What I have so far is correct ( i believe ) please help me finish the last part.

The following data relates to the operations of Dillinger Company, a wholesale distributor of consumer goods:

The following data relate to the operations of Dillinger Company, a wholesale distributor of consumer goods Current assets as of March 31 $ 10,500 $21,000 $ 10,080 Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Capital stock Retained earnings 140,000 $ $ 36,500 $ 40,000 $105,080 a. Gross margin is 30% of sales b. Actual and budgeted sales data $70,000 $72,000 $73,000 $84,000 $80,000 March (actual) May June C. Sales are 70% for cash and 30% on credit Credit sales are collected in the month following sale d. Each month's ending inventory should equal 20% of the following month's budgeted cost of goods e. 25% of a month's inventory purchases are paid for in the month of purchase: the remainder is paid The accounts receivable at March 31 are the result of March credit sales sold 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; 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) f. g. 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 12% Interest is paid only at the time of repayment of principal; figure interest on whole months (1/12, 2/12 and so forth). Required: Using the above data 1. Complete the following schedule Dillinger Company Schedule of Expected Cash Collections Quarter Total $ 50,40051,100 58,800 160,300 64,500 80,700 224,800 April May June Cash sales Credit sales Total collections 21,000 21,600 21,900 71,400 72,700