IHG酒店集团风险管理计划.doc

Fire Life Safety - Action Plan

Welcome

Welcome to this delegate information guide for the ' Introduction to Risk Management Workshop'.

This pack contains the information we talk about during the session it can be used as a reference guide as we progress through the session.

The contents of this session are detailed below

Contents Page
Session objectives
2
The Risk Management Action Plan
2
What needs to covered in the plan
2
Basic Excel Commands – Auto Filter
3
Basic Excel Commands – Header & Footer
5
Basic Excel Commands – Moving & copying Data (Cut & Paste)
7

Please also see the example Risk Management Action Plan

Session four, RISK MANAGEMENT Action Plan
By the end of this session you will be able to:-
n Describe what the plan is and why we use it
n Explain at least three basic excel commands to customise your plan
n Define both good and bad entries into the plan and explain why that is
n Explain how you use the plan to prepare for your RISK MANAGEMENT meetings at Hotel, AGM and DOO level

The Risk Management Action Plan

The RISK MANAGEMENT Action Plan is an Excel Workbook designed to house all the RISK MANAGEMENT issues in your hotel. It is a working document and is used by the RISK MANAGEMENT committee monthly when they review :-

n New issues being added to the plan
n Progress on completion of action points
n Completed action points

It is also used by the Regional team to

n Ensure RISK MANAGEMENT issues are being addressed (RISK MANAGEMENT Calendar points)
n Track progress on completion of Items
n Identify common themes
n Identify common training needs
n Ensure funds are budgeted to address emerging risks

The RISK MANAGEMENT action Plan will :-

n Have unique identification numbers allocated to each issue / risk
n Have all RISK MANAGEMENT issues / risks the hotel faces listed
n Have issues / risks correctly rated
n Have issues correctly dated
n Have issues correctly categorised by risk type
n Have deadlines set which reflect the risk rating
n Have named individuals allocated for each action
n Ensure that the Planned Actions adequately address the issues / risks
n Assist in ensuring all Departments take responsibility for their issues
n Ensure operational issues are addressed effectively by the hotel
n Assist in raising owner issues effectively with the Owners
n Assist in ensuring owners face their responsibilities
n Have Capital / P&L issues identified with action
n Have completed actions suitably archived
n Be used by Area and Regional representatives?
Customising your Action Plan by using basic excel commands

About filtering

Filtering is a quick and easy way to find and work with a subset of data in a list. A filtered list displays only the rows that meet the criteria you specify for a column. Microsoft Excel provides two commands for filtering lists:

1 AutoFilter, which includes filter by selection, for simple criteria
2 Advanced Filter, for more complex criteria

For our RISK MANAGEMENT Action Plan we will only use the Auto Filter option See fig 1

Unlike sorting, filtering does not rearrange a list. Filtering temporarily hides rows you do not want displayed. See fig 2

When Excel filters rows, you can edit, format, chart, and print your list subset without rearranging or moving it.

Auto Filter Fig 1

Fig 2

Below we can see we have selected column G " areas in the hotel" from the drop down box we have chosen Public Areas, now Excel hides all other rows and only shows us the Public Area information. This can be repeated by all the areas in the Hotel, so each department head can receive his or her own list of action points. You can filter one column heading from each column. For example you could choose to see only Capex issues in the Kitchen or only items with a risk rating of 6 etc.

To return to the full list simply go to data, filter, and auto filter switching the filter command off. You can see if the auto filter command is on by a tick to the left of the words Auto Filter in the pick box. If there is no tick the command is switched off.

About headers and footers

Headers and footers are areas in the top and bottom margins of each page in a document.

You can insert text or graphics in headers and footers — for example, page numbers, the date, a company logo, the document's title or file name, or the author's name — that are printed at the top or bottom of each page in a document.

You can work in the header and footer areas by clicking Header and Footer on the View menu. See Fig 3

Fig 3

About Print area

1 On the View menu, click Page Break Preview.
2 Select the area you want to print.
3 On the File menu, point to Print Area, and then click Set Print Area. See Fig 4

When you save the document, your print area selection is also saved.

Fig 4

About moving and copying data

When you copy a cell by dragging or by clicking Cut or Copy, and Paste, Microsoft Excel copies the entire cell, including formulas and their resulting values, comments, and cell formats.

There are no hidden cells in the RISK MANAGEMENT action plan. However, if the selected copy area includes hidden cells, Excel also copies the hidden cells. If the paste area contains hidden rows or columns, you might need to unhide the paste area to see all of the copied cells.

Once an action point has been completed you Cut the entire row from the Action Plan sheet to the completed actions sheet, clicking on the row number to the left of the column A ensures the entire row is selected – see Fig 5

Fig 5

Now that the row has been selected go to the Completed Actions Points sheet, select the row you wish to paste the information into and click paste, see Fig 6

Fig 6

9