Question: Problem 22 The Merry and linear regression for forecasting most recent five weeks of actual data. An adjustment is made for holidays as follows: Motel

 Problem 22 The Merry and linear regression for forecasting most recent
five weeks of actual data. An adjustment is made for holidays as

Problem 22 The Merry and linear regression for forecasting most recent five weeks of actual data. An adjustment is made for holidays as follows: Motel uses the movin g average approach to forecast its rooms sales for each week its food sales. The moving average approach utilizes the Ifthe holiday occurred during the prior five weeks, the week containing the holiday is If the holiday occurs during the forecast week, the forecasted estimate based on the . adjusted by multiplying it by 110 percent moving average is reduced by 10 percent. The rooms sold for the five preceding weeks were as follows: Rooms Rooms BudgetedSold Holidays May 24-31 June 1-7 June 8-14 June 15-21 June 22-28 June 29-July 5 660 710 720 710 715 640 700 710 720 710 Memorial Day (May 30) July 4 The average occupancy per room sold is expected to be 1.6 for June 29-July 5 The regression equations used to forecast the number of meals to be sold are as follow reakfast covers50 8(number of hotel room guests) Lunch covers 150 +2(number of hotel room guests) Dinner covers 60 +.6(number of hotel room guests) Required: 1. Calculate the expected number of rooms to be sold for the week of June 29-July 5 2. Calculate the number of meals to be sold for breakfast, lunch, and dinner for the wee of June 29-July 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!