The company produces two models of industrial heaters, Crest and Cascade. The quantity of each activity required by Crest and Cascade is listed below. 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. Requirement Allocate the $1,040,000 estimated manufacturing overhead between the products using activity-based costing to obtain the total manufacturing overhead cost per product. Reconcile the manufacturing overhead allocated to the two products with total manufacturing overhead. Excel Skills Create formulas with cell references. Saving \& Submitting Solution L Save file to desktod. Instructions DATA \begin{tabular}{|l|r|} \hline Allocation Base & Allocation Rate \\ \hline Number of Setups & $400 per setup \\ \hline Number of Orders & $10 per order \\ \hline Machine Hours & $10 per hour \\ \hline Receiving Hours & $20 per hour \\ \hline \end{tabular} 10 Maintenance g Crest 12 Crest 13 on Base 14 of Setups 15 of Orders 16 . Hours 17 g Hours 18 anufacturing Overhead 19 20 e Manufacturing Overhead 21 imated Manufacturing Overhead 22 sturing Overhead allocated to Crest 23 turing Overhead allocated to Cascade 24 anufacturing Overhead Allocated 25 26 27 28 29 |I | Hint: HINTS \begin{tabular}{|l|l|} \hline & Cascade \\ \hline Allocation Base & Quantity of AC \\ \hline Number of Setups & \\ \hline Number of Orders & \\ \hline Machine Hours & \\ \hline Receiving Hours \\ \hline Total Manufacturing Overhead & \\ \hline \end{tabular} ta table in the ENTERANSWERS tab, and press the