Hotel Management Scorecard for Excel

KPIs are employed by organizations to keep a track of the direction it is heading into. These can be formulated in various areas, which are of significant value to the business.
Financial Perspective generally forms a part of the BSC (Balanced scorecard) and with regard to hotel management the others may relate to Customer perspective, Efficiency and Staff perspective.
Financial Perspective is to keep the organization running, in monetary terms. It can be obtained by using parameters like wage costs as a % of sales, annual operating profit per room, , food costs as a percentage of food sales and % increase in labor costs.
Customer Perspective is to have a means to know how the organization is faring in terms of providing value to the end-users. The indicators hat can help are number of feedbacks, number of complaints received, response rate and frequent customers as a % of total customers.
Efficiency can be judged from % of room booked through reservation channels, internet bookings, rate of room occupancy, rate of sales inquiry conversion and average length of stay.
Staff Perspective is yet another ingredient that deserves consideration. Staff turnover, technological competence of staff, average length of employment and number of training sessions are the indicators that can be used to derive the organizational picture from the view point of the staff