Here are some important figures from the budget of Cornell, Inc., for the second quarter of $2020$:

April May June

Credit sales $ $316,000$ $ $296,000$ $ $356,000$

Credit purchases $124,000147,000172,000$

Cash disbursements

Wages, taxes, and expenses $43,60011,10062,600$

Interest $10,60010,60010,600$

Equipment purchases $76,000142,0000$

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

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

In March $2020,$ credit sales were $$186,000,$ and credit purchases were $$126,000.$ Using this information, complete the following cash budget. $($Do not round intermediate calculations.$)$

April May June

Beginning cash balance $ $119,000$

Cash receipt

Cash collection for credit sales

Total cash available

Cash disbursements

Purchases

Wages, taxes and expenses

Interest

Equipment purchases

Total cash disbursement

Ending cash balance