Question

Required information

[The following information applies to the questions displayed below.]

On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances:

Accounts	Debit				Credit
Cash	$	23,900
Accounts Receivable		13,600
Allowance for Uncollectible Accounts					$	1,400
Supplies		2,500
Notes Receivable (6%, due in 2 years)		20,000
Land		77,000
Accounts Payable						7,200
Common Stock						96,000
Retained Earnings						32,400
Totals	$	137,000			$	137,000

During January 2021, the following transactions occur:

January		2		Provide services to customers for cash, $35,100.
January		6		Provide services to customers on account, $72,400.
January		15		Write off accounts receivable as uncollectible, $1,000.
January		20		Pay cash for salaries, $31,400.
January		22		Receive cash on accounts receivable, $70,000.
January		25		Pay cash on accounts payable, $5,500.
January		30		Pay cash for utilities during January, $13,700.

7. Analyze how well 3D Family Fireworks manages its receivables:

a-1. Calculate the receivables turnover ratio for the month of January (Hint: For the numerator, use total services provided to customers on account). (Round your final answer to 1 decimal place.)

a-2. If the industry average of the receivables turnover ratios for the month of January is 4.2 times, is the company collecting cash from customers more or less efficiently than other companies in the same industry?

• More

• Less

b-1. Calculate the ratio of Allowance for Uncollectible Accounts to Accounts Receivable at the end of January.

b-2. Based on a comparison of this ratio to the same ratio at the beginning of January, does the company expect an improvement or worsening in cash collections from customers on credit sales?

• Improvement

• Worsening

Answer 1

Answer -

As per given information,

Total services provided to customers on account = $72400 (net credit sales)

Accounts receivable (on 1st January) = $13900

Accounts receivable (During January) = $70000

Allowance for uncollectible accounts (on 1st January) = $1400

Allowance for uncollectible accounts (During January) = $1000

So,

Average accounts receivable = [Accounts receivable (on 1st January) + Accounts receivable (During January)] / 2

Average accounts receivable = [13900 + 70000] / 2

Average accounts receivable = $41950

a-1. Answer -

Receivables turnover ratio for the month of January :

Receivables turnover = Net credit sales / Average accounts receivable

Receivables turnover = 72400 / 41950

Receivables turnover = 1.7 times

a-2. Answer -

If the industry average of the receivables turnover ratios for the month of January is 4.2 times. This means that collects receivables about once every 87 days (365 days / 4.2)

Here, company receivables turnover is 1.7 times. This means that collects receivables about once every 215 days (365 days / 1.7)

Then,

Company collecting cash from customers less efficiently than other companies in the same industry

b-1. Answer -

Ratio of Allowance for uncollectible accounts to accounts receivable at the end of January. :

Allowance for uncollectible accounts to accounts receivable = (Allowance for uncollectible accounts / Accounts receivable) * 100

Allowance for uncollectible accounts to accounts receivable = (1000 / 70000) * 100

Allowance for uncollectible accounts to accounts receivable = 1.42%

b-2. Answer -

Ratio of Allowance for uncollectible accounts to accounts receivable at the beginning of January,

Allowance for uncollectible accounts to accounts receivable = (Allowance for uncollectible accounts / Accounts receivable) * 100

Allowance for uncollectible accounts to accounts receivable = (1400 / 13600) * 100

Allowance for uncollectible accounts to accounts receivable = 10.29%

And here,

Allowance for uncollectible accounts to accounts receivable is 1.42% for the of Jaunary.

Based on a comparison of this ratios company shows improvement in cash collections from customers on credit sales.