Spreadsheet: 181383d1348016672-struggling-with-vlookups-capex-report-aug-2012-1-final-dp-1-
Sheet: 125

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 0 | 0 | 0 | 1167 | 0 | 1167 | 0 | 1167 | -167 | 1000 | -167
 | Seal Coat/Restripe or Repairs Parking Lot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3750 | 3750 | 0 | 3750 | 3750
 | PTAC Coil Replacement | 0 | 0 | 0 | 0 | 0 | 808 | 0 | 0 | 808 | 0 | 808 | 5592 | 6400 | 5592
 | Flooring Replacements-Carpet (Material) | 0 | 2768 | 0 | 0 | 0 | 1160 | 0 | 0 | 3928 | 0 | 3928 | 1801 | 5729 | 1801
 | Flooring Replacements-Carpet (Labor) | 0 | 0 | 0 | 0 | 0 | 2334 | 0 | 0 | 2334 | 0 | 2334 | -84 | 2250 | -84
 | Flooring Replacements - Vinyl | 0 | 0 | 0 | 0 | 0 | 325 | 0 | 0 | 325 | 0 | 325 | 1775 | 2100 | 1775
 | Night Stands | 0 | 0 | 0 | 996 | 0 | 0 | 0 | 0 | 996 | 0 | 996 | 354 | 1350 | 354
 | Dressers | 0 | 0 | 0 | 597 | 0 | 0 | 0 | 0 | 597 | 0 | 597 | 1503 | 2100 | 1503
 | Bed - Mattress & Box Springs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2220 | 2220 | 0 | 2220 | 530 | 2750 | 530
 | Beverage Bar Repair | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2750 | 2750 | 2750
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 600 | 600 | 600
 | AL Dining Table Cloths | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8100 | 8100 | 8100
 | ALZ Dining Table Cloths | 0 | 2755 | 0 | 0 | 0 | 0 | 0 | 0 | 2755 | 0 | 2755 | 2645 | 5400 | 2645
 | Replace Furniture | 0 | 0 | 0 | 0 | 0 | 0 | 900 | 979 | 1879 | 0 | 1879 | 4421 | 6300 | 4421
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 1150 | 1650 | 1650
 | Resident Room Chair Replacement | 0 | 0 | 0 | 0 | 0 | 0 | 731 | 15 | 746 | 0 | 746 | 3364 | 4110 | 3364
 | Repaint Carillon Road Sign | 0 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 400 | 0 | 400 | -25 | 375 | -25
 | Bathroom Faucets | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 20 | 120 | 120
 | Shower Faucets | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 200 | 300 | 300
 | Seasonal Decorations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 250 | 1500 | 1500
 | Pendants | 0 | 0 | 0 | 0 | 0 | 0 | 301 | 0 | 301 | 0 | 301 | 869 | 1170 | 869
 | Pagers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 300 | 1050 | 1050
 | Clinical Supplies (Ref., BP Supplies, Charts) | 409 | 0 | 0 | 0 | 0 | 238 | 0 | 304 | 951 | 500 | 1451 | -501 | 950 | -1
 | Linens Replacement (Linens/Towels) | 0 | 0 | 0 | 0 | 948 | 327 | 0 | 0 | 1275 | 1250 | 2525 | -775 | 1750 | 475
 | Mixing Valves & Parts | 0 | 0 | 1562 | 0 | 0 | 0 | 1350 | 0 | 2912 | 0 | 2912 | -2412 | 500 | -2412
 | Other | 855 | 0 | 1988 | 1273 | 0 | 0 | 0 | 0 | 4116 | 0 | 4116 | -1121 | 2995 | -1121
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 1264 | 5523 | 3550 | 2866 | 948 | 5592 | 4449 | 3518 | 27710 | 8200 | 35910 | 31139 | 67049 | 39339
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Repair Roof Leaks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | Replace Fire Place Glass | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 300 | 300
 | Replace Toaster | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 750
 | Ice Machine on Beverage Bar | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3200 | 3200 | 3200
 | Team Member Entrance Floor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1750 | 1750 | 0 | 1750 | 1750
 | Carpet Extractor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2100 | 2100 | 0 | 2100 | 2100
 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5645 | 5645 | 5750 | 11395 | 11395
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 1264 | 5523 | 3550 | 2866 | 948 | 5592 | 4449 | 3518 | 27710 | 13845 | 41555 | 36889 | 78444 | 50734
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Refurbishment Packages | 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
 |  | Southport
 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | [NAME] | Annual | Actual vs.
 | Description | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual YTD | Actual YTD | to be Spent | to Budget | Budget | Budget Variance
 | Emergency CapEx:
 | [NAME] | 0 | 0 | 0 | 231 | 0 | 0 | 1047 | 0 | 1278 | 0 | 1278 | 2822 | 4100 | 2822
 | Outside Condensing Unit(s) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3500 | 3500 | 3500
 | A/C Compressor or Coil | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3500 | 3500 | 3500
 | Phone System Cards (Parts & Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | Commercial Washer Repair or Dryer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 557 | 557 | 0 | 557 | 1693 | 2250 | 1693
 | Nurse Call Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | Mag Locks & Key Pads | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | [NAME] (Parts & Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 1250
 | Other | 0 | 0 | 315 | 7466 | 0 | 0 | 0 | 0 | 7781 | 0 | 7781 | -5281 | 2500 | -5281
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 0 | 0 | 315 | 7697 | 0 | 0 | 1047 | 557 | 9616 | 0 | 9616 | 11984 | 21600 | 11984
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 1264 | 5523 | 3865 | 10563 | 948 | 5592 | 5496 | 4075 | 37326 | 13845 | 51171 | 61373 | 112544 | 75218
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | Van | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 630 | 630 | 0 | 630 | -630 | 0 | -630
 | E-MAR Systems | 0 | 0 | 0 | 17340 | 0 | 0 | 0 | 0 | 17340 | 4160 | 21500 | 0 | 21500 | 4160
 | Replacement Landscaping | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Discretionary CapEx | 0 | 0 | 0 | 17340 | 0 | 0 | 0 | 630 | 17970 | 4160 | 22130 | 4370 | 26500 | 8530
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 1264 | 5523 | 3865 | 27903 | 948 | 5592 | 5496 | 4705 | 55296 | 18005 | 73301 | 65743 | 139044 | 83748
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.009090647564799631 | 0.03972123931992751 | 0.02779695635913812 | 0.2006774833865539 | 0.006817985673599724 | 0.04021748511262622 | 0.0395270561836541 | 0.0338382094876442 | 0.3976870630879434 | 0.1294913840223239 | 0.5271784471102673 | 0.4728215528897328 | 1 | 0.6023129369120566