Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Use the Excel Start File to Create a network diagram Calculate paths and identify the critical path Create a table that calculates crash costs and
Use the Excel Start File to
- Create a network diagram
- Calculate paths and identify the critical path
- Create a table that calculates crash costs and adjusted total costs with headings: Activity. Norm Duration, Norm Cost, Max Crash, Slope, Crash Cost, Adj Total Costs, in that order.
- Identify the activity at each step that was crashed, number of crash steps, and total costs
Activity | Preceding Activity | Normal Duration | Normal Cost | Max Crash | Crash cost/Slope |
A | None | 2 | 150 | 1 | 100 |
B | A | 3 | 100 | 1 | 80 |
C | B | 2 | 200 | 1 | 60 |
D | B | 5 | 200 | 1 | 40 |
E | A | 5 | 200 | 2 | 40 |
F | C | 3 | 150 | 2 | 40 |
G | D | 5 | 200 | 1 | 20 |
H | E, F, G | 1 | 200 | 0 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started