hdsdmicrosoftproject2010-nhpdliu-140628120225-phpapp01.pdf

M TI CAP MICROSOFT PROJECT 2010 SITETECH GLOBAL

Lu : Phn in m, in nghing, t mu Page 1

Fanpage Facebook HDSD Microsoft Project: https://www.facebook.com/microsoftproject.vietnam

PHN 2 NHP S LIU

Sau khi thit lp mc nh nh phn 1 trnh by, cc bn tip tc thc hin phn 2 nhp s liu (cng vic, ti nguyn)

I NHP S LIU CNG VIC

d hiu cho l thuyt v minh ha, trong phn ny chng ta s thc hin trn 1 D liu d n c th nh bng bn di. (D liu ch c tnh cht minh ha)

STT Cng tc Thi gian thc hin

(ngy)

Cng tc ng trc

(Predecession) 1. Cng tc chun b 3d 2. Khi cng 0d 1FS+1d 3. o t t 1 bng my 5d 2 4. Thi cng p cc 10d 3




5. o t t 2 bng my 3d 4 6. o t bng th cng 2d 5 7. Cng tc khc 2d 4,5,6

8. b tng lt mng 3d 7 9. GCLD Cp pha mng 5d 8 10. GLLD Ct thp mng 5d 8 11. b tng mng 1d 9,10 12. Bo dng b tng mng 1d 11 13. Tho d Cp pha mng 2d 12FS+1d 14. GCLD Ct thp ct T1 2d 12 15. GCLD Cp pha ct T1 2d 14 16. b tng ct T1 1d 14,15 17. Tho vn khun ct T1 1d 16 18. GCLD Cp pha dm sn T1 4d 17 19. GCLD Ct thp dm sn T1 4d 18SS+1d 20. b tng dm sn T1 1d 18,19 21. Bo dng b tng dm sn T1 1d 20 22. GCLD Ct thp ct T2 2d 21FS+1d 23. GCLD Cp pha ct T2 2d 22 24. b tng ct T2 1d 23 25. Tho vn khun ct T2 1d 24 26. GCLD Cp pha dm sn T2 4d 25 27. GCLD Ct thp dm sn T2 4d 26SS+1d 28. b tng dm sn T2 1d 26,27 29. Bo dng b tng dm sn T2 1d 28 30. Tho vn khun dm sn T1 2d 28, 20FS+21d 31. Tho vn khun dm sn T2 2d 28FS+14d 32. Khoan rt li kim tra CL b tng 1d 30FS+10d,

31FS+10d




Trong phn nhp s liu lin quan ti cng vic, bn nn thc hin theo trnh t sau: Nhp tn cng vic (ct Task name) Nhp thi gian thc hin cng vic (Duration) Nhp mi quan h gia cc cng vic (ct Predecessors)

1/ Nhp tn cng vic v thi gian thc hin cng vic tng ng

Nu nh bn c 1 bng d liu lp sn nh bng trn thi bn ch vic copy/paste 2 ct Cng tc, Thi gian thc hin vo 2 ct Task name, Duration trong MP. Cn khng th bn s nhp trc tip t bn phm (Cng vic ny qu d dng phi khng? ^^)




Mn hnh nhp tn cng tc v thi gian thc hin

2/ Khai bo mi lin h gia cc cng vic

Cc bn ch rng, y ti ang chn mc nh cc cng vic ch Auto nh (nu cha hiu bn xem li phn 1)




Trong MP c 4 dng lin h l FS, SF, SS, FF (Xem thm thng tin trn din n bit 4 mi lin h ny Chuyn 3 ca thy Kiu Mnh T)

C 2 cch khai bo mi lin h gia cc cng vic

* Cch 1: Nhp trc tip vo ct Predecessors trong MP cc thng tin lin h nh trong ct Cng tc ng trc bng d liu trn. Kt qu c nh hnh sau:

Nhp trc tip mi lin h cng tc vo ct Predecessors

* Cch 2: S dng Task Information

Ti sao li s dng Task Information? V khi bn khai bo nh Cch 1 cho cc cng vic c nhiu mi lin h th rt kh khn v c bit rt d nhm ln.

khi ng Task Information bn ch vic Click p vo tn mi cng vic trong ct Task name, khi ca s Task Information xut hin bn chn Predecessors, ri chn cc cng vic lin h vi cng vic cng vi loi lin h (Type) v thi gian tr (lag)




Nhp mi lin h cng tc thng qua Task Information

