Purchase Solution

A plant can manufacture four different products

Not what you're looking for?

Ask Custom Question

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

Attachments
Purchase this Solution
Solution Summary

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

Solution Preview

Please see the attached file.

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 provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • The Midland Tool Company

    on four heavy presses of different sizes and different requirements.

  • Unionized employees

    The plants, however, are owned by different companies, Company A and Company B. Plant A is the only plant in Company A that manufactures refrigerators while in Company B there are a number of plants manufacturing refrigerators (including Plant B).

  • Accounting Fix, Variable, Direct and Indirect Cos.

    An indirect cost for the Optimist line is the: shift supervisor for the Optimist line Coaching tip: Plant supervisor is indirect for all products, not just optimist line 6.

  • Operations Management Question

    Stationary layout will be most suitable for heavy products while line layout will be best for the manufacture for the light products because small and light products can be moved from one machine to another very easily and, therefore, more attention can

  • Calculating Product Profit From Cost and Revenue Data

    A. Product A. B. Product B. C. Product C. D. Product D. We are not given any information about fixed costs so we must assume they are constant across each of the four products therefore we can disregard them.

  • Preparing Accounting Performance Reports

    The plant has two operating departments and one service department. The refrigerator and dishwasher operating departments manufacture different products and have their own managers.

  • Manufacturing decision-assembling,manufacture or outsourcing

    If the firm decides to manufacture all the products on its own without relying on the customers, and if total cost of manufacturing all the four components comes to $ 125 for manufacture of one unit of finished product A, then firm can decide to purchase

  • Cost Association with Starting Company pricing Models

    The Company has installed the plant and equipment (the cost of which is $600000) which can manufacture 100000 units of Product "A" in a financial year.

  • Activity-Based Costing (ABC) and traditional two-stage method

    ., the overheads are allocated to different products in direct proportion to the resources consumed for the manufacture of respective products. However, ABC costing is costly to maintain.

View More Related Solutions