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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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
 | PTAC Coil Replacement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4800 | 4800 | 4800
 | Flooring Replacements-Carpet (Material) | 0 | 2768 | 0 | 0 | 0 | 0 | 0 | 0 | 2768 | 2500 | 5268 | 461 | 5729 | 2961
 | Flooring Replacements-Carpet (Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2000 | 2000 | 250 | 2250 | 2250
 | Flooring Replacements - Vinyl | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2000 | 2000 | 100 | 2100 | 2100
 | 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 | 1554 | 1554 | 0 | 1554 | 96 | 1650 | 96
 | Bed - Head Board | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1040 | 1040 | 1040
 | Beverage Bar Repair | 0 | 0 | 0 | 0 | 0 | 0 | 532 | 0 | 532 | 0 | 532 | -532 | 0 | -532
 | [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 | 2050 | 0 | 0 | 2050 | 0 | 0 | 0 | 0 | 4100 | 1000 | 5100 | 300 | 5400 | 1300
 | Replace Furniture | 1079 | 221 | 974 | 392 | 283 | 0 | 937 | 0 | 3886 | 2000 | 5886 | 414 | 6300 | 2414
 | [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 | 1075 | -214 | 861 | 2000 | 2861 | 1249 | 4110 | 3249
 | 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 | 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 | 123 | 0 | 0 | 123 | 500 | 623 | 547 | 1170 | 1047
 | Pagers | 0 | 0 | 270 | 0 | 276 | -6 | 0 | 0 | 540 | 250 | 790 | 260 | 1050 | 510
 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1560 | 1560 | 0 | 1560 | 1560
 | Front Porch Rockers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1680 | 1680 | 1680
 | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2000 | 2000 | 995 | 2995 | 2995
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 3129 | 2989 | 1244 | 2442 | 559 | 117 | 3711 | 1340 | 15531 | 24385 | 39916 | 24863 | 64779 | 49248
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Repair Roof Leaks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | B Hall More Lights | 0 | 0 | 421 | 0 | 0 | 0 | 0 | 0 | 421 | 0 | 421 | -421 | 0 | -421
 | 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
 | Replace SPA Flooring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 0 | 750 | 750
 | Garden Place Washer & Dryer | 0 | 0 | 1328 | 0 | 0 | 0 | 0 | 0 | 1328 | 0 | 1328 | -433 | 895 | -433
 | Replace Flat Top Grill | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1900 | 1900 | 1900
 | 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 | 1749 | 0 | 0 | 0 | 0 | 0 | 1749 | 4295 | 6044 | 6796 | 12840 | 11091
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 3129 | 2989 | 2993 | 2442 | 559 | 117 | 3711 | 1340 | 17280 | 28680 | 45960 | 31659 | 77619 | 60339
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | 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
 |  | Hendersonville
 |  |  |  |  |  |  |  |  |  |  |  |  | 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] | 5760 | 0 | 0 | 0 | 0 | 6237 | 0 | 0 | 11997 | 0 | 11997 | -7897 | 4100 | -7897
 | 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 | 794 | 0 | 794 | 0 | 794 | 2706 | 3500 | 2706
 | Phone System Cards (Parts & Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | Commercial Washer Repair or Dryer | 342 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 342 | 0 | 342 | 1908 | 2250 | 1908
 | Nurse Call Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 250 | 1500 | 1500
 | Mag Locks & Key Pads | 0 | 0 | 146 | 0 | 0 | 0 | 0 | 0 | 146 | 0 | 146 | 1354 | 1500 | 1354
 | [NAME] (Parts & Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 1250
 | Other | 0 | 1088 | 0 | 0 | 0 | 0 | 0 | 0 | 1088 | 1000 | 2088 | 412 | 2500 | 1412
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 6102 | 1088 | 146 | 0 | 0 | 6237 | 794 | 0 | 14367 | 2250 | 16617 | 4983 | 21600 | 7233
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 9231 | 4077 | 3139 | 2442 | 559 | 6354 | 4505 | 1340 | 31647 | 30930 | 62577 | 49142 | 111719 | 80072
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | 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 | 0 | 17340 | 4160 | 21500 | 5000 | 26500 | 9160
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 9231 | 4077 | 3139 | 19782 | 559 | 6354 | 4505 | 1340 | 48987 | 35090 | 84077 | 54142 | 138219 | 89232
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.06678531895036138 | 0.0294966683306926 | 0.0227103364949826 | 0.143120699759078 | 0.004044306499106491 | 0.04597052503635535 | 0.03259320353931081 | 0.009694759765299994 | 0.3544158183751872 | 0.2538724777346096 | 0.6082882961097967 | 0.3917117038902032 | 1 | 0.6455841816248128