Spreadsheet: 112267d1308382506-lookup-with-index-and-match-look-up-spreadsheet
Sheet: Page 1

Project:   11111.0.200.00.000 |  | Status:                    Active | Contract Value Fee: | 0.00 | Billed Amount: 0
Project Name:  ABC
Subcontract No: |  | Rate Type: Target | EAC (for FP only): | N/A
Account Name |  | Prior Year  Actual | Current Period  Actual | Year To Date  Actual | Contract To Date  Actual
Revenue | 3434 | 3434 | 3434 | 3434 | 3434
 | 3434 | 3434 | 3434 | 3434 | 3434
Direct Labor - Field | 3434 | 3434 | 3434 | 3434 | 3434
Direct Labor - H&B | 3434 | 3434 | 3434 | 3434 | 3434
Direct Labor Mid H&B | 3434 | 3434 | 3434 | 3434 | 3434
Direct Labor-Field Casual | 3434 | 3434 | 3434 | 3434 | 3434
Total Labor Cost, $: | 3434 | 3434 | 3434 | 3434 | 3434
Freight & Delivery | 3434 | 3434 | 3434 | 3434 | 3434
Office & Field Supplies | 3434 | 3434 | 3434 | 3434 | 3434
Subcontractor Expenses | 3434 | 3434 | 3434 | 3434 | 3434
Telephone | 3434 | 3434 | 3434 | 3434 | 3434
Travel & Entertainment | 3434 | 3434 | 3434 | 3434 | 3434
Total Non-Labor Cost, $: | 3434 | 3434 | 3434 | 3434 | 3434
[NAME] | 3434 | 3434 | 3434 | 3434 | 3434
Field & Field Casual OH | 3434 | 3434 | 3434 | 3434 | 3434
Full Fringe | 3434 | 3434 | 3434 | 3434 | 3434
General & Administrative | 3434 | 3434 | 3434 | 3434 | 3434
Home & Branch OH | 3434 | 3434 | 3434 | 3434 | 3434
Strategic Mid H&B OH | 3434 | 3434 | 3434 | 3434 | 3434
Total Indirect Cost, $:
Total Expense, $: |  |  |  |  | 758481.86
Profit, $: |  |  |  |  | 0
Profit %: |  |  |  |  | 0.00
Project:   22222.0.200.10.000 |  | Status:                    Active | Contract Value Fee: | 0.00 | Billed Amount: 0
Subcontract No: |  | Rate Type: Target | EAC (for FP only): | N/A
Account Name |  | Prior Year  Actual | Current Period  Actual | Year To Date  Actual | Contract To Date  Actual
Revenue
Direct Labor - Field | 3434 | 3434 | 3434 | 3434 | 3434
Direct Labor - H&B | 3434 | 3434 | 3434 | 3434 | 3434
Direct Labor-Field Casual | 3434 | 3434 | 3434 | 3434 | 3434
Total Labor Cost, $: | 3434 | 3434 | 3434 | 3434 | 3434
Telephone | 3434 | 3434 | 3434 | 3434 | 3434
Travel & Entertainment | 3434 | 3434 | 3434 | 3434 | 3434
Total Non-Labor Cost, $: | 3434 | 3434 | 3434 | 3434 | 3434
Field & Field Casual OH | 3434 | 3434 | 3434 | 3434 | 3434
Full Fringe | 3434 | 3434 | 3434 | 3434 | 3434
General & Administrative | 3434 | 3434 | 3434 | 3434 | 3434
Home & Branch OH | 3434 | 3434 | 3434 | 3434 | 3434
Total Indirect Cost, $: | 3434 | 3434 | 3434 | 3434 | 3434
Total Expense, $: |  |  |  |  | 11671.38
Profit, $: |  |  |  |  | 0
Profit %: |  |  |  |  | 0.00
Project:   33333.0.200.20.000 |  | Status:                    Active | Contract Value Fee: | 0.00 | Billed Amount: 0
Project Name:  ACD
Subcontract No: |  | Rate Type: Target | EAC (for FP only): | N/A
Account Name |  | Prior Year  Actual | Current Period  Actual | Year To Date  Actual | Contract To Date  Actual
Revenue
Direct Labor - Field | 3434 | 3434 | 3434 | 3434 | 3434
Direct Labor - H&B | 3434 | 3434 | 3434 | 3434 | 3434
Direct Labor Mid H&B | 3434 | 3434 | 3434 | 3434 | 3434
Direct Labor-Field Casual | 3434 | 3434 | 3434 | 3434 | 3434
Total Labor Cost, $: | 3434 | 3434 | 3434 | 3434 | 3434
Freight & Delivery | 3434 | 3434 | 3434 | 3434 | 3434
Office & Field Supplies | 3434 | 3434 | 3434 | 3434 | 3434
Reproduction | 3434 | 3434 | 3434 | 3434 | 3434
Subcontractor Expenses | 3434 | 3434 | 3434 | 3434 | 3434
Telephone | 3434 | 3434 | 3434 | 3434 | 3434
Travel & Entertainment | 3434 | 3434 | 3434 | 3434 | 3434
Total Non-Labor Cost, $: | 3434 | 3434 | 3434 | 3434 | 3434
[NAME] | 3434 | 3434 | 3434 | 3434 | 3434
Field & Field Casual OH | 3434 | 3434 | 3434 | 3434 | 3434
Full Fringe | 3434 | 3434 | 3434 | 3434 | 3434
General & Administrative | 3434 | 3434 | 3434 | 3434 | 3434
Home & Branch OH | 3434 | 3434 | 3434 | 3434 | 3434
Strategic Mid H&B OH | 3434 | 3434 | 3434 | 3434 | 3434
Sub Admin | 3434 | 3434 | 3434 | 3434 | 3434
Total Indirect Cost, $:
Total Expense, $: |  |  |  |  | 624717.86
Profit, $:
Profit %: