Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a KPI dashboard for TYR Corp. TYR distributes and install four products. Data is available for the 2019 operations up to August. It

image text in transcribed

Develop a KPI dashboard for TYR Corp. TYR distributes and install four products. Data is available for the 2019 operations up to August. It includes per product sales (in $), inventory days, and rework (bad installations that required rework). For each month there is also two general data items, the number of new customers and the number of complaints. The company has as targets: inventory days: 10 days rework: 2% new customers/month: 250 complaints: 2 The dashboard should have 4-6 graphs that include sales, inventory days, rework, new customers and complaint information. Should have at least one pie chart. There should be several slicers (related to time and products). Aim to include targets in the plots. Include names of all team members in the Excel file (sheet called Team)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial and Managerial Accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

2nd edition

978-1119036357, 1119036356, 1118338413, 1118334264, 978-1118338414, 978-1118334263

More Books

Students also viewed these Accounting questions

Question

Quadrilateral EFGH is a kite. Find mG. E H Answered: 1 week ago

Answered: 1 week ago