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?
Please explain and show all work.
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 | |||||||
Monroe Group is preparing its cash collections budget. Budgeted sales are $150,000 in July, $175,000 in...
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 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 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 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 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 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 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 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 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 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...