Reporting Template Draft.xlsx

This is a reporting template draft related to a South Carolina state and local contract opportunity (Solicitation 54-20988) for asbestos, lead paint, and mold collection and testing services. The template is designed to track vendor sales and administrative fees associated with the contract. The document establishes seven service lots with varying rate structures: Lot 1 covers asbestos services at hourly rates, Lot 2 addresses lead services at daily rates, Lot 3 encompasses mold services at 24-hour rates, Lot 4 provides air monitoring at 48-hour rates, Lot 5 includes asbestos laboratory fees at 3-day rates, Lot 6 covers lead paint laboratory fees at 5-day rates, and Lot 7 addresses mold laboratory fees at 6+ day rates. The reporting framework includes fields for entity names and types, purchase order numbers, invoice numbers and dates, lot descriptions, rate types, quantities, total sales figures, and administrative fees.

The reporting template shows all values currently set at $0.00, indicating this is a preliminary draft awaiting contract execution and vendor activity. The template includes a pivot table structure for summarizing total sales and administrative fees by row labels, with provisions for weekly and bi-weekly reporting periods. The document does not specify pricing terms, administrative fee percentages, contract duration, renewal options, funding sources, or other operational details, suggesting these elements would be established in the formal contract award documents and vendor agreements.