Question

The Handel Company has obtained the following sales forecast data: July August September October Cash sales...

The Handel Company has obtained the following sales forecast data:

July August September October

Cash sales ..... $ 80,000 $ 70,000 $ 50,000 $ 60,000

Credit sales ... $260,000 $220,000 $200,000 $220,000


The regular pattern of collection of credit sales is 20% in the month of sale, 70% in the month following the month of sale, and the remainder (10%) in the second month following the month of sale. There are no bad debts.

The budgeted accounts receivable balance on September 30 is:

a.

$196,000

b.

$182,000

c.

$148,000

d.

$126,000

The budgeted cash receipts for October are:

a.

$206,000

b.

$220,000

c.

$266,000

d.

$280,000

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
The Handel Company has obtained the following sales forecast data: July August September October Cash sales...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Scottsdale Co. has actual sales for July and August and forecast sales for September October, November,...

    Scottsdale Co. has actual sales for July and August and forecast sales for September October, November, and December as follows: $ 98,900 105,200 Actual: July August Forecast September October November December 114,200 94,300 121, 3ee 107,400 Based on past experience, it is estimated that 28% of a month's sales are collected in the month of sale, 49% are collected in the month following the sale, and 6% are collected in the second month following the sale. Required: Calculate the estimated...

  • Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November,...

    Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,300 August 105,300 Forecast: September 114,800 October 94,300 November 122,900 December 106,300 Based on past experience, it is estimated that 29% of a month’s sales are collected in the month of sale, 48% are collected in the month following the sale, and 9% are collected in the second month following the sale. Required: Calculate the estimated cash...

  • Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November,...

    Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,100 August 105,100 Forecast: September 114,200 October 94,500 November 121,900 December 107,000 Based on past experience, it is estimated that 24% of a month’s sales are collected in the month of sale, 46% are collected in the month following the sale, and 5% are collected in the second month following the sale. Required: Calculate the estimated cash...

  • Wells Company reports the following sales forecast: September, $60,000; October, $75,000; and November, $90,000. All sales...

    Wells Company reports the following sales forecast: September, $60,000; October, $75,000; and November, $90,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...

  • Wells Company reports the following sales forecast: September $60.000; October $71000; and November, 57 . A...

    Wells Company reports the following sales forecast: September $60.000; October $71000; and November, 57 . A Sores are 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 11111 00 WELLS COMPANY Budgeted Cash Receipts For Month Ended November 30 Cash recepts...

  • Question 1 2 pts Crane Company has the following sales data: August September October November December...

    Question 1 2 pts Crane Company has the following sales data: August September October November December Cash Sales $4000 $5000 $6000 $7000 $16000 Sales on Account $50000 $57,755 $65000 $71,288 $100000 Crane Company's credit customers have the following payment history: 38% in month of sale 59% in month following sale the rest are never collected What are budgeted cash receipts for September?

  • Meredith Company has budgeted sales for the upcoming months as follows: April May June July August September $451,...

    Meredith Company has budgeted sales for the upcoming months as follows: April May June July August September $451,000 $ 468,000 $ 496,000 $518, 000 $504,000 $481,000 30% of the sales are credit sales, the remainder are made in cash. Credit sales are collected 50% in the month of sale, 35% in the month following the sale, and 6% in the second month following the sale. a. Compute Meredith Company's cash receipts for June. (Do not round Intermediate calculations.) Cash Receipts...

  • A company has the following budgeted sales: July $200,000 August $300,000 September $250,000 20% of the...

    A company has the following budgeted sales: July $200,000 August $300,000 September $250,000 20% of the sales are for cash, and 80% are on credit. 25% of the credit sales are collected in the month of sale, and 75% are collected the next month. What are the total expected cash receipts during September?

  • A company has the following budgeted sales: July $200,000 August $300,000 September $250,000 20% of the...

    A company has the following budgeted sales: July $200,000 August $300,000 September $250,000 20% of the sales are for cash, and 80% are on credit. 25% of the credit sales are collected in the month of sale, and 75% are collected the next month. What are the total expected cash receipts during September?

  • QS 20-19 Cash receipts LO P2 Music World reports the following sales forecast: August, $130,000; and...

    QS 20-19 Cash receipts LO P2 Music World reports the following sales forecast: August, $130,000; and September, $200,000. Cash sales are normally 50% of total sales and all credit sales are expected to be collected in the month following the date of sale. Prepare a schedule of cash receipts for September MUSIC WORLD Cash Receipts Budget For Month Ended September 30 September cash sales Collection of accounts receivable Total budgeted cash receipts

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT