Purchase Solution

Linear Programming : Maximizing Profit

Not what you're looking for?

Ask Custom Question

Furniture Unlimited has the capability to manufacture desks, cabinets, and chairs. In order to manufacture these product, it must rent the appropriate equipment at a weekly cost of $2,000 for the desks, $2,500 for the cabinets, and $1,500 for the chairs. The labor and material requirements for each product are shown iii the following table, along with the sellin price and variable cost to manufacture.
[TABLE]
There are 2500 labor hours and 4,000 square feet of lumber available each week. Determine the product mix that maximizes weekly profit.

Please see the attached file for the fully formatted problems.

Attachments
Purchase this Solution

Solution Summary

An LP problem is solved using EXCEL.

Purchase this Solution


Free BrainMass Quizzes
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.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Probability Quiz

Some questions on probability