Draft_AIMS_Cost_Price_Workbook.xlsx
XLSX spreadsheet 76 KB Posted
- Attached to
- Ascension Island Mission Services (AIMS) Solicitation FA252119RA017 Federal contract opportunity
- Solicitation number
- FA252119RA017
About this file
This document contains a cost/price workbook template for the Ascension Island Mission Services solicitation FA252119RA017 issued by the Department of the Air Force Space Command. The workbook requires offerors to provide detailed cost and pricing data for the various contract line item numbers, including direct labor hours and rates by labor category, fringe benefits, overhead, general and administrative costs, and fee. Subcontractor proposals and competitive quotes are also required if subcontract costs exceed established thresholds. In addition to the cost/price template, labor escalation rates and indirect cost rates are to be fully supported for each year of the period of performance. This level of cost and pricing detail is commonly required by government agencies in competitive negotiated procurements to facilitate cost realism analysis and determination of price reasonableness.
Draft AIMS Cost Price Workbook
View the file
Other files for this federal contract opportunity
Show all 50
Ascension Island Mission Services (AIMS) Solicitation FA252119RA017 has more files on GovTribe.
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
General Info & Instructions
| AIMS Cost/Price Workbook |
| GENERAL INFORMATION |
| The use of this Workbook is required and must be complete. The purpose of the requested information in the attached worksheets is to assit Government personnel in the review and evaluation of cost proposals submitted by Offerors. Offerors are reminded that the responsibility for providing adequate supporting data and attachments lies solely with them as the as the Cost/Price Workbook is only a portion of the Cost/Price Volume. Further, the offeror must also bear the burden of proof in establishing reasonableness of proposed costs; therefore, it is in the offeror’s best interest to submit a fully supportable and well-prepared cost proposal. The basis and rationale for all proposed costs should be provided as part of the proposal so that Government personnel can place reliance on the information as current, complete and accurate. Further, FAR 15.403-4 sets forth those circumstances in which offerors are required to submit certified cost or pricing data. |
| Instructions: |
TEP Worksheet(All CLIN Roll-up)
| AIMS TEP Worksheet/All CLIN Roll-up | |
| IAW 52.217-8, |
Option to Extend Services
| CLIN | CLIN Type | Service | FY 2020 | FY 2021 | FY 2022 | FY 2023 | FY 2024 | FY 2025 | FY 2026 | Total | ||
| 0700 | FFP | Phase-in Period | $0.00 | $0.00 | ||||||||
| X013 | NSP | Contract Data Requirements List (CDRL) | $0.00 | |||||||||
| X001 | FFP | Program Management | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| X002 | FFP | BOS Services, Logistics, Civil Engineering | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| X003 | CPFF | Communication | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| X004 | CPFF | Space Object Tracking & Maintenance | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| X005 | CPFF | Launch Support & Maintenance | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| X006 | CPFF | Overtime Support | $100,000.00 | $100,000.00 | $100,000.00 | $100,000.00 | $100,000.00 | $50,000.00 | $550,000.00 | |||
| X007 | CR | Contractor Acquired Property (CAP) | $4,778,347.00 | $4,921,697.41 | $5,069,348.33 | $5,221,428.78 | $5,378,071.65 | $2,689,035.83 | $28,057,929.00 | |||
| X008 | CR | Contractor Acquired Services (CAS) | $491,599.00 | $506,346.97 | $521,537.38 | $537,183.50 | $553,299.01 | $276,649.51 | $2,886,615.37 | |||
| X009 | FFP | Royal Air Force Support | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| X010 | CR | NASA MCAT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| X011 | FfP | NASA SHADOZ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| X012 | CR | Vehicles | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $125,000.00 | $1,375,000.00 | |||
| X014 | FFP | Project Support | $750,000.00 | $750,000.00 | $750,000.00 | $750,000.00 | $750,000.00 | $375,000.00 | $4,125,000.00 | |||
| 8000 | FFP | Phase-out Period | $0.00 | |||||||||
| Total Estimated Price | $0.00 | $6,369,946.00 | $6,528,044.38 | $6,690,885.71 | $6,858,612.28 | $7,031,370.66 | $3,515,685.33 | $36,994,544.36 | ü | $36,994,544.36 |
Government Plug Numbers
CLIN 0700
| AIMS CLIN 0700 Phase In Period | |||
| FY 2020 | Total | ||
| 7/1/2020 to 9/30/2020 | |||
| Amount | |||
| Phase-In Cost | $0.00 | ||
| Total Estimated Phase-In Costs | $0.00 | $0.00 | |
| *Offeror must propose a minimum of $5000.00 as a part of this CLIN. |
CLIN X001
| AIMS CLIN X001 Program Management | |||||||
| FY 2021 | FY 2022 | FY 2023 | FY 2024 | FY 2025 | Total | ||
| 10/01/2020 to 9/30/2021 | 10/01/2021 to 9/30/2022 | 10/01/2022 to 9/30/2023 | 10/01/2023 to 9/30/2024 | 10/01/2024 to 9/30/2025 | |||
| Amount | Amount | Amount | Amount | Amount | |||
| Total Subcontractor Cost | $0.00 | ||||||
| Total Prime Cost | $0.00 | ||||||
| Total Estimated Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
CLIN X002
| AIMS CLIN X002 BOS Services, Logistics and Civil Engineering | |||||||
| FY 2021 | FY 2022 | FY 2023 | FY 2024 | FY 2025 | Total | ||
| 10/01/2020 to 9/30/2021 | 10/01/2021 to 9/30/2022 | 10/01/2022 to 9/30/2023 | 10/01/2023 to 9/30/2024 | 10/01/2024 to 9/30/2025 | |||
| Amount | Amount | Amount | Amount | Amount | |||
| Total Subcontractor Cost | $0.00 | ||||||
| Total Prime Cost | $0.00 | ||||||
| Total Estimated Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
CLIN X003
| AIMS CLIN X003 Communication | ||||||||||||||||||
| Direct Labor (DL) (Note 1) | FY 2021 | FY 2022 | FY 2023 | FY 2024 | FY 2025 | Total | ||||||||||||
| 10/01/2020 to 9/30/2021 | 10/031/2021 to 9/30/2022 | 10/01/2022 to 9/30/2023 | 10/01/2023 to 9/30/2024 | 10/01/2024 to 9/30/2025 | ||||||||||||||
| Offeror's Labor Category (NOTE 1) | Base/Hours | Rate | Extended $ | Base/Hours | Rate | Extended $ | Base/Hours | Rate | Extended $ | Base/Hours | Rate | Extended $ | Base/Hours | Rate | Extended $ | Base/Hours | Extended $ | |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | ||||||||||||
| Total Direct Labor Costs | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | ||||||
| Fringe Benefits (F/B) (See Escalation and Indirect Rate Worksheet) | ||||||||||||||||||
| Insert F/B rate title | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0.00 | |||||||
| Insert line(s) & title(s) for any other F/B rates | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0.00 | |||||||
| Total Fringe Benefit Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Labor Overhead (O/H) (See Escalation and Indirect Rate Worksheet) | ||||||||||||||||||
| Insert O/H rate title | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0.00 | |||||||
| Insert line(s) & title(s) for any other O/H rates | $0.00 | $0.00 | $0.00 | $0.00 | $0 | $0.00 | $0.00 | |||||||||||
| Total Labor Overhead Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Subcontracts/Interorganizational Transfer | ||||||||||||||||||
| Subcontract/Interorganizational Name - #01 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Subcontract/Interorganizational Name - #02 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Subcontract/Interorganizational Name - #03 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Insert line(s) for any additional Subcontractors/Interorganizational | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Total Subcontract Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Material Handling (M/H O/H) (See Escalation and Indirect Rate Worksheet) | ||||||||||||||||||
| Insert M/H O/H rate title | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0.00 | |||||||
| Insert line(s) & title(s) for any other M/H O/H rates | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Total Material Handling Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| General and Administrative (G&A) (See Escalation and Indirect Rate Worksheet) | ||||||||||||||||||
| Insert G&A rate title | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0.00 | |||||||
| Insert line(s) & title(s) for any other G&A rates | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Total G&A Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Subtotal Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Facilities Cost of Money (COM) (See Escalation and Indirect Rate Worksheet) | ||||||||||||||||||
| Insert COM rate title | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0.00 | |||||||
| Insert line(s) & title(s) for any other COM rates | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Total Cost of Money | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Total Estimated Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Prime Fee on Subcontract Costs | $0.00 | $0.00 | ||||||||||||||||
| Prime Fixed Fee | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0 | $0.00 | $0.00 | |||||||
| Total Estimated Costs Plus Fixed Fee | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Note 1: Any proposed personnel in the technical proposal should be identified with their labor category. |
&"Arial,Bold"&12&A
Offeror: Page &P of &N Pages &F
CLIN 8000
| AIMS CLIN 8002 Phase Out Period | |||
| FY 2020 | Total | ||
| 7/1/2025 to 9/30/2025 | |||
| Amount | |||
| Phase-Out Cost | $0.00 | ||
| Total Estimated Phase-Out Costs | $0.00 | $0.00 |
Escalation & Indirect Rates
LABOR ESCALATION
| FY 2021 | FY 2022 | FY 2023 | FY 2024 | FY 2025 | FY 2026 | FY 2027 | ||
| Labor Category (Note 1) | Base Rate (Wage Determination or CBA) | Escalation Rate | Escalation Rate | Escalation Rate | Escalation Rate | Escalation Rate | Escalation Rate | Escalation Rate |
| Program Manager | 2.30% | 2.10% | 2.20% | 2.30% | 2.30% | 2.10% | 2.20% | |
| Logistics | xx | xx | xx | xx | xx | xx | xx |
| Indirect Rates (Note 2) | |||||||
| FY21 | FY22 | FY23 | FY24 | FY25 | FY26 | FY27 | |
| Rate Category | |||||||
| Fringe Benefits | |||||||
| Labor Overhead | |||||||
| Material Handling | |||||||
| General and Administrative | |||||||
| Facilities Cost of Money |
| Basis of Rate | Applied Against | Note 1: |
| Provisional Billing Rate | ||
| Forward Pricing Rate Agreement | ||
| Note 2: |
Subcontractor
| SUBCONTRACTOR COST DATA |
| Subcontracts/Interorganizational Transfers – A cost proposal as detailed as the Offeror’s cost proposal including support documentation will be required to be submitted by all proposed subcontractors and for all interorganizational transfers over $100,000. If opitons are proposed, the option periods should be separately priced. The subcontract or interorganizational transfer proposal, along with supporting documentation, must be provided either in a sealed envelope with the prime’s proposal or via email directly to the Program Officer or Contract Specialist upon request. The email should identify the prime Offeror, proposal title, and that the attached proposal is a subcontract. The subcontractor and interorganizational transfer proposals with supporting documentation must be received and reviewed before the Government can complete its cost analysis of the proposal and enter negotiations. |
REVIEW ALL INFORMATION THIS TAB MAY NOT BE NEEDED
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.
Certified cost or pricing data may be required for subcontractor proposals over $750,000.
*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.
| Subcontractor | Competitive/Sole Source | Cost/price analysis included (Y/N) | Competitive Quotes or Sole Source Documentation Included (Y/N) | Total amount exceeds $650K (Y/N) |
| ABC Company | Competitive | Y | Y | N |
| XYZ Company | Sole Source | Y | Y | Y |
&"Arial,Bold"&12&A
Offeror: Page &P of &N Pages &F
Labor Rates Listing
| Labor Rates Listing | ||||||||||
| FY 2021 | FY 2022 | FY 2023 | FY 2024 | FY 2025 | FY 2026 | FY 2027 | ||||
| Proposed Labor Catagories | Wage Rate | |||||||||
| per hour | Labor Burdens | Fee | Total Labor Cost per Hour | Wage Rate | ||||||
| per hour | Labor Burdens | Fee | Total Labor Cost per Hour | Wage Rate | ||||||
| per hour | Labor Burdens | Fee | Total Labor Cost per Hour | Wage Rate | ||||||
| per hour | Labor Burdens | Fee | Total Labor Cost per Hour | Wage Rate | ||||||
| per hour | Labor Burdens | Fee | Total Labor Cost per Hour | Wage Rate | ||||||
| per hour | Labor Burdens | Fee | Total Labor Cost per Hour | Wage Rate | ||||||
| per hour | Labor Burdens | Fee | Total Labor Cost per Hour | |||||||
| Labor Cat 1 | ||||||||||
| Labor Cat 2 | ||||||||||
| Labor Cat 3 | ||||||||||
| Labor Cat 4 | ||||||||||
| Etc… |
DCAA and Accounting System DCAA and Accounting System
| PART 1 (To Be Completed by Contractor) | Page 1/2 | |
| 1. Contractor Name: | 3. Contractor CAGE Code: |
| 1A. Contractor POC Name/Phone: | 4. RFP No. and/or Contractor's Prop. No.: |
| 2. Contractor's Address: |
5. Total Dollar Amount:
| 6. Type of Proposal (FFP/CPFF/CPAF/CPIF/Other: |
| *Note: Primes shall NOT propose T&M; subcontractors without approved accounting system may propose T&M |
7. Subcontractor To: (if applicable)
8. Period of Performance:
| 9. PROVIDE NAME, ADDRESS, TELEPHONE NUMBER AND E-MAIL ADDRESS FOR THE FOLLOWING (if available) | |
| A. CONTRACT ADMINISTRATION OFFICE (DCMA) | B. AUDIT OFFICE (DCAA) |
10. DO YOU HAVE AN ADEQUATE ACCOUNTING SYSTEM AS DETERMINED BY DCAA OR ANOTHER AGENCY? 11A. DO YOU REQUIRE GOVERNMENT CONTRACT FINANCING TO PERFORM THIS PROPOSED CONTRACT?(FFP ONLY) (If "Yes," complete Item 11B) 11B. TYPE OF FINANCING (Mark "x" for one type)
SPECIFY STATUS OF ACCOUNTING SYSTEM
12. HAS THE CONTRACTOR BEEN AWARDED ANY CONTRACTS OR SUBCONTRACTS FOR THE SAME OR SIMILAR ITEMS WITHIN THE PAST 3 YEARS? (If "Yes," identify item(s), customer(s), and contract number(s)) 13. IS THIS PROPOSAL CONSISTENT WITH ESTABLISHED ESTIMATING & ACCOUNTING PRACTICES & PROCEDURES & FAR PART 31 COST PRINCIPLES? (If "No," explain)
PART 2 Contractors complete 14A and 14B "Proposed" categories and rates. DCAA please complete recommendations/basis for recommendation columns and address additional request for information
14. INFORMATION REQUESTED: Page 2/2
| 14A. Direct Labor Categories and/or | Base Year | DCAA Recommended | *Basis of DCAA | 16. Requesting Office Information (to be completed by Contracting Officer) |
| Employee Name if Actuals Proposed | Proposed Rates | Rates | Recommendation | Contracting Officer: |
| Phone Number: |
| E-Mail Address: |
*Based on Floor Check/Audit Performed, etc and Date
| 14B. Indirect Rates | FY21 | FY22 | FY23 | FY24 | FY25 | FY26 | FY27 | |||||||
| Proposed: | DCAA Rates* | Proposed: | DCAA Rates | Proposed: | DCAA Rates | Proposed: | DCAA Rates | Proposed: | DCAA Rates | Proposed: | DCAA Rates | Proposed: | DCAA Rates | |
| Contractor Site OH: | ||||||||||||||
| Government Site OH: | ||||||||||||||
| Fringe: | ||||||||||||||
| G&A: | ||||||||||||||
| Cost of Money: | ||||||||||||||
| Escalation: | ||||||||||||||
| *Include basis of recommendation/date |
| 15. ADDITIONAL INFORMATION (TO BE COMPLETED BY CONTRACTING OFFICER) |
| 1). If no audit has been performed within the last 12 months, please provide a copy of the contractor's most recent payroll run and a copy of the last audit report, if available. |
| 2). Please indicate if contractor has an approved accounting system in order to award a cost type contract. Include Audit Report Number and Date of when the accounting system was approved |
| 3). Additional info requested (uncompensated overtime, weighted averages, etc) |
Yes No Yes No
ADVANCE PAYMENTS
GUARANTEED LOANS
Yes No Yes No Yes No Yes No
PROGRESS PAYMENTS
Yes No Yes No
File details come from the government source that posted it. Updated .