MHB Finding fixed known %'s of total when total % known

  • Thread starter Thread starter vitamin1
  • Start date Start date
AI Thread Summary
To determine the portions of total tax due from two different tax rates, the total tax amount can be divided by the combined tax rate. For example, with a total tax of $150, the combined rate of 12.5% (6% + 6.5%) allows for calculating the total sale amount as $1200. From there, the individual portions can be calculated: 6% of $1200 equals $72, and 6.5% equals $78. This method effectively allows one to backtrack from the total tax to find the contributions of each tax rate. Understanding this calculation is essential for accurate financial assessments.
vitamin1
Messages
3
Reaction score
0
Hi,

I am trying to figure out the equation of the following so that I can make a formula in a spread sheet.

There are two tax rates... 6.5% and 6% equaling 100% of total tax due for a sale (sale amounts vary).

If I am only given the TOTAL (100%) tax due, in this case \$125, how can I work backwards and know what portion of the \$125 is 6% and what portion is 6.5%?

i.e.
  • \$1000 = total sale
  • 6% = 60
  • 6.5% = 65
  • 100% of total tax due = \$125
  • I am only given total sale and total tax due. How can I work backwards from the two known and get \$60 and \$65?

Hope that makes sense! Thanks.
 
Mathematics news on Phys.org
Hi vitamin and welcome to MHB! :D

If you know the individual tax rates that are applied, it's straightforward (you did it yourself above). If you don't know the individual tax rates that were applied it's impossible.

By the way, preceding dollar signs with a '\' allows your post to render correctly - dollar signs have a special meaning here - they are used for typesetting math (latex).
 
greg1313 said:
Hi vitamin and welcome to MHB! :D

If you know the individual tax rates that are applied, it's straightforward (you did it yourself above). If you don't know the individual tax rates that were applied it's impossible.

By the way, preceding dollar signs with a '\' allows your post to render correctly - dollar signs have a special meaning here - they are used for typesetting math (latex).

Thanks for the dollar sign tip.

I guess I'm just not getting it.

Tell me how you figure the following out equation wise:

Total tax is \$150.
What portion is 6% and what portion is 6.5% ?
 
Let $T$ be the total sale amount (the amount of the sale before taxes).

$$0.125T=150\implies T=1200$$

$$0.06\times1200=72$$

$$0.065\times1200=78$$

Does that help?
 
greg1313 said:
Let $T$ be the total sale amount (the amount of the sale before taxes).

$$0.125T=150\implies T=1200$$

$$0.06\times1200=72$$

$$0.065\times1200=78$$

Does that help?

That did help...thanks!

I also saw another example that helped as follows:

12.5% = 150
so
6% = 150 / 12.5 * 6 = 72
6.5% = 150 / 12.5 * 6.5 = 78
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Back
Top