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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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
 | Seal Coat/Restripe or Repairs Parking Lot | 0 | 0 | 0 | 0 | 0 | 4152 | 0 | 0 | 4152 | 0 | 4152 | -402 | 3750 | -402
 | PTAC Coil Replacement | 0 | 1788 | 0 | 0 | 0 | 0 | 0 | 0 | 1788 | 1500 | 3288 | 1512 | 4800 | 3012
 | Flooring Replacements-Carpet (Material) | 0 | 5046 | 0 | 0 | 484 | 0 | 0 | 0 | 5530 | 4000 | 9530 | 30 | 9560 | 4030
 | 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
 | Interior Furnishing Replacements | 544 | 619 | 0 | 0 | 0 | 0 | 0 | 0 | 1163 | 0 | 1163 | -1163 | 0 | -1163
 | Night Stands | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2250 | 2250 | 2250
 | Dressers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1400 | 1400 | 1400
 | Dining Room Chairs | 0 | 2003 | 0 | 197 | 0 | 3550 | 19 | 0 | 5769 | 0 | 5769 | -5769 | 0 | -5769
 | Bed - Mattress & Box Springs | 0 | 1281 | 0 | 0 | 0 | 0 | 0 | 0 | 1281 | 1000 | 2281 | 469 | 2750 | 1469
 | Beverage Bar Repair | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2900 | 2900 | 2900
 | AL Dining Table Cloths | 0 | 0 | 0 | 0 | 0 | 188 | 0 | 0 | 188 | 0 | 188 | 4312 | 4500 | 4312
 | ALZ Dining Table Cloths | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3600 | 3600 | 3600
 | Replace Furniture | 565 | 0 | 419 | 0 | 0 | 0 | 0 | 0 | 984 | 5000 | 5984 | 316 | 6300 | 5316
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 1000 | 650 | 1650 | 1650
 | Resident Room Chair Replacement | 514 | 863 | -297 | 0 | 955 | 0 | 745 | 0 | 2780 | 0 | 2780 | 1330 | 4110 | 1330
 | 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 | 150 | 150 | 150 | 300 | 300
 | Seasonal Decorations | 0 | 0 | 0 | 382 | 0 | 0 | 0 | 88 | 470 | 500 | 970 | 530 | 1500 | 1030
 | Pendants | 0 | 0 | 1111 | 0 | 0 | 0 | 0 | 0 | 1111 | 0 | 1111 | -1111 | 0 | -1111
 | Clinical Supplies (Ref., BP Supplies, Charts) | 0 | 400 | 27 | 0 | 315 | 0 | 0 | 155 | 897 | 0 | 897 | 53 | 950 | 53
 | Linens Replacement (Linens/Towels) | 0 | 478 | 0 | 217 | 0 | 211 | 754 | 421 | 2081 | 0 | 2081 | -331 | 1750 | -331
 | Mixing Valves & Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500
 | Patio Chairs | 0 | 548 | 0 | 548 | 0 | 0 | 0 | 0 | 1096 | 464 | 1560 | 0 | 1560 | 464
 | Front Porch Rockers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1680 | 1680 | 1680
 | Other | 845 | 207 | 0 | 6494 | 2458 | 0 | 802 | 1056 | 11862 | 0 | 11862 | -8867 | 2995 | -8867
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 2468 | 13233 | 1260 | 9025 | 4212 | 8101 | 2320 | 1720 | 42339 | 17589 | 59928 | 4722 | 64650 | 22311
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Snack Cart | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 895 | 895 | 895
 | Irrigation & Plants at Carillon Sign | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500
 | Sidewalk Repair | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 2500 | 0 | 2500 | 2500
 | Repair Roof Leaks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | ALZ Dining Chairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10800 | 10800 | 0 | 10800 | 10800
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 0 | 500 | 500
 | Parking Lot Repairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4800 | 4800 | 4800
 | B Hall More Lights | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 360 | 360 | 0 | 360 | 360
 | Replace Fire Place Glass | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 150 | 0 | 150 | 150
 | B Hall Restroom Vinyl | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 450 | 450 | 0 | 450 | 450
 | Ice Machine on Beverage Bar | 1212 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1212 | 0 | 1212 | 1988 | 3200 | 1988
 | 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 Admin Office & Private Dining | 0 | 0 | 0 | 0 | 0 | 0 | 2016 | 0 | 2016 | 0 | 2016 | 5484 | 7500 | 5484
 | 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 | 1212 | 0 | 0 | 0 | 0 | 0 | 2016 | 0 | 3228 | 19805 | 23033 | 15167 | 38200 | 34972
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 3680 | 13233 | 1260 | 9025 | 4212 | 8101 | 4336 | 1720 | 45567 | 37394 | 82961 | 19889 | 102850 | 57283
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Refurbishment Packages | 0 | 0 | 0 | 0 | 0 | 300 | 2209 | 0 | 2509 | 25000 | 27509 | 22491 | 50000 | 47491
 |  | - | - | - | - | - | - | - | - | - |  | - | - | - | -
 |  | Carillon Assisted Living, LLC |  |  |  |  |  |  |  |  |  |  |  |  | 09/14/12
 |  | Replacement Capital Expenditure Budgets by Facility |  |  |  |  |  |  |  |  |  |  |  |  | 04:48 PM
 |  | As Of  09/14/12
 |  | Asheboro
 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 5506 | 0 | 0 | 5506 | 0 | 5506 | -1406 | 4100 | -1406
 | 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 | 647 | 0 | 0 | 0 | 0 | 647 | 0 | 647 | 2853 | 3500 | 2853
 | 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 | 0 | 0 | 1500 | 1500 | 1500
 | Mag Locks & Key Pads | 0 | 0 | 340 | 0 | 0 | 0 | 500 | 0 | 840 | 500 | 1340 | 160 | 1500 | 660
 | [NAME] (Parts & Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 1000 | 250 | 1250 | 1250
 | Other | 0 | 998 | 0 | 0 | 0 | 777 | 68 | 0 | 1843 | 1500 | 3343 | -843 | 2500 | 657
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 0 | 998 | 340 | 647 | 0 | 6283 | 568 | 0 | 8836 | 3000 | 11836 | 9764 | 21600 | 12764
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 3680 | 14231 | 1600 | 9672 | 4212 | 14684 | 7113 | 1720 | 56912 | 65394 | 122306 | 52144 | 174450 | 117538
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | Van | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17500 | 17500 | 27500 | 45000 | 45000
 | E-MAR Systems | 0 | 0 | 0 | 0 | 0 | 0 | 17340 | 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 | 0 | 0 | 0 | 17340 | 0 | 17340 | 21660 | 39000 | 32500 | 71500 | 54160
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 3680 | 14231 | 1600 | 9672 | 4212 | 14684 | 24453 | 1720 | 74252 | 87054 | 161306 | 84644 | 245950 | 171698
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.01496239072982313 | 0.05786135393372636 | 0.006505387273836145 | 0.0393250660703395 | 0.01712543199837365 | 0.05970319170563122 | 0.09942264687944705 | 0.006993291319373857 | 0.3018987599105509 | 0.3539499898353324 | 0.6558487497458834 | 0.3441512502541167 | 1 | 0.6981012400894491