Attachment_2_PRICE.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
Professional Services to Support AMSAA Mission Federal contract opportunity
Solicitation number
W91CRB-17-T-0001
Issued by
Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

Pricing

View the file

Other files for this federal contract opportunity

Other files attached to Professional Services to Support AMSAA Mission, newest first.
File Type Posted
W91CRB-17-T-0001-0006.pdf PDF
W91CRB-17-T-0001_Amendment_0005.pdf PDF
W91CRB-17-T-0001_AMENDMENT_0004.pdf PDF
A02_W91CRB-17-T-0001_Amendment_3.pdf PDF
W91CRB-17-T-0001-0002_Amendment_2.pdf PDF
W91CRB-17-T-0001-0001.pdf.pdf PDF
Attachment_1_TECHSTAFF.docx DOCX document
W91CRB-17-T-0001.pdf PDF
Attachment_3_DD254.pdf PDF

On GovTribe

Work with this file on GovTribe

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

Text version

Section B Labor & ODC Proposed Labor & ODC

DIRECT LABOR**# of PersonnelEst. Productive Hours Per (Billed Hours)Loaded Rated per Hour *Estimated Cost
System Administration1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Database Management Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Web Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Applications Programming Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Information Assurance Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Comsec Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Logistics Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
VTC Support5
Optional Categories
Training Support1ERROR:#REF!
IT Customer Support3ERROR:#REF!
Configuration Management Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Systems Analyst Support10ERROR:#REF!ERROR:#REF!ERROR:#REF!
Telephone Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!
Total LaborERROR:#REF!ERROR:#REF!
Burden Rate
Total ODC's$ - 0$ - 0
Total Travel$ - 0$ - 0

Grand Total ERROR:#REF!

Entering the appropriate percentages in the shaded areas will automatically compute the corresponding amounts in the spreadsheet.
* = From labor detail spreadsheet.
** = NOTE: In this case, OCONUS means Iraq or Afghanistan. If performance is required in an OCONUS location other than Iraq or Afghanistan, proposed OCONUS rates will not be in effect. See CLIN 0001 for more detail.
Attachment 1Labor Categories and
Level of EffortW91CRB-08-R-0092

INSTRUCTIONS

INSTRUCTIONS

General: Each 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-Cost Detail spreadsheets. The spreadsheets are designed to automatically compute and populate other cells in the Excel spreadsheets and workbooks.

Section B Spreadsheet: The Section B worksheet imports data from the Price Summary spreadsheet and is used as a basis for the proposed formal Section B.

Price Summary Spreadsheet: This spreadsheet is for Government analysis purposes. It is populated from the Labor-Cost Detail spreadsheets.

Labor - Cost Detail Spreadsheet: 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: Offeror is to enter the positions and the hours they are proposing to meet the requirements.

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 C 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 D. 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 B 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 provided by the Govt for the respective labor category.

NOTE 3: Please enter the base labor rate for the labor categories listed. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reason, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror.

NOTE 4: Apply fringe to prime offeror derived rates. "Sample Fringe Worksheet" provides a sample to be used to compute fringe. The fringe rate is based on the actual fringes paid to or on behalf of the employee INCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc). For proprietary reason, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror.

Sample Fringe Spreadsheet: This spreadsheet shows a generally accepted format for fringe benefit pool/base/rate calculations. Fringe benefit pool, base, and rate calculations are required as part of the offeror's cost/price proposal. Describe as necessary in the cost/price narrative. Please indicate if the rates are based on a forward pricing rate agreement (FPRA) or other signed rate agreement with DCAA and/or DCMA. Subcontractor data may be submitted directly to the Contracting Officer for proprietary reasons.

SECTION B

