This is out of the book concepts in Enterprise Resource Planning and this is exercise 4.2
B M R EXERCISE 4.2 Forecast to SOP Rough Cut Aggregate Plan Sales Forecasting Sales Volume Dec. Jan Feb Mar April May June July Aug. Sept. Oct. Nov. Dec. 5734 5823 5884 6134 6327 6215 6007 5954 Previous Year's Sales (in cases) Previous Year Promotion (in cases) Previous Year's Base-Line Sales (in cases) 6587 300 6287 6735 300 6435 6702 200 6502 5813 given on pp 85 given on pp 85 for Exercise 4.2 5813 previous year's sales - previous year's promotion 5734 5823 5884 6134 6327 6215 6007 5954 3% 175 172 5906 177 6061 184 6318 189 6476 5998 Growth Projected Base-Line Sales (in cases) Promotion Planned (in cases) Sales Forecast in cases) 193 6628 500 7128 195 6697 400 7097 previous year's base-line sales *% of growth (.03) previous year's base-line sales + growth given on pp 85 projected base-line sales promotion planned 5906 5998 6061 6318 6476 100 Sales and Operations Planning 1) Sales Forecast 2) Production Plan 3) Inventory 4) Working Days 5) Capacity (shipping cases) 6) Utilization 7) NRG-A (cases) 8) NRG-B (cases) 5906 5906 100 21 6999 84% 6318 6318 100 21 6999 90% 6900 150 23 6476 6550 247 21 6999 94% 6500 100 21 5998 5998 100 20 6666 90% 4199 1799 6250 100 21 6061 6061 100 23 7666 79% 4243 1818 6000 100 20 7128 6950 96 22 7333 95% 4865 2085 7097 7000 175 20 6666 105% 4900 2100 taken from last line above - Sales Forecast 5900 given on pp 86 for Exercise 4.2 100 given on pp 86 for Exercise 4.2 21 6 mos given, second 6 mos filled in from Exercise 4.3 production capacity (given below as 333.3 cases per day) * working days (#4) production plan (#2)/capacity (#5) production plan (#2) * 70% (percentage of product group given in B21) production plan (#2) * 30% (percentage of product group given in B22) 70% 4134 1772 4423 1895 4585 1965 30% Production Capacity 333.3 Cases per day B M R EXERCISE 4.2 Forecast to SOP Rough Cut Aggregate Plan Sales Forecasting Sales Volume Dec. Jan Feb Mar April May June July Aug. Sept. Oct. Nov. Dec. 5734 5823 5884 6134 6327 6215 6007 5954 Previous Year's Sales (in cases) Previous Year Promotion (in cases) Previous Year's Base-Line Sales (in cases) 6587 300 6287 6735 300 6435 6702 200 6502 5813 given on pp 85 given on pp 85 for Exercise 4.2 5813 previous year's sales - previous year's promotion 5734 5823 5884 6134 6327 6215 6007 5954 3% 175 172 5906 177 6061 184 6318 189 6476 5998 Growth Projected Base-Line Sales (in cases) Promotion Planned (in cases) Sales Forecast in cases) 193 6628 500 7128 195 6697 400 7097 previous year's base-line sales *% of growth (.03) previous year's base-line sales + growth given on pp 85 projected base-line sales promotion planned 5906 5998 6061 6318 6476 100 Sales and Operations Planning 1) Sales Forecast 2) Production Plan 3) Inventory 4) Working Days 5) Capacity (shipping cases) 6) Utilization 7) NRG-A (cases) 8) NRG-B (cases) 5906 5906 100 21 6999 84% 6318 6318 100 21 6999 90% 6900 150 23 6476 6550 247 21 6999 94% 6500 100 21 5998 5998 100 20 6666 90% 4199 1799 6250 100 21 6061 6061 100 23 7666 79% 4243 1818 6000 100 20 7128 6950 96 22 7333 95% 4865 2085 7097 7000 175 20 6666 105% 4900 2100 taken from last line above - Sales Forecast 5900 given on pp 86 for Exercise 4.2 100 given on pp 86 for Exercise 4.2 21 6 mos given, second 6 mos filled in from Exercise 4.3 production capacity (given below as 333.3 cases per day) * working days (#4) production plan (#2)/capacity (#5) production plan (#2) * 70% (percentage of product group given in B21) production plan (#2) * 30% (percentage of product group given in B22) 70% 4134 1772 4423 1895 4585 1965 30% Production Capacity 333.3 Cases per day
