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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 182 | 0 | 182 | 0 | 182 | 818 | 1000 | 818
 | PTAC Coil Replacement | 0 | 0 | 0 | 0 | 0 | 0 | 1086 | 0 | 1086 | 0 | 1086 | 3714 | 4800 | 3714
 | Flooring Replacements-Carpet (Material) | 0 | 2768 | 0 | 0 | 0 | 0 | 0 | 595 | 3363 | 2200 | 5563 | 166 | 5729 | 2366
 | Flooring Replacements-Carpet (Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2217 | 2217 | 0 | 2217 | 33 | 2250 | 33
 | Flooring Replacements - Vinyl | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2000 | 2000 | 100 | 2100 | 2100
 | Interior Furnishing Replacements | 193 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 193 | 0 | 193 | -193 | 0 | -193
 | Night Stands | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1350 | 1350 | 1350
 | Dressers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2100 | 2100 | 2100
 | Bed - Mattress & Box Springs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1650 | 1650 | 1650
 | 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
 | Bed Spreads | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2650 | 2650 | 2650
 | AL Dining Table Cloths | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 3100 | 8100 | 8100
 | ALZ Dining Table Cloths | 0 | 0 | 0 | 1901 | 0 | 0 | 0 | 0 | 1901 | 3000 | 4901 | 499 | 5400 | 3499
 | Replace Furniture | 0 | 0 | 0 | 0 | 0 | 318 | 260 | 541 | 1119 | 5000 | 6119 | 181 | 6300 | 5181
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 474 | 474 | 500 | 974 | 676 | 1650 | 1176
 | Resident Room Chair Replacement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4000 | 4000 | 110 | 4110 | 4110
 | Repaint Carillon Road Sign | 237 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 237 | 0 | 237 | 138 | 375 | 138
 | 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 | 750 | 750 | 750 | 1500 | 1500
 | Pendants | 0 | 0 | 0 | 0 | 0 | 338 | 550 | -170 | 718 | 400 | 1118 | 52 | 1170 | 452
 | Pagers | 338 | 0 | 0 | 0 | 0 | 0 | 0 | 401 | 739 | 250 | 989 | 61 | 1050 | 311
 | Clinical Supplies (Ref., BP Supplies, Charts) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 543 | 543 | 300 | 843 | 107 | 950 | 407
 | Linens Replacement (Linens/Towels) | 0 | 0 | 0 | 0 | 82 | 0 | 0 | 0 | 82 | 1250 | 1332 | 418 | 1750 | 1668
 | Mixing Valves & Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500
 | Patio Chairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1560 | 1560 | 0 | 1560 | 1560
 | Other | 1300 | 0 | 0 | 0 | 0 | 299 | 0 | 0 | 1599 | 1000 | 2599 | 396 | 2995 | 1396
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 2068 | 2768 | 0 | 1901 | 82 | 955 | 2078 | 4601 | 14453 | 27410 | 41863 | 22946 | 64809 | 50356
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Repair Roof Leaks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | Repair Garden Place Counter | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 750
 | Replace Fire Place Glass | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 179 | 179 | 0 | 179 | 121 | 300 | 121
 | Ice Machine on Beverage Bar | 0 | 0 | 0 | 0 | 441 | 0 | 0 | 0 | 441 | 0 | 441 | 2759 | 3200 | 2759
 | Team Member Entrance Floor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1750 | 1750 | 0 | 1750 | 1750
 | Replace SPA Flooring | 700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 700 | 0 | 700 | -700 | 0 | -700
 | 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 | 700 | 0 | 0 | 0 | 441 | 0 | 0 | 179 | 1320 | 3545 | 4865 | 4430 | 9295 | 7975
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 2768 | 2768 | 0 | 1901 | 523 | 955 | 2078 | 4780 | 15773 | 30955 | 46728 | 27376 | 74104 | 58331
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | 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
 |  | Hillsborough
 |  |  |  |  |  |  |  |  |  |  |  |  | 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] | 2224 | 6784 | 0 | 0 | 0 | 0 | 0 | 0 | 9008 | 0 | 9008 | -4908 | 4100 | -4908
 | 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 | 1550 | 0 | 0 | 0 | 1550 | 0 | 1550 | 700 | 2250 | 700
 | Nurse Call Parts | 0 | 0 | 0 | 0 | 600 | 0 | 0 | 0 | 600 | 900 | 1500 | 0 | 1500 | 900
 | 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 | 659 | 0 | 0 | 0 | 659 | 0 | 659 | 591 | 1250 | 591
 | Other | 0 | 0 | 2044 | 0 | 0 | 0 | 0 | 620 | 2664 | 0 | 2664 | -164 | 2500 | -164
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 2224 | 6784 | 2044 | 0 | 2809 | 0 | 0 | 620 | 14481 | 900 | 15381 | 6219 | 21600 | 7119
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 4992 | 9552 | 2044 | 1901 | 3332 | 955 | 2078 | 5400 | 30254 | 31855 | 62109 | 46095 | 108204 | 77950
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | E-MAR Systems | 0 | 0 | 0 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26500 | 26500 | 26500
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 4992 | 9552 | 2044 | 1901 | 3332 | 955 | 2078 | 5400 | 30254 | 31855 | 62109 | 72595 | 134704 | 104450
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.03705903313932771 | 0.07091103456467514 | 0.01517401116522152 | 0.01411242427841786 | 0.02473571683097755 | 0.007089618719562893 | 0.01542641643900701 | 0.04008789642475354 | 0.2245961515619432 | 0.2364814704834303 | 0.4610776220453736 | 0.5389223779546264 | 1 | 0.7754038484380568