Description |
* Price Profile - Add New Pricing Basis of "Local Index Fixed"
** Available For Local/Network Only
** Works like Local Index Retail, but with Tax Exemptions included in the price.
* Purpose of Local Index Fixed is to set the Gross Price that will be charged to the customer including all Taxes.
** Note = Customer Tax Exemptions could already be included in this value.
** Example: City of Fort Wayne has a contracted Price of 1.950000 on Unleaded Gasoline for the entire year of 2017. This includes 3 taxes, but is exempt from 2 others.
*** Due to the nature of the contract, this Gross price must be exactly 1.950000 for all Unleaded Transactions, as well all Calculated Total Amount = to Gross Price * Quantity.
* Price Calculation = When Basis is Local Index Fixed
** Calc Gross Price = Local Index + Profile Rate
*** 1.950000 + 0.00 = 1.950000
** Calc Net Price = Round(Round(Gross Price * Quantity,2) - Total Calc Taxes ) / Quantity, 6)
*** (1.950000*13.065 - (.01+.13+2.35) ) / 13.065
*** (25.48 - 2.49 ) / 13.065 = 1.759663
** Calc Total Amount = Round(Gross Price * Quantity,2)
*** 1.95000 * 13.065 = 25.48
** Total Amount Check = Total Calc Taxes + Round(Net Price * Quantity,2)
*** 2.49 + 1.759663 * 13.065
*** 2.49 + 22.99 = 25.48
* Ensure that Total Calculated Amount on CF Transaction matched to AR > Sales Invoice
|