USING EXCEL TO MEASURE THE SUCCESS OF STRATEGIC INITIATIVES
KEY TERMS:
KEY PERFORMANCE INDICATORS (KPIS)
EFFICIENCY
Nota:
Comparing inputs to output
BENCHMARKS/BENCHMARKING
TYPES OF METRICS
IT
SUPPLY CHAIN
CRM
BALANCED SCORECARD
UNITS OF MEASURE
PRECISION/MATERIALITY
SAMPLING
TYPES OF MEASURES (COUNTS, RATIOS, AVGS, ETC)
PATTERNS/TRENDS
MATERIALITY
Nota:
The relevance of precision
CONCEPTS
CHARACTERISTICS OF IDEAL MEASURES
SIMPLE
Nota:
Straightforward and understandable
PRECISELY DEFINABLE
Nota:
clearly defined so that can appy and evaluate them
OBJECTIVE
VALID
Nota:
Measures precisely what is intended
ROBUST
Nota:
Not sensitive to changes in process of product
WHAT'S THE IMPORTANCE OF MEASUREMENT?
HOW DO YOU DEVISE AND CONSTRUCT PERFORMANCE MEASURES?
HOW TO EXAMINE MEASURES TO UNCOVER PATTERNS AND TRENDS
BASIC MEASUREMENT CALCULATIONS
COUNTS, RATIOS, AVGS, AND VARIANCES
In your freshman year at BYU, you earned a 3.47 GPA. Your sophomore year, you earned a 3.61 GPA. What is
the percentage difference between the GPAs you earned your freshman year and your sophomore year?
Nota:
find out the difference between the two and then divide that by the starting amount and multiply by 100
In your freshman year at BYU, you earned a 3.47 GPA. Your sophomore year, you earned a 3.61 GPA.
Assuming you took 10 credits your freshman year and 18 credits your sophomore year, what is your cumulative
GPA?