revenue project

profilemariya kurganova
revenumanagement.xlsx

Sheet1

Année Date Royal Hotel Occupancy ADR Royal Hotel Royal Hotel RevPar STR Occupancy STR ADR STR RevPar Ecart Ecart Ecart Rooms 210
2014 Jan-2014 60% 265.45 159.27 68% 294.07 200.92 -8% -28.62 -41.65
Feb-2014 61% 268.41 163.46 66% 277.44 182.57 -5% -9.03 -19.11
Mar-2014 64% 281.96 181.02 68% 280.16 191.89 -4% 1.80 -10.88
Apr-2014 63% 274.09 172.95 69% 288.12 198.83 -6% -14.03 -25.88
May-2014 63% 272.50 170.86 79% 325.23 256.76 -16% -52.73 -85.90
Jun-2014 65% 279.85 181.34 80% 333.09 265.22 -15% -53.24 -83.87
Jul-2014 66% 281.74 186.23 81% 300.94 243.25 -15% -19.20 -57.02
Aug-2014 65% 277.04 178.97 88% 385.63 338.51 -23% -108.59 -159.54
Sep-2014 66% 286.15 187.71 91% 488.98 443.94 -25% -202.83 -256.23
Oct-2014 69% 300.38 206.36 87% 403.46 350.26 -18% -103.08 -143.90
Nov-2014 66% 285.99 187.32 83% 338.20 279.13 -17% -52.21 -91.80
Dec-2014 67% 293.30 197.39 80% 312.04 248.31 -12% -18.74 -50.92
2015 Jan-2015 69% 300.46 207.62 71% 300.98 213.89 -2% -0.52 -6.27
Feb-2015 70% 306.08 214.87 70% 311.90 217.62 0% -5.82 -2.75
Mar-2015 74% 321.31 238.41 74% 286.80 213.65 -0% 34.51 24.76
Apr-2015 74% 319.47 235.77 75% 319.77 240.41 -1% -0.30 -4.64
May-2015 73% 316.56 230.77 79% 337.01 267.43 -6% -20.45 -36.66
Jun-2015 75% 328.30 247.54 78% 336.64 262.60 -3% -8.34 -15.07
Jul-2015 77% 336.57 257.48 83% 354.86 295.83 -7% -18.29 -38.35
Aug-2015 74% 326.96 241.30 87% 409.61 354.88 -13% -82.65 -113.58
Sep-2015 74% 329.35 244.71 86% 478.38 411.35 -12% -149.03 -166.64
Oct-2015 78% 345.19 267.87 85% 408.49 346.86 -7% -63.30 -79.00
Nov-2015 72% 324.90 234.90 70% 322.31 224.76 3% 2.59 10.15
Dec-2015 74% 334.62 245.95 73% 334.76 243.98 1% -0.14 1.97
2016 Jan-2016 74% 343.26 255.04 60% 304.76 183.77 14% 38.50 71.27
Feb-2016 75% 348.92 260.99 63% 329.49 208.38 12% 19.43 52.61
Mar-2016 78% 368.48 286.68 67% 309.09 206.99 11% 59.39 79.69
Apr-2016 77% 370.92 286.35 79% 399.71 314.49 -1% -28.79 -28.14
May-2016 75% 366.44 276.30 70% 332.28 231.09 6% 34.16 45.20
Jun-2016 78% 379.92 294.44 71% 336.62 237.53 7% 43.30 56.90
Jul-2016 78% 385.24 299.33 75% 363.59 274.42 2% 21.65 24.92
Aug-2016 73% 366.68 268.04 65% 356.56 230.59 8% 10.12 37.45
Sep-2016 74% 371.67 273.92 82% 491.75 405.47 -9% -120.08 -131.55
Oct-2016 76% 386.01 294.91 77% 381.89 295.50 -1% 4.12 -0.59
Nov-2016 72% 364.67 262.93 69% 325.71 225.27 3% 38.96 37.66
Dec-2016 74% 373.34 274.40 69% 332.99 230.46 4% 40.35 43.95
2017 Jan-2017 65% 389.02 252.86 61% 324.24 198.15 4% 64.78 54.72
Feb-2017 66% 390.45 258.48 69% 349.58 239.57 -2% 40.87 18.91
Mar-2017 69% 389.78 269.73 64% 297.66 190.39 5% 92.12 79.34
Apr-2017 68% 381.81 257.72 67% 310.87 209.68 0% 70.94 48.05
May-2017 67% 382.30 256.91 75% 338.52 253.51 -8% 43.78 3.39
Jun-2017 69% 381.30 264.62 68% 324.15 220.34 1% 57.15 44.28
Jul-2017 71% 381.33 269.22 80% 363.39 289.93 -9% 17.94 -20.71
Aug-2017 69% 380.47 262.52 76% 347.33 262.78 -7% 33.14 -0.26
Sep-2017 70% 383.12 268.57 85% 509.22 432.44 -15% -126.10 -163.88
Oct-2017 73% 384.33 282.10 77% 393.24 304.19 -4% -8.91 -22.09
Nov-2017 69% 383.06 265.84 71% 312.99 222.38 -2% 70.07 43.47
Dec-2017 72% 383.38 274.50 75% 338.39 253.54 -3% 44.99 20.96
2018 Jan-2018 63% 382.10 241.49 61% 308.69 188.72 2% 73.41 52.77
Feb-2018 64% 382.67 243.38 62% 357.09 222.70 1% 25.58 20.68
Mar-2018 67% 382.53 255.15 64% 297.12 189.42 3% 85.41 65.73
Apr-2018 66% 382.79 253.41 71% 319.18 227.33 -5% 63.61 26.08
May-2018 65% 382.44 247.82 67% 333.26 223.25 -2% 49.18 24.57
Jun-2018 68% 383.97 259.95 76% 344.24 260.47 -8% 39.73 -0.52
Jul-2018 69% 382.89 264.19 86% 352.76 301.78 -17% 30.13 -37.58
Aug-2018 67% 384.93 256.36 76% 368.71 279.72 -9% 16.22 -23.35
Sep-2018 67% 380.04 256.15 84% 461.28 389.56 -17% -81.24 -133.41
Oct-2018 71% 388.70 275.98 82% 473.07 389.16 -11% -84.37 -113.19
Nov-2018 67% 390.20 262.60 75% 332.52 248.64 -7% 57.68 13.97
Dec-2018 69% 390.31 269.70 78% 340.79 266.51 -9% 49.52 3.20
2019 Jan-2019 61% 392.11 240.36 64% 334.18 212.36 -2% 57.93 28.00
Feb-2019 62% 393.72 245.29 67% 378.93 254.57 -5% 14.79 -9.28
Mar-2019 66% 395.83 259.27 65% 325.78 212.15 0% 70.05 47.12
Apr-2019 65% 404.39 260.83 69% 422.05 289.44 -4% -17.66 -28.61
May-2019 64% 402.39 259.14 75% 316.35 237.98 -11% 86.04 21.16
Jun-2019 67% 402.65 268.57 75% 347.17 261.37 -9% 55.48 7.20
Jul-2019 68% 403.74 272.52 87% 363.37 315.50 -19% 40.37 -42.97
Aug-2019 65% 402.33 262.32 76% 353.41 267.08 -10% 48.92 -4.76

Sheet2