you must submit only ONE word file and ONE Excel file with as many sheets as necessary.
Part 1: Dream Company Description
a) Describe your dream company (your service or product, your customers, your mission and vision, etc.)
b) What are some managerial decisions that should be made within your company?
c) How optimization can help you improve the decision-making process within your company?
Part 2: Decision Analysis Under Uncertainty and Risk
d) Consider possible outcomes that might happen in the future (e.g., demand level) and different alternatives. Create the payoff table.
e) 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. Criterion of realism
4. Equally likely
5. Minimax regret
f) Decision Analysis Under Risk: Assume a probability for each of the outcomes. Identify the best alternative using the following decision models:
1. Expected monetary value
2. Expected opportunity loss
g) Calculate the following based on the outcome probabilities in section (l) above:
1. Expected Value with Perfect Information (EVwPI)
2. Expected Value of Perfect Information (EVPI)
Part 3: Linear Programming Model
Consider one of the managerial decisions in Part 1 above.
a) Describe the problem in words (objective, parameters, constraints, etc.)
b) Define the decision variables.
c) Formulate the problem as a linear programming (LP) model.
d) Use Excel Solver to solve the associated LP model and find the optimal solution. Ask Excel to generate the Answer and Sensitivity reports.
9 freelance font une offre moyenne de $39 pour ce travail
Hey, I have gone through the project description and I can handle your task very well. You can check my profile, I am an experienced freelancer with more than 350 positive reviews from my clients living across the g Plus
Hi there? I can help you in your project. I have read the project description and I can deliver you the complete work within the given time period. I never compromise on the quality of my work. Please award me your pro Plus
I am a professional Financial Analyst, Statistics Expert and Business Analyst holding years of experience in utilizing advance level tools and functions of Excel and other data analytics softwares to perform financial Plus
1. Expert in Ms excel and statistics. Have done many research projects in Excel using statistics regression analysis, 2. Can complete the report and analysis as well as per the given guidelines. 3. Expert in academic Plus
Hello. I am a new freelancer. I understand your project and I will like to get it done. I have great experience in major Microsoft packages MS inclusive, content development and researching. I will like to get your fee Plus