Case study · Mining and chemicals
$45–80M in NPV improvement within six months of going live
$45–80MNPV improvement
- Mining
- Long-range planning
About
A multi-billion dollar, globally integrated mining and chemicals company with almost two dozen mining sites and processing facilities. It mines three minerals that become around 20 grades of its primary product, plus secondary products.
Ore quality varies, and each mine has its own processing options. Choices at the mine change the cost and output of the chemical plants downstream. Excel couldn't weigh upstream processing, downstream products, shipping and exchange rates together, or show product and customer profitability.
The whole business from mine to customer in one model, with the financials at every step. A monthly model looks 24 months ahead at product and customer profitability. A strategic model looks 30+ years ahead at which mines to open, where to spend capital and which mine feeds which plant.
A 3–5% improvement in net present value, valued at $45–80M, within the first six months. The model also surfaced problems in the existing plan, such as sales price forecasts that caused production swings that made no sense.
- Life sciences
- Sourcing
2%lower COGS
A 2% cut in cost of goods, with analysis in days instead of weeks
Global biopharmaceutical company
Read →- Food and beverage
- Manufacturing
$5Min profit
Up to $5M in profit improvements from two of its five models
Fortune 1000 food and beverage maker
Read →- Logistics
- Network design
5–15%lower transport cost
Two facilities out of the network and 5–15% off transportation
Pitney Bowes
Read →