BILLING REQUIREMENT WITHOUT MAPPING — ACRN LINE ITEM — PRORATION

ACRN/Line Item using Proration Methodology

If there is more than one ACRN within a contract line item, the payment office makes payment from each ACRN in the same proportion as the amount of funding currently unliquidated for each ACRN.

Unliquidated is defined as the Remaining ACRN Funded Value.

The mathematical equation to determine the ACRN/Line Item Proration amounts is:     

        Individual Line Item/ACRN Funded Value                                              

          Total of Remaining ACRN Funded Value

A contract is awarded with the following Accounting Classification data:

Project Setup Data:

Project Number:  USN0418

Billing Level:      USN0418

The ACRN data is set up as follows on the Manage ACRN Bills screen. On the Manage ACRN Bills screen, you can use the ACRN/Line Item combination or the ACRN/Subline Item combination, but you cannot use an ACRN/Line Item/Subline Item combination. You can mix the combinations for one project (for example, link ACRN AA/0001AA and link Line Item ACRN AE/0003 to the same project).

Using the preceding Accounting Classification data, you enter data on the Manage ACRN Bills screen as follows:

The ACRN Sequence Number for this calculation is used only for rounding amounts.

A Standard Bill (calculated by the Calculate Standard Bills screen) produces the following invoice amounts for Project USN0418 (BILL_EDIT_INVC_HDR).

USN0418:  82,500.00

Calculation Logic

Calculate the ACRN allocation amounts by performing the following calculation:

Determine the Amount to be Allocated.

Amount to be Allocated equals SUM (MU_INVC_AMT) in BILL_EDIT_INVC_HDR

Amount to be Allocated:

SUM (MU_INVC_AMT) in BILL_EDIT_INVC_HDR for Project USN0418: 82,500.00

Determine the Remaining Line Item/ACRN Funded Value for each ACRN as a ratio of the Sum of ALL Remaining ACRN Funded Value amounts.

If the individual ACRN/Line Item Remaining ACRN Funded Value (PROJ_ACRN_DETL.ACRN_FUNDED_AMT PROJ_ACRN_DETL.ACRN_BILLED_AMT) is less than or equal to 0.00, do not include that specific ACRN/Line Item Funded Value in the calculation as part of the numerator or denominator. If the PROJ_ACRN_DETL.ACTIVE_FL = N, do not include that specific ACRN Funded Value in the calculation.

The individual ACRN/Line Items which have a Remaining ACRN Funded Value > 0 and are active are:             

Table 1— ACRN/Line Item Remaining ACRN Funded Values

Next, convert ACRN/Line Item Remaining ACRN Funded Values as a ratio to Total of ALL Remaining ACRN Funded Values:

Table 2 — ACRN Proration                                                                             

For individual ACRN/Line Items that are Active and have a Remaining ACRN Funded Value greater than 0.00, multiply the SUM (MU_INVC_AMT) from BILL_EDIT_INVC_HDR for the Billing Level project number by the appropriate ACRN ratio (preceding calculation).

Table 3 — ACRN/Line Item Allocation Calculation