Skip to main content
Menu
Book a Clarity Call →
Nutraceutical contract manufacturer · Gujarat, IndiaDiagnosis + designed systemManufacturing industry →

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.

8Hand-built costing sheets, one per productCounted
10Screens in the clickable sampleCounted
100%Payment before dispatch, as a system ruleTarget
IndustryNutraceutical and cosmetics manufacturing
Team size30–40 people
CountryGujarat, India
Work doneDiagnosis + designed system
StageSample designed
The situation

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.
What we found

Five findings. These four mattered most.

FINDING 01

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.

FINDING 02

Production ran by voice

No work orders, batch tracking or stage status. Only the owner knew what was happening on the floor right now.

FINDING 03

No batch or expiry tracking

Raw material was not tracked by batch, container or expiry, and purchase began only when something ran short.

FINDING 04

Dispatch not tied to payment

Goods could leave before full payment, and money owed was chased by hand.

What we designed

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.

Example with sample data. Not the client’s figures.
InquiryQuotation sentSample approvedOrder placedLive costingRaw materialsPackingLabourCommissionQuantity slabBatch productionMixingWaitingFillingWaitingQC checkWaitingPackingWaitingBatch B-0217 · remote QCStock by expiryContainer AExpires first · pick thisContainer BExpires laterContainer CExpires lastLow stock raises a purchaseDispatch gateLocked until paidPayment received: part paidOrder SO-0418

The order

Priced from live costs
Price is built from current raw material rates, packing, labour, commission and the quantity slab, instead of a hand-built sheet.

On the floor

Read the QR code, then follow the SOP
Each process has a QR code. Reading it with a phone opens the steps, text and video for that job, so the work no longer depends on one person remembering.

Payment rule

Part paid: dispatch stays locked
Dispatch is designed to open only after 100% payment. No one has to remember to check, and nobody can skip it under pressure.
Results and targets

What the design is built to change.

100%Payment before dispatch (target)
1One costing tool in place of a sheet per product (target)
10Screens designed as a clickable sample (counted)
3Device types: web, tablet and phone with QR (target)

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.

How the project went

Studied, designed and shown as a sample.

See all four steps →
01Done

Clarity

A paid visit mapped sales, costing, production, stock, purchase, dispatch and accounts with the owner.

02Designed

System

A system plan and a ten-screen clickable sample, including the bill of materials, production and quality checks from a distance.

03Planned

Automate

Purchase raised by stock levels and planned production, and dispatch locked until payment is complete.

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.

Book a free call →WhatsApp →