IE Exercise 17-19 (Static): Activity-based costing to compute activity rates, overhead cost per unit, and product cost per unit LO P3 Northwest Company produces two types of glass shelving: tounded edge and squared edge. The company reports the foflowing cost data. Naithwest's controller wants to opply activity based costing to allocate the $108,000 of overhead cost to the two products to soe whether product cost per unit would change makedly trom that above, The compam's budgeted activity usage equals as actuat activity usoge for the period. The following additional information is collecterd. Required: 1. Compute the activity rate for each activity using activity-based coston 2. Compute overhead cost per unt for each of the two products using activity based costing 3. Determine prodect cost per unit far eoch of the two products using activity bosed costing Navigatian: 1. Use the Open fixcel in New Tab burten to launch this question, 2. Wher finished in Excel, use the Save and Return to Assignment bution in the lower eight to return to Cornect For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 d costing to allocate the $108,000 of overhead cost to the two products to see dly from that above. The company's budgeted activity usage equals its actual activity mation is collected: 1. Compute the activity rate for each activity using activity-based costing. 5tudents. The soratchpad area is for you to do any additional wosk you need to solve this question or can be used to show your work: Nothins in this area will be graded, but it will be submitted with your assignment. 2. Compute overhead cost per unit for esch of the two products using activity-based costing. Overhead cost per unit - flounded edge Overhead cast per unit - Squared edge Students: The scratchpad area is for you to do ary additional work you need to solve this question of can be used to show your work Nothing in this area wil be graded, but it will be subrnitted with your assignment. 3. Determine product cost per unit for each of the two products using activity-based costing. Students: The seratchpad area is for you to do any additional work you nerd to solve this question or can be used to show your work. Nothing in this area will be graded, but it wall be submitted with your assignment