This Excel document provides a set of templates to capture data and analysis when conducting a Business Continuity Planning (BCP) and Disaster Recovery (DR) project for any size organization. These templates were originally developed for a large, international enterprise with locations in multiple geographies.
This workbook contains 5 sections:
Business Impact Ratings – This sheet captures every critical business process (CBP), as identified by their respective owners, within the organization. For each CBP, important information is captured: e.g. impact analysis, tier rating, dependencies, and critical times.
Current State Inventory – This sheet provides a high-level snapshot of the organization's readiness to respond to a crisis or emergency. Information to be inventoried includes alternate work sites, laptops, remote access connections, Blackberries, DR plans, BCPs, and phone trees.
Inventory and Assessment – This template captures important emergency contact and facility information for all domestic and international sites within the organization.
Findings Report – This spreadsheet outlines all findings and issues within the organization, as identified through the BCP evaluation process. Each such finding is associated with a risk type; analyzed for possible remediation; associated with department(s); associated with critical business processes (as identified in Business Impact Ratings); and rated on several measures of risk, urgency, and cost to remediate.
Risk Category Definitions – Each BCP finding is categorized within a defined set of 16 risk types to facilitate the analysis of similar findings and risks. These risk category definitions are captured in this spreadsheet.
This comprehensive toolkit also includes detailed sections for capturing critical business process dependencies and impact analyses, ensuring that no aspect of your organization's continuity is overlooked. The templates facilitate the identification of alternate work sites and remote access capabilities, essential for maintaining operations during disruptions. Each section is meticulously designed to support thorough data collection and analysis, providing a robust framework for assessing and mitigating risks. This resource is indispensable for executives aiming to fortify their organization's resilience against unforeseen events.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in BCP, Business Continuity Planning, Crisis Management, Business Continuity Management Excel: Business Continuity Planning (BCP) & Disaster Recovery (DR) Templates Excel (XLSX) Spreadsheet, giovanni
BCP Business Continuity Planning Crisis Management Business Continuity Management Disaster Recovery Business Impact Analysis Change Management Organizational Change Project Management Program Management PMO Digital Transformation Customer Experience Business Transformation Digital Transformation Strategy Cyber Security User Experience Customer Strategy Cybersecurity Mobile Strategy Organizational Transformation IT Security Corporate Transformation Business Framework PowerPoint Diagrams Management Model PowerPoint Diagrams Process Improvement Business Process Re-engineering Business Process Improvement Bain PowerPoint McKinsey PowerPoint Bain Presentations Bain Frameworks Boston Consulting Group PowerPoint Consulting Frameworks Strategy Frameworks Mercer PowerPoint PwC PowerPoint Bain Templates Accenture Templates McKinsey Templates Boston Consulting Group Templates Accenture PowerPoint Consulting Methodologies Booz Documents PwC Templates Capgemini PowerPoint Strategy Frameworks Compilation Oliver Wyman Presentations Boston Consulting Group Frameworks E&Y PowerPoint Consulting Training IBM Presentations Oliver Wyman Templates Strategy Consulting Frameworks Bain Documents IBM Documents Capgemini Documents Roland Berger PowerPoint A.T. Kearney PowerPoint BCG Documents Accenture Frameworks BCG Frameworks BCG PowerPoint Oliver Wyman PowerPoint Consulting Documents BCG Presentations A.T. Kearney Documents Management Consulting Frameworks BCG Templates E&Y Templates Roland Berger Presentations Capgemini Templates Boston Consulting Group Documents LEK Frameworks Booz Allen Presentations E&Y Frameworks McKinsey Presentations Booz Allen Frameworks A.T. Kearney Frameworks IBM Templates Booz Allen PowerPoint Accenture Documents Accenture Presentations A.T. Kearney Templates McKinsey Frameworks Boston Consulting Group Presentations McKinsey Documents LEK PowerPoint Mercer Templates Roland Berger Frameworks Capgemini Frameworks Booz Presentations Roland Berger Templates Strategy Methodologies PwC Frameworks Booz Allen Templates Booz Templates Strategy& Presentations Management Consulting Training Oliver Wyman Documents Mercer Presentations LEK Documents PwC Presentations LEK Templates Capgemini Presentations IBM PowerPoint E&Y Documents Oliver Wyman Frameworks Booz Allen Documents PwC Documents IBM Frameworks Mercer Frameworks Mercer Documents LEK Presentations Booz PowerPoint Strategy Documents Booz Frameworks A.T. Kearney Presentations Roland Berger Documents Business Frameworks E&Y Presentations Strategy& PowerPoint Deloitte PowerPoint Consulting Process A.T. Kearney Frameworks A.T. Kearney PowerPoint A.T. Kearney Templates A.T. Kearney Documents A.T. Kearney Presentations Gap Analysis Business Case Development Financial Modeling Business Case Example Business Case Template Capital Budgeting Business Case Sample Business Case Capital Budgeting Business Case PowerPoint Diagrams Compilation Consulting PowerPoint Templates Consulting PowerPoint Diagrams PowerPoint Diagrams Library Strategic Planning Hoshin Operational Excellence Hoshin Kanri Strategy Execution Policy Deployment Strategy Deployment Hoshin Planning Strategy Deployment & Execution COVID-19 Coronavirus ISO 22301
![]() |
Receive our FREE presentation on Operational Excellence
This 50-slide presentation provides a high-level introduction to the 4 Building Blocks of Operational Excellence. Achieving OpEx requires the implementation of a Business Execution System that integrates these 4 building blocks. |