Cabinet Shop OwnerShop tools

Monthly Shop KPI Tracker

Track revenue, direct costs, overhead, quote wins, job size, utilization, and rework across your shop’s months.

Shared shop rates

Save rates once and apply them when needed. Labor is cost per productive person-hour; overhead is separate. Values are stored only in this browser.

Your worksheet

Example inputs. Replace them with your shop’s numbers.

Monthly records

Add months in order. Use direct loaded labor costs and recognize revenue consistently. Drafts stay in this browser; export CSV for a durable copy.

Results

This dashboard is a management worksheet. Owner compensation must be classified consistently; profit is before financing, taxes, and any unlisted costs.

How this is calculated

  • Gross profit = revenue − direct materials/outsourced production − direct labor. Operating profit = gross profit − overhead.
  • Margins = the relevant profit ÷ revenue. Average job value = revenue ÷ completed jobs.
  • Quote win rate = won ÷ quotes in the same cohort. Utilization = productive hours ÷ paid hours. Rework share = rework hours ÷ productive hours.
  • Period ratios use summed numerators and denominators, not the average of monthly percentages.

All money inputs use USD. Calculations retain full precision; displayed amounts are rounded. Drafts save on this device when browser storage is available. Export your worksheet to keep a separate copy.