Use the project information contained in the attached Excel file to determine the initial:

1. Project duration & completion date

2. Critical path (CP)

3. Slack for activities not on the CP

You may use Excel or MS Project, but MS Project is the better approach. Set up the project in MS Project, using February 20, 2023 as the start date. (Check numbers: normal project duration is 73 days; normal/direct costs are $103,000. It is important to start from/use the correct starting points).

Apply schedule optimization techniques to reduce project duration to 68 days.Provide the process details for each crashing iteration: (1) activity shortened; (2) crash cost added; (3) new project duration; (4) new project cost; and (5) new critical path (this is why MS Project is the easier approach). Assume no fixed costs even though fixed cost are mentioned in the case.

Project start date 2/20/2023 Assume no holidays Activity Description Immediate Predecessor Normal Duration Activity Start story draft using template 7 A Research client firm Create "due diligence" rough draft A, B 5 Coordinate needs proposal with client C 20 Estimate future demand and cash flows C 11 Draft future plans for client company E 7 C - IOTMO Create and approve legal documents 12 Integrate all drafts into first-draft proposal D, F. G 6 Line up potential sources of capital G. F 9 Check, approve, and print final legal proposal H Sign contracts and transfer funds I,J 30 Activity Normal Cost Maximum Crash Time Crash Cost/Day $ 3,000 $ 500 5,000 1000 6,000 20,000 3,000 10,000 - N - NWONG 1,000 XC - IOTMOOOD 7,000 1,000 20,000 3,000 8,000 2,000 5,000 2,000 7,000 1,000 12,000 1,000 Total normal costs = $103,000