Hello I just need tha answer to D in excel format. thank you

Indya Jackson Manufacturing Company makes two different products, Precision and Perfect. The company's two departments are named after the products; for example, Product Precision is made in Department Perfect. Indya Jackson's accountant has identified the following annual costs associated with these two products. Financial data Salary of vice president of production division $160,000 Salary of supervisor Department Precision 80,000 Salary of supervisor Department 60,000 Direct materials cost Department Precision 300,000 Direct materials cost Department Perfect 420,000 Direct labor cost Department Precision 240,000 Direct labor cost Department Perfect 680,000 Direct utilities cost Department Precision 120,000 Direct utilities cost Department Perfect 24,000 General factory-wide utilities 36,000 Production supplies 36,000 Fringe benefits 138,000 Depreciation 600,000 Nonfinancial data Machine hours Department Precision 5,000 Machine hours Department Perfect 1,000 Required: Using an Excel Worksheet, prepare a Report, in good form to answer the following: a. Identify the costs that are (1) direct costs of Department Precision, (2) direct costs of Department Perfect, and (3) indirect costs. 20 points b. Select the appropriate cost drivers and allocation rates for the indirect costs and allocate these costs to Departments Precision and Perfect. 20 points c. Determine the total estimated cost of the products made in Departments Precision and Perfect. 15 points d. Assume that Indya Jackson produced 2,000 units of Product Precision and 4,000 units of Product Perfect during the year. If Indya Jackson prices its products at cost plus 40 percent of cost, what price per unit must it charge for Product Precision and for Product Perfect? 15 points