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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 0 | 0 | 0 | 0 | 1000 | 1000 | 1000
 | PTAC Coil Replacement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1600 | 1600 | 1600
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 544 | 0 | 0 | 544 | 0 | 544 | -544 | 0 | -544
 | [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 | 460 | 0 | 0 | 956 | 0 | 0 | 1416 | 0 | 1416 | -246 | 1170 | -246
 | Pagers | 0 | 0 | 0 | 0 | 270 | 0 | 0 | 0 | 270 | 500 | 770 | 280 | 1050 | 780
 | Clinical Supplies (Ref., BP Supplies, Charts) | 0 | 0 | 0 | 0 | 0 | 0 | 104 | 0 | 104 | 500 | 604 | 346 | 950 | 846
 | 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 | 1724 | 0 | 0 | 0 | 0 | 597 | 0 | 0 | 2321 | 500 | 2821 | 174 | 2995 | 674
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 1724 | 0 | 460 | 0 | 270 | 2097 | 104 | 0 | 4655 | 4000 | 8655 | 5510 | 14165 | 9510
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | Ice Machine on Beverage Bar | 0 | 0 | 0 | 0 | 0 | 420 | 0 | 0 | 420 | 1250 | 1670 | -1670 | 0 | -420
 | Garden Place Washer & Dryer | 0 | 0 | 0 | 0 | 0 | 668 | 0 | 0 | 668 | 0 | 668 | -668 | 0 | -668
 | 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 | 1088 | 0 | 0 | 1088 | 3045 | 4133 | -2338 | 1795 | 707
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 1724 | 0 | 460 | 0 | 270 | 3185 | 104 | 0 | 5743 | 7045 | 12788 | 3172 | 15960 | 10217
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - |  | - | - | - | -
 |  | Carillon Assisted Living, LLC |  |  |  |  |  |  |  |  |  |  |  |  | 09/14/12
 |  | Replacement Capital Expenditure Budgets by Facility |  |  |  |  |  |  |  |  |  |  |  |  | 04:48 PM
 |  | As Of  09/14/12
 |  | Fayetteville
 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 2250 | 2250 | 2250
 | Nurse Call Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 250 | 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 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 1250
 | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2250 | 2250 | 250 | 2500 | 2500
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3500 | 3500 | 7000 | 10500 | 10500
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 1724 | 0 | 460 | 0 | 270 | 3185 | 104 | 0 | 5743 | 10545 | 16288 | 10172 | 26460 | 20717
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | E-MAR Systems | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21500 | 21500 | 21500
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Discretionary CapEx | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21500 | 21500 | 21500
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 1724 | 0 | 460 | 0 | 270 | 3185 | 104 | 0 | 5743 | 10545 | 16288 | 31672 | 47960 | 42217
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.03594662218515429 | 0 | 0.009591326105087573 | 0 | 0.005629691409507923 | 0.0664095079232694 | 0.002168473728106756 | 0 | 0.1197456213511259 | 0.2198707256046706 | 0.3396163469557965 | 0.6603836530442035 | 1 | 0.880254378648874