# Excel代写 | BU.610.625 – Simulation and Strategic Options

BU.610.625 – Simulation and Strategic Options, Spring 2020
Homework # 2
Excel file for the question in .xlsx format. Please make sure you spell out the responses to the
the convention LastName_FirstName_AssignmentNumber. For example,
Question 1: Introduction to Simulation
In this example, you are asked to use Microsoft Excel to develop a simulation model for the
example ROGOLABS. The description of this example is available in pages 1-3 of
“Introduction to Simulation: More Advanced Decision Models & Applications” (See folder
a. What is the total cost incurred in your system after 500 days? Recalculate your
spreadsheet a few times and see how this value changes. Does this give you great
confidence in your estimated cost? If not, how would you address this concern?
b. Try changing the minimum and maximum capacity levels at each step and see what
happens to the system cost. Is total cost a linear function of your decisions? Is it a
monotonic function of your decisions – in other words, does it always go up or down
when your decision variable goes up or down?
c. After you have a working model in hand, use it to complete the following table showing
Min Max Av. Capacity Sub-Total
Station A
Station B
Station C
Station D
Station E
Inventory Related Costs
Total:
Question 2: Real options using decision trees.
No simulation model is required for this question.
Read the case SCOR-eSTORE.COM (available through HBSP
https://hbsp.harvard.edu/import/714455 ) and answer the following parts.
a. Briefly answer the following questions:
 What is the idea behind the competitor from StoreStore.com?
 What do they need to get the web business to be viable?
 What are the sources of optionality here?
b. Using a decision tree including investing and passing decisions, show why Bernard
planned to pass on the opportunity.
c. What is the additional value of Allen’s suggestion? Update the decision tree in part b.
d. How about the switch option suggested by Soares? Update the decision tree in part b.
e. Will Allen’s and Soares’ suggestions combined be able to change Bernad’s decision
about passing on the opportunity? Explain why.

E-mail: vipdue@outlook.com  微信号:vipnxx