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 6h 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%. A Incline Electronics Quantity 6 Unit Profit Product 1 6.67 $90.00 Product 41.25 $120.00 Product 3 9.17 $150.00 Total Profit $6,925 Processing Time (hours per unit) 105 400 9 Machine 1 10 Machine 2 11 Machine 3 12 Total Labor Hours Used Hours Available Workers Needed 3.0000 240 240 6.8571 320 1 320 9.1429 665 665 9 12 12 Variable Cells Name Final Value 6.67 41.25 9.17 Reduced Cost 0 Cell $B$5 Quantity Product 1 $C$5 Quantity Product 2 $D$5 Quantity Product 3 Objective Allowable Coefficient Increase 900 120 6.67 150 30 Allowable Decrease 3.75 0 0 30 Constraints Name Shadow Price 0 Cell $E$9 Machine 1 Hours Used $E$10 Machine 2 Hours Used $E$11 Machine 3 Hours Used $E$12 Total Labor Hours Used Final Value 105 240 320 665 Constraint Allowable R.H. Side Increase 400 1E+30 240 6.67 320 3.33 6 65 55 Allowable Decrease 295 18.33 27.5 15 0 5