Question: Help me put this information into a Microsoft Excel template or Ms. Project Network Digmand how to find the critical math of the pralend comes



Help me put this information into a Microsoft Excel template or Ms. Project
Network Digmand how to find the critical math of the pralend comes with the overall protectie Palect Example Task Task! Task 2 Tak3 Task + Tasks End Preceding Tank Start Task 1 Task 1 Taak 2 Task 3,4 Duration 3 Weeks J Weeks 6 Weeks 8 Weeks 4 Weeks Task I can start immediately & has an estimated duration of 3 weeks Task 2 can start after task 1 is completed & is 3 weeks in duration Task 3 can start after task 1 is completed & is 6 weeks in duration Task 4 can start after task 2 s 8 weeks in duration Task 5 can start after task 3 & 4 are completed & s4 weeks in duration Tack F Tak End Start Task Critical Path (CP): . . CP-is the longest path through the diagram CP-will determine the total time to finish the project CP-will identify what tasks are on the CP & cannot be delayed without delaying the entire project . Analysis or the diagram Stanto the path through the diam. Path 1: Task 1, T2, T4, & TS-18 weeks Path 2: Tak I, TI, T5 -13 Weeks In this example Path 1 is the longest path and is the Critical Path of the project. It will take 18 weeks to complete this project Step two is to find the Stack (AKA Float)-This is the amount of time a Task can be delayed without delaying the project. Note-A fask on the CP has a stack Stack is found by using the formule IS-ES Latest Start - Earliest Start Al Tasks have an LS, ES, LF & EF ES IS LF The early figures (ES & EF) are found by doing a forward pass through the diagram. The late figures (1 S & LF) are found by doing a backward pass through the diagram. . Question: What is the SLACK of Task 3? Formula: LS-ES LS-18weeks-4weeks-weeks-8w ES-3weeks Slack-LS-ES-w-www Answer: Task 3 has a noat of weeks. This means we can actually starts week late and still complete the project on time. Question What is the SLACK of Task 2? Formula: LS-ES LS-18w-4w8w3w3weeks ES-3wecks LS-ES-3w-Jw weeks Answer: Task 2 has zero stack, it cannot be delayed without delaying the project. Note: task 2 is on the CP and all tasks on the CP have vero slack. Question: What would happen if task 3 is now 10weeks in duration. What will it do to the overall project time line? Answer: It will have NO Effect on the overall project timeline. TI, T3 & T5 was to take 13 weeks adding 4 more weeks to task 3 will make it 17 weeks, which is still shorter than the CP which is 18 weeksStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
