Attachment 4 - Service Log.xlsx

This file is a Service Log template (PWS Attachment 6) for tracking and documenting call center contractor actions and service orders related to Electronic Security System (ESS) maintenance and service operations at Fort Leavenworth, Kansas. The template is designed to record service requests across a five-year contract period (2026-2030) and includes fields for documenting routine maintenance, emergency repairs, and Preventive Maintenance Inspections (PMI).

The Service Log template captures comprehensive details for each service order, including service ticket numbers, request type classification (Emergency, Routine, or PMI), caller information, date and time of call, facility location details (building and room number), problem descriptions, assigned technician information, service order submission and authorization dates, on-site visit dates and times, technician assessments, corrective actions taken, parts information (model numbers and serial numbers for both broken and replacement parts), replacement part costs, total service order costs, and resolution status. The template includes an example entry showing a $10,000 CCTV repair service order (Example 0001) completed at Fort Pistol, along with several other example service orders demonstrating approval, cancellation, and non-approval statuses. The template also tracks remaining funds calculations and Contract Line Item Numbers (CLINs) to monitor budget utilization throughout the contract period. Future year logs (2026-2030) are provided as blank templates for continued service tracking and documentation.