Similar Posts
John Datum is another customer of the same wireless company. Just like our consultant, John is trying to compare the old plan and the new plan. Having looked at his past monthly data usage values, John, unlike our consultant, has decided to use a simple scenario approach to model his future data usage. In particular, John estimates that his monthly data usage Ū (in GB) can take one of three values, Ū1 = 15, Ū2 = 21 and Ū3 = 24, each value being equally likely (i.e., each having a probability of 1/3 associated with it). What is the expected value of John’s monthly payments, in $, under the old plan?
ByAdmin5. Question 5 This question relates to the Data Plan Example covered in Sessions 1 and 2. The “old plan” refers to the “Family Share” plan, and the “new plan”…
The formula in cell C5 is “=SUMPRODUCT($A$1:$C$1,A2:C2)”. If one copies and pastes the formula from the cell C5 into the cell C6, what numerical value will appear in the cell C6?
ByAdmin7. Question 7 This question relates to the details of spreadsheet implementation of optimization models in Excel covered in Session 2. You should be able to answer this question using…
Suppose we have a data set containing n=100 data points with the following descriptive statistics: mean = 80, and standard deviation = 18. We believe that this data sample comes from a normal distribution. Which of the following choices would you use for forecasting or predicting future demand values?
ByAdmin4. Question 4 This question relates to concepts covered in Lectures 1 & 2. You can use any of the excel files posted to work through the question. Suppose we…
Consider the decision tree we constructed for IDEA in Session 1 of week 4. Assume that all of the data used in the example remain the same except for the probability of the market remaining weak or strong. Suppose that, instead of a 0.5 chance that the market is strong, the probability that the market is strong is now 0.6.
ByAdmin3. Question 3 Consider the decision tree we constructed for IDEA in Session 1 of week 4. Assume that all of the data used in the example remain the same…
Mr. Cal Coolator uses a trend line forecasting model to forecast the daily demand for 1-quart water bottles at a convenience store based on the average temperature recorded outside during the day. The demand line is given by
ByAdmin7. Question 7 This question relates to concepts covered in Sessions 3 and 4. You can use any of the excel files posted online to work through the Quiz. Mr….
Which choice is the decision maker’s maxi-min decision?
ByAdmin7. Question 7 For this question, consider the following decision problem. A decision maker must choose one of three actions: A, B, or C. The outcome of each action is…
