Question:
Linear programming to find maximum profit using excel solver
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
CONTROL VALVE METERING PUMP HYDRAULIC CYLINDER
assembly time(min) 45 20 30
testing time (min) 20 15 25
Profit/Unit $372 $174 $288
Maximum Sales 20 50 45
Minimum Sales 5 12 22
A total of 3150 minutes of assembly time and 2100 minutes of testing time are available next week
Develop[ a linear optimization model to determine how many pieces of equipment the company should make next week to maximize profit contribution