Attachment 2 - Pricing Template.xlsx

Instructions Disclaimer: Unless stated elsewhere, this pricing template workbook MAY be tailored; however, the general structure and content of the worksheets should remain intact. Additional worksheets may be added at the offeror's discretion. Note that some modifications could result in calculation errors on worksheets referencing cell values, formulas, etc. on other worksheets. The burden of ensuring the information contained and submitted in this workbook is complete, accurate and free of errors rests with the offeror.

Back to Overall_Summary Worksheet Back to CLIN_Summary Worksheet Back to Labor Summary Worksheet Back to Lookup Tables Worksheet Back to Indirect_Rates Worksheet Back to Labor_Rates Worksheet Back to Labor Worksheet Back to Material Worksheet Back to Travel Worksheet Back to DSSR Worksheet

LABOR_RATES WORKSHEET INSTRUCTIONS

This worksheet lists PWS task/functions and contractor proposed labor categories and associated direct and fully burdened labor rates by performance period.

Notes: Complete the "Labor Indirect (Wrap Rate) Multipliers" table in the "Indirect_Rates" worksheet before editing this worksheet. Fully burdened labor rates are calculated based on the values in that worksheet. Each row must have a unique LCAT ID number.

General:

Enter annual labor escalation rates for option years in the corresponding cells at the top of the table, if applicable.

Do NOT edit values in the LCAT_ID, PWS, PWS_LCAT, Site columns, if Government provided.

Enter contractor's proposed labor categories in the Contractor_LCAT column, mapped to the corresponding equivalent PWS Task Description.

Unused levels may be left blank, but do not delete the rows.

Note: The PWS_LCAT entries refer to PWS functional requirement/task titles.

Select "Yes" in the Key Personnel column if the labor category is a proposed key position; otherwise, leave blank.

Select the burden pool for each labor category.

Enter direct (unburdened) labor rate for each Contractor_LCAT in the DirectLabor0 column. By default, option period direct labor rates (DirectLabor1, DirectLabor2, DirectLabor3 and DirectLabor4 ) will calculate based on their corresponding escalation rate. Validate/update entries as required.

By default, fully burdened labor rates (the Burdened0, Burdened1, Burdened2, Burdened3, Burdened4 values) will calculate based on the labor wrap rate multiplier for the burden pool selected. Validate/update entries as required.

Enter remarks in the Notes column.

Default formulas: (Modify and/or correct formulas as required.)

• DirectLabor0 = Manual entry (Enter proposed Direct Labor Rates for each labor category in this column.)

• Burdened0 = DirectLabor0 * Wrap Rate Multiplier for the selected burden pool

• DirectLabor1 = DirectLabor0 * Escalation Rate

• Burdened1 = DirectLabor1 * Wrap Rate Multiplier for the selected burden pool

• DirectLabor2 = DirectLabor1 * Escalation Rate

• Burdened2 = Direct Labor2 * Wrap Rate Multiplier for the selected burden pool

• DirectLabor3 = DirectLabor2 * Escalation Rate

• Burdened3 = DirectLabor3 * Wrap Rate Multiplier for the selected burden pool

• DirectLabor4 = DirectLabor3 * Escalation Rate

• Burdened4 = DirectLabor4 * Wrap Rate Multiplier for the selected burden pool

(Note: OT_Burdened0, OT_Burdened1, OT_Burdened2, OT_Burdened3 and OT_Burdened4 columns are cleared of any values and hidden. These columns are not applicable based on this task order's solication instructions and/or CLIN structure.

TRAVEL WORKSHEET INSTRUCTIONS

This worksheet is lists estimated/proposed Travel by performance period.

Notes: Ensure indirect multiplier and profit or fee rates are updated and accurate on the "Indirect_Rates" worksheet before entering data on this worksheet. For the Transition period, any Travel will be included in the Transition CLIN. For the Base Period and all Optional Periods Travel will be Cost Reimbursable no Fee. Every row within each table must have a unique Item number.

TIP: Ensure the Base and Option Periods have the exact same number of rows and Item numbering scheme. Default formulas in the Option periods copy the values of the preceding periods. Only units, quantities and unit costs need to be verified/updated, if necessary.

Data Entry:

Enter estimated travel costs for each period of performance, unless plug figures are provided. Do not edit or adjust any plug figures.

Enter, edit and or verify Indirect Multiplier and Profit rates for each performance period.

Enter any comments or basis of estimate in the Notes column).

Unused columns may be hidden, but not deleted.

Additional rows may be added at the bottom of each table, if required. (In the last Item number, right click, and then select Insert, Table Row Below.)

Ensure each row and period of performance total accurately reflects the offeror's price proposal.

