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

Twenty spreadsheets, and no order could be traced from sale to dispatch.

We studied how a make-to-order furniture maker really ran. Then we designed one system where one order number travels from the sales desk to the truck. It is designed and shown as a clickable sample. It is not in use yet.

ORD-2041CutPolishPackONE ORDER ID, FROM FIRST CUT TO THE TRUCK
20Disconnected Excel files running the businessCounted
1 of 3,931Order rows ever marked completeCounted
24Problems logged, 8 of them criticalCounted
IndustryMake-to-order furniture
Team size50–100 people, incl. contractors
CountryIndia
Work donePaid study, designed system, clickable samples
StageProposal with client
The situation

Orders lived in the owner's phone and twenty files.

Ownerdecides everything“Make 2 sofas”“Urgent: table”“Change polish”#NAME?#VALUE!#NAME?#VALUE!CuttingWhat next?AssemblyWhat next?PolishingWhat next?No labelWrong item
Orders by WhatsAppEvery order, priority and price change came from the owner.
20 files, no linkRepeated lists, and formulas that broke when files were shared.
“What next?”Workers asked again and again what to make next.
Boxes without labelsPacked boxes carried no order reference, so wrong items reached customers.
What we found

Counted from the client's own files.

Every number in this section was counted by our team from the files the business shared with us.

Order status meant nothing

Of 3,931 order rows, one was marked complete. Production sheets held lists of orders, not records of work done.

Counted

The customer’s name was lost at packing

Once a box was packed, nobody could tell whose order it was. The client put it simply: after packing, they didn't know the customer.

Counted

Contractor bills could not be trusted

The cushioning billing sheet showed an error in every cell, and one contractor had been paid an advance well beyond the work they had completed.

Counted

Stock and costing couldn't be trusted

Four material groups had no stock tracking at all, and German Pine was costed 7% above the vendor's rate.

Counted
What we designed

One order number that walks the factory floor.

OWNEROne screen, only what needs you
STATION 06 OF 11

Polishing

The polishing station sees the polish reference photo for each order. Bills are calculated from completed work, and a warning stops an advance that runs over earnings.

FIXES WHAT WE FOUND
Advance over earningsMissing rate cards
PolishingFloor screen · sample view
ORD-2041Walnut finish · photo attachedIn progress
ORD-2037Natural teak · photo attachedDone
BILL-0072Advance above earned amountBlocked
Example data, not client records06 / 11
Design targets

What the system is built to reach.

Nothing is in use yet, so these are targets, not results. Each one is measured the same way as the before number.

1 → allOrders showing their live stage (was 1 row marked complete)Design target
0 → 100%Packed boxes labelled and checked before loadingDesign target
3 → 5 of 5Contractors with a rate card and an automatic billDesign target
Wood → allMaterial categories tracked live, 150+ itemsDesign target
0 → 113Stone orders tracked through to dispatchDesign target
0 → everyQuality checks recorded at receipt and before dispatchDesign target

Before numbers were counted from the client's own files. After numbers are what the design is built to reach once it is in use.

How the project went

Two steps done. The next two wait on the client.

01

Clarity

Mapped 13 departments and 6 sales channels, and went through all 20 files to log 24 problems.

Done
02

System

Designed 12 parts and built clickable samples for desktop, tablet and phone.

Designed and shown
03

Automate

Stock alerts, draft purchase orders and contractor bills from completed work.

Waiting for go-ahead
04

Support and Improvement

Monthly review of the floor screen, quality checks and cost per order.

Next

Is your factory floor running on files and phone calls?

A free 30-minute call with someone who knows factory work. You leave with the three things to fix first, in order.

Book a free call →WhatsApp →