ABC Company's budgeted sales'for June, July, and August are $14,400,18,400,$ and $16,400$ units respectively. The selling price for each unit is $$12.$ Based on past experience, ABC expects that $30\%$ of a month's sales will be collected in the month of sale, $60\%$ in the following month, and $5\%$ in the second month following the sale.

Required:

Prepare an analysis of cash receipts from sales for ABC Company for August.

$\backslash$table$[[,$June,July,August$],[$Budgeted sales units,,,$],[$Unit selling price,,,$],[$Budgeted sales revenue,,,$],[$August collections:,,,$],[$Current month's sales,,,$],[$Prior month's sales,,,$],[$Second prior month's sales,,,$],[$Total collections,,$$,]]$