SAMPLE SECTION B - SUPPLIES OR SERVICES & PRICES
(This is for sample purposes only. The Section B actually submitted shall conform to the format contained in the solicitation.)
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0001TRANSITION and BASE1Each$ - 0
LABOR - FFPPrice=$ - 0From Cost Summary page
Profit=$ - 0From Cost Summary page
Total Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0002Base Year1Each$ - 0
Contract Manpower ReportingTotal Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0003Option year 11Each$ - 0
LABOR - FFPPrice=$ - 0From Cost Summary page
Profit=$ - 0From Cost Summary page
Total Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0004Option 11Each$ - 0
Contract Manpower ReportingTotal Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0005Option Year 21Each$ - 0
LABOR - FFPPrice=$ - 0From Cost Summary page
Profit=$ - 0From Cost Summary page
Total Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0006Option 21Each$ - 0
Contract Manpower ReportingTotal Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0007Option Year 31Each$ - 0
LABOR - FFPPrice=$ - 0From Cost Summary page
Profit=$ - 0From Cost Summary page
Total Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0008Option 31Each$ - 0
Contract Manpower ReportingTotal Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0009Option Year 4 and Transition Out1Each$ - 0
LABOR - FFPPrice=$ - 0From Cost Summary page
Profit=$ - 0From Cost Summary page
Total Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0010Option 41Each$ - 0
Contract Manpower ReportingTotal Price =$ - 0
Total Price$ - 0
Profit$ - 0
Total Price$ - 0
Double Check Number$ - 0Total from Cost Summary sheet
Double Check Number$ - 0Total from Labor-Cost Detail

&F, &A

PAGE &P OF &N

Price Summary

Cost Summary Spreadsheet
Solicitation No.
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Transition In PeriodBase PeriodOption 1 - Year 2Option 2 - Year 3Option 3 - Year 4Option 4 - Year 5Transition Out Period
LABOR HOURSTotal
Total Labor Hours0.000.000.000.000.000.000.000From Labor - Cost Detail workshhet
LABOR COSTS
Labor & Subcontract Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor - Cost Detail workshhet
Profit$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor - Cost Detail workshhet
Total Labor Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Labor - Cost Detail

Labor Cost Detail Spreadsheet
Solicitation No.
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
LABOR COST DETAIL
CLIN 0001 Transition In Period0.00%0.00%
POSITON TITLESTotal Hours (Note 1)Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col c=S, Enter Name of Subcontractor & Goto Col iHourly Base Pay Rate (Note 3 )Fringe (Note 4)Hourly Base Rate plus Fringe RateFully Burdened Hourly Labor Rate Before Prime ProfitTotal Price Before ProfitProfitTotal PriceFully Burdened Labor Rate (To Price Summary Spreadsheet)
abcdef=eXfg=e+fij=i X bkl=j+km=l/b
- 0Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0$ - 0$ - 0$ - 0$ - 0To Cost Summary page
CLIN 0001 Base Year0.00%0.00%
POSITON TITLESTotal Hours (Note 1)Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col c=S, Enter Name of Subcontractor & Goto Col iHourly Base Pay Rate (Note 3 )Fringe (Note 4)Hourly Base Rate plus Fringe RateFully Burdened Hourly Labor Rate Before Prime ProfitTotal Price Before ProfitProfitTotal PriceFully Burdened Labor Rate (To Price Summary Spreadsheet)
abcdef=eXfg=e+fij=i X bkl=j+km=l/b
- 0Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!

- 0 $ - 0 $ - 0 $ - 0 $ - 0 To Cost Summary page

CLIN 0003 Option 10.00%0.00%
POSITON TITLESTotal Hours (Note 1)Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col c=S, Enter Name of Subcontractor & Goto Col iHourly Base Pay Rate (Note 3 )Fringe (Note 4)Hourly Base Rate plus Fringe RateFully Burdened Hourly Labor Rate Before Prime ProfitTotal Price Before ProfitProfitTotal PriceFully Burdened Labor Rate (To Price Summary Spreadsheet)
abcdef=eXfg=e+fij=i X bkl=j+km=l/b
- 0Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0
- 0$ - 0$ - 0$ - 0$ - 0To Cost Summary page
CLIN 0005 Option 20.00%0.00%
POSITON TITLESTotal Hours (Note 1)Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col c=S, Enter Name of Subcontractor & Goto Col iHourly Base Pay Rate (Note 3 )Fringe (Note 4)Hourly Base Rate plus Fringe RateFully Burdened Hourly Labor Rate Before Prime ProfitTotal Price Before ProfitProfitTotal PriceFully Burdened Labor Rate (To Price Summary Spreadsheet)
abcdef=eXfg=e+fij=i X bkl=j+km=l/b
- 0Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!

- 0 $ - 0 $ - 0 $ - 0 $ - 0 To Cost Summary page

CLIN 0007 Option 30.00%0.00%
POSITON TITLESTotal Hours (Note 1)Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col c=S, Enter Name of Subcontractor & Goto Col iHourly Base Pay Rate (Note 3 )Fringe (Note 4)Hourly Base Rate plus Fringe RateFully Burdened Hourly Labor Rate Before Prime ProfitTotal Price Before ProfitProfitTotal PriceFully Burdened Labor Rate (To Price Summary Spreadsheet)
abcdef=eXfg=e+fij=i X bkl=j+km=l/b
- 0Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!

