Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainReordering & Stock PlanningDemand Forecast Planner

SpreadsheetReordering & Stock PlanningFree

Demand Forecast Planner

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

Shown with sample data

Colour

Demand Forecast Planner

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

Forecast units next month
2,189
Units short
1,089
Order or make these
Products growing
4
Forecast units by product
  • Kids bottle790
  • Trail bottle 750ml528
  • Thermal flask 1L368
  • Insulated mug310
  • Picnic set193

How to use it

  1. 1Enter units sold for the last six months.
  2. 2Set an adjustment for known events (1.2 = 20% uplift).
  3. 3Compare the forecast with stock on hand.
  4. 4Record what actually sold and review the gap next month.

In this workbook

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

About this template

A simple, explainable forecast. Enter six months of units sold per product; the sheet gives a three-month moving average, the trend against the earlier three months, and a forecast you can adjust for a known promotion or season, with the stock you would need to cover it.

Who it’s for

  • Monthly purchasing and production planning
  • Small ranges without forecasting software
  • Explaining a forecast to finance

What’s included

  • Forecast sheet: One row per product.
  • Summary by Category sheet: The number of entries for each category, calculated from the Forecast sheet.

How to use it

  1. 1Enter units sold for the last six months.
  2. 2Set an adjustment for known events (1.2 = 20% uplift).
  3. 3Compare the forecast with stock on hand.
  4. 4Record what actually sold and review the gap next month.
Related searchesdemand forecastsales forecast by productmoving averagedemand planningstock planning

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

Demand Forecast Planner

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

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
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

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