1. 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 ( text book-Concept in Enterprise Resource Planning). 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. March April May July 6476 7128 S&OP Dec. Jan. Feb. June Aug. Sep. Oct. Nov. Dec. 1) Sales forecast 5906 5998 6161 6421 6897 6517 6401| 6329 6133 5987 2) Production plan 3) Inventory 4) Working days 100 21 20 23 21 21 22 20 23 21 21 20 21 5) Capacity (shipping cases) 6) Utilization 7) NRG-A (cases) 70% 8) NRG-B (cases) 30% Please select the correct answers. Select one or more: a. The inventory level for March and Aug are 388 and 93 respectively b. The inventory level for March and Aug are 427 and 102 respectively C. The production plan for April and Sep are 6539 and 6499 respectively. d. The inventory level for March and Aug are 457 and 128 respectively e. The production plan for April and Sep are 6571 and 6504 respectively. f. The production plan for April and Sep are 6489 and 6344 respectively. g. If the NRG-A (case) is 4561 in Aug, then the Utilization percentage should be 88 percent. h. If the NRG-A (case) is 4561 in Aug, then the Utilization percentage should be 82.7 percent. i. The production plan for April and Sep are 6649 and 6404 respectively. BACK TO TOP j. If the NRG-A (case) is 4561 in Aug, then the Utilization percentage should be 85 percent.