Why furniture manufacturers are flying blind on their own production data

Ask the MD of a mid-size fitted furniture or kitchen manufacturer how full the order book is, and they’ll probably give you a number. Ask how much of that work is already committed to materials on order, how many fitters are booked against it, and what’s sitting in the queue behind a delayed supplier delivery — and you’ll get a longer pause.

That pause is expensive.

The typical data situation

Most furniture manufacturers at the 20–150 staff level are running their business across three or four systems that don’t talk to each other.

Orders come in through a job management system — Clarity, Business Micros, or something bespoke built years ago that everyone is too nervous to replace. Production scheduling lives in a spreadsheet that one person updates, usually the production manager, usually manually. Material costs and purchase orders sit in Sage. Installer diaries are in Outlook, or a whiteboard, or both.

Nobody intended it to end up like this. Each system solved a real problem at the time it was introduced. The job management software tracks the order from survey to installation. Sage handles the finances. The spreadsheet fills the gap in between. It works, until the business grows to the point where the gaps between systems are costing more than anyone has sat down to calculate.

The decisions that go wrong

The costly decisions aren’t the big strategic ones — they’re the operational ones that get made twelve times a week.

Production capacity. Without visibility of what’s actually in build versus what’s scheduled, the production manager books new work based on feel. Some weeks the workshop is under capacity and installers are waiting. Other weeks there’s a pile-up. You find out which one it is on the Monday morning when it’s already too late to do anything about it.

Material ordering. Lead times from board suppliers and component manufacturers are running at 3–6 weeks for anything non-standard. If nobody has a clear view of committed materials against upcoming orders, the purchasing decision gets made too late. Then an installation gets pushed, a customer gets a phone call they don’t want, and an installer’s week gets disrupted.

Installer scheduling. Fitting teams are typically booked 3–4 weeks ahead. If an order slips in production, that booking has to move. If the installer is self-employed, you’re renegotiating. If they’re employed, you’re paying for a day that isn’t generating revenue. Either way, the visibility problem becomes a cost problem.

What a proper operations dashboard shows

The goal isn’t a dashboard that shows everything — it’s one that shows the three or four numbers the MD and production manager actually need every morning.

A well-built operations dashboard for a furniture manufacturer typically covers:

Orders by status — surveyed, in design, approved, in production, completed, awaiting installation — with a count and value at each stage
Production throughput by week — units completed versus units scheduled, so you can see slippage before it becomes a crisis
Materials committed versus on order — what’s been purchased, what hasn’t been ordered yet but needs to be, and what’s at risk if a supplier delivery is late
Installer diary fill rate — how booked out the fitting teams are over the next 4, 8, and 12 weeks

None of this data needs to be created from scratch. It already exists in your job management system and in Sage. It just needs to be pulled together into one place where someone can look at it without spending an hour building a spreadsheet first.

The integration problem

The obstacle most manufacturers run into is that their job management software and Sage are islands. The job management system knows the order is at stage 4. Sage knows a payment was received. Neither knows what the other knows.

Most job management systems used in the NI furniture trade will export data — either via a direct database connection or a scheduled CSV export. Sage 50 and Sage 200 both have accessible databases. The data is there. What’s missing is the plumbing that brings it together and keeps it current.

This isn’t a project that requires replacing either system. It’s a layer that sits on top of what you already have.

What fixing it involves and costs

For a business where the job management system supports database access or regular exports, an operations dashboard is typically a two-week project. The first week is understanding the data structure and writing the queries. The second week is building the dashboard and testing it against live data.

The cost is in the range of a single delayed installation — one job that slips because materials weren’t ordered on time, one installer day wasted because production ran late. Most manufacturers we talk to can name exactly that scenario from the past three months.

If the job management system and Sage also need to be connected — so that job status updates in one system are reflected in the other without manual re-entry — that’s a separate integration piece, usually another week’s work on top.

DataPulse Report covers the dashboard side: pulling your existing data into a live view that your production manager and MD can check every morning. From £1,800, delivered in 5–7 days.

If you also need the job management system and Sage talking to each other, SyncBridge is the integration layer. From £2,400.

Both start with a brief — no call required. Start here →