skillZs
★ LIVE SKILL TAGS ★
>>> LIVE SKILLS INDEX <<<
* OPEN SOURCE *
NO LOGIN, NO TRACKING
※ REAL INSTALL DATA ※
← back to all skills
gajetoso/financeskills62 installs

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-analysis
view source ↗

Is 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

  1. 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.
  2. 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

  1. Price Variance: (Standard Price - Actual Price) * Actual Quantity.
  2. Usage Variance: (Standard Quantity - Actual Quantity) * Standard Price.

Labor Variances

  1. Rate Variance: (Standard Rate - Actual Rate) * Actual Hours.
  2. 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.py to self-test; import the functions for actual computations.

References


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.

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>