Pareto Rule
Review the charts below, this is the before diagram for the Billing department. Pareto diagrams are often drawn to reflect before and after results.
BEFORE (Was in table format)
Activity, Activity Code, Number
Process Denied Bills, PDB, 22
Review with Supervisor, RWS, 10
Locate Documentation, LD, 6
Copy Documentation, CD, 5
Total: 43
Further assume that the AFTER results are as follows:
Activity Activity Code Number
Process Denied Bills PDB 12
Review with Supervisor RWS 10
Locate Documentation LD 6
Copy Documentation CD 5
Total: 33
Create a Pareto diagram with the after results. Comment on the before and after results of the Billing Department. Create the table in Microsoft Excel and provide comments.
Question
Solution Preview
This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.
By purchasing this solution you'll be able to access the following files:
Solution.xlsx.
Return to homework library