Manufacturing
How do I calculate a fabric shortage before a production order is due?
Subtract reservations and separate quality holds from fabric on hand. Add confirmed receipts due on or before the need-by date. Compare that supply with demand in the same unit. Any positive gap is the shortage. If supply covers demand, the shortage is zero.
Fabric balance for fictional order SO-17
In Bismion’s fictional Factory A example, order SO-17 is 50 m short of the 300 m of cotton twill needed by 24 November 2026. The factory has 130 m of usable stock. Confirmed Receipt-42 brings 120 m that day, making 250 m available.
| Evidence | Quantity | How it counts |
|---|---|---|
| Stock on hand | 200 m | Starting balance at the factory |
| Reserved stock | 50 m | Already committed to other demand |
| Quality hold | 20 m | Held separately from reservations |
| Usable stock | 130 m | 200 − 50 − 20 |
| Receipt-42 | 120 m | Confirmed incoming by 24 November 2026 |
| Available by need date | 250 m | 130 + 120 |
| Order requirement | 300 m | Needed for SO-17 |
| Shortage | 50 m | 300 − 250 |
What changes the answer?
If the receipt arrives a day late
A delivery on 25 November 2026 falls outside the order’s window. With 0 m incoming by 24 November 2026, the order is 170 m short.
If the receipt has no unit
Shortage unknown. Receipt-42 has no unit. Check its source unit before adding it to the fabric balance.