% Function REALLy simple **resolved**

[Matt_T_hat]

I am composing a function that will solve a specific price issue.

First it adds the costs and adds basic markup

P = (A+B)*M%

But I then need to do a little complex stuff with that number to get the result

I have the a percentage that will be taken from the result and so the result must be such that

let R=Result
let C=Their Cut

R-C=P

How can I get to R as a function of C and P?

[DiGiTaIErRoR]

R=P+C

[Matt_T_hat]

Originally posted by DiGiTaIErRoR
R=P+C

If R was static...yes but: C changes based on R... less simple you see Thier cut C comes not from the base but the result... It was probably my fault I didn't explain very well.

The advertiser takes 5% (this changes) of the sale price. in order to acheave a specific profit I need to work out first a desired return (after the cut) and based on this value (P) I need a value that is R-(n% of R) = P where R is the unknown result I am trying to get to.

Sorry I probably put it baddly the first time.

[DiGiTaIErRoR]

Give me an example.

[Matt_T_hat]

i have a pc it cost me £200, i want to make 10% so i want to take £220 however the shop will charge me n% costs so I need to increase my price so that after the shops cut I get my £220. I intend to set a formula that will take the charge useually C
+ n% (say £0.50 + 5%) so that I have a price to ask for so that the profit I make is as calculated from the original supplier cost.
But the result seams to be a function of itself.

I know from my math days that this is always a solveable thing as far as recogning money is concerned but don't know how 2.

[DiGiTaIErRoR]

Ok...

So...

o= 200
c = 5 (%)


So you want 10%, they want c, or 5%, and the original price, o is 200.

So..

P = (p * 1.1) '10 percent
P = (p * (c/100 + 1)) ' store's percent

Thus...

Inflated = Price * 1.1 * (c/100 +1)

[Matt_T_hat]

That sounds about right. The store take +/- 5% of what ever price I sell at.

Can you explain how the formula works?? I feel I only 95% understand

[DiGiTaIErRoR]

It just calculates the percentages.

For example...

say tax is 6% to get the cost plus tax you'd multiply by 1.06, or 106%.

So, * by 1.1 gives you 110%, c/100 +1 , where c is a percent, converts the percent of c into a decimal, then adds the 100%.

In application:

An item you purchase for $5, you want to make a 50 cent profit off of. 5*1.1 = 5.50 Then the store wants 5%(5.50*1.05). That's 5.775.

[Matt_T_hat]

Ok thanks, now I understand I have been able to impliment this in a spread sheet.


Thanks again, that really helpped.