i need the explanation near each table.

The following data relate to the operations of Medco Company, a wholesale distributor of consumer goods: As of March 31 (USD): Cash 15,500 Accounts payable 35,500 Accounts receivable 21.000 Capital stock 41,000 Inventory 10,080 Retained earnings 102,068 Buildings and equipment (net) 140,000 Assumptions a) Gross margin is of sales b) Actual and budgeted sales data: 3596 USD March (actual) 70,000 June 75,000 April 82.000 July 70,000 May 63.000 Sales are for cash and on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are the result of March credit sales. Break down between Cash & Credit sales is as follow: Cash Sale 65% Credit Sales 35% d) Each month's ending inventory should equal 20% of the following month's budgeted cost of goods sold. e) 25% of a month's inventory purchases are paid for in the month of purchase the remainder is paid for in the following month. The accounts payable at March 31 are a result of March 1 Monthly expenses are as follows: salaries and wages, 512,500 per month; rent, S3,600 per month; other expenses (excluding depreciation), 8% of sales. Assume that these expenses are paid monthly. Depreciation is $1,000 per month (includes depreciation on new assets). 2) Equipment costing $9,000 will be purchased for cash in April. h) The company must maintain a minimum cash balance of $5,000. An open line of credit is available at a local bank. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month; borrowing must be in multiples of $1,000. The annual interest rate is 10%. Interest is paid only at the time of repayment of principal; figure linterest on whole months (1/12, 2/12, and so forth) .5 4) Prepare Schedule of Expected Cash Disbursements-Selling and Administrative Expenses (3 points) Point April May June Quarter - Total Explanation 05 Salaries and wages 12,500 12 500 12 500 37,500 05 Rent 0.5 Other expenses Total disbursements 3,600 6,560 3,600 5,040 3,600 6,000 22,100 10,800 17,600 22,660 21,140 65,900 4.0 5) Complete the following cash budget (17 Points) Explanation Cash deficiency, tepayments and interest should be indicated by a minus s. Point April May kurie Quarter Total 05 cash balance beginning 15.500 9.783 9.113 34401 05 Add cash collections 76 300 69.650 70 0 214,250 Total cash available 9,100 70438 79,013 Less cash disbursements 0.6 For inventory 48353 49 185 43,008 141.446 05 Forexpenses 22,660 21.140 22.00 65,000 05 For equipment 9000 0 9,000 Total cash disbursements R0.013 20,325 66,00 216,346 Eres (deficiency of cash 9,787 9,113 13 905 32,805 Financing 05 Borrowing 0 0 0 05 Repayments 0 ol 0.5 interest 0 0 0 0 Total financing o 0 a Cash balance ending 9,787 9,113 13,905 32 BOS The following data relate to the operations of Medco Company, a wholesale distributor of consumer goods: As of March 31 (USD): Cash 15,500 Accounts payable 35,500 Accounts receivable 21,000 Capital stock 41,000 Inventory 10,080 Retained earnings 102,068 Buildings and equipment (net) 140,000 Assumptions a) Gross margin is of sales 35% b) Actual and budgeted sales data: USD March (actual) 70,000 June 75,000 April 82,000 July 70,000 May 63,000 c) Sales are for cash and on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are the result of March credit sales. Break down between Cash & Credit sales is as follow: Cash Sale 6596 Credit Sales 3596 d) Each month's ending inventory should equal 20% of the following month's budgeted cost of goods sold. e) 25% of a month's inventory purchases are paid for in the month of purchase; the remainder is paid for in the following month. The accounts payable at March 31 are a result of March purchases of inventory. Monthly expenses are as follows: salaries and wages, $12,500 per month; rent, $3,600 per month; other expenses (excluding depreciation), 8% of sales. Assume that these expenses are paid monthly. Depreciation is $1,000 per month (includes depreciation on new assets). ) Equipment costing $9,000 will be purchased for cash in April. h) The company must maintain a minimum cash balance of $5,000. An open line of credit is available at a local bank. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month; borrowing must be in multiples of $1,000. The annual interest rate is 10%. Interest is paid only at the time of repayment of principal; figure interest on whole months (1/12, 2/12, and so forth). 1.5 4) Prepare Schedule of Expected Cash Disbursements-Selling and Administrative Expenses (3 points) Point April May June Quarter. Total Explanation 12,500 12,500 37,500 05 salaries and wages 05 Rent 05 Other expenses Total disbursements 3.600 6,560 12,500 3,600 5,040 21,140 3,600 6,000 10,800 17,600 65,900 22,660 22,100 4.0 Exploration 5) Complete the following cash budget (17 Points) Cash deficiency repayments and interest should be indicated by a minus sign. Point May June Quartet - Total 05 Cash balance betinin 15,500 9788 9,113 05 Add cash collections 74,300 69.550 70.800 214.750 Total och available 39,800 79.48 79.913 214,750 est cash disbursements 05 For inventory 19.185 48.900 141.446 05 For expenses 22.560 21.140 22.100 65,000 00 Tor moment 9,000 0 0 9.000 Total cash bursements N0,013 70,125 66,000 216.146 e deficiency of cash 9,787 9,113 11,905 1,500 Financing o 0 0 0 0 Total financing o Cash, ending 527 9,113 11,005 1.596