CREATE IN EXCEL The key to completing this assignment is to take a careful look at Fig. 18-4 on page 222. This Pareto chart is basically a bar chart that shows the volume for four Activities. Pareto Charts can also be used to compare the 'before' and 'after' performance of activities. This is what the assignment is asking you to do. The question says to assume that Fig 18-4 represents the 'before' data and that the information on page 501 represents the 'after' performance. So, all you need to do is create a Pareto Chart (or comparative bar chart) that shows both the 'before' and 'after' results. Then, comment on the comparison. Be sure that your comment does not just state the obvious! You must provide insight about the meaning of the data -- In other words, if you were a manager that was presented with this data, what would you do and why?

Assignment Exercise 18-4: Pareto Rule Note that the test Review the chapter text about the Pareto rule and examine Figure 184. says Pareto diagrams are often drawn to reflect before and after results. Assume that Figure 18-4 s the before diagram for the Billing department. Further assume that the after results are as follows Activity Process Denied Bills Review with Supervisor Locate Documentation Copy Documentation Activity Code PDB RWS LD CD Number 12 10 6 Required 1. Redo the Pareto diagram with the after results. (Use Figure 18-4 as a guide.) 2. Comment on the before and after results for the Billing department. Assignment Exercise 18-4: Pareto Rule Note that the test Review the chapter text about the Pareto rule and examine Figure 184. says Pareto diagrams are often drawn to reflect before and after results. Assume that Figure 18-4 s the before diagram for the Billing department. Further assume that the after results are as follows Activity Process Denied Bills Review with Supervisor Locate Documentation Copy Documentation Activity Code PDB RWS LD CD Number 12 10 6 Required 1. Redo the Pareto diagram with the after results. (Use Figure 18-4 as a guide.) 2. Comment on the before and after results for the Billing department