Business
Business, 21.05.2020 21:14, lmolmlm5420

The Marcus Motel uses the moving average approach to forecast the number of rooms sold for each week and linear regression for forecasting its food sales. The moving average approach utilizes the most recent five weeks of actual data. An adjustment is made for extremes as follows: If during the five weeks, the actual number of rooms sold for a week has more than 30% difference from the budgeted number of rooms sold for that week, the actual is considered to be an extreme. In such case, the extreme is ignored and the budgeted number of rooms sold is used in its place.
The average occupancy per room sold is expected to be 1.8 for June 29 - July 5. The regression equations used to forecast the number of meals to be sold are as follows:

Breakfast customers = 50 + .8 (x)
Lunch customers = 150 + .2 (x)
Dinner customers = 60 + .6 (x)
, where x = Number of motel room guests not committed to food functions for that week.

Room guests committed to food functions (other than the restaurant) for the week of June 29 - July 5 are as follows:

Breakfast: 350
Lunch: 700
Dinner: 0

Required:
1) Calculate the expected number of rooms to be sold for the week of June 29 - July 5.
2) Calculate the expected number of meals to be sold for breakfast, lunch, and dinner in the motel's restaurant for the week of June 29 - July 5. Please use the number from question 1 as the number of rooms sold for the week of June 29 - July 5.

The rooms sold for the five preceding weeks were as follows:
Rooms Budgeted Rooms Sold
May 24-31 680 460
June 1-7 710 700
June 8-14 720 710
June 15-21 700 930
June 22-28 715 710
June 29 - July 5

answer
Answers: 2

Other questions on the subject: Business

image
Business, 22.06.2019 06:10, brooke0713
Amanda works as an industrial designer
Answers: 1
image
Business, 22.06.2019 21:40, cutierosie5136
Which of the following distribution systems offers speed and reliability when emergency supplies are needed overseas? a. railroadsb. airfreightc. truckingd. pipelinese. waterways
Answers: 2
image
Business, 22.06.2019 23:00, keylor97
Which best describes what financial planning skills ultimately enable an individual to do? to prepare for the future to determine lifetime income to determine the cost of living to learn from the past
Answers: 1
image
Business, 23.06.2019 14:30, BreBreDoeCCx
How can improving one’s reasoning skills also improve one’s performance on the job? if one can improve one’s reasoning, one can also improve one’s physical fitness and athletic performance. if one can improve one’s reasoning, one can perform anything. high-performing workers always work reasonable schedules. high-performing workers are able to analyze sophisticated streams of data and solve complex problems.
Answers: 2
Do you know the correct answer?
The Marcus Motel uses the moving average approach to forecast the number of rooms sold for each week...

Questions in other subjects:

Konu
Mathematics, 14.07.2019 04:00