PLEASE HELP ME!

I DON'T KNOW WHAT I AM DOING WRONG.

Please show the procedure and formulas for each cell and be specific for the signs since this assignment is graded by the computer.

1 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) \begin{tabular}{|lr|} \hline \multicolumn{2}{|c|}{TotalBudgetedIndirect} \\ \hline$ & 45 \\ \hline$ & 13,000 \\ \hline$ & 310 \\ \hline$ & 204 \\ \hline$ & 13,559 \\ \hline \end{tabular} heel of each (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste 3. Compute the company's traditional plantwide overhead rate. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste > INSTRUCTIONS ENTERANSWERS Ready ix Accessibility: Investigate AutoSave OFF O Home Insert Draw Page Layout Formulas Data Review View @ Tell me E9 \begin{tabular}{l|l} fx & 4.5 \end{tabular} \begin{tabular}{l} 1 \\ 2 \\ \hline \end{tabular} Activity-Based Costing, Lean Operations, and the Costs of Quality Use ABC to allocate manufacturing overhead Several years after reengineering its production process, Dettling Corporation hired a new controller, Alana Metzgar. She developed an ABC system very similar to the one used by Dettling's chief rival. Part of the reason Metzgar developed the ABC system was because Dettling's profits had been declining, even though the company had shifted its product mix toward the product that had appeared most profitable under the old system. Before adopting the new ABC system, the company had used a plantwide overhead rate based on direct labor hours that was developed years ago. For the upcoming year, Dettling's budgeted ABC manufacturing overhead allocation rates are as follows: \begin{tabular}{|l|l|l|l|} \hline Activity & \multicolumn{1}{c|}{ Allocation Base } & \multicolumn{2}{c|}{ActivityCostAllocationRate} \\ \hline Materials handling & Number of parts & $4.50 per part \\ \hline Machine setup & Number of setups & $325.00 per setup \\ \hline Insertion of parts & Number of parts & $ & 31.00 per part \\ \hline Finishing & Finishingdirectlaborhours & $ & 51.00 per hour \\ \hline \end{tabular} The number of parts is now a feasible allocation base because Dettling recently installed a plantwide computer system. Dettling produces two wheel models: Standard and Deluxe. Budgeted data for the upcoming year are as follows: Use the blue shaded areas on the ENTERANSWERS tab for inputs. Requirements 1 Compute the total budgeted manufacturing overhead cost for the upcoming year. 2 Compute the manufacturing overhead cost per wheel of each model using ABC. Saving \& Submitting Solution 1 Save file to desktop. INSTRUCTIONS ENTERANSWERS Ready ix Accessibility: Investigate 100%