This is my first question on this stackexchange - i hope i'm in the right place and i'm asking the right question.
I work for a business, we sell certain products. We are running a trial currently on a a subset of these products where we are trying to impact on the margin we make on these products by altering (on purpose) which sales channel we sell them on. However, this may not work in all cases, e.g. we may stop selling the item because it is not sellable on the new sales channels.
I'm trying to do the following:
I have a list of productids where we applied this mechanism
I know how much we sold before and after the trial started, i know the margin made on each sale
I know how much we have received into stock from the item before and after the trial
I know how much we had on stock when we started the trial
I need advice on the following: * Am i right to assume that the ratio of margin of total sales vs. the units we have receied into stock is the right answer? So if the margin is 10 before the trial and 20 after, but we received 2 items before and 5 after, we are worse off?
How should i involve the stock amount we had on sale when we started the trial in my calculations?
Is there any available reading i should look into to educate myself?
Last question: provided i get answers on the above questions, i'll be able to flag each of my products with a "SuccessfulTrial" flag - true or false. Based on that, i can build some regression to find which product specifics have an impact on the success of this mechanism. Is my thinking right?
Thanks for any answers,