I need a formula to calculate a profit margin of 25%. I need to know what my minimum sale price can be to always maintain at least a 25% minimum profit margin.
I have a fixed fee of $5 (column D). Another fixed fee of 15% of sale price (column C). Fixed cost of goods sold (column A).
While my variables will change, what forumla can I use to always get a result of 25% without having to play with changing the sale price constantly. I need to do this across thousands of products.
Solved by D. H. in 11 mins