Attachment_0003_-_Pricing_Matrix.xlsx

Instructions Instructions - Attachment 0003 - Price Matrix

Cells that require inputs are highlighted in yellow.

The required inputs are used to auto calculate the Total Proposed Contract Cost/Price, excluding any cost-realism adjustment(s).

Provide an offeror-formatted spreadsheet that calculates each input in each tab in accordance with Section L.

Labor - OP1, Labor - OP2, Labor - OP3, Labor - OP4, Labor - OP5 Tabs

In each Tab, for each Level of Engineering and Logistics (i.e. I, II, and III), the offeror must input an Estimated Cost per hour and Fixed Fee per hour.

In each Tab, for the CONUS FSR and OCONUS FSR labor categories, the offeror must input an Estimated Cost per hour and Fixed Fee per hour.

In each Tab, regarding the Engineering and Logistics labor categories, the attachment automatically calculates a composite Estimated Cost per hour and a composite Fixed Fee per hour. The composite Estimated Cost per hour is calculated by (1) multiplying the proposed Estimated Cost per hour for each Level (i.e. I, II, and III) by the associated labor hours for that level; (2) summing the result; and then (3) dividing this result by the total labor hours for that labor category (i.e. Engineering or Logistics). The composite Fixed Fee per hour is calculated by (1) multiplying the proposed Fixed Fee per hour for each level (i.e. I, II, and III) by the associated labor hours for that level; (2) summing the result; and then (3) dividing this result by the total labor hours for that labor category (i.e. Engineering or Logistics).

The Fully-Burdened Hourly Rate for each labor category (i.e. Engineering or Logistics) equals the composite Estimated Cost per hour plus the composite Fixed Fee per hour.

In each Tab, for each CONUS FSR and OCONUS FSR labor category, the Fully-Burdened Hourly Rate equals the proposed Estimated Cost per hour plus the proposed Fixed Fee per hour.

In each Tab, for each labor category, the Extended Price equals the Fully-Burdened Hourly Rate multiplied by the total labor hours for that labor category.

Material ODC Travel - OP1-OP5 Tab

The plug numbers for Material / Travel / ODC provided by the Government are included. Input any proposed indirect costs (such as overhead, G&A) in accordance with Section L. If the offeror fails to propose any indirect costs to the ODCs, it shall not be allowed to charge indirect costs applied to ODCs if selected for award.

For each ordering period, the Extended Price equals the Government provided Material / Travel / ODC plug number plus the proposed indirect cost (if any).

Task Order 1 Tab

The offeror must input the amount for Travel (and indirect cost if applicable) associated with Task Order 1. Further instruction is included in the "Task Order 1" tab.

Detail Tab

The Detail Tab requires no inputs.

Summary Tab

The Summary Tab requires no inputs.

Summary

Detail

Logistics - OP1 $ - 0 $ - 0 36,671 $ - 0 $ - 0 $ - 0

CONUS FSR - OP1 $ - 0 $ - 0 10,477 $ - 0 $ - 0 $ - 0

OCONUS FSR - OP1 $ - 0 $ - 0 5,238 $ - 0 $ - 0 $ - 0

MATERIAL / ODC / TRAVEL - OP1 $ 1,768,207.00

Engineering - OP2 $ - 0 $ - 0 52,459 $ - 0 $ - 0 $ - 0

Logistics - OP2 $ - 0 $ - 0 36,720 $ - 0 $ - 0 $ - 0

CONUS FSR - OP2 $ - 0 $ - 0 10,492 $ - 0 $ - 0 $ - 0

OCONUS FSR - OP2 $ - 0 $ - 0 5,247 $ - 0 $ - 0 $ - 0

MATERIAL / ODC / TRAVEL - OP2 $ 1,820,356.00

Engineering - OP3 $ - 0 $ - 0 52,456 $ - 0 $ - 0 $ - 0

Logistics - OP3 $ - 0 $ - 0 36,720 $ - 0 $ - 0 $ - 0

CONUS FSR - OP3 $ - 0 $ - 0 10,491 $ - 0 $ - 0 $ - 0

