Skip to content
Gallery
Inventory Planning
Inventory Planning
Sales data
Inventory data
Inventory planning
More
Share
Explore
Sales data

icon picker
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 =
Jan 1, 1 - Dec 31, 3999
⁠
⁠
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
⁠
⁠

⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.