J _Part_III _Atachment_J.3_-_Cost_and_Business_Proposal_Schedules.xlsx
XLSX spreadsheet 56 KB Posted
- Solicitation number
- DTRT57-13-R-20007
About this file
DTRT57-13-R-20007 Section J Part III Attachment J.3 - Cost and Business Proposal Schedules
View the file
Other files
| File | Type | Posted |
|---|---|---|
| DTRT57-13-R-20007_Amendment_A0006.pdf | ||
| DTRT57-13-R-20007_Amendment_A0005.pdf | ||
| A0004_Attachment_2_DTRT57-13-R-20007_Informational_Copy.docx | DOCX document | |
| DTRT57-13-R-20007_Amendment_A0004.pdf | ||
| DTRT57-13-R-20007_A0003_Attachment_4.docx | DOCX document | |
| DTRT57-13-R-20007_A0003.pdf | ||
| DTRT57-13-R-20007_Amendment_A0002.pdf | ||
| DTRT57-13-R-20007_A0001.pdf | ||
| DTRT57-13-R-20007.pdf | ||
| DRAFT_Atachment_J.3_-_Cost_and_Business_Proposal_Schedules.xlsx | XLSX spreadsheet | |
| DRAFT_RFP_DTRT57-13-R-20007.doc | DOC document |
Show all 11
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
Schedule 1
| SCHEDULE 1 |
| SUMMARY OF PROPOSED COSTS AND FIXED FEE - CORA TASK ORDER 1, CLINS 0001 - 0003 |
Offeror or Subcontractor Name: ______________________________________________
| CLIN | Contract Type | Description | Estimated Cost | Fixed Fee | Total |
| 0001 | Firm Fixed Price | Transition | $ | ||
| 0002 | Cost Plus Fixed Fee | Task Order Management and Administration (from Schedule 2) | |||
| Period 1 | $ | $ | $ | ||
| Period 2 | $ | $ | $ | ||
| Period 3 | $ | $ | $ | ||
| Period 4 | $ | $ | $ | ||
| Period 5 | $ | $ | $ | ||
| CLIN 0002 Total | $ | $ | $ | ||
| 0003 | Cost Plus Fixed Fee | CORA Support Services (from Schedule 2) | |||
| Period 1 | $ | $ | $ | ||
| Period 2 | $ | $ | $ | ||
| Period 3 | $ | $ | $ | ||
| Period 4 | $ | $ | $ | ||
| Period 5 | $ | $ | $ | ||
| CLIN 0003 Total | $ | $ | $ | ||
| Total - CORA Task Order 1 | $ | $ | $ |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
Schedule 2
| SCHEDULE 2 |
| SUMMARY OF PROPOSED COSTS AND FIXED FEE BY COST ELEMENT - CORA TASK ORDER 1, CLINS 0001 - 0003 |
| Offeror or Subcontractor Name: __________________________________________________ |
| Element of Proposal | CLIN 0001 | CLIN 0002 | CLIN 0003 | ||||||||
| Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | ||
| Direct Labor (from Schedule 3 & 4) | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Fringe Benefits (if separate from overhead) | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Government-Site Overhead* | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Subcontracts**: | |||||||||||
| Subcontractor A | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Subcontractor B | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Subcontractor C | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Subcontractor D | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Total Subcontracts | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Subcontract Burden (if separate) | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Other Direct Costs: | |||||||||||
| RFP-stipulated | $0 | $0 | $0 | $0 | $0 | $1,365,000 | $1,400,000 | $1,450,000 | $1,500,000 | $1,550,000 | |
| Offeror-estimated | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| ODC Burden (if separate) | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| SUBTOTAL | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| G&A | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| TOTAL ESTIMATED COST | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| FIXED FEE (from Schedule 6) | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Cost of Money | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| TOTAL | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| *Offeror shall propose using Government-site overhead only. | |||||||||||
| **Cost type subcontracts should be cost-plus-fixed-fee. |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
Schedule 3
| SCHEDULE 3 |
| CALCULATION OF DIRECT LABOR COST - CORA TASK ORDER 1 |
| CLIN 0002 - TASK ORDER MANAGEMENT AND ADMINISTRATION |
Offeror or Subcontractor Name: _________________________________________________________
| A. Labor Hours | ||||||
| Key Personnel Position | Proposed Labor Category | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 |
| Task Order Program Manager | |
| Financial Manager | |
| ORA Department Manager | |
| Communications Department Manager | |
| TBD (in accordance with Contractor's proposal) | |
| Total |
| B. Unburdened Labor Rates | ||||||
| Key Personnel Position | Proposed Labor Category | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 |
| Task Order Program Manager | $ | $ | $ | $ | $ |
| Financial Manager | $ | $ | $ | $ | $ |
| ORA Department Manager | $ | $ | $ | $ | $ |
| Communications Department Manager | $ | $ | $ | $ | $ |
| TBD (in accordance with Contractor's proposal) | $ | $ | $ | $ | $ |
| C. Extended Labor Cost (A times B) | ||||||
| Key Personnel Position | Proposed Labor Category | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 |
| Task Order Program Manager | $ | $ | $ | $ | $ | |
| Financial Manager | $ | $ | $ | $ | $ | |
| ORA Department Manager | $ | $ | $ | $ | $ | |
| Communications Department Manager | $ | $ | $ | $ | $ | |
| TBD (in accordance with Contractor's proposal) | $ | $ | $ | $ | $ | |
| Total | $ | $ | $ | $ | $ |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
Schedule 4
| SCHEDULE 4 |
| CALCULATION OF DIRECT LABOR COST - CORA TASK ORDER 1 |
| CLIN 0003 - CORA SUPPORT SERVICES |
| Offeror or Subcontractor Name: _________________________________________________________ |
| A. Labor Hours | |||||
| Labor Category | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 |
| Professional Analyst | |||||
| Professional Specialist | |||||
| Senior Analyst | |||||
| Senior Specialist | |||||
| Senior Engineer | |||||
| Middle Analyst | |||||
| Middle Specialist | |||||
| Middle Engineer | |||||
| Junior Analyst | |||||
| Junior Specialist | |||||
| Junior Engineer | |||||
| Administrative Specialist | |||||
| Total | |||||
| B. Unburdened Labor Rates | |||||
| Labor Category | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 |
| Professional Analyst | Offeror-proposed | Offeror-proposed | Offeror-proposed | Offeror-proposed | Offeror-proposed |
| Professional Specialist | Offeror-proposed | Offeror-proposed | Offeror-proposed | Offeror-proposed | Offeror-proposed |
| Senior Analyst | $52.00 | $53.17 | $54.37 | $55.59 | $56.84 |
| Senior Specialist | $55.00 | $56.24 | $57.50 | $58.80 | $60.12 |
| Senior Engineer | $58.00 | $59.31 | $60.64 | $62.00 | $63.40 |
| Middle Analyst | $33.00 | $33.74 | $34.50 | $35.28 | $36.07 |
| Middle Specialist | $40.00 | $40.90 | $41.82 | $42.76 | $43.72 |
| Middle Engineer | $42.00 | $42.95 | $43.91 | $44.90 | $45.91 |
| Junior Analyst | $26.00 | $26.59 | $27.18 | $27.79 | $28.42 |
| Junior Specialist | $25.00 | $25.56 | $26.14 | $26.73 | $27.33 |
| Junior Engineer | $27.00 | $27.61 | $28.23 | $28.86 | $29.51 |
| Administrative Specialist | Offeror-proposed | Offeror-proposed | Offeror-proposed | Offeror-proposed | Offeror-proposed |
| C. Extended Labor Cost (A times B) | |||||
| Labor Category | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 |
| Professional Analyst | $ | $ | $ | $ | $ |
| Professional Specialist | $ | $ | $ | $ | $ |
| Senior Analyst | $ | $ | $ | $ | $ |
| Senior Specialist | $ | $ | $ | $ | $ |
| Senior Engineer | $ | $ | $ | $ | $ |
| Middle Analyst | $ | $ | $ | $ | $ |
| Middle Specialist | $ | $ | $ | $ | $ |
| Middle Engineer | $ | $ | $ | $ | $ |
| Junior Analyst | $ | $ | $ | $ | $ |
| Junior Specialist | $ | $ | $ | $ | $ |
| Junior Engineer | $ | $ | $ | $ | $ |
| Administrative Specialist | $ | $ | $ | $ | $ |
| Total | $ | $ | $ | $ | $ |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
Schedule 5
| SCHEDULE 5 |
| PROPOSED INDIRECT RATES AND INDIRECT RATE CEILINGS AND ALLOCATION BASES - CORA TASK ORDER 1, CLINS 0002 AND 0003 |
Offeror or Subcontractor Name: _________________________________________________________
| Proposed Indirect Rates | |||||||
| Task Order Period | Contractor Fiscal Year (1) | Fringe Benefits (2) | Government-site Overhead | Contractor-site Overhead (3) | Material Handling (4) | G&A | Other (5) |
| 1 | CFY__ | ||||||
| CFY__ | |||||||
| 2 | CFY__ | ||||||
| CFY__ | |||||||
| 3 | CFY__ | ||||||
| CFY__ | |||||||
| 4 | CFY__ | ||||||
| CFY__ | |||||||
| 5 | CFY__ | ||||||
| CFY__ |
| (1) Offeror shall combine two fiscal years for the period unless its fiscal year coincides with planned performance period. |
| (2) If separate from overhead. |
| (3) If used in proposal. |
| (4) If different from G&A. |
| (5) Specify |
| Indirect Rate Ceilings | |||||||
| Task Order Period | Contractor Fiscal Year | Fringe Benefits | Government-site Overhead | Contractor-site Overhead | Material Handling | G&A | Other |
| 1 | CFY__ | at proposed | |||||
| CFY__ | at proposed | ||||||
| 2 | CFY__ | at proposed | |||||
| CFY__ | at proposed | ||||||
| 3 | CFY__ | ||||||
| CFY__ | |||||||
| 4 | CFY__ | ||||||
| CFY__ | |||||||
| 5 | CFY__ | ||||||
| CFY__ |
| Indirect Rate | Allocation Base |
| Example: Material Handling | Subcontract and equipment cost |
| Example: G&A | All costs except subcontract and equipment cost |
| Fringe Benefits | |
| Government-site Overhead | |
| Contractor-site Overhead | |
| Material Handling | |
| G&A | |
| Other |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
Schedule 6
| SCHEDULE 6 |
| ESTABLISHMENT OF MAXIMUM FACTORS FOR THE MASTER CONTRACT AND CALCULATION OF PROPOSED FIXED FEE FOR CORA TASK ORDER 1 |
Offeror Name: _________________________________________________________
| FIXED FEE - CORA TASK ORDER 1, CLIN 0002 | |||
| Estimated Cost | Percentage (3) | Fixed Fee Dollars | |
| Subcontracts and Other Direct Cost from Schedule 2 CLIN 0002 (1) | $ | % | $ |
| All Other Costs from Schedule 2 (2) | $ | % | $ |
| Total | $ | ||
| Total Fixed Fee Dollars (4) | $ |
| FIXED FEE - CORA TASK ORDER 1, CLIN 0003 | |||
| Estimated Cost | Percentage (3) | Fixed Fee Dollars | |
| Subcontracts and Other Direct Cost from Schedule 2 CLIN 0003 (1) | $ | % | $ |
| All Other Costs from Schedule 2 (2) | $ | % | $ |
| Total | $ | ||
| Total Fixed Fee Dollars (4) | $ |
| (1) "Subcontracts and Travel Cost” should not include any Prime indirect burden. |
| (2) "All Other Costs" should include remaining costs from Schedule 1 except Cost of Money, if proposed. |
| (3) "Percentage" is the fee percentage the Offeror uses to develop fixed fee. These percentages will be incorporated in paragraph H.18 of the resulting contracts and will be used to calculate the maximum fixed fee that an Offeror may propose for subsequent task orders. Offerors may always bid less than the calculated maximum for subsequent task orders. |
| (4) Fixed fee for CLINs 0002 and 0003 on Schedule 2 should be calculated based on the tables above. |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
Schedule 7
| SCHEDULE 7 |
| TABLE OF SUBCONTRACTORS - CORA TASK ORDER 1 |
Offeror or Subcontractor Name: _________________________________________________________
| CLIN 0002 | CLIN 0003 | All CLINs | |||
| Type | Value | Type | Value | Total Sub Value | |
| Subcontractor A | |||||
| Subcontractor B | |||||
| Subcontractor C | |||||
| Subcontractor D | |||||
| Subcontractor E |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
Schedule 8
| SCHEDULE 8 |
| ALLOCATION OF LABOR HOURS BETWEEN OFFEROR AND SUBCONTRACTORS - CORA TASK ORDER 1 |
| CLIN 0003 - CORA SUPPORT SERVICES |
Offeror or Subcontractor Name: _________________________________________________________
| Prime | Sub A | Sub B | Sub C | Sub D | Total | RFP Total | |
| Professional Analyst | 149,600 | ||||||
| Professional Specialist | 99,800 | ||||||
| Senior Analyst | 149,600 | ||||||
| Senior Specialist | 124,900 | ||||||
| Senior Engineer | 37,500 | ||||||
| Middle Analyst | 99,800 | ||||||
| Middle Specialist | 76,000 | ||||||
| Middle Engineer | 12,400 | ||||||
| Junior Analyst | 25,200 | ||||||
| Junior Specialist | 99,800 | ||||||
| Junior Engineer | 2,400 | ||||||
| Administrative Specialist | 2,400 | ||||||
| Total | 899,400 |
| Sub A | Sub B | Sub C | Sub D | |
| Value | $ | $ | $ | $ |
| Type of Subcontract |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
Schedule 9
| SCHEDULE 9 |
| LABOR COST REALISM - CORA TASK ORDER 1 |
Offeror or Subcontractor Name: _________________________________________________________
Labor Category (from Schedules 3 and 4) Resumed Person's Name Company Affiliation Actual Current Labor Rate from Payroll Records Period 1 Unburdened Labor Rate (from Schedules 3 and 4)
| *If the current labor rate for the person whose resume is submitted is more than 5% higher thanthe Schedule 5 labor rate for that category, explain why the proposed labor rate for the labor category is still realistic. |
| **The Offeror may modify the schedule to include additional rows if additional Key Personnel are proposed under CLIN 0002. |
| ***The Transition Manager shall not be included in this table because CLIN 0001 is a firm fixed price CLIN |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
Schedule 10
| SCHEDULE 10 |
| RESUME CHECKLIST - CORA TASK ORDER 1 |
Offeror or Subcontractor Name: _________________________________________________________
| Labor Category | No. of Resumes | Employee Name | Prime or Subcontractor Name |
| Task Order Program Manager | 1 | ||
| Financial Manager | 1 | ||
| ORA Department Manager | 1 | ||
| Communications Department Manager | 1 | ||
| Any additional staff regarded by the Offeror as key personnel under CORA Task Order 1, CLIN 0002 | As proposed by Offeror | ||
| Contract Program Manager | 1 | ||
| Professional Analyst | 2 |
Professional Specialist 2
Senior Analyst 2
Senior Specialist 2
| Senior Engineer | 1 |
| Transition Manager | 1 |
&"Times New Roman,Bold"SECTION J, PART III, ATTACHMENT J.3 - COST AND BUSINESS PROPOSAL SCHEDULES
File details come from the government source that posted it. Updated .