please write it in Excel

Adams Technology Inc. has a Job-Order Costing system. The company uses Predetermined Overhead Rates in applying manufacturing overhead cost to individual jobs. The predetermined overhead rate in Department #1 is based on Direct Labour Cost, and the rate in Department #2 is based on Direct Labour Hours. At the beginning of the most recent year, the company's management made the following estimates for the year: Dept 1 Dept 2 Machine-hours 80,000 19,000 Direct labour-hours 30,000 60,000 Direct materials cost $195,000 $292,000 Direct labour cost $260,000 $520,000 Manufacturing overhead cost $400,000 $700,000 Job 66 entered production on April 1 and was completed on May 12. The company's cost records show the following information about the job: Dept 1 Dept 2 Machine-hours 200 60 Direct labour-hours 70 120 Direct materials cost $840 $1,500 Direct labour cost $610 $880 At the end of the year, the records of Adams showed the following actual cost and operating data for all jobs workedon during the year: Dept 1 Dept 2 Machine-hours 80,000 20,000 Direct labour-hours 28,000 66,000 Direct materials cost $156,000 $295,000 Manufacturing overhead cost $385,000 $785,000 Direct labour cost $260,000 $520,000 Required: a) Compute the predetermined overhead rates for Department #1 and Department #2. (4 marks) b) Compute the Total Cost of Job 66. (8 marks) c) Compute the amount of Underapplied/Overapplied Overhead in each Department at the end of the current year. (4 marks)