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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 719 | 0 | 0 | 719 | 0 | 719 | 4081 | 4800 | 4081
 | Flooring Replacements-Carpet (Material) | 0 | 1870 | 0 | 0 | 0 | 0 | 0 | 0 | 1870 | 0 | 1870 | 1670 | 3540 | 1670
 | 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 | 1500 | 1500 | 600 | 2100 | 2100
 | Night Stands | 0 | 0 | 388 | 0 | 0 | 0 | 0 | 0 | 388 | 0 | 388 | 962 | 1350 | 962
 | 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
 | Bed - Head Board | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1040 | 1040 | 1040
 | [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 | 399 | 399 | 0 | 785 | 785 | 0 | 2368 | 0 | 2368 | 3032 | 5400 | 3032
 | Replace Furniture | 0 | 0 | 0 | 0 | 285 | 154 | 528 | 0 | 967 | 4500 | 5467 | 833 | 6300 | 5333
 | [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 | 0 | 0 | 0 | 4000 | 4000 | 110 | 4110 | 4110
 | 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 | 135 | 0 | 0 | 0 | 0 | 0 | 135 | 750 | 885 | 615 | 1500 | 1365
 | Pendants | 230 | 0 | 0 | 227 | 0 | 0 | 268 | 0 | 725 | 400 | 1125 | 45 | 1170 | 445
 | Pagers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 550 | 1050 | 1050
 | Clinical Supplies (Ref., BP Supplies, Charts) | 0 | 1397 | 0 | 0 | 0 | 395 | 0 | 0 | 1792 | 0 | 1792 | -842 | 950 | -842
 | Linens Replacement (Linens/Towels) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 500 | 1750 | 1750
 | Mixing Valves & Parts | 0 | 0 | 68 | 0 | 941 | 0 | 0 | 0 | 1009 | 0 | 1009 | -509 | 500 | -509
 | 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 | 2500 | 2500 | 495 | 2995 | 2995
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 230 | 3267 | 990 | 626 | 1226 | 2053 | 2748 | 0 | 11140 | 25035 | 36175 | 26415 | 62590 | 51450
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Repair Roof Leaks | 0 | 0 | 0 | 0 | 526 | 0 | 0 | 0 | 526 | 0 | 526 | 974 | 1500 | 974
 | Paint [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 675 | 675 | 675
 | Replace Fire Place Glass | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 300 | 300
 | Ice Machine on Beverage Bar | 0 | 0 | 0 | 0 | 0 | 994 | 0 | 0 | 994 | 0 | 994 | 2206 | 3200 | 2206
 | 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
 | Replace SPA Flooring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 0 | 750 | 750
 | 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 | 526 | 994 | 0 | 0 | 1520 | 5045 | 6565 | 4155 | 10720 | 9200
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 230 | 3267 | 990 | 626 | 1752 | 3047 | 2748 | 0 | 12660 | 30080 | 42740 | 30570 | 73310 | 60650
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | 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
 |  | Shelby
 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 260 | 0 | 0 | 0 | 260 | 0 | 260 | 3840 | 4100 | 3840
 | 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 | 1028 | 0 | 0 | 0 | 0 | 0 | 1028 | 0 | 1028 | 2472 | 3500 | 2472
 | 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 | 550 | 0 | 0 | 0 | 0 | 550 | 0 | 550 | 1700 | 2250 | 1700
 | Nurse Call Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 0 | 1500 | 1500
 | Mag Locks & Key Pads | 0 | 0 | 0 | 0 | 0 | 516 | 0 | 0 | 516 | 0 | 516 | 984 | 1500 | 984
 | [NAME] (Parts & Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 750 | 1250 | 1250
 | Other | 0 | 2613 | 0 | 0 | 0 | 0 | 0 | 0 | 2613 | 0 | 2613 | -113 | 2500 | -113
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 0 | 2613 | 1028 | 550 | 260 | 516 | 0 | 0 | 4967 | 2000 | 6967 | 14633 | 21600 | 16633
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 230 | 5880 | 2018 | 1176 | 2012 | 3563 | 2748 | 0 | 17627 | 32080 | 49707 | 57703 | 107410 | 89783
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | Van | 0 | 0 | 0 | 0 | 0 | 0 | 635 | 0 | 635 | 0 | 635 | -635 | 0 | -635
 | Replacement Landscaping | 0 | 0 | 0 | 0 | 6068 | 0 | 0 | 0 | 6068 | 0 | 6068 | -1068 | 5000 | -1068
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Discretionary CapEx | 0 | 0 | 0 | 0 | 6068 | 0 | 635 | 0 | 6703 | 0 | 6703 | -1703 | 5000 | -1703
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 230 | 5880 | 2018 | 1176 | 8080 | 3563 | 3383 | 0 | 24330 | 32080 | 56410 | 56000 | 112410 | 88080
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.002046081309492038 | 0.05230851347744862 | 0.01795213948936927 | 0.01046170269548972 | 0.07187972600302464 | 0.0316964682857397 | 0.03009518726091985 | 0 | 0.2164398185214839 | 0.2853838626456721 | 0.5018236811671559 | 0.4981763188328441 | 1 | 0.7835601814785161