For Worley Fluid Supplies (Problem 13.51), solve the model using auxiliary variables. Obtain the Solver Sensitivity Report, and answer the following: 

a. Explain the sensitivity information for the objective coefficients. What happens if the profit on hydraulic cylinders is decreased by $10? 

b. Due to scheduled maintenance, the assembly time is expected to be only 2,900 minutes. How will this affect the solution? 

c. A worker in the testing department has to take a personal leave because of a death in the family and will miss two days (16 hours of work time). How will this affect the optimal solution?

Data from Problem 13.51

Worley Fluid Supplies produces three types of fluid handling equipment: control valves, metering pumps, and hydraulic cylinders. All three products require assembly and testing before they can be shipped to customers. The following data provide the number of minutes that each type requires in assembly and testing, the profit, and sales estimates 

A total of 3,000 minutes of assembly time and 2,100 minutes of testing time are available next week. Develop and solve a linear optimization model to determine how many pieces of equipment the company should make next week to maximize profit contribution. 

Transcribed Image Text:

Assembly time (min) Testing time (min) Profit/unit Maximum sales Minimum sales Control Metering Valve Pump 45 20 20 15 $372 $174 20 50 12 5 Hydraulic Cylinder 30 25 $288 45 22