if anyone can help can you explain how you did it

CRAVAT SALES COMPANY Minimum ending cash balance Selling price (per unit) Recent and forecast sales (in units): January (actual) February (actual) March (actual) April May June July August September Desired ending inventories (percentage of next month's sales) Cost of ties (per unit) Purchases paid as follows: In month of purchase In following mortith 50% 50% Collection on sales: Sales collected current month Sales collected following month 30% Sales collected 2 nd month following 10% Variable monthly expenses: Sales commissions (per tie) Fixed monthly expenses: Wages and salaries Utilities Insurance Depreciation Miscellaneous Land purchased in May Dividends declared each quar Balance sheet at March 31: \begin{tabular}{lrr} \multicolumn{1}{l}{ Assets } \\ Cash & & $14,000 \\ Accounts receivable & \\ February sales & $19,440 & \\ March sales & 158,760 & 178,200 \\ Inventory (24,750 units ) & & 120,037.50 \\ Prepaid insuranct & 14,400 \\ Fixed assets, net of depreciation & 172,700 \\ \hline Total assets & $499,337.50 \\ \hline \end{tabular} Liabilities and Stockholders' Equity Accounts payable \$ 76,993.75 Dividends payable 12,000 Liabilities and Stockholders' Equity Accounts payable Dividends payable Capital stock Agreement with Bank: Borrowing increments Maximum borrowing amount Interest rate per month Repayment increments Total of interest paid each quarter \$ 76,993.75 Required minimum cash balance \$ 12,000 CRAVAT SALES COMPANY Cash Budget For the Three Months Ending June 30 CRAVAT SALES COMPANY Cash Budget For the Three Months Ending June 30 \begin{tabular}{l} Cash balance, beginning \\ \cline { 2 - 4 } Add receipts from customers \\ Total cash available \\ Less disbursements: \\ Purchase of inventory \\ Sales commissions \\ Salaries and wages \\ Utilities \\ Miscellaneous \\ Dividends paid \\ Land purchases \\ Total disbursements \\ Excess (deficiency) of receipts \\ over disbursements \\ Financing: \\ Borrowings \\ Repayments \\ Interest \\ Total financing \\ Cash balance, ending \end{tabular} 3. CRAVAT SALES COMPANY Budgeted Income Statement For the Three Months Ended June 30 Sales in units Sales. Variable expenses: Cost of goods sold Commissions Contribution margin Fixed expenses: Salaries and wages Utilities Insurance expired Depreciation Miscellaneous Net operating income Less interest expense Net income CRAVAT SALES COMPANY Budgeted Retained earnings at June 30: Balance, March 31 Add net income Total Less dividends declared Balance, June 30