MG30 Case Study Writing Assignment You are the Plant Manager at Incline Electronics which produces three different products in a plant that is open 40 hours per week. Each product requires the following processing times in hours) on each of three machines. Each machine must be run by one of 19 cross-trained workers who are each available 35 hours per week. The plant has 10 type 1 machines available, 6 type 2 machines available, and type 3 machines available. Products 1, 2 and 3 contribute , si and $150, respectively, in marginal profit per unit produced One of your staff members developed the following excel optimal production plan with Sensitivity Analysis Report. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Pride) with recommendation as to how this optimal production plan can be improved to increase the Total Profit. Your recommendation should Identify and explain 5 options. You can provide a n option for bonus points). These five options must be based only with information present in the excel production plan and Sensitivity Analysis Report. The business memo should be 1 to 2 pages. Proper style and grammar are worth 25% of the grade. Your recommendations are worth 75%. Processing Time (hours per unit) Available Workers Needes 30 9 Machine 1 10 Machine 2 Variable Car Allowable Final Value Reduced Cost Objective Coefficient Allowable increase 3835 Quantity Product 1 SCS Quantity Product 2 SO55 Quantity Products Constraints Final Shadow Constraint Allowable Allowable Cell Name SE Machine 1 Hours Used SE$10 Machine 2 Used SE$t1 Machine 3 Hours Used $E$12. Total Labor Hours Used MG30 Case Study Writing Assignment You are the Plant Manager at Incline Electronics which produces three different products in a plant that is open 40 hours per week. Each product requires the following processing times in hours) on each of three machines. Each machine must be run by one of 19 cross-trained workers who are each available 35 hours per week. The plant has 10 type 1 machines available, 6 type 2 machines available, and type 3 machines available. Products 1, 2 and 3 contribute , si and $150, respectively, in marginal profit per unit produced One of your staff members developed the following excel optimal production plan with Sensitivity Analysis Report. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Pride) with recommendation as to how this optimal production plan can be improved to increase the Total Profit. Your recommendation should Identify and explain 5 options. You can provide a n option for bonus points). These five options must be based only with information present in the excel production plan and Sensitivity Analysis Report. The business memo should be 1 to 2 pages. Proper style and grammar are worth 25% of the grade. Your recommendations are worth 75%. Processing Time (hours per unit) Available Workers Needes 30 9 Machine 1 10 Machine 2 Variable Car Allowable Final Value Reduced Cost Objective Coefficient Allowable increase 3835 Quantity Product 1 SCS Quantity Product 2 SO55 Quantity Products Constraints Final Shadow Constraint Allowable Allowable Cell Name SE Machine 1 Hours Used SE$10 Machine 2 Used SE$t1 Machine 3 Hours Used $E$12. Total Labor Hours Used