GolfGTIforum.co.uk
General => General discussion => Topic started by: mongchops on 06 July 2011, 11:41
-
Lo Folken.
Don't know if I know a more diverse bunch so fingers crossed one of you clever sods may be able to help me.
As titled, I am after the help of a maths wizzard to show one not so clever as I how to calculate a steady percentage increase over a set amount of time.
Thankings.
-
Give me the example...
-
excel spread sheet, :wink:
-
Do you mean like "simple interest"
-
excel spread sheet, :wink:
Great shout!
-
Yeah, I'm with Chuff, it's gotta be excel.
Plus you can make a neat graph. :wink:
-
Will be compound interest surely!
-
http://www.mathsisfun.com/money/compound-interest.html
http://www.mathsisfun.com/money/interest.html
-
gents.....the example.
on the 1st jan 2000, a mans salary is 46,500. he gets a cost of living raise on 1st jan 2001 of 5.4%. he is now earning 49,011. this is still his salary on 1st oct 2001.
his workload increase in equal monthly increments by 23%.
what i need to calculate is the amount of extra money each monthly raise in workload should generate if the salary raise was equal culmulating in a final amount.
make sense?
your help is, as always, most gratefully received.
-
gents.....the example.
on the 1st jan 2000, a mans salary is 46,500. he gets a cost of living raise on 1st jan 2001 of 5.4%. he is now earning 49,011. this is still his salary on 1st oct 2001.
his workload increase in equal monthly increments by 23%.
what i need to calculate is the amount of extra money each monthly raise in workload should generate if the salary raise was equal culmulating in a final amount.
make sense?
your help is, as always, most gratefully received.
Lucky sod is your answer :sad:
-
Hmmm, maybe you're not all as clever as I thought. :nerd:
-
I've been teaching Maths for 12 years and I still don't get the question :undecided:
PatC
-
I think maybe I need some kind of graph or chart to show a month on month increase in workload upto 23%. Starting from 100, the rise must end in 123 but I know that just adding 23% to the initial salary won't reflect the growth properly. Hope this explains more.
-
From a business point of view you would need the figure the workload earns. Pay has to be related to income. If the workload increases 23 percent per month as the question suggests then within four months the work load has virtually doubled which would be near impossible unless the worker was a lazy sod in the first place.
I believe you would need the income from the workload on the 1st January 2001 to work out the figure you require for October 2001. If you could provide this figure it could be worked out quite easily. Without it you could not project a figure for a salary Buddy :wink:
-
:smiley:
http://www.youtube.com/watch?v=Hrm-rPSCIBw
-
Right.....just been reading your question again and here is your answer.
The workload increases by 2.56 percent per month upto 123.04 on the 1st October 2001. If the salary was increased by 2.56 percent per month to match the salary on the 1st October 2001 would be......£61531.23 which represents a 2.56 percent increase per month. Hope this helps. :cool:
-
I agree :wink: