Attachment_1_-_Pricing_Workbook.xlsx

This pricing workbook is a template for the State of California Department of General Services, Procurement Division's Invitation For Bid (IFB) for Main Line Guardrails, Event ID 0000039836. The contract establishes a statewide two-year agreement with three one-year extension options, mandatory for use by the California Department of Transportation (Caltrans) and available to other state departments. The workbook contains pricing schedules for two groups of components: Group 1 includes wood components such as wood posts and pressure-treated wood blocks across six contract line items with estimated quantities ranging from 100 to 15,560 units over the two-year term; Group 2 encompasses non-wood components including guardrail elements, transition sections, end sections, steel posts, plastic blocks, bolts, washers, nuts, and miscellaneous components across nine categories with line items totaling over 360,000 units. All line items are priced on a per-unit basis ("Each"), with quantities specified as the two-year estimated volume for evaluation purposes.

Bidders must complete only yellow input cells in the pricing workbook, providing list price/MSRP, contract discount percentage, and contract unit price for each line item, with extensions automatically calculated. The contract discount is calculated using the formula ((List Price/MSRP – Contract Unit Price) / List Price/MSRP), and all extensions are derived by multiplying the contract unit price by quantity. Certain items carry specific requirements: Guardrail Elements (Category 1) and Steel Posts (Category 4) must include 10% post-consumer recycled content. The pricing workbook shows all totals currently at $0.00, indicating this is a blank template awaiting bidder submissions. No pricing information, set-asides, funding sources, or incumbent details are provided in this document.