OCONUS FSR - OP3 $ - 0 $ - 0 5,247 $ - 0 $ - 0 $ - 0

MATERIAL / ODC / TRAVEL - OP3 $ 1,874,012.00

Engineering - OP4 $ - 0 $ - 0 52,576 $ - 0 $ - 0 $ - 0

Logistics - OP4 $ - 0 $ - 0 36,804 $ - 0 $ - 0 $ - 0

CONUS FSR - OP4 $ - 0 $ - 0 10,515 $ - 0 $ - 0 $ - 0

OCONUS FSR - OP4 $ - 0 $ - 0 5,259 $ - 0 $ - 0 $ - 0

MATERIAL / ODC / TRAVEL - OP4 $ 1,934,472.00

Engineering - OP5 $ - 0 $ - 0 52,576 $ - 0 $ - 0 $ - 0

Logistics - OP5 $ - 0 $ - 0 36,804 $ - 0 $ - 0 $ - 0

CONUS FSR - OP5 $ - 0 $ - 0 10,515 $ - 0 $ - 0 $ - 0

OCONUS FSR - OP5 $ - 0 $ - 0 5,259 $ - 0 $ - 0 $ - 0

MATERIAL / ODC / TRAVEL - OP5 $ 1,985,929.00

TOTAL PROPOSED LABOR, EXCLUDING ANY COST-REALISM ADJUSTMENT(S) $ - 0

TOTAL PROPOSED MATERIAL/ODC/TRAVEL, EXCLUDING ANY COST-REALISM ADJUSTMENT(S) $ 9,382,976.00

TOTAL PROPOSED CONTRACT COST/PRICE, EXCLUDING ANY COST-REALISM ADJUSTMENT(S) $ 9,382,976.00

Labor - OP1

ENGINEERING OP1 52,387 $ - 0 $ - 0 $ - 0 $ - 0

LOGISTICS OP1 36,671 $ - 0 $ - 0 $ - 0 $ - 0

CONUS FSR OP1 10,477 $ - 0 $ - 0 $ - 0 $ - 0

Labor - OP2

ENGINEERING OP2 52,459 $ - 0 $ - 0 $ - 0 $ - 0

LOGISTICS OP2 36,720 $ - 0 $ - 0 $ - 0 $ - 0

CONUS FSR OP2 10,492 $ - 0 $ - 0 $ - 0 $ - 0

Labor - OP3

ENGINEERING OP3 52,456 $ - 0 $ - 0 $ - 0 $ - 0

LOGISTICS OP3 36,720 $ - 0 $ - 0 $ - 0 $ - 0

CONUS FSR OP3 10,491 $ - 0 $ - 0 $ - 0 $ - 0

Labor - OP4

ENGINEERING OP4 52,576 $ - 0 $ - 0 $ - 0 $ - 0

LOGISTICS OP4 36,804 $ - 0 $ - 0 $ - 0 $ - 0

CONUS FSR OP4 10,515 $ - 0 $ - 0 $ - 0 $ - 0

Labor - OP5

ENGINEERING OP5 52,576 $ - 0 $ - 0 $ - 0 $ - 0

LOGISTICS OP5 36,804 $ - 0 $ - 0 $ - 0 $ - 0

CONUS FSR OP5 10,515 $ - 0 $ - 0 $ - 0 $ - 0

Material ODC Travel - OP1-OP5

Task Order 1

ENGINEERING OP1 32 $ - 0 $ - 0 $ - 0 $ - 0

LOGISTICS OP1 32 $ - 0 $ - 0 $ - 0 $ - 0

TOTAL Task Order 1 64 $ - 0

Instruction: In accordance with Section L.4.2.5.1.a, If program management is treated as an indirect cost additional labor hours shall not be input in cells B3 or B10. If program management is treated as a direct cost, then the offeror shall propose labor hours accordingly. TOTAL Task Order 1 hours in Cell B21 shall not exceed 128 (Example: 32 hours Lead Engineer, 32 hours Lead Logistician, 32 hours CEO (Program Management), 32 hours Project Manager (Program Management)).