Financial Management - Excel Required for Answer

profileFaint
Week2-Ch06-PERT-CPM-TEMPLATE.xlsx
Home>Business & Finance homework help>Management homework help>Financial Management - Excel Required for Answer

PERT INPUT

ACTIVITY TIMES IMMEDIATE 75.000000002 PROCESS A USE SOLVER
3-TIME ESTIMATE KNOWN m and s PREDECESSORS 1 18.9999999999
Activity Node a m b m s Node Predecessor Name ES EF VSTART VFINISH m s
1 A 0 0 0 0 0 0
2 B 17.0000000006 17.0000000006 0 0 0 0
3 C 8.0000000003 8.0000000003 0 0 0 0
4 D 15.0000000006 15.0000000006 0 0 0 0
5 E 8.0000000003 8.0000000003 0 0 0 0
6 F 18.9999999999 18.9999999999 0 0 0 0
7 G 8.0000000003 8.0000000003 0 0 0 0
8 H 0 0 0 0 0 0
9 I 0 0 0 0 0 0
10 J 0 0 0 0 0 0
11 K 0 0 0 0 0 0
12 L 0 0 0 0 0 0
13 M 0 0 0 0 0 0
14 N 0 0 0 0 0 0
15 O 0 0 0 0 0 0
16 P 0 0 0 0 0 0
17 Q 0 0 0 0 0 0
18 R 0 0 0 0 0 0
19 S 0 0 0 0 0 0
20 T 0 0 0 0 0 0
21 U 0 0 0 0 0 0
22 V 0 0 0 0 0 0
23 W 0 0 0 0 0 0
24 X 0 0 0 0 0 0
25 Y 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

PERT OUTPUT

CRITICAL PATH ANALYSIS 0 PROCESS B USE SOLVER
18.9999999999
MEAN
STANDARD DEVIATION* * Assumes all critical activities are on one critical path
VARIANCE* If not, enter in gold box, the variance on one critical path of interest.
PROBABILITY COMPLETE BEFORE =
Acitivty Node Critical m s s2 ES EF LS LF Slack Name Back EF Back ES ls lf sl m ACTIVITY IP START FINISH
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 1.9999999992 0 0 0
0 0 18.9999999999 18.9999999999 10.9999999996 0 0 0
0 0 18.9999999999 18.9999999999 3.9999999993 0 0 0
0 0 18.9999999999 18.9999999999 10.9999999996 0 0 0
0 0 18.9999999999 18.9999999999 0 0 0 0
0 0 18.9999999999 18.9999999999 10.9999999996 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 0 0 0
0 0 18.9999999999 18.9999999999 18.9999999999 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