Question

Franks Sporting Goods projects sales for the second quarter of 2015 to be as follows: April $100,000 May $120,000 June $110,

0 0
Add a comment Improve this question Transcribed image text
Answer #1

A)

April May June
Feb sales collection in April $12,000 - -
Mar sales collection in April $56,000 - -
Mar sales collection in May - $16,000 -
April cash sales $10,000 - -
April sales collection in May - $70,000 -
April sales collection in June - - $20,000
May cash sales - $12,000 -
May sales collection in June - - $84,000
June cash sales - - $11,000
Total Cash collection $78,000 $98,000 $115,000

B) Accounts receivable balance in June = 90% of June sales + 20% of May sales

= $110,000 X 90% + $120,000 X 20%

= $123,000

Add a comment
Know the answer?
Add Answer to:
Frank's Sporting Goods projects sales for the second quarter of 2015 to be as follows: April...
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
  • the company's sales budget for the second quarter given below: Budgeted sales (all on account) April...

    the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $360,000 May $560,000 June $220,000 Total $1,140,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $290,000, and March sales totaled...

  • Really 25 Points Ellis Sport Shop projects the following sales: April May June...

    Really 25 Points Ellis Sport Shop projects the following sales: April May June $                65,000 $        71,000 $        89,000 66 percent of Ellis' sales are on credit with 77 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale. February sales were $45,000 and March sales were $56,000. In the past Ellis' bad debt percentage has been 0 and is expected to continue. Prepare a monthly schedule...

  • the company’s sales budget for the second quarter given below: April May June Total Budgeted sales...

    the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $320,000 $520,000 $180,000 $1,020,000 From past experience, the company has learned that 30% of a month’s sales are collected in the month of sale, another 65% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $250,000, and March sales totaled...

  • x-Tel budgets sales of $55,000 for April, $110,000 for May, and $60,000 for June. 5 In addition, sales are 50 % cas...

    x-Tel budgets sales of $55,000 for April, $110,000 for May, and $60,000 for June. 5 In addition, sales are 50 % cash and 50 % on credit. All credit sales are collected in the month following the sale. The April 1 balance in accounts receivable is $19,000. Prepare a schedule of budgeted cash receipts for April, May, and June. 05 X-TEL points Cash Recelpts Budget For April, May, and June April May June eBook Print References Cash receipts from Total...

  • Exercise 10.33 Novak Inc. has budgeted sales for the second quarter of $300,000 for April; $500,000...

    Exercise 10.33 Novak Inc. has budgeted sales for the second quarter of $300,000 for April; $500,000 for May; and $600,000 for June. Normally, 20 % are cash sales and 80% of sales are on account. As well, 30% of the sales on account are normally collected during the month of sale, 50% in the following month, and 20 % in the second month following sale. The accounts receivable balance as of April 1 is $250,000. Prepare the schedule of cash...

  • Clippers Corp. has the following sales budget for the second quarter of 2017: Sales Budget April...

    Clippers Corp. has the following sales budget for the second quarter of 2017: Sales Budget April May June Quarter Cash Sales $ 110,000 $ 175,000 $ 130,000 $ 415,000 Credit Sales $ 275,000 $ 450.000 $ 350,000 $ 1,075,000 $ 385,000 $ 625,000 $ 480,000 $ 1,490,000 Additional information: 1. Credit sales are collected as follows: 15% in the month of sale, 55% in the following month, and 28% in the second following month. 2. Approximately 2% of credit sales...

  • X-Tel budgets sales of $80,000 for April, $88,000 for May, and $40,000 for June In addition,...

    X-Tel budgets sales of $80,000 for April, $88,000 for May, and $40,000 for June In addition, sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. The April 1 balance in accounts receivable is $11,000. Prepare a schedule of budgeted cash receipts for April, May, and June. X-TEL Cash Receipts Budget For April, May, and June April May June Cash receipts from: Total cash receipts

  • Casa Development, Inc. has budgeted sales revenues as follows: January February March April May June Budgeted...

    Casa Development, Inc. has budgeted sales revenues as follows: January February March April May June Budgeted Sales Revenues $55,000 75,000 90,000 80,000 60,000 35,000 Past experience has indicated that 80% of sales each month are on credit and that collection of credit sales occurs as follows: 60% in the month of sale, 30% in the month following the sale, and 5% in the second month following the sale. The other 5% is uncollectible. Prepare a schedule which shows expected cash...

  • Clay Corporation has projected sales and production in units for the second quarter of the coming...

    Clay Corporation has projected sales and production in units for the second quarter of the coming year as follows: Sales Production April 54,000 62.000 May 44,000 52.000 June 64.000 52.000 Required: a. Cash-related production costs are budgeted at $5.4 per unit produced. Of these production costs, 35% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $140,000 per month. The accounts payable balance on March...

  • 1. Carter Company has projected sales and production in units for the second quarter of next...

    1. Carter Company has projected sales and production in units for the second quarter of next year as follows: Sales. Production April May June 60,000 40.000 50.000 50.000 50.000 60.000 | Required: (15%) a. Cash production costs are budgeted at $6 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses (all of which are paid in cash) amount to $120,000...

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
ADVERTISEMENT