Question

Shown below are the budgeted sales for ABC Company for the next six months: Sales for...

Shown below are the budgeted sales for ABC Company for the next
six months:

                   Sales for Cash     Sales on Account
January               $27,000             $175,000 
February              $22,000             $162,000 
March                 $33,000             $214,000 
April                 $19,000             $148,000 
May                   $38,000             $222,000 
June                  $24,000             $171,000

On average, 11% of the sales on account are collected in the month
of sale, 42% are collected in the month following sale, 39% are
collected in the second month following sale, and the remaining
8% is collected three months after the month of sale.

Calculate the expected cash collections for April.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Cash collections for April

= 19000+(148000*11%)+(214000*42%)+(162000*39%)+(175000*8%)

=$202340

Add a comment
Know the answer?
Add Answer to:
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
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
  • Shown below are the budgeted sales for ABC Company for the next six months:                    Sales...

    Shown below are the budgeted sales for ABC Company for the next six months:                    Sales for Cash     Sales on Account January               $15,000             $ 70,000 February       $18,000             $ 80,000 March                 $14,000             $160,000 April                 $26,000             $120,000 May                   $18,000             $170,000 June                  $24,000             $105,000 On average, 35% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 10% are collected in the second month following sale, and the remaining 15% is...

  • Shown below are the expected sales for ABC Company: January February March April Sales for Cash...

    Shown below are the expected sales for ABC Company: January February March April Sales for Cash $22,000 $19,000 $26,000 $21,000 Sales on Account $118,000 $146,000 $133,000 $127,000 On average, 65% of the sales on account are collected in the month of sale, 27% are collected in the month following sale, and the remaining 8% are collected two months after the month of sale. Calculate ABC Company's budgeted accounts receivable at April 30.

  • Shown below are the expected sales for ABC Company: Sales on Account $118,000 $146,000 Sales for...

    Shown below are the expected sales for ABC Company: Sales on Account $118,000 $146,000 Sales for Cash $22,000 $19,000 January February $133,000 $127,000 $26,000 March $21,000 April On average, 65% of the sales on account are collected in the month of sale, 27% are collected in the month following sale, and the remain ing 8 % are collected two months after the month of sale. Calculate the expected cash collections for March. Shown below are the expected sales for ABC...

  • Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...

    Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $269,000 September $52,000 $251,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 8% are collected in the third month following sale, and the remaining...

  • Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...

    Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $251,000 September $52,000 $269,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 9% are collected in the third month following sale, and the remaining...

  • Ed’s Waterbeds has made the following sales projections for the next six months. All sales are...

    Ed’s Waterbeds has made the following sales projections for the next six months. All sales are credit sales.   March $ 32,000   June $ 36,000   April 38,000 July 44,000   May 27,000 August 46,000 Sales in January and February were $35,000 and $34,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a....

  • ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales...

    ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July 7,700 units August 8,300 units September 5,400 units October 10,200 units November ?????? units December 11,700 units The selling price is $18 per unit. 30% of the company's sales are cash sales and 70% of the company's sales are made on account. The sales on account are collected in the pattern 15% in the month of sale, 20% in the month...

  • Laura's Decor Stores made the following sales projection for the next six months. All sales are...

    Laura's Decor Stores made the following sales projection for the next six months. All sales are credit sales. march 38,000 April 44,000 may 33,000 june 42,000 july 50,000 august 52,000 sales in january and february were $41,000 and $40,000 respectively experience has shown that total sales, 10% are uncollectible, 35% are collected in the month of sale, 45 percent are collected in the following month and 10 percent are collected two months after sale. a) prepare a monthly cash receipts...

  • Budgeted sales in Washburn Company over the next four months are given below: September October November...

    Budgeted sales in Washburn Company over the next four months are given below: September October November December Budgeted sales $100,000 $160,000 $180,000 $120,000 Twenty-five percent of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The...

  • Zinger Corporation has budgeted sales over the next four months below: September October November December Budgeted...

    Zinger Corporation has budgeted sales over the next four months below: September October November December Budgeted Sales... $140,000 $150,000 $170,000 $130,000 Twenty five percent of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 41% of a month's credit sales are collected in the month of sale, 32% are collected in the month following sale, and 7% are collected in the second month following sale. The remainder...

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