Question

In: Operations Management

FC.75 The Rexburg Taco Bell wants to forecast—by time of day or "season"—the total number of...

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.)

Solutions

Expert Solution

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


Related Solutions

A manufacturer wants to compare the number of defects on the day shift with the number...
A manufacturer wants to compare the number of defects on the day shift with the number on the evening shift. A sample of production from recent shifts showed the following defects: Day Shift​​: 6​ 9​ 8​ 7​ 10​ 8 Evening Shift: ​​9​ 11​ 8​ 12​ 10​ 13​ 15​ 10 The objective is to determine whether the mean number of defects on the night shift is greater than the mean number on the day shift at the 95% confidence level. a)...
A manufacturer wants to compare the number of defects on the day shift with the number...
A manufacturer wants to compare the number of defects on the day shift with the number on the evening shift. A sample of production from recent shifts showed the following defects: Day Shift 6 9 8 7 10 8 Evening Shift 9 11 8 12 10 13 15 10 The objective is to determine whether the mean number of defects on the night shift is greater than the mean number on the day shift at the 95% confidence level. a)...
A manufacturer wants to compare the number of defects on the day shift with the number...
A manufacturer wants to compare the number of defects on the day shift with the number on the evening shift. A sample of production from recent shifts showed the following defects: Day Shift 5 8 7 6 9 7 Evening Shift 8 10 7 11 9 12 14 9 The objective is to determine whether the mean number of defects on the night shift is greater than the mean number on the day shift at the 95% confidence level. State...
A manufacturer wants to compare the number of defects on the day shift with the number...
A manufacturer wants to compare the number of defects on the day shift with the number on the evening shift. A sample of production from recent shifts showed the following defects: Day Shift                     5          8          7          6          9          7 Evening Shift              8          10        7          11        9          12            14        9 The objective is to determine whether the mean number of defects on the night shift is greater than the mean number on the day shift at the 95% confidence level....
A manufacturer wants to compare the number of defects on the day shift with the number...
A manufacturer wants to compare the number of defects on the day shift with the number on the evening shift. A sample of production from recent shifts showed the following defects: Day Shift 5 8 7 6 9 7 Evening Shift 8 10 7 11 9 12 14 9 The objective is to determine whether the mean number of defects on the night shift is greater than the mean number on the day shift at the 95% confidence level. State...
A researcher wants to study the effectiveness of medication and the time of day on alertness....
A researcher wants to study the effectiveness of medication and the time of day on alertness. 18 patients are randomly selected and three are assigned to each of six groups. Their alertness scores are listed on the table. Is there any difference in the mean score depending on 1) the type of treatment, 2) time, and 3) an interaction effect between treatment and time? Use an alpha level of .05. Time Morning Afternoon Evening Treatment A 12 13 11 15...
Please use PYTHON on colab notebook Here's the list: [[‘Five Guys’,1,3],[‘Burger King’,5,7],['Nack Stick’,4,4][‘Pizza Hut’,7,2],[‘Taco Time’,1,8],[‘McDonalds’,5,7],['Taco Bell’,4,3]]...
Please use PYTHON on colab notebook Here's the list: [[‘Five Guys’,1,3],[‘Burger King’,5,7],['Nack Stick’,4,4][‘Pizza Hut’,7,2],[‘Taco Time’,1,8],[‘McDonalds’,5,7],['Taco Bell’,4,3]] The task is to write a loop that uses the function function2(a,b) (I have it down below)to create a dictionary called bus_dic which has all the business names above as keys and has it followed by the flying distance.f For example, when you type in bus_dist["Five Guys"] you should get 3.16227766 If you need anything else, please leave a message. Thank you! The functio2...
A restaurant manger, Coleman, at the Four Seasons Hotel wants to predict/forecast a number of meals...
A restaurant manger, Coleman, at the Four Seasons Hotel wants to predict/forecast a number of meals to be prepared for the breakfast since the labor costs and cost of good sold are vey high and does not want to create high volume of waste and manage the inventory in a proper way. He looks through the previous data (2016) to determine the relationship between the number of guest stayed at the hotel and number of meals served from the following...
Q1. Jamie wants to forecast the number of students who will enroll in operations management next...
Q1. Jamie wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. He has accumulated the following enrollment data for the past six semesters: SEMESTER STUDENTS ENROLLED IN OM 1 270 2 310 3 250 4 290 5 370 6 410 a (2 pts). Compute a three-semester moving average forecast for semesters 4 through 7 (Model a) (Use two decimals). SEMESTER Three-semester moving average forecast for...
A researcher wants to determine if the number of minutes spent watching television per day is...
A researcher wants to determine if the number of minutes spent watching television per day is independent of gender. A random sample of 315 adults was selected and the results are shown below. Is there enough evidence to conclude that the number of minutes spent watching television per day is related to gender? Test at the alpha=0.05 level of significance. Please show all work/calculations. Minutes spent watching tv per day in table below: GENDER 0-30 30-60 60-90 90-OVER Male 25...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT