Question

Required information {The following information applies to the questions displayed below.) The following are the car repair shop data: Ticket No. Work Tires Ticket No. 11 1 2 13 NNN Brakes Tires Brakes Tires Lubek oil Brakes Brakes Lube & oil Battery Work Lube & oil Lube & oil Tires Brakes Transmission Battery Lube & oil Lube & oil Brakes Lube & oil Ticket Net Ticket No. Work Lube & oil Tires Lube & oil Lube & oil Lube & oil Tires Battery Lube & oil Brakes Tires 19 a. Prepare a check sheet for the above car repair shop data: Frequency Work Type Lube & oil Brakes Tires Battery Transmission Total

Answer 1

a)

Check sheet is constructed by counting the tickets of each work type

For example, for work type Tires, frequency is 7, (ticket # 1,3,5,13,22,26,30)

Resulting check sheet is following:

Work Type	Frequency
Lube & Oil	12
Brakes	7
Tires	7
Battery	3
Transmission	1
Total	30

b)

Steps to draw pareto chart

1. Sort the Work Type in descending order of frequency.

2. Compute % frequency for each Work Type by dividing its frequency by Total.

3. Compute cumulative % frequency as running sum of % frequency.

4. Plot the frequency on primary axis and cumulative % frequency on secondary axis of the same chart.

5. Focus on Work Type that comprise top 20% of all, but has 80% cumulative frequency

Work Type	Frequency	% of Total	Cumulative %
Lube & Oil	12	40%	40%
Brakes	7	23%	63%
Tires	7	23%	87%
Battery	3	10%	97%
Transmission	1	3%	100%
Total	30

Pareto Chart -100% 14 12 hi. 90% 12 -80% - 70% 10 60% -50% -40% 30% 4 3 -20% 10% -0% Lube & Oil Brakes Tires Battery Transmission Work Type Aɔuənbai Cumulative %