Financial Management - Excel Required for Answer

profileFaint
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