QUESTION 4: PROFITABILITY An analysis of performance of the Exeter hotel is requested by the Senior Management based in Spain. Similar hotels in Germany have been more profitable for the 6-month period from May 2021. One possible reason is that the Exeter hotel manager has been giving discounts on bookings, so that half of all rooms were booked at 85 per night, instead of the standard rate of 105. Month May June July Occupancy (rooms) 400 1,050 1,500 2,300 1,950 1,850 Aug Sept Oct Variable costs per occupied room are estimated at 25 per room per night; Fixed costs 1,000 per night. Requirement: Section of your report to the Buenos Dias Operations Manager Evaluate and advise on the profitability of the Exeter hotel over the 6 months and for future consideration