Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question Set 1. National Copper and Smelting is considering adding production capacity for mining and smelting of copper for the upcoming year. The three strategies

Question Set 1. National Copper and Smelting is considering adding production capacity for mining and smelting of copper for the upcoming year. The three strategies under consideration are:

Large Facility: Add machines to mine 20% more ore

Medium Facility: Add capacity to mine 10% more ore

Small Facility: Add capacity to mine 5% more ore

No Change: Do not add any additional capacity

The outcomes of the possible strategies (in millions of dollars) depend on copper prices.

Copper Prices

Strategy

$200/ton

$220/ton

$240/ton

$260/ton

Large Facility

-150

60

45

160

Medium Facility

-25

20

25

100

Small Facility

-70

80

30

90

No Change

-30

50

50

85

For the following questions, you will use Excel to identify the best strategy according to various criteria. You only need to perform the necessary calculations to show which one is best. For example, the first question is for maximax. You need to set up formulas to find the maximum payoff for each strategy and to then find the highest value among them. However, once you have calculated that highest value, you can just type in the corresponding strategy without any further Excel calculations.

1. What would be National Coppers decision using the maximax criterion? (3pts)

2. What would be National Coppers decision using the maximin criterion? (3pts)

3. What would be National Coppers decision using the Laplace criterion? (3pts)

4. What would be National Coppers decision using the minimax regret criterion? It may be helpful to construct a regret table for this problem. (6pts)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions