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