Attachment J-7 Cost Workbook.xlsx
XLSX spreadsheet 44 KB Posted
- Solicitation number
- 693KA9-19-R-00028
About this file
Attachment J-7 Cost Workbook (xlsx)
View the file
Other files
Show all 23
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
Tab A Summary
| Base Year 1 | ||
| Labor - CLIN 001 (Cost Reimbursable) | Estimated Labor Hours | Total Cost |
| Professor I | 2,400 | - 0 |
| Professor II | 3,120 | - 0 |
| Graduate Student I | 4,320 | - 0 |
| Graduate Student II | 4,320 | - 0 |
| Researcher I | 4,320 | - 0 |
| Researcher II | 4,320 | - 0 |
| Subcontractors | - 0 | - 0 |
| Total Hours/Labor | 22,800 | - 0 |
| ODCs CLIN 101 (CR) (NTE) | ||
| Materials & Equipment (NTE) | $70,146.00 | |
| Conferences / Training / Workshops (NTE) | $420,876.00 | |
| Travel (NTE) | $70,146.00 | |
| Other Graduate Student Costs (NTE) | $187,056.00 | |
| Total ODCs (NTE) | $748,224.00 | |
| Tota Cost Base Year 1 | $748,224.00 | |
| CLIN 002 - Base Year 2 | ||
| Labor - CLIN 002 (Cost Reimbursable) | Estimated Labor Hours | Total Cost |
| Professor I | 2,400 | - 0 |
| Professor II | 3,120 | - 0 |
| Graduate Student I | 4,320 | - 0 |
| Graduate Student II | 4,320 | - 0 |
| Researcher I | 4,320 | - 0 |
| Researcher II | 4,320 | - 0 |
| Subcontractors | - 0 | - 0 |
| Total | 22,800 | - 0 |
| ODCs CLIN 102 (CR) (NTE) | ||
| Materials & Equipment (NTE) | $71,829.50 | |
| Conferences / Training / Workshops (NTE) | $430,977.02 | |
| Travel (NTE) | $71,829.50 | |
| Other Graduate Student Costs (NTE) | $191,545.34 | |
| Total ODCs (NTE) | $766,181.38 | |
| Tota Cost Base Year 2 | $766,181.38 | |
| CLIN 003 - Base Year 3 | ||
| Labor - CLIN 003 (Cost Reimbursable) | Estimated Labor Hours | Total Cost |
| Professor I | 2,400 | - 0 |
| Professor II | 3,120 | - 0 |
| Graduate Student I | 4,320 | - 0 |
| Graduate Student II | 4,320 | - 0 |
| Researcher I | 4,320 | - 0 |
| Researcher II | 4,320 | - 0 |
| Subcontractors | - 0 | - 0 |
| Total | 22,800 | - 0 |
| ODCs CLIN 103 (CR) (NTE) | ||
| Materials & Equipment (NTE) | $73,553.41 | |
| Conferences / Training / Workshops (NTE) | $441,320.47 | |
| Travel (NTE) | $73,553.41 | |
| Other Graduate Student Costs (NTE) | $196,142.43 | |
| Total ODCs (NTE) | $784,569.73 | |
| Tota Cost Base Year 3 | $784,569.73 | |
| CLIN 004 - Base Year 4 | ||
| Labor - CLIN 004 (Cost Reimbursable) | Estimated Labor Hours | Total Cost |
| Professor I | 2,400 | - 0 |
| Professor II | 3,120 | - 0 |
| Graduate Student I | 4,320 | - 0 |
| Graduate Student II | 4,320 | - 0 |
| Researcher I | 4,320 | - 0 |
| Researcher II | 4,320 | - 0 |
| Subcontractors | - 0 | - 0 |
| Total | 22,800 | - 0 |
| ODCs CLIN 104 (CR) (NTE) | ||
| Materials & Equipment (NTE) | $75,318.69 | |
| Conferences / Training / Workshops (NTE) | $451,912.16 | |
| Travel (NTE) | $75,318.69 | |
| Other Graduate Student Costs (NTE) | $200,849.85 | |
| Total ODCs (NTE) | $803,399.40 | |
| Tota Cost Base Year 4 | $803,399.40 | |
| CLIN 005 - Base Year 5 | ||
| Labor - CLIN 005 (Cost Reimbursable) | Estimated Labor Hours | Total Cost |
| Professor I | 2,400 | - 0 |
| Professor II | 3,120 | - 0 |
| Graduate Student I | 4,320 | - 0 |
| Graduate Student II | 4,320 | - 0 |
| Researcher I | 4,320 | - 0 |
| Researcher II | 4,320 | - 0 |
| Subcontractors | - 0 | - 0 |
| Total | 22,800 | - 0 |
| ODCs CLIN 105 (CR) (NTE) | ||
| Materials & Equipment (NTE) | $77,126.34 | |
| Conferences / Training / Workshops (NTE) | $462,758.06 | |
| Travel (NTE) | $77,126.34 | |
| Other Graduate Student Costs (NTE) | $205,670.25 | |
| Total ODCs (NTE) | $822,680.99 | |
| Tota Cost Base Year 5 | $822,680.99 | |
| CLIN 006 - Option Year 1 | ||
| Labor - CLIN 006 (Cost Reimbursable) | Estimated Labor Hours | Total Cost |
| Professor I | 2,400 | - 0 |
| Professor II | 3,120 | - 0 |
| Graduate Student I | 4,320 | - 0 |
| Graduate Student II | 4,320 | - 0 |
| Researcher I | 4,320 | - 0 |
| Researcher II | 4,320 | - 0 |
| Subcontractors | - 0 | - 0 |
| Total | 22,800 | - 0 |
| ODCs CLIN 106 (CR) (NTE) | ||
| Materials & Equipment (NTE) | $78,977.37 | |
| Conferences / Training / Workshops (NTE) | $473,864.25 | |
| Travel (NTE) | $78,977.37 | |
| Other Graduate Student Costs (NTE) | $210,606.33 | |
| Total ODCs (NTE) | $842,425.33 | |
| Tota Cost Option Year 1 | $842,425.33 | |
| CLIN 007 - Option Year 2 | ||
| Labor - CLIN 007 (Cost Reimbursable) | Estimated Labor Hours | Total Cost |
| Professor I | 2,400 | - 0 |
| Professor II | 3,120 | - 0 |
| Graduate Student I | 4,320 | - 0 |
| Graduate Student II | 4,320 | - 0 |
| Researcher I | 4,320 | - 0 |
| Researcher II | 4,320 | - 0 |
| Subcontractors | - 0 | - 0 |
| Total | 22,800 | - 0 |
| ODCs CLIN 107 (CR) (NTE) | ||
| Materials & Equipment (NTE) | $80,872.83 | |
| Conferences / Training / Workshops (NTE) | $485,236.99 | |
| Travel (NTE) | $80,872.83 | |
| Other Graduate Student Costs (NTE) | $215,660.88 | |
| Total ODCs (NTE) | $862,643.54 | |
| Tota Cost Option Year 2 | $862,643.54 | |
| Total All Periods | ||
| Labor - CLINs 00X (Cost Reimbursable) | Estimated Labor Hours | Total Cost |
| Professor I | 16,800 | $0.00 |
| Professor II | 21,840 | $0.00 |
| Graduate Student I | 30,240 | $0.00 |
| Graduate Student II | 30,240 | $0.00 |
| Researcher I | 30,240 | $0.00 |
| Researcher II | 30,240 | $0.00 |
| Subcontractors | - 0 | - 0 |
| Total | 159,600 | - 0 |
| ODCs CLINs 10X (CR) (NTE) | ||
| Materials & Equipment (NTE) | $527,824.16 | |
| Conferences / Training / Workshops (NTE) | $3,166,944.96 | |
| Travel (NTE) | $527,824.16 | |
| Other Graduate Student Costs (NTE) | $1,407,531.09 | |
| Total ODCs (NTE) | $5,630,124.37 | |
| Tota Cost Option Year 2 | $5,630,124.37 |
Tab A Summary
Offerors must link the proposed cost by labor category from Tab B CLIN Detail to this summary. Offerors must adjust the proposed hours by labor category as necessary to reflect level of effort to the performed by the subcontractors. However, the total estimated labor hours by period must not exceed or be reduced from the hours provided below.
Since Offerors must show the detail for each proposed subcontractor in Tab B CLIN Detail it is not necessary to add rows in this table summary. The Subcontractors line for each period must be used to collect the total hours and cost proposed for all the subcontractors from Tab B CLIN Detail.
Tab B CLIN Detail CLIN Detailed Cost
| Indirect Costs | ||||||||||||
| CLIN | BASE/Option | Prime/Subcontractor | GFY | Labor Cat | Hours | Rate | Labor | Total Cost | ||||
| 001 | BASE Yr 1 | Professor I | 2,400 | $0 | $0 | $0 | ||||||
| Professor II | 3,120 | $0 | $0 | $0 | ||||||||
| Graduate Student I | 4,320 | $0 | $0 | $0 | ||||||||
| Graduate Student II | 4,320 | $0 | $0 | $0 | ||||||||
| Researcher I | 4,320 | $0 | $0 | $0 | ||||||||
| Researcher II | 4,320 | $0 | $0 | $0 | ||||||||
| Total | 22,800 | $0 | $0 | $0 | $0 | $0 | $0 |
| 002 | BASE Yr 2 | Professor I | 2,400 | $0 | $0 | $0 | ||||
| Professor II | 3,120 | $0 | $0 | $0 | ||||||
| Graduate Student I | 4,320 | $0 | $0 | $0 | ||||||
| Graduate Student II | 4,320 | $0 | $0 | $0 | ||||||
| Researcher I | 4,320 | $0 | $0 | $0 | ||||||
| Researcher II | 4,320 | $0 | $0 | $0 | ||||||
| Total | 22,800 | $0 | $0 | $0 | $0 | $0 | $0 |
| 003 | BASE Yr 3 | Professor I | 2,400 | $0 | $0 | $0 | ||||
| Professor II | 3,120 | $0 | $0 | $0 | ||||||
| Graduate Student I | 4,320 | $0 | $0 | $0 | ||||||
| Graduate Student II | 4,320 | $0 | $0 | $0 | ||||||
| Researcher I | 4,320 | $0 | $0 | $0 | ||||||
| Researcher II | 4,320 | $0 | $0 | $0 | ||||||
| Total | 22,800 | $0 | $0 | $0 | $0 | $0 | $0 |
| 004 | BASE Yr 4 | Professor I | 2,400 | $0 | $0 | $0 | ||||
| Professor II | 3,120 | $0 | $0 | $0 | ||||||
| Graduate Student I | 4,320 | $0 | $0 | $0 | ||||||
| Graduate Student II | 4,320 | $0 | $0 | $0 | ||||||
| Researcher I | 4,320 | $0 | $0 | $0 | ||||||
| Researcher II | 4,320 | $0 | $0 | $0 | ||||||
| Total | 22,800 | $0 | $0 | $0 | $0 | $0 | $0 |
| 005 | BASE Yr 5 | Professor I | 2,400 | $0 | $0 | $0 | ||||
| Professor II | 3,120 | $0 | $0 | $0 | ||||||
| Graduate Student I | 4,320 | $0 | $0 | $0 | ||||||
| Graduate Student II | 4,320 | $0 | $0 | $0 | ||||||
| Researcher I | 4,320 | $0 | $0 | $0 | ||||||
| Researcher II | 4,320 | $0 | $0 | $0 | ||||||
| Total | 22,800 | $0 | $0 | $0 | $0 | $0 | $0 |
| 006 | Option Yr 1 | Professor I | 2,400 | $0 | $0 | $0 | ||||
| Professor II | 3,120 | $0 | $0 | $0 | ||||||
| Graduate Student I | 4,320 | $0 | $0 | $0 | ||||||
| Graduate Student II | 4,320 | $0 | $0 | $0 | ||||||
| Researcher I | 4,320 | $0 | $0 | $0 | ||||||
| Researcher II | 4,320 | $0 | $0 | $0 | ||||||
| Total | 22,800 | $0 | $0 | $0 | $0 | $0 | $0 |
| 007 | Option Yr 2 | Professor I | 2,400 | $0 | $0 | $0 | ||||
| Professor II | 3,120 | $0 | $0 | $0 | ||||||
| Graduate Student I | 4,320 | $0 | $0 | $0 | ||||||
| Graduate Student II | 4,320 | $0 | $0 | $0 | ||||||
| Researcher I | 4,320 | $0 | $0 | $0 | ||||||
| Researcher II | 4,320 | $0 | $0 | $0 | ||||||
| Total | 22,800 | $0 | $0 | $0 | $0 | $0 | $0 |
Tab B CLIN Detail
Offerors must link the proposed direct labor and indirect rates populated in Tabs C and D to the table below. If the level of effort is to be divided between prime and subcontractor, the hours must match the hours by labor category and by period that have been provided below.
Offerors can add rows to accomodate proposed effort for subcontractors. Offerors can also add columns to accomodate additional indirect rates as necessary.
The Tab labeled Example CLIN Detail has been provided as an example of the format to be followed.
Example CLIN Detail
| Example Detailed Cost | ||||||||||
| Indirect Costs | ||||||||||
| CLIN | BASE/Option | Prime/Subcontractor | GFY | Labor Cat | Hours | Rate | Labor | Fringe | F&A | Total Cost |
| XXX | BASE Yr 1 | Prime | Professor I | 800 | $10.00 | $8,000.00 | $80.00 | $242.40 | $8,322.40 | |
| Prime | Professor II | 3,120 | $20.00 | $62,400.00 | $624.00 | $1,890.72 | $64,914.72 | |||
| Prime | Graduate Student I | 4,320 | $30.00 | $129,600.00 | $1,296.00 | $3,926.88 | $134,822.88 | |||
| Prime | Graduate Student II | 4,320 | $40.00 | $172,800.00 | $1,728.00 | $5,235.84 | $179,763.84 | |||
| Prime | Researcher I | 2,400 | $50.00 | $120,000.00 | $1,200.00 | $3,636.00 | $124,836.00 | |||
| Prime | Researcher II | 4,320 | $60.00 | $259,200.00 | $2,592.00 | $7,853.76 | $269,645.76 | |||
| Subcontractor 1 | Professor I | 800 | $70.00 | $56,000.00 | $2,800.00 | $4,116.00 | $62,916.00 | |||
| Subcontractor 2 | Professor I | 800 | $80.00 | $64,000.00 | $5,760.00 | $7,673.60 | $77,433.60 | |||
| Subcontractor 3 | Researcher I | 1,920 | $90.00 | $172,800.00 | $22,464.00 | $29,289.60 | $224,553.60 | |||
| Total | 22,800 | $1,044,800.00 | $38,544.00 | $63,864.80 | $1,147,208.80 |
| XXX | BASE Yr 2 | Professor I | 800 | $10.15 | $8,120.00 | $162.40 | $331.30 | $8,613.70 | |
| Professor II | 3,120 | $20.30 | $63,336.00 | $1,266.72 | $2,584.11 | $67,186.83 | |||
| Graduate Student I | 4,320 | $30.45 | $131,544.00 | $2,630.88 | $5,367.00 | $139,541.88 | |||
| Graduate Student II | 4,320 | $40.60 | $175,392.00 | $3,507.84 | $7,155.99 | $186,055.83 | |||
| Researcher I | 2,400 | $50.75 | $121,800.00 | $2,436.00 | $4,969.44 | $129,205.44 | |||
| Researcher II | 4,320 | $60.90 | $263,088.00 | $5,261.76 | $10,733.99 | $279,083.75 | |||
| Subcontractor 1 | Professor I | 800 | $71.05 | $56,840.00 | $3,410.40 | $4,820.03 | $65,070.43 | ||
| Subcontractor 2 | Professor I | 800 | $81.20 | $64,960.00 | $6,496.00 | $8,574.72 | $80,030.72 | ||
| Subcontractor 3 | Researcher I | 1,920 | $91.35 | $175,392.00 | $24,554.88 | $31,991.50 | $231,938.38 | ||
| Total | 22,800 | $1,060,472.00 | $49,726.88 | $76,528.08 | $1,186,726.96 |
Tab C Direct Labor
| EXAMPLE | ||||||||||
| Labor Category | Base Yr 1 | Base Yr 2 | Base Yr 3 | Base Yr 4 | Base Yr 5 | Option Yr 1 | Option Yr 2 | Labor Category | Base Yr 1 | Base Yr 2 |
| Prime Direct Labor Rates | Prime Direct Labor Rates | |||||||||
| Professor I | Professor I | $ 10.00 | $ 10.15 | |||||||
| Professor II | Professor II | $ 20.00 | $ 20.30 | |||||||
| Graduate Student I | Graduate Student I | $ 30.00 | $ 30.45 | |||||||
| Graduate Student II | Graduate Student II | $ 40.00 | $ 40.60 | |||||||
| Researcher I | Researcher I | $ 50.00 | $ 50.75 | |||||||
| Researcher II | Researcher II | $ 60.00 | $ 60.90 | |||||||
| Subcontractor Direct Labor Rates | Subcontractor Direct Labor Rates | |||||||||
| Professor I - (Subcontractor 1) | $ 70.00 | $ 71.05 | ||||||||
| Professor I - (Subcontractor 2) | $ 80.00 | $ 81.20 | ||||||||
| Researcher I (Subcontractor 3) | $ 90.00 | $ 91.35 |
Tab C Direct Labor Rates
Offerors must populate the table below with the proposed direct labor rates by labor category and by period. Offerors must also identify the subcontractor's name as applicable. The table must be linked to Tab B CLIN Detail.
The table to the right has been included as an example of the format to be followed.
Tab D Indirect Rates
| EXAMPLE | ||||||||||
| Indirect Rate | Base Yr 1 | Base Yr 2 | Base Yr 3 | Base Yr 4 | Base Yr 5 | Option Yr 1 | Option Yr 2 | Indirect Rate | Base Year 1 | Base Year 2 |
| Prime Indirect Rates | Prime Indirect Rates | |||||||||
| Fringe | 1% | 2% | ||||||||
| F&A | 3% | 4% | ||||||||
| Subcontractor Indirect Rates | ||||||||||
| Subcontractor 1 | ||||||||||
| Subcontractor Indirect Rates | Fringe | 5% | 6% | |||||||
| F&A | 7% | 8% | ||||||||
| Subcontractor 2 | ||||||||||
| Fringe | 9% | 10% | ||||||||
| F&A | 11% | 12% | ||||||||
| Subcontractor 3 | ||||||||||
| Fringe | 13% | 14% | ||||||||
| F&A | 15% | 16% |
Tab D Indirect Rates Offerors must populate the table below with the proposed indirect rates by period. Offerors must also identify the subcontractor's name as applicable. The table must be linked to Tab B CLIN Detail.
The table to the right has been included as an example of the format to be followed.
File details come from the government source that posted it.