Pricing Workbook Summary

This is a pricing workbook for a California Department of General Services, Procurement Division Invitation for Bid (IFB) to establish a statewide two-year contract for thermoplastic traffic striping materials and waterborne traffic line paint, with three optional one-year extensions. The solicitation is organized into four groups covering distinct product categories and geographic regions: Group 1 addresses thermoplastic materials for Northern California, Group 2 covers waterborne paint products for Northern California, Group 3 includes thermoplastic materials for Southern California, and Group 4 encompasses waterborne paint products for Southern California. The workbook requires bidders to complete pricing information for 24 line items in the waterborne groups and 4 line items in each thermoplastic group. Products include granular thermoplastic traffic striping materials with alkyd resin binders in white and lead-free yellow variants, rapid dry waterborne traffic line paint in white, yellow, and black, and high build waterborne traffic line paint complying with Federal Specification TT-P-1952F (Type III). Estimated two-year quantities range from single units for containers to 1,100 tons for specific thermoplastic variants, with deliveries required throughout the statewide area.

The pricing workbook instructs bidders to complete only highlighted input cells, specifically the List Price/MSRP and Contract Unit Price fields for each line item. Contract discount percentages are calculated automatically using the formula ((List Price/MSRP – Contract Unit Price) / List Price/MSRP), and extension amounts are computed by multiplying the contract unit price by the two-year estimated quantity. The document references multiple specification attachments (Attachment 2A through 2D) that detail product requirements, including thermoplastic specifications (PTH-02ALKYD), rapid dry waterborne specifications (PTWB-01R2), and bulk container specifications. All line items are assigned UNSPSC commodity codes for classification purposes. The workbook currently displays ERROR:#DIV/0! calculations and $0 extension totals, indicating the pricing data has not yet been populated by bidders. Award decisions will be made by group, making awards in separate categories for thermoplastic and waterborne products across Northern and Southern California regions.