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.

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

b. Implement your model on a spreadsheet and find an optimal solution.

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

d. Due to scheduled maintenance, the assembly time is expected to be only 3,000 minutes. How will this affect the solution?

e. A worker in the testing department has to take a personal leave because of a death in the family and will miss 3 days (24 hours). How will this affect the optimal solution?

f. Use the auxiliary variable technique to handle the bound constraints and generate all shadow prices.

Transcribed Image Text:

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