Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Week 7 Exercise Make a check sheet (simply count the number of occurrences for each type of repair and put them in a table) and

Week 7 Exercise

Make a check sheet (simply count the number of occurrences for each type of repair and put them in a table) and then a Pareto chart for the following car service repair shop data. Please note that there is a total of 30 repairs, called Work (each one with its own ticket number). Do your calculations in Excel and submit your complete file including the chart.

image text in transcribed
Ticket Ticket Ticket No. Work No. Work No. Work 1 Tires 11 Brakes 21 Lube & oil 2 Lube & oil 12 Lube & oil 22 Brakes 3 Tires 13 Battery 23 Transmission 4 Battery 14 Lube & oil 24 Brakes 5 Lube & oil 15 Lube & oil 25 Lube & oil 6 Lube & oil 16 Tires 26 Battery 7 Lube & oil 17 Lube & oil 27 Lube & oil 8 Brakes 18 Brakes 28 Battery 9 Lube & oil 19 Tires 29 Brakes 10 Tires 20 Brakes 30 Tires

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

College Accounting A Practical Approach

Authors: Jeffrey Slater, Mike Deschamps

14th Edition

0134729315, 978-0134729312

More Books

Students also viewed these Accounting questions

Question

2. What types of information are we collecting?

Answered: 1 week ago

Question

5. How quickly can we manage to collect the information?

Answered: 1 week ago

Question

3. Tactical/strategic information.

Answered: 1 week ago