Cost_Model_ABEA_-_Revision_2.xlsx

XLSX spreadsheet 67 KB Posted

Attached to
OBT ABEA Federal contract opportunity
Solicitation number
W91CRB-16-T-0017
Issued by
Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

Cost Model - Revision 2

View the file

Other files for this federal contract opportunity

Other files attached to OBT ABEA, newest first.
File Type Posted
W91CRB-16-T-0017-0005.pdf PDF
A07_-_Conformed_Copy_of_Solicitation_Thru_Amend_0005.pdf PDF
W91CRB-16-T-0017-0004.pdf PDF
Conformed_Copy_of_Solicitation_Thru_Amend_0003.pdf PDF
W91CRB-16-T-0017-0003.pdf PDF
DD_254_Rev_2.pdf PDF
DD_254_Rev_1.pdf PDF
Cost_Model_ABEA_-_Revision_1.xlsx XLSX spreadsheet
W91CRB-16-T-0017-0002.pdf PDF
Conformed_W91CRB-16-T-0017_Thru_Amend_0002.pdf PDF
W91CRB-16-T-0017-0001.pdf PDF
DD254_Army_Business_Enterprise_Architecture_Mar_16.pdf PDF
W91CRB-16-T-0017.pdf PDF
Copy_of_Cost_Model_ABEA.xlsx XLSX spreadsheet
Show all 14

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

SECTION B

SECTION B - SUPPLIES OR SERVICES & PRICES
Solicitation # W91CRB-16-T-0017
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0001Labor (Year 1 + Year 2)
FFPFixed Price =$ - 0
Profit =$ - 0
Price =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0002ODCs/Travel (Year 1 + Year 2)
T&MFixed price =$ 140,000.00
Not to excced valuePrice =$ 140,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0003CMRA1Each$ - 0
Price =NSP
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0004Labor (Year 1 + Year 2)
FFPFixed Price =$ - 0
Profit =$ - 0
Price =$ - 0
TOTAL
Estimated Price=$ 140,000.00
Profit =$ - 0
Price + Profit =$ 140,000.00
$ 140,000.00

&F, &A

PAGE &P OF &N

Cost Summary

COST SUMMARY
Solicitation # W91CRB-16-T-0017

TOTAL SUMMARY

