Excel vs ERP for furniture manufacturing: where spreadsheets stop coping

Most furniture factories run their production on a set of sheets that grew over the years. The designer keeps a panel list per model, the planner has an order tracker, the saw has a cutting sheet printed each morning, stores has a hardware register, and the paint shop works from a whiteboard. In a small factory with a sharp planner, this works.

A spreadsheet bends to any model, the planner already knows it, and there is no licence to buy. The question is not whether it is good or bad, but at what point the factory's orders, variants and stages go past what separate files can reliably hold.

Where Excel works well in a furniture factory

• Quotations for custom pieces, where one person builds the estimate from a panel list and a rate card.
• Panel lists for a fixed range that changes once or twice a year.
• One-off analysis: board consumption over a quarter, a comparison of laminate suppliers, a capacity check before a big project order.
• A small workshop with one planner, a handful of orders a week and everything finished in-house.

Where do spreadsheets become difficult?

Variants and design changes

A model with three widths, four finishes and two hardware options already has twenty-four panel lists. When the designer changes a shelf depth, every copy has to be updated, and an order released from an old copy is cut wrong. Nobody finds out until assembly.

Cutting several orders together

Combining panels from open orders by board thickness and decor means copying rows from several order sheets into one cutting sheet. It is slow and error-prone, so most factories cut order by order and open more sheets than they need.

Yield and offcuts

Spreadsheets hold what was planned. What each sheet actually produced, and what offcut it left, is rarely written down, and usable offcuts stack up in a corner with no record of their size. Board waste then appears only when the stock count does not match.

Finishing batches

Shutters from several orders go through polish or paint together. The whiteboard shows what is in the booth today, but not which coats each batch received or who sprayed it. When one customer complains about colour, matching the piece to its batch and finding the other orders in that batch is guesswork.

Work in progress

An order's panels may be cut, half banded, waiting for boring and partly in finishing at the same time. A sheet updated at the end of the day cannot show that, so the answer to a customer asking about delivery comes from a walk round the floor or a call to the supervisor.

Hardware and packing

Hinges, channels, handles and fittings are picked from a register at packing time. If the register is behind, the shortage is found with the carton half closed, or at the customer's site.

Cost per order

Board, laminate, edge band, finish, hardware, labour and job work sit in different sheets, so the real cost of a custom order is worked out rarely, if at all, and the next quote uses the same rates.

Spreadsheets and ERP compared, task by task

An ERP is an operational system, not a bigger spreadsheet

What changes is who enters the data, and when. A spreadsheet is filled in after the work, by whoever has time. A manufacturing ERP with shop-floor recording is filled in as the work happens: stores issues board to the order, the saw operator records the panels and offcut from each sheet, the finishing supervisor records the batch, the packer confirms the fittings. Yield, progress and cost then come straight from those entries, with nobody building a report on Saturday.

That is why replacing Excel with a billing or accounting package often changes little on the floor. The sheets that cause the most trouble in a furniture factory are the cutting sheet, the finishing whiteboard and the order tracker, and a system without floor recording leaves them where they are.

When should a furniture manufacturer move from Excel to ERP?

There is no turnover or headcount at which a factory must stop using spreadsheets. The useful test is how often the files fail to give a current, trustworthy answer. These are the triggers furniture makers most often point to.

• Several people edit the panel lists or the order tracker, and someone is always working from an old copy.
• More than one cutting or finishing line runs at once, and nobody has the whole picture.
• Designs and variants change often, and orders are cut from out-of-date panel lists.
• Board use is a mystery. Sheets consumed do not match panels produced, and nobody knows which jobs wasted most.
• Production updates arrive late. The office learns what was cut and finished the next morning.
• Finishing checks are kept by hand, and a colour complaint cannot be traced to its batch.
• Hardware or panels go missing between stages and are found short at packing or at site.
• Rework cannot be seen. Nobody can say how many panels were recut or shutters repainted last week, or why.
• Customer requirements are growing. A project buyer or a retailer asks for delivery dates, progress updates or material records you cannot produce quickly.
• Current WIP is unknown. Finding out what is cut, banded, in finishing or waiting for assembly needs a walk round the floor.

None of these means Excel has failed. They mean the factory has grown past what separate files can reliably hold. Two or three together usually mean the sheets cost more time than a system would. The guide to implementing ERP in a furniture factory covers what the move involves.

Keeping what works

The planner's Excel skills are not wasted after the move. Quotation models, design data and one-off analysis can stay in spreadsheets, fed by exports. What moves is the operational record: orders, variant BOMs, stock by lot, cutting, finishing, assembly and dispatch. In FleekERP that record sits on the work order, with inventory and lot traceability for board and hardware and production control for progress by operation, while the books stay in Tally or Zoho.

For how cutting lists, yield and finishing batches run on one record, see FleekERP for furniture and woodwork.