Attachment_J.4_-_Cost_Summary_Format.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- AN/SPA-25H Production & Services Federal contract opportunity
- Solicitation number
- N0017818R5001
About this file
Attachment J.4 - Cost Summary Format
View the file
Other files for this federal contract opportunity
Show all 28
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
CPFF Cost Summary
| N00024-18-R-5001, ATTACHMENT J.4 | |||||||||||||||||||
| COST SUMMARY FORMAT | |||||||||||||||||||
| Prime Offeror Name: | |||||||||||||||||||
| Subcontractor Name (if applicable): | |||||||||||||||||||
| DCAA Point of Contact Information: | |||||||||||||||||||
| KEY? | Total for All Years | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||
| Cost Elements | Labor Category | Y / N | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount |
| LABOR CLINs | |||||||||||||||||||
| Prime Contractor Direct Labor Cost | |||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||
| Labor Category Average Rate per Year | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Total Direct Labor Cost | |||||||||||||||||||
| Prime Contractor Indirect Labor Cost | |||||||||||||||||||
| Fringe Benefits | |||||||||||||||||||
| Overhead | |||||||||||||||||||
| G&A | |||||||||||||||||||
| Total Indirect Labor Cost | |||||||||||||||||||
| Total Prime Direct and Indirect Labor Cost | |||||||||||||||||||
| FCCM | |||||||||||||||||||
| 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) | |||||||||||||||||||
| Fee | |||||||||||||||||||
| Prime Contractor Fee for Prime Contractor Labor | |||||||||||||||||||
| Fixed Fee | |||||||||||||||||||
| Prime Contractor Fee for Subcontractor Labor * | |||||||||||||||||||
| Fixed Fee | |||||||||||||||||||
| Total Fee (for Prime and Subcontractor Labor) | |||||||||||||||||||
| Total Fixed Fee | |||||||||||||||||||
| TOTAL LABOR COST PLUS INCENTIVE FEE | |||||||||||||||||||
| OTHER DIRECT COSTS (ODC) CLINs | |||||||||||||||||||
| Prime Contractor ODC | |||||||||||||||||||
| Travel | |||||||||||||||||||
| ODC | |||||||||||||||||||
| Subtotal ODC | |||||||||||||||||||
| Prime Burdens on ODC | |||||||||||||||||||
| Material Handling | |||||||||||||||||||
| G&A | |||||||||||||||||||
| Other (Specify each separately) | |||||||||||||||||||
| Subtotal Burden on Prime ODCs | |||||||||||||||||||
| Subcontractor ODC | |||||||||||||||||||
| Travel | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Subtotal Subcontractor Travel | |||||||||||||||||||
| ODC | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Subtotal Subcontractor ODC | |||||||||||||||||||
| Total Subcontractor Travel and ODC | |||||||||||||||||||
| Prime Burdens on Subcontractor ODC | |||||||||||||||||||
| Material Handling | |||||||||||||||||||
| G&A | |||||||||||||||||||
| Other (Specify each separately) | |||||||||||||||||||
| Subtotal Prime Burden on Subcontractor ODC | |||||||||||||||||||
| TOTAL TRAVEL AND ODC CLINS | |||||||||||||||||||
| TOTAL ALL CLINS (LABOR AND ODC) |
| Pass Through Analysis - Total for All Years | 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! |
Supporting Cost Data
SUPPORTING COST DATA
| Direct Labor: | Actual Current Labor Rate | Effective Date of Current 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 (list) |
Sample Indirect Rate Supp. Doc.
Sample Indirect Rate Supporting Documentation
| Budget | PRIOR YEAR ACTUALS | |||
| Overhead Expense | Year (BY) | BY - 1 | BY - 2 | BY - 3 |
| 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 |
| 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 |
| Less Unallowable Costs | ||||
| Entertainment | $ 6,000 | $ 4,000 | $ 1,000 | $ 3,000 |
| Net Allowable Costs | $ 708,000 | $ 594,800 | $ 636,200 | $ 534,100 |
| 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 | |
| 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.