Question

Monroe Group is preparing its cash collections budget. Budgeted sales are $150,000 in July, $175,000 in...

Monroe Group is preparing its cash collections budget. Budgeted sales are $150,000 in July, $175,000 in August, and $200,000 in September. Fifty percent of sales are cash sales; the remainder is on account. Sales on account are expected to be collected 30% in the month of sale, 60% in the month following the month of sale, and 10% in the second month following the month of sale. How much are anticipated cash collections during the month of September?

  1. $190,000
  2. $180,000
  3. $130,000
  4. $100,000

Please explain and show all work.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
September
cash sales (200,000*50%)= 100,000
Credit sales
Sept (200,000*50%*30%) 30,000
aug   (175000*50%*60%) 52500
July   (150,000*50%*10%)= 7500
Total cash collection 190,000 answer
option a
Add a comment
Know the answer?
Add Answer to:
Monroe Group is preparing its cash collections budget. Budgeted sales are $150,000 in July, $175,000 in...
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
  • Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a...

    Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a three-month summary of estimated cash collections. Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150,000 June 175,000 July 160,000 August 200,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: • 60 percent in the month of...

  • a) Prepare a sales budget(in dollars) and cash collections budget for July through September of this...

    a) Prepare a sales budget(in dollars) and cash collections budget for July through September of this year. b) Prepare a production budget (in units) for July through September c) Prepare a direct materials purchase budget(in units) and cash disbursements budget for Carbon Fiber for July through September. Please give the details how to get the answers. Thanks! K&B Enterprises manufactures a high-tech raincoat for children. The following information has been assembled for next year's first quarter (i.e., Jul - Sep)...

  • Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...

    Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow Budgeted Sales Cash payments for merchandise July $62,800 42,800 August $81, 2ee 32,400 September $49,200 33,200 Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $13,500 in cash: $49,600 in accounts receivable: $5.700 in accounts payable, and...

  • Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...

    Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow. Budgeted July 562,450 43.600 August $81,500 32.009 September $49,609 3 2.30 Cash payments for nerchandise Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet Includes balances of $13.900 in cash, $51,100 in accounts receivable; $6,100 in accounts payable, and a...

  • Problem #8 (10 points) Cash Receipt Budget Trapp Co. projected sales are as follows: June July...

    Problem #8 (10 points) Cash Receipt Budget Trapp Co. projected sales are as follows: June July August September October $150,000 $125,000 $100,000 $185,000 $225,000 The company expects to sell 40% of its merchandise for cash. Of the sales on account, 10% are expected to be collected in the month of the sale, 80% the month following the sale and 8% in the following month. The remainder 2% is uncollectible. Prepare a schedule indicating cash receipts for August, September, and October.

  • Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December...

    Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December are estimated as $90,000 and $100,000, respectively. Past practice indicates that sales in any given month are collected as follows: month of sale, 75%; month following the month of sale, 20%; uncollectible accounts, 5%. The company allows a 2% discount for cash collections in the month of sale. What is the net cash estimated to be collected in December?

  • Copper Corporation has the following sales budget for the last six months of 2016: July $200,000...

    Copper Corporation has the following sales budget for the last six months of 2016: July $200,000 October $180,000 August 160,000 November 200,000 September 220,000 December 188,000 Historically, the cash collection of sales has been as follows: 65 percent of sales collected in month of sale, 25 percent of sales collected in month following sale, 8 percent of sales collected in second month following sale, and 2 percent of sales is uncollectable. Cash collections for September are $199,000. $240,000. $204,000. $161,400....

  • Copper Corporation has the following sales budget for the last six months of 2016: July $200,000...

    Copper Corporation has the following sales budget for the last six months of 2016: July $200,000 October $180,000 August 160,000 November 200,000 September 220,000 December 188,000 Historically, the cash collection of sales has been as follows: 65 percent of sales collected in month of sale, 25 percent of sales collected in month following sale, 8 percent of sales collected in second month following sale, and 2 percent of sales is uncollectable. Cash collections for October are $117,000. $174,000. $184,800. $199,000....

  • Sales (in dollars) July 240,000 August 280,000 September 200,000 a All sales on account, sales are...

    Sales (in dollars) July 240,000 August 280,000 September 200,000 a All sales on account, sales are expected to be collected in the following pattern: 40% 50% 10% in the month of sale in the month following sale in the second month following sale a May sales is $160,000 and June Sales is $190,000. Prepare schedule of expected cash collections, by month and for the second quarter. then answer the following questions related to this budget. 1- what is the amount...

  • Question 3 (10 marks) BBG Limited is now in the process of preparing its cash budget...

    Question 3 (10 marks) BBG Limited is now in the process of preparing its cash budget for October. The nning cash balance is $44,000. Budgeted cash receipts total $318,000 and budgeted cash disbursements total $344,000. The desired ending cash balance is $60,000. BBG can borrow up to $500,000 from Hang Seng Bank whenever they are in need of cash, with interest not due until the following month. Required: Prepare the BBG's cash budget for October in good form. Question 4...

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