Question: Chapter 5: Managing Quality Here is the data on the following car service repair shop data. Assignment: 1) Make a check sheet (must be computer

Chapter 5: Managing Quality

Here is the data on the following car service repair shop data.

Assignment:

1) Make a check sheet (must be computer generated) 1 mark

2) Perform a Pareto Analysis on ALL seven sets of data collected including the Pareto chart and graph using Microsoft Excel (import/embed excel worksheet to show all Excel formulas used). Round each answer up - no decimals. Analysis 1 mark, Graph 1 mark & import/embed of excel worksheet 2 marks

Ticket No.

Work

Ticket No.

Work

Ticket No.

Work

1

Battery

22

Tires

43

Lube & Oil

2

Tires

23

Lube & Oil

44

Lube & Oil

3

Tires

24

Brakes

45

Brakes

4

Lube & Oil

25

Transmission

46

Tires

5

Brakes

26

Brakes

47

Tires

6

Transmission

27

Tires

48

Lube & Oil

7

Lube & Oil

28

Tires

49

Lube & Oil

8

Lube & Oil

29

Battery

50

Brakes

9

Tires

30

Transmission

51

Tires

10

Battery

31

Lube & Oil

52

Muffler

11

Air Condition

32

Lube & Oil

53

Battery

12

Lube & Oil

33

Air Condition

54

Air Condition

13

Tires

34

Brakes

55

Lube & Oil

14

Lube & Oil

35

Tires

56

Lube & Oil

15

Brakes

36

Brakes

57

Lube & Oil

16

Transmission

37

Battery

58

Battery

17

Lube & Oil

38

Brakes

59

Lube & Oil

18

Lube & Oil

39

Tires

60

Lube & Oil

19

Lube & Oil

40

Tires

61

Lube & Oil

20

Battery

41

Lube & Oil

62

Tires

21

Transmission

42

Lube & Oil

63

Tires

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

ACCT 5131 Spreadsheet Project Summer 2019 Guidelines Please read the guidelines in the Identifying Elements of a Financial Model section in Chapter 12 of the Hilton (2008) textbook (now...

Q:

I would like assistance with assignment 3 and 4 on the attached document I have been struggling with the subject and its my last AUI4863/102/0/2016 Tutorial letter 102/0/2016 ADVANCED INTERNAL AUDIT...

Q:

Two Discussion Questions. A minimum of 200 words per question. Both questions are attached to the word document and each chapter to both questions are attached to the PDF. Any references/citations...

Q:

Needing ANSWERS ASAP! Starting at pg 34 - Labeled Graded Project 06155200: Graded Project Instructions & Worksheets 1 Lesson 1: Business, Accounting, and You PROJECT GOAL The goal of this graded...

Q:

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

Q:

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Q:

i need 5 balance sheets for Auto Zone company from the resources "attachments and the link below" for the last 5 years, 2011-2012-2013-2014-2015 with the sixth page including the total income and...

Q:

Unit 2: Designing the Operations Designing the operations of an organization or your department - precedes operational management. For .ll _ . example, suppose a wallet manufacture's mission is to '...

Q:

Calculate Camar's Break-even (B/E) 1 , should it decide to enter the Northeastern U.S.What could you comment about the contribution? (Tip: The info for the B/E, which is Fixed Costs divided by...

Q:

50 + 10 x 0 + 7+2=??

Q:

Identify and discuss the advantages and disadvantages of using quantitative survey research methods to collect primary data in marketing research.

Q:

The optimal portfolio for you will be \ times | AIM 2 5 SPRING FINC 4 0 9 5 9 8 : SURV X g Quest Library Genesis A Anna's ArchiveV Z - Library Fifty KeySaved 1 5 Multiple Choice 8 0 2 - 4 3 : 4 9 the...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...