To calculate the estimated total cash collections by Cloudy Company during November from the collection of accounts receivable, we need to apply the historical collection pattern to the credit sales for the preceding months.

QUESTION

Cloudy Company had the following historical collection pattern for its credit sales:

70% collected in the month of sale
15% collected in the first month after month of sale
9% collected in the second month after month of sale
5% collected in the third month after month of sale
1% uncollectible

The sales on open account (credit sales) have been budgeted for the last six months of the year as shown below:

 

July $ 80,000
August $ 92,000
September $ 104,000
October $ 116,000
November $ 128,000
December $ 110,000

 

The estimated total cash collections by Cloudy Company during November from collection of accounts receivable is:

 

Multiple Choice

  • $120,960.
  • $109,080.
  • $156,400.
  • $132,400.
  • $111,840.

ANSWER

To calculate the estimated total cash collections by Cloudy Company during November from the collection of accounts receivable, we need to apply the historical collection pattern to the credit sales for the preceding months.

First, let’s calculate the collections for each month:

July Sales:

70% collected in the month of sale: 70% of $80,000 = $56,000

August Sales:

15% collected in the first month after the month of sale: 15% of $92,000 = $13,800

70% collected in the month of sale: 70% of $92,000 = $64,400 Total collections for August = $13,800 + $64,400 = $78,200

September Sales:

9% collected in the second month after the month of sale: 9% of $104,000 = $9,360

15% collected in the first month after the month of sale: 15% of $104,000 = $15,600

70% collected in the month of sale: 70% of $104,000 = $72,800 Total collections for September = $9,360 + $15,600 + $72,800 = $97,760

Now, we have calculated the collections for July, August, and September. To estimate the total cash collections in November, we need to consider the collections from October’s and November’s sales:

October Sales:

5% collected in the third month after the month of sale: 5% of $116,000 = $5,800

9% collected in the second month after the month of sale: 9% of $116,000 = $10,440

15% collected in the first month after the month of sale: 15% of $116,000 = $17,400 Total collections for October = $5,800 + $10,440 + $17,400 = $33,640

November Sales:

1% uncollectible: 1% of $128,000 = $1,280

5% collected in the third month after the month of sale: 5% of $128,000 = $6,400

9% collected in the second month after the month of sale: 9% of $128,000 = $11,520

15% collected in the first month after the month of sale: 15% of $128,000 = $19,200 Total collections for November = $6,400 + $11,520 + $19,200 = $37,120

Now, let’s calculate the estimated total cash collections by adding up the collections from November’s sales and the collections carried over from previous months:

Total Collections in November = Collections from November Sales + Collections from October Sales Total Collections in November = $37,120 + $33,640 = $70,760

So, the estimated total cash collections by Cloudy Company during November from the collection of accounts receivable is $70,760.

Unfortunately, none of the multiple-choice options provided match this calculated amount, so you may need to double-check your calculations or consider any additional information provided in the question to arrive at the correct answer.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 Customer support
On-demand options
  • Tutor’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Attractive discounts
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Unique Features

As a renowned provider of the best writing services, we have selected unique features which we offer to our customers as their guarantees that will make your user experience stress-free.

Money-Back Guarantee

Unlike other companies, our money-back guarantee ensures the safety of our customers' money. For whatever reason, the customer may request a refund; our support team assesses the ground on which the refund is requested and processes it instantly. However, our customers are lucky as they have the least chances to experience this as we are always prepared to serve you with the best.

Zero-Plagiarism Guarantee

Plagiarism is the worst academic offense that is highly punishable by all educational institutions. It's for this reason that Peachy Tutors does not condone any plagiarism. We use advanced plagiarism detection software that ensures there are no chances of similarity on your papers.

Free-Revision Policy

Sometimes your professor may be a little bit stubborn and needs some changes made on your paper, or you might need some customization done. All at your service, we will work on your revision till you are satisfied with the quality of work. All for Free!

Privacy And Confidentiality

We take our client's confidentiality as our highest priority; thus, we never share our client's information with third parties. Our company uses the standard encryption technology to store data and only uses trusted payment gateways.

High Quality Papers

Anytime you order your paper with us, be assured of the paper quality. Our tutors are highly skilled in researching and writing quality content that is relevant to the paper instructions and presented professionally. This makes us the best in the industry as our tutors can handle any type of paper despite its complexity.