Free template

Free economic order quantity (EOQ) template

Free EOQ spreadsheet for Excel and Google Sheets.

EOQ is the order size that balances the cost of placing orders against the cost of holding stock. Enter each SKU's numbers and the sheet gives the EOQ, how many orders a year that means, and roughly how many days apart they are.

Download the free template (.xlsx)

Works in Excel, Google Sheets (File, Import, Upload) and Apple Numbers. No email required.

What's in the template

EOQ tab

SKU, Annual demand (units), Cost per order, Unit cost, Holding cost % per year, Holding cost per unit, EOQ (units), Orders per year, Days between orders

White cells are inputs. Green cells are formulas, so don't type over them. Sample rows are included so you can see how it works. Delete them and add your own.

How to use it

  1. Enter units you expect to sell in a year.
  2. Estimate cost per order: shipping you pay per order plus your time to place and receive it.
  3. Set holding cost, usually 20 to 30 percent of unit cost per year.
  4. Read the EOQ, then round to the supplier's case pack or minimum.
  5. Check the days between orders against lead time. Order size still has to cover lead time.

The math

EOQ = √(2 × annual demand × cost per order ÷ holding cost per unit)

Want to check one product quickly? Use the free EOQ calculator.

Skip the spreadsheet

Spreadsheets work until you have more products than time. SteadyShelf connects to your Shopify store, works out daily sales for every product, shows what to reorder and when for each supplier, and drafts the purchase order for you. $29/month flat, unlimited products and suppliers, 30-day free trial.

SteadyShelf is launching on the Shopify App Store. Join early access to get the install link first.

More free templates

All free inventory templates · Free purchase order generator

FAQ

Is EOQ useful for small stores?

As a sanity check, yes. It tells you whether you're ordering far too often or far too much. Supplier minimums and cash usually decide the final number.

What holding cost should I use?

Twenty to thirty percent of unit cost per year is the common range. It covers storage, cash tied up, damage and the chance the stock goes stale.

Let SteadyShelf do this math for every SKU

Order-by dates per supplier, seasonal forecasts and draft POs for your Shopify store. $29/month after a 30-day free trial.

Get early access