\begin{tabular}{|c|c|c|} \hline 4 & A & B \\ \hline 1 & Inputs: & \\ \hline 2 & & \\ \hline 3 & 1st quarter unit sales & 20,000 \\ \hline 4 & Growth rate in sales per quarter & 20% \\ \hline 5 & Selling price & 50 \\ \hline 6 & Percent of quarterly sales received in quarter & 25% \\ \hline 7 & Unit cost & 35 \\ \hline 8 & Desired ending inventory (\% of following qtr CGS) & 85% \\ \hline 9 & Percent of purchases paid in month of purchase & 70% \\ \hline 10 & Variable expense per unit & 8 \\ \hline 11 & Total Fixed expenses & 120,000 \\ \hline 12 & Depreciation expense & 25,000 \\ \hline 13 & Capital expenditures per quarter & 30,000 \\ \hline 14 & Interest rate on loan balance of previous quarter & 1% \\ \hline 15 & & \\ \hline \end{tabular} Sales Budget \begin{tabular}{|c|c|c|c|c|c|c|} \hline 2 & & -1 & & & & \\ \hline 3 & & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 & Year \\ \hline 4 & & & & & & \\ \hline 5 & Expected unit sales & 20,000 & 24,000 & 28,800 & 34,560 & 107,360 \\ \hline 6 & & & & & & \\ \hline 7 & Unit selling price & 50 & 50 & 50 & 50 & 50 \\ \hline 8 & & 4 & & & & \\ \hline 9 & Total sales & 1,000,000 & 1,200,000 & 1,440,000 & 1,728,000 & 5,368,000 \\ \hline \end{tabular} Cash Receipts Budget \begin{tabular}{|c|c|c|c|c|c|} \hline & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 & Year \\ \hline Accounts receivable, beginning & - & 750,000 & 900,000 & 1,080,000 & \\ \hline Quarter 1 sales & 250,000 & & & & 1,000,000 \\ \hline Quarter 2 sales & & 300,000 & & & 1,200,000 \\ \hline Quarter 3 sales & & & 360,000 & & 1,440,000 \\ \hline Quarter 4 sales & & & & 432,000 & 432,000 \\ \hline & & & & & \\ \hline Total cash receipts & 250,000 & 1,050,000 & 1,260,000 & 1,512,000 & 4,072,000 \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Purchases Budget Purchases Payment Budget