Scaffolding and Formwork Plant Financial Model
Description
This model is built for a scaffolding and formwork manufacturing facility, covering everything from raw material intake to finished goods dispatch. It handles multiple product families—ringlock, cuplock, frame scaffolds, wall and slab formwork, props, and accessories—each with its own bill of materials, routing, and production batch parameters.
The production engine schedules work orders across cutting, welding, surface treatment, and assembly work centers, accounting for changeover times, machine availability, and shift calendars. Scrap generation and rework loops are modeled at each process step, with recovery percentages for recyclable metals, reflecting real shop-floor yield losses.
On the commercial side, the model distinguishes direct project sales, distributor channels, and export markets, with tailored payment terms and price lists. An optional rental fleet module lets you evaluate the economics of renting own-produced equipment, including maintenance, depreciation, and utilization rates.
Modeling specifics
- Batch production scheduling with sequence-dependent setup times by product family, avoiding the typical overestimation of plant capacity.
- Scrap and rework loops at cutting, welding, and finishing stages, with metal recovery credits for recyclable scrap to reflect true material cost.
- Multi-level BOM for complex assemblies (e.g., welded frames that then go through surface treatment), ensuring accurate cost accumulation.
- Work center–level capacity modeling (cutting, welding, coating, assembly) with shift patterns, planned downtime, and overtime options.
- Raw material price escalation contracts indexed to steel/aluminum benchmarks, dynamically feeding into COGS and inventory valuation.
- Integrated rental fleet P&L that draws own-produced equipment from manufacturing output, tracking utilization-based depreciation and maintenance.
- Multi-channel revenue module with distinct payment calendars for domestic projects, distributor sales, and export markets, handling multi-currency receivables.
What's included in the base version
- Production scheduling engine with work center load balancing and capacity heatmaps
- Multi-level bill of materials and routing cards for all standard product families
- Raw material procurement, inventory management, and index-based price escalation module
- Manufacturing cost build-up: direct material, direct/indirect labor, variable and fixed overhead
- Capex plan with phased equipment acquisition, installation, and commissioning logic
- Multi-channel revenue model (direct project, distributor, export) with currency differentiation
- Fully integrated monthly financial statements: P&L, balance sheet, cash flow
- Key investment metrics: IRR, NPV, payback period, DSCR, and sensitivity tables
- Scenario manager with predefined optimistic and pessimistic cases and a user-friendly dashboard
Common modeling mistakes
- Assuming 100% utilization without changeover times or breakdowns — overstates annual capacity by 15–25%.
- Ignoring scrap and rework losses — understates material cost per unit by 10–20%.
- Using flat raw material prices without index-linked escalation — undercuts COGS over the project life, inflating margins.
- Omitting working capital buildup for raw material inventory buffers — delays cash flow peaks and overstates early liquidity.
- Treating all products as identical without setup penalties — underestimates lead times and distorts production mix feasibility.
