Question
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.
Solution Preview
These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.
By purchasing this solution you'll be able to access the following files:
Solution.xlsx.