| 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

  1. a) Describe your dream company (your service or product, your customers, your mission and vision, etc.)
  2. b) What are some managerial decisions that should be made within your company?
  3. c) How optimization can help you improve the decision making process 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 :

Category: Homework Help

Order a customized paper today!