Hello!
Please post answer with formulas.
the two products with total manufacturing overhead. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) \begin{tabular}{|l|l|c|} \hline \multicolumn{2}{|c|}{ DATA } \\ \hline Activity & Allocation Base & \multicolumn{2}{|c|}{ Allocation Rate } \\ \hline Equipment Setup & Number of Setups & $400 per setup \\ \cline { 2 - 3 } Ordering & Number of Orders & $10 per order \\ \cline { 2 - 4 } Machine Maintenance & Machine Hours & $10 per hour \\ \hline Receiving & Receiving Hours & $20 per hour \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|} \hline \multicolumn{2}{|c|}{ Crest } \\ \hline Allocation Base & Quantity of Activity & Activity Rate & Manufacturing Overhead \\ \hline Number of Setups & 350 & & \\ \hline Number of Orders & 6,000 & & \\ \hline Machine Hours & 24,000 & & \\ \hline Receiving Hours & 3,000 & & \\ \hline Total Manufacturing Overhead & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|} \hline \multicolumn{2}{|c|}{ Cascade } \\ \hline Allocation Base & & 250 & \\ Qumber of Setups & Quantity of Activity & Activity Rate & Manufacturing Overhead \\ \hline Number of Orders & 12,000 & & \\ \hline Machine Hours & 18,000 & & \\ \hline Receiving Hours & 7,000 & & \\ \hline Total Manufacturing Overhead & & & \\ \hline \end{tabular} Reconcile Manufacturing Overhead Total Estimated Manufacturing Overhead Manufacturing Overhead allocated to Crest Manufacturing Overhead allocated to Cascade Total Manufacturing Overhead Allocated Cell | Hint: HINTS D14:D17, I14:117 | For cell references, begin the formula with an equals sign ( =, click on the corresponding cell of the Data table in the ENTERANSWERS tab, and press the enter key. Do not refer to the Instructions tab. E18, J18 | Use the function =SUM( ) to calculate the total manufacturing overhead. Cost Management Systems: Activity-Based, Just-In-Time, and Quality Management Systems Using Excel for allocating manufacturing overhead with activity-based costing (ABC) Mt. Hood Manufacturing uses ABC to allocate manufacturing overhead costs, and has computed the following: The company produces two models of industrial heaters, Crest and Cascade. The quantity of each activity required by Crest and Cascade is listed below. \begin{tabular}{|l|r|r|} \hline Allocation Base & Crest & Cascade \\ \hline Number of Setups & 350 & 250 \\ \cline { 2 - 3 } Number of Orders & 6,000 & 12,000 \\ \cline { 2 - 3 } Machine Hours & 24,000 & 18,000 \\ \cline { 2 - 3 } Receiving Hours & 3,000 & 7,000 \\ \hline \end{tabular} Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Excel Skills
