Softwiro
Free Excel template

Production Tracking Spreadsheet for Excel

A free Excel production tracking spreadsheet for a small manufacturer, workshop or maker business. You set up your products and the operations each one goes through, enter your work orders, and then log what each operator finished every day: good units, scrap and hours. The sheet works out how complete every order is, where the work in progress is sitting, which orders are late or due soon, your scrap rate and yield, labour hours against plan, and the real cost per unit. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

Excel file (.xlsx) · 221 KB · 11 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
As of46342Change the date and rates on the Settings sheet.
Work orders9Units completed90
Open orders6Scrap rate1.6%
Late orders2Yield (good / total)98.4%
Due soon1Labour efficiency95.7%
Units in process (WIP)59Avg cost / unit (completed)47.50
OperationUnits in processGood qtyScrapScrap rateHours actualHours planned
Cut1315353.2%50.648.1
Sand613732.1%38.337.0
Assemble156400.0%37.435.8
Finish2511010.9%29.328.0
Pack09000.0%7.27.0
ProductUnits completedScrapStandard cost / unitActual cost / unitvs standard
Oak side table20167.5070.955.1%
Bookshelf, 5 shelf100135.00140.404.0%
Dining chair0256.00
Cutting board60622.5024.207.6%

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: Work orders, open, late and due soon; units in process; units completed; scrap rate; yield; labour efficiency and average cost per unit. Tables by operation and by product, and four charts: work in progress by operation, orders by status, labour hours actual against planned, and cost per unit standard against actual.
  • Orders: One row per work order (60 rows): order number, product, customer, quantity ordered, order and due dates. It works out quantity completed, scrap, completion %, hours actual and planned, hours against plan, days to due, status, material and labour cost, cost per unit and a Check column.
  • Log: The daily production log (1,500 rows): date, order number, operation, good quantity, scrap, hours and operator. It adds the product, planned hours and scrap % for each entry, and flags unknown orders or operations that are not in the product's routing.
  • WIP: Work in progress for every order: the good quantity finished at each of up to five steps, units started, scrap, units finished, units still in process and the operation they have reached.
  • Late orders: Every order that is Late or Due soon on the as-of date, with customer, product, completion % and days to due. Up to 30 lines.
  • Products: Your products (30 rows) with material cost and sale price per unit. It adds planned hours, labour and overhead cost, standard cost per unit, margin % and the first and last operation.
  • Routing: The operations of each product in order (step 1 to 5) with the planned labour hours per unit. This is the plan that the log is measured against.
  • Lists: Your operations (up to 12), which feed the dropdowns and the dashboard.
  • Settings: Business name, currency symbol, the as-of date, labour rate per hour, overhead per labour hour and the due-soon window in days.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most free production trackers are a log of units made per day, so they cannot tell you whether an order is on time or what it cost. This one starts from the order and its routing: every good unit earns the planned hours of its operation, so completion, work in progress and labour efficiency all come from the same log. The sample is a small furniture workshop with 4 products, 9 work orders and 24 log entries in October and November 2026.

How do I track production in Excel?

Start with three lists. On Products, enter what you make and its material cost. On Routing, enter the operations each product goes through, in order, with the hours you expect one unit to take. On Orders, enter each work order with its quantity and due date. Then, each day, add one Log row per operation finished: the order number, the operation, how many units passed, how many were scrapped, the hours and the operator.

Everything else is calculated from the log. In the sample, order WO-1001 (20 oak side tables) shows 20 completed, 1 scrapped, 100% complete and 34.7 hours used against 33.4 earned, so it ran 3.9% over plan. The log is the only place you type progress, so the dashboard cannot disagree with it.

How do I track work in progress (WIP) in a spreadsheet?

Work in progress is every unit you have started that is not yet finished or scrapped. The WIP sheet counts it per order as units started, minus scrap, minus units that passed the last operation, and shows the operation each order has reached. The Dashboard then adds the units up by operation, so you can see where work is piling up.

In the sample, 59 units are in process on 16 November: 25 chairs waiting at Finish, 15 side tables at Assemble, 13 chairs at Cut and 6 bookshelves at Sand. A queue that keeps growing at one operation is your bottleneck.

How do I calculate scrap rate and yield?

Scrap rate is scrap divided by everything the operation processed, good plus scrap. Yield is the share that came out good, which is 1 minus the scrap rate. The sheet works both out for each log line, for each operation and for the whole shop.

The sample has 554 good units and 9 scrapped at operation level, a scrap rate of 1.6% and a yield of 98.4%. The Cut operation scraps the most, 3.2%. Scrap is paid for in the cost: material is charged on every unit started, scrapped or not.

