Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainReordering & Stock PlanningReorder Point & Safety Stock Calculator

SpreadsheetReordering & Stock PlanningFree

Reorder Point & Safety Stock Calculator

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

Shown with sample data

Colour

Reorder Point & Safety Stock Calculator

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

Items to order now
3
Units to order
4,361
Items tracked
5
Entries by supplier type
  • Local3
  • Import2
Share of entries by supplier type
  • Local360%
  • Import240%

How to use it

  1. 1Enter daily demand and lead time, average and worst case.
  2. 2Enter what is on hand and already on order.
  3. 3Order every item marked Order now, using the suggested quantity.
  4. 4Review the inputs each quarter or after a supplier change.

In this workbook

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

About this template

Stop guessing minimums. For each item enter average and peak daily demand and average and longest lead time; the sheet calculates safety stock, the reorder point and a suggested order quantity, and tells you which items need ordering today.

Who it’s for

  • Setting min/max levels that match real demand
  • Avoiding stock-outs on fast movers
  • A weekly "what to order" check

What’s included

  • Reorder planner sheet: One row per item you reorder.
  • Summary by Supplier type sheet: The number of entries for each supplier type, calculated from the Reorder planner sheet.

How to use it

  1. 1Enter daily demand and lead time, average and worst case.
  2. 2Enter what is on hand and already on order.
  3. 3Order every item marked Order now, using the suggested quantity.
  4. 4Review the inputs each quarter or after a supplier change.

Questions

How is safety stock worked out?

Peak daily demand times longest lead time, minus average demand times average lead time. It covers a bad week arriving at the same time as a late delivery.

Related searchesreorder pointsafety stocklead time demandstock replenishmentmin max

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

Reorder Point & Safety Stock Calculator

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

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
Economic Order Quantity (EOQ) Planner2 sheets

Yearly cost today

$8,466

Yearly cost at EOQ

$6,799

Possible saving

$1,667

ABCD
1ItemCategoryAnnual demandCost per order
2Steel sheet 2mmRaw material4,800$85.00
3Aluminium barRaw material2,600$85.00
4Carton, mediumPackaging60,000$40.00
5Label rollPackaging900$40.00
EOQ
SpreadsheetReordering & Stock Planning

Economic Order Quantity (EOQ) Planner

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

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