Attachment E Reporting Template.xlsx

This file is a reporting template for an SFAA (presumably a state or multi-state cooperative purchasing agreement) contract for office supplies and paper, related to a South Carolina state local contract opportunity. The template is designed to capture detailed sales data from awarded contractors, requiring vendors to report transaction-level information including vendor name, contract number, billing entity information, customer purchase order numbers, invoice details, product specifications, quantities, pricing, and administrative fees. The document establishes standardized fields for tracking sales across multiple customer segments (State Government, Education-K12, Education-HED, Local Government, Medical, and Other) and regions, with specific formatting requirements for dates (mm/dd/ccyy format), pricing in US currency, UNSPSC commodity codes (8 digits), and zip codes in standard 5-4 format.

The template mandates an administrative fee calculation of 1% based on total price and includes fields for tracking Energy Star compliance status and VAR/Reseller/Distributor information. The reporting structure accommodates transaction details such as manufacturer SKU numbers, unit of measure, and extended pricing calculations. The template provides rows for multiple line-item entries and includes summary sections for total sales amounts and total administrative fees due, enabling comprehensive tracking of contractor performance and sales volume under the cooperative purchasing agreement for office supplies and paper products across the identified customer segments and geographic regions.