From BOM to real cost: managing production in small factories

Managing a small factory or manufacturing workshop starts with an intense focus on building quality products and satisfying customers. The team procures raw components, sets up production sequences, and works hard to meet promised delivery schedules. As sales volume expands and customer specifications vary, tracking details manually begins to drain valuable supervisory time.

In the early days, spreadsheets seem adequate for calculating component quantities and quoting prices. Soon, however, tough financial questions surface on the shop floor: did a specific batch generate a profit once labor hours and scrap were counted, what raw inventory remains in the warehouse, and why did the finished product cost more than anticipated? At that point, disconnected sheets can no longer keep pace with manufacturing reality.

Why spreadsheets break at the first product change

Spreadsheets rely on static assumptions and constant manual coordination among staff, an approach that falls apart quickly on an active shop floor. The moment a supplier substitutes an ingredient or a machining step changes, outdated worksheets circulate, leading to direct errors in production and margin erosion.

• No version control for bills of materials: When a product design changes or a component dimension is modified, operators often continue building from an older sheet saved on another computer. This discrepancy causes incorrect material consumption and off-spec finished goods that fail inspection.
• Delayed scrap and consumption reporting: Material waste and scrap are rarely recorded in spreadsheets the moment they happen at a work center. Management discovers shortages only when a rush job begins, forcing machine downtime and emergency purchasing.
• Inaccurate tracking of labor hours: Worksheets generally rely on standard labor estimates or rough averages rather than measured time. If an assembly step takes two extra hours due to tooling adjustments, that real expense never reflects in product costing.
• Disconnection from inventory and accounting: Production data remains isolated from raw material warehouses, finished goods stores, and the general ledger. The finance team must retype production numbers by hand, causing delayed reports and recurring transcription errors.

Relying on manual tools forces production managers to operate on guesswork. This lack of visibility makes it difficult to price finished goods accurately or protect operational margins.

From BOM to real cost in five steps

Transitioning from scattered records to operational discipline requires a structured workflow that links product engineering directly to warehouse issues and daily shop-floor tasks. This process flows through five essential steps:

1. Build the multi-level BOM and operational routings: The foundation begins by listing all raw materials, sub-assemblies, expected scrap percentages, and by-products. This step also defines the routings and work centres each item passes through, along with standard setup and run times.
2. Verify material availability and reserve inventory: Before releasing orders to the shop floor, the system checks stock balances across warehouses to ensure raw parts are on hand. Reserving items in advance prevents other orders from claiming them, while shortage alerts trigger immediate purchases before machines sit idle.
3. Issue work orders to shop-floor screens: Production orders turn into sequenced work orders assigned to designated work centres. Operators review technical instructions on tablets, start and stop timers for each operation, and record actual scrap as it occurs.
4. Enforce quality control checks and lot tracking: Consistent quality demands clear inspection checkpoints upon receipt of raw materials, during intermediate operations, and before final storage. Recording lot numbers and pass/fail measurements ensures complete traceability across the product lifecycle.
5. Roll up actual batch costs against planned targets: Once manufacturing concludes, the system tallies consumed raw materials, operator hours, machine run time, and any outside processing fees into a definitive batch cost. Management can then compare actual expenses against the initial estimate to detect margin variances.

Tip: Balancing work orders against work centre capacity prevents severe shop-floor bottlenecks. Planning production around what you can actually deliver keeps orders moving smoothly without overloading key machines.

How MG Factory helps

MG Factory is built specifically for growing workshops and manufacturing plants that need total control over production orders, inventory, and product margins through connected tools:

• Multi-level BOM: Manage complex finished goods, sub-assemblies, and by-products with scrap percentages and operation routings, giving you an exact view of required components before production starts.
• Work centre tablets: Operators start, pause, and finish work orders on a tablet at each work centre, viewing digital instructions and recording scrap right where the physical work happens.
• Batch costing: Calculate planned against actual cost for every production order, rolling up materials, labor, and machine time into the real cost of each completed batch.
• Multi-warehouse inventory: Track raw materials and finished goods across multiple locations with lot tracking, barcode scanning, and automatic min/max reordering to avoid stockouts.
• Quality control: Define pass/fail inspection points, log measurements, and attach photos to lots upon raw material receipt, during assembly, and before final dispatch.

Because MG Factory shares a single platform with financial accounting, all production records flow naturally into your general ledger. Material purchases, work-order expenses, and inventory adjustments update your accounts automatically without manual retyping.

Replacing disconnected spreadsheets with an integrated manufacturing system gives your management team reliable operational data and clear product margins. Schedule a free 45-minute walkthrough prepared around your specific products, materials, and production routings.