Scribd Logo
Upload

Welcome to Scribd!

  • 9 views

    Exercise On Schedule KPIs

    Uploaded by

    Ammar Ali Yasir

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Exercise On Schedule KPIs

    Uploaded by

    Ammar Ali Yasir
    9 views12 pages

    Original Title

    Exercise on Schedule KPIs

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    9 views12 pages

    Exercise On Schedule KPIs

    Uploaded by

    Ammar Ali Yasir

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 12

    Concrete rather than Cement

    Formwork Planning not done in schedule


    BOQ based cost loading

    Move Concrete to Resource Head


    How to consider the revisions of Submittals and EOTs
    Unapproved variations and Submittals?

    Budget vs Reimbusrement

    S Curve
    MP Histogram

    Standard Productivities
    MHRs loading conflcits

    Revised Schedules after every 3 or 4 Months


    Remaining Works Schedule including anticipated variations

    Discipline wise Activity Codes


    10 100
    SVw Ok
    SPIw
    SVt P6 cannot calculate automatically but we can be calculated manually
    SPIt P6 cannot calculate automatically
    TSPIw P6 cannot calculate automatically
    TSPIt P6 cannot calculate automatically

    SRI can be calculated Manually Total Revisions / Total Quarters till Date
    EACt

    ETC=SAC-ES/SPIt Add in the KPI Sheet


    EACt=AT+ETCt
    VAC=SAC-EACt

    SCI Review
    Net variations Changed the formula
    Review Provisional Payments
    Exercise Months / Days
    Exercise Months / Days
    Exercise 24
    Exercise

    10

    Changed the word oiginal instead of final Contract Verify the source of the frmula
    Nishtar II Multan

    BAC, Budget at Completion 4,924,188,841

    Planned Progress 54.04%

    Actual Progress 18.93%

    Planned Start Date 30/Dec/19

    Planned Finish Date 29/Jun/22

    Anticipated Finish Date 13/Oct/23 1383.00

    Original Project Duration 913

    Anticipated Project Duration 1384

    Data Date 28/Jul/21

    SAC, Schedule at Completion 30.0

    Actual Time = DD - PS 19.0

    Eearned Schedule 12.6

    PV, BCWS = BAC x Planned % 2,661,031,649.68

    EV, BCWP = BAC x Actual % 932,148,947.60

    SPIw, Schedule Performance Index = EV/PV 0.35

    Work Based SVw, Schedule Variance = EV - PV (1,728,882,702.08)

    TSPIw=(BAC - EV)/ (BAC - PV) 1.76

    SPIt, Schedule Performance Index (time) = ES/AT 0.66 Months

    TIme Based SVt, Schedule Variance = ES - AT (6.41) Months

    TSPIt=(BAC - EV)/ (BAC - PV) 1.76

    ETCt = (SAC - ES)/SPIt 26.37 Months

    EACt = SAC / SPIt 45.35 Months

    EACt = ETCt + AT 45.35 Months

    VACt = SAC - EACt (15.32) Months


    45.49
    1 2 3 4 5 6
    Months Dec/19 Jan/20 Feb/20 Mar/20 Apr/20 May/20
    Planned Cost 3,053.12 2,736,431.56 31,045,522.73 115,216,320.30 127,357,159.96 88,723,910.37
    Cumulative Cost 3,053.12 2,739,484.68 33,785,007.41 149,001,327.71 276,358,487.67 365,082,398.04

    Planned % 0.00% 0.06% 0.63% 2.34% 2.59% 1.80%


    Cumulative % 0.00% 0.06% 0.69% 3.03% 5.61% 7.41%
    7 8 9 10 11 12
    Jun/20 Jul/20 Aug/20 Sep/20 Oct/20 Nov/20
    94,119,230.83 91,517,586.42 92,827,253.83 88,780,995.20 66,066,437.76 73,525,158.60
    459,201,628.87 550,719,215.29 643,546,469.12 732,327,464.32 798,393,902.08 871,919,060.68

    1.91% 1.86% 1.89% 1.80% 1.34% 1.49%


    9.33% 11.18% 13.07% 14.87% 16.21% 17.71%

    12.57
    Dec/20 Jan/21 Feb/21 Mar/21 Apr/21 May/21
    104,802,073.31 130,763,991.52 184,197,632.01 227,992,837.49 237,834,288.84 305,786,960.46
    976,721,133.99 1,107,485,125.51 1,291,682,757.52 1,519,675,595.01 1,757,509,883.85 2,063,296,844.31

    2.13% 2.66% 3.74% 4.63% 4.83% 6.21%


    19.84% 22.49% 26.23% 30.86% 35.69% 41.90%

    18.93%
    1.22%
    2.13%
    0.07%
    17.2410387559 0.574701291864

    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    0.07%
    Jun/21 Jul/21 Aug/21 Sep/21 Oct/21 Nov/21
    319,115,230.07 327,113,671.19 299,799,036.49 218,418,334.32 217,896,457.19 201,852,127.96
    2,382,412,074.38 2,709,525,745.57 3,009,324,782.06 3,227,743,116.38 3,445,639,573.57 3,647,491,701.53

    6.48% 6.64% 6.09% 4.44% 4.43% 4.10%


    48.38% 55.02% 61.11% 65.55% 69.97% 74.07%
    Dec/21 Jan/22 Feb/22 Mar/22 Apr/22 May/22
    168,961,167.66 225,268,790.23 95,536,936.43 198,814,711.91 247,140,391.28 279,169,099.28
    3,816,452,869.19 4,041,721,659.42 4,137,258,595.85 4,336,073,307.76 4,583,213,699.04 4,862,382,798.32

    3.43% 4.57% 1.94% 4.04% 5.02% 5.67%


    77.50% 82.08% 84.02% 88.06% 93.08% 98.74%
    Jun/22
    61,806,042.68
    4,924,188,841.00

    1.26%
    100.00%

    You might also like