APPENDIX A - City of Windsor Audit Recommendation Tracking Summary - March 31, 2020

Finding # Recommendation/Topic CLT Member Responsible Assigned to Audit Report/Source Audit Unit/Firm Date Issued Target Date for Implementation Current Status (as of March 31, 2020) Additional Comments
238 Enhance controls over authorization, recording and release of materials to contractors City Engineer Senior Manager of Traffic Operations Hotline Investigation - NTS-002-NOV-2018 PwC July 29, 2019 2019 Q4 Closed  
239 Formalize Incident Management Plan and Procedures Chief Financial Officer Executive Director Information Technology Cyber Response Strategy Assessment PwC September 23, 2019 2020 Q4 In progress  
240 Enhance Security Information and Event Management Chief Financial Officer Executive Director Information Technology Cyber Response Strategy Assessment PwC September 23, 2019 2020 Q4 In progress  
241 Develop Incident Severity Matrix and Methodology for Incident Response Times using Critical Asset Classification. Chief Financial Officer Executive Director Information Technology Cyber Response Strategy Assessment PwC September 23, 2019 2021 Q1 In progress  
242 Formalize Incident Response Tabletop Exercises Chief Financial Officer Executive Director Information Technology Cyber Response Strategy Assessment PwC September 23, 2019 2020 Q2 In progress  
243 Develop Working Procedures for Planning and Development Application Processing City Solicitor City Planner Planning and Development PwC February 24, 2020 2020 Q3 In progress  
244 Review and Prioritize Action PlanImplementation of 2014 Business ProcessReview Findings City Solicitor City Planner Planning and Development PwC February 24, 2020 2020 Q4 In progress  
245 Consideration to make disclosure to citizens clear and concise. City Engineer Coordinator, Right of Way & Field Services Hotline Investigation Report - NTS-003-SEP-2019 PwC February 24, 2020 2020 Q4 In progress  
246 Document formal agreement for restoration arrangement with CHAA CLT-Parks, Facilities, Recreation &Culture Executive Director of Recreation and Culture Complaint Investigation Report - Lancaster Plane Auditor General February 24, 2020 2020 Q4 In progress  
247 Ensure contract compliance by retention of relevant documentation CLT-Parks, Facilities, Recreation &Culture Director of Finance, YQG Complaint Investigation Report - Lancaster Plane Auditor General February 24, 2020 2020 Q4 In progress  
PwC VERIFIED COMPLETION 
OPEN AND DELAYED