Assignment: Interpreting Key Performance Indicators
Scenario
You are the manager of a financial planning and analysis team. The executive leadership team of your company has requested that you identify two performance indicators (KPIs) or financial metrics and use them to benchmark your company's recent performance. The executive team wants a visual summary of the comparisons -- a dashboard. The dashboard must include a summary explaining the purpose and interpretation of each KPI or metric selected.
Task
Develop a 2-item KPI dashboard or scorecard in Excel using The Kroger Co (KR), a large, U.S. based grocery store chain. Kroger operates in the Retail sector of the economy, specifically in the grocery store industry. To learn more about the retail sector and/or the grocery store industry, go to the Mergent Online database and select the Industry Analysis tab. There are options for Retail and Personal Care, Drug & Grocery Stores for viewable summary reports.
Next, in the Mergent Online database, search for Kroger (use the name Kroger or stock ticker KR). The company overview includes multiple sections such as financial and competitive information. Using the available information, identify two KPIs or metrics that are pertinent to Kroger and its sector or industry. Example: inventory turnover for the retail industry or average sales revenue per store in the grocery industry.
Collect information to calculate the selected metrics for five years on Kroger and one of its key competitors (use the Competitors section for Kroger in Mergent to select and link to a competitor). Save the downloaded information in an Excel file to create the dashboard.
In the Excel file, create two data visuals (e.g. chart, graph, or comparison table with visual cues) for the dashboard using the KPI or metric data collected. At least one visual must show a trend, that is, the performance and comparisons over time using the 5-years of data collected.
In the Excel file, include a written summary that explains the items (4-8 sentences or bullet points for each KPI or metric selected). The summary must discuss why each is pertinent to the company and its sector or industry. The summary must also explain how to interpret each KPI or metric - that is, a general interpretation as well as the specific values identified for the company and its competitor.
Format your assignment according to the following formatting requirements:
(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
(2) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.