7.3 A hotel group prepares financial statements on a quarterly basis. The senior management is reviewing the performance of one hotel and making plans for next year The managers have in front of them the results for this year (based on some actual results and some forecasts to the end of this year) Profit/(loss) 000 (280) 360 680 40 800 Quarter Sales revenue 000 400 1,200 1,600 800 4,000 2 4 Total The total estimated number of guests (guest nights) for this year is 50,000, with each guest night being charged at the same rate. The results follow a regular pattern; there are no unexpected cost fluctuations beyond the seasonal trading pattern shown above. For next year, management anticipates an increase in unit variable cost of 10 per cent and a profit target for the hotel of 1 million. These will be incorporated into its plans. Required: (a) Calculate the total variable and total fixed cost of the hotel for this year. Show the provisional annual results for this year in total, showing variable and fixed cost sepa (b) 0) If there is no increase in guests for next year, what will be the required revenue rate (i) If the required revenue rate per guest is not raised above this year's level, how many (c) Outline and briefly discuss the assumptions that are made in typical profit-volume or rately. Show also the revenue and cost per guest. per hotel guest to meet the profit target? guests will be required to meet the profit target? break-even analysis and assess whether they limit its usefulness. 7.3 A hotel group prepares financial statements on a quarterly basis. The senior management is reviewing the performance of one hotel and making plans for next year The managers have in front of them the results for this year (based on some actual results and some forecasts to the end of this year) Profit/(loss) 000 (280) 360 680 40 800 Quarter Sales revenue 000 400 1,200 1,600 800 4,000 2 4 Total The total estimated number of guests (guest nights) for this year is 50,000, with each guest night being charged at the same rate. The results follow a regular pattern; there are no unexpected cost fluctuations beyond the seasonal trading pattern shown above. For next year, management anticipates an increase in unit variable cost of 10 per cent and a profit target for the hotel of 1 million. These will be incorporated into its plans. Required: (a) Calculate the total variable and total fixed cost of the hotel for this year. Show the provisional annual results for this year in total, showing variable and fixed cost sepa (b) 0) If there is no increase in guests for next year, what will be the required revenue rate (i) If the required revenue rate per guest is not raised above this year's level, how many (c) Outline and briefly discuss the assumptions that are made in typical profit-volume or rately. Show also the revenue and cost per guest. per hotel guest to meet the profit target? guests will be required to meet the profit target? break-even analysis and assess whether they limit its usefulness