Lot Calculation linens.xlsx

This is a linen services pricing template for South Carolina state parks, specifically for a bidding process involving the South Carolina Department of Parks, Recreation and Tourism. The file contains itemized lot calculations for linen and related services across multiple state park locations. Lot A covers Givhans Ferry State Park with estimated monthly usage including 175 queen sheets, 175 pillow cases, 100 dish towels, 250 bath towels, 250 wash cloths, 20 laundry bags, and 2 pickup/delivery trips. Lot B covers Edisto Beach State Park with higher estimated monthly volumes including 300 queen sheets, 300 pillow cases, 350 dish towels, 400 bath towels, 125 bath mats, 250 wash cloths, 250 hand towels, 25 laundry bags, and 4 pickup/delivery trips. All items are measured in individual units (EA).

Vendors are required to enter unit prices for each line item in designated blue cells within the locked spreadsheet template, with extended prices automatically calculated by multiplying unit price by estimated quantity. The total extended price for each lot serves as the monthly bid amount for that specific park location. Vendors must enter their company name and provide pricing for all items listed, with the spreadsheet preventing alterations to non-pricing fields to maintain bid integrity and standardization across all submissions.