Spreadsheet: 486552d1477544083-solver-complex-functionality-solver-test
Sheet: Dashboard (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10556
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Rms | Occ | ADR | Rem. Supply to [NAME] | Rem. Supply to Fcst | Rem. Supply to Stretch | [NAME] to [NAME] | [NAME] to Fcst | [NAME] to Stretch |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10556
 | Projections 1 | 3923 | 0.3716369837059492 | 122.7583176140707 | 3177 | 2248 | 0 | 450424.1200000005 | 317169.1969661893 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 481580.8799999995
 | Projections 2 | 3483 | 0.3299545282303903 | 117.5483433821417 | 3617 | 2688 | 0 | 522584.1200000005 | 389329.1969661893 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 409420.8799999995
 | Forecast | 6171 | 0.584596438044714 | 129.4360844216802 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 798750.0769661888
 | Budget Rms | 7100 | 0.6726032588101554 | 131.2683098591549 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 932005
 | [NAME] |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Budget |  |  |  |  | Projections |  |  |  |  | Gap to [NAME] |  |  |  | Remaining Supply Forecast
 |  | Rms | ADR | Rev | Rms Mix % | [NAME] | Rms | ADR | Rev | Rms Mix % | [NAME] | Rms | ADR | Rev | Mix % | Rms | ADR | Rev | Mix %
 | Retail | 84 | 198.03 | 16634.52 | 0.044 | 0.06882328847037017 | 5 | 224 | 1120 | 0.01219512195121951 | 0.02018583585130609 | 79 | 196.3863291139241 | 15514.52 | 0.03180487804878049
 | Retail 2 | 420 | 158.28 | 66477.6 | 0.221 | 0.2750429252913748 | 60 | 156.2 | 9372 | 0.1463414634146341 | 0.1689121907128934 | 360 | 158.6266666666667 | 57105.60000000001 | 0.07465853658536586
 | Retail 3 | 136 | 134.61 | 18306.96 | 0.071 | 0.0757428040662146 | 9 | 150.6777777777778 | 1356.1 | 0.02195121951219512 | 0.02444108214103231 | 127 | 133.4713385826772 | 16950.86 | 0.04904878048780487
 | Retail 4 | 236 | 132.88 | 31359.68 | 0.124 | 0.129746833871882 | 31 | 164.4838709677419 | 5099 | 0.07560975609756097 | 0.09189962232661585 | 205 | 128.1008780487805 | 26260.68 | 0.04839024390243903
 | Retail 5 | 116 | 102.49 | 11888.84 | 0.061 | 0.04918861890202277 | 61 | 108.0565573770492 | 6591.45 | 0.148780487804878 | 0.1187981497518674 | 55 | 96.31618181818182 | 5297.39 | -0.08778048780487804
 | Retail 6 | 412 | 112.96 | 46539.52 | 0.217 | 0.1925515620668683 | 5 | 161 | 805 | 0.01219512195121951 | 0.01450856951812625 | 407 | 112.369828009828 | 45734.52 | 0.2048048780487805
 | Retail 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Retail 8 | 113 | 137.77 | 15568.01 | 0.059 | 0.06441073401213908 | 18 | 158.5 | 2853 | 0.04390243902439024 | 0.05141981221765738 | 95 | 133.8422105263158 | 12715.01 | 0.01509756097560976
 | Retail 9 | 50 | 129.84 | 6492 | 0.027 | 0.02685985461255529 | 3 | 179.6666666666667 | 539 | 0.007317073170731708 | 0.009714433503441054 | 47 | 126.6595744680851 | 5953 | 0.01968292682926829
 | Retail 10 | 122 | 132.85 | 16207.7 | 0.064 | 0.06705737301354163 | 0 | 0 | 0 | 0 | 0 | 122 | 132.85 | 16207.7 | 0.064
 | Retail 11 | 12 | 125.18 | 1502.16 | 0.006 | 0.0062150029582249 | 8 | 139.5 | 1116 | 0.01951219512195122 | 0.02011374358040856 | 4 | 96.54000000000002 | 386.1600000000001 | -0.01351219512195122
 | Retail 12 | 96 | 44.35 | 4257.6 | 0.05 | 0.01761529836697711 | 0 | 0 | 0 | 0 | 0 | 96 | 44.35 | 4257.6 | 0.05
 | Retail 13 | 26 | 89 | 2314 | 0.014 | 0.00957389149313816 | 5 | 92.17999999999999 | 460.9 | 0.01219512195121951 | 0.008306831914166942 | 21 | 88.24285714285713 | 1853.1 | 0.001804878048780488
 | Retail 14 | 76 | 110.23 | 8377.48 | 0.04 | 0.03466079710714566 | 205 | 127.6682926829268 | 26172 | 0.5 | 0.4716997284824848 | -129 | 0 | -17794.52 | -0.46
 | Total Retail | 1900 | 127.21 | 241699 | 0.407 | 0.4586190772549782 | 410 | 135.3279268292683 | 55484.45 | 0.1546586193889098 | 0.1984680198801217 | 1490 | 124.9762080536913 | 186214.55 | 0.2523413806110901
 | Discount | 2012 | 113.82 | 229005.84 | 0.431 | 0.434534056933629 | 1481 | 116.1372248480756 | 171999.23 | 0.5586571105243304 | 0.6152416866168023 | 531 | 107.3570809792843 | 57006.60999999999 | -0.1276571105243304
 | Supplier | 760 | 68.53 | 52082.8 | 0.163 | 0.0988260840005775 | 760 | 68.52631578947368 | 52080 | 0.2866842700867597 | 0.1862902935030759 | 0 | 0 | 2.80000000000291 | -0.1236842700867597
 | Total | 4671 | 112.8269556840077 | 527014.7100000001 |  |  | 2651 | 105.4559336099585 | 279563.68 |  |  | 2020 | 122.5005099009901 | 247451.0300000001