2. Using the Fitter sales forecast for January through December given in the table below, develop a spreadsheet for sales and operations planning for the whole year. Use the format of the spreadsheet similar to the one shown in Figure 4-5. The highest level of capacity utilization is 95 percent in any month. In case the demand is higher, inventory has to be built up in the previous months to deal with the increased demand in certain month. (15 marks) S&OP Dec. Jan. Feb. March April May June July Aug. Sep. Oct. Nov. Dec. 1) Sales forecast 5906 5998 6061 6318 6476 7128 7097 6517 6401 6187 6133 5987 2) Production plan 3) Inventory 100 21 20 23 21 21 22 20 23 21 21 21 20 21 4) Working days 5) Capacity (shipping cases) 6) Utilization 7) NRG-A (cases) 70% 8) NRG-B (cases) 30% 2. Using the Fitter sales forecast for January through December given in the table below, develop a spreadsheet for sales and operations planning for the whole year. Use the format of the spreadsheet similar to the one shown in Figure 4-5. The highest level of capacity utilization is 95 percent in any month. In case the demand is higher, inventory has to be built up in the previous months to deal with the increased demand in certain month. (15 marks) S&OP Dec. Jan. Feb. March April May June July Aug. Sep. Oct. Nov. Dec. 1) Sales forecast 5906 5998 6061 6318 6476 7128 7097 6517 6401 6187 6133 5987 2) Production plan 3) Inventory 100 21 20 23 21 21 22 20 23 21 21 21 20 21 4) Working days 5) Capacity (shipping cases) 6) Utilization 7) NRG-A (cases) 70% 8) NRG-B (cases) 30%