Question

Calculate the fully loaded cost of labor for your project team members. (20 points) Write only the total fully loaded labor cost for each member. Don't wTite the cost for each activity in the table below Project Team Hours Needed forOverhead NameEach ActvityCharge RateHourly RateLabor Cest Total) C-10 E-10 Tommy 1.70 $20 Kellie 1.35 $15 B-10 Drew D-10 F-20 1.70 $15 Blake E-10 1.50 $25 esse 1.70 $25 Schedule for each task is as follows: Calculate the cost for each week per activity in the green boxes below (20 points) Fill in the Planned Budget and Cumulative Budget accordingly in the green boxes below (10 points).

Answer 1

calculate the fully loaded cost Of labor (FORMULA= hours needed* rate per hour* overhead rate)

project team member name hours needed rate per hour overhead rate total cost

tommy A=10 20 1.70

C=10 20 1.70

E= 10 20 1.70

TOTAL COST 1020

KELLIE A=5 15 1.35

B= 10 15 1.35   

TOTAL COST 303.75

DREW B=10 15 1.70

D=10 15 1.70

F= 20 15 1.70

TOTAL COST 1020

BLAKE C=10 25 1.50

E=10 25 1.50

F=5 25 1.50

TOTAL COST 937.5

JESSE E=5 25 1.70

F=5 25 1.70

TOTAL COST 425

ARTHURD D=10 20 1.35 270

COST OF EACH ACTIVITY PER WEEK

task week1 week2 week3 week 4 week 5 week 6

A 10*20*1.70   

5*15*1.35

B 10*15*1.35

10*15*1.70

C 10*20*1.70

10*25*1.50

D 10*15*1.35

10*20*1.35

E 10*20*1.70

10*25*1.50

5*25*1.70

F 20*15*1.70

5*25*1.50

5*25*1.70

planned budget 441.25 457.50 715 472.5 927.5 910

cummulative 3923.75

budget