Pricing - Sliding Scale Price Markup
In Excel, I am looking for a formula to apply a sliding scale price markup
using interpolation.
The size of the percentage markup would decrease as cost increases and would
increase as cost decreases.
I have 200 products and the cost ranges from $1.50 (approx. 60% markup) to
$35.00 (approx. 15% markup)
Avg. cost is $6.00 (50% markup)
Thank you.
Ed.
|