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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 207 | 1394 | 1394 | 2788 | -1788 | 1000 | -394
 | Seal Coat/Restripe or Repairs Parking Lot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3750 | 3750 | 3750
 | PTAC Coil Replacement | 0 | 0 | 0 | 0 | 0 | 450 | 813 | 0 | 1263 | 1263 | 2526 | 2274 | 4800 | 3537
 | Flooring Replacements-Carpet (Material) | 0 | 3404 | 0 | 0 | 0 | 0 | 931 | 0 | 4335 | 4335 | 8670 | -1846 | 6824 | 2489
 | Flooring Replacements-Carpet (Labor) | 0 | 0 | 0 | 489 | 0 | 0 | 1937 | 0 | 2426 | 2426 | 4852 | -2602 | 2250 | -176
 | Flooring Replacements - Vinyl | 0 | 0 | 0 | 1341 | 0 | 0 | 931 | 0 | 2272 | 2272 | 4544 | -2444 | 2100 | -172
 | Night Stands | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 300 | 1800 | 1800
 | Dressers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 1000 | 50 | 1050 | 1050
 | Dining Room Chairs | 0 | 2804 | 0 | 268 | 0 | 5173 | 0 | 0 | 8245 | 8245 | 16490 | 17610 | 34100 | 25855
 | Bed - Mattress & Box Springs | 0 | 1281 | 0 | 0 | 0 | 0 | 0 | 0 | 1281 | 1281 | 2562 | 188 | 2750 | 1469
 | [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 | 2500 | 2500 | 5600 | 8100 | 8100
 | Replace Furniture | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 2850 | 7850 | 7850
 | [NAME] | 450 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 450 | 950 | 1400 | 250 | 1650 | 1200
 | Resident Room Chair Replacement | 767 | 0 | 1546 | 0 | 1362 | 0 | 0 | 0 | 3675 | 3675 | 7350 | -3240 | 4110 | 435
 | 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 | 0 | 0 | 0 | 0 | 0 | 1000 | 1000 | 500 | 1500 | 1500
 | Pendants | 0 | 0 | 0 | 0 | 558 | 0 | 1150 | 0 | 1708 | 1708 | 3416 | -2246 | 1170 | -538
 | Pagers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 270 | 270 | 770 | 1040 | 10 | 1050 | 780
 | Clinical Supplies (Ref., BP Supplies, Charts) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 450 | 950 | 950
 | Remove Trees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 950 | 950 | 950
 | Replace Trees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 1250
 | 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
 | Patio Chairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 60 | 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 | 2000 | 2000 | 995 | 2995 | 2995
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 1217 | 7489 | 1546 | 3285 | 1920 | 5623 | 5762 | 477 | 27319 | 45144 | 72463 | 29071 | 101534 | 74215
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Irrigation & Plants at Carillon Sign | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | Repair Roof Leaks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500
 | Parking Lot Repairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9600 | 9600 | 9600
 | 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 | 0 | 0 | 1750 | 1750 | 1750
 | A/C Issues in B Hall | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000
 | Replace Oven, if needed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4200 | 4200 | 4200
 | Attic Fans | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2400 | 2400 | 2400
 | 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 | 0 | 0 | 0 | 0 | 0 | 1795 | 1795 | 29150 | 30945 | 30945
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 1217 | 7489 | 1546 | 3285 | 1920 | 5623 | 5762 | 477 | 27319 | 46939 | 74258 | 58221 | 132479 | 105160
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Refurbishment Packages | 0 | 0 | 0 | 0 | 2238 | 0 | 80 | 1222 | 3540 | 3540 | 7080 | 5420 | 12500 | 8960
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | Carillon Assisted Living, LLC |  |  |  |  |  |  |  |  |  |  |  |  | 09/14/12
 |  | Replacement Capital Expenditure Budgets by Facility |  |  |  |  |  |  |  |  |  |  |  |  | 04:48 PM
 |  | As Of  09/14/12
 |  | Salisbury
 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 4100 | 4100 | 4100
 | 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 | 0 | 0 | 0 | 0 | 1930 | 1930 | 0 | 1930 | 1570 | 3500 | 1570
 | Phone System Cards (Parts & Labor) | 0 | 0 | 0 | 1210 | 0 | 0 | 0 | 0 | 1210 | 1210 | 2420 | -920 | 1500 | 290
 | Commercial Washer Repair or Dryer | 0 | 0 | 0 | 0 | 0 | 0 | 322 | 0 | 322 | 322 | 644 | 1606 | 2250 | 1928
 | Nurse Call Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1200 | 1200 | 300 | 1500 | 1500
 | Mag Locks & Key Pads | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 1000 | 500 | 1500 | 1500
 | [NAME] (Parts & Labor) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 500 | 1250 | 1250
 | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1641 | 1641 | 2141 | 3782 | -1282 | 2500 | 859
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 0 | 0 | 0 | 1210 | 0 | 0 | 322 | 3571 | 5103 | 6623 | 11726 | 9874 | 21600 | 16497
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 1217 | 7489 | 1546 | 4495 | 4158 | 5623 | 6164 | 5270 | 35962 | 57102 | 93064 | 73515 | 166579 | 130617
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | E-MAR Systems | 0 | 17340 | 183 | 0 | 0 | 0 | 0 | 0 | 17523 | 21500 | 39023 | -17523 | 21500 | 3977
 | Replacement Landscaping | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Discretionary CapEx | 0 | 17340 | 183 | 0 | 0 | 0 | 0 | 0 | 17523 | 21500 | 39023 | -12523 | 26500 | 8977
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 1217 | 24829 | 1729 | 4495 | 4158 | 5623 | 6164 | 5270 | 53485 | 78602 | 132087 | 60992 | 193079 | 139594
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.006303119448515892 | 0.1285950310494668 | 0.00895488375224649 | 0.02328062606497858 | 0.02153522651349966 | 0.02912279429663506 | 0.03192475618788165 | 0.02729452711066455 | 0.2770109644238887 | 0.4070976128942039 | 0.6841085773180926 | 0.3158914226819074 | 1 | 0.7229890355761114