Exercise $22-27$A $($Algo$)$ Merchandising: Preparing a cash budget LO P$4$

Use the following information to prepare the July cash budget for Acco Company. Ignore the $$Loan activity$$ section of the budget

Beginning cash balance on July $1$: $$68,000.$

Budgeted cash receipts from sales: $20\%$ is collected in the month of sale, $50\%$ in the next month, and $30\%$ in the second month after sale. Sales amounts are May $($actual$),$ $$1,840,000$; June $($actual$),$ $$1,490,000$; and July $($budgeted$),$ $$1,550,000.$

Budgeted cash payments on merchandise purchases: $65\%$ in the month of purchase and $35\%$ in the month following purchase. Purchase amounts are June $($actual$),$ $$490,000$; and July $($budgeted$),$ $$470,000.$

Budgeted cash payments for salaries in July: $$250,000.$

Budgeted cash payments for sales commissions for July: $$260,000.$

Budgeted cash payment for income taxes in July: $$90,000.$

Budgeted cash payment for loan interest in July: $$9,000.$

can you also do the cash budget its part of the question thank you