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

  • Thread starter Thread starter gazzap
  • Start date Start date
AI Thread Summary
To calculate a cumulative reducing percentage for forecasting, start by determining the total score needed to meet the target percentage by year-end. For a target of 75% over 12 months, the total raw score required is 900. Subtract the cumulative score achieved so far from this total to find the score needed for the remaining months. Divide this figure by the number of remaining months to establish the average score required each month. The challenge lies in the variability of monthly scores, complicating the calculation of a precise formula.
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.
 
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...
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...
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