Question

ABC Company has the following historical collection pattern for its credit sales: 70% collected in month...

ABC Company has the following historical collection pattern for its credit sales: 70% collected in month of sale 15% collected in the first month after sale 10% collected in the second month after sale 4% collected in the third month after sale 1% uncollectible Credit sales are for the last 6 months are as follows: July $60,000 August $70,000 September $80,000 October $90,000 November $100,000 December $85,000 the estimated total cash collections during october from accounts receivable would be

Homework Answers

Answer #1
Ans. Schedule of Cash Receipt in October
Particulars Amuont
From July sales $2,400
From August sales $7,000
From September sales $12,000
From October sales $63,000
Total cash collection in October $84,400
Calculation of Cash collections:
October
From July sales $60,000 * 4%
From August sales $70,000 * 10%
From September sales $80,000 * 15%
From October sales $90,000 * 70%
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Moore Inc. had the following historical pattern for its credit sales: 70% collected in the month...
Moore Inc. had the following historical pattern for its credit sales: 70% collected in the month of sale 20% collected in the firs month after sale 8% collected in the second month after sale 2% uncollectible The sales on open account (credit sales) have been budgeted for the last four months of the year as shown below: September $12,000 October $13,000 November $10,000 December $12,000 Required: a. The estimated total cash collections by the company during December from accounts receivable...
Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit...
Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit sales. 80 percent collected in the month of sale. 10 percent collected in the first month after sale. 5 percent collected in the second month after sale. 4 percent collected in the third month after sale. 1 percent uncollectible. The sales on account have been budgeted for the last seven months as follows: June $ 126,000 July 153,500 August 178,500 September 207,000 October 232,000...
Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit...
Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit sales. 60 percent collected in the month of sale. 20 percent collected in the first month after sale. 15 percent collected in the second month after sale. 4 percent collected in the third month after sale. 1 percent uncollectible. The sales on account have been budgeted for the last seven months as follows: June $131,000 July 158,500 August 183,500 September 217,000 October 242,000 November...
Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit...
Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit sales. 60 percent collected in the month of sale. 20 percent collected in the first month after sale. 15 percent collected in the second month after sale. 4 percent collected in the third month after sale. 1 percent uncollectible. The sales on account have been budgeted for the last seven months as follows: June $ 127,000 July 154,500 August 179,500 September 209,000 October 234,000...
The LaPann Company has obtained the following sales forecast data: July August September October Cash Sales...
The LaPann Company has obtained the following sales forecast data: July August September October Cash Sales $80,000 $70,000 $50,000 $60,000 Credit Sales $240,000 $220,000 $180,000 $200,000 The regular pattern of collection of credit sales is 30% in the month of sale and 70% in the month following the month of sale.  There are no bad debts. The budgeted accounts receivable balance on September 30th is: $126,000 $154,000 $161,000 $186,000
Exercise 9-24 Cash Collections (LO 9-3, 9-5) Coyote Loco, Inc., a distributor of salsa, has the...
Exercise 9-24 Cash Collections (LO 9-3, 9-5) Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit sales. 75 percent collected in the month of sale. 15 percent collected in the first month after sale. 5 percent collected in the second month after sale. 4 percent collected in the third month after sale. 1 percent uncollectible. The sales on account have been budgeted for the last seven months as follows: June $ 127,500 July...
ABC Company was organized on August 1 of the current year. Projected sales for the next...
ABC Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August   $250,000 September     200,000 October     275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on account, 30% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections for August, September, and October. ABC Company Schedule of Collections from Sales...
2. The treasurer of Yoda Inc. needs to estimate cash collections from accounts receivable for September,...
2. The treasurer of Yoda Inc. needs to estimate cash collections from accounts receivable for September, October, and November 2017. Forty percent of the company’s customer’s pay in cash the rest are credit customers. The collection pattern for the credit customers is 20% in the month of the sale and 80% in the following month. They have zero uncollectible accounts. Estimated total sales are as follows: August $78000 September 80,000 October. 95,000 November 91,000 Q: What is Yoda’s cash collections...
Freemore Company has the following sales budget for the last six months of 2018:         July                    &
Freemore Company has the following sales budget for the last six months of 2018:         July                       $206,000                                October                       $181,000         August                  168,000                                November                    203,000         September           209,000                                December                     185,000 Sales are immediately due, however the cash collection of sales, historically, has been as follows:         55% of sales collected in the month of sale,         35% of sales collected in the month following the sale,         7% of sales collected in the second month following the sale, and         3% of sales are uncollectible. Cash collections for September are ________.       A. $173,750 B. $188,170...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit Price Budgeted sales June 20,000 $10 $200,000 July 40,000 $10 $400,000 August 50,000 $10 $500,000 September 30,000 $10 $300,000 October 60,000 $10 $600,000 From past experience, the company has learned that 40% of a month’s sale are collected in the month of sale, another 60% are collected in the month following the sale. Prepare a schedule of expected cash collections from sales for the...