Cost Account Allocation Grid

A parent line item has Quantity = 20, Unit Price = 5, Amount = $100. This is divided across two child allocations, Child1 (Quantity = 12, Amount = $60) and Child2 (Quantity = 8, Amount = $40). You invoice 10% of the parent amount. This is how Proliance breaks down the invoicing information for each child allocation:

• Child1: Quantity 1.2, Amount = 6
• Child2: Quantity 0.8, Amount = 4

This information can be found on the Invoices tab on the Line Item Detail Viewer or in the Anticipated Cost Report.

• ACR Column: Select the ACR column that information from the cost account allocation is currently assigned to, by using the drop-down list. For more information, see "About the ACR Column".

• Advanced Code: This is the advance code associated with the cost account. This code cannot be edited here. For more information, see the Advanced Code section in "Cost Account - Main".
• Amount:

  Enter the amount that you wish to allocate to the cost account. Proliance then updates the Quantity or Unit Price, depending on the Pivot Type, to maintain the following formula:

  Amount = Quantity * Unit Price

  The total amount from all the cost account allocations must equal the parent line item's Scheduled Amount.

  When you select another Unit Code, Proliance will recalculate the Amount based on the default UOM and Unit Price associated with the new code.

  Note: If unit price information is currently hidden in the document, Proliance continues to update the values in the above formula in the background. For more information on showing/hiding unit price information, refer to the Settings page of the document.

• Cost Account: Click the Magnifying Glass icon and select the cost account that the cost account allocation is allocated to.
• Item Description: Type a brief description to help you determine the origin or purpose of a cost account allocation.
• Item Note: Optionally type a short note that provides more information about the cost account allocation. For example, this note may elaborate on the Item Description.
• Line Number: Enter a line number for the cost account allocation.
• Pivot Type:

  Select which value should be the "pivot" point (i.e., stays constant) when Proliance recalculates the following formula:

  Amount = Quantity * Unit Price

  For example, if the pivot is Unit Price, then Proliance keeps the unit price fixed if the Quantity or Amount changes. If the pivot is Quantity, then Proliance keeps the quantity fixed during recalculation.

  The default pivot type is specified on the Settings page of the document.

• Reporting Code 1-3: Optionally, click the Magnifying Glass icon to select up to three reporting codes to help you categorize the cost account allocation. These codes provide additional means to group, sort and filter the allocations in Proliance. This is especially useful when working with the Anticipated Cost Report (ACR).
  
  By entering reporting codes for all the cost account allocations, you will be able to use the ACR to view the entire workspace, summarized by the items and levels within the reporting codes. This is similar to the power offered by the advanced codes in cost accounts. For more information, see "Configuring Cost Account Advanced Codes".
• Quantity:

  Enter the quantity of the cost account allocation. Proliance uses the quantity to calculate the total amount as follows:

  Amount = Quantity * Amount

  If the Pivot Type is by 'Amount', Proliance will automatically adjust the Quantity to maintain the above formula if the Total Amount is edited.

  Drawdowns from a cost account line item can be by quantity, as well as by lump sum.

  Note:

  • The Quantity column is visible only if Show Unit Price Information has been enabled on the Settings page of the document. Proliance continues to update the Quantity even if unit price information is hidden.
  • The Quantity is editable only when the Amount is editable.
  • If neither a Quantity nor Unit Price is specified, Proliance uses Quantity = 1 and Unit Price = Amount to satisfy the above formula.

• Project: Optionally click the Magnifying Glass icon to select a project for the cost account allocation. The projects you can choose from may be restricted depending on the Restrict Projects that Child Items Can Link to setting on the Projects tab. For more information, see About the Projects Tab.

• Unit Code:

  Click the Magnifying Glass icon and select the unit code for the cost account allocation.

  The unit code identifies what is being "bought", to help you identify items across different line items in different documents in Proliance.

  When you select a Unit Code, Proliance defaults the UOM and Unit Price to the values defined for the unit code. For more information on setting default UOM and unit price information, see "Editing Lookup Items".

  Note: The Unit Code column is visible only if Show Unit Price Information has been enabled on the Settings page of the contract.

• Unit Price:

  Enter the price for each unit or accept the default that was populated based on the unit code.

  Note: If you select a different unit code, Proliance will replace the existing unit price with the default unit price in the new unit code.

  The unit price is expressed in the workspace currency. Proliance will automatically convert the default unit price for a unit code into the "native" currency if the cost account allocation uses a currency different from the workspace currency.

  Example

  For example, the workspace currency is USD, while a BCM child row is in CDN. When you select a unit code for the BCM child row, Proliance will convert the unit price in the unit code from USD to CDN.

  Note:

  • The Unit Price column is visible only if Show Unit Price Information has been enabled on the Settings page of the document. Proliance continues to update the Unit Price even if unit price information is hidden.
  • The unit price is editable only when the Amount is editable.
  • If neither a Quantity nor Unit Price is specified, Proliance uses Quantity = 1 and Unit Price = Amount to satisfy the formula above.
• UOM:

  Enter a unit of measure (UOM) or accept the default UOM that was populated based on the unit code.

  Note: If you select a different unit code, Proliance will replace the existing UOM with the default UOM in the new unit code.

  The UOM is the 'unit' the quantity represents—for example: LF (Linear Ft), SF (Square Ft), cu yd (Cubic Yard), or the equivalent metric versions.

  The UOM is critical in determining the unit price. Dissimilar UOM values cannot be used in the same calculation. For example: if the unit price is for m3 (Cubic Meters) but the quantity is in cu yd, then it is not possible to use these measurements in calculations.

  Note: The UOM column is visible only if Show Unit Price Information has been enabled on the Settings page of the document.

  The UOM is editable only when the Amount is editable.

• Drawdown Type:

  Specify how a cost line item from a cost account should be drawn down: by changing the total amount or by changing the quantity of the source BCM allocation.

  Note: You cannot change the Drawdown Type once a drawdown has occurred, unless the drawdown has been removed.

• Linked Drawdown Item: Click the Magnifying Glass icon and select the source cost allocation, as it appears on the Line Items page of the cost account.
• Is Frozen:When selected, this linked drawdown is locked. Proliance will not attempt to perform the drawdown until you unlock it.
• Actual Drawdown Amount: The amount of money that the linked drawdown has successfully taken from the source cost allocation.
  
  This amount may be less than or equal to the Required Drawdown Amt.
  
  You cannot edit this amount.
• Actual Drawdown Quantity: The quantity that the linked drawdown has successfully taken from the source cost allocation.
  
  You cannot edit this amount.
• Drawdown Item Note: Optionally type a short note for each linked drawdown.