# Fix And Repair A Corrupted Excel File

QUESTION 10 | Slaggert Systems is considering becoming certified to the ISO 9000 series of quality standards. . | |||||||||||||||

Becoming certified is expensive, but the company could lose a substantial amount of business if its major customers suddenly demand ISO certification and the company does not have it. . | ||||||||||||||||

At a management retreat, the senior executives of the firm developed the following payoff table, indicating the net present value of profits over the next five years.. | ||||||||||||||||

Customers’ Response | ||||||||||||||||

Decision | Standards Required | Standards Not Required | Probabilities | |||||||||||||

Become certified | $82,000 | $63,000 | Standards Required | Standards Not Required | ||||||||||||

Stay uncertified | $80,000 | $72,500 | 0.41 | 0.59 | ||||||||||||

Part 1 | Identify the type of decision problem and use excel formulas and functions to determine the following calculations. | |||||||||||||||

Best and Worst Payoffs | Opportunity-Losses | |||||||||||||||

Minimum | Maximum | Standards Required | Standards Not Required | MAX | ||||||||||||

Type of decision problem | Become certified | Become certified | ||||||||||||||

What are the payoffs ? | Stay uncertified | Stay uncertified | ||||||||||||||

Part 2 | What decision should the company make using each of the following strategies ? | |||||||||||||||

a. Decision using Aggressive strategy | with Payoff value = | which is the | value among the | outcome values of the alternatives considered | ||||||||||||

b. Decision using Conservative strategy | with Payoff value = | which is the | value among the | outcome values of the alternatives considered | ||||||||||||

c. Decision using Opportunity-Loss strategy | with opportunity loss = | which is the | value among the | opportunity losses of the alternatives considered | ||||||||||||

Part 3 | Compute the standard deviation of the payoffs for each decision. What does this tell you about the risk in making the decision? | |||||||||||||||

a. Std Deviation of Payoffs for becoming certified | ||||||||||||||||

b. Std Deviation of Payoffs for staying uncertified | ||||||||||||||||

c. Which Decision has Greater Risk ? | ||||||||||||||||

Part 4 | What decision should be made using the Average payoff strategy ? | |||||||||||||||

a. Average of Payoffs for becoming certified | ||||||||||||||||

b. Average of Payoffs for staying uncertified | ||||||||||||||||

c. Decision using Average Payoff strategy | ||||||||||||||||

Part 5 | Use the probabilities given on the problem statement section to determine what decision should be made using the Expected Value strategy | |||||||||||||||

a. Expected Value for becoming certified | ||||||||||||||||

b.Expected Value for staying uncertified | ||||||||||||||||

c. Decision using Expected value strategy |