Spreadsheet: 94436d1294251743-match-index-to-pull-data-according-to-multiple-criteria-total-fy12-budget
Sheet: Sheet3

FY10 Actual (LC)
Prelim FY12 FX Rates |  | 4.3 | 4.3 | 4.3
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) |  | 1809 | 7089 | 0
Indirect Labor (Salaries and Benefits) |  | 7754 | 1563 | 0
Overtime |  | 3719 | 1844 | 0
Temporary / Contract Labor |  | 9419 | 4390 | 0
Employee Welfare and Training
Travel and Entertainment |  | 530 | 609 | 0
Repair & Maintenance |  | 7753 | 2332 | 0
Supplies |  | 6507 | 1381 | 0
Professional / Contracted Services |  | 2775 | 1053 | 0
Non-capital purchases |  | 0 | 0 | 0
Utilities
Depreciation |  | 5199 | 1018 | 0
Central pool allocation |  | 9364 | 3616 | 0
BPT transfers |  | 1827 | 320 | 0
SSC CHARGE IN
Rent |  | 1680 | 767 | 0
Insurance
All Other Expenses |  | 2133 | 13 | 0
Total Expenses |  | 60469 | 25995 | 0
Planned Variances
Scrap |  | 0 | 0 | 0
Obsolescence |  | 3644 | 0 | 0
Other ([NAME])
Other ([NAME])
Total Variances |  | 3644 | 0 | 0
FY11 Budget (LC)
Prelim FY12 FX Rates |  | 4.3 | 4.3 | 4.3
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) |  | 23450 | 0 | 10103
Indirect Labor (Salaries and Benefits) |  | 8053 | 0 | 3370
Overtime |  | 5423 | 0 | 777
Temporary / Contract Labor |  | 6515 | 0 | 805
Employee Welfare and Training
Travel and Entertainment |  | 411 | 0 | 123
Repair & Maintenance |  | 6488 | 0 | 1259
Supplies |  | 8086 | 0 | 2435
Professional / Contracted Services |  | 3484 | 0 | 2949
Non-capital purchases |  | 0 | 0 | 0
Utilities
Depreciation |  | 6293 | 0 | 4343
Central pool allocation |  | 1085 | 0 | 6819
BPT transfers |  | 1596 | 0 | 531
SSC CHARGE IN
Rent |  | 1822 | 0 | 2393
Insurance
All Other Expenses |  | 2853 | 0 | 262
Total Expenses |  | 75559 | 0 | 36169
Planned Variances
Scrap |  | 0 | 0 | 0
Obsolescence |  | 3678 | 0 | 0
Other ([NAME])
Other ([NAME])
Total Variances |  | 3678 | 0 | 0
FY11 Reest (LC)
Prelim FY12 FX Rates |  | 4.3 | 4.3 | 4.3
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) |  | 24263 | 957778 | 10457
Indirect Labor (Salaries and Benefits) |  | 8392 | 134760 | 2967
Overtime |  | 5543 | 122152 | 1157
Temporary / Contract Labor |  | 14474 | 336539 | 537
Employee Welfare and Training
Travel and Entertainment |  | 519 | 1599 | 140
Repair & Maintenance |  | 7585 | 41949 | 2259
Supplies |  | 8050 | 300994 | 1201
Professional / Contracted Services |  | 3859 | 302833 | 2432
Non-capital purchases |  | 0 | 0 | 0
Utilities
Depreciation |  | 6345 | 62453 | 3922
Central pool allocation |  | 11127 | 0 | 5077
BPT transfers |  | 2099 | 46684 | 329
SSC CHARGE IN
Rent |  | 2338 | 32812 | 2109
Insurance
All Other Expenses |  | 2767 | 0 | 135
Total Expenses |  | 97361 | 2340553 | 32722
Planned Variances
Scrap |  | 0 | 0 | 0
Obsolescence |  | 0 | 0 | 0
Other ([NAME])
Other ([NAME])
Total Variances |  | 0 | 0 | 0
FY12 Bgt (LC)
Prelim FY12 FX Rates |  | 4.3 | 4.3 | 4.3
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) |  | 18503 | 0 | 33082
Indirect Labor (Salaries and Benefits) |  | 10741 | 0 | 5398
Overtime |  | 3476 | 0 | 5037
Temporary / Contract Labor |  | 6438 | 0 | 4013
Employee Welfare and Training
Travel and Entertainment |  | 759 | 0 | 267
Repair & Maintenance |  | 8270 | 0 | 3704
Supplies |  | 7683 | 0 | 4915
Professional / Contracted Services |  | 5612 | 0 | 4367
Non-capital purchases |  | 0 | 0 | 0
Utilities
Depreciation |  | 5823 | 0 | 9976
Central pool allocation |  | 14509 | 0 | 6621
BPT transfers |  | 2738 | 0 | 428
SSC CHARGE IN
Rent |  | 2356 | 0 | 3922
Insurance
All Other Expenses |  | 2476 | 0 | 995
Total Expenses |  | 89384 | 0 | 82725
Planned Variances
Scrap |  | 0 | 0 | 0
Obsolescence |  | 0 | 0 | 0
Other ([NAME])
Other ([NAME])
Total Variances |  | 0 | 0 | 0
FY10 Actual (USD)
Prelim FY12 FX Rates |  | 4.3 | 4.3 | 4.3
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) | 2069.302325581396 | 420.6976744186047 | 1648.604651162791 | 0
Indirect Labor (Salaries and Benefits) | 2166.744186046512 | 1803.255813953489 | 363.4883720930233 | 0
Overtime | 1293.720930232558 | 864.8837209302326 | 428.8372093023256 | 0
Temporary / Contract Labor | 3211.395348837209 | 2190.46511627907 | 1020.93023255814 | 0
Employee Welfare and Training | 0 | 0 | 0 | 0
Total EE Expenses | 0 | 5279.302325581395 | 3461.860465116279 | 0
Travel and Entertainment | 264.8837209302326 | 123.2558139534884 | 141.6279069767442 | 0
Repair & Maintenance | 2345.348837209302 | 1803.023255813953 | 542.3255813953489 | 0
Supplies | 1834.418604651163 | 1513.255813953489 | 321.1627906976744 | 0
Professional / Contracted Services | 890.232558139535 | 645.3488372093024 | 244.8837209302326 | 0
Non-capital purchases | 0 | 0 | 0 | 0
Utilities | 0 | 0 | 0 | 0
Depreciation | 1445.813953488372 | 1209.06976744186 | 236.7441860465116 | 0
Central pool allocation | 3018.604651162791 | 2177.674418604651 | 840.9302325581396 | 0
BPT transfers | 499.3023255813954 | 424.8837209302326 | 74.4186046511628 | 0
SSC CHARGE IN | 0 | 0 | 0 | 0
Rent | 569.0697674418604 | 390.6976744186047 | 178.3720930232558 | 0
Insurance | 0 | 0 | 0 | 0
All Other Expenses | 499.0697674418605 | 496.046511627907 | 3.023255813953488 | 0
Total Expenses | 0 | 14062.55813953488 | 6045.348837209302 | 0
Planned Variances
Scrap | 0 | 0 | 0 | 0
Obsolescence | 847.4418604651163 | 847.4418604651163 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Total Variances | 0 | 847.4418604651163 | 0 | 0
FY11 Budget (USD)
Prelim FY12 FX Rates |  | 4.3 | 4.3 | 4.3
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) | 2656.511627906977 | 1872.790697674419 | 0 | 783.7209302325582
Indirect Labor (Salaries and Benefits) | 1441.860465116279 | 1261.162790697674 | 0 | 180.6976744186047
Overtime | 1702.325581395349 | 1515.116279069767 | 0 | 187.2093023255814
Temporary / Contract Labor | 0 | 0 | 0 | 0
Employee Welfare and Training | 124.1860465116279 | 95.58139534883722 | 0 | 28.6046511627907
Total EE Expenses | 0 | 4744.651162790698 | 0 | 0
Travel and Entertainment | 1801.627906976744 | 1508.837209302326 | 0 | 292.7906976744186
Repair & Maintenance | 2446.744186046512 | 1880.46511627907 | 0 | 566.2790697674419
Supplies | 1496.046511627907 | 810.232558139535 | 0 | 685.8139534883721
Professional / Contracted Services | 0 | 0 | 0 | 0
Non-capital purchases | 0 | 0 | 0 | 0
Utilities | 2473.488372093023 | 1463.488372093023 | 0 | 1010
Depreciation | 1838.139534883721 | 252.3255813953488 | 0 | 1585.813953488372
Central pool allocation | 494.6511627906977 | 371.1627906976744 | 0 | 123.4883720930233
BPT transfers | 0 | 0 | 0 | 0
SSC CHARGE IN | 980.2325581395348 | 423.7209302325581 | 0 | 556.5116279069767
Rent | 0 | 0 | 0 | 0
Insurance | 724.4186046511628 | 663.4883720930233 | 0 | 60.93023255813954
All Other Expenses | 25983.25581395349 | 17571.86046511628 | 0 | 8411.39534883721
Total Expenses | 0 | 29690.23255813953 | 0 | 0
Planned Variances
Scrap | 855.3488372093024 | 855.3488372093024 | 0 | 0
Obsolescence | 0 | 0 | 0 | 0
Other ([NAME]) | 0 | 0 | 0 | 0
Other ([NAME]) | 855.3488372093024 | 855.3488372093024 | 0 | 0
Total Variances | 0 | 1710.697674418605 | 0 | 0
FY11 Reest (USD)
Prelim FY12 FX Rates |  | 4.3 | 4.3 | 4.3
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) | 29965.58139534884 | 1289.06976744186 | 28407.44186046512 | 269.0697674418604
Indirect Labor (Salaries and Benefits) | 81755.81395348837 | 3366.046511627907 | 78264.88372093023 | 124.8837209302326
Overtime | 0 | 0 | 0 | 0
Temporary / Contract Labor | 525.1162790697675 | 120.6976744186047 | 371.8604651162791 | 32.55813953488372
Employee Welfare and Training | 12044.88372093023 | 1763.953488372093 | 9755.581395348838 | 525.3488372093024
Total EE Expenses | 0 | 6539.767441860466 | 116799.7674418605 | 0
Travel and Entertainment | 72150 | 1872.093023255814 | 69998.6046511628 | 279.3023255813953
Repair & Maintenance | 71889.3023255814 | 897.4418604651163 | 70426.27906976745 | 565.5813953488372
Supplies | 0 | 0 | 0 | 0
Professional / Contracted Services | 0 | 0 | 0 | 0
Non-capital purchases | 16911.62790697674 | 1475.581395348837 | 14523.95348837209 | 912.093023255814
Utilities | 3768.372093023256 | 2587.674418604651 | 0 | 1180.697674418605
Depreciation | 11421.39534883721 | 488.139534883721 | 10856.74418604651 | 76.51162790697674
Central pool allocation | 0 | 0 | 0 | 0
BPT transfers | 8664.883720930233 | 543.7209302325582 | 7630.697674418605 | 490.4651162790698
SSC CHARGE IN | 0 | 0 | 0 | 0
Rent | 674.8837209302326 | 643.4883720930233 | 0 | 31.3953488372093
Insurance | 574566.511627907 | 22642.09302325582 | 544314.6511627907 | 7609.767441860466
All Other Expenses | 0 | 0 | 0 | 0
Total Expenses | 0 | 37690 | 834550.6976744187 | 0
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)
Prelim FY12 FX Rates |  | 4.3 | 4.3 | 4.3
Planned Expenses | Total | [NAME] | Loc2 | Loc3
Direct Labor (Salaries and Benefits) | 2430.46511627907 | 1497.209302325581 | 0 | 933.2558139534884
Indirect Labor (Salaries and Benefits) | 0 | 0 | 0 | 0
Overtime | 238.6046511627907 | 176.5116279069767 | 0 | 62.09302325581395
Temporary / Contract Labor | 2784.651162790698 | 1923.255813953489 | 0 | 861.3953488372093
Employee Welfare and Training | 2929.767441860465 | 1786.744186046512 | 0 | 1143.023255813953
Total EE Expenses | 0 | 5383.720930232558 | 0 | 0
Travel and Entertainment | 2320.697674418605 | 1305.116279069767 | 0 | 1015.581395348837
Repair & Maintenance | 0 | 0 | 0 | 0
Supplies | 0 | 0 | 0 | 0
Professional / Contracted Services | 3674.186046511628 | 1354.186046511628 | 0 | 2320
Non-capital purchases | 4913.953488372093 | 3374.186046511628 | 0 | 1539.767441860465
Utilities | 736.2790697674419 | 636.7441860465117 | 0 | 99.53488372093024
Depreciation | 0 | 0 | 0 | 0
Central pool allocation | 1460 | 547.9069767441861 | 0 | 912.093023255814
BPT transfers | 0 | 0 | 0 | 0
SSC CHARGE IN | 807.2093023255815 | 575.8139534883721 | 0 | 231.3953488372093
Rent | 40025.3488372093 | 20786.97674418605 | 0 | 19238.37209302326
Insurance | 0 | 0 | 0 | 0
All Other Expenses | 0 | 0 | 0 | 0
Total Expenses | 0 | 33964.65116279069 | 0 | 0
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