Home / Free tools / Food Cost & Inventory
Excel · 6 KB
Par Level Calculator
An Excel sheet that turns usage into par levels. Enter average daily usage, days between deliveries and a safety stock percentage for each item; it calculates the par level and, against what you have on hand, the quantity to order. Ten items are pre-labelled as a starting point.
- Format
- Excel workbook
- Size
- 6 KB
- Price
- Free, no sign-up
- Section
- Food Cost & Inventory
What's in it
- Par level calculated as average daily usage times days between deliveries, plus safety stock
- Safety stock set per item as a percentage, defaulting to 30%
- Order quantity calculated as par minus on-hand, and never below zero
- Ten common items already listed, with rows to add your own
How to use it
- Get average daily usage from a few weeks of real counts, not from memory
- Set days between deliveries per supplier - produce and dry goods are rarely the same
- Raise safety stock on items that ruin a shift when they run out, not on everything
- Recount on-hand before ordering; the order quantity is only as good as that number
The guide that explains it
How to Set Par Levels for Inventory — Par levels tell you how much of each item to keep on hand so you never run out or over-order. Here's the formula, a worked example.