Questions to Ac 1 Complete Exhibit 1, the RCCP with the current MPS in excel. (6 mark) 2 Whut observations and recommendations do you have based on the RCCP? Be specific utlang ehibit 1 (Le, idently over/under quantities) (4) Ps add your answer to space provided in Lockdown browser for this question or clearly on this spreadsheet 3 Rebalance based on your recommendations in excel. (9 marks) 4 Given the current MPS and the facts from the case, what are the two root cause ives or problems that need to be addressed to fix Galaxy Furniture's problems in customer service? Justify your answer: (maks) Ps add your answer to space provided in Lockdown browser for this question or clearly on this spreadsheet 5 What are your recommendations to improve customer delivery performance for Galaxy Fumburg? Pase be sure to include any procedural changes, who would be involved, how these will be implemented and how you will measure succes an Hint-Don't tell me again how you will rebalance-how will you fix the problems so that going forward we meet customer demand Ps add your answer to space provided in Lockdown browser for this question or clearly on this spreadsheet Sales bemes Gerent MPS RCCP Ogal MPS " 14 Prod A " 30 25 30 100 29 Load Capacity Available 12 " 34 Under (Over Product SHS/Unit Efficiency 33 90% 1% 25 36% 25 c 2.4 37% 1% Production Planning 031-32823 RCCP 033 $23 14 Total " 14 " E 100% 1 Complete Exhibit 1, the RCCP with the current MPS in excel (6 marks) 2 What observations and recommendations do you have based on the RCCP? Be specific using exhibit 1 (ie, identify overfunder quantities) (4) Pls add your answer to space provided in Lockdown browser for this question or clearly on this spreadsheet 3 Rebalance based on your recommendations in excel. (9 marks) Given the curent MPS and the facts from the case, what are the two root cause issues or problems that need to be addressed to fix Galaxy Fomit's problems in customer service? Justify your answer (4 mark) Pls add your answer to space provided in Lockdown browser for this question or clearly on this spreadsheet 3 What are your recommendations to improve customer delivery performance for Galaxy Furniture? Pleme be sure to include any procedural changes, who would be involved, how these will be implemented and how you will measure comm Hint-Don't tell me again how you will rebalance-how will you fix the problems so that going forward we meet customer demand Pls add your answer to space provided in Lockdown browser for this question or clearly on this spreadsheet Galaxy Fume Corrent MPS-Exhibit Orginal MPS Week 17 33 14 35 Total " Comective Action to Rebe 24 Product A D 45 M ". M 21 50 17 " " " M " " " Capacity Available Under (Over) Data Product Efficiency Somp 33 2% 3.1 97% IN RCCP 033523 Production Planning 031-32 523 Ready Accessibility: Good to go