PLEASE ANSWER THE NUMBER AND WRITE THE FORMULA IN EXCEL

1 Wahyuzan Inc produces two types of ergonomic chairs: Gaming Chair and Office Chair. Due to pandemic, Wahyuzan's demand for Office Chair grown significantly. It estimates production of 150000 units of Gaming Chair and 250000 units of Office Chair. Below are the following data relative with activity cost pools and the cost drivers for each cost pool. 150.000 Gaming Chair Produced Office Chair Produced 250.000 Annual Overhead Data Csurmateu use ur USC Univers per Product Activity Cost Pools Cost Drivers Estimated Overhead Estimated Use of Cost Drivers per Activity Gaming Chair Office Chair 1.700 Ordering and receiving Chair Setup Assembling Inspecting and testing Purchase orders Setups Parts Tests 1.753.000 8.053.000 12.000.000 4.000.000 25.806.000 3.000 orders 2.500 setups 4.000.000 parts 30.000 tests 1.300 1.000 1.800.000 12.000 1.500 2.200.000 18.000 Using the data above: a. Prepare a schedule showing the computations of the activity-based overhead rates per cost driver b. Prepare a schedule assigning each activity's averhead cost to the two products c. Compute the overhead cost per unit for each product 1.a Activity Cost Pools Cost Drivers Estimated Overhead Estimated Use of Cost Driver per Activity Based Activity Overhead Rates 1.b Gaming Chair Office Chair Activity Cost Pools Estimated Use of Cost Drivers per Product Activity-Based Overhead Rates Cost Assigned Estimated Use of Cost Drivers per Product Activity-Based Overhead Rates Cost Assigned 1.c Gaming Chair Office Chair Total Cost Assigned Total Units Produced Overhead Cost per Unit