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