Attachment 0001 Pricing Matrix with EPA Data 24 June 2022.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Invitation for Bid Mortar (PA162, PA167, PA175, and PA189) Fiber Containers
Solicitation number
W15QKN-22-B-0001
Issued by

View the file

Other files

Show all 11

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

Price Matrix for Offerors

Offeror Name:= Input Required by Offeror
Cage Code:=Input Required in Bid is predicated on the use of Gov't Property already in Possession
Date of Submission:
Price Matrix for:W15QKN-22-B-0001OFFEROR: ASSERT WHETHER YOUR OFFER IS OR IS NOT PREDICATED UPON THE USE
OF GOVERNMENT PROPERTY IN YOUR POSSESSION OR ONE OF YOUR
OP = Ordering PeriodSUBCONTRACTGOR'S POSSESSION. IF IT IS, PROVIDE THE PER UNIT RENTAL
VALUES IN COLUMNS L-Q BELOW.
CLINs (references are by ordering period)DESCRIPTIONRANGEUNITPROPOSED UNIT PRICESPROPOSED PER UNIT RENTAL VALUE OF GOVERNMENT PROPERTY
FROMTOOP 1OP 2OP 3OP 4OP 5OP 6OP 1OP 2OP 3OP 4OP 5OP 6
0001 (OPs 1-3), 0021 (OPs 4-6)PA175 Fiber Container First Article Test11LOT
0002 (OPs 1-3), 0022 (OPs 4-6)PA175 Fiber Container Additional FAT11LOT
0003 (OPs 1-3), 0023 (OPs 4-6)PA189 Fiber Container First Article Test11LOT
0004 (OPs 1-3), 0024 (OPs 4-6)PA189 Fiber Container Additional FAT11LOT
0005 (OPs 1-3), 0025 (OPs 4-6)PA162 Fiber Container First Article Test11LOT
0006 (OPs 1-3), 0026 (OPs 4-6)PA162 Fiber Container Additional FAT11LOT
0007 (OPs 1-3), 0027 (OPs 4-6)PA167 Fiber Container First Article Test11LOT
0008 (OPs 1-3), 0028 (OPs 4-6)PA167 Fiber Container Additional FAT11LOT
0009, 0013, 0017, 0029, 0033, 0037PA175 Fiber Containers - Production5004,999EA
5,00014,999EA
15,00024,999EA
25,00060,000EA
0010, 0014, 0018, 0030, 0034, 0038PA189 Fiber Containers - Production5004,999EA
5,00014,999EA
15,00024,999EA
0011, 0015, 0019, 0031, 0035, 0039PA162 Fiber Containers - Production5004,999EA
5,00014,999EA
15,00024,999EA
25,00060,000EA
0012, 0016, 0020, 0032, 0036, 0040PA167 Fiber Containers - Production5004,999EA
5,00014,999EA
15,00024,999EA
25,00060,000EA

EPA Clause

Offeror Name:0= Offeror Fill in Required
EPA Data - Mortar Fiber Containers= Formula - no input required
Unit of Measure (lbs, grams, sheets,etc.)Measurement Required (Qty) per PartOut Year Escalation Factors Applied
End ItemOrdering PeriodFiber Tube / Paper
60mm PA17581mm PA162120mm PA16760mm PA189
Start Measurement for Paper (Fiber Tube) for an individual end itemOP2
OP3
OP4
OP5
OP6
60mm PA17581mm PA162120mm PA16760mm PA189
Baseline for Paper (Fiber Containers)Baseline for Paper (Fiber Containers)Baseline for Paper (Fiber Containers)Baseline for Paper (Fiber Containers)
FAT/Production Quantity RangesUoMUnit Price of PaperCost of Paper at Current Price (Per Lot/Unit)UoMUnit Price of PaperCost of Paper at Current Price (Per Lot/Unit)UoMUnit Price of PaperCost of Paper at Current Price (Per Lot/Unit)FAT/Production Quantity RangesUoMUnit Price of PaperCost of Paper at Current Price (Per Lot/Unit)
500-4,9990$0.000$0.000$0.00500-4,9990$0.00
5,000-14,9990$0.000$0.000$0.005,000-14,9990$0.00
15,000-24,9990$0.000$0.000$0.0015,000-24,9990$0.00
25,000-600000$0.000$0.000$0.00

EPA Example - Paper

Example of EPA Paper Calculation for the 60mm PA175 Production CLINs
(numbers are fictitious)
Assumption - 2 Tons of Paper needed per 60mm PA 175
Unit Prices for paper based on a current quote for each quantity range, which is provided.
Unit of Measure (lbs, grams, sheets,etc.)Measurement Required (Qty) per Part
End Item
60mm PA175
Start Measurement for Paper (Fiber Tube) for an individual end itemTon2.00
60mm PA175
Baseline for Paper (Fiber Containers)
Production Quantity RangesUoMUnit Price of PaperCost of Paper at Current Price (Per Lot/Unit)
500-4,999Ton$ 14.00$28.00
5,000-14,999Ton$ 13.00$26.00
15,000-24,999Ton$ 12.00$24.00
25,000-60000Ton$ 11.00$22.00

Example

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