澳门皇冠|足球比分

                                     

                                    The original version of this paper was published here in May 2009:
                                    See S-curve/intro.htm

                                    This 4th Edition was submitted for publication in January 2019.
                                    It is copyright © Midori Media.
                                    Published here September 2019.

                                    PART 2 | Worked Example | Generating Percentage S‑curves
                                    Using Task Duration as a Quantity | PART 4

                                    Worked Example

                                    To better understand how S-curves are generated, consider a simple Project consisting of five Tasks. The first Task is a Summary Task, and thus must be ignored. The remaining four Tasks are Detail Tasks. Please note that although this worked example will only consider Man Hours, the calculations shown below are identical if Cost is used in lieu of Man Hours.

                                    A Baseline Schedule prepared using MS Project for the example project is shown below.

                                    Figure 9: Sample Baseline Schedule
                                    Figure 9: Sample Baseline Schedule

                                    Baseline Man Hours versus Time S‑curve

                                    To generate a Baseline Man Hours versus Time S-curve, two sets of calculations are required.

                                    The first set of calculations are performed for each Task in the Baseline Schedule.

                                    (1)  Calculate the Duration in Days for each Task
                                    Baseline Duration = Baseline Finish Date - Baseline Start Date + 1

                                    (2)  Calculate Man Hours per Day for each Task
                                    Baseline Man Hours per Day = Baseline Man Hours / Baseline Duration

                                    These calculations are shown below.

                                    Task Name

                                    Baseline Start

                                    Baseline Finish

                                    Baseline Man Hours

                                    Baseline Duration (1)

                                    Baseline MH per Day (2)

                                    Task No. 1

                                    01‑Feb‑2016

                                    02‑Feb‑2016

                                    12.0

                                    2

                                    6

                                    Task No. 2

                                    02‑Feb‑2016

                                    04‑Feb‑2016

                                    24.0

                                    3

                                    8

                                    Task No. 3

                                    03‑Feb‑2016

                                    04‑Feb‑2016

                                    30.0

                                    2

                                    15

                                    Task No. 4

                                    04‑Feb‑2016

                                    05‑Feb‑2016

                                    24.0

                                    2

                                    12


                                    Totals

                                     

                                     

                                    90.0

                                     

                                     

                                    Table 4: Baseline S‑curve Calculation 1 of 2

                                    The second set of calculations are performed for each Day in the Baseline Schedule.

                                    (3)  Calculate the total Man Hours per Day for all Tasks

                                    (4)  Calculate the Year To Date Total for Man Hours per Day for all Tasks

                                    These calculations are shown below.

                                    Task / Date

                                    01‑Feb‑2016

                                    02‑Feb‑2016

                                    03‑Feb‑2016

                                    04‑Feb‑2016

                                    05‑Feb‑2016

                                    Task No. 1

                                    6.0

                                    6.0

                                    --

                                    --

                                    --

                                    Task No. 2

                                    --

                                    8.0

                                    8.0

                                    8.0

                                    --

                                    Task No. 3

                                    --

                                    --

                                    15.0

                                    15.0

                                    --

                                    Task No. 4

                                    --

                                    --

                                    --

                                    12.0

                                    12.0


                                    Totals per Day (3)

                                    6.0

                                    14.0

                                    23.0

                                    35.0

                                    12.0


                                    YTD Totals (4)

                                    6.0

                                    20.0

                                    43.0

                                    78.0

                                    90.0

                                    Table 5: Baseline S‑curve Calculation 2 of 2

                                    The Baseline S-curve is constructed by assigning the Baseline dates to the X axis, and the Year To Date (YTD) values to the Y axis. The resulting Baseline Man Hours versus Time S‑curve is shown below.

                                    Figure 10: Baseline Man Hours versus Time S-curve
                                    Figure 10: Baseline Man Hours versus Time S‑curve

                                    Please note that the Totals per Day values may be used to generate a Baseline Man Hours Histogram by assigning the dates to the X axis, and the Totals per Day values to the Y axis, as shown below.

                                    Figure 11: Baseline Man Hours versus Time Histogram
                                    Figure 11: Baseline Man Hours versus Time Histogram

                                    Target Man Hours versus Time S‑curve

                                    To generate the Actual and Target S-curves, a Production Schedule is required. For the purpose of this example, the Production Schedule will contain the same five Tasks (one Summary Task, four Detail Tasks) as the Baseline Schedule. Once again, the Summary Task must be ignored to ensure the calculations are accurate.

                                    A Production Schedule for the example Project is shown below.

                                    Figure 12: Sample Production Schedule
                                    Figure 12: Sample Production Schedule

                                    Note this schedule contains the Baseline data from the Production Schedule. This allows Baseline S‑curves to be generated from the Production Schedule.

                                    To generate a Target Man Hours versus Time S‑curve, two sets of calculations are performed.

                                    The first set of calculations are performed for each Task in the Production Schedule.

                                    (1)  Calculate the Duration in Days for each Task
                                    Duration = Finish Date - Start Date + 1

                                    (2)  Calculate Man Hours per Day for each Task
                                    Man Hours per Day = Man Hours / Duration

                                    These calculations are shown below.

                                    Task Name

                                    Start

                                    Finish

                                    Man Hours

                                    % Complete

                                    Duration (1)

                                    MH per Day (2)

                                    Task No. 1

                                    02‑Feb‑2016

                                    03‑Feb‑2016

                                    14.0

                                    100%

                                    2

                                    7.0

                                    Task No. 2

                                    02‑Feb‑2016

                                    05‑Feb‑2016

                                    30.0

                                    20%

                                    4

                                    7.5

                                    Task No. 3

                                    04‑Feb‑2016

                                    06‑Feb‑2016

                                    36.0

                                    50%

                                    3

                                    12.0

                                    Task No. 4

                                    05‑Feb‑2016

                                    07‑Feb‑2016

                                    15.0

                                    0%

                                    3

                                    5.0


                                    Totals

                                     

                                     

                                    95.0

                                     

                                     

                                     

                                    Table 6: Target S‑curve Calculation 1 of 2

                                    Target Man Hours versus Time S-curve (Continued)

                                    The second set of calculations are performed for each Day in the Production Schedule.

                                    (3)  Calculate the total Man Hours per Day for all Tasks

                                    (4)  Calculate the Year To Date Total for Man Hours per Day for all Tasks

                                    These calculations are shown below.

                                    Task / Date

                                    01‑Feb-2016

                                    02‑Feb-2016

                                    03‑Feb-2016

                                    04‑Feb-2016

                                    05‑Feb-2016

                                    06‑Feb-2016

                                    Task No. 1

                                    7.0

                                    7.0

                                    --

                                    --

                                    --

                                    --

                                    Task No. 2

                                    7.5

                                    7.5

                                    7.5

                                    7.5

                                    --

                                    --

                                    Task No. 3

                                    --

                                    --

                                    12.0

                                    12.0

                                    12.0

                                    --

                                    Task No. 4

                                    --

                                    --

                                    --

                                    5.0

                                    5.0

                                    5.0


                                    Totals per Day (3)

                                    14.5

                                    14.5

                                    19.5

                                    24.5

                                    17.0

                                    5.0


                                    Year to Date Total (4)

                                    14.5

                                    29.0

                                    48.5

                                    73.0

                                    90.0

                                    95.0

                                    Table 7: Target S‑curve Calculation 2 of 2

                                    The Target S-curve is constructed by assigning the dates to the X axis, and the Year To Date (YTD) values to the Y axis. The resulting Target Man Hours versus Time S‑curve is shown below.

                                    Figure 13: Target Man Hours versus Time S-curve (Showing Baseline S‑curve For Comparison
                                    Figure 13: Target Man Hours versus Time S‑curve (showing Baseline S‑curve for Comparison)

                                    Please note that the Totals per Day values may be used to generate a Target Man Hours Histogram by assigning the dates to the X axis, and the Totals per Day values to the Y axis, as shown below.

                                    Figure 14: Target Man Hours versus Time Histogram (Showing Baseline Histogram For Comparison)
                                    Figure 14: Target Man Hours versus Time Histogram (showing Baseline Histogram for Comparison)

                                    Actual Man Hours versus Time S-curve

                                    To generate an Actual Man Hours versus Time S‑curve, two sets of calculations are performed. Before these calculations may be performed, the Cut Off Date needs to be defined. This is the date the Project's Tasks were last physically inspected to determine their % complete status. For this example a Cut Off Date of the 4th of February, 2016 will be used.

                                    The first set of calculations are performed for each Task in the Production Schedule.

                                    (1)  Determine the Task Status: Finished, In Progress, Not Started.
                                    •  Finished: Tasks that have a Finish Date prior to the Cut Off Date.
                                    •  In Progress: Tasks that have started and have a Finish Date on or after the Cut Off Date.
                                    •  Not Started: Tasks that have a Start Date after the Cut Off Date.

                                    (2)  Calculate the Duration to Date based on the Task Status.
                                    •  Finished: Duration To Date = Finish Date - Start Date + 1
                                    •  In Progress: Duration To Date = Cut Off Date - Start Date + 1
                                    •  Not Started: Duration To Date = 0

                                    (3)  Calculate Man Hours to Date for Finished and Ongoing Tasks.
                                    Man Hours to Date = (Man Hours x % Complete) / Duration to Date

                                    As discussed above in the Target S‑curve calculations, the total Task Man Hours to complete the Task are required.

                                    In this worked example, the Production Schedule contains total Task Man Hours.

                                    The required calculations are shown below.

                                    Task Name

                                    Start

                                    Finish

                                    Man
                                     Hours

                                    % Complete

                                    Status (1)

                                    Duration
                                    to Date (2)

                                    MH x % complete
                                    Duration to Date (3)

                                    Task No. 1

                                    02‑Feb-2016

                                    03‑Feb-2016

                                    14.0

                                    100%

                                    Finished

                                    2

                                    7.0

                                    Task No. 2

                                    02‑Feb-2016

                                    05‑Feb-2016

                                    30.0

                                    20%

                                    In Progress

                                    3

                                    2.0

                                    Task No. 3

                                    04‑Feb-2016

                                    06‑Feb-2016

                                    36.0

                                    50%

                                    In Progress

                                    1

                                    18.0

                                    Task No. 4

                                    05‑Feb-2016

                                    07‑Feb-2016

                                    15.0

                                    0%

                                    Not Started

                                    0

                                    0.0


                                    Totals

                                    95.0

                                    Table 8: Actual S-curve Calculation 1 of 2

                                    The second set of calculations is performed for each Day in the Production Schedule up to the Cut Off Date.

                                    (4)  Calculate the total Man Hours to Date per Day for all Tasks

                                    (5)  Calculate the Year To Date Total for Man Hours to Date per Day for all Tasks

                                    These calculations are shown below.

                                    Task / Date

                                    02‑Feb-2016

                                    03‑Feb-2016

                                    04‑Feb‑2016

                                    05‑Feb-2016

                                    06‑Feb-2016

                                    07‑Feb-2016

                                    Task No. 1

                                    7.0

                                    7.0

                                    --

                                    --

                                    --

                                    --

                                    Task No. 2

                                    2.0

                                    2.0

                                    2.0

                                    --

                                    --

                                    --

                                    Task No. 3

                                    --

                                    --

                                    18.0

                                    --

                                    --

                                    --

                                    Task No. 4

                                    --

                                    --

                                    --

                                    --

                                    --

                                    --


                                    Totals per Day (4)

                                    9.0

                                    9.0

                                    20.0

                                    --

                                    --

                                    --


                                    YTD Totals (5)

                                    9.0

                                    18.0

                                    38.0

                                    --

                                    --

                                    --

                                    Cut Off Date:   04-Feb-2016

                                    Table 9: Actual S‑curve Calculation 2 of 2

                                    The resulting Actual Man Hours versus Time S‑curve is shown in Figure 15.

                                    Figure 15: Actual Man Hours versus Time S‑curve (showing Baseline S-curve for Comparison)
                                    Figure 15: Actual Man Hours versus Time S‑curve (showing Baseline S‑curve for Comparison)

                                    Please note that the Totals per Day values may be used to generate an Actual Man Hours Histogram by assigning the dates to the X axis, and the Totals per Day values to the Y axis, as shown in Figure 16.

                                    Figure 16: Actual Man Hours versus Time Histogram (showing Baseline Histogram for Comparison)
                                    Figure 16: Actual Man Hours versus Time Histogram (showing Baseline Histogram for Comparison)

                                    The Baseline, Actual, and Target S-curves may be combined, as shown in Figure 17.

                                    Figure 17: Man Hours versus Time S-curves
                                    Figure 17: Man Hours versus Time S-curves
                                    PART 2  PART 2

                                    Home | Issacons | PM Glossary | Papers & Books | Max's Musings
                                    Guest Articles | Contact Info | Search My Site | Site Map | Top of Page

                                                                      explore

                                                                      explore

                                                                      news

                                                                      video

                                                                      Technology

                                                                      Second-hand housing

                                                                      search for

                                                                      news

                                                                      aviation