Canada Spends Logo

Explorez notre analyse du budget 2026

Grant: Engage Grants Program

McMaster University

$25,000.00

Assortment Planning in a Large-Scale Auto Parts Distribution Network

EF 2016-17

Résumé
PartSource, a Canadian Tire banner would like to develop an optimization model for assortment planning ofslow moving auto parts that is based on data and will support the company's business rules. The current modelsin the literature do not explore the rich data in the life cycles of Stock Keeping Units (SKUs). Such datainclude consumer ownership of automobiles, historical sales, car accidents, weather conditions, etc. To designsuch an assortment planning model, there are several challenges that are inherent to the specific nature of theauto parts retail industry. In this project, we focus on three challenges: 1) developing classification models forthe life cycles of SKUs; 2) developing classification models for the supply contracts of SKUs; 3) developing anassortment planning model that incorporates the demand patterns and supply patterns of SKUs via stochasticprogramming. We will use the company data to design specialized classification models to understand thedemand and supply patterns of SKUs. Moreover, we will use the demand and supply patterns as inputs tostochastic programming models for assortment planning. We will also explore the solution strategies for thestochastic programming models. Finally, we will develop the prototypes of the proposed methods. Ifsuccessful, this project will help PartSource reduce millions of dollars in inventory management, including theend of life cycle processing expenses. The methodologies applied in this project can also be extended to otherslow moving items. Moreover, this project will present values of data mining, optimization and other advancedanalytical expertise to a nation-wide retailer, thus leading to new job openings for business analysts and datascientists. This research project will also make contributions to academic literature in supply chainmanagement and importantly the training of Highly Qualified Personnel (HQP) within a high focus area formany firms.
Programme
Engage Grants Program
Bénéficiaire
Emplacement
Ontario, Canada
Type de bénéficiaire
Academia
Type
Grant
Source
NSERC's Awards Data

Tel que publié

Application id
503134-2016
Name nom
Huang, Kai
Department département
Business, DeGroote School of
Organization id
27
Institution établissement
McMaster University
Province en
Ontario
Province fr
Ontario
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2016
Competition year année de concours
2016
Award amount
25000
Program id
EGP
Program name en
Engage Grants Program
Program name fr
Programme de subventions d'engagement partenariat
Group en
Research partnerships programs
Group fr
Programmes de partenariat
Committee code
1553
Committee name en
Ontario Internal Decision Committee
Committee name fr
Comité de décision interne pour l'Ontario
Area of application code
520
Area of application group en
Manufacturing processes and products
Area of application group fr
Procédés et produits industriels
Area of application en
Production and operations management
Area of application fr
Production et gestion des opérations
Research subject code
1601
Research subject group en
Industrial engineering
Research subject group fr
Génie industriel
Research subject en
Operations research and management science
Research subject fr
Recherche opérationnelle et science de la gestion
Partie
1
Nb partie
1
Application title
Assortment Planning in a Large-Scale Auto Parts Distribution Network
Keyword
NSERC
Application summary
PartSource, a Canadian Tire banner would like to develop an optimization model for assortment planning ofslow moving auto parts that is based on data and will support the company's business rules. The current modelsin the literature do not explore the rich data in the life cycles of Stock Keeping Units (SKUs). Such datainclude consumer ownership of automobiles, historical sales, car accidents, weather conditions, etc. To designsuch an assortment planning model, there are several challenges that are inherent to the specific nature of theauto parts retail industry. In this project, we focus on three challenges: 1) developing classification models forthe life cycles of SKUs; 2) developing classification models for the supply contracts of SKUs; 3) developing anassortment planning model that incorporates the demand patterns and supply patterns of SKUs via stochasticprogramming. We will use the company data to design specialized classification models to understand thedemand and supply patterns of SKUs. Moreover, we will use the demand and supply patterns as inputs tostochastic programming models for assortment planning. We will also explore the solution strategies for thestochastic programming models. Finally, we will develop the prototypes of the proposed methods. Ifsuccessful, this project will help PartSource reduce millions of dollars in inventory management, including theend of life cycle processing expenses. The methodologies applied in this project can also be extended to otherslow moving items. Moreover, this project will present values of data mining, optimization and other advancedanalytical expertise to a nation-wide retailer, thus leading to new job openings for business analysts and datascientists. This research project will also make contributions to academic literature in supply chainmanagement and importantly the training of Highly Qualified Personnel (HQP) within a high focus area formany firms.