Default formulas: (Modify/correct the formulas, as necessary.)

• Extended Cost = (Travelers * Trips * Airfare) + (Travelers * Trips * Duration * Rental Car) + (Travelers * Trips * Misc.) + (Travelers * Trips * (Duration - 1) *Lodging) + (Travelers * Trips * Duration * M&IE)

• Indirect Cost = Extended Cost * Indirect Multiplier %

• Subtotal = Extended Cost + Indirect Cost

• Profit or Fee = Subtotal * Profit or Fee Rate %

• Total = Subtotal + Profit or Fee

Extended Cost Formula Text:

=([@Travelers]*[@Trips]*([@Airfare]))+ ([@Travelers]*[@Trips]*[@[Duration ]]*[@[Rental Car]])+ ([@Travelers]*[@Trips]*[@[Misc.]])+ ([@Travelers]*[@Trips]*IF([@[Duration ]]>1,[@[Duration ]]-1,[@[Duration ]])*[@Lodging])+ ([@Travelers]*[@Trips]*IF([@[Duration ]]<=2,[@[Duration ]]*[@[M&IE]]*0.75,([@[Duration ]]*[@[M&IE]])-(2*[@[M&IE]]*0.25)))

(Note: For travel days (the first and last day of trip) meals and incidental expenses (M&IE) is calculated at .75 the allowable rate.)

LABOR WORKSHEET INSTRUCTIONS

This worksheet lists Labor cost/price.

Notes: Complete the "LaborRates" worksheet before editing this worksheet. Labor category direct and fully burdened labor rates are calculated based on the values in that worksheet. Each row on each table must have a unique Item number.

TIP: Ensure the Base and Option Periods have the exact same number of rows and Item numbering scheme. Default formulas in the Option periods copy the values of the preceding periods. Only the FTEs and Hours need to be verified/updated, if necessary.

Data Entry:

If values in LCAT ID through PWS Task/Function columns are government provided and prepopulated, do NOT modify.

Enter the number of FTEs, base or straight time hours per FTE in the appropriate columns for each performance period.

Validate and update totals, as required.

Enter remarks in the Notes column.

Unused columns/rows may be hidden, but not deleted.

Additional rows may be added at the bottom of each table, if required. (In the last Item number, right click, and then select Insert, Table Row Below.)

Ensure each row and period of performance total accurately reflects the offeror's price proposal.

Default formulas: (Modify and/or correct formulas as required.)

• ST Hours Total = # FTEs * ST Hours Per FTE

• ST Subtotal = ST Hours Total * ST Rate Burdened

• OT Hours Total = # FTEs * OT Hours Per FTE. (Column is hidden)

• OT Subtotal =OT Hours Total * OT Rate Burdened. (Column is hidden)

• Total = ST Subtotal + OT Subtotal

• Total Hours = ST Hours Total + OT Hours Total (Column is hidden)

INDIRECT_RATES INSTRUCTIONS

Worksheet contains a list of indirect and profit or fee rates, and wrap rate multipliers applied to direct costs (Labor, ODCs, Travel, etc.) by performance period.

Notes: Complete this worksheet before Labor_Rates, Labor, Matierial, Travel and other worksheets. In this template, rates/multipliers for option periods are the same as the preceding period's by default. Modify the values/formulas as required.

Indirect and Profit or Fee Rates Table: Lists all applicable indirect and profit (or fee) rates.

• Enter all applicable indirect, profit and fee rates and for each performance period in the Rate through Option4 columns, and provide descriptions in the Notes column.

• Unused rows may be left blank, or filtered and hidden, but do NOT delete.

• Enter additional user defined rows as required.

Labor Indirect (Wrap Rate) Multipliers: Lists the indirect (wrap rate) multipliers for each labor burden pool. (These values are referenced on the LaborRates worksheet.)

