Reference no: EM132984022

Barrett's Boots Ltd has traditionally made sales for cash and on credit only. Management has resisted accepting credit cards on the basis that the business would lose on average a credit card fee of 4% of the sale value, adversely affecting already low profit margins.

Management has become concerned at negative customer reaction to the policy of not accepting credit cards and, indeed, suspects that sales are being lost because of this policy.

Management has asked you to provide a table showing credit and collection costs in dollars and as a percentage of net sales associated with credit sales and maintaining accounts receivable.

The following data have been provided for the two most recent years which are expected to be representative of future operations.

                                                                                        2019                      2020

Net credit sales                                               $ 720 000              $ 600 000

Part-time salary - accounts receivable clerk             4 350                        4 350

Collection agency fees for slow payers                      3 250                        3 200

Other collection and credit expenses expressed as percentages of net sales are as follows.

Bad debts 1.5%

Invoicing and mailing costs 0.6%

Credit evaluation of new customers 0.14%

It is also estimated that the average accounts receivable balance during the year is approximately 6% of net credit sales, and that surplus cash can be invested at 14% p.a. It is also known that credit card companies pay on average 96% of the sale within 4 business days of the date of sale.

Required

Problem (a) Prepare a table setting out for each year all of the credit and collection expenses both in dollars and as a percentage of net sales