Question

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 November 257,000 December 219,500 Required: 1. Compute the estimated total cash collections during October from credit sales. 2. Compute the estimated total cash collections during the fourth quarter from sales made on account during the fourth quarter

Homework Answers

Answer #1

i hope you will rate my ans positively

Cash collections from sales on account OCTOBER NOVEMBER DECEMBER
80% of the current month sales

[ 80%*232000]

=185600

[ 80%*257000 ]

=205600

[ 80%*219500 ]

=175600

10% of previous month sales

10%*207000

=20700

10%*232000

=23200

10%*257000

=25700

5% of sales made 2 month earlier

5%*178500

=8925

5%*207000

=10350

5%*232000

=11600

4% of sales made 3 months earlier

4%*153500

=6140

4%*178500

=7140

4%*207000

=8280

TOTAL CASH COLLECTION FROM CREDIT SALES 221365 246290 221180

ESTIMATED CASH COLLECTION DURING OCTOBER=221365

Total cash collections during the fourth quarter = 221365 + 246290 + 221180 = 688835

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
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...
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...
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...
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
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $123,000 November 154,000 December 225,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $107,000 November 134,000 December 196,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 20% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $107,000 November 134,000 December 196,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $117,000 November 146,000 December 214,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $129,000 November 161,000 December 236,000...