A07_Att_0003_Cost_Model_W91CRB-19-R-5025.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
Field Service Representatives (FSR) Afghanistan OCONUS
Solicitation number
W91CRB19R5025
Issued by

About this file

A07 Att 0003 Cost Model W91CRB-19-R-5025

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

INSTRUCTIONS

INSTRUCTIONS

SECTION B

SECTION B - SUPPLIES OR SERVICES & PRICES
Solicitation # W91CRB-19-R-5025
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0001Team Lead1EA
FFP
Total =$ - 0From Labor Detail and ODC Summary Worksheets
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0002Field Serice RepresentativeEA
FFP
$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0002AAExpatriate Raid Tower & TIF 25K7EA
FFP
Total =$ - 0From Labor Detail and ODC Summary Worksheets
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0002ABExpatriate Wolfhound3EA
FFP
Total =$ - 0From Labor Detail and ODC Summary Worksheets
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0002ACExpatriate RAID Tower and TIF-25K power generator2EA
FFP
Total =$ - 0From Labor Detail and ODC Summary Worksheets
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0003Logistician1EA
FFP
Total =$ - 0From Labor Detail and ODC Summary Worksheets
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0004Technical Writer1EA
FFP
Total =$ - 0From Labor Detail and ODC Summary Worksheets
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0005Administrative Support1EA
FFP
Total =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0006Interpreters2EA
FFP
Total =$ - 0From Labor Detail and ODC Summary Worksheets
CLINSUPPLIES/SERVICESQUANTITYUNITAMOUNT
0007Maintenance and Supply Services40EA
FFP
Total =$ - 0From Labor Detail and ODC Summary Worksheets
TOTAL$ - 0Sum of all CLINS
DOUBLE CHECK NUMBER (Labor Detail worksheets + ODC worksheet)

&F, &A

PAGE &P OF &N

Labor-Detail

Labor - Cost Detail Spreadsheet
Solicitation No. W91CRB-19-R-5025COST DETAIL
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
0.00%0.00%0.00%
POSITON TITLESFTEs (Note 1)Annual Productive HoursTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor(s)Hourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Fee (Note 5)Total Prime & Sub Labor Before Prime G&A & FeeG&ASubtotalFeeTotalTotal Burdened Rate Including Profit
abcd=b X cefghij = d X ikl = j + kmn=l + mo = n/d
Team Lead10Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Expatriate certified RAID Tower and TIF-25K FSR70Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Expatriate certified RAID Tower and TIF-25K power generator FSR20Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Expatriate certified RAID Tower and TIF-25K logistician10Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Expatriate certified RAID Tower and TIF-25K technical writer10Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Expatriate certified RAID Tower and TIF-25K administrative support10Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Interpreter20Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Expatriate certified RAID Tower and TIF-25K maintenance and supply support facility personnel400Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Expatriate Wolfhound FSRs30Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
580$ - 0$ - 0$ - 0

* = Include OCONUS Allowances as applicable. Include DBA Insurance in the direct rate or indirect as applicable per the offeror's accounting system.

Total Burdened Price less ProfitFeeTotal
TOTAL LABOR$ - 0$ - 0$ - 0

&F, &A

PAGE &P OF &N

ODC - Cost Summary

ODC Cost Detail Spreadsheet
Solicitation # W91CRB-19-R-5025
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
ODC COST DETAIL
CLINODCs (Note 6)Matl Handling/G&A RateMatl Handling/ G&A $Total ODC Price
abcd = b X cf = b + d
CLIN 0001$ - 00.00%$ - 0$ - 0Provide a schedule and narrative for ODC/travel basis of estimate
CLIN 0002$ - 0
CLIN 0002AA$ - 00.00%$ - 0$ - 0Provide a schedule and narrative for ODC/travel basis of estimate
CLIN 0002AB$ - 00.00%$ - 0$ - 0Provide a schedule and narrative for ODC/travel basis of estimate
CLIN 0002AC$ - 00.00%$ - 0$ - 0Provide a schedule and narrative for ODC/travel basis of estimate
CLIN 0003$ - 00.00%$ - 0$ - 0Provide a schedule and narrative for ODC/travel basis of estimate
CLIN 0004$ - 00.00%$ - 0$ - 0Provide a schedule and narrative for ODC/travel basis of estimate
CLIN 0005$ - 00.00%$ - 0$ - 0Provide a schedule and narrative for ODC/travel basis of estimate
CLIN 0006$ - 00.00%$ - 0$ - 0Provide a schedule and narrative for ODC/travel basis of estimate
CLIN 0007$ - 00.00%$ - 0$ - 0Provide a schedule and narrative for ODC/travel basis of estimate
Total$ - 0$ - 0$ - 0
(To Section B)

Microsoft_Word_Document1.docx General: Offeror is to provide a cost/price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed enclosed spreadsheets shall be part of the cost/price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for acceptability, fairness, and reasonableness based on the cost/price analysis criteria in FAR 15.404-1. Please enter the requested data in the light blue shaded areas in the Labor-Detail spreadsheets and in the ODC Summary spreadsheet. The spreadsheets are designed to automatically compute and populate other cells in the Excel spreadsheets and workbooks.

Section B Worksheet: The Section B worksheet imports data from the Labor-Detail Spreadsheets and ODC – Cost Summary spreadsheet and is used as a basis for the proposed formal Section B.

Cost Summary Worksheet: N/A

Labor-Cost Detail Worksheet:

General: There is a separate Labor-Detail worksheet for each Country location. Enter the requested data in the blue shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect differences or nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes.

NOTE 1: FTE = full time equivalent. Offeror is to input their proposed labor categories and number of productive hours in the spreadsheet.

NOTE 2: Column a of the Labor- Detail Spreadsheets contains labor categories. During contract performance these categories ostensibly may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a P in Col e if the effort is to be performed by the prime contractor, and a S if performed by another division or subcontractor. Enter the name of the division or contractor in Col f. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the Col d hours for the individual category among the Col d cells in the original and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours proposed for the respective labor category.

NOTE 3: Please enter the base labor rate for the labor categories listed. The base labor rate consist of the base labor rate that is actually paid to the employee excluding social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead and exclusive of G&A and profit/fee.

NOTE 4: Apply fringe/overhead to prime offeror derived rates. "Sample Fringe-OHWorksheet" provides a sample to be used to compute fringe/overhead.

NOTE 5: Please enter the prime offeror or subcontractor billing rate (if performed by a subcontractor) BEFORE application of prime offeror general and administrative (G&A) expense and fixed fee. Therefore, the rate entered for prime contractor performed rate categories is as follows: rate = prime base labor rate + prime fringe + prime overhead. If the labor category is performed by a subcontractor, the rate entered in Col i is as follows: Rate = sub base rate +sub fringe + sub overhead + sub G&A + sub fee (i.e. subcontractor loaded rate EXCEPT for prime G&A and fee).

Defense Base Act (DBA) Insurance and other applicable allowances: Offerors must address these costs, based upon their normal business practice, and include them in ODCs and/or labor. If these costs are normally included in ODCs, offerors are to show this in their schedule of OCDs. As indicted above, if these costs are part of labor, an additional column may be inserted in the “Labor Detail” worksheet.

ODC - Cost Detail Spreadsheet:

NOTE 6: Offerors shall input their total proposed ODC cost for CLIN and supply a supporting schedule of these costs. Any material handling and/or G&A is to be applied as appropriate.

image2.emf

File details come from the government source that posted it.