Attachment C Reporting Template.xlsm

This is a reporting template for the STC Uniform Rental Service contract opportunity in South Carolina. The template is designed to capture transaction-level data for vendors awarded contracts under this state and local cooperative purchasing program. The template requires vendors to report detailed information on all sales and invoices, including vendor name, contract number, state designation, customer type segmentation (State Gov't, Education-K12, Education-HED, Local Gov't, Medical, or Other), billing and shipping addresses, purchase order numbers, order dates, and invoice details. Products covered under this contract include uniforms, floor mats, towels, mops, linens, and related textile rental services. The template captures product-level information including product numbers, descriptions, unit specifications, quantities invoiced, and pricing at both list and NASPO ValuePoint negotiated rates.

The reporting structure requires vendors to document extended pricing (unit price multiplied by quantity), administrative fees calculated as a percentage of total price, and Energy Star compliance status where applicable. The template includes provisions for identifying value-added resellers, distributors, or resellers and their locations. All pricing must be reported in U.S. currency with specific formatting requirements (standard five-digit or extended ZIP+4 format for addresses, and currency values to three decimal places). The template is formatted for quarterly reporting periods (identified by year and quarter) and includes summary totals for sales and administrative fees. This standardized reporting approach enables South Carolina and participating political subdivisions to track contract performance, monitor pricing compliance, and ensure accountability across all purchases made through the uniform rental service contract.