In: Operations Management
FC.75 The Rexburg Taco Bell wants to forecast—by time of day or
"season"—the total number of Crunchy Tacos it will sell in July,
based on the previous six months of sales as found in the table
below:
Meal Time | Jan | Feb | Mar | Apr | May | Jun |
---|---|---|---|---|---|---|
Lunch | 1,936 | 2,044 | 2,122 | 1,912 | 2,048 | 2,105 |
Afternoon | 1,004 | 1,107 | 958 | 831 | 980 | 833 |
Dinner | 2,113 | 2,040 | 2,014 | 2,173 | 1,995 | 2,058 |
FourthMeal | 497 | 647 | 431 | 567 | 591 | 625 |
What is the seasonal index for the lunch season? (Display your answer to two decimal places.)
What is the seasonal index for the dinner season?
(Display your answer to two decimal places.)
What is the seasonal index for the FourthMeal
season? (Display your answer to two decimal
places.)
Taco Bell believes that total July sales of Crunchy Tacos will be
5,550. Based on this forecast for July, how many Crunchy Tacos
should they expect to sell during the afternoon
"season" in that month? (Display your answer to
two decimal places.)
Below is the screenshot of the formula applied -
Below is the screenshot of the result -
Below is the answer to the question asked -
What is the seasonal index for the lunch
season- 1.45
What is the seasonal index for the dinner season-
1.47
What is the seasonal index for the FourthMeal
season- 0.40
Taco Bell believes that total July sales of Crunchy Tacos will be
5,550. Based on this forecast for July, how many Crunchy Tacos
should they expect to sell during the afternoon
"season" in that month - 943.50