3 VATVESTARCOSIA ACC 202-Excel 2 Template 1. Sales budget: Budgeted unit sales Selling price per unit Total sales b. Schedule of expected cash collections: February sales (XX8) March sales (XX%,XK%) April sales (DOK\%, X0\%\%, X0C\%) May sales (XOK,XOK) June sales (XX\%) Total cash collections c. Merchandise purchases budget: Budgeted unit sales Add desired ending merchandise inventory Total needs Less beginning merchandise inventory Required purchases Cost of purchases at $X per unit \begin{tabular}{|c|c|c|c|} \hline April & May & June & Quarter \\ \hline$74,000 & $50,000 & $50,000 & $74,000 \\ \hline$436,000 & $695,000 & $865,000 & $1,996,000 \\ \hline$510,000 & $745,000 & $915,000 & $2,170,000 \\ \hline \end{tabular} $258,000 $318,000 $244,000 $820,000 $200,000 $200,000 $200,000 $600,000 $54,000 $18,000 $18,000 $106,000 $318,000 \begin{tabular}{|c|c|c|c|} \hline$18,000 & $18,000 & $18,000 & $4,000 \\ \hline$106,000 & $106,000 & $106,000 & $318,000 \\ \hline$26,000 & $40,000 & $20,000 & $86,000 \\ \hline$7,000 & $7,000 & $7,000 & $21,000 \\ \hline$0 & $16,000 & $40,000 & $56,000 \\ \hline$15,000 & $0 & $0 & $15,000 \\ \hline$630,000 & $705,000 & $635,000 & $1,970,000 \\ \hline$120,000 & $40,000 & $280,000 & $200,000 \\ \hline \end{tabular} $170,000 $10,000 \begin{tabular}{|c|c|} \hline$0 & $180,000 \\ \hline(180,000) & (180,000) \\ \hline 5,300 & 5,300 \\ \hline(185,300) & (185,300) \\ \hline 94.700 & $4,700 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Advertising & & & & xcoc \\ \hline Rent & x000x & xcocx & & xcocx \\ \hline Salaries & & & & xcocx \\ \hline Commissions (X\% of sales) & & x000x & xcocx & xcocx \\ \hline Utilities & x