Excel (.xlsx) · 7 KB · Free
PAR Level Worksheet
Set a minimum stock level per item, and see what needs reordering at a glance.
What’s inside
- Item, category, unit, on-hand quantity, PAR level and reorder point
- A Reorder? column that flags itself the moment stock hits the reorder point
- Total items needing reorder and the value of stock on hand, both automatic
- Pre-filled with realistic items and units — by the case, the sack, the piece
- Works for a bar, a kitchen or a housekeeping supply room on the same sheet
Why this exists
Nobody notices the beer is almost out until service on a Saturday night, because the count lives in someone's memory rather than a sheet — and the person who usually remembers is not always the one on shift when it runs out. A written PAR level turns that dependency on one person's memory into something anyone on the team can check in seconds.
In MangoHost, every item has a PAR level and a live on-hand count, updated automatically as stock moves in and out — no manual recount needed to know what is short before service starts.
Questions, answered
- What's the actual difference between PAR level and reorder point?
- PAR level is the minimum you want on hand at all times — your buffer against a bad week. Reorder point is the level that should trigger an order, usually PAR level minus what you expect to use before the next delivery arrives. For an item delivered weekly, the two are often close together; for one delivered monthly, reorder point needs to sit well above zero.
- How do I set a sensible PAR level for a new item?
- Start with roughly two weeks of typical usage, then adjust after a month of watching how fast it actually moves. Setting it too high just ties up cash in stock sitting on a shelf; too low and you are reordering constantly and paying for the convenience.
- Should every single inventory item get a PAR level, down to napkins?
- Only the items where running out actually costs you something — a stockout on rice or beer stops service; a stockout on decorative napkins does not. Track everything you buy if you want to, but set PAR levels and reorder points for the items where being wrong is expensive.
- How often should I actually count and update this?
- Weekly for fast-moving items — drinks, produce, anything used daily — and monthly is often enough for slower-moving supplies. The value of the sheet comes from the count being current when you look at it, not from counting constantly; pick a rhythm you will actually keep up.