Solution: | ||
Total Rooms available | 200 | |
Total number of days in a year | 365 | |
Total room nights | 73000 | (200 X 365) |
Occupancy Rate | 70% | |
Total number of nights occupied | 51100 | (730000 X 70%) |
Total Lodging Revenue | 11242000 | |
Average Revenue per night/per room | 220 | (11242000 / 51100) |
Increase expected in 2nd lodge | 5% | |
New average revenue per night per room | 231 | |
Total Number of nights | 102200 | (51100 for each lodge) |
Budgeted Income Statement | Notes | |
Both Lodge | ||
Revenue: | ||
Lodging | 23608200 | (51100 nights X 231X 2) |
Food and Beverage | 3892500 | (2162500 - 10%) X 2 |
Miscellaneous | 1530000 | (765000 x 2) |
Total Revenue | 29030700 | |
Costs: | ||
Labor | 6856500 | (450000+ (3597000-450000) X 2) + 25 % of 450000 |
Food and Beverage | 2940000 | (1470000 X 2) as variable to nights |
Miscellaneous | 2570400 | (918000 X 2) as variable to nights plus 40% |
Management | 212000 | All fixed |
Utilities | 5953350 | 3053000 + 95% |
Depreciation | 1622600 | 854000 + 90% |
Marketing | 2265760 | 2023000+12% |
Other Cost | 640000 | All fixed |
Total Cost | 23060610 | |
Net operating income | 5970090 |
Woodview Lodge is a premium, all-suite lodge in the Appalachian Mountains. The lodge has 200 rooms...
I have part A completed I just need the required question at the end answered. Thanks : Total Rooms available 200 Total number of days in a year 365 Total room nights 73000 (200 X 365) Occupancy Rate 70% Total number of nights occupied 51100 (730000 X 70%) Total Lodging Revenue 11242000 Average Revenue per night/per room 220 (11242000 / 51100) Increase expected in 2nd lodge 5% New average revenue per night per room 231 Total Number of nights 102200...
I have part A completed I just need the required question at the end answered. Thanks : Total Rooms available 200 Total number of days in a year 365 Total room nights 73000 (200 X 365) Occupancy Rate 70% Total number of nights occupied 51100 (730000 X 70%) Total Lodging Revenue 11242000 Average Revenue per night/per room 220 (11242000 / 51100) Increase expected in 2nd lodge 5% New average revenue per night per room 231 Total Number of nights 102200...
HomeSuites is a chain of all-suite, extended-stay hotel properties. The chain has 16 properties with an average of 150 rooms in each property. In year 1, the occupancy rate (the number of rooms filled divided by the number of rooms available) was 70 percent, based on a 365-day year. The average room rate was $204 for a night. The basic unit of operation is the "night," which is one room occupied for one night. The operating income for year 1...
HomeSuites is a chain of all-suite, extended-stay hotel properties. The chain has 18 properties with an average of 220 rooms in each property. In year 1, the occupancy rate (the number of rooms filled divided by the number of rooms available) was 70 percent, based on a 365-day year. The average room rate was $170 for a night. The basic unit of operation is the “night,” which is one room occupied for one night. The operating income for year 1...
Problem 13-56 Prepare Budgeted Financial Statements: Comparing Alternatives (LO 13-7) HomeSuites is a chain of all-suite, extended-stay hotel properties. The chain has 15 properties with an average of 200 rooms in each property. In year 1, the occupancy rate (the number of rooms filled divided by the number of rooms available) was 70 percent, based on a 365-day year. The average room rate was $180 for a night. The basic unit of operation is the “night,” which is one room...
Prepare the pro forma income statement for a two-department company A hotel operation has 120 rooms and a 100-seat restaurant. Please prepare a pro forma income statement for the next year to determine the forecasted net income. Rooms department: In the previous year of operations the occupancy rate was 70% and the average room rate was $48. The GM is forecasting the occupancy rate to increase by 5% and the average room rate is to be increased by $4. Cost...
Ouestion 3 Rest & Fun Motel operates a 50-room motel near an amusement park. During September, Rest & Fun experienced a 65% occupancy rate from Monday evening through Thursday evening (weeknights). On Friday through Sunday evenings (weekend nights), however, occupancy increases to 90%. There were 18 weeknights and 12 weekend nights in September. All rooms are similar and Rest & Fun charges RM80 per room per night (room-night). The company recently hired Adam Haikal to manage the motel to increase...
Empire Plaza Hotel is a luxury hotel with 432 rooms. Its regular room rate is $460 per night per room. The hotel's cost is $245 per night per room and consists of the following. Variable direct labor and materials cost Fixed cost Total cost per night per room $ 104 141 245 The hotel manager receives an offer to hold the Junior States of America (JSA) convention at the hotel in February, which is the hotel's low season with an...
Sand and Sea Resort (SSR) is a popular hotel with 400 rooms. SSR's regular room rate is $300 per night per room. SSR's cost is $165 per night per room. Below is a breakdown of the SSR's cost: Variable direct labor and materials cost Fixed cost Total cost per night per room $ 165 SSR manager receives an offer to hold the Innovative Scientist Conference at the hotel in March, which is the hotel's low season with an occupancy rate...
Empire Plaza Hotel is a luxury hotel with 432 rooms. Its regular room rate is $460 per night per room. The hotel's cost is $245 per night per room and consists of the following. Variable direct labor and materials cost Fixed cost Total cost per night per room $ 104 141 $ 245 The hotel manager receives an offer to hold the Junior States of America (JSA) convention at the hotel in February, which is the hotel's low season with...