Appendix D Sunrise Hotels (D). D.1. Case background January 2017. Previously, you estimated a cost function for the property and completed a CVP analysis. Your supervisor has asked you to prepare a 2018 operating budget. Analysis of historical data suggests the following monthly room demand: Months January and February March-May, September-October June-August November and December Monthly Demand 5% of annual demand. 8% of annual demand. 12% of annual demand. 7% of annual demand. Revenues. In Sunrise (B), you forecast the average daily rate and sales volume for 2018. Assume the room rate is constant throughout the year. Costs. Assume now that you ran regressions for each of the separate expense categories in your data file. Increasing the variable cost estimates by 4% (an assumption given in the B case) results in the cost formulas provided in the table below." Item Front desk Housekeeping Supplies Energy Cost Equation $7800 $4.30/rental x Rentals $1.35/rental x Rentals $4700 An alternative to regression is the industrial engineering method of cost estimation. Your regional manager provides you with the following insights: The front desk is staffed twenty-four hours per day. Average wages of front desk staff are $8.00/hour. Your annual salary, as general manager, is $27,000. Housekeeping should clean a room in 20 minutes. However, preparing the laundry cart and taking linens to the laundry room mean that, on average, only two rooms per hour can be cleaned. The hourly wage rate for housekeepers is expected be $7.50. A laundry worker works 20 hours per week at $7.50/hour. Room Amenities. Rooms are stocked with two bars of soap and a bottle of shampoo. Soap costs $0.14 a bar and shampoo costs $0.25 per bottle. At the beginning of each month, you want 25% of next month's requirements on hand. Beginning inventory requirements are met on January 1. Assume January 2018 room sales will be 900 rentals. Other Supplies. Paint, light bulbs, coffee, etc. average about $1000 per month. D.2. Required 1. Prepare a monthly operating budget for 2018. Explain why you chose the regression or industrial engineering method to estimate costs. What are the limitations of each method? 2. Prepare a monthly purchases budget for room amenities (units and amount)