5. The accounts receivable department has documented the following problems over a 30-day period: Frequency 24 18 Category Invoice not on record (not found) No formal invoice issued Check (payment) not received on time Check not signed Invoice number and invoice referenced do not agree Invoice amount does not agree with the check amount 30 8 12 108 Note: Decimals should be rounded to four (4) decimal places; percentages should be rounded to one (1) decimal place. a. Provide the Pareto chart based on relative frequency (or proportion). Create the chart in Excel, copy the chart, and paste into the Final Exam Answer Sheets where indicated. b. What is the most typical defect? c. As a percentage, how typical is this defect? d. Based on your Pareto chart, prioritize the quality improvements in decreasing order of importance. 5. The accounts receivable department has documented the following problems over a 30-day period: Frequency 24 18 Category Invoice not on record (not found) No formal invoice issued Check (payment) not received on time Check not signed Invoice number and invoice referenced do not agree Invoice amount does not agree with the check amount 30 8 12 108 Note: Decimals should be rounded to four (4) decimal places; percentages should be rounded to one (1) decimal place. a. Provide the Pareto chart based on relative frequency (or proportion). Create the chart in Excel, copy the chart, and paste into the Final Exam Answer Sheets where indicated. b. What is the most typical defect? c. As a percentage, how typical is this defect? d. Based on your Pareto chart, prioritize the quality improvements in decreasing order of importance