Before starting to build a BSC, it is necessary to gather all the information at a strategic level, which will serve as input for building the logistics dashboard in Excel . When starting, it will also help us to prepare a checklist of strategic information sources. To start our BSC in Excel, we have established 7 guide points:
1. Board
balanced scorecard indicationsThe Board (or Dashboard ) shows our strategic vision in a global way through four axes or perspectives:
Customer Relationship: This perspective identifies and evaluates customer opinions and needs, such as satisfaction, rate of return or profitability, in order to offer a better offer aligned with their preferences.
Finance: This perspective is controlled from the highest levels, since it is related to business figures such as profits, risk, sales growth, gross/net margin, etc., and responds to the needs of the shareholder.
Internal Processes: Identify the organization's and production's strategic objectives and metrics. Determine its value propositions and competitive advantages to align key activities and processes that generate quality.
Learning and growth: Refers to the capacity for growth bosnia-and-herzegovina phone number data and adaptation that an organization can generate through the development of its human resources.
2. Strategic objectives
As for how to make a CMI in Excel, defining the strategic objectives from each perspective is a priority.
The most common objectives that we analyze in an Excel dashboard are the following, according to axes:
Customer relationship : the total number of customers (participants and new customer acquisition), measured through indicators such as market share and percentage of new customer revenue; customer satisfaction through surveys, complaint or suggestion percentages, response times, etc.; customer loyalty through indicators such as purchase frequency index or average user retention time; and finally, the reduction of delivery times measurable through the time invested in it.
Finance: the creation of value through indicators, the sustainability of that value in the future, growth rates at an individual level together with those of the sector at a global level, turnover, profitability measured with indicators, costs, financial structure and, finally, liquidity.
Internal Processes: reduction of production costs, individual production costs, improvement of processes and their total number, process performance, total number of defects and total cycle times, among others.
Learning and Growth: talent, skills, know-how and competencies, which are measured through staff selection and training indicators; information capital: value creation, strategy construction, time and cost objectives of this process; organisational capital: leadership, culture and teamwork.