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."
How do I install this agent skill?
npx skills add https://github.com/gajetoso/financeskills --skill variance-analysisIs this agent skill safe to install?
- Gen Agent Trust Hubpass
The skill is a tool for manufacturing variance analysis. It uses standard accounting formulas implemented in a Python script to calculate differences between planned and actual costs. No security risks were identified.
- Socketpass
No alerts
- Snykpass
Risk: LOW · No issues
What does this agent skill do?
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.
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/gajetoso/financeskills/variance-analysis">View variance-analysis on skillZs</a>