Question

Given the project network provided in the attachment, what task or tasks would you crash to reduce the project by one day? What is the cost of the project after you crash the cost by one day? What is the new duration? Please include your excel file with all calculations.

		Normal		Crash		Crash Cost Per Day
Task	Pred	Duration	Cost	Duration	Cost
a	-	5	$        500	5	$        500
b	a	10	$    2,000	8	$    2,400
c	a	5	$    1,500	3	$    4,500
d	b	15	$    1,500	14	$    2,000
e	c	30	$    4,500	25	$ 15,000
f	d, e	5	$        500	5	$        500

***Please show Excel calculation along with screenshot of formula used.

Answer 1

activity	required time		cost		time available for crashing= normal duration-crashed duration		cost of crashing per period= (crashing cost-normal cost)/periods available for crashing
	normal duration	crashed duration	normal cost	crashing cost
A	5	5	500	500	0		-
B	10	8	2,000	2,400	10-8= 2		(2400-2000)/2= $200
C	5	3	1,500	4,500	2		$1,500
D	15	14	1,500	2,000	1		$500
E	30	25	4,500	15,000	5		$2,100
F	5	5	500	500	0		-

Steps for crashing

	Steps for crashing a project
1	select the critical path and find the process with the least cost of crashing per week
2	If there are multiple critical paths, look for processes that are common, common processes may have low effective cost as common process crashes more than 1 path at once
3	you can only crash an activity depending on the time available for crashing. If an activity is only crashed that much time, choose another activity
4	add the cost of crashing later

Crashing by 1 day

		crash period 1
PATH	normal duration	crash C by 1 period
ABDF	35	35
ACEF	45	44
Cost	$10,500	$1,500

what task or tasks would you crash to reduce the project by one day:  Crash C

What is the cost of the project after you crash the cost by one day:  10500+1500= $ 12000

What is the new duration: 44 days

Please ask, if you have any doubts through the comment section. Do rate the answer