Spreadsheet: 866936d1713856723-using-index-match-in-place-of-offset-functions-budget
Sheet: Hotel PY

 |  |  | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
 | QAR '000 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Q1 | Q2 | Q3 | Q4 | MTD | QTD | YTD | FY | MTD +1 | MTD +2 | MTD +3
 | Rooms |  | 1234 | 1234 | 1234 | 1234 | 1234 | 1234 | 1234 | 1234 | 1234 | 1234 | 1234 | 1234
 | F&B |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rentals & Other Income |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OOD |  | 5.365 | 5.380999999999999 | 11.01189 | 7.9565 | 7.874 | 16.542 | 5.931000000000001 | 14.47577 | 12.217 | 14.46174 | 7.91158 | 7.03633
 | Total Revenue
 | Rooms |  | 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110 | 1221 | 1332
 | F&B |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rentals |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OOD |  | 0.9055 | 1.031 | 1.1 | 0.9106000000000001 | 1.301 | 1.35 | 1.0748 | 1.106 | 1.4388 | 1.7025 | 1.5593 | 1.37
 | A&G |  | 12 | 81.99924999999999 | 99.36285000000001 | 222 | 22 | 84.97114 | 232 | 68.71135000000001 | 332 | 90.14839000000002 | 222 | 97.88404999999999
 | S&M |  | 28.12083 | 30.88537 | 12 | 29.4905 | 47.6225 | 48.9385 | 48.0865 | 23.6025 | 30.84071 | 53.04234 | 83.39935999999999 | 66.94549
 | IT |  | 21.60006 | 22.27106 | 16.60006 | 17.98956 | 19.10681 | 43 | 18.21481 | 534 | 18.21481 | 17.45421 | 15.01481 | 19.30383
 | HR |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 44 | 11
 | POMEC |  | 24.90396 | 28.98277 | 32.08136 | 24.52707999999999 | 28.93131999999999 | 33.03471999999999 | 27.17399999999999 | 23 | 28.01887 | 29.5047 | 27.8302 | 35.03597
 | Utilities |  | 74.38395999999999 | 55 | 55 | 44 | 85.4903 | 44 | 119.14324 | 44 | 44 | 11 | 66 | 89.22628
 | ARED Operating Expenses |  | 44 | 9.16360000000003 | 24.3886 | 8.663599999999974 | 42.76959999999997 | 8.663599999999974 | 8.663599999999974 | -8.885400000000061 | 4.720599999999934 | 5.463189999999997 | 4.598880000000008 | 6.157819999999901
 | Gross Operating Profit
 | [NAME] |  | 23.75285 | 25.05326 | 32.67704 | 28.1034 | 28.54179 | 31.1638 | 28.25108 | 26.94449 | 26.56656 | 30.11759 | 30.4447 | 31.87905
 | Incentive Fees |  | 44 | 55 | 103.55265 | 88.51817 | 86.76463000000001 | 94.79949 | 83.79651 | 54.41891 | 52.54794 | 90.90258 | 90.4042 | 150.26449
 | Common Areas Service Charges |  | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0
 | FF&E |  | 31.67047 | 33.40435 | 43.56939 | 55 | 38.05572 | 41.55173000000001 | 37.66811 | 35.92599 | 35.42208 | 40.15679 | 40.59293 | 42.5054
 | ARED non Operating Expenses |  | -1.438849039914203e-13 | 16.04499999999993 | 445 | 26.02250000000012 | 8.02250000000012 | 8.022499999999892 | 8.02250000000012 | 563 | 8.022499999999892 | 8.130500000000067 | 8.02250000000012 | 48.73460000000009
 | Master Community Charges |  | 320.54061 | 320.54061 | 317.04156 | 319.374 | 319.374 | 319.374 | 319.374 | 319.374 | 319.374 | 438.9009500000001 | 347.50515 | 347.5069600000001
 | Total Owners Expenses
 | EBITDA
 | Interest |  | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666 | 6666
 | Depreciation |  | 315.7564999999996 | 285.1830299999999 | 315.7385199999995 | 305.5535200000004 | 315.7381999999997 | 305.5532600000001 | 315.7382899999998 | 315.7383199999999 | 305.5532800000001 | 315.6195300000009 | 305.4385100000001 | 295.3900800000008
 | Net Income
 | TOTAL ROOMS | 199
 | Rooms Available
 | Room Nights
 | Occupancy |  | 0.5616793645647593 | 0.6110911701363962 | 0.7711136326795267 | 0.6820770519262982 | 0.7145404441562652 | 0.790284757118928 | 0.7213486788782623 | 0.6999513697519857 | 0.7341708542713568 | 0.8184470740800778 | 0.8574061662198391 | 0.8805194805194805
 | ADR
 | RevPar
 | ADR Short Stay
 | ADR Extended Stay
 | TOTAL HEADCOUNTS |  | 27.95 | 27.5 | 27.5 | 27.5 | 26.5 | 27.5 | 27.5 | 27.5 | 27.5 | 28.6 | 28.6 | 28.6
 | HOTEL HEADCOUNTS |  | 23.1 | 21.1 | 23.1 | 23.1 | 21.1 | 23.1 | 23.1 | 23.1 | 23.1 | 20.1 | 20.1 | 20.1
 | Total Common Areas Headcounts |  | 27.95 | 27.5 | 27.5 | 27.5 | 26.5 | 27.5 | 27.5 | 27.5 | 27.5 | 28.6 | 28.6 | 28.6
 | TOTAL ROOMS HEADCOUNTS |  | 23.1 | 21.1 | 23.1 | 23.1 | 21.1 | 23.1 | 23.1 | 23.1 | 23.1 | 20.1 | 20.1 | 20.1
 | TOTAL F&B HEADCOUNT |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Electricity
 | Water
 | Qatar Cool
 | Utilities Expenses
 | Utilities Expenses %
 | Utilities POR
 | Utilities PAR
 | Electricity Unit Cost |  | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13
 | Electricity  - KWH |  | 88830.76923076923 | 35938.46153846154 | 58069.23076923077 | 57884.61538461538 | 126538.4615384615 | 126538.4615384615 | 76923.07692307692 | 76923.07692307692 | 76923.07692307692 | 71492.30769230769 | 61538.46153846154 | 73076.92307692308
 | Electric Usage PAR (KWH)
 | Electric Usage POR (KWH)
 | Water Unit Cost |  | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5
 | Water  - CM |  | 853.8181818181819 | 541.4545454545455 | 710.1818181818181 | 1084.363636363636 | 854.5454545454545 | 854.5454545454545 | 854.5454545454545 | 1127.272727272727 | 1127.272727272727 | 983.6363636363636 | 909.0909090909091 | 1363.636363636364
 | Water Usage PAR (CM)
 | Water Usage POR (CM)
 | Chilled Water Unit Cost |  | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 0.3161
 | Chilled Water  - CM |  | 12721.875 | 9208.875 | 42059.90625 | 34199.09375 | 63509.375 | 119758 | 114041.5625 | 145854.53125 | 96599.66999999991 | 96075.34999999996 | 67136 | 24591
 | Chilled Water Usage PAR (CM)
 | Chilled Water Usage POR (CM)
 | Diesel Unit Cost
 | Diesel  - LTR
 | Diesel Usage PAR (LTR)
 | Diesel Usage POR (LTR)
 | Electricity Tariff
 | 4000 |  | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13
 | 10000 |  | 0.17 | 0.17 | 0.17 | 0.17 | 0.17 | 0.17 | 0.17 | 0.17 | 0.17 | 0.17 | 0.17 | 0.17
 | >10000 |  | 0.22 | 0.22 | 0.22 | 0.22 | 0.22 | 0.22 | 0.22 | 0.22 | 0.22 | 0.22 | 0.22 | 0.22
 | Water Tariff
 | 50 |  | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 | >50 |  | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6
