1. Choose a Key Performance Indicator (KPI), such as those examples listed in Table 1.3, for an actual company.

2. Create a time series based KPI chart that consists of at least six actual data points that have been accumulated over a period of time. These actual data points are typically compared to a target value. Deviations from target indicate poor performance and opportunity for improvement. Please create this KPI chart in Microsoft Excel. In Excel, time series charts are called ?line charts.? There are many YouTube videos which will show you how to create a line chart using your particular version of Excel. An example is as follows:

3. What conclusions can be drawn from the KPI chart?

Transcribed Image Text:

January February March April May June July August September October November December January February March April May June July сл 10 Target -Number of Defectives 15 20 25 January February March April May June July August September October November December January February March April May June July сл 10 Target -Number of Defectives 15 20 25

Answer rating: 100% (QA)

Key Performance Index A key performance indicator chart is one used in an analysis of some of the key performance metrics that have been demonstrated ... View the full answer