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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 603 | 0 | 0 | 0 | 0 | 0 | 0 | 603 | 0 | 603 | 397 | 1000 | 397
 | PTAC Coil Replacement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3200 | 3200 | 3200
 | 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 | 2200 | 2200 | 50 | 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 | 675 | 675 | 675
 | Dressers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1050 | 1050 | 1050
 | Bed - Mattress & Box Springs | 0 | 769 | 0 | 0 | 0 | 0 | 0 | 0 | 769 | 0 | 769 | 56 | 825 | 56
 | Bed - Head Board | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 520 | 520 | 520
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 300 | 300
 | Bed Spreads | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2650 | 2650 | 2650
 | AL Dining Table Cloths | 3900 | 0 | 0 | 3900 | 0 | 0 | 0 | 0 | 7800 | 5000 | 12800 | -4700 | 8100 | 300
 | ALZ Dining Table Cloths | 2940 | 0 | 0 | 2940 | 0 | 0 | 0 | 0 | 5880 | 5000 | 10880 | -5480 | 5400 | -480
 | Replace Furniture | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 1300 | 6300 | 6300
 | [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 | 0 | 0 | 2055 | 2055 | 2055
 | 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 | 64 | 0 | 0 | 0 | 0 | 0 | 0 | 64 | 750 | 814 | 686 | 1500 | 1436
 | Pendants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 420 | 1170 | 1170
 | Pagers | 0 | 0 | 0 | 0 | 0 | 0 | 163 | 0 | 163 | 500 | 663 | 387 | 1050 | 887
 | Clinical Supplies (Ref., BP Supplies, Charts) | 0 | 0 | 0 | 0 | 0 | 0 | 110 | -110 | 0 | 500 | 500 | 450 | 950 | 950
 | Linens Replacement (Linens/Towels) | 0 | 0 | 226 | 0 | 0 | 0 | 0 | 0 | 226 | 1000 | 1226 | 524 | 1750 | 1524
 | 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 | 840 | 840 | 840
 | Other | 0 | 0 | 1146 | 0 | 0 | 0 | 867 | 1327 | 3340 | 0 | 3340 | -345 | 2995 | -345
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 6840 | 4204 | 1372 | 6840 | 0 | 0 | 1140 | 1217 | 21613 | 27835 | 49448 | 7466 | 56914 | 35301
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Replace Fire Place Glass | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 300 | 300
 | 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
 | Sound Systems | 539 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 539 | 0 | 539 | -539 | 0 | -539
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Non-Recurring | 539 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 539 | 2545 | 3084 | -239 | 2845 | 2306
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 7379 | 4204 | 1372 | 6840 | 0 | 0 | 1140 | 1217 | 22152 | 30380 | 52532 | 7227 | 59759 | 37607
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | 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
 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4100 | 4100 | 4100
 | Outside Condensing Unit(s) | 1904 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1904 | 0 | 1904 | 1596 | 3500 | 1596
 | 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 | 0 | 0 | 0 | 0 | 2250 | 2250 | 2250
 | Nurse Call Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 250 | 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 | 0 | 0 | 0 | 5001 | 0 | 3750 | 8751 | 0 | 8751 | -6251 | 2500 | -6251
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 1904 | 0 | 0 | 0 | 0 | 5001 | 0 | 3750 | 10655 | 1250 | 11905 | 9695 | 21600 | 10945
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 9283 | 4204 | 1372 | 6840 | 0 | 5001 | 1140 | 4967 | 32807 | 31630 | 64437 | 29422 | 93859 | 61052
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | 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 | 5000 | 5000 | 5000
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 9283 | 4204 | 1372 | 6840 | 0 | 5001 | 1140 | 4967 | 32807 | 31630 | 64437 | 34422 | 98859 | 66052
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.09390141514682528 | 0.04252521267664047 | 0.01387835199627753 | 0.06918945164324948 | 0 | 0.050587199951446 | 0.01153157527387491 | 0.05024327577661113 | 0.3318564824649248 | 0.3199506367654943 | 0.6518071192304191 | 0.3481928807695809 | 1 | 0.6681435175350752