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
Issued by
Department of the Air Force Space Command

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

Other files attached to Ascension Island Mission Services (AIMS) Solicitation FA252119RA017, newest first.
File Type Posted
Attachment_1_-_AIMS_PWS_18-October-2019.pdf PDF
SB_Guide_Facility_Clearance_Process.pdf PDF
Answers_to__Atch_L-01_Question_&_Answer_Rev_5.xlsx XLSX spreadsheet
Solicitation_Amendment_-_FA252119RA0170004.pdf PDF
Attachment_17_-_CBA_WCFS_-_IBEW_01_Sep_2018_-_30_Sep_2021.pdf PDF
Attachment_3_-_AIMS_GFP_Listing_30_Sep_19.pdf PDF
Attachment_L-03_AIMS_Cost_Price_Workbook_Rev_1.xlsx XLSX spreadsheet
Attachment_M-01_Section_M,_Amendment_0003.pdf PDF
Attachment_1_-_Performance_Work_Statement_8-Oct_19.pdf PDF
Attachment_11_-_AIMS_Work_Load_Factor_Tables_8_Oct_19.pdf PDF
Ascension_AOI_11-250_Signed_20_Dec_17_pages_19-36.pdf PDF
Answers_to__Atch_L-01_Question_&_Answer_Rev_4.xlsx XLSX spreadsheet
Attachment_L-03_AIMS_Cost_Price_Workbook_Rev_1.xlsx XLSX spreadsheet
1959_BLRPG_Admin_Arrangements_Regarding_Sites_in_Ascension_Island.pdf PDF
AIMS_FES_Manning_Enclosure_9.pdf PDF
2016 Wideawake Agreement PDF
AAAF_Storage_Tanks_Redacted.pdf PDF
Pending_Answers_to__Atch_L-01_Question_&_Answer_Rev_2.xlsx XLSX spreadsheet
Pending_Answers_to__Atch_L-01_Question_&_Answer_Rev_1.xlsx XLSX spreadsheet
AAAF_Facilities.pdf PDF
Solicitation_Amendment_FA252119RA0170002_SF_30.pdf PDF
Attachment_L-02_Section_L,_Amendment_0002.pdf PDF
AAAF_Vehicles.pdf PDF
Pending_Answers_to_Attachment_L-01_Question_&_Answer_Rev_1.xlsx XLSX spreadsheet
Pending_Answers_to_Attachment_L-01_Questions_&_Answers.xlsx XLSX spreadsheet
Attachment_5_-_SCA_WD_2015-4555_Rev_8.pdf PDF
Attachment_12_-_Antenna_&_Tower_Listing.pdf PDF
Exhibit_E_AIMS_CDRLs_E001-E002.pdf PDF
Attachment_15_-_Rights_in_Data_for_AIMS_(002).pdf PDF
Attachment_L-03_AIMS_Cost_Price_Workbook.xlsx XLSX spreadsheet
Attachment_1_-_AIMS_Final_PWS.pdf PDF
Attachment_7_-_DD_254.pdf PDF
Exhibit_F_AIMS_CDRL_F001.pdf PDF
Attachment_10_-_AIMS_Base_Support.pdf PDF
Attachment_3_-_AIMS_Government_Furnished_Property.pdf PDF
Attachment_6_-_CBA_WCFS_and_Teamster.pdf PDF
FA252119RA017_AIMS_Final_Solicitation.pdf PDF
Attachment_L-04_AIMS_Past_Performance_Questionnaire.docx DOCX document
Attachment_L-02_Section_L.pdf PDF
Attachment_L-01_Question_&_Answer_Template.xlsx XLSX spreadsheet
Draft_Exhibit_B_CDRLs_B001-B039.pdf PDF
Draft_Exhibit_A_CDRLs_A001_-_A020.pdf PDF
AMENDED_AIMS_Q&As_Version_2.pdf PDF
Draft_Exhibit_F_CDRL_F001.pdf PDF
AIMS_Pre-Solicitation_Registration_Form.pdf PDF
DRAFT_AIMS_Section_L.pdf PDF
Attachment_11-AIMS_Work_Load_Factor_Tables_14_Jun_19.pdf PDF
Draft_Solicitation_-_FA252119RA017.pdf PDF
DRAFT_AIMS_Section_L.pdf PDF
DRAFT_AIMS_PWS_14-June-2019.pdf PDF
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

