Cost Tab

The Cost tab calculates the estimated work cost based on the resources designated. It also tracks the actual work cost based on related work orders in the system. In doing so, the system breaks down these costs by category. Certain calculated fields are described in the table below:

Note: Many of the calculations in this tab are dependent on items in the Setup and Resources tabs. You must first enter Setup information and Resources in order to obtain accurate results.

Field Name

Definition

Est Cost

monthly fields

The projected costs of completing the task. The system automatically completes the monthly fields based on the unit cost of the resources identified on the Resources tab.

Actual Cost

monthly fields

The true cost of completing the task, as determined by cost data entered in related work orders.

Note: The work orders must have:

  • The same Department, Division, Sub-Division, Area, and Sub-Area as the Task.
  • The Start Date and End Date must fall within the same fiscal year as the Task.
  • The Planning Task must be added to the work orders' Task grid.
  • Resources must be assigned to the Planning Task.

Est Cost: TOTAL

The sum of all of the Est Cost fields.

Actual Cost: TOTAL

The sum of all of the Actual Cost fields.

Actual YTD Amounts

  • Labor $
  • Equipment $
  • Contractor $
  • Material $
  • Fluid $
  • Misc $

The total costs for labor, materials, equipment, fluids, contractors, and other miscellaneous items associated with the task. These amounts are calculated using data from actual work orders in he system.

Note: The work orders must have:

  • The same Department, Division, Sub-Division, Area, and Sub-Area as the Task.
  • The Start Date and End Date must fall within the same fiscal year as the Task.
  • The Planning Task must be added to the work orders' Task grid.
  • Resources must be assigned to the Planning Task.

Remaining Budget

The amount of budget remaining for the task for the fiscal year. Calculated as: Est Cost: TOTAL - Actual Cost: TOTAL.

% of Budget Used

The percent of the budget that has been spent thus far in the fiscal year. Calculated as: (Actual Cost: TOTAL / Est Cost: TOTAL) x 100.

% Over/Under

The amount over or under the budget the entity is at this point in the fiscal year related to completing this task. A value < 1 means the task is below budget for the amount of year that has passed. A value > greater than ones means the task is above budget for the amount of year that has passed.

This value is calculated using the following criterion and formula:

  • The system retrieves the % of FY Completed value from the Fiscal Year module > General tab.
  • % of Budget Used/% of FY Completed

See Also

Task

Planning Tasks Header Data

Setup Tab

Resources Tab

Quantity Tab

Labor Days Tab

WOs Tab

Specific Guidelines Tab

Custom Tab(s)

Comments Tab

Toolkit