Oxford Corporation has four categories of overhead. The expected overhead costs for each category for next year are as follows: Maintenance Materials handling Setups Inspection $210,000 90,000 75,000 150,000 The company has been asked to submit a bid for a proposed job for Alonso Corp.. The plant manager believes that obtaining this job would result in new business in future years. Bids are usually based upon full manufacturing cost plus 30 percent. Estimates for the proposed job are as follows: Direct materials Direct labor (375 hours) Number of material moves Number of inspections Number of setups Number of machine-hours $5,000 $7,500 4 3 2 150 0 Expected activity for the four activity-based cost drivers that would be used is: Required: Machine-hours Material moves Setups Quality inspections 10,000 2,000 100 4,000 a) Determine the overhead rate if the company uses the traditional, single plant-wide rate approach if 20,000 direct labor-hours are used as the volume-based cost driver. b) Determine the amount of overhead that would be applied to the proposed Alonso project if activity- based costing is used. c) Determine the total costs of the proposed job if activity-based costing is used. Show all calculations. Excel is preferable for this question.