I have few product categories eg prod1 prod2. Each category have similar products. So prod1 has 3 similar products with slight difference in features and prod2 has 5 products with slight differences. Now we have decided to reduce price for each of this product for regulation purpose. So we want see if decreasing the price will have impact on volume increase. Problem is we already have different price structure in place. Regular price and volume based price. So for customers who generates huge volumes we give them discounts based upon slabs eg if volume is between 1000 to 20000 then they are priced $10, if 20,000 to 30,000 then $5. And all customers below 1000 volume is priced the regular price $30. Now how to implement elasticity model here. Since lower prices were given to customers with already high volume. If I run a regression will it not have cyclical impact since low prices were given to customer with higher volume. My question is how do I structure the data. 1) Should I separate customers based upon volume slabs and pricing structure that is regular vs discounted price? 2)for each customer should I consider volume data for few months before price decrease and then volume for few months after price increase. 3)Should I create 1 model for each product category or sub category. I am new to this. Most of the examples online are more straightforward. Any help is appreciated


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.