please use cell refrences and formulas where appropriate on excell, thank you!

The number of parts is now a feasible dlocation base becouse Dettling recently installed a plantvide computer system. Deiting produces two wheel models: Standard and Delure Budgeted data for the upcoming year are as follow; 27 Use the blue shaded areas on the ENTERANS WEFS tab for inpuls. 24. Always use cell telerences and formulas where appropriate to ceceive full credit 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. (Always use cell references and formulas where appropriate to receive full credit.) \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Activity } & Total Budgeted Indirect Cost \\ \hline 5 & Materials handling & \\ \hline 5 & Machine setups & \\ \hline 7 & Insertion of parts & \\ \hline 8 & Finishing & \\ \hline 9 & Total budgeted indirect costs & \\ \hline 10 & & \\ \hline \end{tabular} II 2. Compute the manufacturing overhead cost per wheel of each model using ABC. 12 (Always use cell references and formulas where appropriate to receive full credit.) 12 22]. Compute the company's traditional plantwide overhead rate. (Always use cell references and formulas where appropriate to receive full credit) Plant overhead rate per direct labor hour Use this rate to determine the manufacturing overhead cost per wheel under the traditional system