IN2004B: Generation of Value with Data Analytics
Department of Industrial Engineering
“Management is the process by which an environment is designed and maintained in which individuals working in groups effectively accomplish specific goals.”
Koontz, Harold, “Management,” 14th Edition, McGraw Hill, 2012
The management process is broken down into five management functions:
As a result of the planning process, some of the following types of plans can be generated:
High need to measure progress
As a result of the planning process, some of the following types of plans can be generated:
High need to measure progress
Specific: An objective should be clear and specific, avoiding ambiguity. It should answer the questions what, who, when, where, and why.
Measurable: An objective should be quantifiable or at least evaluable to determine progress and success. It should be possible to measure it with tangible indicators or criteria.
Achievable: A goal should be realistic and achievable, considering available resources, time, and necessary skills.
Relevant: A goal should be relevant and aligned with the broader goals of the organization or individual.
Time-bounded: A goal should have a clearly defined timeframe or deadline.
Example 1:
Objective: Complete staff training.
SMART: Complete at least 90% of the 2014 training program for all company operating personnel by November 30 of this year.
Example 2
Objective: Increase sales by 20%.
SMART: Achieve a sales increase of product X of at least 17% by the end of the first half of 2015, while maintaining a profitability for the company of at least 5%.
To carry out the Planning, Implementation, and Control processes, we need an information system to evaluate whether the planned objectives are being achieved and whether the implemented actions are being carried out in accordance with the plans.
“It is the result of a quantitative or qualitative measurement, or some other criterion, by which the performance, efficiency, achievement, etc., of a person or organization can be evaluated, often compared to a standard or goal.”
Collins English Dictionary.
“The qualitative and/or quantitative information on an examined phenomenon (or a process, or a result), which makes it possible to analyze its evolution and to check whether quality targets are met, driving actions and decisions.”
Franceschini, Fiorenzo & Galetto, Maurizio & Maisano, Domenico. (2007). Management by Measurement: Designing Key Indicators and Performance Measurement Systems. 10.1007/978-3-540-73212-9.


Fundamental:
Validity: The indicator must accurately reflect the actual behavior of the phenomenon, variable, result, etc., to be measured.
Stability: The indicator must be defined, calculated, and interpreted in the same way over time (allowing for comparisons and observing trends).
Ideal:
Indicators and the data that drive them are often stratified with respect to other variables.
Variables used as stratification criteria are called “Analysis Dimensions” (they are dimensions from the perspective of data).
Example: In a sales process, monthly sales can be stratified by distribution channel, region of the country, product family, etc., for analysis and visualization purposes.
Selecting indicators is a critical factor for an organization to move closer to fulfilling its mission and turning its strategies into reality. Indicators and strategies are inextricably linked.
A strategy without indicators is useless; indicators without a strategy are irrelevant!
A lagging indicator measures the outcome of performance at the end of a period. It is backward-looking because it shows us the consequences of what has already been done. They are also known as result indicators.
A leading indicator measures the performance of factors that are critical now to achieving a desired outcome in the future.
Goal: Measures the outcome of performance at the end of a period.
Example: Annual sales, market share, ROI.
Advantage: They are objective.
Disadvantage: They reflect the effect of past actions.
Goal: Measures processes, activities, behaviors that tend to change before the system starts to follow a particular pattern or trend.
Example: # of customers visited, # of courses offered
Advantage: They are predictive, allowing for strategy corrections
Disadvantage: Based on cause-and-effect hypotheses.
In the context of a YouTuber:
Leading indicator: Number of views of a YouTube video in the first 24 hours.
Lagging indicator: Monthly revenue generated from monetization.
In the context of Netflix’s sales department:
Leading indicator: Number of users who start a free trial in a given month.
Lagging indicator: Monthly revenue from subscriptions.
In the context of a GenAI company:
Leading indicator: Number of programmers hired with expertise in AI.
Lagging indicator: Number of licenses sold per year.
In the context of a mini-split maintenance company:
Leading indicator: Average response time from technical support to support requests.
Lagging indicator: Number of positive reviews on Google Maps in a month.
Selection criteria:
Direct relationship with the objective to be measured
Ease of communication focused on the strategy
Repeatability and reliability
Update frequency
Usefulness in goal setting
Usefulness in assigning responsibilities
Usefulness for downward deployment
A basic indicator is obtained from the direct measurement of a phenomenon or fact. For example: Number of orders delivered completely and on time during the week.
A derived indicator combines the information from two or more basic or derived indicators. For example: Percentage of orders delivered completely and on time during the week.
Example: in Failure Modes and Effects Analysis
Basic indicators: Severity, Occurrence, Detection
Derived indicator: Risk Priority Number = S \(\times\) O \(\times\) D
An indicator should be measured numerically using:
Absolute Numbers: Results of a measurement or counting process (volume produced, share price, number of employees, fixed costs, etc.)
Rates: Relationship between two variables with different units (number of units / number of workers, energy consumption / liters produced, etc.)
Indexes: Dimensionless quantity resulting from dividing the current value of a variable by a reference base value for that variable (consumer price index)
Proportions: Relationships between two variables measured in the same units (men vs. women, admitted vs. rejected)
Growth or Decrease Percentages: (Current Value – Previous Value)*100/Previous Value.
Evaluations: Evaluations of a qualitative variable on a Likert-type ordinal scale (low, medium, high, terrible, bad, average, good, excellent).
For the following concepts, propose one leading and one lagging (basic and derived) quantitative indicators:
Monthly productivity of a furniture production line
Annual staff turnover in a manufacturing company
Customer service level of a company that manufactures plastic packaging and delivers regionally
Business profitability for a medium-sized wholesale grocery company
Performance of the fundraising process of an association supporting homeless children
The purposes of an indicator are:
Establish quantitative goals.
Organizational motivation, induction of desirable behaviors.
Strategy evaluation and strategic learning.


Tecnologico de Monterrey