Bowman Builders manufactures steel storage sheds for commercial use. Joe Bowman, president of Bowman Builders, is contemplating producing sheds for home use. The activities necessary to build an experimental model and related data are given in the following table. The project completion time using standard times is 14 weeks. Setup and solve an LP model using Excel to crash this project to 10 weeks. How much does it cost to reduce the duration of this project from 14 to 10 weeks?

Activity	Immediate Predecessors	Standard Time (WKS)	Standard Cost	Crash Time (WKS)	Crash Cost
A	-	3	$1000	2	$1600
B	-	2	$2000	1	$2700
C	-	1	$300	1	$300
D	A	7	$1300	3	$1600
E	B	6	$850	3	$1000
F	C	2	$4000	1	$5000
G	D, E	4	$1500	2	$2000

PLEASE USE TEMPLATE ABOVE OR I WILL DISLIKE

TO TE TE CA CE CF TA Start A TE Start B Tc Start TG Start G Tend Start End Crash G Start D Start E Start F Crash A Crash B Crash C Crash D Crash E Crash F Solution value Crash Cost Constraints A-->D B -->E C -> F D-->G E->G F --> End G --> End Crash limit A Crash limit B Crash limit C Crash limit D Crash limit E Crash limit F Crash limit Project finish LHS Sign RHS Crash project to (weeks)