12-Month S&OP Planning Spreadsheet
Months
|
Data Category |
YTD |
-3 |
-2 |
-1 |
Curr |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
Annual Totals |
10 |
11 |
12 |
|
Financial Reporting |
|||||||||||||||||
|
Business Plan Dollars |
300 |
100 |
100 |
100 |
100 |
110 |
110 |
110 |
110 |
120 |
120 |
120 |
120 |
1320 |
130 |
130 |
130 |
|
Actual Sales / Projected Plan Total Dollars |
330 |
120 |
110 |
100 |
100 |
110 |
110 |
110 |
110 |
120 |
120 |
120 |
120 |
1350 |
130 |
130 |
130 |
|
% |
110 |
120 |
110 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
102 |
100 |
100 |
100 |
|
Forecast |
|||||||||||||||||
|
Previous Forecast - Total Units |
30 |
10 |
10 |
10 |
10 |
11 |
11 |
11 |
11 |
12 |
12 |
12 |
12 |
132 |
13 |
13 |
13 |
|
Actual Sales / New Forecast - Total Units |
33 |
12 |
11 |
10 |
10 |
11 |
11 |
11 |
11 |
12 |
12 |
12 |
12 |
135 |
13 |
13 |
13 |
|
% |
110 |
120 |
110 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
102 |
100 |
100 |
100 |
|
Production Plan |
|||||||||||||||||
|
Previous Production Plan |
33 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
132 |
13 |
13 |
13 |
|
Actual Production / New Production Plan |
30 |
9 |
10 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
129 |
13 |
13 |
13 |
|
% |
82 |
91 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
98 |
100 |
100 |
100 |
|
|
Inventory Plan |
|||||||||||||||||
|
Total Inventory Previous Plan |
|
18 |
19 |
20 |
21 |
21 |
21 |
21 |
21 |
20 |
19 |
18 |
17 |
17 |
17 |
17 |
|
|
Total Actual Inventory / Current Inventory Plan |
17 |
14 |
13 |
14 |
15 |
15 |
15 |
15 |
15 |
14 |
13 |
12 |
11 |
11 |
11 |
11 |
|
|
Monthly % |
78 |
68 |
70 |
71 |
71 |
71 |
71 |
71 |
70 |
68 |
67 |
65 |
65 |
65 |
65 |
||
|
Weeks of Inventory |
7 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
5 |
5 |
4 |
4 |
4 |
4 |
4 |