Att. L-04 - Total Cost Price Build Up spreadsheet.xlsx

Instruction

Per Section L of the solicitation, each Offeror must submit a Cost/Price Calculation Workbook as part of any proposal submission. Each Offeror shall tailor this workbook to suit its estimating methodology, as described below. Each Offeror shall ensure that the information contained in the workbook aligns with and is traceable to the other elements of the Offeror's proposal.

Workbook Functionality Guide

LOE Hour Inputs Tab (CLINs X009, X010, and X014) The tab entitled "LOE Hour Inputs" displays the hours for each level-of-effort CLIN. Offerors shall tailor this tab to show the Offeror's proposed labor labor categories for each CLIN. Each Offeror labor category must be mapped to the Government labor mix categories.

Rates Tabs The tabs entitled "Direct Rates" and "Indirect Rates" allow for input of direct and indirect rates used to price the proposal. The "Rates" tab draws from the "Direct Rates" and "Indirect Rates" tabs to provide the rates in a tabular format that enables use of the INDEX and MATCH functions to call the appropriate rates in the cost model. The Offeror shall tailor these tabs to display the proposed direct and indirect rates.

Resource Codes Tab The "Resource Codes" tab provides supporting metadata for each resource code used in the proposal. The Offeror shall tailor this tab to reflect the resource codes proposed by the Offeror.

Fee & Profit Tab The Offeror shall enter proposed values in the "Fee & Profit" tab for the CLINs listed in the tab.

Cost Model Tab The "Cost Model" tab performs all of the calculations necessary to derive the appropriate direct and indirect costs arising from each of the proposed hours and costs contained in the Inputs tabs by applying the rates contained in the Rates tab. The Offeror shall tailor this tab to calculate the costs for all LOE CLINs (CLINs X009, X010, and X014). The Offeror may add or remove columns as necessary to reflect the actual direct, indirect, and other costs associated with the Offeror's estimating system.

CLIN Summary Tab The CLIN summary tab summarizes the proposed cost, fee/profit, and price by CLIN. This tab also traces the cost model outputs to the proposed Section B values by displaying the rounding functions used to derive the latter. The Offeror shall complete this tab with the information necessary to populate proposed pricing for all of the listed CLINs. The Offeror shall ensure that the proposed Section B values match the calculated values for Section B displayed in this tab.

Stepladder, Periphrial, and Spares Pricing The tabs entitled "Stepladder Pricing + Periphrial" and "Att 4" sheets provide the tables for CLINs X003, X004, X005, X006, X007, X008, and X012. Offerors shall complete the tables for each CLIN.

CLIN Summary

LOE Cost Model

Rates