* Ngoi ra chng ta c th to Cng vic tng cho 1 s cc cng tc lin quan. Cng vic tng rt thch hp khi chng ta s dng cu trc phn chia cng vic (WBS Work Breakdown Structure)

to cng vic tng cho mt nhm cc cng tc bn ch vic chn 1 dng cng tc vo trc nhm cc cng tc (V d: Cng tc t). Sau chn nhm cc cng tc con ca Cng tc t ri bm Indent (hoc Alt + Shift + Phm sang phi). loi b bn ch vic bm Outdent (hoc Alt + Shift + Phm sang tri).




To cng tc tc tng trong MP

Ngoi ra, to Cng tc tng bn cng c th chn nhm cc cng tc con ri vo Task/Summary (trong tab Insert) ri sa li tn thnh Cng tc t

Sau khi khai bo nh trn MP s tnh ton v v ra s Gantt, xem ton b tin d n trong Gantt Chart bn ch vic chn View/Zoom/Entire project (p dng cho c cc khung nhn khc trong MP nh Resource Graph, Network diagram)

3/ Xem d n di dng s mng

Sau khi nhp ton b cng vic, thi gian thc hin, mi lin h gia cc cng tc chng ta c s ngang Gantt. Trong MP cn h tr chng ta mt cch th hin tin khc na l s mng. y l cng vic rt kh nu v bng tay v vi khi lng cng tc ln.

xem s mng bn ch vic chn khung nhn Network Diagram, ri chn ch View xem.

Th hin tin d n di khung nhn Network Diagram

tm hiu su phn ny cc bn hy ch n Phn Nng cao nh ^^

4/ Xem thi im bt u v kt thc ca cc cng vic




Trong MP mc nh cc cng vic l bt u cng sm cng tt (As soon as possible), nn 2 ct Start v Finish thc cht l thi gian bt u sm v kt thc sm ca mi cng vic. xem thi gian bt u mun v kt thc mun ca mi cng vic chng ta c th chn thm 2 ct Late Start/ Late Finish

chn thm 2 ct trn (cng nh bt k ct thng tin no) bn ch cn nhp vo Ct Add new column, g Late Start hoc Late Finish ri bm Best Fit ( thng tin va vi ct)

i thng tin ct sang ting Vit (V d Task name = Cng tc, Start = Bt u) Bn ch vic click chut phi ln Tiu ct mun i tn ri chn Field settings ri nhp thng tin mun i sang ting Vit vo mc Title, v chn cch cn chnh tiu ct, cng nh d liu trong ct (tri, gia, phi)

Sau khi chn thm 2 ct Late Start v Late Finish; i tn ct d liu sang ting Vit

thay i rng buc cho cc cng vic (Khng phi l As soon as possible nh mc nh) bn Click p vo cng vic xut hin ca s Task Information chn Advanced ri chn loi rng buc trong Constraint type v ngy rng buc trong Constraint date




Cc loi rng buc cho mt cng tc trong MP

C mt s loi rng buc cho mt cng tc sau y bn cn nm bt v hiu chng c th vn dng hp l cho mt s cng vic i hi rng buc c th

As late as possible: khi cng cng mun cng tt

As soon as possible: khi cng cng sm cng tt

Finish no earlier than: kt thc khng c sm hn

Finish no later than: kt thc khng c mun hn

Must finish on: phi kt thc vo ngy

Must start on: phi bt u vo ngy




Start no earlier than: khi cng khng sm hn

Start no later than: khi cng khng mun hn

5/ Xem thi gian d tr ca cng vic

Trong lp qun l tin thi cng. Vic bit c thi gian d tr ca mi cng vic l rt quan trong. Khi bit c nhng thng tin ny, ngi lm qun l d n c th iu chnh c thi im thc hin mt s cng vic m khng lm nh hng ti tng tin thi cng ca d n. Khi ngi lm QLDA s bin d n tr nn mm hn.

MP cung cp cho chng ta 2 thng tin v thi gian d tr l D tr ton phn (Total slack) v D tr ring phn (Free slack). c c 2 thng tin ny bn ch vic to thm ct bng cch s dng Add new column nh mc bn trn.

Total slack v Free slack khc nhau th no?

- Total slack: l thi gian d tr ton phn, l khong thi gian m cng vic c th hon khi cng so vi thi im bt u sm (Start) m khng nh hng ti thi gian thc hin ca ton b d n.

- Free slack: l thi gian d tr ring phn, l khong thi gian m cng vic c th tr hon khi cng m khng nh hng n thi im khi cng sm (Start) ca cng vic ng sau n.

