Solve for production budget & Sales budget.

Sales Budget BBJ: Projected Sales in units Projected Revenue EBJ: Projected Sales in units Projected Revenue JBJ: Projected Sales in units Projected Revenue Total Projected Revenue Less Sales RAD Net Sales Revenue Schedule of Cash Collections Cash Sales Collections Previous Year Q3 Collections Previous Year Q4 Collections from Current Year Q1 Collections from Current Year Q2 Collections from Current Year Q3 Collections from Current Year Q4 Estimated Bad Debt Expense \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{3}{|c|}{2018} & \\ \hline & Q1 & Q3 & Q4 & TOTAL \\ \hline & & & & \\ & & & & \\ & & & & \\ & & & & \\ \hline & & & \\ \hline \end{tabular} Proof: Total Sales + Beg. A/R - Total Collections - Bad Debt = Ending A/R Note: Hide these rows when budget is completed Note: hide these columns when budget is completed