Please complete in Excel.

Problem Activity Based Costing Zeta company has identified the following overhead costs and cost drivers for the upcoming year Overhead Item Expected Costs Cost Driver Quantity Setup costs $45,000 Number of setups 300 Material Handling $90,000 Number of material moves 7,500 Quality Cost $150,000 Number of Inspections 6,000 900 Machining Cost $67,500 Machine Hours Total $352,500 The following information was collected on three jobs that were completed during the year Direct materials Direct labor Units completed Direct labor-hours Machine hours Number of setups Number of Inspections Job 201 $6,000 $2,800 80 18 10 1 Job 202 $12,000 $2,000 60 22 50 2 Job 203 $8,000 $4,000 150 15 10 4 20 10 30 Number of material moves 30 10 50 For the year the company budgeted direct labor cost of $100,000, budgeted direct material cost of $280,000, and estimated labor hours of 5,000. Determine the unit cost for each job using Activity Based Costing. (Round amounts to 2 decimal places.)