Pacific Northwest Carton Converting [FICTIONAL]
Margin Recovery Opportunity
$2.23M in Annual Margin Hiding in Variances
$2.23M annual margin identified through FY 2025 variance analysis. Four levers: standard cost refresh, scrap reduction, line efficiency, SKU rationalization.
FY 2025 simulated
2026 Implementation Plan
The Problem
FY 2025 closed on EBITDA target. Manufacturing variances netted to ~0. But dispersion by commodity and SKU was large—favorable PPV on one input masked unfavorable on another. Standards hadn't been refreshed in 14 months. Nine SKUs ran 6–13% scrap. Line 2 ran 18% below Line 1 on energy per unit. Result: $2.23M annual margin leak.
Company at a Glance
Mid-market converter. CPG, food, e-commerce customers. 200+ SKUs drive complexity and margin pressure.
Business Model
- Product mix: corrugated and folding carton across 200+ SKUs
- Production: Two flexo lines, 24/5 operation
- Target: 18–22% gross margin
Cost Structure Reality
- Material dominance: Paperboard, inks, coatings represent 65-70% of variable cost
- Hidden drivers: Changeover frequency, scrap rates, line uptime create dispersion labor-hour allocation masks
- Operational constraint: Line availability and changeover discipline—not direct labor—shape true unit economics
What Leadership Watches
Plant-level EBITDA, aggregate variance to standard, and average scrap rates provide directional guidance but hide SKU-level and line-level dispersion where margin actually leaks.
How the Plant Makes Money
Margin depends on execution: material yield, line speed, absorption, and mix.
Plant Economics / EBITDA Drivers
- Revenue: Volume, Mix, Price realization, CO-PA Margin
- Costs: PPV, Scrap Rate, Yield, Downtime, Absorption Variance
Revenue
Volume, Mix, Price realization, CO-PA Margin
Costs
PPV, Scrap Rate, Yield, Downtime, Absorption Variance
What Leadership Watches
- Traditional metrics: EBITDA %, net manufacturing variance, plant-average scrap rate
The gap: These aggregate views mask SKU-level dispersion and line-level inefficiency where recoverable margin hides.
Why Margin Leaks Stay Invisible
The Aggregation Trap
Variances Net Out
INK-BASIC-4COLOR runs 5.0% favorable to standard — $4.3M in savings that subsidizes the total commodity PPV. That favorable offset hides the fact that INK-SPECIALTY is 25.2% over standard and COATING-STD is 22.0% over standard. At the aggregate level, leadership sees net material inflation. At the commodity level, they'd see two specialty inputs drifting unchecked while one basic commodity quietly absorbs the damage. $849K in standard cost drift sits inside that net number.
Plant Averages Hide Outliers
Plant-average scrap is 5.0%. It's been 5.0% plus or minus 0.2% for twelve consecutive months. That consistency isn't good news — it means the scrap is structural, not random. Under the average, nine HIGH-complexity SKUs run 6-13% scrap while LOW-complexity SKUs run 2-3%. The HIGH-complexity group alone generates $4.48M in total cost of quality that disappears into the plant-level number.
Allocation Logic Misleads
Labor-hour costing assigns overhead by production volume. That systematically undercharges low-volume, high-complexity SKUs that consume disproportionate setup, changeover, and quality resources. Nine SKUs show positive standard gross margin (12.8-14.0%) but carry negative true contribution margin under activity-based analysis. Total phantom margin: $4.48M across products the P&L says are profitable.
Executive Summary
FY 2025 variance analysis reveals $2.23M annual margin leakage across four operational levers: outdated standard costs concealing $849K in specialty input PPV, nine high-complexity SKUs driving $614K in excess scrap, Line 2 efficiency gap causing $354K in energy and throughput costs, and labor-based allocation masking $417K in negative contribution margin across nine SKUs.
Situation
Plant variances netted to near-zero, and EBITDA hit target. But the aggregate numbers hide $2.23M in real problems across four levers.
Standard Cost Refresh
Outdated standard costs, frozen for 14 months, allowed favorable basic commodities to mask unfavorable specialty inputs. Quarterly refresh and PPV governance recovers $849K.
Scrap Reduction
Nine HIGH-complexity SKUs running 6-13% scrap generate $4.48M in total cost of quality. Targeted process improvements recovers $614K in Year 1.
Energy Optimization
Line 2 consumes 43% more energy per unit than Line 1 — a diagnostic signal of underlying equipment and maintenance problems. Addressing root causes recovers $354K through combined energy, throughput, and maintenance benefits.
SKU Rationalization
Labor-based allocation masks $4.48M in negative contribution margin from nine "phantom-profit" SKUs consuming 4x their attributed resources. Repricing or discontinuation recovers $417K.
$2.23M
Annual Recovery
Total margin opportunity identified through detailed variance analysis
$263K
Implementation
Front-loaded investment in consulting, IT enhancements, and hardware
2 MONTH
Modeled Payback
Modeled net cash positive by month 2; plan targets full run-rate by month 6.
8.5x
Return on Investment
Base case assumes program targets achieved; downside case at 4.8x.
$5.3M
3-Year NPV
Net present value calculated at 10% WACC with sustained governance
10.8%
Breakeven Realization
Program breaks even if only 10.8% of identified savings materialize — a low-risk decision, not a heroic bet
THE ASK: Approve a 90-day plan and $263K budget to capture $2.23M annually. Net positive by month 2.
Methodology
Data foundation: 2,500 production orders | 11,230 material movements | 121 purchase orders | 731 daily energy readings | 24 SKUs across two production lines
1
Disaggregate Variances
Break aggregates into commodity, SKU, and production line detail using SAP transaction-level data
2
Calculate Accurate Unit Economics
Derive contribution margin using actual cost drivers versus frozen standard costs
3
Benchmark Operational Performance
Compare energy consumption, scrap rates, and efficiency across production lines and shifts
4
Quantify Financial Impact
Size opportunities and model payback scenarios with conservative realization assumptions
Data Lineage & Anti-Double-Counting
Methodology Transparency
Each dollar identified in the $2.23M recovery is classified into exactly one category, with explicit rules preventing overlap between levers. This rigorous classification framework ensures leadership can approve individual initiatives without risk of double-counting savings or creating unrealistic implementation targets.
The anti-double-counting logic leverages the natural segregation of SAP modules and cost object hierarchies. Purchase price variance (PPV) captures valuation differences at goods receipt in MM. Scrap and usage variances in PP calculate quantity deviations multiplied by standard costs already established. Energy analysis uses metered consumption data from plant floor systems. SKU profitability in CO-PA captures only the allocation methodology differencen and not the underlying cost components classified elsewhere.
SAP Modules Used
Anti-Double-Counting Logic
PPV captures price variance at goods receipt: Difference between PO price and standard cost, recorded at the moment materials enter inventory
Scrap/TCOQ captures quantity × standard cost: Physical quantity deviations valued at existing standards, with multiplier for downstream impacts
Energy captures metered kWh × rate: Physical consumption measured by production line submeters, independent of standard cost calculations
SKU CM captures allocation difference only: Overhead reassignment using ABC methodology, excluding material and direct labor already classified
Four Levers Overview
$2.23M Annual Recovery by Lever (Adds to Total)
Top two levers (Standard Cost + Scrap) drive $1.46M — 65% of total recovery. These are actionable in the first 90 days with existing data and established process improvement methods. Energy and SKU levers require cross-functional coordination but address structural cost issues that compound over time.
MOCKUP 1: ME2M — PPV Commodity Analysis
"SAP ME2M: Commodity-level PPV reveals $38.6M in addressable unfavorable variance masked by $4.3M favorable offset from INK-BASIC-4COLOR."
Transaction: ME2M (Purchase Orders by Material)
Transaction: ME2M (Purchase Orders by Material)
Lever 1 — Standard Cost Refresh
$849K Recovery Through Proactive PPV Governance
When standard costs sit frozen for 14 months, material price variances accumulate invisibly. In this analysis, aggregate PPV appeared manageable because one high-volume commodity — INK-BASIC-4COLOR — ran 5.0% favorable to standard, generating $4.3M in savings that offset specialty input inflation at the total level. That favorable variance made the net number look tolerable while two specialty inputs drifted well past actionable thresholds.
INK-SPECIALTY shows the most severe drift: actual purchase prices averaging $5,260 per unit against a standard of $4,200, a 25.2% unfavorable variance worth $30.0M in absolute PPV across 28,312 units. This specialty input is critical for low-volume, high-margin SKUs where premium print quality is required. The outdated standard created misleading signals about product profitability because the true input cost escalation was invisible in the frozen standard.
Key Material Price Variances by Commodity
COATING-STD shows a similar pattern at 22.0% unfavorable ($8.4M PPV across 12,271 units). Supply chain pressures pushed procurement to spot markets at premium rates, but those higher costs never reached the standard cost or customer pricing models.
Meanwhile, INK-BASIC-4COLOR ran -5.0% favorable — -$4.3M across 36,177 units from favorable commodity pricing. At the aggregate level, this favorable offset partially masked the specialty inflation. The net PPV across all five commodity groups totals $34.2M unfavorable on a $248.7M standard base (13.8%), but without the commodity-level breakout, the INK-SPECIALTY and COATING-STD problems are invisible.
The $849K recovery represents a 2.2% capture rate on $38.6M in addressable unfavorable PPV — achievable through quarterly standard updates that prevent multi-month drift from accumulating.
The Fix
01
Establish a quarterly standard cost refresh cadence embedded in the financial close calendar with explicit ownership and approval gates
02
Implement automated PPV alerts triggering when material price variance exceeds 5% for two consecutive months, routing to procurement and finance for review
03
Introduce a purchase price gate blocking PO creation when requested price exceeds standard by more than 10% without managerial override
MOCKUP 2: COOIS — Scrap by SKU
"SAP COOIS: Nine HIGH-complexity SKUs running 6-13% scrap generate $4.48M in TCOQ. Plant average of 5.0% has been stable for 12 months — confirming structural, not random, causes."
Transaction: COOIS (Production Order Information System)
Lever 2 — Scrap Reduction
$614K Recovery Through Targeted Process Improvements
Plant-average scrap is 5.0%. That number has held between 4.8% and 5.2% for twelve consecutive months — stable enough to confirm this is a structural pattern, not random variation. The problem isn't the average. It's the dispersion underneath it.
Nine HIGH-complexity SKUs run scrap rates of 6-13%, far above the plant norm. These products involve tight print registration, specialty substrates prone to cracking, and precise die-cutting tolerances. Together they generate $4.48M in total cost of quality (TCOQ) — direct scrap cost multiplied by 2.4x to capture throughput loss, rework, re-runs, and quality overhead.
The $614K Year-1 recovery applies a 12% reduction target across the nine HIGH-complexity SKUs and 5% across MEDIUM-complexity, based on achievable process control improvements in setup, changeover, and operator technique.
One analytical nuance worth noting: SKU-4801 has the highest scrap rate (13.2%) but ranks sixth in TCOQ dollars ($377K) because of its modest production volume. SKU-4421, at a lower 10.0% scrap rate, generates $1.13M in TCOQ — the largest financial impact — because it runs at 3x the volume. Implementation should prioritize by dollar impact, not rate.
Top 9 HIGH-Complexity SKUs by Scrap Rate and TCOQ
TCOQ Multiplier: 2.4x
Direct material cost (1.0x) + Throughput loss (0.6x) + Rework and re-runs (0.4x) + Quality overhead (0.4x) = 2.4x total impact per dollar of direct scrap
01
Implement a targeted process control plan for identified high-scrap SKUs, focusing on critical production stages like print registration and die-cutting.
02
Optimize setup and changeover procedures to reduce variability and scrap during production transitions for complex SKUs.
03
Conduct operator training and skill enhancement specifically for handling premium substrates and operating machinery used for high-complexity products.
04
Establish a cross-functional team (operations, engineering, quality) to monitor progress and adjust improvement initiatives quarterly, ensuring sustained scrap reduction.
MOCKUP 3: ZKCR — Cost Center Analysis
"SAP ZKCR: Line 2 shows 43% energy premium (3.06 vs 2.14 kWh/1,000 units) and $192K unfavorable cost center variance. The energy gap is a diagnostic signal of equipment degradation and deferred maintenance."
Transaction: ZKCR (Custom Cost Center Report)
Lever 3 — Line 2 Efficiency Recovery
$354K Recovery Through Addressing Root Causes on Line 2
Line 2 consumes 3.06 kWh per 1,000 units compared to Line 1's baseline of 2.14 kWh—a 43% energy premium. While the direct utility cost difference is a modest $25K annually, this significant energy gap serves as a crucial diagnostic signal of underlying equipment degradation and operational inefficiencies. The true value of addressing this disparity lies not just in energy savings, but in the broader operational improvements it unlocks.
Cost center actuals confirm the deeper issue: Line 2 posted a $192K unfavorable variance to budget, whereas Line 1 came in just $20K favorable, and all other cost centers were within $5K of plan. This indicates fundamental problems specific to Line 2.
The projected $354K recovery reflects the full operational improvement opportunity from addressing Line 2's root causes. This comprehensive recovery includes substantial throughput gains from reduced downtime, significant maintenance cost avoidance by restoring equipment to designed operating parameters, and the direct (albeit smaller) energy reduction. The cost center variance alone ($192K unfavorable) accounts for over half the recovery target, even before considering the impact of improved throughput.
This efficiency gap is evident despite nearly identical annual production volumes of approximately 336 million units on each line, confirming that the disparity is due to controllable factors rather than product mix or utilization.
The energy differential also strongly correlates with Line 2's 11.5% downtime rate versus Line 1's 6.5%. This 76% higher downtime creates a compounding effect: equipment cycling through start-stop sequences consumes peak energy during ramp-up periods, motors and drives operate outside optimal efficiency curves during partial-load conditions, and climate control systems must compensate for production interruptions. Each unplanned stop significantly impacts energy consumption patterns.
Root cause analysis identified three primary drivers: deferred preventive maintenance on major motor assemblies, lack of variable frequency drives (VFDs) on legacy equipment limiting speed modulation capability, and calibration drift in process control systems causing equipment to operate outside designed efficiency ranges. Each driver is addressable through targeted capital investment and procedural improvements with measurable energy reduction potential, leading to the full $354K recovery.
2.14
Line 1 Baseline
kWh per 1,000 units
3.06
Line 2 Current
kWh per 1000 units
+43% premium
Line Comparison Metrics
$354K Recovery Breakdown
The Fix
01
Install variable frequency drives on Line 2 major motor assemblies to enable speed modulation and eliminate the fixed-speed inefficiency during partial-load operation.
02
Restore the preventive maintenance cadence on Line 2. The downtime correlation suggests mechanical degradation is the primary energy driver.
03
Recalibrate process control systems on Line 2, addressing the drift that forces equipment to run outside designed efficiency ranges.
04
Install permanent energy submetering on Line 2 by equipment zone (corrugator, printer-slotter, folder-gluer, ancillary) to enable ongoing monitoring and create shift-level accountability.
MOCKUP 4: KE30 — CO-PA Profitability Analysis
"SAP KE30 CO-PA: All 9 phantom SKUs show positive standard gross margin (green) but negative true contribution margin (red) under ABC analysis. The ERP is directionally wrong on 37.5% of the portfolio."
Transaction: KE30 (CO-PA Profitability Analysis)
Lever 4 — SKU Rationalization
$417K Recovery Through Repricing/Discontinuation Efforts
Activity-based costing reveals nine SKUs that appear profitable under standard gross margin but carry negative true contribution margin when overhead is allocated by actual resource consumption. These "phantom-profit" products, as shown in the adjacent chart, collectively drain $4.48M from annual profitability. Strategic repricing or discontinuation of these items is projected to yield an immediate $417K recovery, representing a 9.3% capture rate.
The discrepancy stems from traditional labor-hour-based overhead allocation, which systematically undercharges low-volume, high-complexity SKUs. These products consume disproportionate resources due to frequent setup burden (changeovers), elevated scrap rates requiring rework and inspection, and preferential assignment to Line 2, which carries a 43% energy premium (as identified in Lever 3). ABC analysis demonstrates that these nine SKUs consume four times the resources attributed to them under labor-based methods.
SKU-4421 exemplifies this pattern: At 14.0% standard gross margin, it looks like a solid mid-tier product. But $4.90M in annual revenue masks a true contribution margin of -9.1%, creating a $1.13M gap — the single biggest phantom margin hit in the portfolio. This product requires complex die-cutting sequences and tight print registration across six colors, often running on Line 2 where energy costs and downtime rates are significantly higher. None of these resource consumption factors are adequately captured by labor-based allocation.
SKU-4801, for instance, shows a 13.6% gross margin under standard costing. However, under ABC, its true contribution margin is -18.1%, representing a 31.6 percentage point swing.
SKU Code Reference
The analysis uses internal SKU codes. Customer-facing product names are shown for reference:
Remaining 3 phantom SKUs follow similar naming conventions.
This helps readers connect the internal codes to actual product lines.
Phantom Profit SKUs: Detailed Financials
Standard Costing: The Illusion
Labor-hour-based allocation: Fails to capture true resource consumption, leading to undercharging of complex, low-volume SKUs.
ABC Analysis: The Reality
Activity-Based Costing (ABC) reveals: These SKUs consume 4x actual resources due to high setup burden (changeovers), elevated scrap rates, and allocation to Line 2's energy premium. This justifies targeted repricing or potential discontinuation.
Implementation Roadmap
Value Targeted Within 6 Months
Net cash positive is projected by month 2, with a full run-rate of $2.23M annual savings targeted by month 6. This phased approach will prioritize quick wins upfront, such as standard cost refreshes, scrap reduction projects on high-impact SKUs, and Line 2 behavioral changes. Simultaneously, it will build organizational capability for more complex initiatives, including ABC implementation and comprehensive energy management.
Months 0-1 will focus on planning and baseline establishment. This phase will include integrating standard cost refresh procedures into the financial close calendar with clear ownership and approval workflows. Scrap measurement systems will be deployed to capture SKU-level data with root cause coding. Energy submetering will be installed on Line 2 to establish consumption baselines by equipment zone. Automated variance alerts will be configured in SAP with thresholds and routing logic. This planning phase is projected to generate $35K in immediate savings from pricing corrections (enabled by updated standards) while incurring $180K in consulting and setup costs.
Months 1-3 will represent the core implementation phase, requiring intensive resources and addressing change management challenges. Top-3 scrap projects will launch with dedicated cross-functional teams, targeting SKU-4801, SKU-4512, and SKU-4518. Customer repricing negotiations will be initiated for phantom-profit SKUs, supported by ABC data demonstrating true cost structures. VFD procurement and installation will begin on Line 2 major motor assemblies. This phase is projected to drive $950K in cumulative savings while incurring $83K additional costs for IT enhancements and training programs.
1
Planning (Months 0-1)
~$180K cost | $35K projected savings
Baseline measurement, alerts setup, standard cost refresh procedures to be embedded.
2
Implementation (Months 1-3)
~$83K cost | $950K cumulative projected savings
Scrap projects will launch, repricing negotiations will begin, VFD installation will start.
3
Optimization (Months 3-6)
$0 cost | $2.23M annual run-rate targeted
ABC pilot to complete, SPC rollout to occur, governance procedures to be operational.
4
Ongoing (Months 6+)
Sustained performance
Monthly reviews, continuous improvement, standard cost governance to be embedded.
Monthly Cash Flow Analysis
Months 3-6 will transition to optimization with minimal incremental investment. The ABC pilot will complete on top 20 SKUs (representing 80% of production volume), validating the methodology and building organizational capability for full-scale rollout in Year 2. Statistical process control (SPC) will be deployed on the three targeted scrap reduction projects, institutionalizing gains and creating a template for broader quality improvement initiatives. Governance procedures will become operational with monthly variance review meetings, quarterly standard cost updates, and automated exception reporting. By month 6, the full $2.23M annual run-rate is projected to be achieved and embedded in operational processes.
Implementation Investment
$263K Total Investment
The program's total cost of $263K is front-loaded in months 0-2, designed to minimize ongoing operational costs while building sustainable capability for margin improvement. This investment achieves full payback within 2 months of go-live, with a projected 8.5x ROI (base case) and 4.8x ROI (downside case) based on targeted annual savings.
Largest allocations go to consulting support (36%) for specialized expertise in variance analysis, ABC costing, and project facilitation, alongside IT system enhancements (31%) for automated controls and reporting. Submetering hardware (17%) provides granular energy data for optimization, and training & change management (16%) ensures successful adoption of new processes.
Investment Allocation Breakdown
Risk Mitigation & Downside Planning
$1.26M Annual Savings at 56% Realization (Conservative Case)
Margin of Safety: Implementation breaks even at 10.8% realization. The downside case assumes 56% realization — more than 5x the breakeven threshold. This is a low-risk decision, not a heroic bet.
The downside case projects $1.26M with 50-60% realization across all four levers. Even at these assumptions, the program achieves full payback within 3 months and delivers 4.8x ROI. This scenario accounts for potential implementation challenges such as slower adoption of new governance procedures, extended VFD installation timelines, and customer resistance to repricing efforts.
Standard Cost Refresh: Achieves 50% realization ($425K) by prioritizing quarterly updates for the most volatile commodities (e.g., specialty inks, coatings). This approach defers full implementation of automated alerts and purchase price gates to Year 2, focusing on preventing significant PPV drift and building organizational readiness for comprehensive governance.
Scrap Reduction: Realizes 60% of potential savings ($368K) by concentrating efforts on the top-3 SKUs and implementing only the highest-impact process improvements. This phased rollout acknowledges the potential for one of the three targeted projects to underperform and plans for broader SPC rollout to additional SKUs in Year 2.
Energy Optimization: Captures 60% of potential ($212K) through immediate behavioral changes and preventive maintenance. This accounts for potential delays in VFD procurement and installation, assuming lead times could extend to 6 months. Initial gains (15-20%) are targeted from optimizing production scheduling, eliminating unnecessary equipment idling, and restoring calibration on existing systems.
The detailed breakdown of how each initiative contributes to the overall downside scenario is provided in the table below, ensuring clarity and transparency in our conservative projections.
Key Risks & Mitigation Strategies
Master Data Integrity
Risk: Standard costs and BOMs can become inaccurate without rigorous maintenance.
Mitigation: Implement monthly BOM/routing audits automated via SAP workflows, generating exception-based alerts for review.
VFD Procurement & Installation Delays
Risk: Equipment acquisition and installation timelines may exceed the 3-month target.
Mitigation: Prioritize immediate 15-20% energy gains through behavioral changes and preventative maintenance, providing value during potential delays.
Operational Adoption Resistance
Risk: Production teams may resist new scrap tracking and reporting requirements.
Mitigation: Finance will own customer repricing efforts, while Operations leads process improvement initiatives with dedicated resources and clear accountability.
Quarterly Refresh Governance Lapses
Risk: Consistent execution of quarterly standard cost refresh procedures may falter.
Mitigation: Integrate refresh activities into the financial close calendar, supported by trigger-based updates and executive reporting for accountability.
ABC Costing Implementation Complexity
Risk: Full ABC implementation may prove too complex for the organization to sustain initially.
Mitigation: Pilot ABC methodology on the top 20 SKUs (80% volume) in Year 1, with a phased rollout contingent on successful pilot validation and demonstrated ROI.
Key Analytical Challenges
Addressing margin leaks required deep dives into complex data sets and novel analytical approaches to uncover hidden inefficiencies.
Activity-Based Costing
Uncovering hidden negative margins on nine SKUs was challenging. I developed Activity-Based Costing (ABC) from SAP transaction data, pinpointing how setup burden, changeover costs, and line complexity were uncaptured in standard reporting, leading to misallocated labor-hours.
Purchase Price Variance
The Purchase Price Variance (PPV) analysis required meticulous reconciliation. I compared 14 months of frozen standards against actual purchase prices across over 40 diverse commodity codes, revealing significant variances that impacted overall profitability.
Behind the Scenes: Data Simulation Method
How the dataset was constructed to demonstrate margin recovery methodology
Design Principles
The dataset was designed to be realistic, anchored to industry benchmarks; traceable, with every output deriving from a small set of core inputs; and auditable, ensuring all totals reconcile.
Dataset Construction
The model simulates common ERP-style data structures found in manufacturing environments. This includes master data (material masters, BOMs, routings), transactional data (production orders, goods movements, confirmations), injected variance patterns (commodity PPV, SKU-level scrap dispersion, line-level efficiency gaps), and feasibility adjustments based on standard program planning and conservative realization rates.
Reconciliation & Guardrails
Robust checks ensure mathematical integrity, with the four levers summing precisely to $2.23M, anti-double-counting rules, and consistent ROI calculations across base and downside cases. Unit consistency (e.g., kWh per 1,000 units, percentage scrap) and clear naming conventions (SKUs by product code, Line 1/Line 2 references) were maintained throughout the dataset.
Technical Notes
SAP Data Sources: Analysis uses standard MM (material master, PPV), PP (production orders, confirmations), CO (cost center actuals), and CO-PA (profitability analysis) extracts. No custom development required.
Anti-Double-Counting: Each lever addresses a distinct variance bucket—Lever 1 (material PPV), Lever 2 (scrap TCOQ), Lever 3 (Line 2 energy only), Lever 4 (ABC-based phantom margin). No overlap.
Reconciliation: Four levers sum to $2.23M. Downside case applies 50-60% realization per lever based on implementation scope constraints, yielding $1.26M (56% overall).
Naming Conventions: SKUs referenced by product code (RSC-2418, SBS-1612, etc.). Energy measured in kWh per 1,000 units. Scrap as % of input material.
Evidence Trail: SAP Table References
Every dollar traces to standard SAP tables — this methodology is portable and auditable
All analysis uses standard SAP tables available in any ECC or S/4HANA environment. No custom development required.
Decision Point
$2.23M Margin Recovery
2 month Payback
Approve to Proceed
Every figure traces to SAP transactions with conservative realization assumptions. The $263K investment delivers 8.5x ROI in the base case and 4.8x in the downside scenario, with embedded controls preventing future margin erosion.