Attachment 4 - Service Log.xlsx

This is a Service Log template (PWS Attachment 6) designed to track and document maintenance and service activities for an Electronic Security System at Fort Leavenworth, Kansas. The template provides a framework for recording service ticket information across multiple years (2022-2030) and includes columns for essential operational data such as service ticket numbers, call type (Emergency, Routine, or Preventive Maintenance Inspection), caller information, service location details, problem descriptions, technician assignments, service order submission and authorization dates, site visit information, technical assessments, corrective actions, parts replacement details, costs, and service completion status. The example entries demonstrate tracking of CCTV repairs, access control system installations, intrusion detection alarm investigations, and cybersecurity remediation work, with individual service order costs ranging from $5,000 to $35,000 and remaining fund calculations to monitor quarterly budget utilization.

The template includes quarterly budget tracking with an initial awarded amount of $60,000, showing remaining funds calculations as service orders are completed, approved, or cancelled. The log distinguishes between different cost line items (CLINs) and tracks whether preventive maintenance inspections (marked as PMI entries requiring $0.00 cost) are completed separately from billable corrective maintenance work. The template is formatted to accommodate ongoing monthly, quarterly, or semi-annual reporting periods and is designed to integrate with a larger Performance Work Statement for comprehensive electronic security system maintenance services including Physical Access Control Systems (PACS), Intrusion Detection Systems (IDS), and Closed-Circuit Television (CCTV) systems.