Production Output Tally Log

Who this is for

What was made, against what you meant to make. Each line takes your own target for the run, the number made and the number rejected, and works out the good units and the yield, so a shift can be read in figures rather than impressions.

Small manufacturers, packhouses, bakeries, print rooms, makers working to order and anyone running batches where output and rejects both matter.

What this helps you track

• Output per run, shift or day, with the product named
• Your own target beside what was actually made
• Rejects taken off, so good units are counted rather than assumed
• Yield per line and across the sheet
• Totals for the period, to set against orders or a plan

How to use it

1. Write the site, the line and the period the sheet covers at the top.
2. Fill one row per run, shift or batch — whichever unit your work naturally falls into.
3. Enter your own target for that run. It comes from your plan or your order book, and nothing is suggested here.
4. Record what was made and what was rejected as two numbers; good units and yield work themselves out.
5. Use the notes column for why a run fell short, and the notes area for anything affecting the whole shift.
6. The totals and the overall yield appear at the foot in the browser and spreadsheet versions.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

What counts as a reject?

Whatever cannot be sold or shipped as it is: scrap, seconds, rework. Decide once and note the definition at the foot, because yield only means something if the column is filled in consistently.

How is yield worked out?

Good units divided by units made, as a percentage. Good units are what you made less what you rejected, so the figure falls as rejects rise.

Is this a batch record?

No. A batch production record documents one batch in detail — ingredients, equipment, checks. This is the tally across many runs, which is what you read at the end of a week.

Can I log by hour instead of by run?

Yes. Use the shift column for the hour and keep the product column filled in, and the totals still add up the way you expect.