• Enter the fully burdened labor wrap rate multiplier (or replace template's default formula) each labor burden pool and performance period. These wrap rates shall include applicable profit or fee, if applicable.

• If wrap rates are manually entered describe the allocation bases, buildups and formulas in the notes, basis of estimate or separately price volume narrative. (The template's default formulas are described below.)

• Unused rows may be left blank, filtered and hidden, but do NOT delete.

Non-Labor Indirect (Wrap Rate) Multipliers: Lists the indirect (wrap rate) multipliers for non-labor costs. (These values are referenced on Material and Travel worksheets.)

• Enter the wrap rate multiplier for (or a formula for calculating) each non-labor cost (Matierial, Travel, etc..), by performance period.

• Do NOT include profit or fee, as it is calculated separately on the respective worksheets, if applicable.

Labor Wrap Rate Example (For illustrative purposes only.)

Fully burdened labor wrap rate: Allocation base + Fringe Cost + Overhead Cost + G&A Cost + Profit Example Formula Build-up:

• Labor Cost (allocation base) = Direct Labor, or = 1 (...or 100%)

• Fringe Cost = Direct Labor Cost * Fringe Rate, or = (1 * Fringe Rate)

• Overhead Cost = (Direct Labor Cost + Fringe Cost) * Overhead Rate , or = ((1 + (1 * Fringe Rate)) * Overhead Rate)

• G&A Cost = (Direct Labor Cost + Fringe Cost + Overhead Cost) * G&A Rate , or = ((1 + (1 * Fringe Rate)+((1 + (1 * Fringe Rate)) * Overhead Rate)) * G&A Rate)

• Profit = (Direct Labor Cost + Fringe Cost + Overhead Cost + G&A Cost) * Profit Rate, or = ((1 + (1 * Fringe Rate) + ((1 + (1 * Fringe Rate))*Overhead Rate) + ((1 + (1 * Fringe Rate)+((1 + (1 * Fringe Rate)) * Overhead Rate)) * G&A Rate)) * Profit Rate) Default Labor Pool1 Wrap Rate Formula Text (Cell C35):

=ROUND(100% + (100%*C6) + ((100% +(100% *C6))*C11)+ ((100% +(100% *C6)+((100% +(100% *C6))*C11))*C$21) + ((100% +(100% *C6)+((100% +(100% *C6))*C11)+((100% +( 100% *C6)+(( 100% +( 100% *C6))*C11))*C$21))*C$22),4) In the example formula above, 100% represents labor allocation base. C$21 (G&A) and C$22 (Profit) represent static row references. Results are rounded 4 places (0.0000)

MATERIAL WORKSHEET INSTRUCTIONS

This worksheet lists estimated/proposed Material related costs by performance period.

Notes: Ensure indirect multiplier and profit or fee rates are updated and accurate on the "Indirect_Rates" worksheet before entering data on this worksheet. For the Transition period, ODCs will be included in the FFP Transition CLIN.

TIP: Ensure the Base and Option Periods have the exact same number of rows and Item numbering scheme. Default formulas in the Option periods copy the values of the preceding periods. Only units, quantities and unit costs need to be verified/updated, if necessary.

Data Entry:

Enter estimated Materials for each period of performance, unless plug figures are provided. Do not edit or adjust plug figures. Do not edit in PWS through Qty columns, if Government provided.

Enter, edit and/or verify formulas for calculating extended costs, indirect costs, subtotals, profit or fee and total (Extended Cost through Total columns).

Enter/edit comments or a basis of estimate in the Notes column.

Unused columns may be hidden, but not deleted.

Additional rows may be added at the bottom of each table, if required. (In the last Item number, right click, and then select Insert, Table Row Below.)

Ensure each row and period of performance total accurately reflects the offeror's price proposal.

Default formulas: (Modify/correct the formulas, as necessary.)

• Extended Cost = Qty * Unit Cost (Note: If unit is a number, Extended Cost = Unit * Qty * Unit Cost)

• Indirect Cost = Extended Cost * Indirect Multiplier % [Note: Rounded 2 places by default]

• Subtotal = Extended Cost + Indirect Cost

• Profit or Fee = Subtotal * Profit or Fee Rate % [Note: Rounded 2 places by default]

• Total = Subtotal + Profit or Fee

OVERALL SUMMARY WORKSHEET

Worksheet summarizes the task order overall price/cost proposal. (See the CLIN summary sheet for the anticipated CLIN structure and cost/price breakout by CLIN.)

Notes: The summary worksheets sum data from the Labor, Matirial and Travel and other pricing worksheet entries.

Ensure the individual pricing worksheets are complete and accurate before entering/editing the data on the summary worksheets.

Contract Information:

Enter contract/solicitation number, program/contract title and requiring activity from the solicitation, if not provided.

Company Information:

Enter company name and address, and the document name, version and date.

Periods of Performance:

Enter the task order period of performance dates from the solicitation, if not provided.

Price/Cost Summary:

Summarizes proposal costs/price by element and performance period.

Validate the Transition, Labor, Materials and Travel for each performance period.

Verify accuracy of any default formulas, calculations, cell references, etc., and make corrections as required.

Do NOT adjust estimated NTE Material, Travel or Overtime plug figures on the summary or individual worksheets, if provided by the Government.

Total Overall Evaluated Price:

Validate the TOEP.

Comments:

Enter notes and/or summary of revisions, as required.

CLIN_SUMMARY WORKSHEET

This worksheet summarizes the estimated/proposed costs by CLIN and performance period.

Notes: The Total Overal Evaluated Price (TOEP) value on this worksheet should equal the TOEP on the Overall_Summary worksheet. If these totals do not match, ensure the correct CLIN(s) are selected for each entry on the Labor, Material and Travel worksheets, as applicable.

The anticipated CLIN structure is Government provided. Do NOT modify.

Ensure the Labor, Materials and Travel and other worksheets (if applicable) are complete. Values are automatically calculated based on data in those worksheets.

Manual input on this worksheet should not be required.

Materials is borken out under a seperate CLIN (e.g., equipment, supplies, licenses) Travel is broken out under a separate CLIN (e.g., DBA, passports, visas, medical, DSSR, equipment shipping, etc.)

Overtime for CONUS/OCONUS overtime support are combined under a single CLIN.

LookupTables Worksheet

Worksheet contains the pulldown lists used in other worksheets for cell data validation and integrity.

Note: Validate/update entries in Column B of each table on this worksheet before completing other worksheets within this workbook.

• Performance Sites: Government provided. Do not modify. Lists names and descriptions of performance locations. (Referenced on Labor Rates and Labor worksheets.

• Burden Pools: Lists names and descriptions for labor burden pools. Enter or edit pool names and descriptions as required. (Referenced on the Indirect Rates and Labor Rates worksheets.)

• PWS Task/Function References: Government provided. Do not modify. Lists PWS paragraph numbers and task/function descriptions for all tasks to be proposed and priced. (Referenced on CLIN and Task Summary, Labor Rates, Labor and other worksheets.)

• CLINs: Government provided. Do not modify. Lists contract CLINs and descriptions. (Referenced on Overall Summary, CLIN Summary, Labor, and other worksheets.)

DSSR WORKSHEET INSTRUTIONS

This worksheet lists estimated/proposed DSSR costs by performance period.

Notes: Ensure indirect multiplier and profit or fee rates are updated and accurate on the "Indirect_Rates" worksheet before entering data on this worksheet. For the Transition period, DSSR will be included in the Transition CLIN. For the Base Period and all Optional Periods, DSSR will be Cost Reimbursable no Fee.

TIP: Ensure the Base and Option Periods have the exact same number of rows and Item numbering scheme. Default formulas in the Option periods copy the values of the preceding periods. Only units, quantities and unit costs need to be verified/updated, if necessary.

Data Entry:

Enter estimated DSSR for each period of performance, unless plug figures are provided. Do not edit or adjust plug figures.

Offerors may enter build up DSSRs costs by entering a Description, Category, Unit, Unit Cost for each estimated DSSR differential/allowance, OR enter a total directly into the Extended Cost cell and provide the basis of estimate and detailed breakdown in their narrative cost/price volume.

Verify/update Indirect Multiplier and profit or fee rate for the each performance period.

Every row within each table must have a unique Item number.

Do not edit in PWS through Qty columns, if Government provided.

Enter, edit and/or verify formulas for calculating extended costs, indirect costs, subtotals, profit or fee and total (Extended Cost through Total columns).

Enter/edit comments or a basis of estimate in the Notes column.

Unused columns may be hidden, but not deleted.

Additional rows may be added at the bottom of each table, if required. (In the last Item number, right click, and then select Insert, Table Row Below.)

Ensure each row and period of performance total accurately reflects the offeror's price proposal.

Default formulas:

Extended Cost = Qty * Unit Cost (Note: If unit is a number, Extended Cost = Unit * Qty * Unit Cost) Indirect Cost = Extended Cost * Indirect Multiplier % Subtotal = Extended Cost + Indirect Cost Profit or Fee = Subtotal * Profit or Fee Rate % Total = Subtotal + Profit or Fee

Overall_Summary

&F &A &P of &N

CLIN_Summary

&F &A &P of &N

Labor_Summary

Price

&F &A &P of &N

Labor_Summary Worksheet

This worksheet summarizes the offeror's proposed labor (FTEs, hours, and Price) by the PWS task(s) and performance period.

PWS task numbers are Government provided. Do NOT modify.

Ensure the Labor_CONUS, Labor_OCONUS worksheets are complete. Values are automatically calculated based on data in those worksheets.

Manual input on this worksheet should not be required.

Note: Base and Option period amounts in the Totals table should be equal to the corresponding totals on the Overall_Summary worksheet. If these totals do not match, ensure the correct PWS references are selected for each entry on the Labor worksheet.

Lookup_Tables

Indirect_Rates

Labor_Rates

Direct & Fully Burdened Rates

Labor

Transition Period - Labor (CONUS)

Base Period - Labor (CONUS)

Option Period 1 - Labor (CONUS)

Option Period 2 - Labor (CONUS)

Option Period 3 - Labor (CONUS)