Bn cng c th xem c thng tin ca mc 4,5 m khng cn thm Add thm ct bng cch: Ti khung nhn Gantt chart chn menu View/Table/Schedule (Qu tuyt vi phi khng???)




Xem Late Start, Late Finish, Free Slack, Total Slack

Chng ta s bn ti ng dng ca Total slack v Free slack khi iu ha tin trong Phn Nng cao nh ^^.

6/ Xem cng tc gng

Trong qun l d n, vic xc nh cng tc gng l cng vic tin quyt. V mun d n ng tin th chng ta phi bit cng tc no l cng tc gng, v qun l chng tht tt cng vic din ra ng nh tin nh

xem cc cng tc gng, c 2 cch:

* Cch 1: Format/Bar styles click chn Critical tasks

Xem ng gng d n (cch 1)




* Cch 2: Click chut phi vo khu vc tin ngang chn Show/Hide Bar styles/ Critical Tasks

Xem ng gng d n (cch 2)

Khi bn s thy tt c cc cng tc gng s bin thnh mu .

II NHP S LIU TI NGUYN

Sau khi c c tin , chng ta tip tc gn ti nguyn cho cc cng tc. Trong MP 2010 c 3 loi ti nguyn m chng ta cn nm r l: Nhn lc (Work), Vt liu (Material) v chi ph (Cost).

- Nhn lc: l my mc, con ngi; chi ph ph thuc thi gian thi cng

- Vt t: Ct , xi mng, b tng, st thp; chi ph khng ph thuc thi gian thi cng

- Chi ph: l loi ti nguyn ch c lit k (trong Resource sheet) v phi nhp chi ph trc tip khi gn cho cng vic. V d chi ph Lu tr

Khi qun l c ti nguyn trong MP chng ta c th bit:

- Kh nng thiu thn ti nguyn cc thi im v c k hoch ng ph trc

- Nhu cu ti nguyn cn cung cp mi thi im, c k hoch cung ng v iu chnh ph hp. (Dng s liu m MP cung cp k hp ng nguyn tc cung ng vi cc nh cung ng)




- Xc nh c chi ph cho tng cng vic v ton b d n

- Nhu cu v ti chnh cho tng thi im cng nh ton d n m bo ngun ti chnh thc hin d n.

1/ Khai bo ngun lc trong Resource sheet

Chng ta tip tc vi v d d liu n nh phn I.

Bng 2.1 - D liu ti nguyn s dng

STT Cng tc Nhn cng Vt t My mc 1. Cng tc chun b NC[15] 2. Khi cng 3. o t t 1 bng my NC[5] MayDD[1] 4. Thi cng p cc NC[10] CocBTCT[160md] MayEC[1] 5. o t t 2 bng my NC[5] MayDD[1] 6. o t bng th cng NC[8] 7. Cng tc khc NC[10] 8. b tng lt mng NC[8] BT46[3m3] MayD[2] 9. GCLD Cp pha mng NC[10] CP[50m2] 10. GLLD Ct thp mng NC[12] Thep[2Tan] 11. b tng mng NC[10] BT12[20m3] MayD[2] 12. Bo dng b tng mng NC[2] 13. Tho d Cp pha mng NC[12] 14. GCLD Ct thp ct T1 NC[14] Thep[0.5Tan] MayH[1] 15. GCLD Cp pha ct T1 NC[16] CP[24m2] MayH[1] 16. b tng ct T1 NC[10] BT12[1.5m3] MayD[1] 17. Tho vn khun ct T1 NC[16] 18. GCLD Cp pha dm sn T1 NC[16] CP[60m2] 19. GCLD Ct thp dm sn T1 NC[14] Thep[1Tan] 20. b tng dm sn T1 NC[10] BT12[5m3] MayD[2] 21. Bo dng b tng dm sn T1 NC[2] 22. GCLD Ct thp ct T2 NC[14] Thep[0.5Tan] MayH[1] 23. GCLD Cp pha ct T2 NC[16] CP[24m2] MayH[1] 24. b tng ct T2 NC[10] BT12[1.5m3] MayD[1] 25. Tho vn khun ct T2 NC[16]




26. GCLD Cp pha dm sn T2 NC[16] CP[60m2] 27. GCLD Ct thp dm sn T2 NC[14] Thep[1Tan] 28. b tng dm sn T2 NC[10] BT12[5m3] MayD[2] 29. Bo dng b tng dm sn T2 NC[2] 30. Tho vn khun dm sn T1 NC[16] 31. Tho vn khun dm sn T2 NC[16] 32. Khoan rt li kim tra CL b

