USING EXCEL TO MEASURE THE SUCCESS OF STRATEGIC INITIATIVES
1 KEY TERMS:
1.1 KEY PERFORMANCE INDICATORS (KPIS)
Comparing inputs to output
1.4 TYPES OF METRICS
1.4.2 SUPPLY CHAIN
1.5 BALANCED SCORECARD
1.6 UNITS OF MEASURE
1.9 TYPES OF MEASURES (COUNTS, RATIOS, AVGS, ETC)
The relevance of precision
2.1 CHARACTERISTICS OF IDEAL MEASURES
Straightforward and understandable
2.1.2 PRECISELY DEFINABLE
clearly defined so that can appy and evaluate them
Measures precisely what is intended
Not sensitive to changes in process of product
2.2 WHAT'S THE IMPORTANCE OF MEASUREMENT?
2.3 HOW DO YOU DEVISE AND CONSTRUCT PERFORMANCE MEASURES?
2.4 HOW TO EXAMINE MEASURES TO UNCOVER PATTERNS AND TRENDS
2.5 BASIC MEASUREMENT CALCULATIONS
2.5.1 COUNTS, RATIOS, AVGS, AND VARIANCES
2.6 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?
find out the difference between the two and then divide that by the starting amount and multiply by 100
2.7 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