$2.42M annual margin recovery identified with 1.3-month payback period
$2.42M Annual Margin Recovered with 1.3-Month Payback
Annual Recovery
Total margin recovered through systematic analysis
Implementation
Total investment across all initiatives
Payback (Months)
Rapid return on investment
ROI Multiple
Exceptional return on capital deployed
3-Year NPV
Long-term value creation
Four Hidden Levers Drive $2.42M Recovery
Plant averages masked SKU-level margin leakage. Disaggregation surfaced recoverable levers across four critical dimensions that leadership couldn't see in aggregate reporting.
Hidden PPV
$413K exposure masked by net favorable variances
Scrap & TCOQ
$890K driven by 6 high-scrap SKUs
Energy Inefficiency
$467K excess cost from Line 2 performance
Phantom Margin
$672K from 14 SKUs with negative true contribution
Margin Erosion Persisted Because Variances Were Netted and Averaged
What Leadership Saw
From the executive perspective, everything appeared under control. The standard reporting systems showed acceptable performance across all key metrics, masking the underlying issues that were systematically eroding profitability.
Surface-Level Metrics Looked Acceptable
The Illusion of Control
Leadership relied on aggregate metrics that painted a misleadingly positive picture of plant performance.
Aggregate Variances Within Tolerance
Plant-level variance reports showed acceptable performance when favorable and unfavorable variances cancelled each other out
EBITDA Targets Met Q1-Q2
Plant-level EBITDA targets were achieved, creating false confidence in operational performance
Standard Cost System Showing Green
Traditional standard cost reporting indicated acceptable performance across most categories
What Forensic Analysis Revealed
The Hidden Reality
Deep-dive analysis uncovered systematic margin leakage that aggregate reporting completely obscured.
$2.42M Annual Leakage
Across 4 distinct dimensions
Offsetting Variances
Favorable/unfavorable canceling out
14 Phantom SKUs
Appearing profitable but destroying value
The aggregation trap: averages mask the outliers that drive margin
18-Month EBITDA Decline Revealed Persistent Erosion
Continuous Margin Compression
This chart illustrates the persistent decline in EBITDA percentage over the 18-month period from Q1 2023 to Q2 2024. Despite leadership's perception that targets were being met, the trend shows continuous margin erosion from 15% to just 4%.
The steady quarterly decline highlighted the urgent need for forensic analysis to identify and address the underlying drivers of margin leakage.
Four-Step Diagnostic Uncovered Hidden Margin Leakage
Analysis completed in 6 weeks using existing SAP data, without disrupting operations or requiring new systems.
Disaggregate Variances
Break plant-level aggregates into commodity, SKU, and line-level detail to expose hidden patterns
Calculate True Unit Economics
Rebuild contribution margin using actual cost drivers versus outdated standards
Benchmark Operational Performance
Compare energy, scrap, and efficiency across lines and shifts to identify outliers
Quantify Financial Impact
Size each opportunity and model payback scenarios for prioritized implementation
$2.42M Fully Explained by Four Levers
Complete Reconciliation
Sum of levers: $413K + $890K + $467K + $672K = $2,442K ≈ $2.42M
Annualized impact based on 12-month run rate. Implementation sequenced by payback period to maximize early returns and build momentum.
Hidden PPV
$413K masked exposure
Scrap & TCOQ
$890K quality costs
Energy Inefficiency
$467K excess consumption
Phantom Margin
$672K negative contribution
Commodity Disaggregation Revealed $413K Exposure Masked by Net PPV
Net PPV appeared favorable due to offsetting commodity movements. Favorable and unfavorable variances cancelled out at the aggregate level, masking a true unfavorable exposure of $413K in specialty inputs.
Aggregate vs. Disaggregated View
Root Cause
Standards not updated for 14 months despite supplier price escalations. High-volume commodities masking low-volume unfavorable variances.
The Fix
Quarterly standard cost refresh linked to procurement contracts. Automated PPV alerts when variance exceeds 5% threshold for 2 consecutive months.
6 SKUs Drove $890K TCOQ While Plant Average Scrap Looked Acceptable
While plant-level scrap rates appeared within tolerance, disaggregation revealed six SKUs with scrap rates exceeding 8% driving massive quality costs. The financial impact of scrap far exceeded the percentage rates due to material value and lost throughput.
TCOQ Components and Action Plan
Total Cost of Quality Breakdown
Root Cause Analysis
Deep dive on top 3 SKUs with >8% scrap rates
Implement SPC
Statistical process control on critical parameters
Mandatory Reason Codes
Required for all scrap >$100 per transaction
Line 2 Uses +43% Energy Per Unit, Creating $467K Annual Excess Cost
Line 1 Energy Consumption
2.8 kWh/unit
Baseline performance
Line 2 Energy Consumption
4.0 kWh/unit (+43%)
Significant inefficiency
Annual Excess Cost
$467K
Recoverable opportunity
Calculation: 1.2 kWh/unit × 3.2M units/year × $0.12/kWh = $461K ≈ $467K
Energy Inefficiency Root Causes and Solutions
Implementation Roadmap
Install Submetering
Establish baseline by shift and enable real-time monitoring
VFD Retrofit
Variable frequency drives on 3 largest motors ($85K investment, 8-month payback)
Weekly Energy Review
Establish cadence with operations team to drive accountability
14 SKUs Flip from Positive GM to Negative Contribution, Worth $672K
Standard costing masked true profitability by allocating overhead evenly rather than by actual consumption. When costs were allocated based on actual drivers—changeovers, machine hours, energy, and material touches—14 SKUs revealed negative contribution margins.
Sum: $285K + $220K + $167K = $672K
Why Standards Mislead and How to Fix It
Overhead Misallocation
Allocated by labor hours, not actual drivers like machine time or changeovers
Scrap Allowance Gap
High-scrap SKUs carry standard 2% allowance versus 8%+ actual rates
Changeover Cost Averaging
Costs spread evenly versus actual frequency and complexity
Action Split
Immediate: Reprice 8 SKUs to reflect true costs; discontinue 6 low-volume losers destroying value
Ongoing: Migrate to activity-based costing for overhead allocation to prevent future phantom profitability
Five Actions Recover Margin and Prevent Relapse
Each action has clear ownership and cadence to ensure accountability and sustainability. Controls embedded in monthly governance prevent margin leakage from recurring.
PPV Governance and Scrap Reduction
PPV Governance
Quarterly standard refresh linked to contracts
Owner: Procurement + Finance
Cadence: Monthly PPV review
Lever: $413K
Scrap Reduction
Root cause analysis on top 3 SKUs, SPC implementation
Owner: Operations + Quality
Cadence: Weekly scrap review
Lever: $890K
Energy Optimization and Profitability Reset
Energy Optimization
Submetering, VFD retrofit, baseline monitoring
Owner: Engineering + Operations
Cadence: Weekly energy dashboard
Lever: $467K
Profitability Reset
Reprice 8 SKUs, discontinue 6 losers, migrate to ABC
Owner: Finance + Commercial
Cadence: Quarterly profitability review
Lever: $672K
Controls & Governance Framework
Sustaining Mechanisms
Master data change control, automated alerts, and mandatory reason codes ensure gains stick. Cross-functional ownership prevents siloed decision-making.
Owner: Finance + IT
Cadence: Monthly control testing
Impact: Sustain all levers
Weekly
Ops-Finance review
Monthly
Standard cost review
QuarterLy
Cost roll triggers
Value Locked in Within 6 Months with Controls That Stick
Cumulative impact reaches $2.42M by month 6; governance sustains gains. Cumulative: $180K + $950K + $1,312K = $2,442K ≈ $2.42M by month 6
Implementation Investment Breakdown
Total Investment
Covers all initiatives
Submetering Hardware
IT System Enhancements
Consulting Support
Training & Change Management
Monthly steering committee meetings required with Plant Manager, Controller, Operations Manager, and Quality Manager to track progress and resolve roadblocks.
Controls: Standard cost governance | Master data change control | PPV escalation | Scrap reason codes | Energy baselines/alerts
Appendix: SAP Finance Data Architecture
Data Flow Overview
- Actuals originate: MM (material costs via GR), PP (labor/overhead via confirmations), FI (external costs)
- Variances compute: CO compares actual costs posted to production orders vs. standard costs from material master
- Profitability reports: CO-PA pulls from production order settlements and sales order data
Cost Objects Map
Appendix: Production Order Lifecycle & Variance Taxonomy
Create & Release Order
Planner defines material, quantity, dates; system copies BOM & routing with standard costs.
Goods Issue (GI)
Materials issued to order; inventory credited, order debited at standard price.
Confirm Activities
Labor and machine hours posted; order debited at standard rate.
Goods Receipt (GR)
Finished goods received; inventory debited, order credited at standard cost.
Calculate Variance
System compares actual costs (GI + confirmations) vs standard cost (GR); difference = variance.
Settle Order
Variance posted to P&L or material account; order closed.
Hidden Margin Recovery in Carton Packaging