Project Overview – MillerCoors

About MillerCoors:

Large US-Based Brewing Company
Annual Revenue: $2 Billion
Year Founded: 1873
Headquarters: Golden, CO
ERP: SAP
ImpactECS customer since 2006

Before ImpactECS:

Existing Product Costing Process

SAP in place, but with limited costing capability

• Multiple SAP instances created disparate environments
• Product costing in SAP limited to Packaged SKU’s only (no costing for wort or brew products)
• Specific brew recipes by individual brew line unavailable in SAP
• Only standard costs – no tools or systems to effectively calculate actual cost

Spreadsheet models used as primary tool to calculate product costs

• Unable to fully allocate beer costs to the Packaged SKU level
• Unable to allocate beer loss to the Packaged SKU level
• No visibility into actual cost performance
• No connection between the brew side production and packaged volume

How MillerCoors uses ImpactECS:

Standard Costs

• Calculates detailed brew and packaging costs at the plant, line, and SKU level
• Maintains weighted BOMs and recipes for multiple brew lines
• Calculates wort production based on forecasted packaged volumes

Actual Costs

• Calculates detailed brew and packaging costs at the plant, line, and SKU level
• Maintains weighted BOMs for multiple brew lines
• Allocates actual beer loss at the SKU level
• Manages wort settlement process including variance calculations for materials, PPV, malt and general yield

Scenario Analysis
• Simulate the effects of material price changes and recipe adjustments on brew costs
• Determine production loading based on forecasted volume and mix

 

Ready to see ImpactECS in action?

Get a glimpse of how we help companies
understand their costs and profits