Attachment 001 Pricing Sheet.xlsx
XLSX spreadsheet 47 KB Posted
- Attached to
- PRNG Waste Management Services Federal contract opportunity
- Solicitation number
- W912LR26QA010
- Issued by
- Department of the Army National Guard
About this file
This is a Pricing Sheet template for waste management services at Puerto Rico Army National Guard (PRNG) facilities. The spreadsheet is structured to capture unit pricing for non-hazardous solid waste collection and disposal services across a base year and three option years, with all extended price calculations locked to prevent formula manipulation. Contractors must enter unit prices per service in the designated column, with the template automatically calculating extended prices based on quantities and frequencies specified for each location and contract line item number (CLIN).
The pricing structure encompasses waste collection services across 26 Puerto Rico military locations, including Fort Allen Training Center, multiple Facility Maintenance Sites (FMS), and Readiness Centers throughout the island. Services include regular waste collection at varying frequencies (weekly, bi-weekly, or upon request) with container sizes ranging from 8 to 40 cubic yards, totaling 3,540 services annually for the base year. Pricing is organized by four CLINs (0001-0004 for base year; 1001-1004 for Option 1; 2001-2004 for Option 2; and 3001-3004 for Option 3), with cost-sharing percentages applied to certain locations (100%, 75%, or 50% shares). The solicitation (W912LR26QA010) is set aside for small business concerns under NAICS code 562111, with an award to be made based on lowest acceptable price meeting all specified requirements, and a submission deadline of March 25, 2026, at 4:00 PM local time.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| W912LR26QA0100001 SF 30.pdf | ||
| W912LR26QA010 RFIs.pdf | ||
| PWS - Solid Waste Management Ver22Feb2026.pdf | ||
| SCA WD 2015-5707.pdf | ||
| PWS - Solid Waste Management TechExhibit4 Attachment1.pdf | ||
| SCA WD 2015-5701.pdf | ||
| Part 12 RFQ Combined Synopsis-Solicitation .pdf | ||
| W912LR26QA010 (1449).pdf | ||
| SCA WD 2015-5699.pdf | ||
| SCA WD 2015-5703.pdf | ||
| SCA WD 2015-5697.pdf |
Show all 11
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
TOTAL
| Base Year | Sum of Extended Price |
| 0001 | $0.00 |
| 0002 | $0.00 |
| 0003 | $0.00 |
| 0004 | $0.00 |
| Grand Total | $0.00 |
| Option 1 | Sum of Extended Price |
| 1001 | $0.00 |
| 1002 | $0.00 |
| 1003 | $0.00 |
| 1004 | $0.00 |
| Grand Total | $0.00 |
| Option 2 | Sum of Extended Price |
| 2001 | $0.00 |
| 2002 | $0.00 |
| 2003 | $0.00 |
| 2004 | $0.00 |
| Grand Total | $0.00 |
| Option 3 | Sum of Extended Price |
| 3001 | $0.00 |
| 3002 | $0.00 |
| 3003 | $0.00 |
| 3004 | $0.00 |
| Grand Total | $0.00 |
BASE YEAR
| Waste Management Pricing Structure Base Period (12 Months) |
| Instructions: Enter unit price in COLUMN I of this spreedsheet. All other cells are locked. Do not edit the formulas. Report issues with formulas or calculations to the solicitation point of contact |
| Description | Location | CLIN | % Share | Container Size (CuYds) | Frequency (Weekly Basis) | Quantity (Total Services) | Unit of Measure | Unit Price | Extended Price |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 0001 | 100% | 8 | 1 | 780 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 0001 | 100% | 30 | 1 (Every 2 weeks) | 26 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 0001 | 100% | 40 | 1 (Every 2 weeks) | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center - FMS#9 | 0001 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Additional Pickups (Base Year) | Fort Allen Training Center | 0001 | 100% | 8 | Upon Request | 275 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Ceiba FMS#3 | 0002 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Gurabo FMS#2 | 0002 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Mayaguez - FMS #5 | 0002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | San Juan - AASF Army Aviation Support Facility | 0002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Vega Baja FMS#7 | 0002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Additional Pickups (Base Year) | Puerto Rico (Various Sites) | 0002 | 100% | 8 | Upon Request | 15 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Aguadilla Readiness Center | 0003 | 75% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Former 1013TH EN, Aguadilla | 0003 | 75% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Aibonito Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Arecibo Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Cabo Rojo Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Caguas Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Cayey Readiness Center | 0004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Coamo Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Guayama Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Gurabo Readiness Center | 0004 | 50% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Humacao Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Mayaguez Readiness Center | 0004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Peñuelas Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Ponce Readiness Center | 0004 | 50% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Toa Baja Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Utuado Readiness Center | 0004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Vega Baja RC Readiness Center | 0004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Total Services | 3540 | Total Price | $0.00 |
OPTION 1
| Waste Management Pricing Structure Base Period (12 Months) Option 1 |
| Instructions: Enter unit price in COLUMN I of this spreedsheet. All other cells are locked. Do not edit the formulas. Report issues with formulas or calculations to the solicitation point of contact |
| Description | Location | CLIN | % Share | Container Size (CuYds) | Frequency (Weekly Basis) | Quantity (Total Services) | Unit of Measure | Unit Price | Extended Price |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 1001 | 100% | 8 | 1 | 780 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 1001 | 100% | 30 | 1 (Every 2 weeks) | 26 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 1001 | 100% | 40 | 1 (Every 2 weeks) | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center - FMS#9 | 1001 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Additional Pickups (Base Year) | Fort Allen Training Center | 1001 | 100% | 8 | Upon Request | 275 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Ceiba FMS#3 | 1002 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Gurabo FMS#2 | 1002 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Mayaguez - FMS #5 | 1002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | San Juan - AASF Army Aviation Support Facility | 1002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Vega Baja FMS#7 | 1002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Additional Pickups (Base Year) | Puerto Rico (Various Sites) | 1002 | 100% | 8 | Upon Request | 15 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Aguadilla Readiness Center | 1003 | 75% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Former 1013TH EN, Aguadilla | 1003 | 75% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Aibonito Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Arecibo Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Cabo Rojo Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Caguas Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Cayey Readiness Center | 1004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Coamo Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Guayama Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Gurabo Readiness Center | 1004 | 50% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Humacao Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Mayaguez Readiness Center | 1004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Peñuelas Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Ponce Readiness Center | 1004 | 50% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Toa Baja Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Utuado Readiness Center | 1004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Vega Baja RC Readiness Center | 1004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Total Services | 3540 | Total Price | $0.00 |
OPTION 2
| Waste Management Pricing Structure Base Period (12 Months) Option 2 |
| Instructions: Enter unit price in COLUMN I of this spreedsheet. All other cells are locked. Do not edit the formulas. Report issues with formulas or calculations to the solicitation point of contact |
| Description | Location | CLIN | % Share | Container Size (CuYds) | Frequency (Weekly Basis) | Quantity (Total Services) | Unit of Measure | Unit Price | Extended Price |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 2001 | 100% | 8 | 1 | 780 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 2001 | 100% | 30 | 1 (Every 2 weeks) | 26 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 2001 | 100% | 40 | 1 (Every 2 weeks) | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center - FMS#9 | 2001 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Additional Pickups (Base Year) | Fort Allen Training Center | 2001 | 100% | 8 | Upon Request | 275 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Ceiba FMS#3 | 2002 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Gurabo FMS#2 | 2002 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Mayaguez - FMS #5 | 2002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | San Juan - AASF Army Aviation Support Facility | 2002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Vega Baja FMS#7 | 2002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Additional Pickups (Base Year) | Puerto Rico (Various Sites) | 2002 | 100% | 8 | Upon Request | 15 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Aguadilla Readiness Center | 2003 | 75% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Former 1013TH EN, Aguadilla | 2003 | 75% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Aibonito Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Arecibo Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Cabo Rojo Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Caguas Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Cayey Readiness Center | 2004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Coamo Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Guayama Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Gurabo Readiness Center | 2004 | 50% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Humacao Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Mayaguez Readiness Center | 2004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Peñuelas Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Ponce Readiness Center | 2004 | 50% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Toa Baja Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Utuado Readiness Center | 2004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Vega Baja RC Readiness Center | 2004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Total Services | 3540 | Total Price | $0.00 |
OPTION 3
| Waste Management Pricing Structure Base Period (12 Months) Option 3 |
| Instructions: Enter unit price in COLUMN I of this spreedsheet. All other cells are locked. Do not edit the formulas. Report issues with formulas or calculations to the solicitation point of contact |
| Description | Location | CLIN | % Share | Container Size (CuYds) | Frequency (Weekly Basis) | Quantity (Total Services) | Unit of Measure | Unit Price | Extended Price |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 3001 | 100% | 8 | 1 | 780 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 3001 | 100% | 30 | 1 (Every 2 weeks) | 26 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center | 3001 | 100% | 40 | 1 (Every 2 weeks) | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Fort Allen Training Center - FMS#9 | 3001 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Additional Pickups (Base Year) | Fort Allen Training Center | 3001 | 100% | 8 | Upon Request | 275 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Ceiba FMS#3 | 3002 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Gurabo FMS#2 | 3002 | 100% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Mayaguez - FMS #5 | 3002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | San Juan - AASF Army Aviation Support Facility | 3002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Vega Baja FMS#7 | 3002 | 100% | 8 | 2 | 208 | Per service | $0.00 | |
| Additional Pickups (Base Year) | Puerto Rico (Various Sites) | 3002 | 100% | 8 | Upon Request | 15 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Aguadilla Readiness Center | 3003 | 75% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Former 1013TH EN, Aguadilla | 3003 | 75% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Aibonito Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Arecibo Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Cabo Rojo Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Caguas Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Cayey Readiness Center | 3004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Coamo Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Guayama Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Gurabo Readiness Center | 3004 | 50% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Humacao Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Mayaguez Readiness Center | 3004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Peñuelas Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Ponce Readiness Center | 3004 | 50% | 8 | 2 | 104 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Toa Baja Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Utuado Readiness Center | 3004 | 50% | 8 | 1 | 52 | Per service | $0.00 | |
| Regular Waste Collection (Base Year) | Vega Baja RC Readiness Center | 3004 | 50% | 8 | 2 | 208 | Per service | $0.00 | |
| Total Services | 3540 | Total Price | $0.00 |
File details come from the government source that posted it. Updated .