tng NC[5] TBK[1]

Bng 2.2 - Chi ph s dng ti nguyn

Ti nguyn Chi ph Thm gi

K hiu Tn y NC Nhn cng 180.000/d 50.000/h

MayDD My o t 200.000/h MayD My m 150.000/h TBK Thit b khoan 1.000.000

MayH My hn 100.000/h Thep Thp 18.000.000/Tan BT46 B tng 4x6 550.000/m3 BT12 B tng 1x2 760.000/m3

CocBTCT Cc B tng ct thp 180.000/md CP Cp pha 15.000/m2

MayEC My p cc 200.000/h

Notes: S lng ti nguyn mi cng tc, Chi ph cho mi ti nguyn c th tham khobng cch s dng cc phn mm d ton GXD hay phn mm tnh gi ca my GXD

Khai bo d liu trong bng trn vo Resource sheet




Khung nhn Resource Sheet khai bo thng tin cc ti nguyn

Trong :

- Resource Name: nhp tn ti nguyn

- Type: la chn c im phn loi trong 3 loi ti nguyn (work, material, cost)

- Material Label: n v o lng ca vt t, do bn t nh ngha

- Initials: k hiu ti nguyn m bn mun hin th

- Group: chng ta c th chn cc ti nguyn c cng c im thnh mt nhm. Sau ny c th lc (filter) theo nhm. V d: Ct vng, ct en, xi mng vo mt nhm lc ra t hng vi 1 nh cung cp (V d t l nhm CX).

- Max Units: lng ti nguyn c th cung cp ti a (ch p dng cho loi ti nguyn dng work)

- Std Rate: chi ph s dng ti nguyn chun. Vi ti nguyn dng work s ch chi ph trn thi gian s dng (gi cng, ngy cng). Vi ti nguyn dng Material th ch chi ph s dng trn n v ti nguyn (m3, tn, m2) - Ovt. Rate: chi phsi lm vic ngoi gi. (Ch p dng cho ti nguyn dng work) - Cost/Use: chi ph 1 ln s dng ti nguyn. V d khi s dng cn trc thp 500.000/h nhng khi mun s dng n th mi ln phi mt 10.000.000 lp dng. - Accrue At: xc nh cch m MP tnh chi ph s dng ti nguyn ca mt cng vic. C 3 cch tnh l:




+ Start: MP tnh chi ph s dng ti nguyn ngay khi bt u

+ End: MP tnh chi ph s dng ti nguyn ngay khi kt thc

+ Prorated (mc nh): MP tnh chi ph s dng ti nguyn t l vi khi lng cng tc hon thnh. (la chn ny hon ton ph hp vi thc t)

- Base calendar: l lch d n m MP s s dng phn phi ti nguyn. (C th khc vi lch lm vic ca d n) - Code: c th s dng ct ny nh du k hiu ti nguyn. Rt hu dng khi mun lc ti nguyn (filter). Chng ta c th hiu chnh nhanh cc ti nguyn bng Resource Information. Ti khung nhn Resource sheet chn 1 ti nguyn ri chn Resource/Information (hoc click p vo ti nguyn ) Trong tab Genaral bn c th la chn trong Book Type: Committed (ti nguyn chnh thc c s dng cho d n), Proposed (ti nguyn ch l xut s dng, khng c MP tnh ton). Nu ti nguyn thuc loi Work th s c thm la chn thi gian sn c trong Resource Availability.

Hiu chnh thng tin cc ti nguyn bng Resource Information

Bn cng c th thm ghi ch cho ti nguyn trong tab Notes d qun l

2/ Phn b ti nguyn cho cng vic

Sau khi to y danh sch ti nguyn cho d n trong Resource Sheet chng ta s gn chng cho cc cng vic trong d n. C nhiu cch gn (phn b) ti nguyn cho cng vic (bn cht ging nhau nhng cch thc thc hin khc nhau).




Khung nhn Gantt chart sau khi phn b ti nguyn cho cc cng tc

* Cch 1: Phn b ti nguyn bng ca s Task Information

Click chut tri vo cng vic, ca s Task Information bt ln chn tab Resources ri chn ti nguyn cn phn b (Resource Name) v s lng cn phn b (Units). MP s t ng tnh ton ra Cost.

* Cch 2: Phn b ti nguyn bng ca s Assign Resources

