Question

need 1-4 answered! please help!

2) Schedule of expected cash collections: April May Jun Total sha Tootections .. Nordic Cerpeny, a merchandising company pre- pares its master budget un quarterly base. The following data Save been assembled to Assist in preparation of the master budget for the second quarter. 2. As of March 31 (the end of the prior quare), the company's balance sheet showed the following account balances: June May $1,000 Total Accounts Receivable : Imory HERE ** Plant and Equipment (net) ...... Cal Side... Retained Varnings ... $ 13.00 3283,700 Actual sales for March and budgeted sales for April-July are as follows: March (actual) ...... $60.000 RS 000 3) Inventory purchases budgets April Targeted at of morts sold ............. 343.000 AddDesired ending wory Thuld .. Dedact: Opening love story: Required purchase ...... "For Aplika: 70,000 X 60% atle-52000 1951,000 X 30% - $15.00 4) Schedule of cash disbursements for purchases: April For Merchurches........ Por Apel peche .... . Tor June pucha . Total cash disbarem Apr REFERERE 7000 May Jun Total ** 50,000 c. Sales are 20% for cash and 80% ce credit. All payments on credit wies are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. d. The company's gross profitrate is 40% of sales. Monthly expenses are budgeted as follows malaries and wages, $7,500 per month; ship- ping 6% of ales; advertising 36,000 per month; depreciation, $2.000 per month other expense, 4% of sales At the end of each month, Inventory is to be on hand equal to 30% of the following month's sales needs, stated at cost. Half of a month's faventory purchases are paid for is the month of purchase and half In the following month. Equipment purchases during the quarter will be as follows: April, $11,500; and May, $3.000. Dividends totaling $3,500 will be declared and paid in June. The company must maintain a minimum cash balancs of $8,000. An open line of credit is available at a local barik. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month. Borrowings and repayments of principal must be in multiples of $1,000. Interest is paid only at the time of repayment of principal The annual interest rate is 12%. (Figure interest on whole months, C., Vis, 2.) Uhing the date above, complete the following statements and schedules for the second quarter 1) Sales Budget for the 2 Quarter: April May June Total $14,000 - 56.000 Total Budgeted Sales 70.000 . C

Answer 1

1)	Sales budget for the 2nd Quarter
		April	May	June	Total
	Cash Sales (20% of total sales)	$14,000	$17,000	$18,000	$49,000
	Credit Sales (80% of total sales)	$56,000	$68,000	$72,000	$196,000
	Total Budgeted Sales	$70,000	$85,000	$90,000	$245,000
2)	Schedule of expected cash collections
		April	May	June	Total
	Cash Sales	$14,000	$17,000	$18,000	$49,000
	Credit Sales	$48,000	$56,000	$68,000	$172,000
	Total collections	$62,000	$73,000	$86,000	$221,000
3)	Inventory purchases budget
		April	May	June	Total
	Budgeted Cost of goods sold (60% of total sales)	$42,000	$51,000	$54,000
	Add: Desired ending inventory	$15,300	$16,200	$9,000
	Total needs	$57,300	$67,200	$63,000
	Deduct: Opening Inventory	$12,600	$15,300	$16,200
	Required Purchased	$44,700	$51,900	$46,800	$143,400
	For May = Total sales $85,000 * 60% cost ratio = $51,000
	For June = Total Sales $90,000 * 60% cost ratio = $54,000
	For June Desired Ending Inventory = July Sales $50,000 * 60% cost ratio x 30% = $9,000
4)	Schedule for cash disbursements for purchases
		April	May	June	Total
	For March Purchases	$18,300
	For April Purchases (50% Paid in April and 50% in May)	$22,350	$22,350
	For May purchases (50% paid in May and 50% in June)		$25,950	$25,950
	For June purchases (50% paid in June and 50% in July)			$23,400
	Total cash disbursements	$40,650	$48,300	$49,350	$138,300

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you