CLINCLIN TypeServiceFY 2020FY 2021FY 2022FY 2023FY 2024FY 2025FY 2026Total
0700FFPPhase-in Period$0.00$0.00
X013NSPContract Data Requirements List (CDRL)$0.00
X001FFPProgram Management$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002FFPBOS Services, Logistics, Civil Engineering$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X003CPFFCommunication$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X004CPFFSpace Object Tracking & Maintenance$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X005CPFFLaunch Support & Maintenance$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X006CPFFOvertime Support$100,000.00$100,000.00$100,000.00$100,000.00$100,000.00$50,000.00$550,000.00
X007CRContractor 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
X008CRContractor 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
X009FFPRoyal Air Force Support$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X010CRNASA MCAT$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X011FfPNASA SHADOZ$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X012CRVehicles$250,000.00$250,000.00$250,000.00$250,000.00$250,000.00$125,000.00$1,375,000.00
X014FFPProject Support$750,000.00$750,000.00$750,000.00$750,000.00$750,000.00$375,000.00$4,125,000.00
8000FFPPhase-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 2020Total
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 2021FY 2022FY 2023FY 2024FY 2025Total
10/01/2020 to 9/30/202110/01/2021 to 9/30/202210/01/2022 to 9/30/202310/01/2023 to 9/30/202410/01/2024 to 9/30/2025
AmountAmountAmountAmountAmount
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 2021FY 2022FY 2023FY 2024FY 2025Total
10/01/2020 to 9/30/202110/01/2021 to 9/30/202210/01/2022 to 9/30/202310/01/2023 to 9/30/202410/01/2024 to 9/30/2025
AmountAmountAmountAmountAmount
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 2021FY 2022FY 2023FY 2024FY 2025Total
10/01/2020 to 9/30/202110/031/2021 to 9/30/202210/01/2022 to 9/30/202310/01/2023 to 9/30/202410/01/2024 to 9/30/2025
Offeror's Labor Category (NOTE 1)Base/HoursRateExtended $Base/HoursRateExtended $Base/HoursRateExtended $Base/HoursRateExtended $Base/HoursRateExtended $Base/HoursExtended $
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.000$0.00
Total Direct Labor Costs0$0.000$0.000$0.000$0.000$0.000$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 2020Total
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 2021FY 2022FY 2023FY 2024FY 2025FY 2026FY 2027
Labor Category (Note 1)Base Rate (Wage Determination or CBA)Escalation RateEscalation RateEscalation RateEscalation RateEscalation RateEscalation RateEscalation Rate
Program Manager2.30%2.10%2.20%2.30%2.30%2.10%2.20%
Logisticsxxxxxxxxxxxxxx
Indirect Rates (Note 2)
FY21FY22FY23FY24FY25FY26FY27
Rate Category
Fringe Benefits
Labor Overhead
Material Handling
General and Administrative
Facilities Cost of Money
Basis of RateApplied AgainstNote 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.

SubcontractorCompetitive/Sole SourceCost/price analysis included (Y/N)Competitive Quotes or Sole Source Documentation Included (Y/N)Total amount exceeds $650K (Y/N)
ABC CompanyCompetitiveYYN
XYZ CompanySole SourceYYY

&"Arial,Bold"&12&A

Offeror: Page &P of &N Pages &F

Labor Rates Listing

Labor Rates Listing
FY 2021FY 2022FY 2023FY 2024FY 2025FY 2026FY 2027
Proposed Labor CatagoriesWage Rate
per hourLabor BurdensFeeTotal Labor Cost per HourWage Rate
per hourLabor BurdensFeeTotal Labor Cost per HourWage Rate
per hourLabor BurdensFeeTotal Labor Cost per HourWage Rate
per hourLabor BurdensFeeTotal Labor Cost per HourWage Rate
per hourLabor BurdensFeeTotal Labor Cost per HourWage Rate
per hourLabor BurdensFeeTotal Labor Cost per HourWage Rate
per hourLabor BurdensFeeTotal 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/orBase YearDCAA Recommended*Basis of DCAA16. Requesting Office Information (to be completed by Contracting Officer)
Employee Name if Actuals ProposedProposed RatesRatesRecommendationContracting Officer:
Phone Number:
E-Mail Address:

*Based on Floor Check/Audit Performed, etc and Date

14B. Indirect RatesFY21FY22FY23FY24FY25FY26FY27
Proposed:DCAA Rates*Proposed:DCAA RatesProposed:DCAA RatesProposed:DCAA RatesProposed:DCAA RatesProposed:DCAA RatesProposed: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 .