Question

Wells Company reports the following sales forecast: September, $46,000; October, $64,000; and November, $73,000. All sales...

Wells Company reports the following sales forecast: September, $46,000; October, $64,000; and November, $73,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November.

Homework Answers

Answer #1
Schedule of expected cash collections
November
Collections from accounts receivables:
September ($46000 X 10%) $             4,600
October ($64000 X 60%) $           38,400
November ($73000 X 25%) $           18,250
Total cash receipts $           61,250
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
Wells Company reports the following sales forecast: September, $46,000; October, $67,000; and November, $78,000. All sales...
Wells Company reports the following sales forecast: September, $46,000; October, $67,000; and November, $78,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November. WELLS COMPANY Budgeted Cash Receipts For Month Ended November 30 Cash receipts from November...
Graham Potato Company has projected sales of $9,600 in September, $13,000 in October, $19,600 in November,...
Graham Potato Company has projected sales of $9,600 in September, $13,000 in October, $19,600 in November, and $15,600 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December.    Also assume Graham’s cash payments for November and December...
Bluebear Corporation budgeted sales for the last four months of 2018: Month Sales September $360,000 October...
Bluebear Corporation budgeted sales for the last four months of 2018: Month Sales September $360,000 October 400,000 November 350,000 December 410,000 Historically, the cash collection of sales have been as follows: 65 percent in month of sale 25 percent in month following sale 8 percent in second month following sale 2 percent uncollectible The company allows a 2 percent cash discount for payments made by customers during the month of the sale. July and August sales were $405,000 and $275,000,...
Graham Potato Company has projected sales of $9,600 in September, $13,000 in October, $19,600 in November,...
Graham Potato Company has projected sales of $9,600 in September, $13,000 in October, $19,600 in November, and $15,600 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December.    Also assume Graham’s cash payments for November and December...
Budgeted sales at Ikkeep Corporation over the next four months are given below: September $150,000 October...
Budgeted sales at Ikkeep Corporation over the next four months are given below: September $150,000 October $160,000 November $180,000 December $140,000 The company estimates that 25% of the sales are for cash, and 75% on credit. Collections for sales on account follow a stable pattern as follows: 50% will be collected in the month of the sale, 30% in the month following the sale, 15% in the second month following the sale, and the rest uncollectible. What would be the...
Ruiz Co.’s budget includes the following credit sales for the current year: September, $152,000; October, $143,000;...
Ruiz Co.’s budget includes the following credit sales for the current year: September, $152,000; October, $143,000; November, $127,000; December, $164,000. Credit sales are collected as follows: 10% in the month of sale, 60% in the first month after sale, and 30% in the second month after sale. How much cash can the company expect to collect in December as a result of current and past credit sales?
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
It is November 1 of Year 1. Sales for Kadan Company for November and December of...
It is November 1 of Year 1. Sales for Kadan Company for November and December of Year 1 and January of Year 2 are forecasted to be as follows: November, 400,000; December 600,000; January, 200,000 100% of sales are credit sales. Of these credit sales, 5% are collected during the month of sale, 25% in the following month, and 65% in the second following month; 5% are never collected. Total sales for September and October of Year 1 were 100,000...
It is November 1 of Year 1. Sales for Jude Company for November and December of...
It is November 1 of Year 1. Sales for Jude Company for November and December of Year 1 and January (of Year 2) are forecasted to be as follows: November, 300,000; December 700,000; January, 200,000 100% of sales are credit sales. Of these credit sales, 15% are collected during the month of sale, 25% in the following month, 50% in the second following month, and 10% are never collected. Total sales for September and October of Year 1 were 100,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
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT