Invoice Amounts for February of 2008

When you run the Invoice Generation program (R52121) for February of 2008, the system calculates these invoice amounts from the transactions in the F4812 table for funding level 101:

Current Cost Amount

Current Fee Amount

Current Award Fee Amount

Total

150,000.00 USD

40,000.00 USD

2,000.00 USD

192, 000.00

The system allows you to bill only up to the contract limits. This table shows the amounts that you bill, the excess amounts, and how the system calculates these amounts:

Amount Type

Calculation for Amount to Bill

(contract limit − cumulative billed amount)

Amount Eligible to Bill

Excess Amount

Cost

1,200,000 − 1,150,000

50,000.00 USD

100,000.00 USD

Fee

300,000 − 275,000

25,000,00 USD

15,000.0 USD

Award Fee

10,000 − 9,750

250.00.00 USD

1,750.00 USD

Because the current cost, fee, and award fee amounts exceed the contract limits, the R52121 program creates an excess billing line for funding level 101. When you run the Create A/R Entries program (R48199), the system creates records in the F52G200 table for the excess amounts. Because the billing limit is Funded By Line, the system creates separate records for each amount type that was exceeded. This table shows the records that the system creates in the F52G200 table:

Pricing Type Group

Cum Invoice

Cum Invoice Exceeded

C

(cost)

1,300,000.00

−100, 000.00

F

(fee)

315,000.00

−15,000.00

A

(award fee)

11,750.00

−1,750.00

T

(total)

1,626,750.00

(the system does not populate this field because the limit method is funded by line)

Note: The system creates the record for pricing type group T so that if you change the billing limit to Funded By Total, the system has a record that contains the total amounts. If you continue using the Funded By Line billing limit, the system does not use this record.