please answer for me this question I gave you already datas in Excell.

B X fx =VLOOKUP(B15,B4:K7,2,FALSE) Product name 1 Units 2 # of Batches 3 Machine hours 4 Direct labor hours Overhead cost 1 Units Product name Direct material Direct labor AllocatedOverhead Total Cost per unit D NO246 $ $ $ $ E $ NO246 $ 142,000.00 $ 31,500.00 45,494.51 218,994.51 $ 3,000 5 4,100 2,100 345,000.00 22,750.00 73 F ## AR478 $ $ $ $ LM213 $ 7,000 $ 10 $ 4,000 $ 2,450 $ 15.16 per H 90 $ RY780 4,000 $ 8 $ 5,500 $ 2,750 $ AR478 LM213 $ 138,000.00 $ 137,000.00 $ $ 36,750.00 $ 41,250.00 $ $ 45,494.51 $ 45,494.51 $ $ 220,244.51 $ 223,744.51 $ Units RY780 81 $ 8,750 15 7,250 2,900 128,900.00 43,500.00 45,494.51 217,894.51 $ 75 J Total S $ S K 22,750 38 20,850 10,200 Total $ 545,900.00 $ 153,000.00 $ 181,978.02 $ 880,878.02 L 1. What is the cost per unit of each product when machine hours are used as the cost driver for overhead allocation? 2. How much overhead is allocated to the AR478 product line when direct labor hours are used as the cost driver for overhead allocation? 3. What is the total cost of the LM213 product line when direct labor hours are used as the cost driver for overhead allocation? 4. What is the cost per unit of the RY780 product line when the number of batches is used as the cost driver for overhead allocation? 5. What is the allocation rate when machine hours are used as the cost driver