Project #40687 - Pareto Analysis on Microsoft Excel

Assignment 3

Pareto Analysis

 

For this assignment I want you to answer the following questions using Microsoft Excel. There are five questions that require you to construct a Pareto analysis diagram with the Lorenz cumulative percentage line. Please have the excel files uploaded to Blackboard by 11:55pm, Sunday September 21st. You are to work alone.

 

 

1. A manufacturer of a swing assembly has gathered the following data for the defects that are occurring to their product. Construct a Pareto analysis diagram with Lorenz curve for this data.

 

Defect

Total

Missing nameplate

20

Handling damage

28

Failed test

2

Poor torque

17

Improper assembly

10

Wrong part

4

Missing components

8

 

 

2. A building contractor has determined the frequency of the defects that are found when a brand new home is completed and inspected. Construct a Pareto analysis diagram with Lorenz curve for this data. This is one problem not two.

 

Defect Type

Occurrences

Defect Type

Occurrences

Damaged walls

14

Doors

11

Exterior paint

4

HVAC

9

Plumbing

3

Roof

2

Caulking

25

Masonry

65

Electrical

27

Interior paint

16

Cabinetry

19

Landscaping

7

Woodwork

45

Fixtures

56

 

 

 

 

 

 

 

 

 

 

 

3. Construct a Pareto analysis diagram with Lorenz curve for the analysis of the external failure of a wireless telephone manufacturer using the following data.

Type of Cost

Dollars (in thousands)

Customer complaints

30

Returned goods

40

Retrofit costs

50

Warranty claims

80

Liability costs

25

Penalties

5

Customer goodwill

35

 

 

4. A project team is studying the downtime cost of a soft-drink bottling line. Data analysis in thousands of dollars for a three month period are: back pressure regulator, 40; adjust feed worm, 25; jam copper head, 8; lost cooling, 53; valve replacement, 10; and other, 3. Construct a Pareto analysis diagram with Lorenz curve for this data.

 

 

5. A major record of the month club collected data on the reasons for returned shipments during a quarter. Results are: wrong selection, 60,000; refused, 190,000; wrong address, 70,000; order cancelled, 6,000; and other 12,000. Construct a Pareto analysis diagram with Lorenz curve for this data.

 

Subject Business
Due By (Pacific Time) 09/21/2014 04:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy