# Attachments:

December 6, 2015

Note: you must submit only ONE word file and ONE Excel file with as many sheets as necessary.

Part 1: Dream Company Description

2. b) What are some managerial decisions that should be made within your company?

Part 2: Linear Programming Model

Consider one of the managerial decisions in Part 1 above.

1. d) Describe the problem in words (objective, parameters, constraints, etc.)
2. e) Define the decision variables.
3. f) Formulate the problem as a linear programming (LP) model.
4. g) Use Excel Solver to solve the associated LP model and find the optimal solution. Ask Excel to generate the Answer and Sensitivity reports.

Part 3: Decision Analysis Under Uncertainty and Risk

1. h) Consider possible outcomes that might happen in the future (e.g., demand level) and different alternatives. Create the payoff table.
2. i) Decision Analysis Under Uncertainty: Analyze different alternatives you have assuming you have no information about the probability of each outcome. Identify the best alternative using the following decision models:
3. Maximax
4. Maximin
5. Criterion of realism
6. Equally likely
7. Minimax regret
8. j) Decision Analysis Under Risk: Assume a probability for each of the outcomes. Identify the best alternative using the following decision models:
9. Expected monetary value
10. Expected opportunity loss
11. k) Calculate the following based on the outcome probabilities in section (l) above:
12. Expected Value with Perfect Information (EVwPI)
13. Expected Value of Perfect Information (EVPI)
Get a 20 % discount on an order above \$ 120
Use the following coupon code :
today2015

Category: Homework Help

Order a customized paper today!