Par Level — Inventory & Reorder System for Small Businesses | Excel + Google Sheets

Most "inventory templates" you'll find were built by someone who's never managed real stock in their life. They give you three columns — item, quantity, price — and call it a system. Then you still stock out of your bestseller and sit on dead inventory you can't move.

Par Level is different. It was built by an operator who runs real supply pipelines.

Drop in your products and Par Level tells you — automatically — exactly what to reorder, the day to reorder it, and how much to buy. It uses the same math professional supply planners use: reorder points, safety stock sized to a service level, and Economic Order Quantity (EOQ). No fluff, no guessing.

What it does for you the moment you open it:

• 🟢🟠🔴 Color-coded status on every product — OK, Low, Reorder Now, Stockout, or Overstock — at a glance
• 📋 A live "What to Buy Now" dashboard that builds your purchase list automatically, with quantities and total cash needed
• 🎯 Reorder points that account for your supplier's lead time AND demand swings, so you stop stocking out
• 📦 EOQ that tells you the most cost-efficient quantity to order — not too much, not too little
• 🔤 Automatic ABC analysis so you know which products actually matter (your vital few vs. trivial many)
• 💰 Overstock flags that surface cash you've frozen in slow-moving stock

What's inside (6 tabs):

• Start Here — a 5-minute setup guide
• Dashboard — your daily command center with KPIs and the auto buy-list
• Inventory — the engine; just fill the input columns, everything else calculates
• Suppliers — track lead times, minimums, and terms
• Sales Log — optional demand journal
• Settings — tune service level, costs, and thresholds to your business

Who it's for: Etsy & Shopify sellers, makers, candle/soap/skincare brands, e-commerce shops, cafés, small retailers — anyone who buys stock and resells it.

The math (because it's real):
Reorder Point = (Avg Daily Usage × Lead Time) + Safety Stock
Safety Stock = Z-score(Service Level) × √(Lead Time) × Demand Variability
EOQ = √( (2 × Annual Demand × Order Cost) ÷ Holding Cost )

Instant download. Comes pre-loaded with sample data so you can see it working immediately — then swap in your own products. Works in Microsoft Excel (365), Google Sheets, and Apple Numbers.

⚠️ Note: The auto buy-list uses a dynamic formula best supported in Excel 365 or Google Sheets.