subject
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

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 01:30
Ben collins plans to buy a house for $166,000. if the real estate in his area is expected to increase in value by 2 percent each year, what will its approximate value be five years from now?
Answers: 1
question
Business, 22.06.2019 06:00
Cash flow is often a problem for small businesses. how can an entrepreneur increase cash flow? a) locate lower-priced suppliers. b) forego sending in estimated tax payments to the irs c) shorten the terms on a bank loan to pay it off more quickly d) sell more low-margin items.
Answers: 1
question
Business, 22.06.2019 08:50
Dyed-denim corporation is seeking to lower the costs of value creation and achieve a low-cost position. as a result, it plans to move its manufacturing plant from the u.s. to thailand, which based on company research, is the optimal location for production. this strategic move will most likely allow the company to realize
Answers: 3
question
Business, 22.06.2019 16:00
Advanced enterprises reports year-end information from 2018 as follows: sales (160,250 units) $968,000 cost of goods sold 641,000 gross margin 327,000 operating expenses 263,000 operating income $64,000 advanced is developing the 2019 budget. in 2019 the company would like to increase selling prices by 14.5%, and as a result expects a decrease in sales volume of 9%. all other operating expenses are expected to remain constant. assume that cost of goods sold is a variable cost and that operating expenses are a fixed cost. should advanced increase the selling price in 2019?
Answers: 3
You know the right answer?
The Marcus Motel uses the moving average approach to forecast the number of rooms sold for each week...
Questions
question
Mathematics, 29.08.2020 01:01
Questions on the website: 13722367