J.4 Scrap Metal Pricing Spreadsheet.xlsx

This is a pricing spreadsheet template for the Architect of the Capitol's Campuswide Scrap Metal Recycling Services solicitation (AOCSSB26R0007). Bidders must complete the spreadsheet by entering competitive percentages for various scrap metal materials to establish their pricing proposals.

The spreadsheet covers sixteen line items across eight material categories: #2 Copper (solid and wire), Brass, Aluminum, Stainless Steel, #2 Ferrous Bundles, Light Iron, and Heavy Steel. For each material, bidders must provide pricing for two service options: Contractor Pick Up and AOC Delivery. The materials are priced using dealer or consumer buying prices ranging from $0.050 per pound (Light Iron and Heavy Steel) to $2.380 per pound (#2 Copper). Estimated monthly weights range from 200 pounds for #2 Copper to 4,000 pounds for ferrous bundles and heavy steel. Bidders enter competitive percentages in the designated gray cells, which are then multiplied against the material rates to calculate monthly sub-totals and yearly revenue projections to the AOC. The spreadsheet automatically calculates a grand total that will determine the winning bid. The pricing assumptions section is included but not detailed in the provided document.