Cost_Model_ABEA_-_Revision_2.xlsx
XLSX spreadsheet 67 KB Posted
- Attached to
- OBT ABEA Federal contract opportunity
- Solicitation number
- W91CRB-16-T-0017
About this file
Cost Model - Revision 2
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| W91CRB-16-T-0017-0005.pdf | ||
| A07_-_Conformed_Copy_of_Solicitation_Thru_Amend_0005.pdf | ||
| W91CRB-16-T-0017-0004.pdf | ||
| Conformed_Copy_of_Solicitation_Thru_Amend_0003.pdf | ||
| W91CRB-16-T-0017-0003.pdf | ||
| DD_254_Rev_2.pdf | ||
| DD_254_Rev_1.pdf | ||
| Cost_Model_ABEA_-_Revision_1.xlsx | XLSX spreadsheet | |
| W91CRB-16-T-0017-0002.pdf | ||
| Conformed_W91CRB-16-T-0017_Thru_Amend_0002.pdf | ||
| W91CRB-16-T-0017-0001.pdf | ||
| DD254_Army_Business_Enterprise_Architecture_Mar_16.pdf | ||
| W91CRB-16-T-0017.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 Personnel | Est. Productive Hours Per (Billed Hours) | Loaded Rated per Hour * | Estimated Cost |
| System Administration | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Database Management Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Web Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Applications Programming Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Information Assurance Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Comsec Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Logistics Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| VTC Support | 5 | |||
| Optional Categories | ||||
| Training Support | 1 | ERROR:#REF! | ||
| IT Customer Support | 3 | ERROR:#REF! | ||
| Configuration Management Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Systems Analyst Support | 10 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Telephone Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| ERROR:#REF! | ERROR:#REF! | |||
| Total Labor | ERROR:#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 1 | Labor Categories and |
| Level of Effort | W91CRB-08-R-0092 |
INSTRUCTIONS
INSTRUCTIONS
SECTION B
| SECTION B - SUPPLIES OR SERVICES & PRICES |
| Solicitation # W91CRB-16-T-0017 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0001 | Labor (Year 1 + Year 2) | ||||
| FFP | Fixed Price = | $ - 0 | |||
| Profit = | $ - 0 | ||||
| Price = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0002 | ODCs/Travel (Year 1 + Year 2) | ||||
| T&M | Fixed price = | $ 140,000.00 | |||
| Not to excced value | Price = | $ 140,000.00 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0003 | CMRA | 1 | Each | $ - 0 | |
| Price = | NSP |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0004 | Labor (Year 1 + Year 2) | ||||
| FFP | Fixed 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 0001 | Total | |
| Labor Hours | 0 | 24,000 | 24,000 | 48,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 Charge | 0.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-0017 | COST DETAIL CLIN 00XX |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: |
| Year 1 (clin 0001) | 0.00% | |||||||||
| POSITION TITLES | FTEs (Note 1) | Estimated Productive Hrs Per FTE | Total Hours | Effort 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) | Profit | Total | Total Burdened Rate Including Profit |
| a | b | c | d=b X c | e | f | g | h=d X g | i | j = h + 1 | k = j / d |
| Program Manager | 1.00 | 1,920 | 1,920 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Consultant/Facilitator | 1.00 | 1,920 | 1,920 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Enterprise Architect/Systems Architect I/BPR Specialist (lead) | 3.00 | 1,920 | 5,760 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Enterprise Architect/Systems Architect I/BPR Specialist | 4.00 | 1,920 | 7,680 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Enterprise Architect/Systems Architect II/BPR Specialist | 3.00 | 1,920 | 5,760 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Systems Engineer | 0.50 | 1,920 | 960 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
13 24,000 $ - 0 $ - 0 $ - 0
| Year 2 (clin 0001) | 0.00% | |||||||||
| POSITION TITLES | FTEs (Note 1) | Estimated Productive Hrs Per FTE | Total Hours | Effort 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) | Profit | Total | Total Burdened Rate Including Profit |
| a | b | c | d=b X c | e | f | g | h=d X g | i | j = h + 1 | k = j / d |
| Program Manager | 1.00 | 1920 | 1,920 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Consultant/Facilitator | 1.00 | 1920 | 1,920 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Enterprise Architect/Systems Architect I/BPR Specialist (lead) | 3.00 | 1920 | 5,760 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Enterprise Architect/Systems Architect I/BPR Specialist (intermediate) | 4.00 | 1920 | 7,680 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Enterprise Architect/Systems Architect II/BPR Specialist | 3.00 | 1920 | 5,760 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Systems Engineer | 0.50 | 1920 | 960 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
13 24,000 $ - 0 $ - 0 $ - 0
| Transition In (clin 0004) - Note 4 | 0.00% | |||||||||
| POSITION TITLES | FTEs (Note 1) | Estimated Productive Hrs | Total Hours | Effort 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) | Profit | Total | Total Burdened Rate Including Profit |
| a | b | c | d=c | e | f | g | h=d X g | i | j = h + 1 | k = j / d |
| 0.00 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0.00 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0.00 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0.00 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0.00 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0.00 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
0 0 $ - 0 $ - 0 $ - 0
| Total Burdened Price less Profit | Profit | Total | ||
| TOTAL LABOR | 48,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 0002 | ODCs (Note 6) | Handling Charge |
| a | b | c |
| Year 1 ODCs/Travel | $ 70,000.00 | 0.00% |
| Year 2 ODCs/Travel | $ 70,000.00 | 0.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 .