Question: * ( Refer to the previous worksheet. ) A kitchenware manufacturer has set up an LP problem to determine how many of type A (
Refer to the previous worksheet.A kitchenware manufacturer has set up an LP problem to determine how many of type A Xa and type B X cups to produce to maximize the total profit. The LP formulation and the sensitivity report generated by Excel Solver are given on the right.a Determine the optimal solution and the maximized total profit.b Write the Excel formula set in the cell of the total profit suppose that the objective function coefficients, $ and $ are stored in cells C and D respectivelyc Without solving the LP problem again, find the optimal solution and the maximized total profit if both the unit profits of A and B become $dFind the shadow price of the MOQ constraint KeWithout solving the LP problem again, find the maximized total profit if the RHS of the Cutting, Assembly and MOQ constraints become hours, hours and respectively. Discuss whether the optimal solution remains unchanged.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
