I need help. I am a bit confused and it has to be on a excel spreadsheet with formulas too and I don't know much of formulas

Problem 17-1B Comparing plantwide rate method and activity-based costing 9 P1 2 P3 BuiltRite Machining reports the following budgeted overhead cost and related data for the year. Activity Budgeted Cost Activity Cost Driver Budgeted Activity Usage Assembly $500,000 Machine hours (MH) 12,500 Product design 30,000 Engineering hours (EH) 600 Factory services 20,000 Direct labor hours (DLH) 1,250 Inspection 50,000 Inspections 500 Total $600,000 Page 699 Required 1. Compute a single plantwide overhead rate assuming the company allocates overhead cost based on 12,500 machine hours. 2. Job 55 used 150 machine hours and Job 66 used 220 machine hours. Allocate overhead cost to each job using the single plantwide overhead rate from part 1. 3. Compute an activity overhead rate for each activity using activity-based costing. 17 4. Allocate overhead costs to the following jobs using activity-based costing