Question: Module 4 - Directions for Assignment: 1) In this assignment you are required to calculate the Total Cost per Task Given: Total Percentage of task

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

PROJECT OVERVIEW Harrisburg Industries produces its product in two sequential departments: Blending and Forming. The old controller, who has just retired, has been manually preparing the production...

Henkel Industries produces its product in two sequential departments: Blending and Forming. The old controller, who has just retired, has been manually preparing the production cost reports each...

The HamilGine Piston Decision This case addresses many issues that affect insourcing/outsourcing decisions. A complex and important topic facing businesses today is whether to produce a component,...

Compagnie du Froid, S.A. Case Study Assignment Questions: 1. Calculate the amount of the bonus pool available under the existing bonus plan. How much would each manager get if that were applied to...

Responsibility Center Presentation Imagine you have been selected by your manager to present a training session to a group of new employees. The new hires do not have accounting backgrounds and have...

I only need everything that is blank or has an "X" by it answered. Thank you! ******Please ignore the first 2 pictures. They are unclear and I added better pictures above this, but couldn't get rid...

WEEK # 1 - EXERCISES Exercise 1 You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table...

Module 4 Excel Workbook Assignment MBA 6315 Background Information: Shoes for You, Inc. (from Module 2) has become a very successful company. During the year ending 2018, they completed the equity...

using following REA model to create logical model like the example that i show below Inventory Cash St. Francis Olive Oil Company HHH Request Items Order Items Receive Items Pay Vendors Return Items...

Which one is measure of software complexity ? Select one: O Number of function points (FP) Number of subsystems Number of lines of code (LOC) Number of objects

The breaking strength of plastic bags used for packaging produce is normally distributed with a mean of 35 kPa (kilopascals) and a standard deviation of 10 kPa. a. What proportion of the bags have a...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

3. Should employees be able to take as much time off work as they want?

2. What are the differences between an employee, worker and self-employed person?

understand the issues to be considered when an employee leaves an organisation.