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.

A:l:H1 fx. Master Budget Project \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} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & 0 & c & . & & \\ \hline 36 & & J11y's Cash Collections & & & & \\ \hline 37 & & August's Cash Collections & & & & \\ \hline 3 & & September's Cash Collections & & & & \\ \hline 39 & & Total Cash Collections & & & & \\ \hline \multicolumn{7}{|l|}{40} \\ \hline 41 & 2. & Production Budget & & & & \\ \hline 43 & & \multicolumn{4}{|c|}{ The company maintains a finished goods inventory equal to 10% of the following } & \\ \hline 44 & & \multicolumn{4}{|c|}{ month's sales. The inventory of finished goods on July 1 is as it should be. } & \\ \hline 45 & & VaughanCompany & & & & \\ \hline 47 & & Production Budget & & & & Total \\ \hline 48 & & 3 rd Quarter & July & August & September & 3rd Quarter \\ \hline 49 & & & & & & \\ \hline 50 & & Budgeted Sales in Units & & & & \\ \hline 51 & & Add: Desired Ending Inventory & & & & \\ \hline 52 & & Total Needs & & & & \\ \hline 53 & & Less: Beginning Inventory & & & & \\ \hline 54 & & Required Production & & & & \\ \hline \end{tabular} MasterBudgetProject Group 09 Vaughan Company makes AM AZING SUPER DUPER Widgets. Management is now preparing detailed budgets for the third quarter, July through S eptember, and has assembled the following information to assist in budget preparation: 1. Sales Budget The marketing department has estimated sales as follows for the remainder of the year: (Actual sales in June were 5,000 units) \begin{tabular}{|r|r|l|r|} \hline July & 4,000 & October & 4,000 \\ \hline August & 12,000 & November & 6,000 \\ \hline September & 15,000 & December & 8,000 \\ \hline \end{tabular} The selling price of a SUPER DUPER widget is $80 and all sales are on account. Based on past experience, sales are collected in the following pattern: 20% in the month of sale 75% in month following the sale 5% are ne ver collected (uncollectible) \begin{tabular}{|c|c|c|c|c|} \hline Vaughan Company & & & & \\ \hline Sales Budget & & & & Total \\ \hline 3rd Quarter & J1ly & August & September & 3rd Quarter \\ \hline Sales in Units & & & & \\ \hline Selling Price per Unit & & & & \\ \hline Tota1 Sales in $ & & & & \\ \hline Cash Collections & & & & \\ \hline June's CashCollections & & & & \\ \hline July's Cash Collections & & & & \\ \hline August's Cash Collections & & & & \\ \hline September's Cash Collections & & & & \\ \hline Tota 1 Cash Collections & & & & \\ \hline \end{tabular} A:l:H1 fx. Master Budget Project \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} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & 0 & c & . & & \\ \hline 36 & & J11y's Cash Collections & & & & \\ \hline 37 & & August's Cash Collections & & & & \\ \hline 3 & & September's Cash Collections & & & & \\ \hline 39 & & Total Cash Collections & & & & \\ \hline \multicolumn{7}{|l|}{40} \\ \hline 41 & 2. & Production Budget & & & & \\ \hline 43 & & \multicolumn{4}{|c|}{ The company maintains a finished goods inventory equal to 10% of the following } & \\ \hline 44 & & \multicolumn{4}{|c|}{ month's sales. The inventory of finished goods on July 1 is as it should be. } & \\ \hline 45 & & VaughanCompany & & & & \\ \hline 47 & & Production Budget & & & & Total \\ \hline 48 & & 3 rd Quarter & July & August & September & 3rd Quarter \\ \hline 49 & & & & & & \\ \hline 50 & & Budgeted Sales in Units & & & & \\ \hline 51 & & Add: Desired Ending Inventory & & & & \\ \hline 52 & & Total Needs & & & & \\ \hline 53 & & Less: Beginning Inventory & & & & \\ \hline 54 & & Required Production & & & & \\ \hline \end{tabular} MasterBudgetProject Group 09 Vaughan Company makes AM AZING SUPER DUPER Widgets. Management is now preparing detailed budgets for the third quarter, July through S eptember, and has assembled the following information to assist in budget preparation: 1. Sales Budget The marketing department has estimated sales as follows for the remainder of the year: (Actual sales in June were 5,000 units) \begin{tabular}{|r|r|l|r|} \hline July & 4,000 & October & 4,000 \\ \hline August & 12,000 & November & 6,000 \\ \hline September & 15,000 & December & 8,000 \\ \hline \end{tabular} The selling price of a SUPER DUPER widget is $80 and all sales are on account. Based on past experience, sales are collected in the following pattern: 20% in the month of sale 75% in month following the sale 5% are ne ver collected (uncollectible) \begin{tabular}{|c|c|c|c|c|} \hline Vaughan Company & & & & \\ \hline Sales Budget & & & & Total \\ \hline 3rd Quarter & J1ly & August & September & 3rd Quarter \\ \hline Sales in Units & & & & \\ \hline Selling Price per Unit & & & & \\ \hline Tota1 Sales in $ & & & & \\ \hline Cash Collections & & & & \\ \hline June's CashCollections & & & & \\ \hline July's Cash Collections & & & & \\ \hline August's Cash Collections & & & & \\ \hline September's Cash Collections & & & & \\ \hline Tota 1 Cash Collections & & & & \\ \hline \end{tabular}