I need help woth this problem using cell referemces & formulas

B D E G LON 8 9 Fuller Company uses ABC to account for its chrome wheel manufacturing process. Company managers have identified four manufacturing activities that incur manufacturing overhead costs: materials handling, machine setup, insertion of parts, and finishing. The budgeted activity costs for the upcoming year and their allocation 4 bases are as follows: 5 Total Budgeted Manufacturing Activity Overhead Cost Allocation Base Materials handling $12,000 Number of parts Machine setup 3,400 Number of setups Insertion of parts 48,000 Number of parts 10 Finishing 80,000 Finishing direct labor hours 11 Total $143,400 12 Fuller Company expects to produce 1,000 chrome wheels during the year. The wheels 13 are expected to use: Parts Setups Finishing Hours 14 Consumed 15 3.000 10 2,000 16 Finishing Parts Setups Hours 17 Used Required Consumed 18 Job 420 200 130 19 Job 510 425 350 20 21 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit, 22 If you copy/paste from the Instruction tab you will be marked wrong. 23 24 Requirements 25 1 Compute the cost allocation rate for each activity, 26 2 Compute the manufacturing overhead cost that should be assigned to Job 420. 27 3 Compute the manufacturing overhead cost that should be assigned to Job 510. 28 AN Step Instructions 1 1. Compute the cost allocation rate for each activity. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong.) 2 2. Compute the manufacturing overhead cost that should be assigned to Job 420. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong.) 3 3. Compute the manufacturing overhead cost that should be assigned to Job 510 (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong.)