C5.Attachment 7 - Pricing Spreadsheet (Excel) rev 1.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- N0001426R4005
- Solicitation number
- N0001426R4005
About this file
This is a Pricing Spreadsheet template for a federal service contract proposal. The spreadsheet is designed for offerors to submit pricing for labor and other direct costs (ODCs) across a base year plus four optional extension years. The contract structure includes six labor categories: Technology Specialist, Senior Technology Analyst, Lead Technology Specialist, Technology Analyst (two positions), and System Tester, each with 1,920 hours allocated per year. All labor is priced on a Firm Fixed Price (FFP) basis with fully burdened rates that must not exceed the service contracting tripwire of $250 per hour inclusive of all indirect costs and fee.
The pricing framework establishes a baseline contract value of $500,000 in ODCs across the base and four option years (CLINs 7000-7400 at $100,000 per year), with an additional $50,000 ODC allocation under FAR 52.217-8 for a six-month extension period, bringing the total potential contract value to $550,000. Offerors must populate the spreadsheet with direct labor rates, fringe percentages, overhead, G&A, and fee markups, with the template automatically calculating fully burdened rates. The spreadsheet includes sections for prime contractor and up to ten subcontractors, requiring offerors to document competitive or sole-source justifications, cost/price analyses, and ensure subcontractor costs and hours align with detailed proposals. All labor categories and indirect rates must be verified by offerors to ensure accuracy, and subcontractor effort cannot exceed 70 percent of total contract effort without additional supporting information.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Solicitation Amendment N0001426R40050001 SF 30.pdf | ||
| C5.Attachment 3 - Past Performance Information Form rev1.docx | DOCX document | |
| Attachment 8 - Q and A.xlsx | XLSX spreadsheet | |
| C5.Attachment 5 - Technical Evaluation Form Sub-Factor 1.2 (Excel) rev1.xlsx | XLSX spreadsheet |
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
Pricing Worksheet
| Price Proposal - Total Amount: |
| Prime Offeror: ENTER NAME HERE |
| Subcontractor: ENTER NAME HERE IF APPLICABLE |
| Base, Year 1 | Summary of Costs | ||||||||||
| CLIN | Labor Category | Fully Burdened Rate | # of Hour Proposed | Total | Last Name | Prime/Sub/Both | Base, Year 1 | Note: Per the TOR Instruction to Offerors, the Travel and ODCs amounts are government-provided | |||
| 5000 | Technology Specialist | $ - 0 | 1,920 | $ - 0 | FFP | Labor (CLINs 5000 - 5005) | $ - 0 | NTE amounts. Offerors shall not change given NTE amounts, but shall ensure that they are | |||
| 5001 | Senior Technology Analyst | $ - 0 | 1,920 | $ - 0 | COST | ODC (CLIN 30007000) | $ 100,000.00 | included in the Overall Total Amount. | |||
| 5002 | Lead Technology Specialist | $ - 0 | 1,920 | $ - 0 | $ 100,000.00 | ||||||
| 5003 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | Option I, Year 2 | List of Acronyms | |||||
| 5004 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | FFP | Labor (CLINs 5100 - 5105) | $ - 0 | FFP - Firm Fixed Price | |||
| 5005 | System Tester | $ - 0 | 1,920 | $ - 0 | COST | ODC (CLIN 7100) | $ 100,000.00 | ODCs - Other Direct Costs | |||
| 11,520 | $ - 0 | $ 100,000.00 | |||||||||
| Option I, Year 2 | Option II, Year 3 | ||||||||||
| Labor Category | Fully Burdened Rate | # of Hour Proposed | Total | Last Name | Prime/Sub/Both | FFP | Labor (CLINs 5200 - 5205) | $ - 0 | |||
| 5100 | Technology Specialist | $ - 0 | 1,920 | $ - 0 | COST | ODC (CLIN 7200) | $ 100,000.00 | ||||
| 5101 | Senior Technology Analyst | $ - 0 | 1,920 | $ - 0 | $ 100,000.00 | ||||||
| 5102 | Lead Technology Specialist | $ - 0 | 1,920 | $ - 0 | Option III, Year 4 | ||||||
| 5103 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | FFP | Labor (CLINs 5300 - 5305) | $ - 0 | ||||
| 5104 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | COST | ODC (CLIN 7300) | $ 100,000.00 | ||||
| 5105 | System Tester | $ - 0 | 1,920 | $ - 0 | $ 100,000.00 | ||||||
| 11520 | $ - 0 | Option IV, Year 5 | |||||||||
| Option II, Year 3 | FFP | Labor (CLINs 5400 - 5405) | $ - 0 | ||||||||
| Labor Category | Fully Burdened Rate | # of Hour Proposed | Total | Last Name | Prime/Sub/Both | COST | ODC (CLIN 7400) | $ 100,000.00 | |||
| 5200 | Technology Specialist | $ - 0 | 1,920 | $ - 0 | $ 100,000.00 | ||||||
| 5201 | Senior Technology Analyst | $ - 0 | 1,920 | $ - 0 | Contract Value | ||||||
| 5202 | Lead Technology Specialist | $ - 0 | 1,920 | $ - 0 | FFP | Labor (CLINs 5000 - 5405) | $ - 0 | ||||
| 5203 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | COST | ODC (CLINs 7000 -7400) | $ 500,000.00 | ||||
| 5204 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | Contract Total Amount: | $ 500,000.00 | |||||
| 5205 | System Tester | $ - 0 | 1,920 | $ - 0 | FAR 52.217-8(Six (6) Month Extension) | Hours | |||||
| 11,520 | $ - 0 | FFP | Labor (CLINs 5400 - 5405) | $ - 0 | 5,760 | ||||||
| Option III, Year 4 | COST | ODC (CLIN 7400) | $ 50,000.00 | ||||||||
| Labor Category | Fully Burdened Rate | # of Hour Proposed | Total | Last Name | Prime/Sub/Both | FAR 52.217-8 Overall Total Amount : | $ 50,000.00 | ||||
| 5300 | Technology Specialist | $ - 0 | 1,920 | $ - 0 | |||||||
| 5301 | Senior Technology Analyst | $ - 0 | 1,920 | $ - 0 | Contract value with FAR 52.217-8 | Hours | |||||
| 5302 | Lead Technology Specialist | $ - 0 | 1,920 | $ - 0 | FFP | Labor (CLINs 5000 - 5405) | $ - 0 | 63,360 | |||
| 5303 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | COST | ODC (CLIN 7000 -7400) | $ 550,000.00 | ||||
| 5304 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | Contract Total Amount: | $ 550,000.00 | |||||
| 5305 | System Tester | $ - 0 | 1,920 | $ - 0 | |||||||
| 11,520 | $ - 0 | ||||||||||
| Option IV, Year 5 | |||||||||||
| Labor Category | Fully Burdened Rate | # of Hour Proposed | Total | Last Name | Prime/Sub/Both | ||||||
| 5400 | Technology Specialist | $ - 0 | 1,920 | $ - 0 | |||||||
| 5401 | Senior Technology Analyst | $ - 0 | 1,920 | $ - 0 | |||||||
| 5402 | Lead Technology Specialist | $ - 0 | 1,920 | $ - 0 | |||||||
| 5403 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | |||||||
| 5404 | Technology Analyst | $ - 0 | 1,920 | $ - 0 | |||||||
| 5405 | System Tester | $ - 0 | 1,920 | $ - 0 | |||||||
| 11,520 | $ - 0 |
Subcontractor
| SUBCONTRACTOR COST DATA | Prime 1 (Fill-in) | ||
| For each subcontractor, enter labor hours and the total cost for the base year and each option year. | ***Source Selection Information. See FAR 3.104*** | ||
| The subcontractors labor hours by labor category should be the same as subcontractor hours in the Labor Hours Skill Summary format. |
| **Note: The Offeror shall ensure that their Subcontractor hours and total cost inputs match the Subcontractors detailed cost proposal for both hours and cost |
| Prime Offerors are responsible for verifying that the subcontractor proposals total costs and hours are the same the Total Amount and Base - O IV Tab. |
| ***Subcontractor hours and costs entered in this spreadsheet are for demonstration purposes only*** |
| Delete all titles and rates that are not applicable. |
| Base Year | ||||||||||||||
| (12 Months) | Option 1 | |||||||||||||
| (12 Months) | Option 2 | |||||||||||||
| (12 Months) | Option 3 | |||||||||||||
| (12 Months) | Option 4 | |||||||||||||
| (12 Months) | TOTAL | |||||||||||||
| Company Name | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Total Cost | ||
| 1 | Subcontractor #1 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| 2 | Subcontractor #2 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| 3 | Subcontractor #3 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| 4 | Subcontractor #4 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| 5 | Subcontractor #5 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| 6 | Subcontractor #6 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| 7 | Subcontractor #7 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| 8 | Subcontractor #8 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| 9 | Subcontractor #9 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| 10 | Subcontractor #10 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |
| TOTAL SUBCONTRACTORS | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||
| Enter Subcontractor Information Below | ||||||||||||||
| Subcontractor | CAGE | |||||||||||||
| Code | Competitive/Sole Source | Cost/price analysis included (Y/N) | Type of Subcontract (i.e., Fixed Price, Time and Materials, etc.) | Competitive Quotes or Sole Source Documentation Included (Y/N) |
The prime contractor should perform and provide a cost/price analysis of each subcontractor’s cost proposal. Offerors are required to obtain competition to the maximum extent practicable when selecting subcontractors; if the offeror has obtained competitive quotes, copies should be provided. If the Offeror has selected other than the low bid for inclusion in their proposal or intends to award the subcontract on a sole-source basis, the offeror should provide rationale for their decision. For sole-sourced subcontracts, the prime contractor must provide a short sole-source justification.
*Note: Federal Acquisition Regulation provision 52.215-22 is incorporated into this solicitation by reference. The offeror is to exclude excessive pass-through charges from subcontractors. The offeror must identify in its proposal the percentage of effort it intends to perform and the percentage to be performed by each of its proposed subcontractors. If more than 70 percent of the total effort will be performed through subcontractors, the offeror must include the additional information required by the above-cited clause.
| Insert Subcontractor/Consultant Name | FTE's being Provided (Include number of FTE's and LCATs) | CAGE Code | Contract Type | Identify if the Subcontractor was selected competitively or via sole source | Base | Hours | Total | Option I | Hours | Total | Option II | Hours | Total | Option III | Hours | Total | Option IV | Hours | Total | Overall Total Hours | Overall Total Dollars | |
| 1 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||
| 2 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||
| 3 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||
| 4 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||
| 5 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||
| Total Per Period of Performance | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
Tripwire
| This spreadsheet calculates the loaded labor rates (with fee) for the base year and option years after all cost summary format inputs and calculations are completed. |
| * It is the Offerors responsibility to make sure the Labor Category matches the correct Direct Labor Rate and that all Indirect Rates are correct - including formulas |
| Rates below are for EXAMPLE PURPOSES ONLY |
| The service contracting tripwire applicable to the base and all option periods for this solicitation is a fully burdened labor rate of $250 per hour. This tripwire applies to prime, subcontract, and consultant labor inclusive of all subcontractor, consultant, and prime contractor indirect costs and applicable fee or profit |
| Base Year (12 months) | ||||||||||||||
| CLIN | Skill Mix/Labor Category | Site | Direct Labor $ w/Esc | Fringe % | Direct Labor With Fringe | O/H % | Direct Labor With Fringe & O/H | G&A % | Direct Labor With Fringe, O/H, & G&A | Fee % | Direct Labor With Fringe, O/H, G&A, & Fee | FCCOM % | M&H on Sub Labor | TOTAL COST |
Direct Labor With Fringe, O/H, G&A, FCCOM (with Fee) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
| 5000 | Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5001 | Senior Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5002 | Lead Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5003 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5004 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5005 | System Tester | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| Option Period 1 (12 months) | ||||||||||||||
| CLIN | Skill Mix/Labor Category | Site | Direct Labor $ w/Esc | Fringe % | Direct Labor With Fringe | O/H % | Direct Labor With Fringe & O/H | G&A % | Direct Labor With Fringe, O/H, & G&A | Fee % | Direct Labor With Fringe, O/H, G&A, & Fee | FCCOM % | M&H on Sub Labor | TOTAL COST |
Direct Labor With Fringe, O/H, G&A, FCCOM (with Fee) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
| 5100 | Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5101 | Senior Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5102 | Lead Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5103 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5104 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5105 | System Tester | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| Option Period 2 (12 months) | ||||||||||||||
| CLIN | Skill Mix/Labor Category | Site | Direct Labor $ w/Esc | Fringe % | Direct Labor With Fringe | O/H % | Direct Labor With Fringe & O/H | G&A % | Direct Labor With Fringe, O/H, & G&A | Fee % | Direct Labor With Fringe, O/H, G&A, & Fee | FCCOM % | M&H on Sub Labor | TOTAL COST |
Direct Labor With Fringe, O/H, G&A, FCCOM (with Fee) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
| 5200 | Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5201 | Senior Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5202 | Lead Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5203 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5204 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5205 | System Tester | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| Option Period 3 (12 months) | ||||||||||||||
| CLIN | Skill Mix/Labor Category | Site | Direct Labor $ w/Esc | Fringe % | Direct Labor With Fringe | O/H % | Direct Labor With Fringe & O/H | G&A % | Direct Labor With Fringe, O/H, & G&A | Fee % | Direct Labor With Fringe, O/H, G&A, & Fee | FCCOM % | M&H on Sub Labor | TOTAL COST |
Direct Labor With Fringe, O/H, G&A, FCCOM (with Fee) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
| 5300 | Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5301 | Senior Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5302 | Lead Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5303 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5304 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| 5305 | System Tester | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 | |
| Option Period 4 (12 months) | ||||||||||||||
| CLIN | Skill Mix/Labor Category | Site | Direct Labor $ w/Esc | Fringe % | Direct Labor With Fringe | O/H % | Direct Labor With Fringe & O/H | G&A % | Direct Labor With Fringe, O/H, & G&A | Fee % | Direct Labor With Fringe, O/H, G&A, & Fee | FCCOM % | M&H on Sub Labor | TOTAL COST |
Direct Labor With Fringe, O/H, G&A, FCCOM (with Fee) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
| 5400 | Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 |
| 5401 | Senior Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 |
| 5402 | Lead Technology Specialist | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 |
| 5403 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 |
| 5404 | Technology Analyst | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 |
| 5405 | System Tester | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | 0.00% | $0.00 |
File details come from the government source that posted it. Updated .