Three things happen to units that don't come out right, and cost accounting gives each its own name. Spoilage is a unit that can't be sold as intended: burnt, underweight, contaminated. Rework is a unit that's fixed and then sold as good: a bag resealed, a jar relabeled. Scrap is what's left over with a little value: trim, broken pieces, sold cheap or given to a farmer for feed. They matter separately because they land in different places. A loss you expect on every run belongs in the cost of the good units. A loss from something going wrong belongs on its own line, where you can see it. Mix the two and one bad day makes every bag look expensive. Below are the definitions, three batches of a made-up granola maker worked through, and a calculator. This is the usual treatment in outline: ask your accountant how your own books should show it.
The short version
- Spoilage: can't be sold as intended. Rework: fixed and sold. Scrap: leftover with some value.
- Normal spoilage is what a good run still loses. It stays in the cost of the good units.
- Abnormal spoilage is the rest. It's taken out as a loss, and looked at.
- Rework adds its own cost to the batch.
- Scrap that's sold comes off the batch's cost.
- Set the normal allowance from your own records, before the month, not after.
- TaroStack records every adjustment with a reason and costs each batch. More below.
Three batches
Each batch starts 1,000 bags and has $2,400.00 put into it, so a bag started costs $2.40. This maker treats 2% as normal: 20 bags a batch.
| B-114 | B-115 | B-116 | |
|---|---|---|---|
| Good bags | 950 | 880 | 985 |
| Reworked and passed | 20 | 0 | 0 |
| Spoiled | 30 | 120 | 15 |
| Normal spoilage, up to 20 | 20 | 20 | 15 |
| Abnormal spoilage | 10 | 100 | 0 |
| Loss from abnormal spoilage | $24.00 | $240.00 | $0.00 |
| Rework cost | $12.00 | $0.00 | $0.00 |
| Scrap sold | $0.00 | $18.00 | $0.00 |
| Cost carried by good bags | $2,388.00 | $2,142.00 | $2,400.00 |
| Cost of a good bag | $2.46 | $2.43 | $2.44 |
B-116 is an ordinary run. Fifteen bags lost, under the allowance, nothing abnormal. The whole $2,400.00 is carried by 985 good bags: $2.44 each. That's what a bag costs when things go right, losses included.
B-115 is the sealer fault. A hundred and twenty bags lost. Twenty are normal. The other hundred, at $2.40, are a $240.00 loss, taken out and shown by itself. The broken granola was sold to a bakery for $18.00, which comes off the batch. What's left, $2,142.00, is carried by 880 bags: $2.43.
So the cost of a good bag barely moved, and the month shows a $240.00 loss with a cause attached. Had all $2,400.00 been spread over 880 bags, each would have cost $2.73, and a pricing decision might have been made from a number that was really a broken sealer.
B-114 had 20 bags resealed, at $12.00 of labor and film. They count as good. Ten bags over the allowance were lost: $24.00. The good bags, 970 with the reworked ones, carry $2,388.00: $2.46.
The sums
- Normal spoilage (units) = the smaller of units spoiled and units started × the allowance.
- Abnormal spoilage = units spoiled − normal spoilage.
- Loss from abnormal spoilage = abnormal units × cost of a unit started.
- Cost carried by good units = cost put in − that loss + rework cost − scrap sold.
- Cost of a good unit = cost carried ÷ (good units + reworked units).
Setting the allowance
Normal is a number you choose from evidence: what your process loses on runs where nothing went wrong. Take the last twenty batches, leave out the ones with a known fault, and look at what the rest lost. This maker's ordinary runs lose between 1% and 2%, so 2% is its allowance. Set it before the month starts. An allowance raised afterward to absorb a bad batch defeats the purpose.
The rate itself is in scrap rate formula, and what share comes out right the first time in first pass yield formula. Stock that expires on the shelf is a different loss: see what is an inventory write-down and expired stock journal entry.
Get the calculator
Download the spoilage, rework and scrap calculator. One sheet and a read-me: type what a batch started with, what came out good, reworked and spoiled, your allowance, and the costs, and it splits the loss and works out what a good unit cost. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The calculator needs the count of what was lost and why, and that's the number least likely to be written down. A tub of floor sweepings is tipped out at the end of a shift. Bags that failed the seal check are opened and the granola goes back into the next batch, which is rework nobody recorded. At month end the materials used don't match the bags made, and the gap is a single unexplained figure.
How TaroStack does it
TaroStack records the loss when it happens, with its reason.
Each batch records what it used and what it made, good and rejected, so the yield shows on the batch.
Actual against standard cost. A batch that used more, or made less, than its recipe expects shows it.
Every adjustment carries a reason: spoiled, damaged, sample, sealer fault. Losses add up by cause.
Cost comes from what you paid for the lots a batch used, freight included.
| The month-end question | Tally sheets | In TaroStack |
|---|---|---|
| What did batch B-115 lose | A note, if someone wrote it | Made and rejected, on the batch |
| What did that cost | Bags × a guess | From the lots used |
| How much loss was the sealer | Unknown | Adjustments by reason |
| What a good bag really costs | Month total ÷ bags | Each batch's actual cost |
TaroStack doesn't post journal entries or decide what your books call normal. Recipes, batches and costs are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
