60.1K

Verified Solution

Link Copied!

D Question 14 20 pts [20 points) PerezCPU manufactures two types of computers (desktops and laptops) using two operations A desktop requires 2 hours of operation 1 and 1 hour of operation 2. . For laptops, one unit requires 1 hour of operation 1 and 3 hours of operation 2 The revenues per unit of desktops and laptops are $30 and $20, respectively. The total daily processing time available for each operation is 8 hours. Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient increase Decrease $C$13 desktops 3.2 0 30 10 23.33333333 $0$13 laptops 1.6 20 70 5 0 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$7 operation 1 8 14 8 8 5.333333333 SF$8 operation 2 8 2 8 16 The optimal objective function value for this problem is $128. Using the sensitivity report generated using Excel answer the following questions 1. Suppose that the capacity of machine 1 is increased to 20 hours, how will this increase affect the optimum revenue? Explain and do not find new opalva 2. If the capacity of operation 1 is increased from 8 hours to 13 hours, how will this increase impact the optimum revenue! Explain and find the new optimal 3. A suggestion is made to increase the capacities of operations 1 and 2 at the additional cost of $10/ for each operation is this advisable? Explain 4.1 PerexCPU can increase the capacity of both operations, which operation should receive priority? Explain Upload Choose a File Question 14 20 pts 120 points) Pere CPU manufactures two types of computers (desktops and laptops) using two operations A desktop requires 2 hours of operation 1 and 1 hour of operation 2 . For laptops, one unit requires 1 hour of operation 1 and 3 hours of operation 2 The revenues per unit of desktops and laptops are $30 and $20, respectively The total daily processing time available for each operation is 8 hours, Sensitivity Report: Variable Cells Cell Name $C$13 desktops $0$13 laptops Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 3.2 0 30 10 23.33333333 16 0 20 70 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SF$7 operation1 8 14 8 8 5.333333333 SFS8 operation 2 2 8 16 The optimal objective function value for this problem is $128. Using the sensitivity report generated using Excel answer the following questions 1. Suppose that the capacity of machine is increased to 20 hours how will this increase affect the optimum revenue Explain and do not find new optimal value 2. If the capacity of operation 1 increased from 8 hours to 13 hours, how will this increase impact the optimum revenue? Explain and find the new optimal value 3. A suggestion is made to increase the capacities of operations 1 and 2 at the additional cost of $10/hr for each operation. Is this advisable? Explain 4.1 PerezCPU can increase the capacity of both operations, which operation should receive priority? Explain

Answer & Explanation Solved by verified expert

See Answer