Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainReordering & Stock PlanningEconomic Order Quantity (EOQ) Planner

SpreadsheetReordering & Stock PlanningFree

Economic Order Quantity (EOQ) Planner

Find the order size that keeps ordering and holding costs lowest for each item.

Shown with sample data

Colour

Economic Order Quantity (EOQ) Planner

Find the order size that keeps ordering and holding costs lowest for each item.

Yearly cost today
$8,466
Yearly cost at EOQ
$6,799
Possible saving
$1,667
Yearly saving by category
  • Resale$712.58
  • Raw material$593.02
  • Packaging$361.58
Share of yearly saving by category
  • Resale$712.5843%
  • Raw material$593.0236%
  • Packaging$361.5822%

How to use it

  1. 1Enter annual demand, cost per order and unit cost.
  2. 2Set the holding rate (often 20–30% of unit cost a year).
  3. 3Compare the EOQ with your current order quantity.
  4. 4Round to the supplier’s pack size and check the saving still holds.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Ordering too often wastes time and freight; ordering too much ties up cash and space. Enter annual demand, the cost of placing an order, unit cost and your holding rate, and the sheet returns the economic order quantity, orders per year and the yearly cost compared with how you order today.

Who it’s for

  • Reviewing order sizes with a supplier
  • Teaching or learning EOQ
  • Justifying a change in order frequency

What’s included

  • EOQ sheet: One row per item.
  • Summary by Category sheet: Yearly saving and Cost at EOQ and the number of entries for each category, calculated from the EOQ sheet.

How to use it

  1. 1Enter annual demand, cost per order and unit cost.
  2. 2Set the holding rate (often 20–30% of unit cost a year).
  3. 3Compare the EOQ with your current order quantity.
  4. 4Round to the supplier’s pack size and check the saving still holds.
Related searcheseoqeconomic order quantityorder quantityholding costordering cost

Details

Format
Spreadsheet
Category
Reordering & Stock Planning
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetReordering & Stock PlanningFree

Economic Order Quantity (EOQ) Planner

Find the order size that keeps ordering and holding costs lowest for each item.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Reordering & Stock Planning
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More reordering & stock planning templates

View all
Reorder Point & Safety Stock Calculator2 sheets

Items to order now

3

Units to order

4,361

Items tracked

5

ABCD
1ItemSupplier typeAvg daily demandPeak daily demand
2Phone case, clearImport4270
3Screen protectorImport6595
4Charging cable 1mLocal3048
5Wall adapter 20WLocal1826
Reorder planner
SpreadsheetReordering & Stock Planning

Reorder Point & Safety Stock Calculator

Work out when to reorder each item from its demand, lead time and how variable both are.

10 min setupPreview
Demand Forecast Planner2 sheets

Forecast units next month

2,189

Units short

1,089

Products growing

4

Forecast units by product
790
528
368
310
193
Kids bottleTrail bottle 750mlThermal flask 1LInsulated mugPicnic set
SpreadsheetReordering & Stock Planning

Demand Forecast Planner

Forecast next month for each product from the last six months, with a trend and seasonal adjustment.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