Spreadsheet: 181123d1347934110-struggling-with-vlookups-capex-report-aug-2012-1-final-dp
Sheet: 102

 |  |  |  |  |  |  |  |  |  |  |  |  | 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
 | Planned CapEx - Recurring:
 | PC Replacement | 0 | 0 | 0 | 1297 | 0 | 0 | 0 | 0 | 1297 | 0 | 1297 | -297 | 1000 | -297
 | Seal Coat/Restripe or Repairs Parking Lot | 0 | 0 | 0 | 2150 | 900 | 0 | 0 | 0 | 3050 | 0 | 3050 | -3050 | 0 | -3050
 | PTAC Coil Replacement | 850 | 850 | 725 | 0 | 650 | 0 | 0 | 1250 | 4325 | 0 | 4325 | -1125 | 3200 | -1125
 | Flooring Replacements-Carpet (Material) | 0 | 1215 | 0 | 0 | 0 | 0 | 0 | 0 | 1215 | 3500 | 4715 | 1014 | 5729 | 4514
 | Flooring Replacements-Carpet (Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2200 | 2200 | 50 | 2250 | 2250
 | Flooring Replacements - Vinyl | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 600 | 2100 | 2100
 | Interior Furnishing Replacements | 0 | 0 | 564 | 0 | 0 | 403 | 75 | 22 | 1064 | 0 | 1064 | -1064 | 0 | -1064
 | Night Stands | 0 | 0 | 0 | 1328 | 0 | 0 | 0 | 0 | 1328 | 0 | 1328 | 472 | 1800 | 472
 | Dressers | 0 | 0 | 0 | 1782 | 0 | 0 | 0 | 0 | 1782 | 1250 | 3032 | -932 | 2100 | 318
 | Dining Room Chairs | 0 | 2804 | 0 | 268 | 0 | 5192 | 0 | 0 | 8264 | 0 | 8264 | -8264 | 0 | -8264
 | Bed - Mattress & Box Springs | 0 | 2664 | 0 | 0 | 0 | 0 | 0 | 0 | 2664 | 2000 | 4664 | -1914 | 2750 | 86
 | Bed - Head Board | 0 | 0 | 0 | 696 | 0 | 0 | 0 | 0 | 696 | 0 | 696 | 344 | 1040 | 344
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 1875 | 0 | 0 | 1875 | 1500 | 3375 | -2175 | 1200 | -675
 | Bed Spreads | 0 | 1409 | 0 | 1559 | 150 | 0 | 0 | 0 | 3118 | 0 | 3118 | 62 | 3180 | 62
 | AL Dining Table Cloths | 0 | 0 | 0 | 0 | 0 | 0 | 326 | 0 | 326 | 0 | 326 | 7774 | 8100 | 7774
 | ALZ Dining Table Cloths | 0 | 0 | 1383 | 0 | 0 | 0 | 1383 | 0 | 2766 | 0 | 2766 | 2634 | 5400 | 2634
 | Replace Furniture | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 3300 | 8300 | 8300
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 1150 | 1650 | 1650
 | Resident Room Chair Replacement | 745 | 1544 | 0 | 0 | 1384 | 0 | 2106 | -91 | 5688 | 0 | 5688 | -1578 | 4110 | -1578
 | Repaint Carillon Road Sign | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 375 | 375 | 0 | 375 | 375
 | Bathroom Faucets | 0 | 0 | 0 | 0 | 0 | 0 | 349 | 0 | 349 | 0 | 349 | -229 | 120 | -229
 | Shower Faucets | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 200 | 300 | 300
 | Seasonal Decorations | 0 | 0 | 0 | 33 | 0 | 0 | 0 | 0 | 33 | 750 | 783 | 717 | 1500 | 1467
 | Pendants | 0 | 0 | 179 | 1137 | 0 | 0 | 206 | 0 | 1522 | 0 | 1522 | -352 | 1170 | -352
 | Pagers | 0 | 0 | 0 | 613 | 0 | 0 | 0 | 0 | 613 | 500 | 1113 | -63 | 1050 | 437
 | Clinical Supplies (Ref., BP Supplies, Charts) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 450 | 950 | 950
 | Linens Replacement (Linens/Towels) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 500 | 1750 | 1750
 | Mixing Valves & Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500
 | Patio Chairs | 0 | 550 | 0 | 550 | 0 | 0 | 0 | 0 | 1100 | 0 | 1100 | 460 | 1560 | 460
 | Front Porch Rockers | 0 | 1549 | 0 | 0 | 0 | 0 | 0 | 0 | 1549 | 0 | 1549 | 131 | 1680 | 131
 | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2000 | 2000 | 995 | 2995 | 2995
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 1595 | 12585 | 2851 | 11413 | 3084 | 7470 | 4445 | 1181 | 44624 | 22925 | 67549 | 310 | 67859 | 23235
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Repair Roof Leaks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | Raise Shed Door | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 750
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500
 | Parking Lot Repairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 2500 | 2300 | 4800 | 4800
 | Replace Fire Place Glass | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 150 | 150
 | Ice Machine on Beverage Bar | 0 | 3063 | 0 | 0 | 0 | 0 | 0 | 0 | 3063 | 0 | 3063 | 137 | 3200 | 137
 | Team Member Entrance Floor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1750 | 1750 | 0 | 1750 | 1750
 | Replace Beverage Bar Flooring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 0 | 750 | 750
 | A/C Issues in Admin Office & Private Dining | 0 | 0 | 0 | 2339 | 0 | 0 | 0 | 489 | 2828 | 0 | 2828 | 4672 | 7500 | 4672
 | A/C Issues in B Hall | 0 | 0 | 0 | 0 | 0 | 1529 | 353 | 0 | 1882 | 0 | 1882 | -1882 | 0 | -1882
 | Replace SPA Flooring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 750
 | [NAME], if needed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2900 | 2900 | 2900
 | 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 | 900 | 900 | 0 | 900 | 900
 | Small Generator to run Mag Locks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 895 | 895 | 0 | 895 | 895
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Non-Recurring | 0 | 3063 | 0 | 2339 | 0 | 1529 | 353 | 489 | 7773 | 6795 | 14568 | 14527 | 29095 | 21322
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 1595 | 15648 | 2851 | 13752 | 3084 | 8999 | 4798 | 1670 | 52397 | 29720 | 82117 | 14837 | 96954 | 44557
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Refurbishment Packages | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 12500 | 12500
 |  | - | - | - | - | - | - | - | - | - |  | - | - | - | -
 |  | Carillon Assisted Living, LLC |  |  |  |  |  |  |  |  |  |  |  |  | 09/14/12
 |  | Replacement Capital Expenditure Budgets by Facility |  |  |  |  |  |  |  |  |  |  |  |  | 04:48 PM
 |  | As Of  09/14/12
 |  | Harrisburg
 |  |  |  |  |  |  |  |  |  |  |  |  | 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] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4100 | 4100 | 4100
 | Outside Condensing Unit(s) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 422 | 422 | 0 | 422 | 3078 | 3500 | 3078
 | A/C Compressor or Coil | 0 | 0 | 1590 | 600 | 2503 | 0 | 0 | 0 | 4693 | 4500 | 9193 | -5693 | 3500 | -1193
 | Phone System Cards (Parts & Labor) | 0 | 0 | 0 | 0 | 1076 | 0 | 0 | 0 | 1076 | 0 | 1076 | 424 | 1500 | 424
 | Commercial Washer Repair or Dryer | 0 | 0 | 0 | 0 | 1400 | 0 | 0 | 0 | 1400 | 0 | 1400 | 850 | 2250 | 850
 | Nurse Call Parts | 0 | 0 | 0 | 0 | 2533 | 21 | 287 | 0 | 2841 | 1500 | 4341 | -2841 | 1500 | -1341
 | Mag Locks & Key Pads | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 1000 | 500 | 1500 | 1500
 | [NAME] (Parts & Labor) | 0 | 460 | 0 | 0 | 0 | 0 | 0 | 0 | 460 | 0 | 460 | 790 | 1250 | 790
 | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1172 | 1172 | 1000 | 2172 | 328 | 2500 | 1328
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 0 | 460 | 1590 | 600 | 7512 | 21 | 287 | 1594 | 12064 | 8000 | 20064 | 1536 | 21600 | 9536
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 1595 | 16108 | 4441 | 14352 | 10596 | 9020 | 5085 | 3264 | 64461 | 37720 | 102181 | 28873 | 131054 | 66593
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | E-MAR Systems | 0 | 17340 | -17340 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21500 | 21500 | 21500
 | Replacement Landscaping | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Discretionary CapEx | 0 | 17340 | -17340 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26500 | 26500 | 26500
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 1595 | 33448 | -12899 | 14352 | 10596 | 9020 | 5085 | 3264 | 64461 | 37720 | 102181 | 55373 | 157554 | 93093
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.0101235132081699 | 0.2122954669510136 | -0.08187034286657273 | 0.0910925777828554 | 0.06725313225941582 | 0.05725021262551253 | 0.03227464869187707 | 0.02071670665295708 | 0.4091359153052287 | 0.2394099800703251 | 0.6485458953755537 | 0.3514541046244462 | 1 | 0.5908640846947714