Question
Kenny West is a manager of The Aloha Motel, has a contract with Appraisers Associates to appraise his 150-room motel, the consultant on the job
Kenny West is a manager of The Aloha Motel, has a contract with Appraisers Associates to appraise his 150-room motel, the consultant on the job determines the following:
1. Occupancy percentages for the most recent year were as follows:
Daily occupancy % = 80% Double occupancy % = 40% Average occupancy per room = 1.5 (use this only as a double-check, not a formula)
2. Average room rates were as follows:
Single rooms = $125.00 Double rooms = $165.00
3. Room expenses were as follows:
Labor--fixed = $80,000 Labor--variable = 15% of room sales Other variable expenses = 5% of room sales
4. Food sales for the most recent year were as follows:
a. Breakfast:
- 60% of guests staying in singles dined in the motel's restaurant
- 40% of guests staying in doubles dined in the motel's restaurant
- The average check was 11.95
- An average of 10 breakfast guests per day were non-room guests
b. Lunch:
- 20% of the hotel guests used the facilities
- 60% of lunch guests were non-room guests
- The average check was $18.50
c. Dinner
- 30% of guests staying in singles dined in the restaurant
- 10% of guests staying in doubles dined in the restaurant
- 20% of dinner guests were non-room guests
- The average check was $32.70
5. The food service expenses for a recent year were as follows:
a. Cost of sales: 30% b. Labor: fixed = $60,000, variable = 20% of food sales c. Other: fixed = $12,000, variable = 15% of food sales
6. Telephone sales and expenses for the most recent year were as follows:
a. Telephone sales were 3% of total revenue of the motel b. Telephone expenses were 95% of telephone sales
7. Other expenses of the motel were as follows:
Fixed Expenses | Variable (% of Total Revenues) | |
Administrative & general | $100,000 | 4% |
Marketing | 40,000 | 3% |
Property operation & maintenance | 40,000 | 5% |
Utilities | 12,000 | 1% |
Insurance | 15,000 | -- |
Property taxes | 30,000 | -- |
Rent | 2,000 | -- |
Required:
1. Prepare an operations statement for the most recent year (2018) based on the above information.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started