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

 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 0 | 0 | 0 | 0 | 500 | 500 | 1150 | 1650 | 1650
 | Seasonal Decorations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1250 | 250 | 1500 | 1500
 | Pendants | 0 | 1005 | 0 | 0 | 0 | 910 | 0 | 0 | 1915 | 0 | 1915 | -745 | 1170 | -745
 | Pagers | 0 | 422 | 0 | 0 | 429 | 0 | 0 | 0 | 851 | 150 | 1001 | 49 | 1050 | 199
 | 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 | 30 | 191 | 0 | 0 | 0 | 0 | 221 | 1200 | 1421 | 329 | 1750 | 1529
 | Mixing Valves & Parts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500
 | Other | 0 | 0 | 0 | 0 | 0 | 85 | 182 | 0 | 267 | 2500 | 2767 | 228 | 2995 | 2728
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 0 | 1427 | 30 | 191 | 429 | 995 | 182 | 0 | 3254 | 6100 | 9354 | 4811 | 14165 | 10911
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 | A/C Issues in Admin Office & Private Dining | 0 | 0 | 0 | 0 | 0 | 914 | 0 | 1230 | 2144 | 0 | 2144 | -2144 | 0 | -2144
 | Replace Oven, if needed | 1247 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1247 | 0 | 1247 | -1247 | 0 | -1247
 | 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 | 1247 | 0 | 0 | 0 | 0 | 914 | 0 | 1230 | 3391 | 1795 | 5186 | -3391 | 1795 | -1596
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 1247 | 1427 | 30 | 191 | 429 | 1909 | 182 | 1230 | 6645 | 7895 | 14540 | 1420 | 15960 | 9315
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - |  | - | - | - | -
 |  | Carillon Assisted Living, LLC |  |  |  |  |  |  |  |  |  |  |  |  | 09/14/12
 |  | Replacement Capital Expenditure Budgets by Facility |  |  |  |  |  |  |  |  |  |  |  |  | 04:48 PM
 |  | As Of  09/14/12
 |  | Fuquay-Varina
 |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 1313 | 0 | 0 | 1313 | 1000 | 2313 | 187 | 2500 | 1187
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 0 | 0 | 0 | 0 | 0 | 1313 | 0 | 0 | 1313 | 2250 | 3563 | 6937 | 10500 | 9187
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 1247 | 1427 | 30 | 191 | 429 | 3222 | 182 | 1230 | 7958 | 10145 | 18103 | 8357 | 26460 | 18502
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | 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 | 1247 | 1427 | 30 | 191 | 429 | 3222 | 182 | 1230 | 7958 | 10145 | 18103 | 29857 | 47960 | 40002
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | 0.02600083402835696 | 0.02975396163469558 | 0.0006255212677231026 | 0.003982485404503753 | 0.008944954128440367 | 0.06718098415346122 | 0.003794829024186822 | 0.02564637197664721 | 0.165929941618015 | 0.2115304420350292 | 0.3774603836530442 | 0.6225396163469558 | 1 | 0.834070058381985