Aluminum Die Casting Plant Financial Model

Description

The model's core is a part-level production engine built around a fleet of die casting machines with varying tonnages (cold and hot chamber). For each machine you define maximum shot weight, cycle time, uptime, and scrap rates specific to different alloys. Multi-cavity dies are modeled as separate resources, with their own life (shots before rebuild) and maintenance cost. The production schedule allocates parts to machines based on tooling availability and optimal load, while accounting for non-productive time like die changes, furnace cleaning, and preventive maintenance.

Cost modeling digs deep into the metal flow: raw alloy procurement pricing is linked to LME plus alloy-specific spreads, with a scrap buy-back loop from runners, rejected castings, and post-processing trimmings. Melting loss is modeled as a percentage depending on alloy type and furnace efficiency. Tooling costs are split between upfront investments (often customer-funded) and ongoing per-shot maintenance reflected in the part cost. Energy consumption—electricity, natural gas, compressed air—is calculated based on machine cycle times, furnace holding energy, and hydraulic pressure profiles.

Revenue streams include sale of finished cast parts under long-term supply agreements, alloy surcharge pass-through mechanisms, and sales of process scrap metal. The model can handle tiered pricing based on part complexity (e.g., vacuum casting, thin-wall), coating or impregnation surcharges, and separate billing for customer-owned tooling maintenance. This allows clear margin analysis per part number, customer, or alloy.

The investment phase covers land/building acquisition or lease, machine procurement and installation, auxiliary equipment (trimming presses, vibratory finishing, machining centers), and ramping-up working capital (alloy inventory, WIP). The model supports phased CapEx with construction drawdowns and flexible financing structures—senior debt, mezzanine, equity injection—providing a detailed view of capital calls and returns from day one.

Modeling specifics

• Multi-cavity die logic: cavity fill balance and respective reject rates, allowing optimization of cavity count versus cycle time.
• Alloy price model with LME indexation, alloy-specific premium, and automated surcharge billing on customer invoices.
• Closed-loop scrap recycling: returns runners and rejected parts to furnace with melting loss and alloy degradation tracking.
• Tooling life cycle: upfront investment amortized over shot count, separate customer-funded asset tracking, and rebuild reserve calculation.
• Energy metering: kWh and m³ natural gas modeled per machine cycle, per kg melted, and per post-treatment batch with part-specific allocation.
• Post-processing cascade: step-by-step yield losses from deburring, machining, impregnation, and coating, with rework loops.
• Inventory dynamics: raw alloy reorder model based on LME expectations and safety stock, WIP levels tied to machine queues, and finished goods buffer against shipment schedule.
• Machine-level P&L: contribution margin and EBITDA per machine, filterable by part family, enabling decisions on machine retirement or new investment.

What's included in the base version

• Fleet configurator with up to 20 die casting machines and tooling library
• Part recipe builder (alloy, cycle parameters, post-processing route)
• Production schedule and capacity report with utilization heat maps
• Direct labor and overhead allocation model by cost center
• Raw material procurement calculator (LME, alloy premiums, scrap discount)
• Tooling cost amortization and maintenance budget
• Energy consumption model (electricity and gas by equipment)
• Revenue forecast with detail by customer, part number, and scrap
• CapEx phasing and depreciation schedule (straight-line and accelerated)
• Integrated three-statement model (P&L, Balance Sheet, Cash Flow)
• Project evaluation: NPV, IRR, equity IRR, payback period, DSCR
• Sensitivity table for key value drivers (LME, cycle time, utilization)

Common modeling mistakes

• Flat scrap rate without part and cavity differentiation — overestimates contribution margin by 15–25%.
• Ignoring tooling life and per-shot maintenance — understates total tooling cost by 30–50% and masks capital reinvestment spikes.
• Not modeling alloy price pass-through mechanism — exposes project to LME volatility, potentially eroding net margin by 5–10 pp in a rising metal scenario.
• Assuming constant machine utilization without accounting for die changeovers and furnace downtimes — inflates annual output capacity by 10–20%.