Search This Blog

Showing posts with label Pareto Diagram. Show all posts
Showing posts with label Pareto Diagram. Show all posts

Friday, February 4, 2011

SCOM305 Week 4 Homework Problems

Solution is available here for U$25.00

1. Click on the "Problems tab" to review the 5 homework problems.  These are due on Saturday. 
2. Create a new work sheet tab for each problem.
3. Solve your problem on the worksheet.  Some problems have auxiliary questions to be answered.
Highlight your answers in RED. 

4. Post to your Assignments Link. 

1. An analysis of customer complaints at a large mail order house revealed the following data:
Billing Errors
4500
Picking Errors
9800
Long Delays
1353
Unclear Charges
1800
Delivery Errors
900
Shipping Errors
7300
Out of Stock
2700
Construct a Pareto Diagram in Excel to show this data.  What area(s) should the focus be on?