Current Attempt in Progress

Tamarisk Restaurant Supply Company has budgeted sales revenues as follows:

a$1$

Prepare a schedule for expected collections from customers.

Past experience indicates that $60\%$ of the credit sales will be collected in the month of sale and the remaining $40\%$ will be collected in the following month.

Purchases of inventory are all on credit and $50\%$ is paid in the month of purchase and the remaining $50\%$ in the month following purchase. Budgeted inventory purchases are as follows:

beginning cash balance on July $1$ was $$18,200.$ Assume that borrowed money, in this case, is for one month.