MG305 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 8 type 3 machines available. Products 1, 2, and 3 contribute $90, $120, 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 6 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%. Incline Electronics 5 Quantity 6 Unit Profit Product 1 6.67 $90.00 Product 2 41.25 $120.00 Product 3 9.17 $150.00 Total Profit $8,025 Processing Time (hours per unit) 9 Machine 1 10 Machine 2 11 Machine 3 12 Total Labor Hours Used Hours Available Workers Needed 105 3.0000 240 6.8571 320 9.1429 665 Variable Cells Final Value Reduced Cost Objective Coefficient Allowable increase Allowable Decrease 3.75 Call $B$5 $C$5 $D$5 Name Quantity Product 1 Quantity Product 2 Quantity Product 3 41.25 120 150 30 9.17 Constraints Allowable Allowable Shadow Price Constraint RH. Side 400 Decrease Final Value 105 240 295 Cell Name $E$9 Machine 1 Hours Used SE$10 Machine 2 Hours Used SES11 Machine 3 Hours Used $E$12 Total Labor Hours Used 1E30 6.67 0 320 665 55