1-Units to Case Conversion Sheet.xlsx

This is a Units to Case Conversion Sheet template for the County of Bucks, Pennsylvania, designed to facilitate pricing clarity and invoicing accuracy for unit cost contracts involving product purchases. The spreadsheet requires bidders to complete missing information across columns B, D, E, and F to document packaging and conversion details for line items numbered 1 through 19.1. Bidders must enter the unit price from their bid form submission, specify the individual package unit of measure (selected from options including bottle, can, box, tube, roll, each, bag, canister, tub, dozen, ounces, feet, inches, towel, wipe, pill, bar, or tablet), indicate how many units comprise each package, and document how many individual packages fit within a case. The sheet notes that certain line items (7, 17, 17.1, 18, and 18.1) will be ordered by "each" with no conversion required. A total volume number field is included at the bottom of the template, with a dropdown list accommodating volumes from 0 to 1,536 units.

The calculated case purchase price derived from this conversion sheet will serve as the basis for county invoicing. A critical provision states that if any discrepancy exists between the unit price listed in Column B of this form and the unit price in the Pricing Section of the PennBid website, the unit cost on the PennBid website shall prevail and will be used to calculate the final case price. This conversion sheet is essential for contracts involving packaged goods such as janitorial supplies, bedding and linen supplies, or similar consumable products where bidders must clarify packaging configurations and corresponding invoicing amounts.