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, 21.06.2019 13:30
Boteck is a full-service technology company. it provides equipment, installation services, and training services. customers can purchase any product or service separately or as a bundled package. on may 3, box-rite corporation purchased computer equipment, installation, and training for a total cost of $120,000. estimated stand-alone fair values of the equipment, installation, and training are $75,000, $50,000, and $25,000 respectively. the journal entry to record the sale and installation on may 3 will include select one:
Answers: 1
question
Business, 22.06.2019 22:10
Scoresby co. uses 6 machine hours and 2 direct labor hours to produce product x. it uses 8 machine hours and 16 direct labor hours to produce product y. scoresby's assembly and finishing departments have factory overhead rates of $240 per machine hour and $160 per direct labor hour, respectively. how much overhead cost will be charged to the two products? a. product x = $1,440; product y = $2,560 b. product x = $1,760; product y = $4,480 c. product x = $3,200; product y = $9,600 d. product x = $800; product y = $800
Answers: 1
question
Business, 23.06.2019 02:10
Which of the following most accurately describes how the equilibrium price of a good or service can be determined? a. by moving the supply curve right or left until it matches the demand curve. b. by finding where the supply curve and the demand curve intersect. c. by doing market research to determine the maximum price consumers will pay. d. by taking the opposite of the columns in a supply schedule and a demand schedule.
Answers: 2
question
Business, 23.06.2019 10:10
Swain company manufactures one product, it does not maintain any beginning or ending inventories, and its uses a standard cost system. the company's beginning balance in retained earnings is $65,000. it sells one product for $170 per unit and it generated total sales during the period of $603,500 while incurring selling and administrative expenses of $54,500. swain company does not have any variable manufacturing overhead costs and its standard cost card for its only product is as follows:
Answers: 1
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, 05.01.2022 03:10
question
Mathematics, 05.01.2022 03:20
question
Mathematics, 05.01.2022 03:20
question
Social Studies, 05.01.2022 03:20