$\backslash$begin$\{$tabular$\}\{$lccr$\}$

& April & May & June $\backslash \backslash$

Credit sales & $\backslash (\backslash$$ $317,000\backslash )$ & $\backslash (\backslash$$ $297,000\backslash )$ & $\backslash (\backslash$$ $357,000\backslash )\backslash \backslash$

Credit purchases & $125,000$ & $148,000$ & $173,000\backslash \backslash$

Cash disbursements & & & $\backslash \backslash$

Wages, taxes, and expenses & $43,700$ & $11,200$ & $62,700\backslash \backslash$

Interest & $10,700$ & $10,700$ & $10,700\backslash \backslash$

Equipment purchases & $77,000$ & $144,000$ & $0$

$\backslash$end$\{$tabular$\}$

The company predicts that $5$ percent of its credit sales will never be collected, $25$ percent of its sales will be collected in the month of the sale, and the remaining $70$ percent will be collected in the following month. Credit purchases will be paid in the month following the purchase.

In March $2024,$ credit sales were $\backslash (\backslash$$ $187,000\backslash )$ and credit purchases were $\backslash (\backslash$$ $127,000\backslash ).$ Using this information, complete the following cash budget:

Note: Do not round intermediate calculations. Leave no cells blank $-$ be certain to enter $"0"$ wherever required.

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|\}$

$\backslash$hline & $\backslash$multicolumn$\{1\}\{|$c$|\}\{$ April $\}$ & $\backslash$multicolumn$\{1\}\{|$c$|\}\{$ May $\}$ & June $\backslash \backslash$

$\backslash$hline Beginning cash balance & $\backslash (\backslash$$ $\backslash$quad $120,000\backslash )$ & & $\backslash \backslash$

$\backslash$hline Cash receipts & & & $\backslash \backslash$

$\backslash$hline Cash collections from credit sales & $289,150$ & & $\backslash \backslash$

$\backslash$hline Total cash available & & & $\backslash \backslash$

$\backslash$hline Cash disbursements & & & $\backslash \backslash$

$\backslash$hline Purchases & & & $\backslash \backslash$

$\backslash$hline Wages, taxes, and expenses & & & $\backslash \backslash$

$\backslash$hline Interest & & & $\backslash \backslash$

$\backslash$hline Fauinment nurchaces & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$