JavaScript Required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Inventory Planning
Inventory Planning
Sales data
Inventory data
Inventory planning
More
Share
Explore
Sales data
Sales Forecast
Forecast your future sales using a worst-case, baseline, and best-case scenario analysis.
You can create 3 different scenarios (or versions) of your inventory forecast and assign a growth rate from the prior year:
Scenario
Increase from prior year
1
Worst case
-5%
2
Baseline
10%
3
Best case
25%
There are no rows in this table
Selected scenario for the model 👉
Baseline
Notice that when you change it, the "Qty Scenario Chosen" column changes below
🔮 Forecast Data
Filter the table by:
Product Type =
Jumpsuits & Rompers
+7
Date =
Everything
Search
Month
Product Type
Qty Sold Previous Year
Worst Case Scenario
Baseline Scenario
Best Case Scenario
Qty Scenario Chosen
June 2019
7
Jumpsuits & Rompers
23,000
21,850
25,300
28,750
25,300
Dresses
12,000
11,400
13,200
15,000
13,200
Skirts
6,000
5,700
6,600
7,500
6,600
Headbands
6,000
5,700
6,600
7,500
6,600
Outerwear
6,000
5,700
6,600
7,500
6,600
Shoes
1,000
950
1,100
1,250
1,100
Swimwear
2,000
1,900
2,200
2,500
2,200
July 2019
7
Jumpsuits & Rompers
10,000
9,500
11,000
12,500
11,000
Dresses
4,000
3,800
4,400
5,000
4,400
Skirts
2,000
1,900
2,200
2,500
2,200
Headbands
4,000
3,800
4,400
5,000
4,400
Outerwear
2,000
1,900
2,200
2,500
2,200
Shoes
100
95
110
125
110
Swimwear
5,000
4,750
5,500
6,250
5,500
August 2019
7
Jumpsuits & Rompers
8,000
7,600
8,800
10,000
8,800
Dresses
6,000
5,700
6,600
7,500
6,600
Skirts
4,000
3,800
4,400
5,000
4,400
Headbands
7,000
6,650
7,700
8,750
7,700
Outerwear
2,000
1,900
2,200
2,500
2,200
Shoes
100
95
110
125
110
Swimwear
100
95
110
125
110
September 2019
7
Swimwear
100
95
110
125
110
Jumpsuits & Rompers
10,000
9,500
11,000
12,500
11,000
Dresses
10,000
9,500
11,000
12,500
11,000
Skirts
6,000
5,700
6,600
7,500
6,600
Headbands
10,000
9,500
11,000
12,500
11,000
Outerwear
3,000
2,850
3,300
3,750
3,300
Shoes
1,000
950
1,100
1,250
1,100
October 2019
7
Swimwear
1,000
950
1,100
1,250
1,100
Jumpsuits & Rompers
11,000
10,450
12,100
13,750
12,100
Dresses
10,000
9,500
11,000
12,500
11,000
Skirts
6,000
5,700
6,600
7,500
6,600
Headbands
9,000
8,550
9,900
11,250
9,900
Outerwear
6,000
5,700
6,600
7,500
6,600
Shoes
1,000
950
1,100
1,250
1,100
November 2019
7
Swimwear
1,000
950
1,100
1,250
1,100
Jumpsuits & Rompers
12,000
11,400
13,200
15,000
13,200
Dresses
10,000
9,500
11,000
12,500
11,000
Skirts
5,000
4,750
5,500
6,250
5,500
Headbands
15,000
14,250
16,500
18,750
16,500
Outerwear
4,000
3,800
4,400
5,000
4,400
Shoes
1,000
950
1,100
1,250
1,100
December 2019
7
Swimwear
10
10
11
13
11
Jumpsuits & Rompers
7,000
6,650
7,700
8,750
7,700
Dresses
5,000
4,750
5,500
6,250
5,500
Skirts
3,000
2,850
3,300
3,750
3,300
Headbands
5,000
4,750
5,500
6,250
5,500
Outerwear
1,000
950
1,100
1,250
1,100
Shoes
1,000
950
1,100
1,250
1,100
👉Next up:
Input Sales Data
Related Docs
$10k Work: How to increase your productivity using the magic of leverage
Khe Hy
Hoffman fanmade coffee calculator
Alessandro Mingione
How to Find the Perfect CS:GO Mouse Sensitivity
Zack Aman
Organize your Spotify playlists
Helena Jaramillo
Mental Health Awareness Month
Jamie Forseth
Eigenquestions: The Art of Framing Problems
Shishir Mehrotra
The Notion User's Guide to Coda (2022 Edition)
Ben Parker
Public Neurodiversity Support Center
Mykola Bilokonsky
We Work Remotely Job Board
Justine Camacho
Dreamline Calculator by Tim Ferriss
Al Chen
Home Maintenance Starter Kit
Shannon Ong-Shepard
Sahil Bloom's Calendar Painter: How to get more focused and efficient with your time
Justin Hales
Des Traynor's 4-Step Prioritised Productivity Guide
Des Traynor
I Think I Might Be Neurodivergent!
Myk Bilokonsky
Related Categories
Finance
Sales
Personal
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.