Formula to add margin dollars and remain whole

[Caly]

Hello I am trying to remain whole by applying the margin rate dollars to an item based on a similar product but unsure how to do that.

I have two products that are the same except one is the original and another is from a different vendor but same basic features.

The original is more but has a better margin than the similar. But trying to apply the margin rate dollars from the original to remain whole.

Example
Original is Product A
50% margin, margin dollars is $90, sell price is $200, cost is $110.

Similar is Product B
25% margin
I’m trying to apply the margin rate dollars from the original which is $90 but how should that be done so that I will still make the $90 margin rate dollars?

 

[Joe4]

I am not sure if your explanation is entirely clear. Could you show us some sample data in an Excel file and your expected output in each case (and an explanation of how exactly you arrived at that result)?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[kvsrinivasamurthy]

The example given for Product A does not tally with %..