Explore BrainMass

# A plant can manufacture four different products

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

For each of the following changes, calculate the new optimal profit (do not make any additional Solver runs).

4. A plant can manufacture four different products: A, B, C, and D in any combination. Each product requires time on each of four machines in minutes per pound of product, as shown in the following table. Each machine is available 60 hours per week. The maximum demand and profit margins for each product are also provided in the table.

Below are the solution and sensitivity report obtained using Solver.

For each of the following changes, calculate the new optimal profit (do not make any additional Solver runs). For each answer, indicate what numbers you used from the report and how you used them in getting your answer. Answer each question independently from the others.

a) The price of product B increases by 10%.

b) The price of D decreases by 15%.

c) 10% of the available time on Machine 2 is lost.

d) At least 1 unit of product A must be sold.

e) The time available on each machine goes down by 20% (That is, 20% on Machine 1 is lost, 20% on Machine 2 is lost, and so on).

https://brainmass.com/statistics/descriptive-statistics/plant-manufacture-four-different-products-165759

#### Solution Preview

4. A plant can manufacture four different products: A, B, C, and D in any combination. Each product requires time on each of four machines in minutes per pound of product, as shown in the following table. Each machine is available 60 hours per week. The maximum demand and profit margins for each product are also provided in the table.

Below are the solution and sensitivity report obtained using Solver.

For each of the following changes, calculate the new optimal profit (do not make any additional Solver runs). For each ...

#### Solution Summary

The expert examines plans manufactured for four different products. A sensitivity report obtained using a solver is determined.

\$2.49