Lab $7-2$ Create a Balanced Scorecard Dashboard$$ Sl$$inte$-$

Case Summary: As Sl$$inte $$s management evaluates different aspects of their business, they are increasingly interested in identifying areas where they can track performance and quickly determine where improvement should be made. The managers have asked you to develop a dashboard to help track different dimensions of the Balanced Scorecard including Financial, Process, Growth, and Customer

Once you have these in place, you can create your visualizations.; To simplify the process, here are four KPIs that management has identified as high priorities:

Finance: Which products provide the highest amount of profit? The goal is $13$ percent return on sales. Use Profit ratio $=$ Total profit$/$Total sales.

Process: How long does it take to ship our product to each state on average? Management would like to see five days or less. Use Delivery time in days $=$ Ship date $$ Order date.

Customers: Which customers spend the most on average? Management would like to make sure those customers are satisfied. Average sales amount by average transaction count.

Employees: Who are our top$-$performing employees by sales each month? Rank the total number of sales by employee.

Lab $7-2$ Part $1$ Objective Questions $($LO $7-2,7-3)$

OQ$1.$ What is management$$s expected profit margin for each product?

OQ$2.$ What is the average revenue threshold for our best customers?

OQ$3.$ What color should you use to show favorable metrics?

Page $372$

Lab $7-2$ Part $1$ Analysis Questions $($LO $7-2,7-3)$

AQ$1.$ What KPIs would you consider using to evaluate sales financial performance?

AQ$2.$ What KPIs would you consider using to evaluate process efficiency?

AQ$3.$ What KPIs would you consider using to evaluate employee growth?

AQ$4.$ What KPIs would you consider using to evaluate customer relationships?

AQ$5.$ For each KPI, identify a benchmark value or KPI goal that you think management might use.

AQ$6.$ Using the available fields, identify some calculations or relationships that would support your KPIs from AQ$1$ to AQ$4?$

AQ$7.$ Are there any KPIs you selected that don$$t have supporting data fields?

Lab $7-2$ Part $2$ Objective Questions $($LO $7-2,7-3)$

OQ$1.$ Which product$($s$)$ has $($have$)$ fallen below the profit goal of $13$ percent in February $2020?$

OQ$2.$ Which state takes the most time to ship to in February $2020?$

OQ$3.$ Which salesperson is leading the rest for overall sales in February $2020?$

OQ$4.$ Which customer is our best customer in February $2020?$

Lab $7-2$ Part $2$ Analysis Questions $($LO $7-2,7-3)$

AQ$1.$ How does the balanced scorecard dashboard help management quickly identify issues?

AQ$2.$ What category of visualizations did you produce in this lab?

AQ$3.$ What additional visualizations might you include on your dashboard?