Exam 1 Quantitative Methods For Management (SM 60.65)
Exam 1 Quantitative Methods For Management (SM 60.65)
Exam 1 Quantitative Methods For Management (SM 60.65)
ID:
Exam 1
Quantitative Methods for Management (SM 60.65)
Instructions
1. Manage your time carefully.
2. Show the steps of your calculations in sufficient detail.
3. This exam is closed-book, closed-notes. No calculators are allowed.
4. Write neatly. Check your calculations to avoid silly mistakes.
5. You may not leave the exam room before submitting your complete exam.
Question
Score
1
2
3
Total
b) (5 points) Redraw your decision tree in the space below and solve for the optimal
decision. Indicate the EMV of your solution.
a) (10 points) What is the probability that it will be rainy on the day of the show?
b) (10 points) Assume the probability of a rainy forecast is not 0.1 but 0.2. Furthermore,
the probability that it rains following a rainy forecast is unchanged (i.e. 0.9). What
must the probability of rain following a sunny forecast be so that the overall
probability of rain is unchanged (i.e. the same as calculated in part a)?
Probability
210
10%
220
10%
230
40%
240
30%
250
10%
a) (10 points) Let cell A1 contain the formula =rand(). Write an Excel formula for cell
B1 that generates a random variable representing the yield size in tons.
b) (10 points) Now suppose the market price for potatoes follows the inverse demand
equation: Price = 15.5 0.05Yield + N, where N is a random variable that is
normally distributed with mean 0 and standard deviation 0.5. Write an Excel formula
for cell C1 that generates a random variable representing the market price.
c) (10 points) Assume the cell D1 gives the value of B1 multiplied by C1. In other
words, D1 is the random variable representing revenue. The calculation is repeated
1,000 times, with results in columns A through D and rows 1 to 1,000. Write an Excel
formula that estimates the probability that the farmers revenue falls between $2,000
and $2,500.