Name:
Click the image below to add data to the spreadsheet. Save this page as a .pdf file and submit
to Blackboard. Do not change cell sizes - don’t type beyond the space provided (be brief).
Include the formulas (how you obtained your answer) as shown in the example on page 1 (1
point per cell).
Be sure to follow correct file naming formats (e.g. tbarry-A7.pdf – points deducted for incorrect
file names).
Submit only this page for A7! (5 points deducted for including page 1)
Email submissions to the professor will NOT be accepted under ANY
circumstances.
All Dollar values and Percentage calculations – 2 decimal places
What Is? Formula Calculation
With Numbers Answer Interpretation of the Answer
1 BAC
$7,000 x 5 (for the five
walls) =
$35,000 This is our total budget
2Planned %
Complete
Given amount/Total
amount
4 days / 5 days =
80% After end of day 4 out of 5 days, this
leaves us of 80% planned completion
3 PV
BAC x Planned % Complete
$35,000 x 80% =
$28,000 This is the value of the project so far
4Actual %
Complete
All five days’ completion %
.20+.20+.14+.116+.07 =
72.60% This is the Actual Completion
percentage
5 EV
BAC x Actual Complete %
$35,000 x 72.60%
$25,410 The planned amount is $28,000, and we
are at $25, 410. We are behind
schedule.
6 SPI
EV/PV = SPI
$25,410/$28,000 =
90.75 90.75< 1 means we are behind schedule
7 SV
EV-PV=SV
$25,410 - $28,000=
-$2,590 We are behind $2,590
8 AC
Total five wall cost so far
$6,910+$7,530+$4,820+
$4,200+$2,450=
$25,910 Money spent so far
9 CPI
EV/AC = PI
$25,410/$25,910=
97.02 97.02<1; The sponsor is not getting
money’s worth
1
0CV
EV-AC= CV
$25,410- $25,910=
-$500 Negative variance; over budget by $500
