Build-To (PAR) List Calculator

Use four weeks of usage, lead time, safety stock, and coverage days to set par levels and order quantities for any item on your order guide.

Download from The Vault Read the Guide

Quick Build-To Calculator

Plug in your last four weeks of usage plus lead time, safety stock, and coverage days. We’ll calculate daily usage, a Build-To (PAR) level, and a recommended order quantity.

Cases × units per case or straight units.
Use the same unit you used for Week 1.
Optional, but recommended.
Optional — the more weeks, the smoother the average.
Days from order placed to truck on-site.
Extra cushion for late trucks or spikes.
Days you want on hand after the next delivery.
Optional — we’ll show Build-To and order in cases.
Count what’s physically on the shelf.
Anything already ordered but not received.
Average & Peak Usage
0.0 / 0.0

Average weekly usage / peak weekly usage, based on the weeks you entered.

Daily Usage (units/day)
0.0

Average weekly usage ÷ 7 days.

Build-To (PAR, units)
0

Daily usage × (Lead Time + Safety Stock + Coverage Days).

Order Quantity (units)
0

Build-To − On Hand − On Order. If negative, we show zero.

In Cases (Build-To / Order)
0.0 / 0.0

Uses the case pack you entered. Great for rounding orders to whole cases.

Preview: Build-To (PAR) List Template (Google Sheets)

Read-only preview of the template. For your own copy, grab it from The Vault and open in Excel or Google Sheets.

After you publish your own copy to the web, replace the placeholder ID in this iframe with your Sheet’s published ID to show your live template here.