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