Our Services

Get 15% Discount on your First Order

Deliverable 5 – Interpreting Key Performance Indicators Assignment Content Competency

August 3, 2022

Competency
Evaluate operational performance using analytic and comparative techniques.

Student Success Criteria
View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.

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 (2) key 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.

Instructions
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 (5) 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 (2) 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.

Submit the Excel file including the downloaded data, the two (2) data visuals created as a dashboard, and the written summary information.

Resources

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Question:: Effective 21st century leaders recognize the importance of both

Question:: Effective 21st century leaders recognize the importance of both emotional intelligence (EQ) and cognitive intelligence (IQ) as driving forces in their ability to succeed. Which of the four components of EQ (self-awareness, self-management, social awareness, and relationship management) do you consider the most essential to an effective leader? Why? Use specific

Need 5 Criminal Justice Dissertation Research Topics. The research topics

Need 5 Criminal Justice Dissertation Research Topics. The research topics need to be something that doesn’t have a lot of information published on it. The topics need to be in depth because the dissertation will be between 100-300 pages. Dissertation Body, 5 Distinct Chapters: Chapter I: Introduction. Chapter II: Review

Complete worksheet A case study involving some whistleblower situations where

Complete worksheet A case study involving some whistleblower situations where a student will describe the event, what he or she believes was wrong on the part of the actors concerning the relevant stakeholders and what actions, based on a personal moral compass, would have led to a better outcome.

Water by the Spoonful

Your job is to write a director’s concept for Water by the Spoonful addressing the following questions:  What themes are present in Water by the Spoonful? How do you plan to highlight those themes?  What is the mood/atmosphere of this piece? How do you plan to create that

I want a 2100 words paper. the paper has to

I want a 2100 words paper. the paper has to be divided into 2 parts. first part (Question 1) has to be between 500-600 words. second part (Question 2, 3, 4) has to be between 1500-1600 word. all the instructions are attached in the word file. please see the attached.

Assignment Overview: Major sporting events are either hosted by the

Assignment Overview: Major sporting events are either hosted by the same organization/facility, in the same location each year, or they rotate and are hosted by a different organization/facility, in a different location each year. Creating a SWOT analysis is a critical step in the event planning process, whether the event

There are many factors that will continue to impact community

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Aegis case study MAN4720 – Premium Paper Help

Heterosexism can be found in almost every social institution within

Heterosexism can be found in almost every social institution within society, especially amongst early childhood education. For our writing assignment this week, I want you to pick your favorite childhood storybook, and apply a heterosexist analysis to it. In a 1-2 page, please answer the following questions: Directions: 1. Provide

In “An Inquiry into the Nature and Causes of the

In “An Inquiry into the Nature and Causes of the Wealth of Nations” published in 1776, Adam Smith wrote: “Nothing is more useful than water: but it will purchase scarcely anything… A diamond, on the contrary, has scarcely any use-value; but a very great quantity of other goods may frequently

DOCUMENTING | 10 Points Throughout the quarter you will be

DOCUMENTING | 10 Points Throughout the quarter you will be tasked with exploring current events, media, social media, and other forms of pop culture to analyze and document in your pop culture journal (you will be posting your journal entry to your peer discussion group on Canvas each week it

Bowel and Urinary Disorders Top of Form Bottom of Form Module 01 Content 1. Top of Form Complete the comparison tables on urinary

Bowel and Urinary Disorders Top of Form Bottom of Form Module 01 Content 1. Top of Form Complete the comparison tables on urinary disorders and bowel disorders. NUR2571_Module 01_Comparison of Bowel Elimination Disorder _v2.docx NUR2571_Module 01_Comparison of Urinary Elimination Disorder_v2.docx Bottom of Form

Marketing Strategies in Healthcare Organizations Watch: What nonprofits can learn

Marketing Strategies in Healthcare Organizations Watch: What nonprofits can learn from Coca-Cola (https://www.ted.com/talks/melinda_gates_what_nonprofits_can_learn_from_coca_cola?utm_campaign=tedspread&utm_medium=referral&utm_source=tedcomshare) In the video, Melinda Gates talks about the marketing strategies Coca-Cola uses to reach even the most remote parts of the world, and the success that they have had with this. How can these strategies be applied

An impoverished 69-year-old man is diagnosed with cancer of the

An impoverished 69-year-old man is diagnosed with cancer of the pancreas. There is no hope for cure, but radiation and chemotherapy, which could cost more than $150,000, may extend his life for a few months. If this patient unambiguously requests treatment, his doctors may struggle with the decision but will

Write about about antibiotic

REDESIGN TASK AND SUBMISSION GUIDELINES Please create a report in a ppt file. It should include messages you want to deliver about antibiotics with at least two charts hat support your messages. You do not need to address everything about the dataset. However, you should emphasize your messages in

Personal Development Portfolio: Initial reflection

Developing HR Policy The Personal Development Portfolio (PDP) provides the framework to help you expand your academic, professional and career development; build and sustain a personal learning network; articulate your professional goals; and reflect on your skills through various strategies and assessments. In this module there are two PDP submissions.

Civil Disobedience For this assignment, make sure you post your

Civil Disobedience For this assignment, make sure you post your initial response to the Discussion Area by the due date assigned. To support your work, use your course and text readings and also use outside sources. As in all assignments, cite your sources in your work and provide references for

How does Genesis 1:27-28 (https://www.biblegateway.com/passage/?search=Genesis+1:27-28) and Genesis 2:8-9, 15-17 (https://www.biblegateway.com/passage/?search=Genesis+2%3A8-9%2C+15-17+&version=NIV)

How does Genesis 1:27-28 (https://www.biblegateway.com/passage/?search=Genesis+1:27-28) and Genesis 2:8-9, 15-17 (https://www.biblegateway.com/passage/?search=Genesis+2%3A8-9%2C+15-17+&version=NIV) provide insight for the three basic economic questions of what to produce, how to produce it, and for whom to produce? You may skim over the following article from the Institute of Faith, Work, and Economics for reflection. It is