Attachment S-1- Pricing Worksheet.xls
XLS spreadsheet 45 KB Posted
- Attached to
- Maintenance Support for Inactive Ships in Bremerton, WA and CG/LSD Modernization Support in San Diego, CA
- Solicitation number
- N00024-17-R-4404
About this file
Attachment S-1
View the file
Other files
Show all 40
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
| ATTACHMENT S-1 - 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 | 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 | ||||||||||||||||||||
| Prime Contractor Fixed Fee for Prime Contractor Labor | ||||||||||||||||||||
| Prime Contractor Fixed Fee for Subcontractor Labor * | ||||||||||||||||||||
| Total Fixed Fee (for Prime and Subcontractor Labor) | ||||||||||||||||||||
| Total Labor Cost Plus Fixed Fee (CPFF) | ||||||||||||||||||||
| Other Direct Costs | ||||||||||||||||||||
| Other Direct Costs (ODCs) | ||||||||||||||||||||
| Any adders to ODCs such as G&A (cost only - no fee) | ||||||||||||||||||||
| Total ODCs | ||||||||||||||||||||
| Total CPFF all CLINs (Labor and ODCs) | ||||||||||||||||||||
| Fee Analysis - Total for All Years | Amount | Amount | Percent | |||||||||||||||||
| Prime Contractor Labor Cost | ||||||||||||||||||||
| Fee for Labor Performed by Prime Contractor |
Supporting Cost Data Summary
| SUPPORTING COST DATA | |||
| 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 .