Hello, I need help filling out this chart, the current data I have so far is correct

$-$

Required information

$[$The following information applies to the questions displayed below.$]$

Built$-$Tight is preparing its master budget. Budgeted sales and cash payments follow:

Budgeted sales July August September Budgeted cash payments for $$55,000$ $$71,000$ $$57,000$ Direct materials Direct labor $15,36012,64012,960$ Overhead $3,2402,5602,64019,40016,00016,400$

Sales to customers are $20\%$ cash and $80\%$ on credit. Sales in June were $$52,500.$ All credit sales are collected in the month following the sale. The June $30$ balance sheet includes balances of $$51,000$ in cash and $$4,200$ in loans payable. A minimum cash balance of $$51,000$ is required. Loans are obtained at the end of any month when the preliminary cash balance is below $$51,000.$ Interest is $1\%$ per month based on the beginning$-$of$-$the$-$month loan balance and is paid at each month$-$end. Any preliminary cash balance above $$51,000$ is used to repay loans at month$-$end. Expenses are paid in the month incurred and consist of sales commissions $(10\%$ of sales$),$ office salaries $($ $$3,200$ per month$),$ and rent $($ $$5,700$ per month$).$

$2.$ Prepare a cash budget for the months of July, August, and September.

Note: Negative balances and Loan repayment amounts $($if any$)$ should be indicated with minus sign. Enter your final answers in whole dollars.

BUILT$-$TIGHT Cash Budget July August September Beginning cash balance $ $51,000$ $ $51,000$ Add: Cash receipts $53,00058,20068,200$ Total cash available $104,000109,200$ Less: Cash payments for Direct labor $3,2402,5602,640$ Direct materials $15,36012,64012,960$ Overhead $19,40016,00016,400$ Sales commissions $5,5007,1005,700$ Office salaries $3,2003,2003,200$ Rent $5,7005,7005,700$ Interest on loan Total cash payments $52,40047,20046,600$ Preliminary cash balance Loan activity Additional loan $000$ Repayment of loan to bank Ending cash balance $000$ Loan balance July August September Loan balance $-$ Beginning of month Additional loan $($loan repayment$)$ Loan balance $-$ End of month