If executives of an organisation were using these Daily Sales figures for June, to forecast the sales for the entire month of July, which of the following would be the most likely forecast using the Jury of Executive Opinion?
Look at the sheet LeadInd.
Coupled with the data in the sheet DailySales, which of the following is most likely to be true about the daily sales towards the end of June, and their continuation into July?
Look at the sheet MonthlySales for Questions 12 – 16.
The probability for “Average” sales for July is 0.6. If all other states are equally likely, what is the probability for each of these other states?
To confirm the monthly sales forecast for July, the 10 sales representatives from the firm were all privately surveyed by a hired consultant. Their responses are found in sheet Survey1. Use this sheet for Question 17 – 20.
Construct a Box and Whisker Plot for the data. How many outliers are there?
Look at sheet Survey2 which contains the survey results for the second survey round.
Which of the Sales Representatives is likely to exhibit the bias of “Anchoring” (think about the definition of Anchoring bias)?
Look at sheet ScenarioSept which forecasts sales for the September quarter (months of July, August, and September) based on various scenarios of the Interest Rate and Income.
Use this sheet for Questions 22 – 24.What is the underlying equation that is generating the sales forecast for each scenario?
Assume that the interest rate is 1.5% and assume that Income is closest to the figure of Income in June in the sheet QuarterlySales, is the best forecast for Income in September.
Now round this figure of income to the closest scenario in the sheet ScenarioSept.From the sheet, ScenarioSept, which is the most likely forecast for sales from the list below?
If the interest rate is expected to remain constant, and income is going to trend in the direction indicated by the leading indicator in the sheet LeadInd, from the list below, what is a likely number of sales that the firm should plan for beyond the September quarter?