Set Restaurant Par Levels Fast: Step‑by‑Step + Free Template

Disclosure: We are reader supported, and earn affiliate commissions when you buy through us.

Stop guessing your kitchen stock and start ordering with confidence. In the next few minutes you’ll learn exactly how to set par levels for restaurant inventory, cut waste, and keep every line cook happy—all without pricey software. Follow the step‑by‑step system below, download the free Google‑Sheets template, and see measurable results in your first week.

Why Guessing Inventory Costs You Money

Most kitchens rely on gut feelings: “It’s a busy night, so we’ll over‑order,” or “We’re slow, let’s order less.” That approach leads to two costly outcomes:

Food waste – perishables that sit too long and end up in the trash.
Stockouts – missing key ingredients that stall service and frustrate staff.

By tracking actual usage instead of guessing, you create a data‑driven baseline that eliminates both problems.

How to Calculate Par Levels Without Software

Track usage for 5‑7 days – Record the opening count, deliveries received, and closing count for every item you want to control (lettuce, tomatoes, chicken, sauces, etc.).
Compute average daily use – Add the total quantity used over the tracking period and divide by the number of days. This figure becomes the core of your par calculation.
Add a safety buffer – If weekend sales swing wildly, add 20 %; if demand is steady, 10 % is enough.

Formula:

Par Level = (Average Daily Use) × (1 + Buffer %)

For example, if you use 30 lb of lettuce per day and apply a 15 % buffer, your par level is 34.5 lb.

Free Spreadsheet Template Walkthrough

I’ve built a free Google‑Sheets template that automates the above steps. Here’s how to use it:

Column	What to Enter
Item	Name of the ingredient (e.g., “Romaine Lettuce”).
Start Qty	Count at the beginning of the tracking day.
Received	Amount delivered that day.
End Qty	Count at the end of the day.
Used	Calculated as `Start Qty + Received – End Qty`.
Avg Daily Use	Formula: `SUM(Used) / Days Tracked`.
Buffer %	Your chosen safety margin (10‑20 %).
Par Level	Formula: `Avg Daily Use * (1 + Buffer %)`.

Copy the template to your Google Drive.
Enter daily data in the first four columns. The sheet automatically fills “Used,” “Avg Daily Use,” and “Par Level.”
Check each morning – Compare current inventory to the “Par Level” column. Order the difference to stay stocked without over‑ordering.

Implement & Review Your Par Levels

Morning check – Scan the “Par Level” column; place orders for any item below its target.
Weekly review – Update the “Used” column with the latest week’s data, let the averages recalculate, and adjust the buffer if sales patterns have shifted.
Menu changes – When you add or remove dishes, repeat the 5‑7‑day tracking for the affected ingredients to generate new par levels.

By treating the spreadsheet as a living document, you keep waste low and service smooth even during unexpected rushes.

Final Checklist

[ ] Track usage for at least five days.
[ ] Calculate average daily use for each item.
[ ] Choose a buffer (10‑20 % based on sales volatility).
[ ] Populate the free template and generate par levels.
[ ] Perform a morning inventory check against the par numbers.
[ ] Review and adjust weekly.

Implement this system today, and you’ll see a noticeable drop in food waste and a smoother kitchen flow within weeks. Download the template now, plug in your numbers, and start mastering your inventory like a pro.