Transition In (clin 0004)Year 1 (clin 0001)Year 2 (clin 0001Total
Labor Hours024,00024,00048,000
Labor & Subcontract Labor$ - 0$ - 0$ - 0$ - 0
Profit$ - 0$ - 0$ - 0$ - 0
Total Labor (clin 0001)$ - 0$ - 0$ - 0$ - 0
Other Direct Costs$ 70,000.00$ 70,000.00$ 140,000.00
Handling Charge0.00%0.00%$ - 0
Total ODC (clin 0002)$ 70,000.00$ 70,000.00$ 140,000.00

TOTAL COST $ - 0 $ 70,000.00 $ 70,000.00 $ 140,000.00

&F, &A

Page &P of &N

Labor- Cost Detail

Labor - Cost Detail Spreadsheet
Solicitation No. W91CRB-16-T-0017COST DETAIL CLIN 00XX
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Year 1 (clin 0001)0.00%
POSITION TITLESFTEs (Note 1)Estimated Productive Hrs Per FTETotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor(s)Total Burdened Rate less Profit (Note 3)Total Burdened Price less Profit (Note 3)ProfitTotalTotal Burdened Rate Including Profit
abcd=b X cefgh=d X gij = h + 1k = j / d
Program Manager1.001,9201,920Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Consultant/Facilitator1.001,9201,920Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Enterprise Architect/Systems Architect I/BPR Specialist (lead)3.001,9205,760Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Enterprise Architect/Systems Architect I/BPR Specialist4.001,9207,680Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Enterprise Architect/Systems Architect II/BPR Specialist3.001,9205,760Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Systems Engineer0.501,920960Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0

13 24,000 $ - 0 $ - 0 $ - 0

Year 2 (clin 0001)0.00%
POSITION TITLESFTEs (Note 1)Estimated Productive Hrs Per FTETotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor(s)Total HOURLY Burdened Rate less Profit (Note 3)Total Burdened Price less Profit (Note 3)ProfitTotalTotal Burdened Rate Including Profit
abcd=b X cefgh=d X gij = h + 1k = j / d
Program Manager1.0019201,920Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Consultant/Facilitator1.0019201,920Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Enterprise Architect/Systems Architect I/BPR Specialist (lead)3.0019205,760Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Enterprise Architect/Systems Architect I/BPR Specialist (intermediate)4.0019207,680Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Enterprise Architect/Systems Architect II/BPR Specialist3.0019205,760Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0
Systems Engineer0.501920960Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0

13 24,000 $ - 0 $ - 0 $ - 0

Transition In (clin 0004) - Note 40.00%
POSITION TITLESFTEs (Note 1)Estimated Productive HrsTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor(s)Total HOURLY Burdened Rate less Profit (Note 3)Total Burdened Price less Profit (Note 3)ProfitTotalTotal Burdened Rate Including Profit
abcd=cefgh=d X gij = h + 1k = j / d
0.000Enter P or S$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
0.000Enter P or S$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
0.000Enter P or S$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
0.000Enter P or S$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
0.000Enter P or S$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
0.000Enter P or S$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!

0 0 $ - 0 $ - 0 $ - 0

Total Burdened Price less ProfitProfitTotal
TOTAL LABOR48,000$ - 0$ - 0$ - 0

&F, &A

PAGE &P OF &N

ODC Travel Summary

ODC Cost Detail Spreadsheet
Solicitation No. W91CRB-16-T-0017
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
ODC COST DETAIL
CLIN 0002
CLIN 0002ODCs (Note 6)Handling Charge
abc
Year 1 ODCs/Travel$ 70,000.000.00%
Year 2 ODCs/Travel$ 70,000.000.00%
Total$ 140,000.00
OFFEROR TO ENTER HANDLING CHARGE ONLY
Contract ODCs Not-to-exceed $140,000

Microsoft_Word_Document1.docx 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 and in the ODC/Travel 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 Cost Summary Spreadsheet and is used as a basis for the proposed formal Section B.

Cost Summary Worksheet: This spreadsheet is for Government analysis purposes. It is populated from the Labor-Cost Detail spreadsheet and from the ODC/Travel Summary worksheet.

Labor-Detail Worksheet:

General: Each offeror is to bid on the labor categories and the productive hours contained in the spreadsheet. The number of hours are estimates for evaluation and contract not-to-exceed ceiling purposes. These categories and productive hours are NOT to be changed by the offerors in the spreadsheets. However, offeror is allowed to bid labor categories and corresponding productive hours in addition to those specified in the spreadsheet if the offeror deems that additional labor categories are necessary to perform under the contract. 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.

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 B if the effort is to be performed by the prime contractor, and an S if performed by another division or subcontractor. Enter the name of the division or contractor in Col C. If the particular individual category is to be performed jointly by more than one entity (i.e. the prime and a sub or subs), the offeror will be required to insert additional row(s) under the labor category and to allocate the Col k hours for the individual category to be performed among the prime and subs . After this allocation, the total of the original and inserted rows under the individual category in Col K shall total to the number of hours provided by the Govt for the respective labor category.

NOTE 3: Please enter the burdened labor rate before profit for the labor categories listed. The burdened labor rate consist of the base labor rate that is actually paid to the employee plus social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead and G&A exclusive of profit/fee. Additional information may be requested if so determined by the Contract Officer to determine reasonableness of prices proposed.

NOTE 4: Transition-In costs – Offerors are to fill in the light blue shaded areas representing their transitioning in costs. This amount will be part of the total evaluated price.

NOTE 5: N/A

ODC - Cost Detail Spreadsheet:

NOTE 6: Offeror’s proposed ODCs/travel HANDLING CHARGE shall be inserted on the ODC Travel Summary worksheet in the light blue shaded cells.

image2.emf

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