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 Funded Value.
The mathematical equation to determine the Proration amounts is:
Individual Remaining ACRN Funded Value (each ACRN)
Total of ALL Remaining ACRN Funded 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.
|
Sequence Number |
Active |
ACRN |
Original ACRN Funding |
ACRN Modification Value |
Total ACRN Funded Value |
Previous ACRN Allocation Amt |
Remaining ACRN Value |
|
1 |
Y |
AA |
36,000.00 |
0.00 |
36,000.00 |
0.00 |
36,000.00 |
|
2 |
Y |
AB |
41,000.00 |
0.00 |
41,000.00 |
0.00 |
41,000.00 |
|
3 |
Y |
AC |
80,000.00 |
0.00 |
80,000.00 |
0.00 |
80,000.00 |
ACRN Modification Value column is for illustration purposes only.
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 Funded Value for each ACRN as a ratio to the Sum of ALL Remaining ACRN Funded Value amounts for active ACRNs.
If the individual ACRN 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 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.
Gather individual ACRN Remaining ACRN Funded Values where PROJ_ACRN_DETL.ACTIVE_FL = Y and Remaining ACRN Funded Value (PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT) > 0:
ACRN AA Remaining ACRN Funded Value: 36,000.00
ACRN AB Remaining ACRN Funded Value: 41,000.00
ACRN AC Remaining ACRN Funded Value: 80,000.00
Total Remaining ACRN Funding Value 157,000.00
Next, convert ACRN Remaining ACRN Funded Values as a ratio to Total of ALL Remaining ACRN Funded 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 Funded Value > 0.
The smallest ACRN Sequence Number with a Remaining ACRN Funded 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 |
|