SmartERP Documentation An Ashewa Technology Solutions Platform

Analyze Production Cost Variances

Investigating Material Price Variance, Material Usage Variance, and Labor Efficiency Variance.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Analyze Production Cost Variances within SmartERP.

Swimlane production lifecycle diagram across Planner, Supervisor, Operator, Quality Inspector, and Storekeeper.
SmartERP manufacturing order execution and shop floor lifecycle.

SmartERP Manufacturing Dashboard

Investigating Material Price Variance, Material Usage Variance, and Labor Efficiency Variance.

2. Prerequisites & Security Access Groups#

  • Required Modules: mrp, quality_control, smarterp_manufacturing_costing
  • Security Groups:
    • Manufacturing User (Technical ID: mrp.group_mrp_user)
    • Manufacturing Administrator (Technical ID: mrp.group_mrp_manager)
    • Quality Inspector (Technical ID: quality.group_quality_user)
  • Master Data Dependencies: Bills of Materials (BoM), routing operations, work centers with machine/labor hourly rates, raw material stock, and inspection checkpoints.

3. Step-by-Step Configuration & Execution#

Step 1: Navigating to the Interface#

  1. Log into your SmartERP instance at https://smarterp.et/odoo.
  2. Open the main App Switcher (grid icon in the top-left corner).
  3. Navigate to Operations.

SmartERP Manufacturing Dashboard

Step 2: Operational Data Parameters & Controls#

Ensure all mandatory parameters comply with enterprise operational standards:

  • Authorized Operator: Action executed under assigned RBAC permissions (Authorized Operator).
  • Relational Integrity: Linked to upstream customer, product, inventory lot, or manufacturing order.
  • Statutory & Quality Controls: Verified against Ethiopian commercial and tax regulations or technical engineering specifications.

Step 3: Operational Execution & State Progression#

  • State Progression Gate: Advance record from Draft through Confirmed to Completed / Posted.
  • Integrated System Impact: Automatically updates inventory stock quants, customer receivables, or work-in-progress cost accounting ledgers.
  • Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.

Variance Analysis Formulas#

SmartERP calculates standard cost variances to hold plant supervisors and procurement officers accountable:

1. Material Usage Variance (MUV)#

$$\text{MUV} = (\text{Actual Quantity Consumed} - \text{Standard Quantity Allowed}) \times \text{Standard Unit Cost}$$

  • Favorable (Negative): Plant operators used less material than engineering standards.
  • Unfavorable (Positive): Excess scrap, off-spec trimming, or material leakage occurred.

2. Labor Efficiency Variance (LEV)#

$$\text{LEV} = (\text{Actual Hours Worked} - \text{Standard Hours Allowed}) \times \text{Standard Labor Rate}$$

  • Measures line productivity and operator efficiency against routing benchmarks.

Viewing the Cost Analysis Report#

  1. Open any completed Manufacturing Order.
  2. Click Cost Analysis in the smart button ribbon.
  3. The report presents line-by-line comparisons:
    • Expected component cost vs Realized component cost.
    • Expected operation run-time vs Realized operation run-time.
    • Net variance percentage per unit produced.

4. Advanced Configuration Points#

  • Automated Actions & Scheduled Tasks (Crons):
    • MRP: Recalculate BoM standard costs (mrp.ir_cron_bom_cost_roll): Runs weekly to update standard costing from latest procurement purchase prices
    • Quality: Trigger periodic inspection alerts (quality.ir_cron_inspection_check): Runs daily to flag mandatory quality testing queues
    • Workcenter: Update OEE statistics (mrp.ir_cron_workcenter_oee): Runs hourly to compute Overall Equipment Effectiveness metrics
  • Custom Print Templates & Reports:
    • Production Order Traveler & Pick List
    • Shop Floor Work Order Execution Slip
    • Quality Inspection Certificate & Non-Conformance Report
    • Manufacturing Cost Analysis & Variance Ledger
  • Multi-Company Rules: Record-level security isolation under Company 1 (Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.

5. Comprehensive Troubleshooting Matrix#

Error Symptom / ExceptionProbable Root CauseCorrective Action / Resolution
BoM Missing Error: No active Bill of Materials foundProduct variant lacks a verified and confirmed BoM in the system.Create and confirm an active BoM under Manufacturing → Products → Bills of Materials.
Component Shortage Block: Insufficient stockRaw material components have not been transferred to the shop floor location.Execute an internal transfer from main warehouse to production staging location.
Quality Gate Blocked: Mandatory test failedWork order failed critical quality tolerance threshold.Perform required corrective rework or request authorized Quality Manager override.
Workcenter Capacity OverloadScheduled production duration exceeds available work center shift capacity.Adjust scheduled start dates or distribute load across alternative work centers.
Last updated: 2026-11-15