Spreadsheet: 181411d1348031762-struggling-with-vlookups-capex-report-aug-2012-1-final-dp
Sheet: Facilities

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105
 |  |  |  |  |  |  |  |  |  |  |  |  | Actual plus |  |  |  |  | 106
 |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 |  |  | Actual plus | Forecast | 2012 |  |  |  | 110
 |  | January | February | March | April | May | June | July | August | 2012 | 2012 Forecast | Forecast | [NAME] | Annual | Actual vs. |  |  | 112
 | Description | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual YTD | to be Spent | to be Spent | to Budget | Budget | Budget Variance |  |  | 113
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 117
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 122
 | Planned CapEx - Recurring: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125
 | PC Replacement | 0 | 603 | 0 | 4857 | 0 | 0 | 4852 | 413 | 10725 | 1394 | 12119 | 881 | 13000 | 2275
 | Seal Coat/Restripe or Repairs Parking Lot | 0 | 0 | 0 | 2150 | 900 | 4152 | 0 | 0 | 7202 | 3750 | 10952 | 298 | 11250 | 4048
 | PTAC Coil Replacement | 850 | 2638 | 2619 | 0 | 650 | 1977 | 1899 | 1925 | 12558 | 2763 | 15321 | 35879 | 51200 | 38642
 | Flooring Replacements-Carpet (Material) | 1746 | 27881 | 0 | 1757 | 612 | 1160 | 931 | 595 | 34682 | 20535 | 55217 | 5598 | 60815 | 26133
 | Flooring Replacements-Carpet (Labor) | 0 | 0 | 0 | 489 | 6548 | 2334 | 1937 | 2217 | 13525 | 12826 | 26351 | -3851 | 22500 | 8975
 | Flooring Replacements - Vinyl | 0 | 0 | 0 | 1341 | 4091 | 325 | 931 | 0 | 6688 | 13272 | 19960 | 1040 | 21000 | 14312
 | Interior Furnishing Replacements | 737 | 1295 | 564 | 0 | 0 | 403 | 336 | 284 | 3619 | 0 | 3619 | -3619 | 0 | -3619
 | Night Stands | 0 | 0 | 388 | 3384 | 0 | 0 | 0 | 0 | 3772 | 1500 | 5272 | 9353 | 14625 | 10853
 | Dressers | 0 | 0 | 0 | 4021 | 0 | 0 | 0 | 0 | 4021 | 2250 | 6271 | 11929 | 18200 | 14179
 | Dining Room Chairs | 0 | 10428 | 979 | 994 | 0 | 19238 | 69 | 0 | 31708 | 8245 | 39953 | 28247 | 68200 | 36492
 | Bed - Mattress & Box Springs | 0 | 7532 | 0 | 0 | 0 | 0 | 0 | 3774 | 11306 | 4281 | 15587 | 4488 | 20075 | 8769
 | Bed - Head Board | 0 | 0 | 0 | 1456 | 0 | 0 | 0 | 0 | 1456 | 0 | 1456 | 4264 | 5720 | 4264
 | Beverage Bar Repair | 0 | 0 | 0 | 0 | 0 | 0 | 532 | 0 | 532 | 0 | 532 | 10618 | 11150 | 10618
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 4294 | 0 | 0 | 4294 | 1500 | 5794 | 506 | 6300 | 2006
 | Bed Spreads | 0 | 2818 | 0 | 3118 | 300 | 0 | 0 | 0 | 6236 | 0 | 6236 | 16024 | 22260 | 16024
 | AL Dining Table Cloths | 3900 | 1639 | 0 | 3900 | 0 | 188 | 326 | 0 | 9953 | 31000 | 40953 | 36447 | 77400 | 67447
 | ALZ Dining Table Cloths | 4990 | 4174 | 1781 | 7289 | 0 | 785 | 2167 | 0 | 21186 | 17000 | 38186 | 8614 | 46800 | 25614
 | Replace Furniture | 2570 | 1391 | 1752 | 392 | 568 | 472 | 3483 | 1494 | 12122 | 38000 | 50122 | 16428 | 66550 | 54428
 | [NAME] | 450 | 0 | 0 | 0 | 508 | 0 | 0 | 474 | 1432 | 6950 | 8382 | 13068 | 21450 | 20018
 | Resident Room Chair Replacement | 2793 | 3653 | 1249 | 0 | 5064 | 0 | 5711 | -291 | 18179 | 13675 | 31854 | 7191 | 39045 | 20866
 | Repaint Carillon Road Sign | 787 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 1187 | 2625 | 3812 | -62 | 3750 | 2563
 | Bathroom Faucets | 0 | 0 | 0 | 0 | 0 | 0 | 349 | 0 | 349 | 900 | 1249 | 1751 | 1200 | 2651
 | Shower Faucets | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1050 | 1050 | 18450 | 3000 | 19500
 | Seasonal Decorations | 753 | 297 | 135 | 414 | 391 | 0 | 0 | 120 | 2110 | 10750 | 12860 | 1180 | 19500 | 11930
 | Pendants | 674 | 1696 | 2645 | 1808 | 2956 | 3407 | 3633 | 200 | 17019 | 5758 | 22777 | -10177 | 14040 | -4419
 | Pagers | 338 | 422 | 270 | 613 | 1153 | 915 | 163 | 671 | 4545 | 5570 | 10115 | 2235 | 12600 | 7805
 | Clinical Supplies (Ref., BP Supplies, Charts) | 409 | 1797 | 27 | 0 | 315 | 633 | 214 | 892 | 4287 | 5300 | 9587 | -8637 | 12350 | -3337
 | Remove Trees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 950 | 1250
 | Replace Trees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22750 | 1250 | 22750
 | Linens Replacement (Linens/Towels) | 0 | 478 | 645 | 409 | 1030 | 538 | 754 | 421 | 4275 | 14450 | 18725 | -12225 | 22750 | 2225
 | Mixing Valves & Parts | 0 | 0 | 1630 | 0 | 1231 | 0 | 1350 | 0 | 4211 | 0 | 4211 | 9829 | 6500 | 9829
 | Patio Chairs | 0 | 1952 | 0 | 1952 | 0 | 0 | 0 | 0 | 3904 | 9604 | 13508 | -2588 | 14040 | 7016
 | Front Porch Rockers | 0 | 1549 | 0 | 0 | 0 | 0 | 0 | 0 | 1549 | 0 | 1549 | 69886 | 10920 | 69886
 | Other | 4865 | 854 | 4069 | 9074 | 2458 | 981 | 1851 | 8658 | 32810 | 14500 | 47310 | -47310 | 71435 | -32810
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 25862 | 73097 | 18753 | 49418 | 28775 | 42202 | 31488 | 21847 | 291442 | 249448 | 540890 | 249735 | 791825 | 499183
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Snack Cart | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 895 | 895 | 895
 | Irrigation & Plants at Carillon Sign | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 2500 | 2500
 | Sidewalk Repair | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 2500 | 0 | 2500 | 2500
 | Repair Roof Leaks | 0 | 900 | 0 | 0 | 526 | 211 | 0 | 0 | 1637 | 0 | 1637 | 11863 | 13500 | 11863
 | Raise Shed Door | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 750
 | ALZ Dining Chairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10800 | 10800 | 0 | 10800 | 10800
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500 | 1000 | 1000
 | Repair Garden Place Counter | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | Vanity and Crib | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1700 | 1700 | 1700
 | Paint [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900 | 900 | 0 | 900 | 450 | 1350 | 450
 | Parking Lot Repairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 2500 | 16700 | 19200 | 19200
 | B Hall More Lights | 0 | 0 | 421 | 0 | 0 | 0 | 0 | 0 | 421 | 360 | 781 | -421 | 360 | -61
 | Replace Fire Place Glass | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 179 | 179 | 150 | 329 | 1771 | 2100 | 1921
 | Replace Toaster | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | B Hall Restroom Vinyl | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 450 | 450 | 0 | 450 | 450
 | Ice Machine on Beverage Bar | 1212 | 3063 | 0 | 0 | 899 | 1414 | 0 | 0 | 6588 | 1250 | 7838 | 20962 | 28800 | 22212
 | Team Member Entrance Floor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14000 | 14000 | 1750 | 15750 | 15750
 | Replace Beverage Bar Flooring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3750 | 3750 | 0 | 3750 | 3750
 | A/C Issues in Admin Office & Private Dining | 0 | 0 | 0 | 2339 | 0 | 914 | 2016 | 1720 | 6989 | 0 | 6989 | 8011 | 15000 | 8011
 | A/C Issues in B Hall | 0 | 0 | 372 | 0 | 0 | 1529 | 353 | 0 | 2254 | 0 | 2254 | 7746 | 10000 | 7746
 | Replace SPA Flooring | 700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 700 | 4500 | 5200 | 50 | 5250 | 4550
 | Garden Place Washer & Dryer | 0 | 0 | 1328 | 0 | 0 | 668 | 0 | 0 | 1996 | 0 | 1996 | -206 | 1790 | -206
 | Replace Oven, if needed | 1247 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1247 | 0 | 1247 | 11353 | 12600 | 11353
 | [NAME], if needed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2900 | 2900 | 2900
 | Replace Flat Top Grill | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1900 | 1900 | 1900
 | Carpet Extractor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2100 | 2100 | 0 | 2100 | 2100
 | Attic Fans | 0 | 0 | 0 | 0 | 389 | 0 | 0 | 0 | 389 | 0 | 389 | 2011 | 2400 | 2011
 | ALZ Activity Area Chairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2750 | 2750 | 2750
 | Additional Security Cameras | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11700 | 11700 | 0 | 11700 | 11700
 | Small Generator to run Mag Locks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11635 | 11635 | 0 | 11635 | 11635
 | Sound Systems | 539 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 539 | 0 | 539 | -539 | 0 | -539
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Non-Recurring | 3698 | 3963 | 2121 | 2339 | 1814 | 4736 | 2369 | 2799 | 23839 | 66195 | 90034 | 98396 | 188430 | 164591
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 29560 | 77060 | 20874 | 51757 | 30589 | 46938 | 33857 | 24646 | 315281 | 315643 | 630924 | 348131 | 980255 | 663774
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Refurbishment Packages | 0 | 0 | 0 | 0 | 2238 | 300 | 2289 | 1222 | 6049 | 28540 | 34589 | 127911 | 162500 | 156451
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | Carillon Assisted Living, LLC |  |  |  |  |  |  |  |  |  |  |  |  | 09/14/12
 |  | Replacement Capital Expenditure Budgets by Facility |  |  |  |  |  |  |  |  |  |  |  |  | 04:48 PM
 |  | As Of  09/14/12
 |  | Facility Summary
 |  |  |  |  |  |  |  |  |  |  |  |  | Actual plus
 |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 |  |  | Actual plus | Forecast | 2012
 |  | January | February | March | April | May | June | July | August | 2012 | 2012 Forecast | Forecast | [NAME] | Annual | Actual vs.
 | Description | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual YTD | to be Spent | to be Spent | to Budget | Budget | Budget Variance
 | Emergency CapEx:
 | [NAME] | 7984 | 12284 | -5500 | 231 | 260 | 12322 | 1047 | 7160 | 35788 | 0 | 35788 | 5212 | 41000 | 5212
 | Outside Condensing Unit(s) | 1904 | 0 | 0 | 0 | 0 | 0 | 0 | 1489 | 3393 | 0 | 3393 | 31607 | 35000 | 31607
 | A/C Compressor or Coil | 0 | 0 | 4204 | 2168 | 3107 | 0 | 2423 | 4818 | 16720 | 4500 | 21220 | 13780 | 35000 | 18280
 | Phone System Cards (Parts & Labor) | 0 | 0 | 0 | 1210 | 1076 | 0 | 0 | 900 | 3186 | 1210 | 4396 | 15104 | 19500 | 16314
 | Commercial Washer Repair or Dryer | 342 | 0 | 0 | 550 | 2950 | 1017 | 781 | 3768 | 9408 | 3121 | 12529 | 16721 | 29250 | 19842
 | Nurse Call Parts | 0 | 0 | 0 | 14 | 3133 | 21 | 287 | 0 | 3455 | 11600 | 15055 | 4445 | 19500 | 16045
 | Mag Locks & Key Pads | 0 | 0 | 487 | 0 | 916 | 516 | 500 | 0 | 2419 | 2500 | 4919 | 14581 | 19500 | 17081
 | [NAME] (Parts & Labor) | 576 | 460 | 0 | 0 | 1780 | 0 | 616 | 0 | 3432 | 2250 | 5682 | 10568 | 16250 | 12818
 | Other | 0 | 6410 | 2359 | 7923 | 0 | 7305 | 319 | 8080 | 32396 | 10391 | 42787 | 28648 | 71435 | 39039
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 10806 | 19154 | 1550 | 12096 | 13222 | 21181 | 5973 | 26215 | 110197 | 35572 | 145769 | 140666 | 286435 | 176238
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 40366 | 96214 | 22424 | 63853 | 46049 | 68419 | 42119 | 52083 | 431527 | 379755 | 811282 | 616708 | 1429190 | 996463
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Discretionary CapEx: |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Van | 0 | 0 | 0 | 0 | 0 | 0 | 635 | 630 | 1265 | 17500 | 18765 | 26235 | 45000 | 43735
 | E-MAR Systems | 0 | 34680 | 183 | 34680 | 0 | 100 | 34680 | 0 | 104323 | 42300 | 146623 | 89877 | 236500 | 132177
 | Replacement Landscaping | 700 | 0 | 0 | 0 | 6068 | 0 | 0 | 0 | 6768 | 0 | 6768 | 43232 | 50000 | 43232
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Discretionary CapEx | 700 | 34680 | 183 | 34680 | 6068 | 100 | 35315 | 630 | 112356 | 59800 | 172156 | 159344 | 331500 | 219144
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 41066 | 130894 | 22607 | 98533 | 52117 | 68519 | 77434 | 52713 | 543883 | 439555 | 983438 | 776052 | 1760690 | 1215607
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.02332381055154513 | 0.07434244529133464 | 0.01283985255780404 | 0.05596271916123793 | 0.02960032714447177 | 0.03891599316177181 | 0.04397934900521955 | 0.02993883079928892 | 0.3089033276726738 | 0.2496492852234067 | 0.5585526128960805 | 0.4407658361210662 | 1 | 0.6904151213444729