Please include your clear solutions using Ms excel. Kindly read the instructions in the picture below. Thank you?

Levine Company produces two products: A and B. The company has three overhead functions that are required for both products. Below is production information for Products A and B: Product Prime Direct Overhead Overhead Overhead Costs Labor Function Function Function (Direct Hours #1 #2 #3 Materials + Direct Labor) A $35 4 hrs 2 hrs 1 hr 6 hrs B $22 1.5 hrs 1 hr 8 hrs, 1 hr The company produces 800 units of Product A and 8,000 units of Product Beach period. The overhead functions have the following hourly costs: Function Hourly Rate $10 7 3 18 INSTRUCTIONS: KINDLY INCLUDE YOUR CLEAR SOLUTIONS IN EACH QUESTION USING MS EXCEL AND UPLOAD LINK IF ITS OKAY. BUT IF NOT, YOU CAN SEND YOUR EXCEL SCREENSHOT. THANK YOU 14. Refer to Levine Company If total overhead is assigned to A and B on the basis of units produced, Product A will have an overhead cost per unit of a. $ 88.64. b. $123.64. c. $135.00. d. None of the responses are correct15. Refer to Levine Company If total overhead is assigned to A and B on the basis of units produced, Product B will have an overhead cost per unit of a. $84.00. b.$88.64. c. $110.64. d. None of the responses are correct 16. Refer to Levine Company If total overhead is assigned to A and B on the basis of direct labor hours, Product A will have an overhead cost per unit of a. $51.32 b. $205.26 c. $461.88 d. None of the responses are correct 17. Refer to Levine Company If total overhead is assigned to A and B on the basis of direct labor hours, Product B will have an overhead cost per unit of a. $76.97 b. $87.75 c. $88.64 d. None of the responses are correct 18. Refer to Levine Company If total overhead is assigned to A and B on the basis of overhead activity hours used, the total product cost per unit assigned to Product A will be a. $86.32. b. $95.00. c. $115.50 d. None of the responses are correct19. Refer to Levine Company If total overhead is assigned to A and B on the basis of direct labor hours, Product B will have an overhead cost per unit of a. $51.32 b. $76.97 c. $510.32 d. None of the responses are correct 20. Refer to Levine Company If total overhead is assigned to A and B on the basis of overhead activity hours used, the total product cost per unit assigned to Product B will be a. $115.50 b. $73.32 c. $34.60 d. None of the responses are correct