09.Appendix G - Professional Broadcast Report Template.xlsx

This file is a Professional Broadcast Report Template designed for agencies utilizing the Commonwealth of Pennsylvania's Professional Broadcast, Audio Visual & Multi-Media Equipment and related services contract. The template provides standardized reporting formats across multiple categories: a Sales Report for tracking orders and invoices; a Problem & Response Report for documenting maintenance and service incidents with associated timelines; a Service Level Report for monitoring compliance with defined service levels; and an Outstanding Issues Report for summarizing unresolved items by agency location. The template accommodates eight distinct service level categories, including Remote Site Maintenance, Preventative Maintenance, Corrective Maintenance, Fleet Changeover, Equipment Installation, Equipment Removal, Engineering Services, and Additional Services. Required data fields encompass comprehensive agency information, equipment specifications (including original equipment manufacturer details and serial numbers), detailed timestamps for service calls and responses, and service level achievement metrics (Yes/No indicators for compliance).

The template is structured to capture financial information through order details, unit costs, markups, and total order values, facilitating tracking of equipment purchases and maintenance expenditures across multiple agencies. Service level documentation requires recording both requested and actual response dates and times using 24-hour format, enabling agencies to verify contractor compliance with predetermined response time commitments. The template includes a holiday calendar spanning 2013 through 2016, incorporating federal holidays and validation dates that likely correspond to billing cycles or service review periods. The Outstanding Issues Report section allows agencies to document unresolved problems with location-specific details, providing accountability mechanisms for ongoing service delivery gaps or equipment concerns requiring escalation or further investigation.