MHB How do I calculate a cumulative reducing percentage for forecasting?

  • Thread starter Thread starter gazzap
  • Start date Start date
gazzap
Messages
2
Reaction score
0
I have a maths problem that has confused me.
Each month I have a performance score. Month by month those scores are added together to make a cumulative score of the year to date.
There is a target (percentage) that must be achieved by the year end. Based on the current cumulative result I need to find what the result has to be in all of the remaining months in order to hit the target exactly.

For example
Month 1 result: 93 out of 100 (93%)
Month 2 result: 71 out of 100 (cumulative result is now 82%, 164 out of 200)

Target for year is 75%.

So, in the remaining 10 months, the result each month would have to be less than 75% (because it is currently 7% above the target). But what is the formula to calculate that figure?
Each month going forward, the real result will be entered, and of course this will have an effect on this figure.
I know the answer to the example is 73.9%, achieved purely using trial and error but I cannot create the formula to find the answer.
Using this figure I can see that the cumulative result changes more in the first month than the second and the second is more than the third and so on. ie the change is in ever decreasing amounts until the target is hit.
I don't know what the name of this maths problem is.
Can anyone help?
 
Mathematics news on Phys.org
gazzap said:
I have a maths problem that has confused me.
Each month I have a performance score. Month by month those scores are added together to make a cumulative score of the year to date.
There is a target (percentage) that must be achieved by the year end. Based on the current cumulative result I need to find what the result has to be in all of the remaining months in order to hit the target exactly.

For example
Month 1 result: 93 out of 100 (93%)
Month 2 result: 71 out of 100 (cumulative result is now 82%, 164 out of 200)

Target for year is 75%.

So, in the remaining 10 months, the result each month would have to be less than 75% (because it is currently 7% above the target). But what is the formula to calculate that figure?
You need to use "raw" numbers rather than percentages but if that "out of 100" stays constant, then you can just treat the percentages as if they were "raw" numbers. If you want 75% 0ver the 12 months of the year, then you want a raw score if 0.75*1200= 900. You already have 93+ 71= 164, as you say. So you want a total of 900- 164= 736 over the next 10 months. That is an average of 73.6 for each month so you will want 73.6%, not 73.9%, of 100 each month.

Each month going forward, the real result will be entered, and of course this will have an effect on this figure.
I know the answer to the example is 73.9%, achieved purely using trial and error but I cannot create the formula to find the answer.
Using this figure I can see that the cumulative result changes more in the first month than the second and the second is more than the third and so on. ie the change is in ever decreasing amounts until the target is hit.
I don't know what the name of this maths problem is.
Can anyone help?
 
Unfortunately the number isn't always out of 100 each month. I was using that to simplify the example so that the number would equal the percentage in the example but in reality the numbers are basically random. If I knew the total for the year was going to be out of 1200 then yes it would be far easier.
 
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...
Fermat's Last Theorem has long been one of the most famous mathematical problems, and is now one of the most famous theorems. It simply states that the equation $$ a^n+b^n=c^n $$ has no solutions with positive integers if ##n>2.## It was named after Pierre de Fermat (1607-1665). The problem itself stems from the book Arithmetica by Diophantus of Alexandria. It gained popularity because Fermat noted in his copy "Cubum autem in duos cubos, aut quadratoquadratum in duos quadratoquadratos, et...
I'm interested to know whether the equation $$1 = 2 - \frac{1}{2 - \frac{1}{2 - \cdots}}$$ is true or not. It can be shown easily that if the continued fraction converges, it cannot converge to anything else than 1. It seems that if the continued fraction converges, the convergence is very slow. The apparent slowness of the convergence makes it difficult to estimate the presence of true convergence numerically. At the moment I don't know whether this converges or not.
Back
Top