F7 × ✓ fx v A B C D E F G H J K L M Activity Budget $ Actual $ Planned % Actual % BCWP BCWS ACWP SV CV SPI CPI ECAC 1 Win $ es $ 100% 100% $ 2 Order Material es $ $ 100% 100% $ 3 Mobilize $ 800 $ 1,100 100% 100% $ 1,100 4 Appoint Sub $ $ 100% 100% $ 5 Build Slab $ 3,500 $ 4,700 100% 100% $ 4,700 Build Walls $ 5,500 $ 6,100 50% 100% $ 6,100 7 Paint $ 1,800 $ 400 0% 20% $ 400 8 Roof $ 5,600 $ 1,400 0% 20% $ 1,400 9 Finish $ 800 $ 0% 0% $ - 10 Totals $ 18,000 $13,700 $ 13,700 11 CV = BCWP - ACWP 12 CPI = BCWP/ACWP SV = BCWP - BCWS SPI = BCWP/BCWS ECAC = ACWP/BCWP x BCAC

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
5th Edition
ISBN:9781305084766
Author:Saeed Moaveni
Publisher:Saeed Moaveni
Chapter14: Computational Engineering Tools Electronic Spreadsheets
Section14.4: Matrix Computation With Excel
Problem 1BYG
icon
Related questions
Question

fill out the chart below (formulas are the bottom left) using excel. show the cell formulas 

F7
× ✓ fx v
A
B
C
D
E
F
G
H
J
K
L
M
Activity
Budget $ Actual $
Planned % Actual % BCWP
BCWS
ACWP
SV
CV
SPI
CPI
ECAC
1
Win
$
es
$
100%
100%
$
2
Order Material
es
$
$
100%
100%
$
3
Mobilize
$
800 $ 1,100 100%
100%
$ 1,100
4
Appoint Sub
$
$
100%
100%
$
5
Build Slab
$ 3,500 $ 4,700 100%
100%
$ 4,700
Build Walls
$ 5,500 $ 6,100 50%
100%
$ 6,100
7
Paint
$ 1,800 $ 400 0%
20%
$
400
8
Roof
$ 5,600 $ 1,400 0%
20%
$ 1,400
9
Finish
$
800 $
0%
0%
$
-
10
Totals
$ 18,000 $13,700
$ 13,700
11
CV = BCWP - ACWP
12
CPI = BCWP/ACWP
SV = BCWP - BCWS
SPI = BCWP/BCWS
ECAC = ACWP/BCWP x BCAC
Transcribed Image Text:F7 × ✓ fx v A B C D E F G H J K L M Activity Budget $ Actual $ Planned % Actual % BCWP BCWS ACWP SV CV SPI CPI ECAC 1 Win $ es $ 100% 100% $ 2 Order Material es $ $ 100% 100% $ 3 Mobilize $ 800 $ 1,100 100% 100% $ 1,100 4 Appoint Sub $ $ 100% 100% $ 5 Build Slab $ 3,500 $ 4,700 100% 100% $ 4,700 Build Walls $ 5,500 $ 6,100 50% 100% $ 6,100 7 Paint $ 1,800 $ 400 0% 20% $ 400 8 Roof $ 5,600 $ 1,400 0% 20% $ 1,400 9 Finish $ 800 $ 0% 0% $ - 10 Totals $ 18,000 $13,700 $ 13,700 11 CV = BCWP - ACWP 12 CPI = BCWP/ACWP SV = BCWP - BCWS SPI = BCWP/BCWS ECAC = ACWP/BCWP x BCAC
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Engineering Fundamentals: An Introduction to Engi…
Engineering Fundamentals: An Introduction to Engi…
Civil Engineering
ISBN:
9781305084766
Author:
Saeed Moaveni
Publisher:
Cengage Learning