COMPLETE EXCEL SOLUTION AND FORMULA PLEASE

Question 1 30 Points The activities in the following table describe the construction of a new house. Construct the associated project network ACTIVITY PREDECESSORS DURATION (WEEKS) ACTIVITY PREDECESSORS DURATION (WEEKS) 3 A B 2 A 1 D c 2 E 7 B,C D F 10 G F 3 H G 1 1 F 2 EH 6 K Clear site Bring utilities to site Excavate Pour foundation Outside plumbing Frame house Do electric wiring Lay floor Lay roof Inside Plumbing Shingling Outside Sheathing insulation Install windows and doors Do brick work Insulate walls and ceiling Cover walls and ceiling Insulate roof Finish interior Finish exterior Landscape 1 2 L FJ 1 M F 2 N 5 0 LM G, o 3 P 2 Q IP 1 R P 8 S UN 5 T S 3 a. Formulate the LINEAR PROGRAMMING for early times and solve it using EXCEL SOLVER. (rename sheet as LP-EST) b. Formulate the LINEAR PROGRAMMING for latest start times and solve it using EXCEL SOLVER. (rename sheet as LP-LST) C. Make a table for the summary of EST, EFT, LST, LFT and Slack. d. Determine the completion time and critical activities of the project