Module 4 - Directions for Assignment: 1) In this assignment you are required to calculate the "Total Cost per Task" Given: Total Percentage of task = 100% Given: Multiple resources required with the percentage of resource required to complete task What is the "Total Cost Per Task" in Column I. Please use Vlookup function to look up cost of each Resource Multiply cost per resource from step above and multiply by % of Resource required b. c. d. e. AutoSave.OFF Module 4 Assignment Cancel Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) Paste Number C17 1 Description 2 Senior Engineer - Electric 3 Junior Engineer - Electric 4 Senior Engineer - Mechanical 5 Junior Engineer - Mechanical 6 Senior Engineer -Systems 7 Junior Engineer - System 8 Senior Engineer - MCAD 9 Junior Engineer - MCAD 10 Senior Engineer - CCAD 11 Junior Engineer - CCAD 12 Senior Assembly - MFG 13 Junior Assembly -MFG 14 15 Resource Cost Per Unit of Resource per Hour EE1 EE2 ME1 ME2 SE1 SE2 MCI MC2 CC1 CC2 MFG1$ MFG2$ 95.05 80.75 92.63 78.90 98.52 85.36 85.05 65.20 94.89 84.56 50.50 35.50