Please help solving this problem. 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 2 Current assets: Cash Accounts Receivable Inventory T otal current assets Buildings and equipment, net Total Assets Liabilities and Stockholders' Equity Liabilities: Accounts Payable Stockholders' Equity: Common stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity NEWPORT TIE COMPANY Cash Budget For the three-month period ending June 30. 2024 10.000 56,000 11,180 77.180 254,100 331280 26,390 103,555 201.335 331280 June April 10.000 10.000 1 ODOO May Quarter Beginning cash balance Add cash collections T otal cash available Less cash disbursements: Inventory purchases Selling and Administrative Equipment purchases D ividends T otal cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings R epayments Interest T otal financing Ending cash balance