Attachment H - Subcontractor_Cost_Summary_Format.xlsx
XLSX spreadsheet 37 KB Posted
- Solicitation number
- N0017421R0009
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amendment 0002 -N00174-21-R-0009.pdf | ||
| Amendment 01 N00174-21-R-0009.pdf | ||
| Attachment_G_Prime_Cost_Summary_Format-REV 1_12 Jan_21.xlsx | XLSX spreadsheet | |
| Attachment H - Subcontractor_Cost_Summary_Format-REV 1_12 Jan 2021.xlsx | XLSX spreadsheet | |
| Attachment B -CDRL 005.pdf | ||
| Attachment B-CDRL 003.pdf | ||
| Attachment B -CDRL 006.pdf | ||
| Attachment_G_Prime_Cost_Summary_Format.xlsx | XLSX spreadsheet | |
| Attachment_B_CDRL_001.pdf | ||
| Attachment_B_CDR_004.pdf | ||
| Attachment B -CDRL 002.pdf | ||
| N00174_21_R_0009.pdf | ||
| Attachment_D_DD_254.pdf | ||
| Attachment_C_QASP.pdf | ||
| Attachment_F_Past_Performance_Questionnaire.pdf | ||
| Attachment_I_Personnel_Qualifications.docx | DOCX document | |
| Attachment_E_Past_Performance_Matrix.pdf |
Show all 17
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
CPFF
SOLICITATION N00174-21-R-0009 - ATTACHMENT H- SUBCONTRACTOR COST SUMMARY FORMAT
| Prime Offeror Name: | |||||||||||||||||||||
| Subcontractor Name(s) (if applicable): | |||||||||||||||||||||
| DCAA Point(s) of Contact Information: | |||||||||||||||||||||
| Total for All Years | Base Year - Year 1 | Option Year 1 - Year 2 | Option Year 2 - Year 3 | Option Year 3 - Year 4 | Option Year 4 - Year 5 | ||||||||||||||||
| Cost Elements | Labor Category | eCRAFT Labor Category | Employee Name | Government Labor Category (Senior, Mid, Junior) | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount |
| Prime Contractor Labor Cost | |||||||||||||||||||||
| Prime Contractor Direct Labor | |||||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||||
| Etc. | |||||||||||||||||||||
| Total Direct Labor Cost | |||||||||||||||||||||
| Prime Contractor Indirect Labor Cost | |||||||||||||||||||||
| Overhead | |||||||||||||||||||||
| Fringe Benefits | |||||||||||||||||||||
| G&A | |||||||||||||||||||||
| Total Indirect Labor Cost | |||||||||||||||||||||
| Total Direct and Indirect Labor cost | |||||||||||||||||||||
| COM | |||||||||||||||||||||
| Total Prime Contractor Labor Cost |
| Subcontractor Labor Cost |
| Subcontractor proposed cost and fee |
| Subcontractor 1 |
| Subcontractor 2 |
| Etc. |
| Total proposed subcontractor labor cost and fee |
| Prime contractor pass through (not including fee) |
| Handling |
| G&A |
| Other (if any) |
| Total pass through (not including fee) |
| Total Subcontractor Cost including pass through |
Total Labor Cost (Prime and Subcontractor Labor)
| Fixed Fee |
| Total Labor Hours |
| Fixed Fee on Subcontractors |
| Fixed Fee on Prime Labor |
Total Labor Cost Plus Fixed Fee (CPFF)
| Other Direct Costs | ||||||
| Travel | $ 509,000.00 | $ 85,000.00 | $ 103,000.00 | $ 105,000.00 | $ 106,000.00 | $ 110,000.00 |
| Materials/Supplies | $ 1,355,000.00 | $ 150,000.00 | $ 255,000.00 | $ 300,000.00 | $ 300,000.00 | $ 350,000.00 |
| Any adders to ODCs such as G&A (cost only - no fee) | $ 335,520.00 | $ 42,300.00 | $ 64,440.00 | $ 72,900.00 | $ 73,080.00 | $ 82,800.00 |
| Total ODCs | $ 2,199,520.00 | $ 277,300.00 | $ 422,440.00 | $ 477,900.00 | $ 479,080.00 | $ 542,800.00 |
Total CPFF all CLINs (Labor and ODCs)
| Pass Through Analysis - Total for All Years | Amount | Amount | Percent |
| Subcontractor proposed cost and fee | |||
| Pass Through Amount (not including fee) | |||
| Prime Contractor Fee for Subcontractor Labor * | |||
| Total Pass Through Amount (including fee) | ERROR:#DIV/0! | ||
| Maximum Pass Through Allowed by SeaPort-e IDIQ Contract | 8% |
| Fee Analysis - Total for All Years | Amount | Amount | Percent |
| Prime Contractor Labor Cost | |||
| Target Fee for Labor Performed by Prime Contractor |
* When analyzing pass through costs, the Government will consider prime offeror fee on subcontractor price as an element of pass through as explained in the Section H Savings Clause of the MACs. In Section B, however, prime offeror fee on subcontractor price is a fee element rather than a cost element. Prime offeror fee on subcontractor price should be included in the fee column (rather than the cost column) of Section B.
Supporting Cost Data Summary
SUPPORTING COST DATA XXXXX-XX-X-XXXX
| Direct Labor: | Actual Current Labor Rate | Proposed Base Period Labor Rate | Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCAA recommended rates, if known. |
| Employee Name | $ | $ | |
| Employee Name | $ | $ | |
| Employee Name | $ | $ |
| Indirect Rates: | Current Rate | Proposed Base Rate | Subject to FPRA? (Yes/No) Reason for difference between current rates and proposed rates. Reason for difference between proposed rates and DCAA recommended rates, if known. |
| Fringe | |||
| Overhead | |||
| G&A | |||
| Other |
Additional brief narrative in accordance with Section L.
Indirect Rate Support
Sample Indirect Rate Supporting Documentation
| SAMPLE | Budget | Actual Expenses | |||
| Overhead Expense | 2011 | 2010 | 2009 | 2008 | SAMPLE |
| Payroll Taxes | $ 110,000 | $ 93,000 | $ 90,000 | $ 85,000 | |
| Vacation | $ 50,000 | $ 46,000 | $ 43,000 | $ 42,000 | |
| Holiday | $ 40,000 | $ 40,000 | $ 39,000 | $ 38,500 | |
| Sick Leave | $ 10,000 | $ 9,000 | $ 8,000 | $ 7,000 | |
| Pensions | $ 200,000 | $ 175,000 | $ 165,000 | $ 155,000 | |
| Office Equipment | $ 5,000 | $ 6,000 | $ 65,000 | $ 3,000 | |
| Depreciation | $ 4,000 | $ 1,000 | $ 4,000 | $ 2,000 | |
| Travel | $ 40,000 | $ 35,000 | $ 33,000 | $ 33,000 | |
| Reproduction | $ 10,000 | $ 9,800 | $ 9,700 | $ 9,600 | |
| Rent | $ 130,000 | $ 82,000 | $ 75,000 | $ 68,000 | |
| Advertising | $ 55,000 | $ 44,000 | $ 50,000 | $ 42,000 | SAMPLE |
| Insurance | $ 48,000 | $ 46,000 | $ 44,000 | $ 42,000 | |
| Telephone | $ 12,000 | $ 12,000 | $ 11,500 | $ 10,000 | |
| Total Pool | $ 714,000 | $ 598,800 | $ 637,200 | $ 537,100 | |
| SAMPLE | |||||
| Less Unallowable Costs | |||||
| Entertainment | $ 6,000 | $ 4,000 | $ 1,000 | $ 3,000 | |
| Net Allowable Costs | $ 708,000 | $ 594,800 | $ 636,200 | $ 534,100 | SAMPLE |
| Allocation Base | ||||
| Direct Labor | $ 1,895,500 | $ 1,756,200 | $ 1,650,000 | $ 1,530,000 |
Overhead Rate 37.35% 33.87% 38.56% 34.91%
| *Contributing Government Contracts | Expiration Date | Value of Contracts | |
| N000XX-XX-X-00XX | 6/1/11 | ||
| N000XX-XX-X-00XX | 9/1/12 | SAMPLE | |
| N000XX-XX-X-00XX | 8/1/10 |
| * When developing your percentage, these are the contracts contributing |
| to development of the percentage. |
File details come from the government source that posted it. Updated .