Purchase Solution

Linear programming to find maximum profit using excel solver

Not what you're looking for?

Ask 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

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.