Financial Management - Excel Required for Answer

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

PERT-COST INPUT

CURRENT DATE = IMMEDIATE 0 PROCESS A USE SOLVER
PREDECESSORS 0 0
WORK PACKAGE NODE BUDGETED TIME BUDGETED COST PERCENT COMPLETE COST TO DATE NODE PREDECESSOR Name Marginal Cost ES EF VSTART VFINISH m
1 A 0 0 0 0 0 0
2 B 0 0 0 0 0 0
3 C 0 0 0 0 0 0
4 D 0 0 0 0 0 0
5 E 0 0 0 0 0 0
6 F 0 0 0 0 0 0
7 G 0 0 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-COST OUTPUT

PERT/COST ANALYSIS OBJ FCTN 0 PROCESS B USE SOLVER
DATE OF ANALYSIS 0 TOTAL PROJECT BUDGET 0 PRJ TIME 0
EXPECTED COMPLETION TIME 0 COST OF WORK TO DATE 0 Activity Pred PROJ ACT ES EF V ST VFIN TIME
EXPECTED REMAINING TIME VALUE OF WORK TO DATE 0 A 0 0 0 0 0
EXPECTED PROJECT DELAY COST OVERRUN 0 B 0 0 0 0 0
C 0 0 0 0 0
BUDGETED VALUES TO DATE VALUES ANALYSIS TO DATE D 0 0 0 0 0
WORK PACKAGE NODE TOTAL TIME TOTAL COST PERCENT COMPLETE VALUE TO DATE COST TO DATE COST OVERRUN TIME REMAINING E 0 0 0 0 0
F 0 0 0 0 0
G 0 0 0 0 0
H 0 0 0 0 0
I 0 0 0 0 0
J 0 0 0 0 0
K 0 0 0 0 0
L 0 0 0 0 0
M 0 0 0 0 0
N 0 0 0 0 0
O 0 0 0 0 0
P 0 0 0 0 0
Q 0 0 0 0 0
R 0 0 0 0 0
S 0 0 0 0 0
T 0 0 0 0 0
U 0 0 0 0 0
V 0 0 0 0 0
W 0 0 0 0 0
X 0 0 0 0 0
Y 0 0 0 0 0
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