please show work on excel spreadsheet with calculations

Problem 3: Job Costing - Two Departments (20 points) Rhett Company has two departments, Machining and Assembly. The following estimates are for the coming year. Machining Assembly Direct manufacturing labor-hours 10,000 50,000 Machine-hours 40,000 10,000 Manufacturing overhead $400,000 $800,000 The machining department uses direct labor hours to allocate overhead while the assembly department uses machine hours. The actual data for Job # 1 is as follows: Machining 50 Assembly 20 Direct manufacturing labor-hours Machine-hours Direct Materials Cost Direct Labor Cost 10 $5,000 $2,500 $4,000 $2,000 Required Calculate the total cost of Job #1. Show all calculations and label all amounts Total Costs for Job #1 Calculations