solution

The manager of the Hospitality Inn has developed regression analysis equations for forecasting the hotelâ€™s dining room sales volume based on the hotelâ€™s anticipated guest-night count. The monthly equations (where Y equals the forecast number of meals to be served, and X equals the number of hotel guests) follow:

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â BreakfastÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Y = 750+ 0.82 X

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â LunchÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Y =900 +1.15 X

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DinnerÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Y =1,200 + 0.42 X

The hotel has 100 rooms. Its occupancy in November is expected to be 70% and its double occupancy rate is 40%. The average meal checks follow:

BreakfastÂ Â Â Â Â Â Â Â $ 5.25

LunchÂ Â Â Â Â Â Â Â Â Â Â Â Â $10.24

DinnerÂ Â Â Â Â Â Â Â Â Â Â Â $15.78

Calculate the dining roomâ€™s forecast meal period sales, both in number of guests and sales revenue dollars, for the month of November.

solution

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!