For problem 3 (Mike's metal manufacturing problem), what do the values in the "shadow price" column tell us? Would Mike's profit change if he had more than 480 hours of machine time each week? If so, how much would his profit increase (initially) per extra hour of machine time available? i. ii. Would Mike's profit change if he had more than 400 hours of polishing ii Would Mike's profit change if he had more than 400 hours of assembly iv. Would Mike's profit change if the contract for product I required him to time each week? If so, how much would his profit increase (initially) per extra hour of polishing time available? time each week? If so, how much would his profit increase (initially) per extra hour of assembly time available? produce more than 50 units of product I each week? If so, how much would his profit decrease (initially) per extra unit of product I that he is required to produce? Would Mike's profit change if he were allowed to sell more than 25 units of product IV each week? If so, how much would his profit increase (initially) per extra unit of product IV that he is allowed to produce? v. For each of the five problems, print a sensitivity analysis report by clicking "Sensitivity" in the "Reports" menu on the right-hand side of the "Solver Results" window immediately after you have clicked "solve." Attach a print-out of the sensitivity report for each problem. Note that the first table in the sensitivity report shows how changing the objective fcn. coeffs. affects the optimal solution, and the second table shows how changing the right-hand sides affects the optimal solution and optimal objective value 29 3 Mike's Metal Manufacturing Firm problem units product 1 units product 2 units product 3 units product 4 current guess 50 0 145 10 curr 1250 6 6 objective coeffs curr RHS euired RHS machining const. coeffs polishing const. coeffs assembling const. coeffs product 1 contract product 2 and 3 contract product 4 sales limit 480 370 400 50 145 10 480 400 400 50 100 25 0 0 0 For problem 3 (Mike's metal manufacturing problem), what do the values in the "shadow price" column tell us? Would Mike's profit change if he had more than 480 hours of machine time each week? If so, how much would his profit increase (initially) per extra hour of machine time available? i. ii. Would Mike's profit change if he had more than 400 hours of polishing ii Would Mike's profit change if he had more than 400 hours of assembly iv. Would Mike's profit change if the contract for product I required him to time each week? If so, how much would his profit increase (initially) per extra hour of polishing time available? time each week? If so, how much would his profit increase (initially) per extra hour of assembly time available? produce more than 50 units of product I each week? If so, how much would his profit decrease (initially) per extra unit of product I that he is required to produce? Would Mike's profit change if he were allowed to sell more than 25 units of product IV each week? If so, how much would his profit increase (initially) per extra unit of product IV that he is allowed to produce? v. For each of the five problems, print a sensitivity analysis report by clicking "Sensitivity" in the "Reports" menu on the right-hand side of the "Solver Results" window immediately after you have clicked "solve." Attach a print-out of the sensitivity report for each problem. Note that the first table in the sensitivity report shows how changing the objective fcn. coeffs. affects the optimal solution, and the second table shows how changing the right-hand sides affects the optimal solution and optimal objective value 29 3 Mike's Metal Manufacturing Firm problem units product 1 units product 2 units product 3 units product 4 current guess 50 0 145 10 curr 1250 6 6 objective coeffs curr RHS euired RHS machining const. coeffs polishing const. coeffs assembling const. coeffs product 1 contract product 2 and 3 contract product 4 sales limit 480 370 400 50 145 10 480 400 400 50 100 25 0 0 0