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. Average Rooms in Hotel 150 Average Occupancy 80% Hotel Current Nightly Demand B 125 75% 85 70% D. 195 85% 105 90% Total 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. Anrnual Compound Growth Source Source of Demand 25% Composite Growth Business Travelless Convention Delegites 8% 35% 6% Vacationers 40% 4% Total 1006 Total Marks (4 Points)