Parts C and D or (#3 and #4) please show formulas looking for FORMULAS in your cells. Do not plug numbers into your cells - I want to be able to change the number of sales in units in your Sales Budget and see the WHOLE budget update. Please make sure you interlock your budgets with formulas.

\begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & & . & D & & \\ \hline 53 & & Less: Beginning Inventory & & & & \\ \hline 54 & & Reguired Production & & & & \\ \hline \multicolumn{7}{|l|}{56} \\ \hline 56 & 3. & Raw Materials Purchasing Budget & & & & \\ \hline 58 & & \multicolumn{5}{|c|}{ Each unit of SUPER DUPER widget requires 0.6 pounds of WHAM compound. To } \\ \hline 59 & & \multicolumn{5}{|c|}{ prevent shortages, the company would like the inventory of WHAM compound on hand } \\ \hline 60 & & \multicolumn{4}{|c|}{ at the end of each month to equal 40% of the following month's production needs. } & \\ \hline 61 & & \multicolumn{2}{|c|}{ The inve ntory on July 1 is 1,344 pounds. } & & & \\ \hline 63 & & \multicolumn{5}{|c|}{ WHAM compound costs $10.00 per pound and Vaughan pays for 50% of its purchases } \\ \hline 84 & & \multicolumn{4}{|c|}{ in the month of purchase; the remainder is paid in the following month. $41,184} & \\ \hline 60 & & \multicolumn{4}{|c|}{ of WHAM compound was purchased in June and 50% was paid for in June. } & \\ \hline 67 & & VaughanCompany & & & & \\ \hline 68 & & RM Purhasing Budget & & & & Total \\ \hline 69 & & 3 rd Quarter & Ju1y & A1gust & September & 3rd Quarter \\ \hline 70 & & & & & & \\ \hline 71 & & Required Production & & & & \\ \hline 72 & & RM per Unit & & & & \\ \hline 73 & & ProductionNeeds & & & & \\ \hline 74 & & Add: Desired Ending I nventory & & & & \\ \hline 75 & & Total Needs & & & & \\ \hline 76 & & Less: Beginning Inventory & & & & \\ \hline & & RM to be Purchased & & & & \\ \hline 78 & & Cost of RM per pound & & & & \\ \hline 79 & & Cost of RM to be Purchased & & & & \\ \hline0 & & & & & & \\ \hline 81 & & Cash Disbursements for RM & & & & \\ \hline 82 & & & & & & \\ \hline & & June's RM Purchases & & & & \\ \hline 84 & & July's RM Purchases & & & & \\ \hline & & August's RM Purchases & & & & \\ \hline8 & & September's RM Purchases & & & & \\ \hline 87 & & Total Disbursements & & & & \\ \hline \end{tabular} A:l:H1 fx. Master Budget Project