Question

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units.

Activity	Immediate Predecessor	Activity Time (wks)	Total Budgeted Cost
A	-	4	24,000
B	-	5	15,000
C	A	2	16,000
D	B	8	40,000
E	C	3	30,000
F	D, E	5	55,000
G	F	3	21,000
H	D	7	21,000
I	F	5	10,000
J	G, H	4	20,000
K	I	3	24,000
L	G, H	2	20,000

Create a Gantt chart based on earliest start times. Create a budget cost chart, using earliest start times.

Answer 1

For a GANTT CHART, start with the end time of previous activity and then select the cells equivalent to activity time. Colour them.

For budget chart, divide total activity cost with time to obtain each week cost and then add costs for each week to find total week cost.