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 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 Company Income Statement Quarter Ended June 30, For the Cost of Goods Sold Gross Margin 10.000 56,000 11,180 77.180 254,100 331280 26,390 103,555 201.335 331280 2024 $271 -ooo Foa bas Selling and Administrative Expenses: Shipping Advertising Depreciation ather expenses Net operating income Other Expenses and Losses: Interest Expense Net Income (loss)