Please help solving this problem. The data is around the table.

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 TABIB Newport Tie Company TABIA Newport Tie Company Balance Sheet 31-Mar-24 Actual Sales for March and budgeted sales ($1 for April-July are as follows: 1 03.555 1 03555 75,000 8.000 12.500 2.000 4.500 $25.0 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 Cc mpany Balance Sheet At June 30. 2024 Assets 10.000 56,000 11,180 77.180 254,100 331280 26,390 103,555 201.335 331280 Current assets: Cash Accounts Receivable Inve ntory Total current assets Buildings and equipment net Total Assets Liabilities and Liabilities: Accounts Payable Note Payable Total Liabilities Stockholders Equity: Common stock Retained Earnings Total Stockholders' Equity Stockholders' Equity her e the $0 Total Liabilities and Stockholders Equity