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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 1187 | 0 | 0 | 0 | 0 | 1187 | 0 | 1187 | -187 | 1000 | -187
 | PTAC Coil Replacement | 0 | 0 | 1497 | 0 | 0 | 0 | 0 | 0 | 1497 | 0 | 1497 | 3303 | 4800 | 3303
 | Flooring Replacements-Carpet (Material) | 1746 | 3404 | 0 | 1757 | 0 | 0 | 0 | 0 | 6907 | 1500 | 8407 | 299 | 8706 | 1799
 | Flooring Replacements-Carpet (Labor) | 0 | 0 | 0 | 0 | 2181 | 0 | 0 | 0 | 2181 | 0 | 2181 | 69 | 2250 | 69
 | Flooring Replacements - Vinyl | 0 | 0 | 0 | 0 | 1370 | 0 | 0 | 0 | 1370 | 500 | 1870 | 230 | 2100 | 730
 | Interior Furnishing Replacements | 0 | 0 | 0 | 0 | 0 | 0 | 262 | 262 | 524 | 0 | 524 | -524 | 0 | -524
 | Night Stands | 0 | 0 | 0 | 1060 | 0 | 0 | 0 | 0 | 1060 | 0 | 1060 | 290 | 1350 | 290
 | Dressers | 0 | 0 | 0 | 1642 | 0 | 0 | 0 | 0 | 1642 | 0 | 1642 | 458 | 2100 | 458
 | Dining Room Chairs | 0 | 2819 | 979 | 262 | 0 | 5322 | 50 | 0 | 9432 | 0 | 9432 | 24668 | 34100 | 24668
 | Bed - Mattress & Box Springs | 0 | 1537 | 0 | 0 | 0 | 0 | 0 | 0 | 1537 | 0 | 1537 | 113 | 1650 | 113
 | Bed - Head Board | 0 | 0 | 0 | 760 | 0 | 0 | 0 | 0 | 760 | 0 | 760 | 280 | 1040 | 280
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 1875 | 0 | 0 | 1875 | 0 | 1875 | -675 | 1200 | -675
 | Bed Spreads | 0 | 1409 | 0 | 1559 | 150 | 0 | 0 | 0 | 3118 | 0 | 3118 | 62 | 3180 | 62
 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 400 | 5400 | 5400
 | 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 | 767 | 1246 | 0 | 0 | 1362 | 0 | 0 | 0 | 3375 | 0 | 3375 | 735 | 4110 | 735
 | 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 | 201 | 0 | 0 | 0 | 201 | 750 | 951 | 549 | 1500 | 1299
 | Pendants | 0 | 553 | 0 | 0 | 0 | 604 | 1158 | 0 | 2315 | 0 | 2315 | -1145 | 1170 | -1145
 | Pagers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 550 | 1050 | 1050
 | 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
 | Other | 0 | 647 | 0 | 0 | 0 | 0 | 0 | 4828 | 5475 | 0 | 5475 | -2480 | 2995 | -2480
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 2513 | 11615 | 2476 | 8227 | 5264 | 7801 | 1470 | 5090 | 44456 | 21075 | 65531 | 34215 | 99746 | 55290
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Irrigation & Plants at Carillon Sign | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500
 | Repair Roof Leaks | 0 | 900 | 0 | 0 | 0 | 0 | 0 | 0 | 900 | 0 | 900 | 600 | 1500 | 600
 | Repair Garden Place Counter | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 750
 | Vanity and Crib | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1700 | 1700 | 1700
 | Ice Machine on Beverage Bar | 0 | 0 | 0 | 0 | 458 | 0 | 0 | 0 | 458 | 0 | 458 | 2742 | 3200 | 2742
 | 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
 | A/C Issues in B Hall | 0 | 0 | 372 | 0 | 0 | 0 | 0 | 0 | 372 | 0 | 372 | 4628 | 5000 | 4628
 | Replace SPA Flooring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 0 | 750 | 750
 | Replace Oven, if needed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4200 | 4200 | 4200
 | 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 | 900 | 372 | 0 | 458 | 0 | 0 | 0 | 1730 | 5045 | 6775 | 15120 | 21895 | 20165
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 2513 | 12515 | 2848 | 8227 | 5722 | 7801 | 1470 | 5090 | 46186 | 26120 | 72306 | 49335 | 121641 | 75455
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | 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 | 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 | 5500 | -5500 | 0 | 0 | 122 | 0 | 209 | 331 | 0 | 331 | 3769 | 4100 | 3769
 | Outside Condensing Unit(s) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1067 | 1067 | 0 | 1067 | 2433 | 3500 | 2433
 | A/C Compressor or Coil | 0 | 0 | 1587 | 0 | 0 | 0 | 1628 | 1001 | 4216 | 0 | 4216 | -716 | 3500 | -716
 | Phone System Cards (Parts & Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900 | 900 | 0 | 900 | 600 | 1500 | 600
 | Commercial Washer Repair or Dryer | 0 | 0 | 0 | 0 | 0 | 0 | 260 | 2539 | 2799 | 2799 | 5598 | -3348 | 2250 | -549
 | 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 | 719 | 0 | 719 | 0 | 719 | 531 | 1250 | 531
 | Other | 0 | 0 | 0 | 457 | 0 | 0 | 251 | 0 | 708 | 500 | 1208 | 1292 | 2500 | 1792
 |  | - | - | - | - | - | - | - | - | - |  | - | - | - | -
 | Total Emergency CapEx | 0 | 5500 | -3913 | 457 | 0 | 122 | 2858 | 5716 | 10740 | 3299 | 14039 | 7561 | 21600 | 10860
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 2513 | 18015 | -1065 | 8684 | 5722 | 7923 | 4328 | 10806 | 56926 | 29419 | 86345 | 69396 | 155741 | 98815
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | 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 | 2513 | 18015 | -1065 | 8684 | 5722 | 7923 | 4328 | 10806 | 56926 | 29419 | 86345 | 95896 | 182241 | 125315
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.01378943267431588 | 0.0988526182362915 | -0.005843909987324477 | 0.04765118716424954 | 0.03139798398823536 | 0.04347539796203928 | 0.02374877223017872 | 0.05929510922350075 | 0.3123665914914865 | 0.1614290966357735 | 0.4737956881272601 | 0.52620431187274 | 1 | 0.6876334085085134