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? | |||