*Please show solutions via excel

The president lost a bid on the job by 20,000. It manufactures products according to customer's specifications and uses a job-order costing system. The company uses a plantwide overhead rate based on direct labor cost to apply its manufacturing overhead (assumed to be all fixed) to jobs. The following estimates were made at the beginning of the year: Total Plant Fabricating Department Machining Department Assembly Department Manufacturing overhead 350,000 400,000 90,000 840,000 Direct labor 200,000 100,000 300,000 600,000 Jobs require varying amounts of work in three departments. The job, for example, would have required manufacturing costs in the three departments as follows: Fabricating Department Machining Department Assembly Department Direct materials 30,000 2,000 14,000 Direct labor 28,000 5,000 62,000 ? ? ? Manufacturing overhead Using a plantwide approach: a. Compute the plantwide predetermined rate for the year. b. Determine the amount of manufacturing overhead cost that would have been applied to the Job