60.1K

Verified Solution

Link Copied!

PLEASE HELP ME ANSWER THE FINAL PART (c) to this question!!!!!

Help John prepare the sales forecast for quarter 2 (outlining amounts for each month ard for the quarter overall). \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Beginning AVR (March) } & \multicolumn{2}{|c|}{ April } & \multicolumn{2}{|c|}{ May } & \multicolumn{2}{|c|}{ June } & \multicolumn{2}{|c|}{ Quarter } \\ \hline & s & 850000 & $ & i & s & i & s & 850000 \\ \hline Aprilcashsales & & 1113125 & & i & & i & & 1113125 \\ \hline April card sales & & 2181725 & & i & & i & & 2181725 \\ \hline April credit sales & & 6339.38 & & 7235.31 & & i & & 10574.69 \\ \hline Maycanh sales & & i & & 1235000 & & i & & 1295000 \\ \hline Maycard sales. & & a. & & 2420600 & & 1 & & 2420600 \\ \hline Maycredit sales & & i & & 370500 & & 802750 & & 11732.50 \\ \hline June cash sales & & i & & i & & 11781.25 & & 1178125 \\ \hline June card sales & & & & i & & 2309125 & & 2309125 \\ \hline June credit sales & & 1 & & 1 & & 3534.38 & & 353438 \\ \hline Total cash receipts & $ & 44787.88 & $ & 47496.31 & \$ & 46434.38 & $ & 13871856 \\ \hline \end{tabular} Determine the collectible (or net) A/R balance at the end of quarter 2. (Round answer to 2 decimal places, e.g. 15.25.) A/R balance at the end of quarter 2 Johris supervisor is working on the compary's budgeted balance sheet for quarter 2 , and he delegates budgeting for the ending A/R balance to John. He gets rieht to work, realizing that he cinit with relevant information from the sales department, as follows. - Sales volume is expected as follows: Acrit, 685 units, Mar, 760 units; June, 725 units; and July, 760 units. - Average velling price is expected to be $65 per unis. - SOK of each months swles are credit card/debit card sales, subject to a 2 K merchunt fee Al approprote receipts will be deposited into the companys account in the month of sale - 25% of cach montrissales are trade credit sales. 30% of trade credit custorners pay their balance in the month of the sale, and 65% pary in fult the month totlowing the sale. 5% of trade credit sales go uncollected. - The ARR balance on March 31 was $8.500, reflecting the remaining collectible amount from March credir sales

Answer & Explanation Solved by verified expert

See Answer