Vo menu Resource chn Assign Resources (hoc n Alt + F10) ca s Assign Resources xut hin tng t Cch 1 chn ti nguyn cn phn b (Resource Name) v s lng cn phn b (Units). MP s t ng tnh ton ra Cost.

* Cch 3: Phn b ti nguyn bng ca s Show Split

Click chut phi vo khu vc biu Gantt chn Show Split, sau click chn cng vic, ri chn ti nguyn v s lng nh trn (Nu bn nh ID ca tng ti nguyn th cch lm ny s rt nhanh. Ti hay s dng cch ny)




* Cch 4: Khai bo bng cch g trc tip vo ct Resource Names theo cu trc sau:

Tn ti nguyn[s lng]

Tuy nhin cch 4 ny rt t ngi s dng!

3/ Xem xt phn b ti nguyn

Sau khi phn b ti nguyn cho mi cng vic, chn khung nhn Resource Usage xem xt tng qut ti nguyn c phn b vo nhng cng tc no (Theo di ti nguyn trn Resource Usage rt hu ch nu bn c 1 ti nguyn c bit no , v mun xem xem ti nguyn c c phn b vo cng tc no, lm vic ht nng sut cha. V d 1 k s chuyn x l s c cng trng chng hn)

Khung nhn Resource Usage khi cha kt hp View

Trong khung nhn Resource Usage, bn vo menu View/Table ri chn mt s cch xem thng tin ti nguyn:

- View/Table/Cost: cho bit thng tin chi ph ca tng ti nguyn, v chi ph ca cc ti nguyn cho tng cng tc. (Bn cng c th nhp chi ph cho loi ti nguyn dng Cost ti y nh trn u ca phn II cp)

- View/Table/Summary: cho bit thng tin chi ph, gi cng ca tng ti nguyn, v chi ph, gi cng ca cc ti nguyn cho tng cng tc.




- View/Table/Work: cho bit thng tin v s gi cng ca tng ti nguyn, s gi cng thc hin, v s gi cng cn li (Remaining)

Khung nhn Resource Usage khi kt hp vi cc tab trong Table ca menu View

4/ Xem biu phn b ti nguyn

Chn khung nhn Resouce Graph, cun chut thay i cc biu ca tng ti nguyn.

Vi mi biu ti nguyn bn c th chn nhiu cch xem thng tin bng cch click chut phi vo biu : xem s lng ti a ca mi ti nguyn (peak units), xem s cng (work), xem cng tch ly (cumulative work), xem phn phi vt kh nng (overallocation), chi ph (cost), chi ph tch ly (cumulative cost).




Biu nhn lc xem di dng cng (h cng)

5/ Xem chi tit cng vic c phn b ti nguyn

Bn trn chng ta s dng Resource Usage xem xt cc ti nguyn c dng vo nhng cng vic g. Cn y chng ta li lm ngc li xem cc cng vic s dng nhng ti nguyn g bng cch dng Task Usage.

Trong khung nhn Task Usage, chn View/Table/Summary ta s thy ct chi ph cho cc ti nguyn tng cng tc. V y chng ta c th thm vo chi ph cho loi ti nguyn dng Cost nh cp phn u ca mc II (trong v d l chi ph cho Thit b khoan TBK cng tc cui cng)

Xem chi tit cng vic c phn b ti nguyn




6/ Gn chi ph c nh cho cng tc

Ti khung nhn Gantt chart chn menu View/Table/Cost

Nhp chi ph c nh cho tng cng tc ti ct Fixed cost v cch phn b fixed cost trn thi gian ca cng tc ti ct Fixed cost accrural (c 3 la chn)

Khi :

Gi tr Total cost = Gi tr Fixed cost + Chi ph s dng ti nguyn ca cng tc

Gi s trong d n trn c 1 s chi ph c nh cho cc cng tc sau:

Bng chi ph c nh ca cc cng tc

Cng tc Fixed Cost Chun b 500.000

b tng mng 1.000.000 b tng ct T1 1.000.000

b tng dm sn T1 2.000.000 b tng ct T2 1.000.000

b tng dm sn T2 2.000.000




Mn hnh nhp chi ph c nh cho cng tc

xem thng tin chung v d n nh: ngy bt u, ngy kt thc, chi ph k hoch, chi ph cn li bn vo menu Project/Project Information/Statistics

Thng tin chung v d n trong Project Statistics

hdsdmicrosoftproject2010-nhpdliu-140628120225-phpapp01.pdf

Documents

Transcript of hdsdmicrosoftproject2010-nhpdliu-140628120225-phpapp01.pdf