3 1. Using the formula's discussed in class, calculate the rooms sold and the property occupancy (2 Decimal Places) 4 ROOMS ROOMS SOLD OCC % 5 AVAILABLE 6 Hotel A 350 83.33% 7 Hotel B 305 190 8 Hotel C 400 216 9 Hotel D 240 197 10 11 Hotel E Total 500 54.33% 12 13 + 14 2. Using the formula's discussed in class, now calculate each individual hotels Average Daily Rate (ADR) (2 Decimal Places) 15 16 ROOMS AVAILABLE ROOMS SOLD OCC % ADR REVENUE 17 Hotel A 350 0 $53,387.86 18 Hotel B 305 190 $50,435.50 19 Hotel C 400 216 $43,124.40 20 Hotel D 240 197 $37,284.22 21 Hotel E 500 0 $1,07,358.25 22 Total 0 0.00%