Attachment 0001 Pricing Matrix with EPA Data 24 June 2022.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- W15QKN-22-B-0001
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-0001 | OFFEROR: ASSERT WHETHER YOUR OFFER IS OR IS NOT PREDICATED UPON THE USE | |
| OF GOVERNMENT PROPERTY IN YOUR POSSESSION OR ONE OF YOUR | |||
| OP = Ordering Period | SUBCONTRACTGOR'S POSSESSION. IF IT IS, PROVIDE THE PER UNIT RENTAL | ||
| VALUES IN COLUMNS L-Q BELOW. |
| CLINs (references are by ordering period) | DESCRIPTION | RANGE | UNIT | PROPOSED UNIT PRICES | PROPOSED PER UNIT RENTAL VALUE OF GOVERNMENT PROPERTY | |||||||||||
| FROM | TO | OP 1 | OP 2 | OP 3 | OP 4 | OP 5 | OP 6 | OP 1 | OP 2 | OP 3 | OP 4 | OP 5 | OP 6 | |||
| 0001 (OPs 1-3), 0021 (OPs 4-6) | PA175 Fiber Container First Article Test | 1 | 1 | LOT | ||||||||||||
| 0002 (OPs 1-3), 0022 (OPs 4-6) | PA175 Fiber Container Additional FAT | 1 | 1 | LOT | ||||||||||||
| 0003 (OPs 1-3), 0023 (OPs 4-6) | PA189 Fiber Container First Article Test | 1 | 1 | LOT | ||||||||||||
| 0004 (OPs 1-3), 0024 (OPs 4-6) | PA189 Fiber Container Additional FAT | 1 | 1 | LOT | ||||||||||||
| 0005 (OPs 1-3), 0025 (OPs 4-6) | PA162 Fiber Container First Article Test | 1 | 1 | LOT | ||||||||||||
| 0006 (OPs 1-3), 0026 (OPs 4-6) | PA162 Fiber Container Additional FAT | 1 | 1 | LOT | ||||||||||||
| 0007 (OPs 1-3), 0027 (OPs 4-6) | PA167 Fiber Container First Article Test | 1 | 1 | LOT | ||||||||||||
| 0008 (OPs 1-3), 0028 (OPs 4-6) | PA167 Fiber Container Additional FAT | 1 | 1 | LOT | ||||||||||||
| 0009, 0013, 0017, 0029, 0033, 0037 | PA175 Fiber Containers - Production | 500 | 4,999 | EA | ||||||||||||
| 5,000 | 14,999 | EA | ||||||||||||||
| 15,000 | 24,999 | EA | ||||||||||||||
| 25,000 | 60,000 | EA | ||||||||||||||
| 0010, 0014, 0018, 0030, 0034, 0038 | PA189 Fiber Containers - Production | 500 | 4,999 | EA | ||||||||||||
| 5,000 | 14,999 | EA | ||||||||||||||
| 15,000 | 24,999 | EA | ||||||||||||||
| 0011, 0015, 0019, 0031, 0035, 0039 | PA162 Fiber Containers - Production | 500 | 4,999 | EA | ||||||||||||
| 5,000 | 14,999 | EA | ||||||||||||||
| 15,000 | 24,999 | EA | ||||||||||||||
| 25,000 | 60,000 | EA | ||||||||||||||
| 0012, 0016, 0020, 0032, 0036, 0040 | PA167 Fiber Containers - Production | 500 | 4,999 | EA | ||||||||||||
| 5,000 | 14,999 | EA | ||||||||||||||
| 15,000 | 24,999 | EA | ||||||||||||||
| 25,000 | 60,000 | EA |
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 Part | Out Year Escalation Factors Applied | |||||
| End Item | Ordering Period | Fiber Tube / Paper | |||||
| 60mm PA175 | 81mm PA162 | 120mm PA167 | 60mm PA189 | ||||
| Start Measurement for Paper (Fiber Tube) for an individual end item | OP2 | ||||||
| OP3 | |||||||
| OP4 | |||||||
| OP5 | |||||||
| OP6 |
| 60mm PA175 | 81mm PA162 | 120mm PA167 | 60mm PA189 | ||||||||||
| Baseline for Paper (Fiber Containers) | Baseline for Paper (Fiber Containers) | Baseline for Paper (Fiber Containers) | Baseline for Paper (Fiber Containers) | ||||||||||
| FAT/Production Quantity Ranges | UoM | Unit Price of Paper | Cost of Paper at Current Price (Per Lot/Unit) | UoM | Unit Price of Paper | Cost of Paper at Current Price (Per Lot/Unit) | UoM | Unit Price of Paper | Cost of Paper at Current Price (Per Lot/Unit) | FAT/Production Quantity Ranges | UoM | Unit Price of Paper | Cost of Paper at Current Price (Per Lot/Unit) |
| 500-4,999 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 500-4,999 | 0 | $0.00 | ||||
| 5,000-14,999 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 5,000-14,999 | 0 | $0.00 | ||||
| 15,000-24,999 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 15,000-24,999 | 0 | $0.00 | ||||
| 25,000-60000 | 0 | $0.00 | 0 | $0.00 | 0 | $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 item | Ton | 2.00 |
| 60mm PA175 | |||
| Baseline for Paper (Fiber Containers) | |||
| Production Quantity Ranges | UoM | Unit Price of Paper | Cost of Paper at Current Price (Per Lot/Unit) |
| 500-4,999 | Ton | $ 14.00 | $28.00 |
| 5,000-14,999 | Ton | $ 13.00 | $26.00 |
| 15,000-24,999 | Ton | $ 12.00 | $24.00 |
| 25,000-60000 | Ton | $ 11.00 | $22.00 |
Example
File details come from the government source that posted it. Updated .