F
Fibonacci
Hello,
I am having a lot of trouble trying to figure out a way to create a
spreadsheet to automate my retail markup process. Here is what I am
trying to do:
Let's say for items costing me $1.00 I would like to have a 500%
markup. A $3.00 item, a 300% markup. By the time an item reaches a cost
of $50.00 I would like the markup to fall to around 100%.
I am guessing this would involve some kind of logarithmic function, I
am not sure.
I would like to have a spreadsheet that allows me to adjust the
properties of this curve by adjusting 1 or 2 cells, changing it's shape
to find one that fits my needs.
I have had some success, but the can never seem to adjust the rate of
decay and its position in the curve as I would like.
Could anyone offer a solution to my problem? It would be most
appreciated.
Best Regards,
Fibonacci
I am having a lot of trouble trying to figure out a way to create a
spreadsheet to automate my retail markup process. Here is what I am
trying to do:
Let's say for items costing me $1.00 I would like to have a 500%
markup. A $3.00 item, a 300% markup. By the time an item reaches a cost
of $50.00 I would like the markup to fall to around 100%.
I am guessing this would involve some kind of logarithmic function, I
am not sure.
I would like to have a spreadsheet that allows me to adjust the
properties of this curve by adjusting 1 or 2 cells, changing it's shape
to find one that fits my needs.
I have had some success, but the can never seem to adjust the rate of
decay and its position in the curve as I would like.
Could anyone offer a solution to my problem? It would be most
appreciated.
Best Regards,
Fibonacci