BUY WITH CONFIDENCE
DESCRIPTION
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.
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 Business Continuity Planning, Business Impact Analysis Excel: Business Continuity Planning (BCP) & Disaster Recovery (DR) Templates Excel (XLSX) Spreadsheet, giovanni
OVERVIEW
(XLSX)
ABOUT THE AUTHOR
Business Continuity Planning Business Impact Analysis Project Management Strategic Planning Hoshin Kanri Strategy Deployment & Execution Operational Excellence Consulting Frameworks Strategy Frameworks Consulting Training COVID-19 Business Resilience ISO 22301 Leadership CEO Scenario Planning
![]() |
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. |