Overhead in the Project Budget: Implementation Activity

The following implementation activity will walk you through the process of configuring an allocation rule for capturing the overhead for projects.

Attention: This activity is based on the U100 dataset. If you are using another dataset, or if any system settings have been changed in U100, these changes can affect the workflow of the activity and the results of the processing. To avoid any issues, restore the U100 dataset to its initial state.

Story

Suppose that the project manager of the SweetLife Fruits & Jams company wants to estimate the project costs considering the administrative overhead of the project management to be able to estimate the project profitability more accurately. The company estimates the project overhead as 20% of labor costs, such as a worker's time spent on performing the project.

Acting as SweetLife’s implementation manager, you need to configure an allocation rule to capture the project overhead as 20% of labor costs to reflect the overhead in the project budget. Because the administrative overhead is already presented in the general ledger in the form of transactions that are not classified against projects, you do not need to post to the general ledger allocation transactions that are created.

Configuration Overview

In the U100 dataset, the following tasks have been performed for the purposes of this activity:

  • On the Enable/Disable Features (CS100000) form, the Project Accounting feature has been enabled to support the project accounting functionality.
  • On the Account Groups (PM201000) form, the OVERHEAD and LABOR account groups have been created.

Process Overview

You will configure an allocation rule for capturing the labor overhead on the Allocation Rules (PM207500) form.

System Preparation

To prepare to perform the instructions of the activity, sign in to a company with the U100 dataset preloaded; you should sign in as system administrator by using the gibbs username and the 123 password.

Step: Configuring an Allocation Rule

To configure an allocation rule used for capturing the project overhead as a percentage of labor costs, perform the following instructions:

  1. On the Allocation Rules (PM207500) form, add a new record.
  2. In the Summary area, specify the following settings:
    • Allocation Rule: LABOVERHEAD
    • Description: Labor overhead
  3. In the left pane, add a row for the allocation rule step with the following settings:
    • Step ID: 10
    • Description: Labor
  4. In the right pane, on the Calculation Rules tab, specify the following settings of the step selected in the left pane:
    • Allocation Method: Allocate Transactions
    • Create Allocation Transaction: Selected
    • Select Transactions (Selection Criteria section): Non-Allocated Transactions
    • Account Group From (Selection Criteria section): LABOR
    • Account Group To (Selection Criteria section): Empty

      Based on this setting and the previous setting, with this step, the allocation rule processes only transactions of the LABOR account group.

    • If @Rate is Not Defined (Rate Settings section): Set @Rate to 0

      You will not use rates to calculate the amount of the allocation transaction.

    • Quantity Formula (Calculation Settings section): =0
    • Billable Qty. Formula (Calculation Settings section): =0
    • Amount Formula (Calculation Settings section): =[PMTran.Amount]*0.2

      You calculate the overhead amount as 20% of the transaction amount.

    • Description Formula (Calculation Settings section): ='Project overhead for labor'
  5. In the right pane, on the Allocation Settings tab, specify the following settings of the step selected in the left pane:
    • Post Transaction to GL (Transaction Options section): Cleared
    • Reverse Allocation (Transaction Reversal section): Never

      The project overhead is not considered in billing and you do not need to create reversing allocation transactions.

    • Account Group (Debit Transaction section): Replace with OVERHEAD

      With this setting, the system generates an allocation transaction that debits the specified account group—that is, the OVERHEAD account group.

    • Account Group (Credit Transaction section): None
  6. Save the created allocation rule.

You have configured the allocation rule that can be used for capturing the project overhead as 20% of labor costs. To allocate the labor expenses of a project by using this rule, you need to assign the rule to the project tasks.

To review how a project is being allocated by using the allocation rule, complete Overhead in the Project Budget: Process Activity.