a. Calculate the expected number of rooms to be sold for the week of June 29 - July 5. 

b. 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 Marcus Motel uses the moving average approach to forecast its rooms sales 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 rooms sold for a week differed by more than 30% from the budgeted room sales 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 rooms sold for the five preceding weeks were in the Excel.

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

The Marcus Motel uses the moving average appraoch to forecast its rooms sales 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 duting the five weeks the actual rooms sold for a week differed by more than 30% from the budgeted room sales for that week, the actual is considered to be an extreme. In such case, the extreme is ingored and the budgeted number of rooms sold is used in its place.
						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
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 day
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