Kpiloom
Industry guides

Furniture HR and Operations Dashboards: People and Daily Performance

What to track on a furniture HR dashboard and an operations dashboard: skilled staff, absence, lead time, defects and backlog, with worked examples.

By the Kpiloom team · · 6 min read


A customer orders a six-seater dining set, pays the advance and is promised delivery in three weeks. Week three arrives, the polisher is on leave, the table top is still in the finishing bay and the delivery van is booked for another order. Furniture businesses lose more goodwill to late and damaged deliveries than to price. Behind most delays sit two things: people and workflow.

A furniture HR dashboard keeps the first in view: who is on the team, who is absent, which skilled roles are missing. A furniture operations dashboard covers the second: orders, lead time, defects and backlog. This guide explains what to put on each, how to read the numbers, and how to use them together.

Why people data matters in a furniture workshop

Furniture is still skill-heavy work. A good carpenter, polisher or upholsterer takes years to train, and one of them leaving can slow a whole product line. Many units also rely on contract and piece-rate workers, so headcount changes week to week.

That makes three questions important: do we have enough skilled hands for the order book, are people turning up, and are we keeping the good ones?

The furniture HR dashboard: KPIs to track

KPIFormulaWhat to look for in a furniture business
HeadcountCOUNT of employees with status = ActiveSplit by trade: carpentry, polishing, upholstery, fitting, delivery
Attrition rateLeavers ÷ Average headcountLosing skilled craftsmen hurts far more than losing helpers
Open positionsCOUNT of open requisitionsSkilled vacancies older than a month are a red flag
Time to hireAVERAGE of (Offer accepted − Opening date)Polishers and upholsterers usually take longest to find
AbsenteeismDays absent ÷ Scheduled working daysWatch for spikes after paydays and festivals
Training hoursSUM of training hours loggedCross-training helpers into skilled work
Avg salaryTotal payroll ÷ HeadcountCompare by trade against local market rates
eNPS% Promoters − % DetractorsA simple quarterly pulse for the workshop

Good and bad. A workshop where attrition among skilled staff stays low and absence stays steady month to month is in good shape. Trouble looks like rising absence in one trade, more than one skilled role open for over 30 days, or new joiners leaving within their first few months.

Worked example. A unit has 40 people: 14 carpenters, 8 polishers, 6 upholsterers, 12 helpers and drivers. In October, polishers missed 22 days out of 208 scheduled, an absenteeism rate of about 10.6%. The rest of the workshop was near 3%. That one number explains why finishing, not cutting, was the bottleneck that month.

The furniture operations dashboard: KPIs to track

Operations is where promises to customers are kept or broken. The same eight measures work for a small showroom-plus-workshop and for a larger factory.

KPIFormulaWhy it matters here
Orders fulfilledCOUNT of orders with status = DeliveredOutput you can invoice
On-time deliveryOn-time orders ÷ Orders deliveredThe number customers remember
Avg lead timeAVERAGE of (Delivered date − Order date)Made-to-order pieces often run several weeks
Defect rateDefective units ÷ Units producedIncludes finish faults, wobbles and transit damage
Capacity utilizationActual output ÷ Maximum possible outputShows whether to take more orders or add a shift
Cost per unitTotal operating cost ÷ UnitsRises fast with rework and overtime
BacklogCOUNT of open ordersOrders waiting for production or delivery
DowntimeSUM of stoppage hoursSaw, CNC router or spray booth breakdowns

Good and bad. Healthy signs are a stable backlog, lead times that match what sales promises, and defects caught in the workshop rather than at the customer's door. Warning signs are a backlog that grows every week, on-time delivery slipping while utilization stays high, and repeat defects on the same product.

Worked example. Last month a unit delivered 150 orders, 126 of them on time: 84% on-time delivery. Of 410 pieces produced, 17 failed final inspection, a 4.1% defect rate, and 11 of those were finish faults. The backlog stood at 64 orders against a usual 45. Read alone, it looks like a capacity problem. Read with the people data, it is a polishing problem.

How the two dashboards work together

The real value comes from reading people and operations side by side. A few links to check every month:

  • Absence vs. lead time. When absenteeism rises in one trade, lead time for products that need that trade usually follows two to three weeks later.
  • Attrition vs. defect rate. When experienced staff leave and new hires take their place, defects often rise until training catches up. Training hours should rise at the same time.
  • Overtime vs. cost per unit. High utilization with growing overtime pushes cost per unit up. Hiring one more skilled worker can be cheaper than months of extra shifts.
  • Open positions vs. backlog. A growing backlog with skilled roles open is a hiring problem, not a sales problem.

In practice, keep the furniture operations dashboard as the weekly review and open the HR view monthly, or whenever a delay can't be explained by machines or materials. If stock is also a worry, the furniture inventory tracker in Excel shows which wood, boards and fittings are running low.

Excel, Google Sheets, Power BI or Looker Studio?

ToolBest forThings to know
ExcelOwner-run units with one office PCWorks offline; easy to print for floor meetings
Google SheetsShowroom and workshop updating the same fileShared link, live updates from a phone
Power BIMulti-unit factories with an ERPNeeds more setup and a license
Looker StudioTeams already using Google toolsFree, but best fed from a Google Sheet

For most single-site furniture businesses, Excel or Google Sheets is enough. Software prices and plans change, so confirm current pricing on each vendor's official site. Start with the Excel staff tracker for furniture makers and the delivery and production dashboard for furniture in Google Sheets, or compare the Excel operations dashboard for furniture workshops. The full range sits on the furniture templates page, and the operations templates in Excel cover other industries too.

Which theme should you pick?

Classic suits printing for floor meetings, Dark is easy on the eyes on a workshop screen, Minimal reads best in reports to partners, and Colorful helps when the team scans trades at a glance.

Getting started

Start small. Put this month's attendance register and order list into the files, check that the numbers match what you already know, then add last quarter's data for trends. The furniture HR dashboard needs updating once a month; operations needs a weekly refresh. For background on choosing measures, see what a KPI dashboard is.

Pay, attendance and contract records are personal data and subject to labor rules. This guide is general information, not legal, HR or financial advice; check local employment and wage rules with a qualified adviser.

Get the dashboards from this guide

Furniture HR Dashboard

Furniture Operations Dashboard

Frequently asked questions

Which KPIs matter most for a furniture workshop?

On-time delivery, average lead time, defect rate and backlog on the operations side; attrition and absenteeism among skilled trades such as polishers and upholsterers on the people side.

How do I count contract and piece-rate workers in headcount?

Keep them in the same employee table with a worker type column (permanent, contract, piece-rate). Then show headcount for all workers and for permanent staff separately, so changes are easy to explain.

How often should a furniture business update these dashboards?

Refresh operations weekly, because orders and deliveries move fast. The people view can be updated monthly from the attendance register and payroll.

Skip the build. Start with a ready dashboard.

Templates for Excel and Google Sheets, with live previews.

Browse dashboards

Dashboards related to this article

Keep reading