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 occupied for one night.
The operating income for year 1 is as follows:
HomeSuites | |||
Operating Income | |||
Year 1 | |||
Sales revenue | |||
Lodging | $ | 137,970,000 | |
Food & beverage | 19,162,500 | ||
Miscellaneous | 7,665,000 | ||
Total revenues | $ | 164,797,500 | |
Costs | |||
Labor | $ | 44,325,000 | |
Food & beverage | 13,797,000 | ||
Miscellaneous | 9,198,000 | ||
Management | 2,500,000 | ||
Utilities, etc. | 37,500,000 | ||
Depreciation | 10,500,000 | ||
Marketing | 25,000,000 | ||
Other costs | 8,000,000 | ||
Total costs | $ | 150,820,000 | |
Operating profit | $ | 13,977,500 | |
In year 1, the average fixed labor cost was $400,000 per property. The remaining labor cost was variable with respect to the number of nights. Food and beverage cost and miscellaneous cost are all variable with respect to the number of nights. Utilities and depreciation are fixed for each property. The remaining costs (management, marketing, and other costs) are fixed for the firm.
At the beginning of year 2, HomeSuites will open three new properties with no change in the average number of rooms per property. The occupancy rate is expected to remain at 70 percent. Management has made the following additional assumptions for year 2:
The managers of HomeSuites are considering different pricing strategies for year 2. Under the first strategy (“High Price”), they will work to maintain an average price of $210 per night. They realize that this will reduce demand and estimate that the occupancy rate will fall to 60 percent with this strategy. Under the alternative strategy (“High Occupancy”), they will work to increase the occupancy rate by lowering the average price. They estimate that with an average nightly rate of $170, they can achieve an occupancy rate of 80 percent. The current estimated profit is $22,092,800.
Required:
a. Prepare a budgeted income statement for year 2 if the “High Price” strategy is adopted.
b. Prepare a budgeted income statement for year 2 if the “High Occupancy” strategy is adopted.
Statement of Budgeted Income Statement | |||||||
HomeSuites | |||||||
Operating Income | Year 1 | Year 2 | Year 2 | ||||
Particulars | High Pricing | High Occupancy | |||||
Avg Rooms | 200 | 200 | 200 | ||||
Total Rooms (200x15) | 3000 | 3000 | 3000 | ||||
No of days | 365 | 365 | 365 | ||||
Avg Room price | 180 | 210 | 170 | ||||
Total Revenue at full capacity (3000x365x180) | 197100000 | (3000*365*210) | 229950000 | (3000*365*210) | 186150000 | ||
Occupany | 70% | 60% | 80% | ||||
Total Rooms @ 70% | A | 2100 | Total Rooms @ 60% | 1800 | Total Rooms @ 60% | 2400 | |
Sales revenue | Amount ($) | Per unit Cost | Amount ($) | Amount ($) | |||
Lodging (19,71,00,000*70%) | 13,79,70,000 | 65700 | (22,99,50,000*60%) | 13,79,70,000 | (186150000*80%) | 14,89,20,000 | |
Food & beverage | 1,91,62,500 | (19162500*80%) | 1,53,30,000 | (19162500*80%) | 1,91,62,500 | ||
Miscellaneous | 76,65,000 | No Change | 7665000 | No Change | 7665000 | ||
Total revenues | B | 16,47,97,500 | Total revenues | 16,09,65,000 | Total revenues | 17,57,47,500 | |
Costs | Amount ($) | Amount ($) | Amount ($) | ||||
Labor Fixed | 4,00,000 | Fixed | 4,00,000 | Fixed | 4,00,000 | ||
Labor Varaible (per room cost is divided "A") | 4,39,25,000 | 20,917 | (20917*1800) | 3,76,50,000 | (20917*2400) | 5,02,00,000 | |
Food & beverage Varaible (per room cost is divided "A") | 1,37,97,000 | 6,570 | (6570*1800) | 1,18,26,000 | (6570*2400) | 1,57,68,000 | |
Miscellaneous Varaible (per room cost is divided "A") | 91,98,000 | 4,380 | (4380*1800)*125% | 98,55,000 | (4380*2400)*125% | 1,31,40,000 | |
Management Fixed | 25,00,000 | (2500000*92% | 23,00,000 | (2500000*92% | 23,00,000 | ||
Utilities, etc. Fixed | 3,75,00,000 | No Change | 3,75,00,000 | No Change | 3,75,00,000 | ||
Depreciation Fixed | 1,05,00,000 | No Change | 1,05,00,000 | No Change | 1,05,00,000 | ||
Marketing Fixed | 2,50,00,000 | (2500000*90%) | 2,25,00,000 | (2500000*90%) | 2,25,00,000 | ||
Other costs Fixed | 80,00,000 | No Change | 80,00,000 | No Change | 80,00,000 | ||
Total costs | C | 15,08,20,000 | Total costs | 14,05,31,000 | Total costs | 16,03,08,000 | |
Operating profit | D = B-C | 1,39,77,500 | Operating profit | 2,04,34,000 | Operating profit | 1,54,39,500 |
Problem 13-56 Prepare Budgeted Financial Statements: Comparing Alternatives (LO 13-7) HomeSuites is a chain of all-suite...
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...
Woodview Lodge is a premium, all-suite lodge in the Appalachian Mountains. The lodge has 200 rooms In its first year of operations (2019), its occupancy rate (number of rooms filled divided by the number of rooms available) was 70%, based on a 365-day year. The average room rate was $220 per night. The basic unit of operation is the "night." Which is one room occupied for one night. Operating income for 2019 is as follows: Woodview Lodge Income Statement For...
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...
Problem 13-51 (Static) Prepare Budgeted Financial Statements (LO 13-6) The following information is available for year 1 for Pepper Products: $2,850,000 Sales revenue (200,000 units) Manufacturing costs Materials 168,000 Variable cash costs 142,400 327,600 Fixed cash costs Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total costs 999,000 422,400 149,600 509, 200 74,800 $2,793,000 57,000 Operating profits All depreciation charges are fixed and are expected to remain the same for year 2....
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...
13-51. Prepare Budgeted Financial Statements (LO 13-6) eXcel The following information is available for year 1 for Pepper Products. $2,850,000 Sales revenue (200,000 units) Manufacturing costs $168,000 Materials 142,400 327,600 Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs 999,000 Marketing (variable, cash) 422,400 Marketing depreciation 149,600 Administrative (fixed, cash) 509,200 Administrative depreciation 74,800 Total costs $2.793,000 Operating profits $ 57,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales...
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...
I need an answer to problem 5.6 of the Financial Management for the Hospitality Industry. Thanks The Rainbow Motor Motel is a 50-room facility with a restaurant to accommodate its guests. The motel is open 365 days a year, even on leap years; as Lurena Boucha, the proprietor, closes down the facility every February 29, her birthday, for an all day celebration of four years of successful operations. On the average, 98% of the rooms are available for sale. For...