Spreadsheet: 94418d1294244283-match-index-to-pull-data-according-to-multiple-criteria-total-fy12-analysis-formula
Sheet: Budget

FY10 Actual (USD)
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) | 1510 | 560 | 950 | 0
Indirect Labor (Salaries and Benefits) | 235 | 123 | 112 | 0
Overtime | 40 | 12 | 28 | 0
Temporary / Contract Labor | 33 | 12 | 21 | 0
Employee Welfare and Training | 0 | 0 | 0 | 0
Total EE Expenses | 1818 | 707 | 1111 | 0
Travel and Entertainment | 150 | 8 | 142 | 0
Repair & Maintenance | 555 | 12 | 543 | 0
Supplies | 329 | 8 | 321 | 0
Professional / Contracted Services | 252 | 7 | 245 | 0
Non-capital purchases | 0 | 0 | 0 | 0
Utilities | 0 | 0 | 0 | 0
Depreciation | 358 | 121 | 237 | 0
Central pool allocation | 1059 | 218 | 841 | 0
BPT transfers | 1171 | 425 | 746 | 0
SSC CHARGE IN | 0 | 0 | 0 | 0
Rent | 569 | 391 | 178 | 0
Insurance | 0 | 0 | 0 | 0
All Other Expenses | 798 | 495 | 303 | 0
Total Expenses | 7059 | 2392 | 4667 | 0
Planned Variances
Scrap | 0 | 0 | 0 | 0
Obsolescence | 848 | 848 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Total Variances | 848 | 848 | 0 | 0
FY11 Budget (USD)
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) | 780 | 545 | 0 | 235
Indirect Labor (Salaries and Benefits) | 971 | 187 | 0 | 784
Overtime | 307 | 126 | 0 | 181
Temporary / Contract Labor | 339 | 152 | 0 | 187
Employee Welfare and Training | 0 | 0 | 0 | 0
Total EE Expenses | 2397 | 1010 | 0 | 1387
Travel and Entertainment | 1244 | 958 | 0 | 286
Repair & Maintenance | 444 | 151 | 0 | 293
Supplies | 754 | 188 | 0 | 566
Professional / Contracted Services | 1496 | 810 | 0 | 686
Non-capital purchases | 0 | 0 | 0 | 0
Utilities | 0 | 0 | 0 | 0
Depreciation | 247 | 146 | 0 | 101
Central pool allocation | 394 | 235 | 0 | 159
BPT transfers | 494 | 371 | 0 | 123
SSC CHARGE IN | 0 | 0 | 0 | 0
Rent | 981 | 424 | 0 | 557
Insurance | 0 | 0 | 0 | 0
All Other Expenses | 1273 | 663 | 0 | 610
Total Expenses | 9724 | 4956 | 0 | 4768
Planned Variances
Scrap | 0 | 0 | 0 | 0
Obsolescence | 856 | 856 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Total Variances | 856 | 856 | 0 | 0
FY11 Reest (USD)
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) | 1030 | 564 | 223 | 243
Indirect Labor (Salaries and Benefits) | 1198 | 195 | 313 | 690
Overtime | 682 | 129 | 284 | 269
Temporary / Contract Labor | 1245 | 337 | 783 | 125
Employee Welfare and Training | 0 | 0 | 0 | 0
Total EE Expenses | 4155 | 1225 | 1603 | 1327
Travel and Entertainment | 821 | 121 | 372 | 328
Repair & Maintenance | 1677 | 176 | 975 | 526
Supplies | 1165 | 187 | 699 | 279
Professional / Contracted Services | 2167 | 897 | 704 | 566
Non-capital purchases | 0 | 0 | 0 | 0
Utilities | 0 | 0 | 0 | 0
Depreciation | 1204 | 147 | 145 | 912
Central pool allocation | 377 | 259 | 0 | 118
BPT transfers | 1360 | 488 | 108 | 764
SSC CHARGE IN | 0 | 0 | 0 | 0
Rent | 1798 | 544 | 763 | 491
Insurance | 0 | 0 | 0 | 0
All Other Expenses | 948 | 633 | 0 | 315
Total Expenses | 15672 | 4677 | 5369 | 5626
Planned Variances
Scrap | 0 | 0 | 0 | 0
Obsolescence | 0 | 0 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Total Variances | 0 | 0 | 0 | 0
FY12 Bgt (USD)
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) | 1199 | 430 | 0 | 769
Indirect Labor (Salaries and Benefits) | 1505 | 250 | 0 | 1255
Overtime | 1979 | 808 | 0 | 1171
Temporary / Contract Labor | 9483 | 150 | 0 | 9333
Employee Welfare and Training | 0 | 0 | 0 | 0
Total EE Expenses | 14166 | 1638 | 0 | 12528
Travel and Entertainment | 6392 | 176 | 0 | 6216
Repair & Maintenance | 8808 | 192 | 0 | 8616
Supplies | 1322 | 179 | 0 | 1143
Professional / Contracted Services | 1145 | 130 | 0 | 1015
Non-capital purchases | 0 | 0 | 0 | 0
Utilities | 0 | 0 | 0 | 0
Depreciation | 3674 | 1354 | 0 | 2320
Central pool allocation | 4914 | 3375 | 0 | 1539
BPT transfers | 1634 | 637 | 0 | 997
SSC CHARGE IN | 0 | 0 | 0 | 0
Rent | 7344 | 548 | 0 | 6796
Insurance | 0 | 0 | 0 | 0
All Other Expenses | 2894 | 579 | 0 | 2315
Total Expenses | 52293 | 8808 | 0 | 43485
Planned Variances
Scrap | 0 | 0 | 0 | 0
Obsolescence | 0 | 0 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Total Variances | 0 | 0 | 0 | 0