Please help solving this. The data is around the table

TABIB Newport Tie Company Actual Sales for March and budgeted sales ($1 for April-July are as follows: TABIA Newport Tie Company Balance Sheet 31-Mar-24 March (actual) April June July Collection on Sales Sales collected Current Month Sales collected Following Month Cost of Goods Sold (percentage of sales) Desired ending invenories [Percentage of following month's COGS) Inventory Purchases Paid as Follows I In month of purchase I In following month Variable Monthly Expenses [percentage of sales) S hipping Other expenses Fixed Monthly Expenses Salaries and wages Advertising Fixed Quarterly Expenses Depreciation Equipment Purchases during the Quarter April May Dividends declared and paid in June Agreement with Bank Borrowing increments Maximum borrowing amount Interest Rate per Month Repayment increments Re uired minimum balance 75,000 8.000 5.000 12.500 2.000 4.500 Current assets: Cash Accounts Receivable Inventory T otal current assets Buildings and equipment, net Total Assets Liabilities: Accounts Payable Liabilities and Stockholders' Equity Stockholders' Equity: Common stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity NEWPORT TIE COMPANY April IA: S 01 Expected Cash Conections Cash sales Credit sales Total Cash Collections 1B: Merchandise Purchases Budget Budgeted Cost of Goods Sold Add desired ending inventory T otal N eeds Less beginning inventory Requi.ed dollar purchases 10.000 56,000 11,180 77.180 254,100 331280 26,390 103,555 201.335 331280 June Q u arter 1 C: Schedule of cash disbursements for merchandise purchases March Purchases April Purchases May Purchases June Purchases Total cash disbu.sements for purchases 1 D: Schedule of cash disbursements for selling and administrative expenses Salaries and wages Shipping Advertising O ther expenses T cash disbursements for selling and administrative expenses 26.390 26.330