- 0 $ - 0 $ - 0 $ - 0 $ - 0 To Cost Summary page

CLIN 0009 Option 40.00%0.00%
POSITON TITLESTotal Hours (Note 1)Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col c=S, Enter Name of Subcontractor & Goto Col iHourly Base Pay Rate (Note 3 )Fringe (Note 4)Hourly Base Rate plus Fringe RateFully Burdened Hourly Labor Rate Before Prime ProfitTotal Price Before ProfitProfitTotal PriceFully Burdened Labor Rate (To Price Summary Spreadsheet)
abcdef=eXfg=e+fij=i X bkl=j+km=l/b
- 0Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!

- 0 $ - 0 $ - 0 $ - 0 $ - 0 To Cost Summary page

CLIN 0009 Transition Out0.00%0.00%
POSITON TITLESTotal Hours (Note 1)Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col c=S, Enter Name of Subcontractor & Goto Col iHourly Base Pay Rate (Note 3 )Fringe (Note 4)Hourly Base Rate plus Fringe RateFully Burdened Hourly Labor Rate Before Prime ProfitTotal Price Before ProfitProfitTotal PriceFully Burdened Labor Rate (To Price Summary Spreadsheet)
abcdef=eXfg=e+fij=i X bkl=j+km=l/b
- 0Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0Enter P or S- 0- 0- 0- 0- 0- 0- 0ERROR:#DIV/0!
- 0$ - 0$ - 0$ - 0$ - 0To Cost Summary page
Total HoursTotal Direct LaborTotal ProfitTotal Price
TOTALS0$ - 0- 0$ - 0- 0

&F, &A

PAGE &P OF &N

Sample Fringe-Worksheet

DIRECT LABOR FRINGE/OVERHEAD RATE

Company, Inc.
Anycity, USA
Proposal Submitted In Response to XXXXX
DIRECT LABOR FRINGE/OVERHEAD RATE
FY2011EstimatedEstimatedEstimated
Overhead Expenses:ActualYear 1Year 2Year 3
Indirect payroll$ - 0$ - 0$ - 0$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)$ 12,000.00$ 11,000.00$ 10,000.00$ 8,700.00
Vacation (PTO)$ 12,000.00$ 11,000.00$ 10,000.00$ 8,000.00
Holiday$ - 0$ - 0$ - 0$ - 0
Sick Leave$ 600.00$ 600.00$ 600.00$ 600.00
Health/Disability Ins$ 7,000.00$ 7,000.00$ 7,000.00$ 6,500.00
Workmans Compensation/Defense Base Act$ 4,000.00$ 4,000.00$ 4,000.00$ 4,000.00
Bonuses$ 1,000.00$ 1,000.00$ 1,000.00$ 1,000.00
Retention Pay$ 2,000.00$ 1,000.00$ 1,000.00$ 1,000.00
401k Match$ 4,000.00$ 3,500.00$ 3,000.00$ 3,000.00
Mil Leave$ 100.00$ 100.00$ 100.00$ 50.00
Breavement$ 100.00$ 200.00$ 200.00$ 50.00
Insurance$ 200.00$ 200.00$ 200.00$ 100.00
Total Pool$ 43,000.00$ 39,600.00$ 37,100.00$ 33,000.00
Less: FAR 31 Unallowable Cost
Entertainment, etc.
Net Allowable cost$ 43,000.00$ 39,600.00$ 37,100.00$ 33,000.00
Labor Base
Direct Labor$ 113,500.00$ 100,000.00$ 90,000.00$ 80,000.00
OH Labor$ 4,352.00$ 4,200.00$ 4,100.00$ 4,000.00
B&P Labor$ 1,200.00$ 1,100.00$ 1,100.00$ 1,000.00
Total Labor Base$ 119,052.00$ 105,300.00$ 95,200.00$ 85,000.00

Rate 36.12% 37.61% 38.97% 38.82%

This exhibit shows a combined fringe benefit/overhead allocation. However the offeror may in actuality have separate
allocations for fringe benefits and overhead depending on its accounting system.
Please provide any FPRAs/FPRRs/Rate Agreements to corroborate proposed rates.

File details come from the government source that posted it. Updated .