Hello,
I am interested in your project. I have professional experience with SQL.
I have analyzed your data, and I want to confirm that I understand everything.
The MSRP is the price you sell your products;
The Cost is the amount that you pay by the product.
If MSRP>Cost then you will have profit, is not you will lose money.
Your objective is to calculate a new MSRP in order to have always profit.
Are the online fees and delivery charges specific for each product, or for each Source (Amazon or Ebay, etc.)?
Do you have the data of each extra cost? Or do you have an estimation of how much it will be based on some parameters?
I can provide you the mathematical formula, using SQL if you want, based on the parameters I have indicated. We can also define an minimal profit margin, to calculate the new MSRP.
Thank you,
Best regards,
David