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
Worst case
-5%
Baseline
10%
Best case
25%
There are no rows in this table

Selected scenario for the model 👉

Notice that when you change it, the "Qty Scenario Chosen" column changes below

🔮 Forecast Data


Filter the table by:
Product Type =
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
23,000
21,850
25,300
28,750
25,300
12,000
11,400
13,200
15,000
13,200
6,000
5,700
6,600
7,500
6,600
6,000
5,700
6,600
7,500
6,600
6,000
5,700
6,600
7,500
6,600
1,000
950
1,100
1,250
1,100
2,000
1,900
2,200
2,500
2,200
July 2019
7
10,000
9,500
11,000
12,500
11,000
4,000
3,800
4,400
5,000
4,400
2,000
1,900
2,200
2,500
2,200
4,000
3,800
4,400
5,000
4,400
2,000
1,900
2,200
2,500
2,200
100
95
110
125
110
5,000
4,750
5,500
6,250
5,500
August 2019
7
8,000
7,600
8,800
10,000
8,800
6,000
5,700
6,600
7,500
6,600
4,000
3,800
4,400
5,000
4,400
7,000
6,650
7,700
8,750
7,700
2,000
1,900
2,200
2,500
2,200
100
95
110
125
110
100
95
110
125
110
September 2019
7
100
95
110
125
110
10,000
9,500
11,000
12,500
11,000
10,000
9,500
11,000
12,500
11,000
6,000
5,700
6,600
7,500
6,600
10,000
9,500
11,000
12,500
11,000
3,000
2,850
3,300
3,750
3,300
1,000
950
1,100
1,250
1,100
October 2019
7
1,000
950
1,100
1,250
1,100
11,000
10,450
12,100
13,750
12,100
10,000
9,500
11,000
12,500
11,000
6,000
5,700
6,600
7,500
6,600
9,000
8,550
9,900
11,250
9,900
6,000
5,700
6,600
7,500
6,600
1,000
950
1,100
1,250
1,100
November 2019
7
1,000
950
1,100
1,250
1,100
12,000
11,400
13,200
15,000
13,200
10,000
9,500
11,000
12,500
11,000
5,000
4,750
5,500
6,250
5,500
15,000
14,250
16,500
18,750
16,500
4,000
3,800
4,400
5,000
4,400
1,000
950
1,100
1,250
1,100
December 2019
7
10
10
11
13
11
7,000
6,650
7,700
8,750
7,700
5,000
4,750
5,500
6,250
5,500
3,000
2,850
3,300
3,750
3,300
5,000
4,750
5,500
6,250
5,500
1,000
950
1,100
1,250
1,100
1,000
950
1,100
1,250
1,100

👉Next up:


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.