Schedule Development#

Overview

Assigning Budgets#

Coming... Use the Budget (Hrs) column. Check for Budget Issues.

Assigning Non-Standard Capacity#

The capacity of resources is assumed to be 8 hours per day. Where this differs for a particular activity - such as for a 12 hour day on site - set the Non-Standard Capacity column on the activity accordingly (eg "12").

Why?

Budgeted work (ie activities with an assigned budget) is assigned to resources at the project activity level. This is known as "resource assignment". The total work assigned to a resource at any point in time, versus that resource's capacity (generally based on 8 hours/day), can be considered the "resource loading". The standard GTE Smartsheet schedule template calculates this loading, as a percentage, at the budgeted activity level as follows, and the accuracy of this calculation is important for its use in Resource Management.

= IFERROR(
    (
        [Budget (hrs)]@row / Duration@row) / ( COUNTM([Resource(s)]@row) 
            * IF(
                [Non-Standard Capacity]@row <> "", 
                [Non-Standard Capacity]@row, 8
            )
    ), 
    ""
)

Setting Activity Durations#

Setting Activity Timing & Sequencing#

Resource Assignment#

Cost Coding#

Cost units are designated by applying cost codes to activities or summaries in the project schedule within Smartsheet. Each cost unit is created in the cost tracking system for resource costings to be assigned to, and these then become the project control accounts.

Where applicable, activities at any level of the WBS must be coded as an element of the project Cost Breakdown Structure in the "Cost Code" column of the project schedule in Smartsheet. The level(s) at which cost assignments are made, and name of the cost units, must be in accordance with the guidance in Cost Management.