Spreadsheet: 64891d1265725721-formula-that-changes-acording-to-the-date-budget-to-actual
Sheet: Sheet1

 | BUDGET  COMPARISON  TO  ACTUAL  2010
 | 2008 RSD | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | 2008
 | RSD TOTAL IN | 387772916.5 | 464380284 | 486251102.5 | 456534480.5 | 467205983 | 419852146.5 | 464308804 | 487415817 | 559037010.5 | 609167462.5 | 621742625.04 | 293283444 |  | 5716952076.04
 | RSD WIN | 19856327 | 26557397 | 28204783.5 | 23534906.87 | 20268345.06 | 23818292 | 20407114 | 22100791.5 | 30116565.5 | 36740167 | 34267875.5 | 13023410.5 |  | 298895975.43
 | 2009 RSD | 0.05213002771259083 | 0.06120796244716967 | - | - | - | - | - | - | - | - | - | - |  | 0.05413692637113147
 | TOTAL IN | 612403405.5 | 173812092 |  |  |  |  |  |  |  |  |  |  |  | 786215497.5
 | DROP | 118364320 | 37519780 |  |  |  |  |  |  |  |  |  |  |  | 155884100
 | WIN | 31924606.5 | 10638684 |  |  |  |  |  |  |  |  |  |  |  | 42563290.5
 | TOTAL IN % | 0.2260991329513435 | 0.01960971737225279 | - | - | - | - | - | - | - | - | - | - |  | 0.1804496164869861
 | DROP % | 0.1832758385297191 | -0.0836060339372992 | - | - | - | - | - | - | - | - | - | - |  | 0.1190399790613667
 | WIN % | 0.1835853795096895 | 0.1967649382198024 | - | - | - | - | - | - | - | - | - | - |  | 0.1868796069702365
 | Total number of days for month = | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 |  | 365
 | Actual days in month = | 31 | 7 |  |  |  |  |  |  |  |  |  |  |  | 38
 | 2009 EUR
 | TOTAL IN | 6804000 | 1850000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8364000
 | WIN | 355000 | 110000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 453000
 | TI 08 - 09 % | 0.1740152851263962 | 0.01960971737225279 | - | - | - | - | - | - | - | - | - | - |  | 0.1804496164869861
 | WIN 08 - 09 % | 0.1323943661971831 | 0.1967649382198024 | - | - | - | - | - | - | - | - | - | - |  | 0.1868796069702365
 | RSD to EUR-2009 | 90
 | RSD to EUR-2010 | 94
 | 3% Tax DLS | 1133564.925 | 381960.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1515525.045
 | ACTUAL TO DATE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | 2010
 | TOTAL IN | 750867284.5 | 177220498 |  |  |  |  |  |  |  |  |  |  |  | 928087782.5
 | DROP | 140057640 | 34382900 |  |  |  |  |  |  |  |  |  |  |  | 174440540
 | WIN | 37785497.5 | 12732004 |  |  |  |  |  |  |  |  |  |  |  | 50517501.5
 | COMPARISON - EURO VALUES
 | TOTAL IN | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | 2009
 | BUDGET TOTAL | 7850000 | 7360000 | 8620000 | 8220000 | 7960000 | 7290000 | 6570000 | 6190000 | 7730000 | 8260000 | 8690000 | 9270000 |  | 94010000
 | BUDGET TO DATE | 7849000 | 1840000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 9689000
 | ACTUAL TO DATE | 7988000 | 1885000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 9873000
 | ± | 139000 | 45000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 184000
 | ± % | 0.01770926232641101 | 0.02445652173913044 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0.01899060790587264
 |  | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 |  | 365
 | WIN | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | 2009
 | BUDGET TOTAL | 390000 | 370000 | 430000 | 410000 | 400000 | 360000 | 330000 | 310000 | 390000 | 410000 | 430000 | 460000 |  | 4690000
 | BUDGET TO DATE | 392000 | 92000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 484000
 | ACTUAL TO DATE | 402000 | 135000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 537000
 | ± | 10000 | 43000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 53000
 | ± % | 0.02551020408163265 | 0.4673913043478261 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0.109504132231405
 | HOLD PERCENTAGE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | 2010
 | BUDGET | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 |  | 0.055
 | ACTUAL | 0.05032247146732626 | 0.07184272780905965 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0.05443181394320316
 | ± | -0.004677528532673739 | 0.01684272780905965 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | -0.0005681860567968433
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL IN
 | TOTAL IN | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | 2010 |  | Actual - 2009 | Act-09 to Budget-10 %
 | BUDGET TOTAL | 737819214.3636364 | 691860601.939394 | 810409357.3333334 | 772733780 | 748653564.060606 | 685709487.2727273 | 617557932.7272727 | 581804578.7272727 | 726600420 | 776822873.2727273 | 816770169.0909092 | 871081715.6363639 |  | 8837823694.424242 |  | 7770664832.7 | 0.1373317321876366
 | BUDGET TO DATE | 737819214.3636364 | 172965150.4848485 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 910784364.8484849 | Daily | 21289492.69232877 | 24213215.60116231
 | ± | 13000000 | 4300000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 17300000 |  | Act-YTD | 24423362.69736842
 | ± % | 0.0176194923457129 | 0.02486049928523997 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0.01899461680249416 |  | Diff | 210147.0962061137
 | 86963803.18181819 | 925146.842359768 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP
 | DROP | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | 2010 |  | Actual - 2009 | Act-09 to Budget-10 %
 | BUDGET TOTAL | 141888310.4545455 | 133050115.7575758 | 155847953.3333333 | 148602650 | 143971839.2424242 | 131867209.0909091 | 118761140.9090909 | 111885495.9090909 | 139730850 | 149389014.0909091 | 157071186.3636364 | 167515714.5454546 |  | 1699581479.69697 |  |  | #N/A
 | BUDGET TO DATE | 141888310.4545455 | 33262528.93939395 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 175150839.3939394 | Daily | 0 | #N/A
 | ± | -1800000 | 1100000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | -175200000 |  | Act-YTD | 4590540.52631579
 | ± % | -0.01268603448891329 | 0.03307024556083084 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | -1.000280675823369 |  | Diff | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIN
 | WIN | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | 2010 |  | Actual - 2009 | Act-09 to Budget-10 %
 | BUDGET TOTAL | 36890960.71818182 | 34593030.0969697 | 40520467.86666667 | 38636689 | 37432678.2030303 | 34285474.36363637 | 30877896.63636364 | 29090228.93636363 | 36330021 | 38841143.66363636 | 40838508.45454546 | 43554085.78181819 |  | 441891184.7212121 |  | 394460608.2 | 0.1202416047007762
 | BUDGET TO DATE | 36890960.71818182 | 8648257.524242425 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 45539218.24242424 | Daily | 1080713.995068493 | 1210660.780058115
 | ± | 900000 | 4100000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 5000000 |  | Act-YTD | 1329407.934210526
 | ± % | 0.0243962201709871 | 0.4740839398580645 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0.109795472846787 |  | Diff | 118747.1541524108
 | DAILY RESULTS
 | Budget per day (TI) | 23800619.81818182 | 24709307.21212121 | 26142237.33333334 | 25757792.66666667 | 24150114.96969697 | 22856982.90909091 | 19921223.63636364 | 18767889.63636364 | 24220014 | 25058802.36363636 | 27225672.30303031 | 28099410.18181819 |  | 24213215.60116231
 | Budget per day (DROP) | 4577042.272727273 | 4751789.84848485 | 5027353.333333334 | 4953421.666666667 | 4644252.878787879 | 4395573.636363637 | 3831004.545454545 | 3609209.545454545 | 4657695 | 4819000.454545455 | 5235706.212121213 | 5403732.727272728 |  | 4656387.615608135
 | Budget per day (WIN) | 1190030.990909091 | 1235465.360606061 | 1307111.866666667 | 1287889.633333333 | 1207505.748484849 | 1142849.145454546 | 996061.1818181819 | 938394.4818181817 | 1211000.7 | 1252940.118181818 | 1361283.615151515 | 1404970.509090909 |  | 1210660.780058115
 | Actual per day (TI) | 24221525.30645161 | 25317214 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 24423362.69736842
 | Actual per day (DROP) | 4517988.387096774 | 4911842.857142857 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 4590540.52631579
 | Actual per day (WIN) | 1218887.016129032 | 1818857.714285714 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1329407.934210526
 | Diff (TI) | 420905.488269791 | 607906.7878787853 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 210147.0962061137
 | Diff (DROP) | -59053.88563049957 | 160053.0086580077 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | -65847.08929234557
 | Diff (WIN) | 28856.02521994128 | 583392.3536796535 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 118747.1541524108
 | Round up value = | 100000
 |  | Department:  SLOT
 |  | WIN | JAN | 2010 |  | DROP | JAN | 2010
 |  | BUDGET TO DATE | 36900000 | 45500000 |  | BUDGET TO DATE | 141900000 | 175200000
 |  | ACTUAL TO DATE | 37800000 | 50500000 |  | ACTUAL TO DATE | 174400000 | 174400000
 |  | ± (in numbers) | 900000 | 5000000 |  | ± (in numbers) | 32500000 | -800000
 |  | ± % (percentage) | 0.02439024390243903 | 0.1098901098901099 |  | ± % (percentage) | 0.2290345313601128 | -0.0045662100456621
 |  | COMPARISON TO 2009 |  |  |  | COMPARISON TO 2009
 |  | Actual to DATE (2009) | 31900000 | 42600000 |  | Actual to DATE (2009) | 118400000 | 155900000
 |  | ± in numbers | 5900000 | 7900000 |  | ± in numbers | 56000000 | 18500000
 |  | ± percentage | 0.1849529780564263 | 0.1854460093896714 |  | ± percentage | 0.472972972972973 | 0.1186658114175754
 | Budgeted DROP per Guest = | 6654
 | FORECAST | SUN | MON | TUE | WED | THU | FRI | SAT | Ave per day | ACTUAL | DIFF | % increase
 | VISITS | 700 | 590 | 625 | 615 | 650 | 870 | 920 | 710
 | SM DROP | 4657800 | 3925860 | 4158750 | 4092210 | 4325100 | 5788980 | 6121680 | 4724340 | 4590540.52631579 | -133799.4736842103 | 0.02914677975658635