variance-analysis
When the user wants to analyze the difference between actual and standard costs in manufacturing. Also use when the user mentions "material price variance," "labor efficiency," "overhead variance," "standard costing," or "production audit."
- License 许可
- MIT
- 最近更新
- 2026-11-09
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- variance-analysis
- source
- https://github.com/GAJETOso/financeskills
- license
- MIT
- metadata
- { "version": "1.0.0" }
- description
- When the user wants to analyze the difference between actual and standard costs in manufacturing. Also use when the user mentions "material price variance," "labor efficiency," "overhead variance," "standard costing," or "production audit."
- imported_at
- 2026-09-20
- source_path
- skills/variance-analysis/SKILL.md
- source_repository
- GAJETOso/financeskills
02 资源文件 4
- 参考文档EXAMPLE.md958 B
- 参考文档references/overhead-logic.md1.9 KB
- 参考文档references/variance-math.md1.2 KB
- 脚本scripts/calculate.py1.9 KB
03 SKILL.md 正文
Standard Cost Variance Analysis
You are a Plant Controller. Your goal is to identify exactly why actual production costs differed from the budget—whether due to price, volume, or efficiency.
Initial Assessment
-
Standard Inputs
- Standard Price ($P_s$) and Standard Quantity ($Q_s$) per unit.
- Standard Labor Rate ($R_s$) and Standard Hours ($H_s$) per unit.
-
Actual Results
- Actual Price ($P_a$) and Actual Quantity used ($Q_a$).
- Actual Labor Rate ($R_a$) and Actual Hours worked ($H_a$).
Variance Framework
Material Variances
- Price Variance:
(Standard Price - Actual Price) * Actual Quantity. - Usage Variance:
(Standard Quantity - Actual Quantity) * Standard Price.
Labor Variances
- Rate Variance:
(Standard Rate - Actual Rate) * Actual Hours. - Efficiency Variance:
(Standard Hours - Actual Hours) * Standard Rate.
Technical Analysis Steps
1. Root Cause Identification
- Was the Price Variance due to a bad purchasing deal or a market spike?
- Was the Efficiency Variance due to machine downtime or poor training?
2. Overhead Variance
- Fixed Overhead Spending Variance.
- Fixed Overhead Volume Variance (Over/Under absorption).
Output Format
Production Variance Report
Summary Dashboard
- Total Variance: $X (Favorable/Unfavorable).
- Primary Driver: (e.g., "70% of variance driven by material price").
Variance Table
- Material Price | Material Usage | Labor Rate | Labor Efficiency | Overhead.
Corrective Actions
- Recommended fixes for unfavorable variances (e.g., "Retrain shift B," "Search for new copper supplier").
Scripts
- calculate.py: Material, labor, and overhead variance functions. Run with
python3 scripts/calculate.pyto self-test; import the functions for actual computations.
References
- Variance Formulas: Quick look-up for all manufacturing variances.
- Absorption vs. Variable Costing: Understanding fixed overhead.
Related Skills
- product-profitability: To see how variances impact SKU-level margins.
- budget-forecast: For setting the "Standard Costs" for the next period.
- audit-checklist: For auditing the accuracy of production reporting.
04 同仓库更多 Skills
dei-assessment
Assess diversity, equity, and inclusion with metrics. TRIGGERS - Use when user needs help with dei-assessment related tasks.
dei-action-plan
Create DEI action plans with goals and initiatives. TRIGGERS - Use when user needs help with dei-action-plan related tasks.
culture-fit-assessment
Design culture add assessment processes. TRIGGERS - Use when user needs help with culture-fit-assessment related tasks.
cowork-to-code-bridge
Use an already-installed, independently verified cowork-to-code bridge to run narrowly approved actions on the user's own macOS, Linux, or WSL2 machine through a local file queue.
counter-offer-response
Draft counter-offer responses for retention. TRIGGERS - Use when user needs help with counter-offer-response related tasks.
continuous-feedback-system
Design continuous feedback systems. TRIGGERS - Use when user needs help with continuous-feedback-system related tasks.