General Foundry’s project crashing data are shown in the following table. Set up and solve an LP model using Excel to crash this project into 10 weeks. How much does it cost to reduce the duration of this project from 15 to 10 weeks? EXPLAIN WHERE YOU GOT CONSTRAINTS AND USE TEMPLATE BELOW.

		Time (weeks)		Cost		Crash cost per week
Activity	Immediate Predecessors	Standard	Crash	Standard	Crash
A	-	2	1	22000	22750	750
B	-	3	1	30000	34000	2000
C	A	2	1	26000	27000	1000
D	A, B	4	3	48000	49000	1000
E	C	4	2	56000	58000	1000
F	C	3	2	30000	305000	500
G	D, E	5	2	80000	84500	1500
H	F, G	2	1	16000	19000	3000
									Using EST:
Act	Pred	Time	Cost	Cost/Pd	EST	EFT	LST	LFT	1	2	3	4	5	6	7	8	9	10	11	12
A	-
B	A
C	A
D	B, C
E	C
F	D, E
								Budget per week =
								Cumulative budget =
									Using LST:
									1	2	3	4	5	6	7	8	9	10	11	12
								A
								B
								C
								D
								E
								F
								Budget per week =
								Cumulative budget =

Answer rating: 100% (QA)

LP model us... View the full answer