I have a question regarding a cost allocation problem (7.7). I have to submit answer in excel. I appreciate any assistance. Thank you!

7.7 Consider the following data for a clinical laboratory: Activity Data Annual Test A Test B Test C Test D 2,000 1,500 1,000 500 5 Cost Driver Activity Receive specimen Set up equipment Run test Record results Transmit results5,000 Number of minutes per test Total costs Costs 10,000 Number of tests 5 25,000 100,000 Number of minutes per test Number of minutes per test Number of minutes per test 10 5 10 20 10 10,000 2 $150,000 a. Using ABC techniques, determine the allocation rate for each b. Now, using this allocation rate, estimate the total cost of c. Verify that the total annual costs aggregated from individual test activity. performing each test. costs equal the total annual costs of the laboratory given in the table above