Requirements:

Create all formulas within the Excel worksheet using cell references

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.

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