The operation team of H hotel, which has 25 rooms on daily basis, has projected that...
The management of 80-room Brize Garden Suites, which has single and double rooms only, has acquired the following internal financial data: - Occupancy of 72.00% - Projected after-tax average ADR of $64.00 - 30.00% of double room occupancy - A price difference of $28.00 more than single rooms for double rooms Based on the financial information given, calculate the individual ADRs for both single and double rooms for Brize Garden Suites (Note: Round the total number of rooms sold, total...
Suppose that Allianz Lodging Establishment has 300 rooms with 70% occupancy on daily basis. The ADR of this hotel is $80.00 and it operates every day in a certain year. Also, this hotel has $4 million annual F&B revenue. On daily basis, the total number of guests stayed at Allianz is 100. Based on the information given, calculate the revenue per available customer (assume that total number of guests stay constant through the year and there are 365 days in...
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...
10 Problem 6 bibelsto Part A: The Aaron Hotel, a 100-room limited-service operation, has provided you with the following data for the months of May and June: on trom May June Single rooms sold 1,000 950 Double rooms sold 1,600 1,610 Room revenue $221,000 $222,720 Number of paid guests 4,520 4,653 Required: don b onsolosa toru 1. Compute the paid occupancy for May. OOS R o b o 2. What was the monthly ADR for June? OVO 3. What was...
My
question is about the case study “ Comparing Apples and Oranges:
which group yuelds the best profit?”
1) Using the Excel apreadsheet attached to complete the rooms
sold and revenue projections based on the above case study.
Case Study: "Comparing Apples and Oranges: Which Group Yields
the Best Profit?"
The Diamond Peak Hotel, one of 45 hotels in the Host Marriott
management company, was bustling with business this Thursday
afternoon as the hour of the daily revenue meeting drew...
Scenario: Styles Wing Bicycle Company manufactures and sells 2 sizes of bicycles, 21.5 inch and 22.5 inch. Sales Their sales team has committed to the following projected monthly unit sales for the next year. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 21.5 Bike 368 472 633 616 443 345 322 317 317 317 328 22.5 Bike 320 410 550 535 385 300 280 275 275 275 285 Dec 420 365 The selling price for the 21.5...