Attachment 0007 Pricing Template APR 2023 POWER SUPPLY.xlsx

XLSX spreadsheet 20 KB Posted

Attached to
Solicitation for Power Supply Fuel
Solicitation number
W58RGZ-24-B-0046
Issued by

About this file

This document is a Pricing Template for a federal contract opportunity related to the overhaul and repair of Power Supply Fuel units. The template includes instructions for the offeror to enter proposed Firm-Fixed-Price (FFP) amounts for various Contract Line Item Numbers (CLINs) such as Product Verification Audit, Overhaul/Repair, Scrap/Beyond Economical Repair, and Contracts Data Requirements List. The offeror is expected to provide supporting calculations and formulas to show how the proposed FFP prices were derived. This is a 5-year Indefinite Delivery Indefinite Quantity (IDIQ) maintenance and overhaul contract under NAICS code 335999 with a size standard of 600 employees. The acquisition is a 100% Small Business Set-Aside managed by the Department of the Army Materiel Command Contracting Command at Redstone Arsenal. The required quantities range from 10 to 60 units, including up to 10 for Foreign Military Sales.

View the file

Other files

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

INSTRUCTIONS

AGPU Starter Engine Electrical Pricing Template Instructions: Enter the requested data in the yellow shaded cells.

Do not hard key calculated numbers. It is requested that the general format of this attachment be maintained as much as possible for evaluation and contract administration purposes.

STEP 1: The offeror shall propose a total FFP for CLIN 0001AA Product Verification Audit (PVA) and FFP unit prices by ordering period for CLINs 0002 through 0005 in the Price Table worksheet.

STEP 2: In the CLIN Summary for Evaluation Purposes worksheets, input/update formulas to apply the proposed FFP amounts from the Price Table worksheet to the Government's RFP evaluation quantities by CLIN and ordering period. Use formulas to link the Price Table FFP proposed amounts to the CLIN Summary for Evaluation worksheet.

STEP 3: The offeror shall provide additional worksheets within the AGPU Starter Engine Electrical Pricing Template to show the calculation/build-up of the Price Table proposed FFP amounts. Input formulas to show the calculation of the proposed FFP amounts, linking the supporting calculation worksheets to the FFP prices in the Price Table.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's proposed prices.

1. Price Table

Price Table
POWER SUPPLY FUEL
Prime Contractor Name:
Prime Contractor CAGE Code:
CLIN Number/CLIN DescriptionProposed Prices
0001AA- PVA (Total FFP)
0002AA- Overhaul/ Repair -US
Ordering Period 1 Unit Price
Ordering Period 2 Unit Price
Ordering Period 3 Unit Price
Ordering Period 4 Unit Price
Ordering Period 5 Unit Price
0003AA- Overhaul/ Repair - FMS
Ordering Period 1 Unit Price
Ordering Period 2 Unit Price
Ordering Period 3 Unit Price
Ordering Period 4 Unit Price
Ordering Period 5 Unit Price
0004AA- Scrap/ Beyond Economical Repair
Ordering Period 1 Unit Price
Ordering Period 2 Unit Price
Ordering Period 3 Unit Price
Ordering Period 4 Unit Price
Ordering Period 5 Unit Price
0005- Contracts Data Requirements List (CDRL)NSP

"Price Table" worksheet:

Enter the requested data in the yellow highlighted cells. The offeror shall propose a total FFP price for CLIN 0001AA PVA and FFP unit prices by ordering period for CLINs 0002AA through 0005AA The offeror shall ensure that all calculations are accurate and reflective of the offeror's proposed prices.

2. CLIN Summary for Evaluation

CLIN Summary for Evaluation
POWER SUPPLY FUEL
Prime Contractor Name:
Prime Contractor CAGE Code:
CLIN Number/CLIN DescriptionProposed PricesQuantities for Evaluation PurposesTotal Proposed Price For Evaluation Purposes
0001AA- PVA (Total Price)1$ - 0
0002AA-Overhaul/Repair - US
Ordering Period 1 Unit Price10$ - 0
Ordering Period 2 Unit Price10$ - 0
Ordering Period 3 Unit Price10$ - 0
Ordering Period 4 Unit Price10$ - 0
Ordering Period 5 Unit Price10$ - 0
0003AA- Overhaul/Repair - FMS
Ordering Period 1 Unit Price0$ - 0
Ordering Period 2 Unit Price2$ - 0
Ordering Period 3 Unit Price2$ - 0
Ordering Period 4 Unit Price2$ - 0
Ordering Period 5 Unit Price4$ - 0
0004AA- Physically Unrepairable Determination
Ordering Period 1 Unit Price1$ - 0
Ordering Period 2 Unit Price1$ - 0
Ordering Period 3 Unit Price1$ - 0
Ordering Period 4 Unit Price1$ - 0
Ordering Period 5 Unit Price1$ - 0
0005AA-Containers
Ordering Period 1 Unit Price1$ - 0
Ordering Period 2 Unit Price1$ - 0
Ordering Period 3 Unit Price1$ - 0
Ordering Period 4 Unit Price1$ - 0
Ordering Period 5 Unit Price1$ - 0
0006- Contracts Data Requirements List (CDRL)NSPNSPNSP
$ - 0

"CLIN Summary for Evaluation" worksheet:

Enter the requested data in the yellow highlighted cells. Input/update formulas to apply the proposed FFP amounts from the Price Table worksheet to the Government's RFP evaluation quantities by CLIN and ordering period. Use formulas to link the Price Table FFP proposed amounts to the CLIN Summary for Evaluation worksheet. Enter a proposed

The CLIN Summary for Evaluation should be modified accordingly to reflect the offeror's total proposed price at the evaluation quantities.

This offeror shall ensure that all calculations in this worksheet are accurate and reflective of the offeror's proposed prices.

File details come from the government source that posted it. Updated .