Can you please do the work on excel so i can see the steps

Super Chairs $($SC$)$ manufactures funky chairs. SC has identified various activity centres to which

overhead costs are assigned. The cost pools for these centres and their selected cost drivers for

$2023$ are as follows:

SC$\text{'}$s products and other operating statistics follow:

SC uses direct labour hours to allocate manufacturing overhead under traditional costing.

Tasks: Answer the following questions:

Under traditional costing:

a$)$ What is the predetermined overhead rate? $2$ marks

b$)$ What is the total amount of manufacturing overhead allocated to Metaz Chairs? $2$ marks

c$)$ What are the total product costs for all Metaz Chairs? $2$ marks

d$)$ What are the product unit costs for a Yak Chair? $2$ marks

Under activity$-$based costing:

e$)$ What are the activity$-$based overhead rates for the three cost pools? $3$ marks

f$)$ What is the total amount of manufacturing overhead allocated to Metaz Chairs? $3$ marks

g$)$ What are the total product costs for all Metaz Chairs? $2$ marks

h$)$ What are the product unit costs for a Yak Chair? $2$ marks

i$)$ What are the product unit costs for a Latko Chair? $2$ marks