Financial Management - Excel Required for Answer
Faint
Week2-Ch06-CPM-Deadline-TEMPLATE.xlsm
CPM DEADLINE INPUT
| PROJECT DEADLINE = | | | | | | | IMMEDIATE | | | | | EXTRA COST | 0 | | 0 | | | | | | | | | PROCESS A | | USE SOLVER |
| | | | | | | | PREDECESSORS | | | | | | | 0 | 0 |
| ACTIVITY | NODE | NORMAL TIME | NORMAL COST | CRASH TIME | CRASH COST | | NODE | PREDECESSOR | | | | Name | CRASHED | ES | EF | VSTART | VFINISH | m | Maximum Reduction | Marginal Cost | DEADLINE |
| | | | | | | | | | | 1 | A | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 2 | B | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 3 | C | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 4 | D | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 5 | E | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 6 | F | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 7 | G | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 8 | H | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 9 | I | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 10 | J | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 11 | K | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 12 | L | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 13 | M | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 14 | N | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 15 | O | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 16 | P | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 17 | Q | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 18 | R | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 19 | S | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 20 | T | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 21 | U | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 22 | V | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 23 | W | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 24 | X | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 25 | Y | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | 26 | Z | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
| | | | | | | | | | | | | | | | | 0 | 0 |
CPM DEADLINE OUTPUT
| CRASHING ANALYSIS |
| TOTAL PROJECT COST | | | 0 | PROJECT NORMAL COST | | | 0 |
| COMPLETION TIME | | | 0 | PROJECT CRASH COST | | | 0 |
| ACTIVITY | NODE | Completion Time | Start Time | Finish Time | Amount Crashed | Cost of Crashing | Total Cost |
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|
| | | | | | | |
|