Question: PLEASE DO ALL IN EXCEL HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations. Information

PLEASE DO ALL IN EXCEL

HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations.

  1. Information on a projects activities is shown in the following table:

Activity

Immediate Predecessor

Activity Time (wks)

Total Budgeted Cost

A

-

5

25,000

B

-

4

28,000

C

B

1

16,000

D

A

10

44,000

E

C

3

36,000

F

D, E

5

50,000

G

D, E

4

80,000

H

E

7

21,000

I

F

6

36,000

J

G, H

4

60,000

K

I, J

3

30,000

L

G, H

1

20,000

  1. Create a Gantt chart based on earliest start times. (20 pts)

  1. Create a budget cost chart, using earliest start times. (20 pts)

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 General Management Questions!