Costing in eight spreadsheets, and goods could leave before they were paid for.
A 30–40 person nutraceutical and cosmetics contract manufacturer ran costing, production and stock on Excel and spoken instructions. We visited, mapped the work and designed one connected flow from inquiry to payment.
Excel was the only system, and the owner was the only live view.
The owner wanted control over production tracking, client management, raw materials and quality checks. The business makes products for other brands, under its own label and for online sale, with quantity-slab pricing and commissions on distributor orders.
- 1Inquiries, quotations, samples and follow-ups had no record, so lost deals had no reason.
- 2Production was coordinated by voice, with no work orders or batch-level tracking.
- 3Raw material was not tracked by batch or expiry, and purchase began when something ran short.
- 4Dispatch was not linked to payment, and money owed was chased by hand.
Five findings. These four mattered most.
Costing in sheets that break easily
Each product was costed in its own hand-built sheet, with a flat profit line, in a business with quantity slabs and commissions.
Production ran by voice
No work orders, batch tracking or stage status. Only the owner knew what was happening on the floor right now.
No batch or expiry tracking
Raw material was not tracked by batch, container or expiry, and purchase began only when something ran short.
Dispatch not tied to payment
Goods could leave before full payment, and money owed was chased by hand.
One flow from inquiry to payment, with a gate nobody can skip.
Follow one order through costing, batch production and stock. Switch the payment to see the dispatch gate stay locked until the order is fully paid.
The order
On the floor
Payment rule
What the design is built to change.
Nothing is in use yet, and the file holds no measured before-numbers. So the design shows the direction, not number targets. The counts come from the costing workbook and the clickable sample.
Studied, designed and shown as a sample.
Clarity
A paid visit mapped sales, costing, production, stock, purchase, dispatch and accounts with the owner.
System
A system plan and a ten-screen clickable sample, including the bill of materials, production and quality checks from a distance.
Automate
Purchase raised by stock levels and planned production, and dispatch locked until payment is complete.
Support and Improvement
An owner dashboard with daily, weekly and monthly views and alerts for anything critical.
Other businesses we have mapped.
Twenty spreadsheets, and no order could be traced from sale to dispatch.
Read the case study →Peak-season business lost because production planning ran on memory.
Read the case study →Find what is slowing your business down, in 30 minutes.
A free call with someone who knows operations. No sales pitch. You leave with the three things to fix first.