# 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.