Attachment B - Reporting Template Draft.xlsx

This is a reporting template draft for the STC Mobile Device Protection Plan contract opportunity in South Carolina. The template is designed to track vendor sales and administrative fees across multiple product categories and geographic regions. The products covered include cellular devices, tablets, laptops, Chromebooks, and MacBooks, which are organized by Region I, Region II, and Region III. The reporting structure includes fields for vendor identification (contract number 5400026776), report period documentation, billing entity information, customer purchase order details, invoice tracking, and regional plan type categorization. The template utilizes a pivot table format to consolidate and summarize total sales and administrative fees by product and region.

The template currently displays zero values across all pricing, quantity, and administrative fee fields, indicating this is a blank draft format ready for vendor completion. Vendors are required to report detailed transaction-level data including invoice dates, customer information, plan types, unit pricing, quantities purchased, and corresponding administrative fees. The structure enables the state entity to monitor sales performance by region and product category while tracking administrative fee collections. This standardized reporting mechanism establishes the framework for ongoing contract management, revenue tracking, and vendor compliance monitoring throughout the term of the mobile device protection plan agreement.