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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 0 | 207 | 207 | 0 | 207 | 793 | 1000 | 793
 | PTAC Coil Replacement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1600 | 1600 | 1600
 | Flooring Replacements-Carpet (Material) | 0 | 0 | 0 | 0 | 128 | 0 | 0 | 0 | 128 | 0 | 128 | -128 | 0 | -128
 | Flooring Replacements-Carpet (Labor) | 0 | 0 | 0 | 0 | 2150 | 0 | 0 | 0 | 2150 | 0 | 2150 | -2150 | 0 | -2150
 | Flooring Replacements - Vinyl | 0 | 0 | 0 | 0 | 1101 | 0 | 0 | 0 | 1101 | 0 | 1101 | -1101 | 0 | -1101
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 1150 | 1650 | 1650
 | Seasonal Decorations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | 750 | 750 | 1500 | 1500
 | Pendants | 0 | 0 | 451 | 0 | 973 | 110 | 0 | 371 | 1905 | 0 | 1905 | -735 | 1170 | -735
 | Pagers | 0 | 0 | 0 | 0 | 0 | 588 | 0 | 0 | 588 | 400 | 988 | 62 | 1050 | 462
 | 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 | 0 | 934 | 934 | 0 | 0 | 0 | 0 | 1868 | 1000 | 2868 | 127 | 2995 | 1127
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 0 | 0 | 1385 | 934 | 4352 | 698 | 0 | 578 | 7947 | 4400 | 12347 | 1818 | 14165 | 6218
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | 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 | 0 | 1795 | 1795
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 0 | 0 | 1385 | 934 | 4352 | 698 | 0 | 578 | 7947 | 6195 | 14142 | 1818 | 15960 | 8013
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | 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:
 | 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 | 199 | 0 | 199 | 0 | 199 | 2051 | 2250 | 2051
 | Nurse Call Parts | 0 | 0 | 0 | 14 | 0 | 0 | 0 | 0 | 14 | 0 | 14 | 1486 | 1500 | 1486
 | 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 | 474 | 0 | 474 | 0 | 474 | 776 | 1250 | 776
 | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 2500 | 2500 | 2500
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 0 | 0 | 0 | 14 | 0 | 0 | 673 | 0 | 687 | 0 | 687 | 9813 | 10500 | 9813
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 0 | 0 | 1385 | 948 | 4352 | 698 | 673 | 578 | 8634 | 6195 | 14829 | 11631 | 26460 | 17826
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | E-MAR Systems | 0 | 0 | 17340 | 0 | 0 | 0 | 0 | 0 | 17340 | 4160 | 21500 | 0 | 21500 | 4160
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Discretionary CapEx | 0 | 0 | 17340 | 0 | 0 | 0 | 0 | 0 | 17340 | 4160 | 21500 | 0 | 21500 | 4160
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 0 | 0 | 18725 | 948 | 4352 | 698 | 673 | 578 | 25974 | 10355 | 36329 | 11631 | 47960 | 21986
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0 | 0 | 0.3904295246038365 | 0.01976647206005004 | 0.09074228523769808 | 0.01455379482902419 | 0.0140325271059216 | 0.01205170975813178 | 0.5415763135946622 | 0.2159090909090909 | 0.7574854045037531 | 0.2425145954962469 | 1 | 0.4584236864053378