ATT 0001 M548 Price Matrix.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- M548 Metal Ammunition Containers
- Solicitation number
- W519TC-24-R-0028
About this file
This is a price matrix template spreadsheet for solicitation W519TC-24-R-0028 for M548 Metal Ammunition Containers. The spreadsheet contains pricing tables for offerors to complete across five ordering periods, including First Article Test pricing and unit pricing for different quantity ranges (1-9,999, 10,000-24,999, 25,000-39,999, and 40,000-65,000 units). Each quantity range is assigned a weighted percentage for evaluation purposes (10%, 20%, 60%, and 10% respectively).
The template includes an Economic Price Adjustment (EPA) worksheet specifically for steel pricing calculations, requiring offerors to input pounds per unit and price per pound data. The EPA section contains formulas to calculate price adjustments and percentage increases/decreases, with a specific focus on tracking changes in steel costs over the contract periods. The spreadsheet is designed to automatically calculate weighted evaluated prices and grand total evaluated price once offerors input their pricing data.
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
Price Matrix
| PRICE EVALUATION SHEET | |
| W519TC-24-R-0028 | M548 Metal Ammunition Containers |
| Offeror: | Offeror Fill-In |
| Cage Code: | |
| Date: |
| CLIN 0001 |
| First Article Test |
Ordering Period 1 Ordering Period 2 Ordering Period 3 Ordering Period 4 Ordering Period 5
FAT Total ------- $ - 0
| CLIN 0002 |
| M548 Metal Ammunition Containers |
| Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | ||||||||
| Quantity Ranges | U/P | Weight | U/P | Weight | U/P | Weight | U/P | Weight | U/P | Weight | ||
| 1 | - | 9,999 | 10% | 10% | 10% | 10% | 10% | |||||
| 10,000 | - | 24,999 | 20% | 20% | 20% | 20% | 20% | |||||
| 25,000 | - | 39,999 | 60% | 60% | 60% | 60% | 60% | |||||
| 40,000 | 65,000 | 10% | 10% | 10% | 10% | 10% | ||||||
| 100% | 100% | 100% | 100% | 100% | ||||||||
| Weighted Evaluated Price | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
EVALUATED CLIN PRICE -------------------------------------------------------------------------------------- $ - 0
GRAND TOTAL EVALUATED PRICE: --------------------------------------------------------------------------------------- $ - 0
EPA WS
| PRICE EVALUATION SHEET | |
| W519TC-24-R-0028 | M548 Metal Ammunition Containers |
| Offeror: | 0 |
| Cage Code: | 0 |
| Date: | 12/31/99 |
EPA PRICING WORKSHEET FOR STEEL
| OP1 | OP2 | OP3 | OP4 | OP5 | |
| Base Price | |||||
| Lbs Per Unit | |||||
| Price Per Lb |
Total $ Per Lb $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Price $ Per Ammo Can $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Price Worksheet
| PRICE EVALUATION SHEET | |
| W519TC-24-R-0028 | M548 Metal Ammunition Containers |
| Offeror: | 0 |
| Cage Code: | 0 |
| Date: | 12/31/99 |
| EPA PRICING WORKSHEET FOR STEEL | ||
| Updated | Proposed |
| Lbs Per Unit |
| Price Per Lb |
Total $ Per Lb $ - 0 $ - 0
| Price $ Per Ammo Can | $ - 0 | $ - 0 | |
| Updated amount: | $ - 0 | ||
| Less Original Contract Amount: | $ - 0 | ||
| Total Increase/(Decrease) Per Can: | $ - 0 | ||
| Add: | |||
| BYO Cost Per Can: | $ - 0 | ||
| Revised Cost Per Can: | $ - 0 |
| Revised Cost Per Can: | $ - 0 |
| Less BYO Base Cost Per Can: | $ - 0 |
| Increase in Cans | $ - 0 |
| Increase in Cans | $ - 0 |
| Divide by BYO Base Cost Per Can | $ - 0 |
| Percentage Increase/Decrease: | ERROR:#DIV/0! |
| Percent is Less than 10% | ERROR:#DIV/0! |
File details come from the government source that posted it. Updated .