Can you please answer this question showing your work in excel

431 Job costing, accounting for manufacturing overhead, budgeted rates. The Pisano Company uses a jobcosting system at its Dover, Delaware, plant. Pisano uses normal costing with two directcost categories (direct materials and direct manufacturing labor) and two manufacturing overhead cost pools (the machining department with machinehours as the allocation base and the finished department with direct manufacturing labor costs as the allocation base). The 2014 budget for the plant is as follows: Manufacturing overhead costs Direct Manufacturing labor costs Direct manufacturing labor hours Machine hours Machining Department $9,065,000 Finishing Department $970,000 $4,050,000 36,000 155,000 185,000 37,000 $8,181,000 1. Prepare an overview diagram of Pisano's jobcosting system. 2. What is the budgeted manufacturing overhead rate in the machining department? In the finishing department? 3. During the month of January, the jobcost record for job 431 shows the following: Direct materials used Direct manufacturing labor costs Direct manufacturing labor hours Machine hours Machining Department $13,000 $900 Finishing Department $5,000 $1,250 20 70 140 20 Compute the total manufacturing overhead cost allocated to job 431. 4. Assuming that job 431 consisted of 300 units of product, what is the cost per unit? 5. Amounts at the end of 2014 are as follows: Machining Department $10,000,000 Manufacturing overhead incurred Direct manufacturing $1,030,000 labor costs Machine hours 200,000 Finishing Department $7,982,000 $4,100,000 34,000 Compute the under or overallocated manufacturing overhead for each department and for the Dover plant as a whole. 6. Why might Pisano use two different manufacturing overhead cost pools in its jobcosting system