skills.rest
vctplatform
vctplatformCOMMUNITY
Explore all skills by this author →
GitHub

erp-production-quality

Analyze ERP production KPIs and quality metrics via SQL queries.

Updated Aug 23, 2026
Search Tags:#production#efficiency#quality#manufacturing#cost analysis#ERP#OEE
One-click install
npx skills add https://github.com/vctplatform/vct-erp --skill erp-production-quality
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: erp-production-quality
Source: https://github.com/vctplatform/vct-erp/tree/main/vct-erp/.agents/skills/erp-production-quality
Command: npx skills add https://github.com/vctplatform/vct-erp --skill erp-production-quality

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides comprehensive insights into production efficiency, quality control, and cost management, enabling businesses to identify bottlenecks and improve overall operational performance.

Core Features & Use Cases

  • Production Planning & Execution: Track planned vs. actual production output and adherence to schedules.
  • OEE Monitoring: Analyze Overall Equipment Effectiveness, including availability, performance, and quality, with detailed downtime reasons.
  • Quality Control: Monitor key quality KPIs, perform Pareto analysis on defects, and track cost of quality.
  • Maintenance Management: Track equipment maintenance schedules, MTBF, MTTR, and planned maintenance percentages.
  • Cost Analysis: Analyze Bill of Materials (BOM) costs and compare standard vs. actual production costs.
  • Labor Productivity: Report on output per worker and adherence to targets.
  • Use Case: A factory manager can use this Skill to quickly generate a weekly report on OEE, identify the top reasons for machine downtime, and check the status of planned maintenance for critical equipment.

Quick Start

Generate a monthly report on production output versus planned output and OEE for all machines.

Frequently Asked Questions about erp-production-quality

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate Overall Equipment Effectiveness and analyze downtime reasons in an ERP system?▼

To calculate Overall Equipment Effectiveness (OEE) in an ERP, this Skill queries your database to evaluate machine availability, performance, and quality metrics, while categorizing and presenting detailed downtime reasons for factory analysis.

What is the best way to track planned vs actual production output and schedule adherence?▼

The best way to track planned vs actual production output is by querying ERP production planning data to compare scheduled targets against realized manufacturing execution, generating tabular variance reports for schedule adherence analysis.

Can I perform Pareto analysis on manufacturing defects and track the cost of quality?▼

Yes, you can perform Pareto analysis on manufacturing defects and track the cost of quality by querying ERP quality control records to isolate defect frequencies, categorize failure modes, and calculate associated quality costs for presentation.

How do I compare standard vs actual production costs and analyze BOM costs?▼

You compare standard vs actual production costs by querying ERP costing data to analyze Bill of Materials (BOM) expenses against realized manufacturing expenditures, isolating labor, material, and overhead variances for cost analysis.

Does this approach require SQL queries to report on labor productivity and maintenance metrics like MTBF?▼

Yes, this approach requires SQL queries to retrieve data for labor productivity reporting and to calculate maintenance metrics such as Mean Time Between Failures (MTBF), Mean Time To Repair (MTTR), and planned maintenance percentages.

Related Skills

Explore More Finance & Accounting Skills→
ZiyaoMouZiyaoMou

geely-equipment-anomaly-assistant

Diagnose equipment anomalies and generate maintenance work-order recommendations.

Community
Intermediate
klu-devklu-dev
2

production-scheduling

Manage production scheduling in discrete and batch manufacturing with constraint identification and changeover optimization.

Community
Advanced
bomberoxenviosdosruedasbomberoxenviosdosruedas

agency-supply-chain-strategist

Develop supply chain and procurement strategies with supplier and cost controls.

Community
Advanced
TeiNamTeiNam
12

production-scheduling

Optimize production schedules and resolve bottlenecks in discrete and batch manufacturing.

Community
Advanced