Kwik Patch Private Limited
Gloves Division

Material Cost Variance Dashboard

Data Available:
Period
ToleranceWatch >% · Critical >%
Filters

Material Cost at a Glance

Compare
Each layer splits the one above it. Click any box to open it in Drill-down.

Tolerance Status

Key Insights for Management

Auto-generated from the current selection

    Standard to Actual Cost Bridge

    StandardPriceUsageNot-in-BOM consumedActualBar up = adverse, down = favourable
    Click a bar to open it in Drill-down.

    Standard vs Actual Material Cost by Month

    Standard costActual costLabel above each pair = total variance %
    Click a month to filter the dashboard to it; click it again to release.

    Price, Usage and Not-in-BOM Variance by Month

    Price varianceUsage varianceNot-in-BOM consumedTotal variance
    Above zero = favourable · below zero = adverse. The diamond marks the month's net total.

    Monthly Figures

    Click a month heading to filter it

    Top 10 by Standard Cost: Standard vs Actual

    Analyse by
    StandardActual
    Click a row to filter the dashboard to it; click it again to release.

    Top 10 Adverse Contributors

    Analyse by
    Price partUsage partNot-in-BOM partThe dashed line marks the items making up 80% of adverse variance

    Price, Usage and Not-in-BOM Variance by Category / Section

    Price varianceUsage varianceNot-in-BOM consumed
    Left of zero = adverse · right of zero = favourable · the figure on the right is total variance % of standard. Click a category to filter it; click it again to release.

    Variance per Pair by Job and Style

    Cost per pair = cost ÷ FG pairs of the job, so jobs and styles of different sizes can be compared. Click a row to filter it; click it again to release.

    Variance Heatmap

    RowsColumns Measure
    ◀ Adverse
    −8% or worse−4%0%+4%+8% or better
    Favourable ▶
    Click a cell to filter that combination; click it again to release.

    BOM Exceptions Summary

    Click a card to show only that type

    Exceptions by Material

    Items issued with no BOM quantity are valued at their actual rate (column D); BOM items not issued are valued at standard. “Usage impact” here includes not-in-BOM consumption. Click a row to filter it; click it again to release.

    Exception Details by Job

    Click a row to filter that job; click it again to release.

    Drill-down: Variance Analysis

    Show
    Price variance = (Standard rate − Actual rate) × Actual qty · Usage variance = (Standard qty − Actual qty) × Standard rate · (A) = Adverse, (F) = Favourable. Click ▸ to expand a row, or “Drill ›” to filter the whole dashboard to it. Quantities and costs are totals of the lines below a row; Std Rate and Actual Rate are weighted averages (total cost ÷ total quantity), marked “avg” with the range on hover when the lines carry different rates.

    Action Log

    Use ✎ on any Drill-down row to record an action, owner and status. Saved in this browser.
    Material Cost Variance Dashboard
    Loading data…