Question

In: Operations Management

The accounts receivable department has documented the following problems over a 30-day period: Category Frequency Invoice...

The accounts receivable department has documented the following problems over a 30-day period:

Category

Frequency

Invoice not on record (not found)

24

No formal invoice issued

18

Check (payment) not received on time

30

Check not signed

8

Invoice number and invoice referenced do not agree

12

Invoice amount does not agree with the check amount

108

Note: Decimals should be rounded to four (4) decimal places; percentages should be rounded to one (1) decimal place.

  1. Provide the Pareto chart based on relative frequency (or proportion).

Create the chart in Excel,

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.

Solutions

Expert Solution

(a)

Category Frequency Relative fr. Cumulative fr.
Invoice amount does not agree with the check amount 108 0.54 0.54
Check (payment) not received on time 30 0.15 0.69
Invoice not on record (not found) 24 0.12 0.81
No formal invoice issued 18 0.09 0.90
Invoice number and invoice referenced do not agree 12 0.06 0.96
Check not signed 8 0.04 1
Total 200 1

(b)

The most typical defect is "Invoice amount does not agree with the check amount"

(c)

In relative frequency terms, it is 0.54 or 54% in percentage terms.

(d)

The decreasing order of importance:

  1. Invoice amount does not agree with the check amount
  2. Check (payment) not received on time
  3. Invoice not on record (not found)
  4. No formal invoice issued
  5. Invoice number and invoice referenced do not agree
  6. Check not signed

Related Solutions

Ferry's Furniture Outlet has an accounts receivable period of 51.06 days and an accounts payable period...
Ferry's Furniture Outlet has an accounts receivable period of 51.06 days and an accounts payable period of 43.07 days. The company turns over its inventory 5.69 times per year. What is the length of the company's operating cycle? Assume 365 days per year. 94.13 days 72.14 days 21.08 days 115.21 days 107.22 days
Accounts Receivable The following table indicates the historical breakout of accounts receivable Days Current 30 to...
Accounts Receivable The following table indicates the historical breakout of accounts receivable Days Current 30 to 60 60 to 90 Over 90 Percent of Balance 50% 30% 15% 5% Percent Collectible 95% 90% 80% 60% The company uses the gross method of recording all sales on accounts. Marketable Securities The interest rate earned on marketable securities is 6.0%. Inventory In 20x2, the company had used the gross method to record inventory purchases on account. As of January 1, 20x3, the...
Bayview Manufacturing Company has an accounts receivable department that performs three activities within the department: invoicing...
Bayview Manufacturing Company has an accounts receivable department that performs three activities within the department: invoicing customers, processing customer credit applications, and performing collection activities. During interviews, the employee survey reports that they spend 15 percent of their time invoicing customers, 55 percent of their time processing credit applications, and 30 percent of their time on collection activities. The accounts receivable department employs 10 associates for a total monthly cost of $50,000. Assume each associate works 8 hours per day,...
Accounts receivable at the beginning of the year are 300. The company has a 30-days collection...
Accounts receivable at the beginning of the year are 300. The company has a 30-days collection period. Calculate cash collections in each of the four quarters by completing the following. Q1 Q2 Q30 Q4 beginning receivables 300 208 Sales 540 570 630 780 Cash collections 662 560 610 731 Ending receivables 208
A company has increasing accounts receivable, increasing inventory and decreasing accounts payables year over year on...
A company has increasing accounts receivable, increasing inventory and decreasing accounts payables year over year on the balance sheet.  Which of the following is correct about the impact operating cash flow? a. None of these b. Increase in inventory is a source of cash c. Increase in accounts receivable is a source of cash d. Decreasing accounts payable is a source of cash
Drumpf suppy has the following accounts receivable aging schedule as at december 31,2015. Accounts receivable Age...
Drumpf suppy has the following accounts receivable aging schedule as at december 31,2015. Accounts receivable Age Amount proportion expected to dedaulf allowance required current $150,000 0.5% 1-30 days past due $65,000 1.0% 31-45 days past due $16,500 13.0% 46-90 days past due $4,500 20.0% 91-135 days past due $3,000 25.0% over 135 days past due $1,500 60.0% The balance in drumpf's allowance for doubtful accounts at the beginning of the year is $6,000(credit). During the year, accounts in the total...
B-Good, Inc. has accounts receivable at September 30 of $1,000,000. At September 30, Allowance for Doubtful...
B-Good, Inc. has accounts receivable at September 30 of $1,000,000. At September 30, Allowance for Doubtful Accounts has a credit balance (prior to adjustment) of $               2,250 The Company uses the percentage of receivables basis for estimating uncollectible accounts. An analysis of the accounts and the percentage of estimated bad debts are as follows: Month of Age of 9/30 Estimated % Sale: Accounts Balance Uncollectible September 1 - 30 days $650,000 2.5% August 31 - 60 days 150,000 6.0% July...
Say Zuzu Company currently has $10,000,000 in accounts receivable. It has day sales outstanding (DSO) of...
Say Zuzu Company currently has $10,000,000 in accounts receivable. It has day sales outstanding (DSO) of 60 days. Assume a 360-day year. The company wants to reduce its DSO to the industry average of 30 days by pressuring more of its customers to pay their bills on time. The company's CFO estimates that if this policy is adopted the company's average sales will fall by 20 percent. Assuming that the company adopts this change, succeeds in reducing its DSO to...
ABC Ltd has accounts receivable of $70 600 at 30 April, 2019. An analysis of the...
ABC Ltd has accounts receivable of $70 600 at 30 April, 2019. An analysis of the accounts shows these amounts as follows: Month of sale Balance of Accounts Receivable April, 2019 $40 000 March, 2019 23 000 February, 2019 3 200 January, 2019 4 100 December and November, 2018 300 70 600 Credit terms are 2/7, n/30. At 30 April, 2019, there is a $2000 credit balance in Allowance for Doubtful Debts before adjustment. The entity uses the ageing of...
ABC Ltd has accounts receivable of $99 600 at 30 April,2019. An analysis of the...
ABC Ltd has accounts receivable of $99 600 at 30 April, 2019. An analysis of the accounts shows these amounts as follows:Month of saleBalance of Accounts ReceivableApril, 2019$50 000March, 201943 000February, 20191 200January, 20195 100December and November, 201830099 600Credit terms are 2/7, n/30. At 30 April, 2019, there is a $2000 credit balance in Allowance for Doubtful Debts before adjustment. The entity uses the ageing of accounts receivable basis for estimating uncollectable accounts. Estimates of bad debts are as follows:Age...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT