Lux Hotel 5-Star Hotel Configuration

1 staff cost are estimated to be 18% of accommodation revenue

2 purchases are estimated to be 15% of accommodation revenue

3 marketing costs are estimated to be 5% of accommodation revenue

4 Administration costs of $200,000 are allocated based on floor space

5 utilities cost has an allocation of $30 per square metre floor space plus 3% of accommodation revenue

6 maintenance cost has an allocation of $50 per square metre floor space plus 9% of accommodation revenue

7 Other operating expenses of $300,000 are allocated based on floor space

Required:

(a) Reconstruct the income statement using the contribution margin format, clearly show separate columns for each room type and maintaining a total column.

(b) Calculate sales mix (based on accommodation revenue) for Lux Hotel.

(c) Calculate the weighted average contribution margin (WACM) per night stay of each room type and total WACM. (d) Determine the overall break-even level of rooms and number of night stay of each room type.

(e) Calculate the margin of safety per room type. (6 marks) (f) Suppose that Lux Hotel desires to earn a $500,000 profit. Determine the occupancy rates required to earn the desired profit.

Gmac C Get C Lux New Tab G how + M Total M Inbc M Inbo M Inbo S BUS EX Exar O Mail G adva Para G che Get C Lux + + c File C:/Users/Manpreet/Desktop/mgt%20&%20cost%20acing/BUSN9117%20Assignment%20Part%202.pdf Hotel Configuration Bed 1 Bed 2 Bed 3 (Single) (Double) (Penthouse) area per room (square metres) 20 30 60 number of rooms first floor - 240 square metre 3 4 1 second floor - 240 square metre 3 4 1 third floor - 240 square metre 3 4 number of rooms 9 12 3 floor space (square metres) 180 360 180 planned occupancy rate (%) (open 365 days) 60% 70% 50% average selling price ($/roomight) 220.00 350.00 700.00 1 1 24 720 63% 345.00 Budgeted Income Statement Total Bed 1 Bed 2 Bed 3 (Single) (Double) (Penthouse) $ $ $ 433,620 1,073,100 383,250 $ 1,889,970 78,052 193,158 65,043 160,965 143,095 354,123 290,525 718,977 68,985 57,488 126,473 340,195 283,496 623,690 256,778 1,266,280 Accommodation Revenue Cost of Goods Sold Staff costs Purchases (toiletries, sheets, towels etc.)2 Total Cost of Goods Sold Gross Profit Operating Expenses Administration Costs 3 Marketing Costs Utilities cost 5 Maintenance cost Other operating expenses 7 Total Operating Expenses Net Profit ($) 50,000 21,681 18,409 48,026 75,000 100,000 53,655 42,993 114,579 50,000 19,163 16,898 43,493 75,000 204,553 52,225 200,000 94,499 78,299 206,097 300,000 150,000 213,115 461,227 77,410 257,750 878,895 387,385 Type here to search W ENG 3:05 AM 18/09/2020 8