Question 5: With data from the five hotels provided below, conduct a supply and demand analysis. A. Calculate the current nightly demand and the average occupancy for the five hotels. Hotel Average Rooms in Hotel Average Occupancy Current Nightly Demand A 150 80% B 125 75% ? C 85 70% ? 85% ? E 105 90% ? Total ? ? D 195 ? What is the average occupancy for the five hotels? (rounded to the nearest hundredth place) Total Marks (8 Points) B. Calculate the composite growth for each source of travellers and the total rate. Rounded to the nearest hundredth place. Annual Compound Source Source of Demand Growth Composite Growth Business Travellers 25% 8% Convention Delegates 35% 6% Vacationers 40% 4% Total 100X Total Marks (4 points)