HOTEL ONLY | CTC
 | Rooms |  | 15.9285 | 17.8285 | 15.9285 | 16.9285 | 18.1485 | 16.9285 | 16.3285 | 8.1285 | 15.92334 | 16.52334 | 16.52334 | 16.52334
 | F&B |  | 7.28429 | 7.95529 | 2.28429 | 7.28429 | 7.33929 | 7.28429 | 7.28429 | 7.28429 | 7.28429 | 6.523689999999999 | 4.08429 | 7.35029
 | A&G |  | 50.77282999999999 | 50.88685 | 48.65685 | 53.6899 | 51.89413 | 51.83123000000001 | 37.24157 | 35.47723000000001 | 55.68184 | 55.93251 | 57.15987000000001 | 60.60912
 | S&M |  | 15.9285 | 17.8285 | 15.9285 | 16.9285 | 18.1485 | 16.9285 | 16.3285 | 8.1285 | 15.92334 | 16.52334 | 16.52334 | 16.52334
 | IT |  | 7.28429 | 7.95529 | 2.28429 | 7.28429 | 7.33929 | 7.28429 | 7.28429 | 7.28429 | 7.28429 | 6.523689999999999 | 4.08429 | 7.35029
 | HR |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | POMEC |  | 7.87442 | 7.07442 | 7.34109 | 4.14109 | 7.60775 | 7.87442 | 7.87442 | 7.87442 | 7.87442 | 7.74109 | 8.07742 | 6.31609