Assortment Planning Framework With Substitution And Complexity Cost

Date/Time
Date(s) - 05/08/2021
14:00 - 16:00

Categories No Categories


Speaker: Dilara Sönmez

Time: Aug 5, 2021 02:00 PM Istanbul

Join Zoom Meeting

https://zoom.us/j/9937664491?pwd=R0FNalFFZUM0Wm9MaitiYWJrbVhodz09

Meeting ID: 993 766 4491

Passcode: 525871

Title: Assortment Planning Framework With Substitution And Complexity Cost

Abstract: While increasing product variety may have a positive effect on market share, it may lead to difficulties in product management and forecasting, leading to increase in inventory holding costs. In addition, as a result of increased setup times, efficiency decreases. In this study, we propose two methods to help a multinational tire manufacturer manage their assortment to find a balance between variety and sales. The first method evaluates the marginal complexity cost of a set of new products so that a data-driven decision can be made to introduce or not to introduce new products. The second method determines the set of tires to be included in the assortment that improves the total profit. To account correctly for the partial sales revenue losses due to discontinued products, we estimate the fractions of demands substituted by the products left in the assortment. Customer no-purchase information were unobserved, as well as the exact timings of stock-outs and sales up to those times. Also, market share information for a particular group of tires for the company were unavailable. Based on these incomplete data, the substitution probabilities were estimated using an iterative method. The solutions were iterated on to find the set of substitution probabilities that best fit the data.

 

Discontinued products are expected to save from complexity costs due to production capacity losses because of frequent break times. The complexity cost is a set function that accounts for the interactions between the products during manufacturing processes, as well as the variety in the product portfolio. In order to estimate the break time savings, a machine learning model was used, and an algorithm was designed to measure the effect of a set of products being discontinued.

 

For the periods in which the machines work in full capacity, the additional profit due to potential new sales was also considered. This value and the conversion cost saved due to discontinued products were added to the profit function. The predictions from the machine learning model and the other costs are used to formulate a large-scale assortment optimization problem with a black-box objective function.

 

The assortment problem is solved using genetic algorithm. The results show that the new assortment obtained through our analysis has 3.8% – 15.6% less products than the initial assortment. The new assortment leads to additional profit between 0.7% and 4.7% of the company’s annual income. The results also show that considering complexity costs in assortment decisions leads to substantially different assortments and additional savings in comparison to those obtained without their considerations.