Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Billing Requirement Without Mapping for ACRN Only - Proration

Use this section to see examples of calculations for ACRN Only without mapping using the proration methodology.

Requirement: the payment office makes payment from each ACRN within the contract in the same proportion as the amount of funding currently unliquidated for each ACRN. 

Unliquidated is defined as the Remaining ACRN Allocation Value.

The mathematical equation to determine the Proration amounts is:           

      Individual Remaining ACRN Allocation Value (each ACRN)                                          

               Total of ALL Remaining ACRN Allocation Values

A contract is awarded with the following Accounting Classification data:

Line Item Subline Item ACRN Accounting Appropriation Number Funding Amt
0001 0001AA AA 5793400309475A110704040004081572806F503000 F03000 15,000.00
0001 0001AB AA 5793400309475A110704040004081572806F503000 F03000 11,000.00
0002 0002AA AB 8893400309475A110704040004081572806F336000 F07700 12,000.00
0002 0002AB AB 8893400309475A110704040004081572806F336000 F07700 14,000.00
0003 0003AA AA 5793400309475A110704040004081572806F503000 F03000 10,000.00
0003 0003AB AB 8893400309475A110704040004081572806F336000 F07700 15,000.00
0004 0004AA AC 7765658810475A110704040004081572806F336000 C15500 30,000.00
0004 0004AB AC 7765658810475A110704040004081572806F336000 C15500 50,000.00

Project Setup Data:

Project Number:  USN0418

Billing Level:      USN0418

Set up the ACRN data as follows on the Manage ACRN Bills screen. Line and Subline data are not entered based upon the Billing Requirement selection of ACRN Only. Accounts are not mapped.

Seq No ACRN Active Original ACRN Funding ACRN Modification Value Total ACRN Value Previous ACRN Allocation Value Remaining ACRN Allocation Value
1 AA Y 36,000.00 0.00 36,000.00 0.00 36,000.00
2 AB Y 41,000.00 0.00 41,000.00 0.00 41,000.00
3 AC Y 80,000.00 0.00 80,000.00 0.00 80,000.00

ACRN Modification Value column is for illustration purposes only.

Note: 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 (SUM (MU_INVC_AMT) in BILL_EDIT_INVC_HDR).

USN0418:  82,500.00

Calculation Logic

Calculate the ACRN allocation amounts by performing the following calculation:

Determine Amount Remaining to be Allocated.

Amount Remaining to be Allocated equals SUM(MU_INVC_AMT) in BILL_EDIT_INVC_HDR.                                   

Project USN0418 Amount Remaining to be Allocated:  82,500.00

Determine the Remaining ACRN Allocation Value for each ACRN as a ratio to the Sum of ALL Remaining ACRN Allocation Value amounts for active ACRNs.

If the individual ACRN Remaining ACRN Allocation 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 Allocation 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 Allocation Value in the calculation.

Gather individual ACRN Remaining ACRN Allocation Values where PROJ_ACRN_DETL.ACTIVE_FL = Y and Remaining ACRN Allocation Value (PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT) > 0:

ACRN AA Remaining ACRN Allocation Value:  36,000.00

ACRN AB Remaining ACRN Allocation Value:   41,000.00

ACRN AC Remaining ACRN Allocation Value:   80,000.00

Total Remaining ACRN Allocation Value          157,000.00

Next, convert ACRN Remaining ACRN Allocation Values as a ratio to Total of ALL Remaining ACRN Allocation Values:

ACRN Proration:

ACRN ACRN Proration
AA (36,000.00 / 157,000.00)
AB (41,000.00 / 157,000.00)
AC (80,000.00 / 157,000.00)

Multiply the SUM (MU_INVC_AMT) from BILL_EDIT_INVC_HDR for the Billing Level project ID by the appropriate ACRN ratio from the preceding table.

ACRN Allocation:

ACRN Ratio Computation ACRN Allocation Amount
AA (82,500.00 * (36,000.00 / 157,000.00)) 18,917.20
AB (82,500.00 * (41,000.00 / 157,000.00)) 21,544.59
AC (82,500.00 * (80,000.00 / 157,000.00)) 42,038.22
Total ACRN Allocation Amount 82,500.01

If any residual amounts result due to rounding (Total ACRN Allocation Amount not equal to Invoice Amount, SUM(MU_INVC_AMT)), apply the residual to the ACRN linked to the smallest ACRN Sequence Number with a Remaining ACRN Allocation Value > 0.

The smallest ACRN Sequence Number with a Remaining ACRN Allocation Value is ACRN AA (SEQ_NO = 1).

Distribute the .01 rounding amount to ACRN AA.

Summary of ACRN Allocation Amounts

ACRN Calculation Allocation Amount
AA Reduce by .01 - rounding issue 18,917.20
AB 21,544.59
AC 42,038.22
Total ACRN Allocation Amount 82,500.00