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
 
Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
Back
Top