JMA Manufacturing is considering expanding the company's manufacturing capacity at its New Bern plant. Engineering has developed estimates for three expansion plans. A small expansion will cost $1 million. A medium-sized expansion will cost $2 million, while a major expansion will cost $5 million. The income generated by the expansion will depend on the demand for JMA's product. Marketing has developed estimates for the net present value (not including the fixed cost of the capacity expansion) associated with each of the expansion alternatives based on low and high demand scenarios. If JMA decides to go with the small expansion, marketing estimates the company can earn $0.5 million if demand is low and $2 million if demand is high. With the medium expansion, income will be $2 million (low demand) and $3 million (high demand). With the large expansion, marketing estimates income will be $4 million if demand is low and $8 million if

Algebra for College Students
10th Edition
ISBN:9781285195780
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Jerome E. Kaufmann, Karen L. Schwitters
Chapter12: Algebra Of Matrices
Section12.CR: Review Problem Set
Problem 37CR
icon
Related questions
Topic Video
Question
JMA Manufacturing is considering expanding the company's manufacturing capacity
at its New Bern plant. Engineering has developed estimates for three expansion plans.
A small expansion will cost $1 million. A medium-sized expansion will cost $2 million,
while a major expansion will cost $5 million.
The income generated by the expansion will depend on the demand for JMA's
product. Marketing has developed estimates for the net present value (not including
the fixed cost of the capacity expansion) associated with each of the expansion
alternatives based on low and high demand scenarios. If JMA decides to go with the
small expansion, marketing estimates the company can earn $0.5 million if demand is
low and $2 million if demand is high. With the medium expansion, income will be $2
million (low demand) and $3 million (high demand). With the large expansion,
marketing estimates income will be $4 million if demand is low and $8 million if
demand is high.
Marketing estimates there is a one in three chance the company will experience high
demand.
Use Excel to create a sensitivity analysis chart that plots the expected outcome for
each alternative over the entire range (0% through 100%) of high demand
probabilities. If the probability of high demand is smaller than 33%, which alternative
would be the optimal choice using the Expected Value criterion?
Transcribed Image Text:JMA Manufacturing is considering expanding the company's manufacturing capacity at its New Bern plant. Engineering has developed estimates for three expansion plans. A small expansion will cost $1 million. A medium-sized expansion will cost $2 million, while a major expansion will cost $5 million. The income generated by the expansion will depend on the demand for JMA's product. Marketing has developed estimates for the net present value (not including the fixed cost of the capacity expansion) associated with each of the expansion alternatives based on low and high demand scenarios. If JMA decides to go with the small expansion, marketing estimates the company can earn $0.5 million if demand is low and $2 million if demand is high. With the medium expansion, income will be $2 million (low demand) and $3 million (high demand). With the large expansion, marketing estimates income will be $4 million if demand is low and $8 million if demand is high. Marketing estimates there is a one in three chance the company will experience high demand. Use Excel to create a sensitivity analysis chart that plots the expected outcome for each alternative over the entire range (0% through 100%) of high demand probabilities. If the probability of high demand is smaller than 33%, which alternative would be the optimal choice using the Expected Value criterion?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Optimization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Algebra for College Students
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning