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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 397 | 0 | 0 | 0 | 0 | 675 | 1072 | 0 | 1072 | 3728 | 4800 | 3728
 | 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 | 2217 | 0 | 0 | 0 | 2217 | 0 | 2217 | 33 | 2250 | 33
 | Flooring Replacements - Vinyl | 0 | 0 | 0 | 0 | 1620 | 0 | 0 | 0 | 1620 | 0 | 1620 | 480 | 2100 | 480
 | Interior Furnishing Replacements | 0 | 676 | 0 | 0 | 0 | 0 | 0 | 0 | 676 | 0 | 676 | -676 | 0 | -676
 | 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
 | 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 | 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 | 1639 | 0 | 0 | 0 | 0 | 0 | 0 | 1639 | 3500 | 5139 | 2961 | 8100 | 6461
 | ALZ Dining Table Cloths | 0 | 1420 | 0 | 0 | 0 | 0 | 0 | 0 | 1420 | 3000 | 4420 | 980 | 5400 | 3980
 | Replace Furniture | 927 | 1170 | 360 | 0 | 0 | 0 | 857 | -26 | 3288 | 1500 | 4788 | 1512 | 6300 | 3012
 | [NAME] | 0 | 0 | 0 | 0 | 508 | 0 | 0 | 0 | 508 | 0 | 508 | 1142 | 1650 | 1142
 | Resident Room Chair Replacement | 0 | 0 | 0 | 0 | 0 | 0 | 1054 | 0 | 1054 | 0 | 1054 | 3056 | 4110 | 3056
 | Repaint Carillon Road Sign | 550 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 550 | 0 | 550 | -175 | 375 | -175
 | 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 | 650 | 233 | 0 | 0 | 191 | 0 | 0 | 32 | 1106 | 750 | 1856 | -356 | 1500 | 394
 | Pendants | 0 | 138 | 0 | 0 | 981 | 0 | 0 | 0 | 1119 | 500 | 1619 | -449 | 1170 | 51
 | Pagers | 0 | 0 | 0 | 0 | 178 | 333 | 0 | 0 | 511 | 500 | 1011 | 39 | 1050 | 539
 | 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 | 388 | 0 | 0 | 0 | 0 | 0 | 388 | 1000 | 1388 | 362 | 1750 | 1362
 | Mixing Valves & Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500
 | Patio Chairs | 0 | 854 | 0 | 854 | 0 | 0 | 0 | 0 | 1708 | 1400 | 3108 | 12 | 3120 | 1412
 | Front Porch Rockers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1680 | 1680 | 1680
 | Other | 141 | 0 | 0 | 0 | 0 | 0 | 0 | 157 | 298 | 2000 | 2298 | 697 | 2995 | 2697
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 2268 | 8000 | 1145 | 854 | 5695 | 333 | 3078 | 838 | 22211 | 14850 | 37061 | 29839 | 66900 | 44689
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Repair Roof Leaks | 0 | 0 | 0 | 0 | 0 | 211 | 0 | 0 | 211 | 0 | 211 | 1289 | 1500 | 1289
 | Paint [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900 | 900 | 0 | 900 | -225 | 675 | -225
 | 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 | 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 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
 | Garden Place Washer & Dryer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 895 | 895 | 895
 | Replace Oven, if needed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4200 | 4200 | 4200
 | Attic Fans | 0 | 0 | 0 | 0 | 389 | 0 | 0 | 0 | 389 | 0 | 389 | -389 | 0 | -389
 | 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 | 389 | 211 | 0 | 900 | 1500 | 5045 | 6545 | 9270 | 15815 | 14315
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 2268 | 8000 | 1145 | 854 | 6084 | 544 | 3078 | 1738 | 23711 | 19895 | 43606 | 39109 | 82715 | 59004
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | 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
 |  | Newton
 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 0 | 456 | 0 | 6951 | 7407 | 0 | 7407 | -3307 | 4100 | -3307
 | 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 | 921 | 603 | 0 | 0 | 1888 | 3412 | 0 | 3412 | 88 | 3500 | 88
 | 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 | 1017 | 0 | 671 | 1688 | 0 | 1688 | 562 | 2250 | 562
 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | [NAME] (Parts & Labor) | 576 | 0 | 0 | 0 | 1121 | 0 | -576 | 0 | 1121 | 0 | 1121 | 129 | 1250 | 129
 | Other | 0 | 1712 | 0 | 0 | 0 | 0 | 0 | 472 | 2184 | 0 | 2184 | 316 | 2500 | 316
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 576 | 1712 | 0 | 921 | 1724 | 1473 | -576 | 9982 | 15812 | 1500 | 17312 | 4288 | 21600 | 5788
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 2844 | 9712 | 1145 | 1775 | 7808 | 2017 | 2502 | 11720 | 39523 | 21395 | 60918 | 55897 | 116815 | 77292
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | E-MAR Systems | 0 | 0 | 0 | 0 | 0 | 0 | 17340 | 0 | 17340 | 4160 | 21500 | 0 | 21500 | 4160
 | Replacement Landscaping | 700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 700 | 0 | 700 | 4300 | 5000 | 4300
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Discretionary CapEx | 700 | 0 | 0 | 0 | 0 | 0 | 17340 | 0 | 18040 | 4160 | 22200 | 4300 | 26500 | 8460
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 3544 | 9712 | 1145 | 1775 | 7808 | 2017 | 19842 | 11720 | 57563 | 25555 | 83118 | 60197 | 143315 | 85752
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.02472874437428043 | 0.0677668073823396 | 0.007989393992254823 | 0.01238530509716359 | 0.05448138715417088 | 0.01407389317238251 | 0.1384502668946028 | 0.08177790182465199 | 0.4016536998918466 | 0.1783135052157834 | 0.57996720510763 | 0.4200327948923699 | 1 | 0.5983463001081534