Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Bev Vickerstaff, Parminder Johal

1st Edition

1444170414, 978-1444170412

More Books

Students also viewed these Accounting questions

Question

Explain the Pascals Law ?

Answered: 1 week ago

Question

What are the objectives of performance appraisal ?

Answered: 1 week ago

Question

State the uses of job description.

Answered: 1 week ago

Question

Do you favor a civil service system? Why or why not?

Answered: 1 week ago