APPENDIX A - City of Windsor Audit Recommendation Tracking Summary - September 30, 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 September 30, 2020) Additional Comments
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 andMethodology for Incident Response Times usingCritical 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 Complete pending validation by PwC  
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 Plan Implementation 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 Item retargeted to 2021 Q2  
248 Establish control to independently review the payment certificate calculation template City Engineer Contract Co-ordinator VFM Purchased Services Winter Road Clearing PwC May 25, 2020 2020 Q4 Complete pending validation by PwC  
249 Leverage existing real time GPS records to improve vendor performance monitoring City Engineer Maintenance Co-ordinator VFM Purchased Services Winter Road Clearing PwC May 25, 2020 2020 Q4 Complete pending validation by PwC  
250 Formally amend contract terms to minimize risk of potential contract dispute City Engineer Contract Co-ordinator VFM Purchased Services Winter Road Clearing PwC May 25, 2020 2020 Q4 In progress  
251 Establish protocols for joint ownership of security policies and monitoring controls Commissioner - Parks,Recreation, Culture &Corporate Facilities Senior Manager, Facilities Security Incident Prevention and Mitigation PwC May 25, 2020 2021 Q4 Due 2021 Q4  
252 Define responsibilities to monitor contractual requirements Commissioner - Parks,Recreation, Culture &Corporate Facilities Senior Manager, Facilities Security Incident Prevention and Mitigation PwC May 25, 2020 2022 Q4 Due 2022 Q4  
253 Confidential action plan Commissioner - Parks,Recreation, Culture &Corporate Facilities Senior Manager, Facilities Security Incident Prevention and Mitigation PwC May 25, 2020 2020 Q4 In Progress  
254 Enhance protocols for managing and documenting dynamic security plans Commissioner - Parks,Recreation, Culture &Corporate Facilities Senior Manager, Facilities Security Incident Prevention and Mitigation PwC May 25, 2020 2020 Q4 In Progress  
255 Formalize evidence of ongoing flexible/alternative work arrangements City Clerk Executive Director, Human Resources Hotline investigation report - NTS 005 - FEB - 2020 PwC May 25, 2020 2021 Q1 Item retargeted to 2021 Q2  
256 Formalize central insight into all flexible/alternative agreements in effect City Clerk Executive Director, Human Resources Hotline investigation report - NTS 005 - FEB - 2020 PwC May 25, 2020 2021 Q1 Item retargeted to 2021 Q2  
COMPLETE PENDING VERIFICATION 
OPEN AND DELAYED