Mini$-$Exercise $14-7($Static$)$ Cash budget LO $14-7$

ABC Company has a cash balance of $$22,000$ on August $1$ and requires a minimum ending cash balance of $$20,000.$ Cash receipts from sales budgeted for August are $$306,180.$ Cash disbursements budgeted for August include inventory purchases, $$40,000$; other manufacturing expenses, $$92,000$; operating expenses, $$78,600$; bond retirements, $$50,000$; and dividend payments, $$15,000.$

Required:

Prepare a cash budget for ABC Company for August.

Note: Leave no cells blank, enter zero $(0)$ wherever required.

$\backslash$table$[[,$August$],[$Beginning cash balance,$