How do I work out cost per unit?

The sheet adds material cost (units started times the material cost per unit) to labour and overhead (actual hours times your labour rate plus overhead per hour) and divides by the units completed. It shows this for finished orders and compares it with the standard cost on Products, which is built from the routing hours.

Rates in the sample are 22.00 labour and 8.00 overhead per hour, so one oak side table has a standard cost of 67.50. The finished order cost 70.95 per table, 5.1% over standard, because it used extra hours and one unit was scrapped. Check how to treat overhead with your accountant, since the right method depends on your records and local rules. To see what price covers that cost, try the break-even calculator.

How to use it

  1. On Settings type your business name, currency symbol, the "as of" date (the day you are reporting on), your labour rate per hour, your overhead per labour hour and the number of days that counts as "due soon". On Lists enter your operations (Cut, Weld, Paint and so on).
  2. On Products add one row per product with its material cost and sale price per unit. On Routing add one row per operation of each product, in order (step 1, 2, 3...) with the planned labour hours per unit. A product can have up to 5 steps.
  3. On Orders add one row per work order: order number, product, customer, quantity ordered, order date and due date.
  4. Every working day, add a row to the Log for each operation finished: date, order number, operation, good quantity, scrap, hours worked and operator.
  5. Orders shows completion %, hours against plan, status (Complete, Late, Due soon, In progress, Not started) and cost per unit. WIP shows where every unit is. Late orders lists what needs a phone call.
  6. Open Dashboard for order status, work in progress by operation, scrap rate, yield, labour efficiency, cost per unit and four charts. Change the as-of date on Settings to move the whole workbook to a new day.

Before you start:

  • Capacity: 30 products, 100 routing steps (5 per product), 60 work orders, 1,500 log rows, 12 operations (the Dashboard table shows the first 6) and 30 lines on the late-orders list.
  • Good quantity is what passed the operation. Scrap is what was thrown away at that operation. An order counts as Complete when the good quantity at its last operation reaches the quantity ordered.
  • Completion % is earned hours divided by planned hours: every good unit earns the planned hours of its operation. This way an order that has been cut and sanded but not assembled shows partial progress, not 0%.
  • Material cost = units started x material cost per unit, so scrapped units are paid for. Labour and overhead = actual hours x (labour rate + overhead per hour). Cost per unit is shown for completed orders.
  • Units in process = units started, minus scrap, minus units finished at the last operation. The Dashboard groups them by the operation they have reached.
  • The sheet never reads the computer clock: Status and Late orders are worked out against the as-of date on Settings, so the numbers do not change by themselves when you open the file on another day.

Excel file (.xlsx) · 221 KB · 11 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet gives you an estimated cost before production starts. ProTrack ties every stage of an order to its actual cost and to the contract, so a cost overrun shows up while you can still fix it.

In this sheetIn ProTrack
The cost here is an estimate made before production starts.It compares the cost of each stage (materials, labor, machine hours, subcontractor) with what was estimated in the quotation, and works out the cost per piece.
You find out the cost exceeded the price after the order is finished.It calculates expected and actual profit as the work progresses, and alerts you when cost passes 80% and then 100% of the contract value.
You phone the departments to find out where each order stands.Workers log their output from their phones with a simple code, and you see each order's current stage and progress percentage on your own phone.
Pieces sent out to the laundry or the print shop are tracked from memory.It records what went out, what came back, what was rejected and what is still outside, and adds the cost to the order.

See ProTrack · Ask for a demo

Frequently asked questions

Is this production tracking spreadsheet really free?

Yes. Download it, use it in your business and change anything you like. There is nothing to sign up for to open the file.

Can I track more than one product and several operations?

Yes. The sheet holds 30 products, each with up to 5 operations, 60 work orders and 1,500 log rows. Operations are shared, so the same Cut or Pack step can be used by every product.

Does it show which orders are late?

Yes. Orders are compared with the as-of date on Settings. An order is Late if it is past its due date and not complete, and Due soon if it is within the window you set (3 days in the sample). Both appear on the Late orders sheet and in red or yellow on Orders.

How is completion % worked out?

Each good unit earns the planned hours of the operation it passed, and completion is earned hours divided by the hours planned for the whole order. An order that is cut and sanded but not assembled therefore shows partial progress, not zero.

Will it work in Google Sheets and with my currency?

It opens in Excel, LibreOffice and Google Sheets and uses only common formulas. The currency symbol on Settings is a label, and amounts use plain number formats, so any currency works.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

All the templates in this group: Factory management sheets: production, cost and quality

More free templates for: Factories and production

More free templates

All templates · Free tools