Linear programming to find maximum profit using excel solver
Not what you're looking for?
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
Purchase this Solution
Solution Summary
The solution gives detailed steps on solving a linear programming problem to find maximum profit using excel solver.
Purchase this Solution
Free BrainMass Quizzes
Probability Quiz
Some questions on probability
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.