Your job is to reduce the duration of the entire project from 15 to 12 weeks, incurring the minimum cost possible Time (weeks) Cost ($) Activity Crash Cost per Week($) Normal Crash Normal Crash A 2 1 22,000 22.750 750 B 3 1 30,000 34,000 2,000 C 2 1 26,000 27,000 1.000 D 4 3 48,000 49,000 1,000 E 4 2. 56,000 58,000 1,000 3 2 30,000 30,500 500 G 5 4 80,000 81,500 1.500 H 2 1 16,000 19.000 3,000 C F 0 2 2 4 4 7 o N 2 4 10 13 N 2 Start E H O O 4 8 13 15 O 8 A F 2 4 4 7 2. 2 O N 10 13 2. 2 3 3 Start E H o o 4 4 8 13 15 4 8 13 o 15 4 2 B G 3 3 7 8 4 4 00 00 3 4 5 Use this file as a starting point Project Crashing.xlsx Follow guidance from this Video Tutorial. Use the captions for better understanding. File Upload Google Doc Office 365 Studio Time (weeks) Normal Time Predecessor Activity Normal Crash 4 10 313 ES XEF ISLF 3 0122 1 1 1 3 C Cost Crash Total Cost per Crashing Normal Crash Week Cost 522,000 522,750 5750 $30.000 $34.000 52.000 $26.000 527.000 $1,000 148.000 $40.000 $1,000 556.000 58.000 51.000 $30.000 $30,500 $500 $80,000 $61.500 $1.500 $16.000 519.000 $3.000 E 2 F o AB DE F. 2 4 OSO 000 H15 131 2135 18 H . Total OB3 134 307 4148 8 G13 8 5 13