asap please with cell referencing

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & c & D & E & F & G \\ \hline 34 & & & & & & & \\ \hline 35 & Budget \#4 & & & \multirow{3}{*}{\multicolumn{3}{|c|}{\begin{tabular}{l} Computer Accessories \\ Manufacturing Cost Budget \\ For the year ending December 31,20XX \end{tabular}}} & \\ \hline 36. & & & & & & & \\ \hline 37 & & & & \multirow{2}{*}{\multicolumn{4}{|c|}{\begin{tabular}{l} For the year ending December 31,200 \\ Second Third Fourth \end{tabular}}} \\ \hline & & & First & & & & \\ \hline 38 & & & Quarter & Quarter & Quarter & Quarter & Annual Total \\ \hline 39 & & Direct Materials & & & & & 2 \\ \hline 40 & E. & Budgeted production in units & & & & & \\ \hline 41 & 28 & Cost per kit & & = & & & \\ \hline 42 & & Direct material cost & & & & & \\ \hline 43 & & & & & & & \\ \hline 44 & & Direct labor & & & & & \\ \hline 45 & & Budgeted production in units & & & & & \\ \hline 46. & & Direct labor cost per unit & & & & & \\ \hline 47 & & Direct labor cost & & & & & \\ \hline 48. & & & & & & & \\ \hline 49 & & Variable Manufacturing Overhead & & & & & \\ \hline 50 & & \begin{tabular}{l} Budgeted production in units \\ Vanable Overhead cost per unit \end{tabular} & & & & & \\ \hline \begin{tabular}{l} 51 \\ 52 \end{tabular} & & \begin{tabular}{l} Vanable Overhead cost per unit \\ Variable Manufacturing Overhead \end{tabular} & & & & & \\ \hline 53 & & Variable Manulacturing Overhead & & & & & \\ \hline 54 & & Fixed Manufacturing Overthead & & & & & \\ \hline \begin{tabular}{l} 55 \\ 56 \end{tabular} & & Total Manufactuning Costs & & ab & & & E \\ \hline & & & & & & & \\ \hline 58 & & & & & & & \\ \hline 59 & Budqet $5 & & & Computer A & ccessones. & & \\ \hline 60 & & & & Selling and & Administrative & Expenses Bud & dqet: \\ \hline 61 & & & & For the yea & \begin{tabular}{l} ending Decer \\ Third \end{tabular} & \begin{tabular}{l} nber 31,200 \\ Fourth \end{tabular} & \\ \hline 62 & & & \begin{tabular}{l} First \\ Quarter \end{tabular} & \begin{tabular}{l} Second \\ Quarter \end{tabular} & \begin{tabular}{l} Third \\ Quarter \end{tabular} & Quarter & Annual Total \\ \hline 63 & & Budgets Sales Units from Budget \#1 & & & & & \\ \hline 64 & & Budgets Sales Dollars from Budget #1. & & & & & \\ \hline 65 & & & & & & & \\ \hline \begin{tabular}{l} 66 \\ 67 \end{tabular} & & \begin{tabular}{l} Variable selling and admin. expenses \\ Bad Debts \end{tabular} & & & & & \\ \hline \begin{tabular}{l} 67 \\ 68 \end{tabular} & & \begin{tabular}{l} Bad Debts \\ Vanable selling and admin expenses \end{tabular} & & & & & \\ \hline 69 & & Total varable selling and admin. Expenses & & & & & \\ \hline 70 & & Fixed Seling and administrative Expenses & & & & & \\ \hline 71 & & Total selling and administrative expenses & & & & & \\ \hline \end{tabular} Part 1 relates to Module 22 make sure you take time to Review 224, which also has a video in MBC that walks you through the review. I haw budgot support materal in the Module 22 folder in the course Computer Accessones assembies a computer networkang device from kits of imported components. You have been asked to dewilop a quarterfy and annual operating budget and a pro-forma income stalements for the year ending December 31,20x You haw oblainod the following infornation I have a ternplate set up on the PartiBudgetSolution workshoet that you showh ure to complete the roquired budgots You need to use cell references in the development of your budgets. You must use this worksheet to reference the data that is being inputted onto the budgets on the budget worksheet. If you type in any numbers in the solution, I will take off 5 pts for each cell that has a number typed in the cell. You should use this worksheet as your data ficld and only une ced refercnces and formulas in your budgets The beauty behind excel is that managers can perform what-if analysers jest by changing the data, so you do not noed to retype the budgots if you have used cell references and formulas throughout elling and administrative costs are paid in quarter incurred uniess it is an noncash exnence