Sandwich Panel Plant Financial Model

Description

The model captures the full production cycle of a sandwich panel plant: from raw material intake (steel coils, chemical components for Polyurethane/Polyisocyanurate foam, mineral wool batts) through the continuous or discontinuous laminating line to finished panels cut to customer-specified lengths. Each step is modeled with specific consumption factors per square meter for different core materials and thicknesses, including catalyst and blowing agent ratios for PUR/PIR foam, and adhesive application for mineral wool.

Production capacity is dynamically calculated based on line speed (m/min), panel width and thickness, and shift schedule. The model accounts for changeover times when switching between core types, thicknesses, or metal sheet gauges, and allows modeling of a multi-shift growing ramp-up. Scrap generation from start-up, edge trimming, and off-spec panels is explicitly modeled with recycling returns for metal and foam waste, reducing raw material cost.

The financial structure includes detailed CapEx for production line(s), coil handling, mixing/polyol station, saw, stacker, packaging, and auxiliary equipment, as well as building, land, and infrastructure. Operating expenses are built up from direct costs (raw materials, energy, labor, maintenance, consumables), indirect manufacturing costs, and SG&A. The model separates fixed and variable energy consumption for the line and utilities, reflecting real plant metering setups.

Revenue is modeled by product line — wall panels, roof panels, cold storage panels, and optional customized panels — each with its own price per m² and market share. The model can simulate several sales scenarios (B2B wholesale, direct to projects, export) and automatically calculates capacity constraints and order book lead times. The investment requirement is presented as an order-of-magnitude illustration, not final values, as it depends on plant scale and configuration.

Modeling specifics

• Dynamic material consumption per m2 by core material (PUR/PIR/mineral wool) and thickness, including chemical reaction yields and foam density control.
• Scrap and recycling loop: models edge-trim, startup, and off-spec waste with separate recovery rates for steel and foam, reducing net material cost by 2–5%.
• Line changeover modeling: calculates downtime and lost production when switching between core types or thicknesses, adjusting OEE and shift schedules.
• Multi-core and multi-thickness product mix allows simultaneous production planning of wall, roof, and cold storage panels with distinct technical specs.
• Detailed energy model splits consumption into fixed (idle) and variable (per m2) loads for each process step, reflecting real utility metering.
• CapEx phasing with independent delivery, installation, and commissioning timelines for each equipment group, including retention payments.
• Workforce planning by shift with semi-variable scaling: operators increase in steps as lines run additional hours, incorporating training cycles.
• Multi-channel revenue model: B2B wholesale, direct project sales, and export, with different payment terms and credit periods impacting working capital.

What's included in the base version

• Production capacity and line configuration (continuous/discontinuous, speed, width)
• Raw material calculator for PUR, PIR, mineral wool cores with variable thickness and density
• Comprehensive CapEx schedule with equipment list, building, and infrastructure
• Opex model: direct costs (materials, energy, labor, consumables, maintenance), indirect manufacturing, SG&A
• Revenue model by product segment (wall, roof, cold storage) with pricing per m²
• Integrated income statement, cash flow, balance sheet (monthly)
• Sensitivity tables on key drivers (raw material prices, capacity utilization, forex)
• Executive dashboard with IRR, NPV, payback, and capacity utilization summary

Common modeling mistakes

• Ignoring scrap rates and edge trimming — overestimates material yield by 5–12% and understates raw material cost.
• Using a single average energy rate per m2 instead of splitting fixed and variable load — underestimates energy cost during ramp-up by 8–15%, inflating margins.
• Not modeling changeover downtime between product runs — overestimates effective annual capacity by 10–20% and understates delivery lead times.
• Assuming all core materials have identical density and cost — misprices mineral wool panels (if using PUR densities), overstating their margin by 15–25%.
• Treating revenue as a single blended price per m2 — obscures margin differences between commodity wall panels and high-spec cold storage panels, leading to suboptimal product mix decisions.
• Ignoring safety stock of imported chemicals and coil due to long lead times — underestimates net working capital by 20–30% and can cause liquidity shortfalls.