Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A common tax scenario
Message
De
23/05/2012 13:40:04
 
 
À
23/05/2012 13:23:33
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01544104
Message ID:
01544167
Vues:
34
>Re: the calculation, I'd just back out the values in the reverse order they were originally calculated.
>
>If you start with total value $574.88 (actually $575.875), that is 1.095 * ( Price + FedTax ), so
>
>( Price + FedTax ) = 574.88 / 1.095, = 525.00
>
>Then, ( Price + FedTax ) = Price * 1.05, so
>
>Price = ( Price + FedTax ) / 1.05, = 525.00 / 1.05, = 500.00
>
>If you want to do it all in one step:
>
>T = total dollar value including all taxes
>P = provincial tax rate as a decimal e.g. 9.5% = 0.095
>F = federal tax rate as a decimal e.g. 5% = 0.05
>I = item price
>
>Then I = ( T / ( 1 + P ) ) / ( 1 + F )

We do not have the total dollar value including all taxes, as defined here with the T variable. This is the hole problem here we have to workaround. The only thing I have is the total amount for the taxes, which is 74.88$ in our example. From that amount, we have to go back to 500.00$, as we test for Quebec presently. So, this is why, in the other thread, Gregory is working on that fancy method to reverse engineer the entire process.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform