Spreadsheet: 116333d1311763312-sum-cells-based-on-value-book1
Sheet: Sheet1

2011-07-27 00:00:00
Account |  | Previous Years |  |  |  | 2011-01-01 00:00:00 |  |  |  | 2011-02-01 00:00:00 |  |  |  | 2011-03-01 00:00:00 |  |  |  | 2011-04-01 00:00:00 |  |  |  | 2011-05-01 00:00:00
 |  | Actuals/Forecast | Plan | [NAME] |  | Actuals/Forecast | Plan | [NAME] |  | Actuals/Forecast | Plan | [NAME] |  | Actuals/Forecast | Plan | [NAME] |  | Actuals/Forecast | Plan | [NAME] |  | Actuals/Forecast | Plan | [NAME]
Costs
A |  | 1033635 | 8759154 | -7725519 |  | 8029.75 |  | 8029.75 |  | 8029.75 |  | 8029.75 |  | 8029.75 |  | 8029.75 |  | 8029.75 |  | 8029.75 |  | 8029.75 |  | 8029.75
b |  | 25406282 | 13805500 | 11600782 |  | 4903.5 |  | 4903.5 |  | 4903.5 |  | 4903.5 |  | 4903.5 |  | 4903.5 |  | 4903.5 |  | 4903.5 |  | 4903.5 |  | 4903.5
c |  | 686590 | 686590 |  |  | 11353.25 |  | 11353.25 |  | 11353.25 |  | 11353.25 |  | 11353.25 |  | 11353.25 |  | 11353.25 |  | 11353.25 |  | 11353.25 |  | 11353.25
d |  | 2552721 | 2172773 | 379948 |  |  |  |  |  | 612 |  | 612 |  | 108 |  | 108 |  | 122 |  | 122
e |  |  |  |  |  | 4429.75 |  | 4429.75 |  | 4429.75 |  | 4429.75 |  | 4429.75 |  | 4429.75 |  | 4429.75 |  | 4429.75 |  | 4429.75 |  | 4429.75
f |  | 1270134 | 9224535 | -7954401 |  | 3763.58 |  | 3763.58 |  | 3763.59 |  | 3763.59 |  | 3763.58 |  | 3763.58 |  | 3763.58 |  | 3763.58 |  | 3763.59 |  | 3763.59
g |  | 1265522 | 38300 | 1227222 |  | 3403 |  | 3403 |  | 3403 |  | 3403 |  | 3403 |  | 3403 |  | 3403 |  | 3403 |  | 3403 |  | 3403
h |  | 1112629 | 268393 | 844236 |  | 21618.33 |  | 21618.33 |  | 21618.34 |  | 21618.34 |  | 21618.33 |  | 21618.33 |  | 21618.33 |  | 21618.33 |  | 21618.34 |  | 21618.34
u |  | 8516640 | 8040636 | 476004 |  | 146443 | 184674 | -38231 |  | 146443 | 184674 | -38231 |  | 146443 | 184674 | -38231 |  | 146443 | 184674 | -38231 |  | 146443 | 184674 | -38231
t |  | 1699902 | 2623423 | -923521 |  | 70829.25 | 70829.25 |  |  | 70829.25 | 70829.25 |  |  | 70829.25 | 70829.25 |  |  | 70829.25 | 70829.25 |  |  | 70829.25 | 70829.25
Capitalization
e |  | -19476088 | -18426033 | -1050055 |  | 15831.83 |  | 15831.83 |  | 15831.84 |  | 15831.84 |  | 15831.83 |  | 15831.83 |  | 15831.83 |  | 15831.83 |  | 15831.84 |  | 15831.84
Amortization
q |  | 2522543 | 8942365 | -6419822 |  | 63132.92 | 278062.25 | -214929.33 |  | 63132.91 | 278062.25 | -214929.34 |  | 63132.92 | 278062.25 | -214929.33 |  | 63132.92 | 278062.25 | -214929.33 |  | 63132.91 | 278062.25 | -214929.34
Business Restructuring Costs
hh |  |  |  |  |  | 120772 |  | 120772
Benefits coming from
ii |  | 81326497 | 95523753 | -14197256 |  |  | 3280972.58 | -3280972.58 |  |  | 3280972.59 | -3280972.59 |  |  | 3280972.58 | -3280972.58 |  |  | 3280972.58 | -3280972.58 |  | 1400 | 3280972.59 | -3279572.59
Total Capital |  | -16953545 | -9483668 | -7469877 |  | 78964.75 | 278062.25 | -199097.5 |  | 78964.75 | 278062.25 | -199097.5 |  | 78964.75 | 278062.25 | -199097.5 |  | 78964.75 | 278062.25 | -199097.5 |  | 78964.75 | 278062.25 | -199097.5
Total Expense |  | 43544055 | 45619304 | -2075249 |  | 274773.41 | 255503.25 | 19270.16 |  | 275385.43 | 255503.25 | 19882.18 |  | 274881.41 | 255503.25 | 19378.16 |  | 274895.41 | 255503.25 | 19392.16 |  | 274773.43 | 255503.25 | 19270.18
Total Revenue
Total Benefit |  | 81326497 | 95523753 | -14197256 |  |  | 3280972.58 | -3280972.58 |  |  | 3280972.59 | -3280972.59 |  |  | 3280972.58 | -3280972.58 |  |  | 3280972.58 | -3280972.58 |  | 1400 | 3280972.59 | -3279572.59
Total Labor Hours
Total FTE's
Total Other
Total Expenditure |  | 26590510 | 36135636 | -9545126 |  | 353738.16 | 533565.5 | -179827.34 |  | 354350.18 | 533565.5 | -179215.32 |  | 353846.16 | 533565.5 | -179719.34 |  | 353860.16 | 533565.5 | -179705.34 |  | 353738.18 | 533565.5 | -179827.32
Total Income |  | 81326497 | 95523753 | -14197256 |  |  | 3280972.58 | -3280972.58 |  |  | 3280972.59 | -3280972.59 |  |  | 3280972.58 | -3280972.58 |  |  | 3280972.58 | -3280972.58 |  | 1400 | 3280972.59 | -3279572.59
Net Total |  | 54735987 | 59388117 | -4652130 |  | -353738.16 | 2747407.08 | -3101145.24 |  | -354350.18 | 2747407.09 | -3101757.27 |  | -353846.16 | 2747407.08 | -3101253.24 |  | -353860.16 | 2747407.08 | -3101267.24 |  | -352338.18 | 2747407.09 | -3099745.27
Total Expenditure |  | 26590510 | 36135636 | -9545126 |  | 353738.16 | 533565.5 | -179827.34 |  | 354350.18 | 533565.5 | -179215.32 |  | 353846.16 | 533565.5 | -179719.34 |  | 353860.16 | 533565.5 | -179705.34 |  | 353738.18 | 533565.5 | -179827.32
2011-01-01 00:00:00 |  | 2011-01-01 00:00:00 | #N/A
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00