USING EXCEL TO MEASURE THE SUCCESS OF STRATEGIC INITIATIVES

USING EXCEL TO MEASURE THE SUCCESS OF STRATEGIC INITIATIVES

1. KEY TERMS:

   • KEY PERFORMANCE INDICATORS (KPIS)
   • EFFICIENCY
     • 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
     • The relevance of precision

2. CONCEPTS

   • CHARACTERISTICS OF IDEAL MEASURES
     • SIMPLE
       • Straightforward and understandable
     • PRECISELY DEFINABLE
       • clearly defined so that can appy and evaluate them 
     • OBJECTIVE
     • VALID
       • Measures precisely what is intended
     • ROBUST
       • 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?
     • 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?
     • 3.56