Microsoft Project 2013 Practical Exercises
Microsof Project Praccal Exercises
Contents Microsof Project 2013..........................................................................................................................1 Praccal Exercises..................................................................................................................................1 Praccal 1..............................................................................................................................................4 Introducon to Microsof Project......................................................................................................4 Creang a New Project ile................................................................................................................! Create a "lan# Project....................................................................................................................! Enter Project In$or%aon & c'ange t'e start date.........................................................................! Enter Project Pro(eres & c'ange t'e tle and aut'or.................................................................! Enter 'olida) in$or%aon..............................................................................................................* Enter t'e +,-..............................................................................................................................10 dd t'e nu%erical codes $or t'e +,-.........................................................................................13 dding t'e Project /itle as a Project -u%%ar) /as#........................................................................1 -aing Project iles..........................................................................................................................1 Praccal 2............................................................................................................................................1! dding duraon and (redecessorsuccessor relaons'i(s.............................................................1! dding duraons.........................................................................................................................1! dding (redecessorsuccessor relaons'i(s...............................................................................1* ow sc'eduling wor#s in Project 2010 and Project 2013............................................................22 Inserng ags...............................................................................................................................23 dding a %ilestone..........................................................................................................................2! Modi$)ing t'e %escale..................................................................................................................2* 5is(la)ing t'e crical (at'...............................................................................................................2* ssessing t'e sensiit) o$ )our sc'edule.......................................................................................30 6iewing t'e networ# diagra%..........................................................................................................31 Page 2 o$ 64
Microsof Project Praccal Exercises
Praccal 3............................................................................................................................................33 dding 7esources............................................................................................................................33 Create t'e resource (ool.............................................................................................................33 ssigning resources.....................................................................................................................34 djusng 7esource llocaon.........................................................................................................40 Iden8caon o$ resource oer9allocaon....................................................................................40 5ealing wit' oer9allocaon issues..............................................................................................42 6iewing t'e "udget details..............................................................................................................4: 6iew t'e total cost.......................................................................................................................4: Praccal 4............................................................................................................................................4* Co%(aring actual (rogress wit' (lanned (rogress..........................................................................4* -aing t'e "aseline......................................................................................................................4* 6iewing t'e /rac#ing ;an< C'art................................................................................................4= Inserng a status re(ort date......................................................................................................0 -e>ng ?(ons ,e$ore @(dang /as# -tatus...............................................................................2 In$or%aon a"out actual (rogress.............................................................................................. Entering -o%e actual -tatus In$or%aon....................................................................................: 6iewing earned alue..................................................................................................................:0 6iewing t'e start and 8nis' ariances.........................................................................................:3 6iewing t'e CPI............................................................................................................................:4 6iewing t'e -PI............................................................................................................................:
Page 3 o$ 64
Microsof Project Praccal Exercises
Practical 1 Introduction to Microsoft Project
Microsof Project is a sofware (rogra% designed to assist (roject %anagers. It is a (ower$ul tool wit' %an) o(ons and $eatures to 'el( a (roject %anager to deelo( sc'edulesA trac# (roject (rogressA %anage resource assign%entA (roduce re(orts etc. /'ese (raccals are onl) an introducon to Microsof Project to gie )ou an a((reciaon o$ so%e o$ t'e $eatures )ou can ex(ect $ro% (roject %anage%ent sofware. oweerA i$ )ou (lan to use a tool li#e Microsof Project in t'e wor#(lace )ou s'ould stud) t'e ca(a"ilies o$ t'e sofware in %ore de(t' so t'at )ou are aware o$ t'e arious o(ons aaila"le to )ou Band 'ae an understanding o$ t'e su"tlees associated wit' so%e o$ t'ose o(ons. I$ )ou wis' to learn %ore a"out Microsof Project 2013A t'ere are excellent "oo#s aaila"le on t'e %ar#et Be.g. DMicrosof Project 2013 t'e %issing %anual ") ,onnie ,ia$ore as well as ideos and tutorials t'at can "e $ound online.
I$ )ou 'ae not done so alread)A create a $older $or t'e course )ou are stud)ing Be.g. PPMP2000! and t'en create a su"$older wit'in t'is course $older called ProjectPraccals. Fou will sae t'e wor# t'at )ou do in (raccal 1 in t'e ProjectPraccals $older in a 8le called (raccal1.
?(en Microsof Project.
-elect D"lan# Project
Page 4 o$ 64
Microsof Project Praccal Exercises
Microsof Project o(ens wit' a ;an< C'art iew. In t'e 8rst window on t'e lef 'and side )ou will see t'e tas# and duraon colu%ns. I$ necessar)A ex(and t'is window Busing t'e Ds(lit "ar to iew t'e startA 8nis'A (redecessor and resource colu%ns.
/'e window on t'e rig't 'and side is a calendar t'at will dis(la) a ;an< c'art iew o$ )our (roject. long t'e to( )ou will see t'e o(ons aaila"le on t'e Dri""on $or t'e tas# Dta". Fou will also see arious ot'er ta"s 9 8leA resourceA (rojectA iew and $or%at.
Ex(lore t'e arious o(ons Be.g. i$ )ou clic# on t'e ile ta" )ou will see NewA -aeA PrintA el( o(ons etc..
Page 5 o$ 64
Microsof Project Praccal Exercises
Clic# on t'e 6iew ta" and iew t'e dro( down o(ons under D;an< c'art. ?"sere t'at t'e ;an< c'art o(on 'as "een selected.
Note t'at t'ere are arious o(ons i$ )ou clic# on t'e down arrow on t'e ;an< c'art and note t'at t'ere are %ore iews aaila"le. +'en )ou 'ae deelo(ed )our 8rst sc'edule Bat t'e end o$ (raccal 2A )ou can tr) out so%e o$ t'e alternae iews Be.g. networ# diagra%.
oer oer an icon or o(on in t'e ri""on. Fou s'ould see a (o(9u( window telling )ou t'e $uncon o$ t'e icon. Be.g. i$ )ou 'oer oer t'e Networ# 5iagra% o(on t'e (o(9u( window will ex(lain t'e (ur(ose o$ t'e Networ# 5iagra% iew 9 Ddis(la) tas#s re(resented as "oxes G..
Fou will get t'e o((ortunit) to iew )our sc'edule using t'e Networ# 5iagra% iew in (raccal 2. s )ou can see Microsof Project (roides )ou wit' a large nu%"er o$ o(ons and $uncons. /'ese la" exercises will introduce t'e "asic ste(s to allow )ou to deelo( a sc'eduleA add resource in$or%aon and trac# t'e (rogress o$ a (roject. Fou %a) li#e to s(end so%e %e "eco%ing $a%iliar wit' t'e arious ri""ons and o(ons aaila"le "e$ore connuing wit' t'e (raccals. Note t'at o(ons on t'e /ea% ri""on are "e)ond t'e sco(e o$ t'is course.
Page 6 o$ 64
Microsof Project Praccal Exercises
Creating a New Project File Create a blank Project
Fou created a "lan# (roject w'en )ou clic#ed on D"lan# (roject at t'e "eginning o$ t'is (raccal.
Enter Project Information – change the start date
Clic# t'e Project ta" and select Project In$or%aon. /'e Project In$or%aon dialog "ox will now "e dis(la)ed. /'is allows )ou to set dates $or t'e (rojectA select t'e calendar to use etc. /'e start date will "e set to toda)Hs date ") de$ault.
-et t'e start date to Monda) o$ next wee#. Fou ac'iee t'is ") selecng t'e date in t'e calendar and t'en clic#ing ?. /'e Project In$or%aon dialog "ox will now disa((ear. BNote t'at t'e screen s'ots s'own in t'is docu%ent will 'ae diJerent dates to )our exercises. /'e screens'ots in t'is docu%ent were created in 201 and are onl) re(resentae o$ w'at )ou s'ould see.
Enter Project Properties – change the title and athor
Clic# t'e ile ta" and select In$o to iew t'e (roject in$or%aon on t'e rig't9'and side.
Page 7 o$ 64
Microsof Project Praccal Exercises
Clic# on t'e DProject In$or%aon dro( down "ox on t'e rig't9'and side Ba"oe t'e in$or%aon a"out t'e start date etc.
-elect Ddanced Pro(eres.
/)(e New Billing System in t'e /itle text "ox and t)(e )our na%e in t'e ut'or text "oxA t'en clic# ?.
Clic# on t'e D"ac#9arrow s)%"ol to return to t'e nor%al iew o$ t'e (roject.
Enter holida! information
Clic# t'e Project ta" Bi$ it is not alread) selected and select Dc'ange wor#ing %e $ro% t'e Pro(eres grou(.
Fou will see t'e Dc'ange wor#ing %e window a((ear. /'e standard calendar BProject calendar is t'e de$ault. Note t'at it assu%es a da) wor#ing wee# wit' * 'our da)s and -aturda) and -unda) as t'e non9wor#ing da)s o$ t'e wee#. /o enter addional 'olida)s etc.A )ou %ust enter and na%e t'e exce(ons in t'e exce(ons ta" o$ t'e ta"le at t'e "o
Microsof Project Praccal Exercises
Enter t'e 2 wee#s o$ K%as 'olida) in$or%aon in t'e ta"le. Call t'e exce(on DK%as acaon. acaon. I$ )ou clic# on t'e dro( down "ox in t'e start colu%nA )ou will "e a"le to to use t'e calendar t'at a((ears to select t'e start date. Fou can set t'e 8nis' date in a si%ilar wa).
Four dialog "ox s'ould a((ear si%ilar to t'e screen "elowA "elowA alt'oug' t'e )ear %a) "e diJerent diJerent de(ending on w'en )ou co%(lete t'ese (raccals.
Page ! o$ 64
Microsof Project Praccal Exercises
Enter the "#$ ssu%e t'at )ou 'ae alread) wor#ed out )our wor# "rea#down "rea#down structureA resourcesA %e es%ates and (redecessorsuccessor relaons'i(s $or our exa%(le (roject.
Clic# on t'e D/as# ta".
Enter t'e $ollowing in$or%aon in t'e D/as# Na%e colu%n. 7eLuire%ents nal)sis In$or%aon gat'ering 5e8ne 7eLuire%ents 7eLuire%ents 5is# -torage @(grade Purc'ase Install -ofware Modi8caons 5ata"ase C'anges 5esign 5, C'anges Modi$) 5, Progra%s 5esign Progra%s Progra% Code (rogra% @nit test Progra% , Code (rogra% , @nit test , Progra% C Code (rogra% C @nit test C Progra% 5
Page "# o$ 64
Microsof Project Praccal Exercises
Code (rogra% 5 @nit test 5 Progra% 71 Code (rogra% 71 @nit test 71 Integraon Integrate /est dersing ,roc'ure 5esign Print Mail ?ut
/o delete a tas# clic# on t'e tas#A rig't 9clic# t'e %ouse and select Ddelete tas# $ro% t'e %enu. /r) t'is now wit' t'e Modi$) 5, tas#.
/o re9 insert t'e Modi$) 5, tas#A clic# on t'e DProgra%s entr) t'at was "elow t'e %odi$) 5, tas# t'at )ou just deleted. 7ig't9clic# t'e %ouse and select insert tas#. new "lan# tas# s'ould now "e aaila"le $or )ou to enter t'e Modi$) ,5 tas#. Enter t'e Modi$) 5, tas#. BNote t'at )ou could 'ae used t'e undo arrow to get t'e %odi$) d" tas# re9inserted. /'ere are undo and redo arrows aaila"le at t'e to( o$ t'e Microsof Project window i$ )ou %a#e an error.
@se )our %ouse to select t'e two tas#s "elow t'e 7eLuire%ents nal)sis entr) and t'en clic# on t'e Dindent Bgreen arrow (oinng to t'e rig't icon in t'e sc'edule grou( on t'e $as% ri""on.
Page "" o$ 64
Microsof Project Praccal Exercises
7e(eat t'is (rocedure to ac'iee t'e $ollowing (roject +,- structure &e'(irements )nalysis
In$or%aon gat'ering 5e8ne 7eLuire%ents *is% Storage +,gra-e
Purc'ase Install Sofware Mo-i.caons *ata/ase 01anges
5esign 5, C'anges Modi$) 5, Programs
5esign Progra%s Program )
Code (rogra% @nit test Program B
Code (rogra% , @nit test , Program 0
Code (rogra% C @nit test C Program *
Code (rogra% 5 @nit test 5 Program &"
Code (rogra% 71 @nit test 71 ntegraon
Integrate /est )-ersing Broc1(re
5esign Print Mail ?ut Noce t'at t'e entries wit' su"tas#s are in "old. /'is indicates t'at t'e) are su%%ar) tas#s. /'eir s)%"ol on t'e ;an< c'art also a((ears as a "lac# line. /'e su%%ar) tas#s also 'ae a Dcolla(se s)%"ol B9 on t'eir lef 'and side.
Clic# on one o$ t'e colla(se s)%"ols and o"sere 'ow t'is 'ides t'e su"tas#s "eneat' it. +'en su"tas#s are 'iddenA an Dex(and s)%"ol B a((ears to t'e lef o$ t'e su%%ar) tas# na%e. Clic# on t'e ex(and s)%"ol and noce 'ow it ex(ands t'e su%%ar) tas#.
Page "2 o$ 64
Microsof Project Praccal Exercises
%dd the nmerical codes for the "#$&
-elect t'e D?utline Nu%"ers c'ec# "ox on t'e ri""on o$ t'e or%at ta". Fou s'ould now see t'e nu%erical codes on )our +,-. I$ )ou 'ae indented t'e 'ierarc'ical structure correctl)A )ou s'ould see t'e $ollowing result. $as% N(m/er
BS
$as% names
N(m/er "
"
&e'(irements )nalysis
2
1.1
In$or%aon gat'ering
3
1.2
5e8ne 7eLuire%ents
4
2
*is% Storage +,gra-e
2.1
Purc'ase
:
2.2
Install
7
3
Sofware Mo-i.caons
*
3"
*ata/ase
=
3.1.1
5esign 5, C'anges
10
3.1.2
Modi$) 5,
""
32
Programs
"2
3.2.1
5esign Progra%s
"3
322
Program )
14
3.2.2.1
Code (rogra%
1
3.2.2.2
@nit test
"6
323
Program B
1!
3.2.3.1
Code (rogra% ,
1*
3.2.3.2
@nit test ,
"!
324
Program 0
20
3.2.4.1
Code (rogra% C
21
3.2.4.2
@nit test C
Page "3 o$ 64
Microsof Project Praccal Exercises
22
325
Program *
23
3.2..1
Code (rogra% 5
24
3.2..2
@nit test 5
25
326
Program &"
2:
3.2.:.1
Code (rogra% 71
2!
3.2.:.2
@nit test 71
2
4
ntegraon
2=
4.1
Integrate
30
4.2
Integraon tesng
3"
5
)-ersing Broc1(res
32
.1
5esign
33
.2
(rint
34
.3
Mail out
Note t'at an alternae is to create a se(arate +,- colu%n. I$ )ou scroll t'roug' t'e list o$
aaila"le colu%ns in t'e colu%n wit' t'e 'eading Ddd a New Colu%n w'ic' s'ould a((ear afer t'e D7esource Na%es colu%nA )ou will 8nd t'e +,- o(on. Colu%ns can "e rearrangedA so t'is could "e (osioned "e$ore t'e D/as# Na%e colu%n i$ reLuired. )-- t1e BS col(mn now an- ,osion it /eore t1e tas% name col(mn8
/'e tas# %ode is %anuall) sc'eduled ") de$ault. +e will see t'e diJerence "etween %anual and auto%ac sc'eduling later in t'e (raccalsA so $or now we will leae t'e tas# %odes as %anuall) sc'eduled. I$ )ou cannot alread) iew a Dtas# %ode colu%n add t'e Dtas# %ode colu%n to allow )ou to iew w'et'er tas#s are auto%acall) or %anuall) sc'eduled. Posion it just "e$ore t'e +,- colu%n. /'e to( o$ )our (roject s'ould now a((ear si%ilar to t'e $ollowing screens'ot.
Page "4 o$ 64
Microsof Project Praccal Exercises
Adding the Project Title as a Project Summary Task
Clic# t'e or%at ri""on and select t'e DProject su%%ar) /as# c# "ox.
/'e 8le tle s'ould now a((ear as nu%"er 0 at t'e to( o$ t'e tas# list B+,- 0 and t'e su%%ar) tas# s'ould dis(la) t'e total duraon o$ t'e (roject Bw'ic' is onl) one at t'is stage as we 'ae not entered tas# duraons or (redecessor in$or%aon.
/'e to( o$ )our (roject s'ould now a((ear si%ilar to t'e $ollowing screens'ot.
Saving Project Files
Microsof Project 8les can "e saed wit' or wit'out a "aseline. /'e "aseline allows )ou to trac# (er$or%ance. oweerA as we are sll deelo(ing our (roject 8leA we are not )et read) to sae wit' a "aseline. /'e de$ault is to sae t'e 8le wit'out a "aseline. -ae )our 8le Bwit'out a "aseline ") selecng D-ae s $ro% t'e ile %enu and saing )our 8le as (raccal1 in t'e $older )ou created earlier called ProjectPraccals. 5ou"le clic# on t'e Dco%(uter o(on to "rowse to t'e ProjectPraccals $older to sae )our 8le. BNote t'at one o$ t'e ot'er o(ons suc' as a Drecent $older %a) "e a((ro(riate in $uture.
Page "5 o$ 64
Microsof Project Praccal Exercises
Page "6 o$ 64
Microsof Project Praccal Exercises
Practical 2 Adding duration and redecessor!successor relationshis %dding drations
?(en (raccal1.%(( 8le and sae to a 8le called (raccal2.%((. Fou now 'ae a co() o$ )our wor# to use in (raccal2.%((. Fou will use (raccal2.%(( as t'e starng (oint $or t'is wee#Hs (raccal.
I$ it is not alread) o(enA o(en (raccal2.%(( ") dou"le clic#ing on t'e 8le.
Enter t'e tas# duraons gien in t'e ta"le "elow. Note t'at t'e duraons are onl) entered $or s(eci8c tas#s and not $or deliera"lessu%%ar) tas#s. Fou will noce t'at as )ou enter duraons $or t'e s(eci8c tas#sA Microsof Project auto%acall) calculates t'e totals $or t'e su%%ar) tas#s. /'e units we are using are wee#sA "ut duraons can "e %ont'sA da)s or een %inutes. $as% names
*(raons
New Billing System &e'(irements )nalysis
In$or%aon gat'ering
3 wee#s
5e8ne 7eLuire%ents
3 wee#s
*is% Storage +,gra-e
Purc'ase
11 da)s
Install
3 da)s
Sofware Mo-i.caons *ata/ase
5esign 5, C'anges
2 wee#s
Modi$) 5,
1 wee#
Programs
5esign Progra%s
3 wee#s
Program )
Code (rogra%
2 wee#s
@nit test
1 wee# Page "7 o$ 64
Microsof Project Praccal Exercises
Program B
Code (rogra% ,
4 wee#s
@nit test ,
2 wee#s
Program 0
Code (rogra% C
3 wee#s
@nit test C
2 wee#s
Program *
Code (rogra% 5
3 wee#s
@nit test 5
2 wee#s
Program &"
Code (rogra% 71
2 wee#s
@nit test 71
1 wee#
ntegraon
Integrate
2 wee#s
test
1 wee#
)-ersing Broc1(res
5esign
2 wee#s
(rint
1 da)
Mail out
1 da)
%dding predecessor'sccessor relationships
-croll out t'e lef 'and window Bwit' t'e tas# na%eA duraon etc colu%ns unl )ou can see t'e (redecessor colu%n.
/'ere are arious o(ons $or entering t'e (redecessor relaons'i(s. +e will enter t'e% ") adding t'e (redecessor tas# nu%"er into t'e (redecessor colu%n. B/'e Dlin# icon in t'e sc'edule grou( on t'e /as# ri""on is anot'er o(on )ou %ig't li#e to ex(eri%ent wit' in t'e la". It is (ossi"le t'at a tas# 'as %ore t'an one (redecessor. In t'at case enter t'e list o$ (redecessor tas# nu%"ers se(arated ") co%%as Be.g. 3A!A=. Enter t'e (redecessor relaons'i(s s'own in t'e ta"le "elow $as% N(m/er
BS N(m/er
Page " o$ 64
$as% names
Pre-ecessor 9tas% n(m/ers:
Microsof Project Praccal Exercises
#
#
New Billing System
"
"
&e'(irements )nalysis
2
1.1
In$or%aon gat'ering
3
1.2
5e8ne
2
7eLuire%ents 4
2
*is% Storage +,gra-e
2.1
Purc'ase
3
:
2.2
Install
7
3
Sofware Mo-i.caons
*
3"
*ata/ase
=
3.1.1
5esign 5, C'anges
3
10
3.1.2
Modi$) 5,
=
""
32
Programs
"2
3.2.1
5esign Progra%s
"3
322
Program )
14
3.2.1.1
Code (rogra%
12
1
3.2.1.2
@nit test
14
"6
323
Program B
1!
3.2.3.1
Code (rogra% ,
12
1*
3.2.3.2
@nit test ,
1!
"!
324
Program 0
20
3.2.4.1
Code (rogra% C
12
21
3.2.4.2
@nit test C
20
22
325
Program *
23
3.2..1
Code (rogra% 5
12
24
3.2..2
@nit test 5
23
Page "! o$ 64
3
Microsof Project Praccal Exercises
25
326
Program &"
2:
3.2.:.1
Code (rogra% 71
12
2!
3.2.:.2
@nit test 71
2:
2
4
ntegraon
2=
4.1
Integrate
:A 10A 1A 1*A 21A24A2!
30
4.2
/est BIntegraon
2=
tesng 3"
5
)-ersing Broc1(res
32
.1
5esign
3
33
.2
(rint
32
334
.3
Mail out
33
Note t'at
/'e (redecessorBs s'ould "e t'e lowest leel in )our +,-A i.e. a (redecessor tas# s'ould not "e a Ds(mmary tas%8 . ;o( can incl(-e a BS ,re-ecessor8 col(mn . I$ )ou scroll t'roug' t'e list o$ aaila"le
colu%ns in t'e colu%n wit' t'e 'eading Ddd a New Colu%n w'ic' s'ould a((ear afer t'e D7esource Na%es colu%nA )ou will 8nd t'e +,- Predecessors colu%n. Colu%ns can "e rearrangedA so t'is could "e (osioned afer t'e D/as# Na%e colu%n i$ reLuired. $1is col(mn may /e (se(l to c1ec% yo(r sc1e-(le i t1e ,re-ecessor inormaon was ,roi-ein terms o BS n(m/ers
It is alwa)s a good idea to sae )our wor# regularl). Fou can use t'e BCtrl- s'ortcut or t'e sae icon at t'e to( o$ Microsof Project to sae )our wor# Bsee screens'ot "elow. -ae t'e current ersion o$ )our wor# "e$ore )ou connue.
Page 2# o$ 64
Microsof Project Praccal Exercises
?"sere t'e c'anges in t'e ;an< c'art. It %a) "e diOcult to iew t'e enre (roject at t'is (oint. ?ne o(on is to use t'e scroll "ar at t'e side and "o
Page 2" o$ 64
Microsof Project Praccal Exercises
(o) schedling )orks in Project 2010 and Project 2013 /'e $ollowing notes are extracted $ro% Microsof Project Del(. “Project 2010 introduces a new mode that gives users complete control over how tasks are scheduled — manual scheduling. Project can schedule tasks using two methods: manual scheduling and automatic scheduling. With manual scheduling, changes to actors such as task dependencies, constraints, and project calendars do not automaticall! adjust task dates. "asks are manually scheduled #! default. Project managers who are accustomed to automatic scheduling with past versions o Project can turn the manual scheduling eature o or speciic tasks or or the entire project. $ome projects, especiall! complicated ones, ma! re%uire Project&s powerul scheduling engine to take care o scheduling or !ou. “ '(icrosot )elp, 2010* Note: we will only use automatic scheduling for our project schedules in this course. "he dierence #etween the #ehaviour o automaticall! and manuall! scheduled tasks is demonstrated in the ne+t section where we also learn a#out inserting lags.
Fou will c'ange to auto%ac sc'eduling in t'e next secon. /'e details o$ 'ow Microsof Project sc'edules tas#s can "e Luite co%(licated and de(ends on w'et'er t'e tas# is auto%acall) or %anuall) sc'eduledA t'e lin# t)(esA an) tas# constraints etc. or a co%(re'ensie descri(on o$ t'is to(ic )ou s'ould read Microsof Project Del( on Dow sc'eduling wor#s in Project. /o Luote Microsof Project 'el( D This stuf isn’t necessarily easy to understand at rst, but charging orward through it will make you a more knowledgeable project manager - and give you rmer control over the end date o your project . . /o access Microsof Project 'el(A clic# on t'e DQ 'el( icon.
Enter Dow (roject sc'edules tas#s in t'e searc' text "ox and clic# on t'e lin# to Dow Project sc'edules tas#s t'at a((ears as a result o$ t'e searc'.
Page 22 o$ 64
Microsof Project Praccal Exercises
Inserting *ags +e 'ae currentl) allowed 11 da)s $or (urc'asing o$ t'e 'ardware. oweerA actuall) (lacing t'e (urc'ase order is li#el) to ta#e 1 da). /'e re%ainder o$ t'e %e was to allow $or s'i(%ent and delier). +e could add anot'er tas# t'at is Ddelier) to %a#e t'is clearer or we could introduce a lag %e "etween t'e (urc'ase and t'e installaon to allow $or t'e delier) %e. +e will introduce a lag %e now.
C'ange t'e duraon $or t'e (urc'ase o$ t'e dis# storage u(grade to 1 da).
Noce t'at w'en )ou reduce t'e %e $or t'e (urc'aseA t'e installaon is sll sc1e-(le- to /e in "# -ays afer t1e ,(rc1ase. /'is is "ecause we are sll using t'e de$ault sc'eduling
w'ic' is to %anuall) sc'edule tas#s.
Page 23 o$ 64
Microsof Project Praccal Exercises
'as "eco%e
C'ange all t'e tas#s to use auto%ac sc'eduling ") using )our %ouse to select B'ig'lig't all t'e tas#sA $ollowed ") clic#ing on Duto -c'edule in t'e tas#s grou( on t'e /as# ri""on.
Note t'at t'e dis# storage u(grade now onl) ta#es 4 da)s and t'e installaon is started i%%ediatel) afer (urc'ase. /'is 'as "een sc'eduled auto%acall) according to its (redecessor relaons'i(.
oweerA re%e%"er t'at we do want to introduce a lag %e $or t'e delier) o$ t'e new 'ardware. +e will do t'at now.
5ou"le clic# on t'e Dinstall dis# storage tas# and select t'e (redecessors ta" in t'e (o(9u( Dtas# in$or%aon window t'at a((ears.
Clic# on t'e inis'9to9-tartB- relaons'i( in t'e /)(e colu%n and noce t'at t'ere is a dro(down list associated wit' t'e t)(e cells.
?(en t'e dro( down list and o"sere t'e diJerent t)(es o$ (redecessor relaons'i(s. +'at are t'e)Q
+'at do t'e diJerent t)(es o$ relaons'i(s %eanQ @se$ul @7 '<("logs.%sdn.co%"(rojectarc'ie200*0!2="ac#9to9"asics9 understanding9tas#9de(endencies.as(x Page 24 o$ 64
Microsof Project Praccal Exercises
B@se t'e Microsof el( $uncon to read a"out t'e diJerent t)(es o$ (redecessor relaons'i(s i$ )ou 'ae not read a"out t'e% alread). int -earc' $or D(redecessor and clic# on t'e D"out in#ing /as#s lin#.
/'e lin# "etween t'e (urc'ase and install tas#s $or t'e dis# storage u(grade is a inis'9to9 -tart relaons'i( Bt'e de$ault. oweerA we wis' to introduce a Dlag %eA i.e. t'ere is to "e a dela) "etween t'e (urc'ase order "eing co%(leted and t'e installaon to allow $or t'e delier) o$ t'e new 'ardware. Introduce t'is lag now ") c'anging t'e alue in t'e lag colu%n o$ t'e tas# in$or%aon window $or t'e Dinstall tas#. C'ange t'e lag alue in t'is colu%n to 10 da)s. BI$ )ou no longer 'ae t'is window o(enA re%e%"er t'at it can "e o(ened ") dou"le clic#ing on t'e tas#.
?"sere t'e c'ange in t'e ;an< c'art. /'e %e $or t'e dis# storage u(grade s'ould now "e 14 da)s again. B@se t'e undo and re9do arrows to c'ec# t'at )ou are ac'ieing t'e desired result.
Page 25 o$ 64
Microsof Project Praccal Exercises
Note t'at t'e (redecessor colu%n $or t'e install tas# now 'as :-10 da)s s'owing t'e (redecessor relaons'i( and lag. /'is could also 'ae "een entered %anuall) in t'e (redecessor colu%n.
$o ens(re t1at any new tas%s a--e- to yo(r sc1e-(le are a(tomacally s c1e-(le- A )ou
s'ould clic# on DNew /as#s Manuall) -c'eduled on t'e "o
i%ages "elow
C'anges to
Page 26 o$ 64
Microsof Project Praccal Exercises
Adding a milestone +'en t'e integraon and tesng is co%(leteA t'e new Ds)ste% is read) to go. /'is is a %ilestone $or t'e (roject. B+e could 'ae ot'er %ilestones during t'e (rojectA "ut t'is is t'e onl) one we will add $or t'e (ur(oses o$ t'ese (raccal exercises.
Insert a new tas# underneat' t'e 8nal DMail ?ut tas# called D-)ste% read). I$ )ou 'ae inserted t'e tas# correctl)A it s'ould "e D: -)ste% 7ead) D. @se t'e indentoutdent arrows on t'e /as# ri""on to %a#e an) necessar) adjust%ent to )our +,- 'ierarc').
Ma#e t'e (redecessor o$ Ds)ste% read) t'e Dintegraon tesng tas# Bi.e. tas# 30 wit' +,4.2 and na%e o$ /est
C'ange t'e duraon to 0 da)s. Noce t'e new %ilestone s)%"ol t'at a((ears on t'e ;an< c'art Ba s%all dia%ond.
Now su((ose t'at we want to %ail t'e "roc'ures out 2 wee#s "e$ore t'e s)ste% is read). dd t'e a((ro(riate relaons'i( "etween t'e D%ail out tas# t'e Ds)ste% read) %ilestone to wor# "ac# 2 wee#s to deter%ine w'en t'e %ail out tas# s'ould ta#e (lace. int use a negae lag relae to t'e Ds)ste% read) tas#. Fou will "e a"le to iew t'eir relaons'i( on t'e ;an< c'art to c'ec# i$ it 'as "een entered correctl).
Modifying the timescale In so%e situaons )ou %a) not want to use t'e de$ault %e scale used in t'e ;an< c'art. or exa%(leA it can "e use$ul to condense t'e ;an< c'art to see t'e D"ig (icture "e
?ne wa) to iew t'e w'ole (roject is to select t'e DEnre Project $ro% t'e oo% grou( on 6iew ri""on. Note t'at i$ )ou select DRoo% G $ro% t'e dro(9down list o$ oo% o(onsA t'ere are o(ons t'at allow )ou to oo% to 1 wee#A 1 %ont' etc. Ex(eri%ent wit' so%e o$ t'ese o(ons now.
Fou can also %odi$) t'e %escale ") selecng t'e /i%escale o(on $ro% t'e /i%escale dro(9down list in t'e oo% grou( on t'e 6iew ri""on. Page 27 o$ 64
Microsof Project Praccal Exercises
/'ere are t'ree ers t'at can "e dis(la)ed a"oe )our ;an< c'art. Ex(eri%ent wit' t'e diJerent D/i%escale o(ons t'at )ou can select $ro% t'e D-'ow dro( down "ox. /'is will clari$) w'at is %eant ") t'e diJerent ers. B/r) one erA t'en t'ree ers and o"sere w'at 'a((ens on )our ;an< c'art.
7eturn to t'e de$ault w'ic' s'ows two ers B%iddleA "o
gain in t'e /i%escale windowA select t'e D%iddle er ta" and c'ange t'e units to Luarters instead o$ wee#s.
-elect t'e "o
-et t'e %iddle er "ac# to wee#s and t'e "o
"islaying the critical ath
-elect t'e or%at ta" and clic# in t'e Dcrical tas#s c'ec# "ox in t'e "ar st)les grou(.
?"sere t'at t'e tas#s on t'e crical (at' are now dis(la)ed as red "ars on )our ;an< c'art.
Fou can also use t'e 8lter in t'e 5ata grou( on t'e 6iew ta" to 8lter out all tas#s exce(t t'ose on t'e crical (at'.
Page 2 o$ 64
Microsof Project Praccal Exercises
+'at tas#s are on t'e crical (at'Bs $or )our (rojectQ SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
I$ )ou used t'e 8lterA return it "ac# to t'e de$ault Dno 8lterA so t'at )ou can now iew all )our tas#s again.
Assessing the sensitivity of your schedule /'e sensiit) o$ a sc'edule is a %easure o$ 'ow li#el) it is t'at t'e original crical (at' Bor (at's will c'ange w'en t'e (roject is underwa). I$ t'e li#eli'ood is 'ig'A t'en t'e sc'edule is er) sensie. /'e sensiit) de(ends on a. /'e nu%"er o$ crical ,at1s in t'e networ#. In generalA t'e sensiit) increases as t'e nu%"er o$ crical (at's increases. Fou 'ae alread) iden8ed t'e crical (at' or (at's $or )our networ#. ow %an) 'ae )ou iden8edQ
Note t'at t'is Lueson is not as#ing
'ow %an) tas#s are on t'e crical (at' Bor (at'sA it is as#ing 1ow many crical ,at19s: are in t'e networ#. and ". /'e a%ount o$ slac# t'e non crical tas#s 'ae 9 i$ t'ere is a reasona"le a%ount o$ slac# relae to t'e non crical tas# duraonsA t'en t'ese tas#s are less li#el) to "eco%e cricalA i.e. t'e networ# is %ore li#el) to "e sta"le Binsensie. /'e instrucons to iew slac# are gien "elow
Clic# t'e arrow on /a"les in t'e 5ata grou( on t'e 6iew ri""on and select t'e Dsc'edule ta"le. /'is allows )ou to iew t'e Dsc'edule ta"le. Page 2! o$ 64
Microsof Project Praccal Exercises
Fou s'ould now see a ta"le o$ t'e sc'edule wit' E-A EA -A A ree slac# and total slac# colu%ns.
+'at is t'e slac# $or t'e non crical tas#sQ
+'at does t'is Band t'e nu%"er o$ crical (at's suggest a"out t'e sensiit) o$ t'e networ#Q
7e%e%"erA
/as#s on a (at' can 'ae t'e sa%e /-A "ut diJerent - & i.e. t'e tas#s on t'e (at' Ds'are t'e total slac#A so i$ one is dela)ed it reduces t'e /- $or t'e (at' and all t'e su"seLuent tas#s on t'at (at'. oweerA i$ a tas# is not at t'e end o$ t'e c'ain its dela) will dela) t'e start o$ its successorA so ") de8nionA t'e tas# Bor tas#s not at t'e end o$ t'e c'ain will 'ae no $ree slac#. ree slac# tends to s'ow u( in t'e last tas# at t'e end o$ a c'ain o$ non crical acies or in a single non crical acit). Fou can o"sere exa%(les w'ere tas#s on t'e sa%e (at' 'ae t'e sa%e /-A "ut onl) t'e tas# on t'e end o$ t'e c'ain 'as - ") loo#ing at t'is in t'e sc'edule ta"le. ;ie one exa%(le $or t'is (roject.
7eturn to t'e de$ault iew o$ t'e tas# entries ") selecng DEntr) $ro% t'e list o$ aaila"le ta"les in /a"les dro(9down list. B/'e dro(9down list is in t'e 5ata grou( on t'e 6iew ri""on.
#iewing the network diagram
-elect DNetwor# diagra% $ro% t'e D /as# 6iews grou( on t'e 6iew ri""on. Fou s'ould now see t'e networ# diagra% iew o$ t'e (roject.
It %a) "e diOcult to see t'e w'ole (roject. -elect Roo% $ro% t'e Roo% dro(9down list in t'e Roo% grou( on t'e 6iew ri""on and select DEnre Project.
Page 3# o$ 64
Microsof Project Praccal Exercises
/'ere are arious o(ons )ou can ex(lore to %odi$) t'e networ# diagra%. or exa%(leA )ou can re%oe t'e Dsu%%ar) tas# "oxesA so t'at )our networ# diagra% is less clu
,e$ore 8nis'ing (raccal 2 return to t'e ;an< iew and %a#e sure t'at )ou 'ae saed )our wor#.
Page 3" o$ 64
Microsof Project Praccal Exercises
Practical 3 Adding $esources
?(en (raccal2.%(( 8le Bi$ it is not alread) o(en and sae to a 8le called (raccal3.%((. Fou now 'ae a co() o$ )our wor# to use in (racca3.%((. Fou will use (raccal3.%(( as t'e starng (oint $or t'is wee#Hs (raccal.
Create the resorce pool
I$ it is not alread) o(enA o(en (raccal3.%(( ") dou"le clic#ing on t'e 8le.
Ma#e sure )ou are using t'e ;an< c'art iew.
-elect t'e D7esource -'eet o(on $ro% t'e 6iew ri""on. In t'e ta"le t'at is dis(la)edA )ou s'ould see colu%ns $or t'e resource na%eA t)(eA %aterial la"elA inialsA grou(A %ax unitsA std rate etc. I$ t'is is not t'e ta"le )ou see dis(la)edA select Entr) $ro% t'e /a"les dro(9down list in t'e 5ata grou( on t'e 6iew ri""on.
dd t'e in$or%aon a"out t'e resources $or t'e (roject. /'e resource could include "ot' wor#ers and %aterials suc' as eLui(%ent 'ire. In our exa%(le we onl) 'ae to add t'e staJ res(onsi"le $or t'e tas#s. /'e staJ resources t'at are aaila"le $or our exa%(le (roject are listed "elow. Enter t'e% in t'e resource ta"le now. &eso(rce
$y,e
Name
Max
St- &ate
)ccr(e )t
+nits
Base calen-ar
Progra%%er
+or#
200T
U*0A000)r
Prorated
standard
nal)st
+or#
100T
U120A000)r
Prorated
standard
ardware
+or#
100T
U110A000)r
Prorated
standard
+or#
100T
U120A000)r
Prorated
standard
+or#
100T
U!A000)r
Prorated
standard
/ester
+or#
200T
U100A000)r
Prorated
standard
-enior
+or#
0T
U120A000)r
Prorated
standard
+or#
100T
U100A000)r
Prorated
standard
engineer Mar#eng s(ecialist Purc'asing agent
Progra%%er ;ra('ic 5esigner
Page 32 o$ 64
Microsof Project Praccal Exercises
d%in
+or#
100T
U0A000)r
Prorated
standard
+or#
100T
U:0A000)r
Prorated
standard
ssistant (rinter
1. Note t'at a. Fou enter t'e resource units into Microsof Project as a (ercentage. /'e de$ault (ercentage is 100T. 100T indicates t'at t'ere is one o$ t'ose resources aaila"le. I$A as in t'e case o$ (rogra%%ersA t'ere are 2 aaila"leA )ou enter 200T. - i%ilarl)A i$ t'ere was a $ull9%e (rogra%%er and one (art9%e Bor 0. %e (rogra%%er aaila"leA )ou would enter 10T. B/'is assu%es t'at so%eone wor#ing 0T is t'ere $or 'al$ a da) eer) da). I$ t'is was not t'e case )ou %a) 'ae to D8ne tune t'is resource in$or%aon and allocaon. +'en )ou grou( resources toget'er in t'is wa) it %eans t'at t'e) are interc'angea"leA i.e. all (rogra%%ers can do t'e sa%e wor#A 'ae t'e sa%e s#ill leel and get t'e sa%e salar). I$ )ou need to %a#e a disncon t'en )ou s'ould enter t'e details o$ t'e diJerent resources se(aratel). ". It is eas) to switc' "etween 'ourl) and annual (a) rate. I$ )ou enter t'e nu%eric alue)rA t'e entr) will "e an annual (a) rate. c.
I$ )ou entered an 'ourl) rateA t'en t'at grou( could Luali$) $or oer%e rates w'ic' would t'en "e entered in t'e D?t rate colu%n.
d. In t'e Dccrue at colu%nA t'ere are arious o(ons aaila"le in t'e dro( down list startA (roratedA end. Prorated %eans t'at t'e cost(a)%ent is accrued on a da) to da) "asis. -tart %eans (a)%ent is reLuired at t'e start. End %eans t'e (a)%ent is reLuired w'en t'e wor# is co%(lete. e. /'e calendar can also "e c'anged $or eac' resource entr). /'is would allow )ou to ta#e into account t'e diJerences in aaila"ilit) o$ wor# grou(s or indiiduals in t'e (roject.
%ssigning resorces
7eturn to t'e ;an< c'art iew and clic# t'e 7esource ta". Note t'at t'ere is an icon on t'e tool"ar t'at is $or assigning resources. BIt 'as t'e a((earance o$ t'e 'ead and s'oulders o$ two (eo(le.
Clic# t'e DIn$or%aon ;at'ering tas% in )our (roject Bin t'e tas# list. Fou are now going to assign resource to t'is in$or%aon gat'ering tas#. Clic# on t'e Dassign resources icon on t'e tool"ar. In t'e (o(9u( window t'at a((ears )ou will see all t'e resources aaila"le $or t'e (roject.
Page 33 o$ 64
Microsof Project Praccal Exercises
-elect anal)st and clic# on t'e assign "ung was diJerent.
I$ t'e tas# was eJort drienA t'en t'e addional resource would 'ae reduced t'e duraon $or t'e tas# accordingl). Microsof Project uses resource and assign%ent in$or%aon w'en calculang t'e sc'edule. It ta#es into account t'ings suc' as 1.
/'e a%ount o$ wor# or oer%e a resource is allocated.
2.
/'e tas# t)(e. o
ixed unit & D A task in which the assigned units [or resources] is a fxed value and any changes to the amount o work or the task's duration do not aect the task's units. his is calculated as ollows! "uration x #nits $ %ork& (icrosot )el*+ 2,1,-
o
ixed duraon & A task in which the duration is a fxed value and any changes to the work or the assigned units [that is+ resources] don't aect the task's duration. his is calculated as ollows! "uration x #nits $ %ork.& (icrosot )el*+ 2,1,-
Page 34 o$ 64
Microsof Project Praccal Exercises
o
ixed wor# &D A task in which the amount o work is a fxed value and any changes to the task's duration or the num/er o assigned units [or resources] do not aect the task's work. his is calculated as ollows! "uration x #nits $ %ork.& (icrosot )el*+ 2,1,-
0.
+'et'er or not t'e tas# is eJort drien. “ a task is eortdriven+ as resources are added or removed on the assignment+ the work remains constant or the task and is redistri/uted among the resources. 3or fxedunit tasks+ or exam*le+ one result is that i more resources are assigned+ a shorter duration is re4uired to com*lete the task& (icrosot )el*+ 2,1,-
5.
/'e resource calendar.
Fou %a) 'ae read t'e details a"out Dow do resource assign%ents drie t'e sc'eduleQ w'en )ou read t'e Dow sc'eduling wor#s in Project arcle in Microsof el( t'at was re$erred to earlier in t'ese (raccals. I$ notA read t'is now and ex(eri%ent wit' t'e arious o(ons to %a#e sure t'at )ou understand t'e%. B/o %odi$) a tas# t)(eA dou"le clic# on t'e tas#A -elect t'e Ddanced ta" in t'e D/as#s In$or%aon (o( u( window and select t'e tas# t)(e $ro% t'e dro( down list. Note t'at t'ere is also a c'ec# "ox to allow )ou to select w'et'er or not )ou want t'e tas# to "e DeJort drien.
Page 35 o$ 64
Microsof Project Praccal Exercises
/r) diJerent co%"inaons suc' as 9
ixed unitA eJort drien o
dd a new resource & w'at 'a((ens to t'e duraonQ
o
7educe one o$ t'e resources to 0T & w'at 'a((ens to t'e duraonQ
etc. /'e arious o(ons are descri"ed in detail in t'e Microsof Project Del( on Dow sc'eduling wor#s in Project arcle re$erred to earlier in t'e (raccals. Ma#e sure t'at )ou understand t'e arious o(ons and t'e results o$ )our ex(eri%entaon. I$ )ou "eliee t'at Microsof Project 'as %odi8ed )our sc'edule in a wa) t'at does not corres(ond to t'e reLuire%ents $or )our (rojectA )ou can oerride t'e duraon etc. BNote t'at %anuall) sc'eduled tas#s cannot "e set to eJort9drien.
I$ necessar)A reset t'e de$ault $or t'e tas# )ou 'ae "een ex(eri%enng wit' to auto%acall) sc'eduled and D8xed units t'at are not DeJort drien
In our exa%(leA t'e in$or%aon gat'ering tas# is to ta#e 3 wee#s B1 wor#ing da)s wit' "ot' t'e anal)st and %ar#eng s(ecialist wor#ing on t'is toget'er Band "ot' allocated 100T to t'is tas#. Ma#e sure t'at t'is is correct in )our sc'edule. lwa)s ta#e care w'en )ou %odi$) resource assign%ents. C'ec# t'at t'e result is t'e desired -(raon and reso(rce allocaon $or )our (roject. Fou s'ould also c'ec# t'at resources are not oer9allocated. /'is will "e discussed $urt'er in t'e next secon.
Add the ollowing resources to the project tasks !ote that the task dura"ons are also given in the table # necessary override the dura"ons to correspond to the data in the table below Also, note that there is an alternave method for adding a resource $ou can select the resource rom the drop down list o available resources that you observe when you click in the resource column or a par"cular task
$as% names
*(raons
&eso(rces
New Billing System &e'(irements )nalysis
In$or%aon gat'ering
3 wee#s
1 anal)st and 1 %ar#eng s(ecialist
5e8ne 7eLuire%ents
3 wee#s
1 anal)st and 1 %ar#eng s(ecialist
*is% Storage +,gra-e
Purc'ase
1 da) Blag o$ 10 da)s $or Page 36 o$ 64
I (urc'asing agent
Microsof Project Praccal Exercises
delier) introduced earlier Install
3 da)s
1 'ardware engineer
5esign 5, C'anges
2 wee#s
1 anal)st
Modi$) 5,
1 wee#
0. senior
Sofware Mo-i.caons *ata/ase
(rogra%%er Programs
5esign Progra%s
3 wee#s
1 anal)st
Code (rogra%
2 wee#s
1 (rogra%%er
@nit test
1 wee#
1 tester
Code (rogra% ,
4 wee#s
1 (rogra%%er
@nit test ,
2 wee#s
1 tester
Code (rogra% C
3 wee#s
1 (rogra%%er
@nit test C
2 wee#s
1 tester
Code (rogra% 5
3 wee#s
1 (rogra%%er
@nit test 5
2 wee#s
1 tester
Code (rogra% 71
2 wee#s
1 (rogra%%er
@nit test 71
1 wee#s
1 tester
2 wee#s
0. -enior
Program )
Program B
Program 0
Program *
Program &"
ntegraon
Integrate
Progra%%erA 1 (rogra%%er test
1 wee# Page 37 o$ 64
0. senior
Microsof Project Praccal Exercises
(rogra%%erA 1 tester )-ersing Broc1(res
5esign
2 wee#s
1 gra('ic designerA 1 %ar#eng s(ecialist
(rint
1 da)
1 (rinter
Mail out
1 da)
1 ad%in assistance
I$ )ou do not wis' to allocate 100T o$ a resource to a (arcular tas# Be.g. i$ )ou want t'e resource to wor# 0T on one tas# and 0T on anot'er tas# $or a (arcular (eriod o$ %eA it is (ossi"le to s(eci$) t'is.
5ou"le clic# on t'e D%ail out tas#. Fou will see a D/as# In$or%aon (o(9u( window.
Clic# on t'e 7esources ta". Fou can now adjust t'e units in t'e D@nits colu%n. /r) c'anging t'e units $or t'e ad%in assistant now. Clic# o# and note an) c'anges. 5id an)t'ing 'a((en to t'e duraon andor cost $or t'is tas#Q Ex(lain. SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
C'ange t'e units $or t'e ad%in assistant "ac# to t'eir original alue.
Note t'at so%e o$ t'e tas#s now 'ae a red s)%"ol in t'e Di colu%n to indicate t'at t'e) use
resources t'at are now oer9allocated. Fou will learn a"out so%e tec'niLues to 'el( resole t'ose issues in t'e next secon.
Adjusting $esource Allocation Identi+ication of resorce o,er-allocation
-elect t'e 6iew ta" and clic# on D7esource -'eet in t'e 7esource 6iews grou(. Fou s'ould now see a iew o$ t'e resource s'eet. In t'is iewA )ou s'ould see t'e oer9 allocated resources dis(la)ed in red. re an) o$ )our resources oer9allocated $or t'is (rojectQ B/'e (rogra%%ersA anal)sts and testers s'ould "e dis(la)ed in red "ecause t'e) are oer9 allocated.
Page 3 o$ 64
Microsof Project Praccal Exercises
/o o"tain %ore in$or%aon a"out t'e oer9allocaon (ro"le%A select t'e D7esource @sage o(on t'e 7esource 6iews grou(. I$ )ou use t'e "o
n alternae iew t'at can "e er) use$ul is t'e resource gra('. Fou can iew t'e resource gra(' ") selecng t'e D7esource ;ra(' o(on $ro% t'e D?t'er 6iews dro(9down list. /r) t'at now. BFou %a) need to select Denre (roject $ro% t'e oo% "loc# on t'e 6iew ri""on.
Page 3! o$ 64
Microsof Project Praccal Exercises
Page 4# o$ 64
Microsof Project Praccal Exercises
Clic#ing on t'e arrows at t'e "o
.ealing )ith o,er-allocation isses /'ere are arious o(ons $or dealing wit' resource oer9allocaon " It %a) "e (ossi"le to oerco%e t'e (ro"le%s ") leelling t'e resources wit'in exisng
slac#. /'is does not extend t'e (roject duraonA "ut "ecause )ou 'ae a"sor"ed so%e o$ t'e exisng slac# Vi.e. (us'ed a tas# later in t'e %eline WA it %a) %a#e t'e networ# %ore sensie. 2 It %a) not "e (ossi"le to oerco%e t'e oer9allocaon (ro"le% ") using slac#. In t'is
situaonA o(ons include a. extending t'e (roject duraonX ". allocang addional resources to t'e (rojectX c.
%a#ing t'e exisng resources wor# oer%e.
In our exa%(leA t'e anal)st is oer9allocated w'en 'es'e 'as to design t'e data"ase c'anges and t'e (rogra%%ing tas#s.
I$ )ou are not in t'e ;an< C'art iewA return to t'e ;an< c'art iew.
Clic# t'e arrow on /a"les in t'e 5ata grou( on t'e 6iew ri""on and select t'e D-c'edule ta"le. /'is allows )ou to iew t'e Dsc'edule ta"le.
Page 4" o$ 64
Microsof Project Praccal Exercises
?"sere t'at t'ere are : wee#s o$ slac# $or t'e Ddata"ase design and c'anges tas#sA "ut 0 slac# $or t'e (rogra% designs.
7ecord t'e end date $or )our (roject 'ere
SSSSSSSSSSSSSSSSSSSSSSS
7ecord t'e duraon o$ t'e (roject Bin da)s 'ere
Clic# t'e 7esource ta" and select Deelling ?(ons $ro% t'e eel grou(. In t'e 7esource eelling window t'at a((earsA select Deel onl) wit'in aaila"le slac# in t'e Dresoling oer9allocaons secon. Ma#e t'e selecons as s'own "elow and clic# ?.
/'is o(on will a
fer selecng t'e Dleel onl) wit'in aaila"le slac# clic# t'e Dleel all "u
Microsof Project Praccal Exercises
+'at aJect 'as t'is 'adQ B6iew t'e result in t'e D7esource -'eet and on t'e ;an< c'art. ow %uc' slac# is t'ere $or t'e Ddata"ase design and c'anges tas#s nowQ
+'at tas#s are now DcricalQ
Note t'at t'is is now considered to "e a D crical c1ain. /'is ter% was coined ") ") Eli)a'u ;oldra< w'o recognised t'at t'at a (roject networ# %a) "e constrained ") "ot' resource and tec'nical de(endencies as is t'e case in t'is exa%(le. /'e ter% crical (at' tends to "e associated wit' just tec'nical de(endenciesA not resource de(endencies.
7ecord t'e end date and duraon Bin da)s o$ t'e (roject now
ae t'e) c'angedQ BEx(lain.
Fou s'ould 8nd t'at t'e end date 'as not c'anged and t'at t'e oer9allocaon o$ t'e anal)st 'as "een resoledA "ut not t'e (ro"le% wit' t'e (rogra%%ers and testers. +e were a"le to resole t'e oer9allocaon o$ t'e anal)st using aaila"le slac#A "ut not t'e (ro"le% wit' t'e (rogra%%ers and testers. /o resole t'e ot'er resource oer9allocaon issues we eit'er need to extend t'e duraon o$ t'e (roject or add extra (rogra%%ing and tesng resources. or t'e (ur(oses o$ t'is exerciseA we will assu%e t'at t'e addion o$ extra resources is not an o(on and t'at we need to extend t'e duraon.
Page 43 o$ 64
Microsof Project Praccal Exercises
gain Clic# t'e 7esource ta" and select Deelling ?(ons $ro% t'e eel grou(. /'e 7esource eelling window will a((ears. /'is %e Dunc# t'e Deel onl) wit'in aaila"le slac# o(on.
Clic# t'e Deel ll "u
"ecause t'e nu%"er o$ resources are constrained. +it' resource constrained sc'edulingA we allow t'e duraon o$ t'e (roject to "e extended i$ t'at is necessar) to resole oer9 allocaon w'en t'e nu%"er o$ resources are li%ited. In t'e text "oo# de8nion o$ D reso(rce leelling we ai% to ac'iee a D%ore een%ore leel usage o$ resources wit1o(t exten-ing t1e -(raon o$ t'e (roject ") onl) adjusng t'e sc'eduled %e $or a tas# Dwit'in
t'e aaila"le slac#.
+'at 'as 'a((enedQ
Is t'ere sll a resource allocaon (ro"le%Q
C'ec# t'e resource s'eet and resource gra(' B$or t'e (rogra%%ersA anal)st and testers. re t'e) oer9allocatedQ
+'at 'as 'a((ened to t'e duraon o$ t'e (roject now t'at )ou 'ae (er$or%ed resource leelling wit'out t'e Dleel onl) wit'in aaila"le slac# restriconQ
+'at 'as 'a((ened to t'e crical tas#sQ
+'en does t'e (roject 8nis' nowQ 97ecord t'e (roject end date now
+'at is t'e (roject start dateQ Note t'at in t'is (raccal we 'ae carried out resource Dleelling oer t'e enre (roject. oweerA t'is is not t'e onl) o(on. or exa%(leA )ou can c'oose to leel onl) a (oron o$ t'e (roject or to (er$or% leelling $or selected resources t'at are in 'ig' de%and. It is also (ossi"le to %anuall) resole Doccasional resource oer allocaons ") introducing Dleelling dela)s. In addionA )ou will 'ae noced t'at t'ere are arious o(ons t'at )ou can set w'en (er$or%ing leelling Be.g. to allow tas#s to "e s(lit. 5iscussion o$ t'ese o(ons is "e)ond t'e sco(e o$ t'ese (raccals. Page 44 o$ 64
Microsof Project Praccal Exercises
#iewing the %udget details /ie) the total cost
-elect t'e DCost ta"le $ro% t'e dro(9down list o$ ta"les in t'e 6iew ri""on. /IP 5o t'is ") 8rst c'oosing t'e 6IE+ ta" B ri""on & ;o to t'e D5ata seconA and select $ro% t'e dro(9down lisng under D/a"les Cost
+'at is t'e total cost es%ate $or t'is (rojectQ
+'at is t'e %ost ex(ensie tas#Q
/o iew t'e costs associated wit' eac' o$ t'e resources select D7esource -'eet $ro% t'e D7esource 6iews grou( and select t'e DCost ta"le $ro% t'e dro(9down list o$ ta"les in t'e 5ata grou( on t'e 6iew ri""on. /'is s'ould allow )ou to iew t'e cost associated wit' eac' o$ t'e resources.
+'at is t'e total a%ount es%ated to "e s(ent on (rogra%%ing staJ in t'is (rojectQ Page 45 o$ 64
Microsof Project Praccal Exercises
Page 46 o$ 64
Microsof Project Praccal Exercises
Practical Comaring actual rogress with lanned rogress
?ne o$ t'e reasons $or deelo(ing )our (roject sc'edule is to allow )ou to co%(are actual (rogress wit' (lanned (rogress. Fou can acco%(lis' t'is ") saing a "aseline as a sna(s'ot o$ )our original sc'edule "e$ore )our (roject gets rolling and t'en recording actual (rogress as t'e (roject (rogresses.
/'is (raccal is to de%onstrate so%e o$ t'e Microsof Project $eatures to 'el( )ou to co%(are actual (rogress wit' (lanned (rogress. /o de%onstrate t'e Microsof Project $eatures we will (ro"a"l) 'ae to set i%aginar) data a"out t'e status o$ tas#s $or a %e in t'e $uture Bunless )ou are er) "e'ind in )our (raccals. /'is is not so%et'ing )ou would do in realit).
?(en (raccal3.%(( 8le Bi$ it is not alread) o(en and sae to a 8le called (raccal4.%((. Fou now 'ae a co() o$ )our wor# to use in (racca4.%((. Fou will use (raccal4.%(( as t'e starng (oint $or t'is wee#Hs (raccal. Close (raccal3.%((
I$ it is not alread) o(enA o(en (raccal4.%(( ") dou"le clic#ing on t'e 8le.
$a,ing the baseline Now t'at we 'ae iden8ed tas#sA (redecessor relaons'i(sA added duraonsA assigned resources and resoled t'e resource issuesA we are read) to sae our (lan as a "aseline (lan. /'is will allow us to co%(are actual (rogress wit' (lanned (rogress w'en t'e (roject is underwa).
/o sae t'e "aseline (lanA return to t'e ;an< c'art iew t'en clic# on t'e Project ta" and select Dset "aseline $ro% t'e D-et ,aseline dro(9down list in t'e -c'edule grou(.
-elect Dset "aseline. s t'is is t'e original "aseline it s'ould just "e called "aseline.
Clic# t'e D$or t'e enre (roject o(on $ollowed ") ? to co%(lete saing t'e "aseline.
Page 47 o$ 64
Microsof Project Praccal Exercises
/ie)ing the racking antt Chart I$ )ou now iew t'e trac#ing ;an< c'art it will dis(la) "ot' t'e current sc'edule B"ars on to( wit' t'e "aseline tas#s "ars "elow t'e%. /o iew t'e /rac#ing ;an< c'art select t'e /rac#ing ;an< o(on $ro% t'e dro( down list )ou see w'en )ou clic# on D;an< C'art in t'e to( lef 'and corner w'en )ou are iewing t'e tas# ri""on. BFou %a) need select Denre (roject $ro% t'e oo% secon o$ t'e 6iew ri""on to see t'e w'ole c'art clearl).
Page 4 o$ 64
Microsof Project Praccal Exercises
Four /rac#ing ;an< c'art s'ould a((ear si%ilar to t'e $ollowing extract
Inserting a stats report date
Now su((ose t'at )ou are in t'e execung stage o$ t'e (roject. In t'at case )ou will want to u(date t'e sc'edule to accuratel) record t'e actual status o$ )our (roject on a regular "asis. Fou can do t'is in Microsof Project and )ou can use arious $eatures to 'el( )ou to anal)se t'e status o$ )our (roject.
/o "eginA )ou need to collect (rogress data $ro% )our tea% u( to t'e (arcular status date. Fou will "e gien so%e status in$or%aon to ex(eri%ent wit' s'ortl). In t'is (raccal exercise we are de%onstrang so%e o$ t'e Microsof Project $eatures. oweerA we are not actuall) in t'e execung stage o$ t'e (roject so we are going to ar8ciall) select a status date. /'is could "e in t'e $uture or (ast de(ending on 'ow Luic#l) )ou are (rogressing t'roug' t'e (raccals. Ignore t'is ano%al) $or t'e (ur(oses o$ t'is exercise.
or t'is (raccalA )ou are to select t'e (roject status date to "e t'e rida) o$ t'e 4t' wee# into )our (roject. B/'is assu%es t'at )ou correctl) started )our (roject on a Monda) as reLuested in (raccal 1. I$ t'at is not t'e case %a#e t'e a((ro(riate adjust%ents.
$o set t1e stat(s -ate select DProject In$or%aon $ro% t'e Project (ro(eres grou( on t'e
Project ri""on. Enter t'e status date and clic# ?. B/'e screen s'ot "elow does not 'ae t'e actual date t'at )ou need to select $or )our status date. /'e date will de(end on w'en )ou Page 4! o$ 64
Microsof Project Praccal Exercises
started t'ese (raccal exercises.
7ecord )our (rogress status date 'ere.
It can also "e 'el($ul to iew t'e status data as a Dgridline on t'e ;an< C'art Band /rac#ing ;an< C'art. /o ac'iee t'isA clic# on t'e dro( down arrow "elow t'e D;ridlines icon in t'e Dor%at area o$ t'e or%at ri""on.
-elect gridlines $ro% t'e o(ons dis(la)ed.
In t'e (o( u( window t'at a((earsA scroll down t'e Dine to c'ange list and clic# D-tatus 5ate. Ma#e selecons $or t'e t)(e and colour t'at will stand out clearl) on )our ;an< C'art. Bor exa%(leA a solid line coloured (ur(le.
Page 5# o$ 64
Microsof Project Praccal Exercises
Fou s'ould now see a line s'owing t'e status date on )our ;an< C'art.
$etting ptions #efore 4pdating ask $tats
/'ere are seeral se>ngso(ons related to u(dang tas#s. Mostl) t'e de$aults are w'at we would want in %ost cases. oweerA t'ere are so%e se>ngs in t'e adanced categor) t'at need to "e %odi8ed "e$ore we enter so%e status data $or t'e (roject.
/o c'ange t'e se>ngsA go to ile9Y?(ons and select Dadanced as s'own "elow.
Page 5" o$ 64
Microsof Project Praccal Exercises
-croll down t'roug' t'e adanced o(ons and %odi$) t'e Dcalculaon o(ons $or t'is (roject as s'own in t'e screens'ot "elow
Page 52 o$ 64
Microsof Project Praccal Exercises
/'e $ollowing in$or%aon ex(lains w'at we 'ae %odi8ed. Moe en- o com,lete- ,arts afer t1e stat(s -ate /ac% to t1e stat(s -ate8 & t'is %eans an)
co%(leted wor# will "e %oed %oed "ac# to "e$ore t'e status date i.e. t'e wor# is now recorded as 'aing "een co%(leted in t'e (ast. )n- moe start o remaining ,arts /ac% to stat(s -ate8 & %eans an) inco%(lete (arts will
start at t'e status dateA i.e. i$ t'e) were sc'eduled $urt'er in t'e $uture t'e) can now start "ac# at t'e status date. Moe start o remaing ,arts /eore t1e stat(s -ate orwar- to t1e stat(s -ate & %eaning t'at as
t'e) 'ae not "een co%(leted "e$ore t'e status dateA t'e) are now sc'eduled to "e co%(leted in t'e D$uture B$ro% t'e status date. )n- moe en- o com,lete- ,arts orwar- to stat(s -ate8 & %eans t'at t'e co%(leted
and inco%(leted (orons o$ t'e tas# are joined at t'e status date.
Information abot actal progress
Page 53 o$ 64
Microsof Project Praccal Exercises
Clic# on t'e 6iew ta" and select t'e D/rac#ing ta"le $ro% t'e dro(9down list o$ ta"les in t'e 5ata grou(.
Fou will now 'ae a iew o$ t'e ta"le in w'ic' )ou can iew t'e actual start dateA actual 8nis' dateA T co%(lete etc. Fou can read %ore a"out t'e %eaning o$ eac' o$ t'e diJerent 'eadings ") (lacing t'e %ouse oer t'e 'eading. Fou can also Microsof el( to 8nd %ore detailed in$or%aon.
s )ou can see t'ere are a nu%"er o$ 8elds aaila"le $or recording status in$or%aon. /o u(date status in$or%aon )ou need to enter t'e $ollowing in$or%aon a"out tas#s t'at 'ae startedBor co%(leted 1. )ct(al start -ate & record in t'e ct. -tart colu%n 2. 1at 1as /een com,lete- & )ou can record eit'er t'e actual duraon Bct. 5ur. Colu%nA actual wor# Bct. +or# or (ercentage co%(leted Bsee note "elow regarding PMIHs reco%%endaon regarding T co%(lete. 3. 1at sll nee-s to /e com,lete- & )ou can record eit'er t'e es%ated re%aining duraon B7e%. 5ur. or t'e es%ated re%aining wor# Ban addional colu%n t'at can "e added.
or t'e (ur(ose o$ t'is exerciseA we will assu%e t'at we 'ae t'e act(al start -atesA act(al -(raons and esmates o t1e remaining -(raon Bor 8nis' dates i$ t'e tas# 'as
Page 54 o$ 64
Microsof Project Praccal Exercises
co%(leted $or tas#s t'at 'ae started "e$ore t'e status date we select. 7eLuesng t'is in$or%aon can ofen "e t'e Luic#est wa) to get accurate status data $ro% tea% %e%"ers Notes=
1. Microsof Project will calculate t'e alues $or an) o$ t'e status 8elds t'at )ou donHt u(date directl). or exa%(leA i$ )ou entered t'e actual start dateA t'e actual duraon and re%aining duraonA it will calculate t'e $ollowing
5uraon Z actual duraon re%aining duraon
T Co%(lete Z Bactual 5uraon 5uraon [ 100
2. ;ien t'at t'at it can "e diOcult to accuratel) es%ate t'e T co%(lete o$ a tas# t'at 'as startedA "ut is not )et 100T co%(leteA t'e PMIHs ,od) o$ #nowledge 'as two reco%%endaons $or Dco%(lete w'en carr)ing out earned alue anal)sis 1 )ll or not1ing. tas# is eit'er co%(lete B100T or inco%(lete. I$ inco%(lete it is not included in an) earned alue calculaons. 2 +nstarte-> starte- or com,lete @nstarted s'ould "e set to 0T co%(leteA started s'ould "e set to 0T co%(lete and co%(lete tas#s s'ould "e set to 100T co%(lete. t'ird alternae w'en (er$or%ing earned alue calculaons is to s(eci$) w'at is "elieed to "e t'e Dactual T co%(lete and use t'is alue in t'e calculaons. s stated earlierA we will assu%e t'at we 'ae t'e act(al start -atesA act(al -(raons and esmates o t1e remaining -(raon Bor 8nis' dates i$ t'e tas# 'as co%(leted $or tas#s t'at 'ae started "e$ore t'e status date.
Entering $ome actal $tats Information
7e%e%"er t'at we 'ae entered t'e status date as t'e rida) 4 wee#s into )our (roject. +e will now enter so%e status data $or tas#s t'at were sc'eduled to start "e$ore t'is date.
In t'e exercise )ou will see 'ow to u(date tas#s t'at are running on sc'eduleA u(date co%(leted tas#s t'at didnHt run on sc'edule and u(date tas#s t'at are in (rogress.
+'en entering status dataA it can "e Luite 'el($ul to 8lter out t'e tas#s t'at )ou ex(ect to need to "e u(dated "ecause t'e) are sc'eduled to 'ae started "e$ore t'e status date. /o iew t'ose tas#sA go to t'e 6iew ri""on and select DMore 8lters $ro% t'e 8lter dro( down list.
Page 55 o$ 64
Microsof Project Praccal Exercises
I$ )ou t'e select t'e D-'ould start ") o(on and clic# on t'e Da((l) "u
+,-ang $as%s &(nning ?n Sc1e-(le
/'is ste( is to de%onstrate 'ow eas) it is to u(date tas#s t'at are running on sc'edule. +e will Dundo t'is u(date in t'e next secon so t'at we can ex(lore 'ow to enter in$or%aon a"out tas#s t'at are not running on sc'edule.
-elect t'e DIn$or%aon ;at'ering and D5e8ne 7eLuire%ents tas#s.
-elect t'e DMar# on trac# o(on $ro% t'e dro( down list o$ DMar# on /rac# $ound in t'e sc'edule area o$ t'e /as# ri""on.
/'e status $or t'e two tas#s s'ould "e u(dated and )our /rac#ing ;an< C'art s'ould "e si%ilar to t'e $ollowing
+,-ang 0om,lete- $as%s t1at -i- not &(n on Sc1e-(le
In t'is situaon it is "est to enter t'e actual start and 8nis' dates $or t'e tas#. Page 56 o$ 64
Microsof Project Praccal Exercises
,e$ore we start entering t'e status dataA (n-o t1e ,reio(s stat(s (,-ates si%(l) ") clic#ing t'e undo arrow at t'e to( o$ Microsof Project.
/'e /rac#ing ;an< C'art s'ould now "e si%ilar to t'e $ollowing Bi.e. no status data 'as "een entered )et.
et us assu%e t'at t'e Din$or%aon gat'ering tas# 'as "een co%(letedA "ut t'at it 8nis'ed in 2 wee#s rat'er t'an t'e es%ated 3 wee#s in t'e original sc'edule. /o enter t'is in$or%aonA select t'e Din$or%aon gat'ering tas#A t'en clic# t'e down arrow on t'e rig't o$ t'e DMar# on /rac# "u
Fou s'ould now see a (o( u( window t'at will allow )ou to enter t'e ctual start and 8nis' dates.
Enter t'e actual start date Bassu%e t'at t'e tas# started on %e.
+or# out t'e date w'en )our Din$or%aon gat'ering tas# s'ould "e co%(leted i$ it onl) too# 2 wee#s and enter t'at data in t'e Dctual inis' date. BNote t'at t'ere is a dro( down calendar t'at )ou can use to 'el( )ou wit' t'is.
Clic# t'e ? "u
Four Dtrac#ing ;an< C'art s'ould "e si%ilar to t'e $ollowing
Page 57 o$ 64
Microsof Project Praccal Exercises
Fou can see t'at now t'e Dde8ne reLuire%ents tas# can start 1 wee# earlier t'an originall) sc'eduled. ssu%e t'at t'is tas# started as soon as t'e in$or%aon gat'ering tas# was co%(leted and t'at it was co%(leted in 1 wee# and not t'e originall) es%ated %e o$ 3 wee#s. @(date t'e status $or t'is tas#.
Four trac#ing ;an< C'art s'ould now "e si%ilar to t'e $ollowing
;ien t'at t'e (reious tas#s were co%(leted earl)A t'ere could "e ot'er tas#s t'at are now a"le to 'ae "een started "e$ore t'e status date. ((l) t'e 8lter again to iden$) t'ose tas#s.
+,-ang $as%s t1at are in Progress 9/(t not necessarily ,rogressing accor-ing to sc1e-(le:
In t'is situaon it is "est to enter t'e actual startA t'e actual duraon Bso $ar and t'e es%ated re%aining duraon.
,ased on t'e data we 'ae entered so $arA )ou s'ould now see t'at Ddis# storage (urc'ase could 'ae "een co%(leted and t'at t'e Ddesign (rogra%s and Ddesign Badersing "roc'ure could 'ae "een started. oweerA t'e two design tas#s would not "e ex(ected to 'ae "een co%(leted ") t'e status date.
et us assu%e t'at Ddesign (rogra%s started as soon as its (redecessor 8nis'ed B%eaning t'at one wee# o$ wor# s'ould 'ae "een co%(leted u( to t'e status date. ssu%e t'at t'is tas# is also going well and t'e designers ex(ect to co%(lete t'e design wor# in anot'er wee#.
Page 5 o$ 64
Microsof Project Praccal Exercises
-elect t'e Ddesign (rogra%s tas# and again clic# on t'e Du(date tas#s o(on $ro% t'e DMar# on /rac# list.
Enter t'e start date Bt'e new start date gien t'at t'e (redecessor 'as 8nis'ed earl)A an actual duraon o$ 1 wee# and a re%aining duraon o$ 1 wee#.
inis' u(dang t'e status o$ )our (roject ") co%(leng t'e status in$or%aon $or Ddis# storage (urc'ase and Dadersing "roc'ure design. ssu%e t'at t'e) "ot' started as soon as t'eir (redecessors were 8nis'ed and t'at )ou ex(ect t'e% to ta#e t'e originall) es%ated duraon.
7e%oe t'e 8lter so t'at )ou can iew t'e w'ole /rac#ing ;an< C'art.
I$ )ou are not alread) iewing t'e trac#ing ;an< c'artA select t'at iew.
7eturn to t'e entr) ta"le Baccessed t'roug' ta"les in t'e 6iew ri""on to answer t'e $ollowing Luesons 1. +'at is t'e new duraon $or t'e (roject "ased on t'e current dataQ SSSSSSSSSSSSSSSSSS 2. +'at is t'e new 8nis' date $or t'e (roject "ased on t'e current dataQ SSSSSSSSSSSSSSSSSS 3. ae t'ese c'anged and i$ soA w'at is t'e c'angeQ SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
/ie)ing earned ,ale
-elect D/a"le in t'e 6iew ri""on $ollowed ") D%ore ta"les. 5ou"le clic# on Dearned alue in t'e list o$ aaila"le ta"les and clic# t'e D((l) "u
Page 5! o$ 64
Microsof Project Praccal Exercises
Fou will now "e a"le to iew a ta"le wit' t'e 'eadings 9 Planned 6alue B,C+-A Earned 6alue B,C+PA C BC+PA -6 AC6A ECA ,C and 6C. Note t'at Microsof Project sll 'as t'e old acron)%s in t'e 'eadings as well as t'e na%es and acron)%s t'at )ou s'ould "e $a%iliar wit' $ro% t'is course. Sim,le -e.nions= P@ & t'e (lanned alue & (lanned "udget "ased on t'e original es%ates up to the status
date you have set E@ & t'e Dearned alue o$ t'e wor# co%(leted so $ar Bi.e. "ased on t'e T co%(lete 9
calculates t'at T o$ t'e alue o$ t'e original es%ate to co%(lete t'e w'ole tas#. )0 & t'e actual cost to date Be.g. t'e actual cost $or t'e nu%"er o$ 'ours wor#ed on t'e
tas#. E)0 & also #nown as t'e $orecasted cost at co%(leon. It is calculated in Microsof using t'e
$ollowing $or%ula EC Z C Bso $ar B"aseline cost & E6 Bso $arCPI B)0 & total (lanned cost $or t'e tas#. @)0 & 6ariance at co%(leon BZ ,C & EC
/'ere is also a 'el( lin# aaila"le i$ )ou 'oer a"oe an) o$ t'e 'eadings in Microsof Project.
ro% t'e ta"le )ou s'ould "e a"le to co%(lete t'e $ollowing in$or%aon $or )our (roject. BNote Fou are to 8ll in t'e "lan#s and select t'e a((ro(riate o(on w'ere )ou are gien a c'oice in "rac#ets. C'oices are in italics. /'e (lanned "udget $or t'is (roject to s(end ") t'e status date )ou 'ae selected is . Bro% t'e P6 B,C+- colu%n in row 1 $or t'e w'ole (roject -o $ar t'e (roject 'as earned
in ter%s o$ t'e wor# co%(leted B$ro% t'e
Earned 6alue colu%n in row 1 t t'e sa%e %eA it 'as actuall) s(ent
B$ro% t'e C colu%n in row 1
ccording to t'e ta"leA t'ere is
B-6 B worth o work that was supposed to
have been completed that hasn’t been done yet%addi"onal worth o work that has been completed that was not scheduled to be completed yet and o$ t'e exisng wor# t'at 'as
"een carried out so $arA t'e (roject is
BC6 B over%under "udget.
Fou can also loo# at t'e ariance at co%(leon B6C. /'is ta#es into account t'e CPI we 'ae generated so $ar & i$ t'is connues oer t'e rest o$ t'e li$e o$ t'e (roject we can ex(ect to "e
B6C Bover%under "udget.
Page 6# o$ 64
Microsof Project Praccal Exercises
6C is calculated ") su"tracng t'e EC B$orecasted cost at co%(leon $ro% t'e ,C B(lanned cost. EC is calculated using t'e CPI. I$ )ou 'oer oer t'e 'eading $or t'is colu%n Bor an) o$ t'e ot'ers )ou can see $or%ula used $or t'e calculaon in Microsof Project. It was also gien in t'e de8nions a"oe. Note t'at i$ )ou were actuall) %onitoring t'e (rojectA )ou would also c'ec# t'at t'e ariaons 'ae not re9introduced an) resource allocaons issues. I$ t'at was t'e caseA it would "e necessar) to resole t'e (ro"le%s. +e will not inesgate t'is as(ect o$ t'e (roject in t'e la" exercises.
s )ou (ro"a"l) nocedA t'e sc'edule ariance is %easured in ter%s o$ dollars. I$ it is negae it indicates t'at we are D"e'ind sc'edule in t'e sense t'at t'ere is wor# t'at s'ould 'ae "een carried out t'at 'as not "een done. -i%ilarl)A i$ it is (osieA it is an indicaon t'at we are Da'ead o$ sc'edule in t'e sense t'at t'ere is addional wor# t'at 'as "een co%(leted t'at was not sc'eduled to 'ae "een co%(leted ") t'is stage in t'e original (lan. Note 'oweer t'at a negae sc'edule ariance does not necessaril) %ean t'e (roject will not 8nis' on %e. 1. +') notQ +'en do )ou t'in# a (roject %ig't 'ae a negae sc'edule arianceA "ut sll "e a"le to 8nis' on %e Bor een a'ead o$ %eQ SSSSSSSSSSSSS
SSSSSS
/'e -6 is use$ul to iden$) w'et'er or not t'ere is wor# t'at s'ould 'ae "een carried out t'at 'as not "een co%(leted )et. oweerA -6 does not gie us in$or%aon a"out w'en t'e (roject is ex(ected to 8nis' Bor w'en tas#s wit'in t'e (roject are ex(ected to start and 8nis' once t'e (roject is underwa). ,) iewing t'e ariance ta"le )ou can also see w'at is 'a((ening in ter%s o$ t'e actual 8nis' dates $or acies in t'e (roject and t'e oerall (roject. -i%ilarl)A alt'oug' a (osie -6 is a good signA it does not guarantee t'at t'e (roject will 8nis' earl). gain )ou s'ould c'ec# t'e /rac#ing ;an< c'art and iew t'e ariance ta"les to c'ec# )our sc'edule status.
/ie)ing the start and +inish ,ariances
-elect D/a"les $ro% t'e 6iew ri""on and t'en select D6ariance $ro% t'e list o$ ta"les. /'is will result in t'e dis(la) o$ a ta"le wit' t'e 'eadings start Bactual recorded or (redicted start datesA 8nis' Bactual recorded or (redicted 8nis' datesA "aseline startA "aseline 8nis'A start ariance and 8nis' ariance. In t'e case o$ t'ose acies t'at 'ae "een co%(leted t'e start and 8nis' ariances are t'e actual ariancesA in t'e case o$ t'ose ac ies t'at 'ae )et Page 6" o$ 64
Microsof Project Praccal Exercises
to "e started or co%(letedA t'e ariances are "ased on w'at we #now alread) #now and w'at we ex(ect to 'a((en. Answer to the &ues"on in the previous sec"on' It is (ossi"le to 'ae a negae sc'edule
ariance "ecause t'e (roject is late on non crical tas#sA "ut it could 8nis' earl) or on %e i$ t'e (roject is running on %e or a'ead on t'e acies on t'e crical (at'crical c'ain. ,) iewing t'e ariance ta"le )ou can see w'at is 'a((ening in ter%s o$ t'e start and 8nis' dates once t'e (roject is underwa). BC'ec# )our answers to t'e Luesons in t'e (reious secon.
Page 62 o$ 64
Microsof Project Praccal Exercises
/ie)ing the CPI
-elect /a"les $ro% t'e 6iew ri""on $ollowed ") D%ore ta"les.
-elect DEarned 6alue Cost Indicators
+'at is t'e CPI $or )our (rojectQ
+'at does t'is %eanQ
Is it good or "adQ
Note also t'at t'e /CPI tells us 'ow %uc' we would 'ae to earn on t'e re%aining wor# to ac'iee t'e original target. +'at is t'e /CPI $or t'is (rojectQ
Is t'at good or "adQ
Page 63 o$ 64