Linear programming to find maximum profit using excel solver
Not what you're looking for? Search our solutions OR ask your own Custom question.
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
© BrainMass Inc. brainmass.com December 24, 2021, 11:57 pm ad1c9bdddfhttps://brainmass.com/math/optimization/linear-programming-maximum-profit-excel-solver-624172
SOLUTION This solution is FREE courtesy of BrainMass!
Please check attachment
© BrainMass Inc. brainmass.com December 24, 2021, 11:57 pm ad1c9bdddf>https://brainmass.com/math/optimization/linear-programming-maximum-profit-excel-solver-624172