with excel formulas

A1 A1 Chapter 8: Applying Excel Fourth-quarter sales 37 Total cash collections 7. Construct the production budget Budgeted unit : 42 Add desired finishisd goods inventory 43 Total net: 44 Less begioning inventory 45 Required production 46 Construct the raw materials purchases budget 49 Required production (units) 50 Raw materials required to produce one unit 51 Production needs (pounds) 52 Add desired ending inventory of raw materials (pounds) Total needs (pounds) Less beginning inventory of raw materials (pounds) Raw materials to be purchased Cost of raw materials per pound Cost of raw materials to be purchased B +1 ? D ? E ? 40 1 ? F ? Year 2 Quarfer Yoar 2 Quarter 1 3 ? ? ? I ? ? ? ? ? ? 4 Year ? ? ? ? ? G. H ? ? ? ? ? Yoar 3 Quarter ? 1 2 ? ? Year 3 Quarter Year. ? ? ? ? ? ? ? ? 7?????????? \begin{tabular}{|c|c|c|c|c|} \hline ? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline ? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline \end{tabular}