Question: please answer Q11 the sensitivity report is attached 9. A fitter produces two types of fitting products product A and product Busing a cutting machine

please answer Q11 the sensitivity report is attached
please answer Q11 the sensitivity report is
please answer Q11 the sensitivity report is
9. A fitter produces two types of fitting products product A and product Busing a cutting machine (cutter) and a grinding machine (grinder). Product A requires 4 hours of the cutter and 8 hours of the grinder; product B requires 6 hours of the cutter and 4 hours of the grinder. The cutter has processing hours of at most 300 hours and at least 200 hours. The grinder has maximum processing time of 250 hours. The cost involved in the production of product A is 8 and of product B is 12. The fitter expects that the combined production for products A and B must total at least 50 units. The fitter wants to determine the number of units of product A (x1) and product B(x2) that will minimize the cost of manufacturing. a. Formulate a linear programming model for this problem. b. Transform this model into a standard form. 11. Solve the linear programming model formulation in Problem 9 for the fitter by using the computer. a. If the fitter can obtain additional hours either to cutter or grinder (but not both), which should he select? How much? Explain your answer. b. Identify the sensitive ranges for the objective function coefficients and for the constraint quan-tity values. Then explain the sensitivity range for the demand for the products. c. What is the impact of optimal solution if the demand is reduced to 45? 6 Variable Calls Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 12.5 0 8 4 15-30 37.5 0 12 1E+30 8 Cell Name $B$8 variables x1 10 $C$8 variables x2 11 12 Constraints 13 14 Cell Name 15 $D$4 usage 16 $D$5 usage 17 $D$6 usage 18 $D$7 usage 19 20 21 Final Value 50 275 275 250 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 16 50 3.125 9.375 0 200 75 1E+30 0 300 1E+30 25 -1 250 150 50

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!