I already included the solution for the question at the end, but I need to include the solver equation parameters (i.e objective, changing variable cells, and constraints) which the solution is missing, especially for part c. Please show formulas input in excel and the solver parameters (i.e objective, changing variable cells, and constraints). Thank you!

Good Homes Construction Company is about to begin the construction of a large new home. The company's president, Michael Dean, is currently planning the schedule for this project. Michael has identified the five major activities (labeled A, B, . . ., E) that will need to be performed according to the following project network.

Finish Start C E.Normal Time Crash Time Normal Crash Activity (Weeks) (Weeks) Cost Cost $54,000 $60,000 62,000 65,000 NONIN 66,000 70,000 40,000 43,000 75,000 80,000a) Activity ES EF LS LF Slack Critical Path Yes Start Yes A 50 0 WO No B job WAOO O V W WOO OONOHOO Yes C No D 12 F 12 12 Yes Finish 12 12 12 12 Yes Critical Path: Start -> A -> C -> E -> Finish Total duration = 12 weeks1)) Activity Crash to Crash Cost A B D Length of Path A B E Cost C $1,333 10 E $2,500 10 D & E $4,000 9 B & C $4,333 8 New Plan: Activity Duration A 3 weeks B 3 weeks C 3 weeks D 2 weeks E 2 weeks $54,000 $65,000 $68,666 $41,500 $80,000 $7,834 is saved by this crashing schedule. AC-E C) A B C D E F G H J 1 Normal Crash Maximum Time Crash Cost 2 Time Time Normal Crash Reduction per Week Start Time Finish 3 Activity (weeks) (weeks) Cost Cost (weeks) Saved Time Reduction Time 4 A 3 $54,000 $60,000 1 $6,000 0 3 5 B $62,000 $65,000 1 $3,000 4.000000002 8 6 N - NWN $66,000 $70,000 8 AW OTA $1,333 oooo 7 MOO $40,000 $43,000 2 $ 1,500 12 8 $75,000 $80,000 2 $2,500 12 9 10 Max Time 11 Project Completion Time (weeks) 12