ISOM 300 If the project is completed in normal duration, overhead cost is $3700 Fall 2022 BALL STATE If the project is completed in 30 days, overhead cost is $3300 UNIVERSITY If the project is completed in 26 days, overhead cost is $3100 If the project is completed at its minimum duration, overhead cost is $2900 Homework 3 Calculate total cost per duration and define which will be the optimal duration of the project. Assigned:11/18/2022 Due: 11/27/2022 Note: You can solve this problem using the attached excel template or by hand. If you solve t by hand, Deliverable: word and Excel files (pdf not accepted) make sure your handwriting and pictures are readable. Total Points: 50 PROBLEM 1 PROBLEM 2 Use the Expected Value technique to monitor and control the following project on the specified days. Task Predecessor Normal time Normal cost Crash time Crash cost (days) ($) (days) ($) Task Duration A 6 300 Budget (days) Predecessor B A 8 400 600 C A 500 620 A 3 600 D B. C 8 100 480 B 2 400 E 4 500 4 C 4 600 F B 6 400 520 D 2 A 200 G 4 500 540 4 B 800 D, E 8 60 4 840 C 500 G. H 4 400 2 800 G 3 D, E, F 1200 Consider the project shown above. With the project information create the project baseline chart. 1. Draw the network diagram, find the critical path and total duration of the project. 2. When the project was at day 2 the following data was collected . Calculate the crash cost per week per activity. b. Calculate the total normal cost of the project. 2. Crash the project to 30 days and indicate: Actual costs %Complete a. What activities were crashed and how many days each Task 2 days day b. Total cost of the project crashed to 30 days A 700 60% 3. Continue crashing the project to 26 days and indicate: B 45 100% . What activities were crashed and how many days C 400 50% b. Total cost of the project crashed to 26 days D 0 0% 4. Crash the project to its minimum duration (the fastest it can be completed) 0 . For the following paths indicate to what duration can each be crashed, and if they need to be 0% fully crashed: 0% G Path A to G 0% . Path A to H Find the cost and schedule variances. Also, find the CPI, SP.! and CR. b. Total duration of the project crashed to its minimum. b. Forecast the estimated final budget using the ETC and EAC. c. Total cost to crash the project to its minimum duration c. What can you say about the health of the project? Elaborate 5. Management gives you the following overhead (Indirect) costs: 3. When the project was at day 3 the following data was collectedActual costs %Complete Task 3 days 3days A 750 100% B 450 100% C 500 30% D 0 0% 200 20% 0 0% G 0 0% a. Find the cost and schedule variances. Also, find the CPI, SP.! and CR. b. Forecast the estimated final budget using the ETC and EAC. c. What can you say about the health of the project? Elaborate 4. When the project was at day 5 the following data was collected Actual costs % Complete Task 3 days 3days A 750 100% B 150 100% C 500 30% D 0 0% E 200 20% 0 0% G 0 0% a. Find the cost and schedule variances. Also, find the CPI, SP.! and CR. b. Forecast the estimated final budget using the ETC and EAC. c. What can you say about the health of the project? Elaborate 5. You are the project manager of a project that has 34 weeks of total duration. You are evaluating the status of your project at week 17. What does it mean to have an ETC of $38,000 and an EAC of $87,000? Note: You can solve this problem using the attached excel template or by hand. If you solve t by hand, make sure your handwriting and pictures are readable