A method to rationalize the product portfolio in retail stores
Retail store operations face a variety of challenges and complexities. Determining the best assortment is the main problem in the retail store. This re-search presents a practical methodology for the analysis of products in the assortment with the goal of reducing the excess items and improve sales...
- Autores:
-
Coronado-Hernandez, Jairo R.
Ospina Mateus, Holman
Baron-Villamizar, Javier
Vidal, Lucelys
Piñeres Castillo, Aurora Patricia
Rojas-Millán, Rafael H.
Silva, Jesús
- Tipo de recurso:
- Article of journal
- Fecha de publicación:
- 2020
- Institución:
- Corporación Universidad de la Costa
- Repositorio:
- REDICUC - Repositorio CUC
- Idioma:
- eng
- OAI Identifier:
- oai:repositorio.cuc.edu.co:11323/6920
- Acceso en línea:
- https://hdl.handle.net/11323/6920
https://repositorio.cuc.edu.co/
- Palabra clave:
- Rationalization
Portfolio optimization
Clustering analysis
Retail
- Rights
- closedAccess
- License
- CC0 1.0 Universal
id |
RCUC2_53cd93c4e96f0ed174b23b33ce9ef1bc |
---|---|
oai_identifier_str |
oai:repositorio.cuc.edu.co:11323/6920 |
network_acronym_str |
RCUC2 |
network_name_str |
REDICUC - Repositorio CUC |
repository_id_str |
|
dc.title.spa.fl_str_mv |
A method to rationalize the product portfolio in retail stores |
title |
A method to rationalize the product portfolio in retail stores |
spellingShingle |
A method to rationalize the product portfolio in retail stores Rationalization Portfolio optimization Clustering analysis Retail |
title_short |
A method to rationalize the product portfolio in retail stores |
title_full |
A method to rationalize the product portfolio in retail stores |
title_fullStr |
A method to rationalize the product portfolio in retail stores |
title_full_unstemmed |
A method to rationalize the product portfolio in retail stores |
title_sort |
A method to rationalize the product portfolio in retail stores |
dc.creator.fl_str_mv |
Coronado-Hernandez, Jairo R. Ospina Mateus, Holman Baron-Villamizar, Javier Vidal, Lucelys Piñeres Castillo, Aurora Patricia Rojas-Millán, Rafael H. Silva, Jesús |
dc.contributor.author.spa.fl_str_mv |
Coronado-Hernandez, Jairo R. Ospina Mateus, Holman Baron-Villamizar, Javier Vidal, Lucelys Piñeres Castillo, Aurora Patricia Rojas-Millán, Rafael H. Silva, Jesús |
dc.subject.spa.fl_str_mv |
Rationalization Portfolio optimization Clustering analysis Retail |
topic |
Rationalization Portfolio optimization Clustering analysis Retail |
description |
Retail store operations face a variety of challenges and complexities. Determining the best assortment is the main problem in the retail store. This re-search presents a practical methodology for the analysis of products in the assortment with the goal of reducing the excess items and improve sales and profit margin of a retail store without affecting customer satisfaction. The methodology integrates 6 steps that allow to optimize products of a portfolio in categories, sub categories and segments, through Pareto analysis and clustering analysis using the BCG matrix. The methodology was applied in an independent supermarket. The results in the case of the application for non-perishable products, allowed to identify a set of different products (n = 152), of which they were prioritized in a subcategory (oils) in which 90 products were prioritized. In the example, it shows how 21 products have significant results in the variety of products. The combination of the global and local category of the product, the net profit, the inventory rotation and the participation of the growth provides a multifactorial analysis in the decision-making to supply with products a retail store seeking to increase the level of service and maximizing profits. |
publishDate |
2020 |
dc.date.accessioned.none.fl_str_mv |
2020-08-13T16:55:34Z |
dc.date.available.none.fl_str_mv |
2020-08-13T16:55:34Z |
dc.date.issued.none.fl_str_mv |
2020 |
dc.type.spa.fl_str_mv |
Artículo de revista |
dc.type.coar.fl_str_mv |
http://purl.org/coar/resource_type/c_2df8fbb1 |
dc.type.coar.spa.fl_str_mv |
http://purl.org/coar/resource_type/c_6501 |
dc.type.content.spa.fl_str_mv |
Text |
dc.type.driver.spa.fl_str_mv |
info:eu-repo/semantics/article |
dc.type.redcol.spa.fl_str_mv |
http://purl.org/redcol/resource_type/ART |
dc.type.version.spa.fl_str_mv |
info:eu-repo/semantics/acceptedVersion |
format |
http://purl.org/coar/resource_type/c_6501 |
status_str |
acceptedVersion |
dc.identifier.uri.spa.fl_str_mv |
https://hdl.handle.net/11323/6920 |
dc.identifier.instname.spa.fl_str_mv |
Corporación Universidad de la Costa |
dc.identifier.reponame.spa.fl_str_mv |
REDICUC - Repositorio CUC |
dc.identifier.repourl.spa.fl_str_mv |
https://repositorio.cuc.edu.co/ |
url |
https://hdl.handle.net/11323/6920 https://repositorio.cuc.edu.co/ |
identifier_str_mv |
Corporación Universidad de la Costa REDICUC - Repositorio CUC |
dc.language.iso.none.fl_str_mv |
eng |
language |
eng |
dc.rights.spa.fl_str_mv |
CC0 1.0 Universal |
dc.rights.uri.spa.fl_str_mv |
http://creativecommons.org/publicdomain/zero/1.0/ |
dc.rights.accessrights.spa.fl_str_mv |
info:eu-repo/semantics/closedAccess |
dc.rights.coar.spa.fl_str_mv |
http://purl.org/coar/access_right/c_14cb |
rights_invalid_str_mv |
CC0 1.0 Universal http://creativecommons.org/publicdomain/zero/1.0/ http://purl.org/coar/access_right/c_14cb |
eu_rights_str_mv |
closedAccess |
dc.publisher.spa.fl_str_mv |
Corporación Universidad de la Costa |
dc.source.spa.fl_str_mv |
Advances in Cybernetics, Cognition, and Machine Learning for Communication Technologies |
institution |
Corporación Universidad de la Costa |
dc.source.url.spa.fl_str_mv |
https://link.springer.com/chapter/10.1007%2F978-981-15-3125-5_51 |
bitstream.url.fl_str_mv |
https://repositorio.cuc.edu.co/bitstreams/b0f62752-e80b-4280-bc58-186927c05e63/download https://repositorio.cuc.edu.co/bitstreams/82632b9a-ccf9-440b-bdf6-e775bc675e3b/download https://repositorio.cuc.edu.co/bitstreams/389a3c1f-f089-47a8-a2ee-1f845f3890d8/download https://repositorio.cuc.edu.co/bitstreams/79b3f0b4-3b4a-4249-9605-804cf5a50212/download https://repositorio.cuc.edu.co/bitstreams/dc82b6dd-48dd-4a12-a4b5-c6baa7fef684/download |
bitstream.checksum.fl_str_mv |
ea956f6d8f9cceab59d5604a9c235764 42fd4ad1e89814f5e4a476b409eb708c e30e9215131d99561d40d6b0abbe9bad 94c86ba0be640a8801582e08678c1a1d 956533dff649b7cf8dec9b6891ea4846 |
bitstream.checksumAlgorithm.fl_str_mv |
MD5 MD5 MD5 MD5 MD5 |
repository.name.fl_str_mv |
Repositorio de la Universidad de la Costa CUC |
repository.mail.fl_str_mv |
repdigital@cuc.edu.co |
_version_ |
1811760726401875968 |
spelling |
Coronado-Hernandez, Jairo R.Ospina Mateus, HolmanBaron-Villamizar, JavierVidal, LucelysPiñeres Castillo, Aurora PatriciaRojas-Millán, Rafael H.Silva, Jesús2020-08-13T16:55:34Z2020-08-13T16:55:34Z2020https://hdl.handle.net/11323/6920Corporación Universidad de la CostaREDICUC - Repositorio CUChttps://repositorio.cuc.edu.co/Retail store operations face a variety of challenges and complexities. Determining the best assortment is the main problem in the retail store. This re-search presents a practical methodology for the analysis of products in the assortment with the goal of reducing the excess items and improve sales and profit margin of a retail store without affecting customer satisfaction. The methodology integrates 6 steps that allow to optimize products of a portfolio in categories, sub categories and segments, through Pareto analysis and clustering analysis using the BCG matrix. The methodology was applied in an independent supermarket. The results in the case of the application for non-perishable products, allowed to identify a set of different products (n = 152), of which they were prioritized in a subcategory (oils) in which 90 products were prioritized. In the example, it shows how 21 products have significant results in the variety of products. The combination of the global and local category of the product, the net profit, the inventory rotation and the participation of the growth provides a multifactorial analysis in the decision-making to supply with products a retail store seeking to increase the level of service and maximizing profits.Coronado-Hernandez, Jairo R.-will be generated-orcid-0000-0003-4360-6128-600Ospina Mateus, Holman-will be generated-orcid-0000-0002-2385-774X-600Baron-Villamizar, JavierVidal, Lucelys-will be generated-orcid-0000-0002-8083-7251-600Piñeres Castillo, Aurora Patricia-will be generated-orcid-0000-0003-2445-8297-600Rojas-Millán, Rafael H.Silva, JesúsengCorporación Universidad de la CostaCC0 1.0 Universalhttp://creativecommons.org/publicdomain/zero/1.0/info:eu-repo/semantics/closedAccesshttp://purl.org/coar/access_right/c_14cbAdvances in Cybernetics, Cognition, and Machine Learning for Communication Technologieshttps://link.springer.com/chapter/10.1007%2F978-981-15-3125-5_51RationalizationPortfolio optimizationClustering analysisRetailA method to rationalize the product portfolio in retail storesArtículo de revistahttp://purl.org/coar/resource_type/c_6501http://purl.org/coar/resource_type/c_2df8fbb1Textinfo:eu-repo/semantics/articlehttp://purl.org/redcol/resource_type/ARTinfo:eu-repo/semantics/acceptedVersionPublicationORIGINALA METHOD TO RATIONALIZE THE PRODUCT PORTFOLIO IN RETAIL STORES.pdfA METHOD TO RATIONALIZE THE PRODUCT PORTFOLIO IN RETAIL STORES.pdfapplication/pdf106711https://repositorio.cuc.edu.co/bitstreams/b0f62752-e80b-4280-bc58-186927c05e63/downloadea956f6d8f9cceab59d5604a9c235764MD51CC-LICENSElicense_rdflicense_rdfapplication/rdf+xml; charset=utf-8701https://repositorio.cuc.edu.co/bitstreams/82632b9a-ccf9-440b-bdf6-e775bc675e3b/download42fd4ad1e89814f5e4a476b409eb708cMD52LICENSElicense.txtlicense.txttext/plain; charset=utf-83196https://repositorio.cuc.edu.co/bitstreams/389a3c1f-f089-47a8-a2ee-1f845f3890d8/downloade30e9215131d99561d40d6b0abbe9badMD53THUMBNAILA METHOD TO RATIONALIZE THE PRODUCT PORTFOLIO IN RETAIL STORES.pdf.jpgA METHOD TO RATIONALIZE THE PRODUCT PORTFOLIO IN RETAIL STORES.pdf.jpgimage/jpeg60814https://repositorio.cuc.edu.co/bitstreams/79b3f0b4-3b4a-4249-9605-804cf5a50212/download94c86ba0be640a8801582e08678c1a1dMD54TEXTA METHOD TO RATIONALIZE THE PRODUCT PORTFOLIO IN RETAIL STORES.pdf.txtA METHOD TO RATIONALIZE THE PRODUCT PORTFOLIO IN RETAIL STORES.pdf.txttext/plain1607https://repositorio.cuc.edu.co/bitstreams/dc82b6dd-48dd-4a12-a4b5-c6baa7fef684/download956533dff649b7cf8dec9b6891ea4846MD5511323/6920oai:repositorio.cuc.edu.co:11323/69202024-09-17 10:49:53.807http://creativecommons.org/publicdomain/zero/1.0/CC0 1.0 Universalopen.accesshttps://repositorio.cuc.edu.coRepositorio de la Universidad de la Costa CUCrepdigital@cuc.edu.coQXV0b3Jpem8gKGF1dG9yaXphbW9zKSBhIGxhIEJpYmxpb3RlY2EgZGUgbGEgSW5zdGl0dWNpw7NuIHBhcmEgcXVlIGluY2x1eWEgdW5hIGNvcGlhLCBpbmRleGUgeSBkaXZ1bGd1ZSBlbiBlbCBSZXBvc2l0b3JpbyBJbnN0aXR1Y2lvbmFsLCBsYSBvYnJhIG1lbmNpb25hZGEgY29uIGVsIGZpbiBkZSBmYWNpbGl0YXIgbG9zIHByb2Nlc29zIGRlIHZpc2liaWxpZGFkIGUgaW1wYWN0byBkZSBsYSBtaXNtYSwgY29uZm9ybWUgYSBsb3MgZGVyZWNob3MgcGF0cmltb25pYWxlcyBxdWUgbWUobm9zKSBjb3JyZXNwb25kZShuKSB5IHF1ZSBpbmNsdXllbjogbGEgcmVwcm9kdWNjacOzbiwgY29tdW5pY2FjacOzbiBww7pibGljYSwgZGlzdHJpYnVjacOzbiBhbCBww7pibGljbywgdHJhbnNmb3JtYWNpw7NuLCBkZSBjb25mb3JtaWRhZCBjb24gbGEgbm9ybWF0aXZpZGFkIHZpZ2VudGUgc29icmUgZGVyZWNob3MgZGUgYXV0b3IgeSBkZXJlY2hvcyBjb25leG9zIHJlZmVyaWRvcyBlbiBhcnQuIDIsIDEyLCAzMCAobW9kaWZpY2FkbyBwb3IgZWwgYXJ0IDUgZGUgbGEgbGV5IDE1MjAvMjAxMiksIHkgNzIgZGUgbGEgbGV5IDIzIGRlIGRlIDE5ODIsIExleSA0NCBkZSAxOTkzLCBhcnQuIDQgeSAxMSBEZWNpc2nDs24gQW5kaW5hIDM1MSBkZSAxOTkzIGFydC4gMTEsIERlY3JldG8gNDYwIGRlIDE5OTUsIENpcmN1bGFyIE5vIDA2LzIwMDIgZGUgbGEgRGlyZWNjacOzbiBOYWNpb25hbCBkZSBEZXJlY2hvcyBkZSBhdXRvciwgYXJ0LiAxNSBMZXkgMTUyMCBkZSAyMDEyLCBsYSBMZXkgMTkxNSBkZSAyMDE4IHkgZGVtw6FzIG5vcm1hcyBzb2JyZSBsYSBtYXRlcmlhLg0KDQpBbCByZXNwZWN0byBjb21vIEF1dG9yKGVzKSBtYW5pZmVzdGFtb3MgY29ub2NlciBxdWU6DQoNCi0gTGEgYXV0b3JpemFjacOzbiBlcyBkZSBjYXLDoWN0ZXIgbm8gZXhjbHVzaXZhIHkgbGltaXRhZGEsIGVzdG8gaW1wbGljYSBxdWUgbGEgbGljZW5jaWEgdGllbmUgdW5hIHZpZ2VuY2lhLCBxdWUgbm8gZXMgcGVycGV0dWEgeSBxdWUgZWwgYXV0b3IgcHVlZGUgcHVibGljYXIgbyBkaWZ1bmRpciBzdSBvYnJhIGVuIGN1YWxxdWllciBvdHJvIG1lZGlvLCBhc8OtIGNvbW8gbGxldmFyIGEgY2FibyBjdWFscXVpZXIgdGlwbyBkZSBhY2Npw7NuIHNvYnJlIGVsIGRvY3VtZW50by4NCg0KLSBMYSBhdXRvcml6YWNpw7NuIHRlbmRyw6EgdW5hIHZpZ2VuY2lhIGRlIGNpbmNvIGHDsW9zIGEgcGFydGlyIGRlbCBtb21lbnRvIGRlIGxhIGluY2x1c2nDs24gZGUgbGEgb2JyYSBlbiBlbCByZXBvc2l0b3JpbywgcHJvcnJvZ2FibGUgaW5kZWZpbmlkYW1lbnRlIHBvciBlbCB0aWVtcG8gZGUgZHVyYWNpw7NuIGRlIGxvcyBkZXJlY2hvcyBwYXRyaW1vbmlhbGVzIGRlbCBhdXRvciB5IHBvZHLDoSBkYXJzZSBwb3IgdGVybWluYWRhIHVuYSB2ZXogZWwgYXV0b3IgbG8gbWFuaWZpZXN0ZSBwb3IgZXNjcml0byBhIGxhIGluc3RpdHVjacOzbiwgY29uIGxhIHNhbHZlZGFkIGRlIHF1ZSBsYSBvYnJhIGVzIGRpZnVuZGlkYSBnbG9iYWxtZW50ZSB5IGNvc2VjaGFkYSBwb3IgZGlmZXJlbnRlcyBidXNjYWRvcmVzIHkvbyByZXBvc2l0b3Jpb3MgZW4gSW50ZXJuZXQgbG8gcXVlIG5vIGdhcmFudGl6YSBxdWUgbGEgb2JyYSBwdWVkYSBzZXIgcmV0aXJhZGEgZGUgbWFuZXJhIGlubWVkaWF0YSBkZSBvdHJvcyBzaXN0ZW1hcyBkZSBpbmZvcm1hY2nDs24gZW4gbG9zIHF1ZSBzZSBoYXlhIGluZGV4YWRvLCBkaWZlcmVudGVzIGFsIHJlcG9zaXRvcmlvIGluc3RpdHVjaW9uYWwgZGUgbGEgSW5zdGl0dWNpw7NuLCBkZSBtYW5lcmEgcXVlIGVsIGF1dG9yKHJlcykgdGVuZHLDoW4gcXVlIHNvbGljaXRhciBsYSByZXRpcmFkYSBkZSBzdSBvYnJhIGRpcmVjdGFtZW50ZSBhIG90cm9zIHNpc3RlbWFzIGRlIGluZm9ybWFjacOzbiBkaXN0aW50b3MgYWwgZGUgbGEgSW5zdGl0dWNpw7NuIHNpIGRlc2VhIHF1ZSBzdSBvYnJhIHNlYSByZXRpcmFkYSBkZSBpbm1lZGlhdG8uDQoNCi0gTGEgYXV0b3JpemFjacOzbiBkZSBwdWJsaWNhY2nDs24gY29tcHJlbmRlIGVsIGZvcm1hdG8gb3JpZ2luYWwgZGUgbGEgb2JyYSB5IHRvZG9zIGxvcyBkZW3DoXMgcXVlIHNlIHJlcXVpZXJhIHBhcmEgc3UgcHVibGljYWNpw7NuIGVuIGVsIHJlcG9zaXRvcmlvLiBJZ3VhbG1lbnRlLCBsYSBhdXRvcml6YWNpw7NuIHBlcm1pdGUgYSBsYSBpbnN0aXR1Y2nDs24gZWwgY2FtYmlvIGRlIHNvcG9ydGUgZGUgbGEgb2JyYSBjb24gZmluZXMgZGUgcHJlc2VydmFjacOzbiAoaW1wcmVzbywgZWxlY3Ryw7NuaWNvLCBkaWdpdGFsLCBJbnRlcm5ldCwgaW50cmFuZXQsIG8gY3VhbHF1aWVyIG90cm8gZm9ybWF0byBjb25vY2lkbyBvIHBvciBjb25vY2VyKS4NCg0KLSBMYSBhdXRvcml6YWNpw7NuIGVzIGdyYXR1aXRhIHkgc2UgcmVudW5jaWEgYSByZWNpYmlyIGN1YWxxdWllciByZW11bmVyYWNpw7NuIHBvciBsb3MgdXNvcyBkZSBsYSBvYnJhLCBkZSBhY3VlcmRvIGNvbiBsYSBsaWNlbmNpYSBlc3RhYmxlY2lkYSBlbiBlc3RhIGF1dG9yaXphY2nDs24uDQoNCi0gQWwgZmlybWFyIGVzdGEgYXV0b3JpemFjacOzbiwgc2UgbWFuaWZpZXN0YSBxdWUgbGEgb2JyYSBlcyBvcmlnaW5hbCB5IG5vIGV4aXN0ZSBlbiBlbGxhIG5pbmd1bmEgdmlvbGFjacOzbiBhIGxvcyBkZXJlY2hvcyBkZSBhdXRvciBkZSB0ZXJjZXJvcy4gRW4gY2FzbyBkZSBxdWUgZWwgdHJhYmFqbyBoYXlhIHNpZG8gZmluYW5jaWFkbyBwb3IgdGVyY2Vyb3MgZWwgbyBsb3MgYXV0b3JlcyBhc3VtZW4gbGEgcmVzcG9uc2FiaWxpZGFkIGRlbCBjdW1wbGltaWVudG8gZGUgbG9zIGFjdWVyZG9zIGVzdGFibGVjaWRvcyBzb2JyZSBsb3MgZGVyZWNob3MgcGF0cmltb25pYWxlcyBkZSBsYSBvYnJhIGNvbiBkaWNobyB0ZXJjZXJvLg0KDQotIEZyZW50ZSBhIGN1YWxxdWllciByZWNsYW1hY2nDs24gcG9yIHRlcmNlcm9zLCBlbCBvIGxvcyBhdXRvcmVzIHNlcsOhbiByZXNwb25zYWJsZXMsIGVuIG5pbmfDum4gY2FzbyBsYSByZXNwb25zYWJpbGlkYWQgc2Vyw6EgYXN1bWlkYSBwb3IgbGEgaW5zdGl0dWNpw7NuLg0KDQotIENvbiBsYSBhdXRvcml6YWNpw7NuLCBsYSBpbnN0aXR1Y2nDs24gcHVlZGUgZGlmdW5kaXIgbGEgb2JyYSBlbiDDrW5kaWNlcywgYnVzY2Fkb3JlcyB5IG90cm9zIHNpc3RlbWFzIGRlIGluZm9ybWFjacOzbiBxdWUgZmF2b3JlemNhbiBzdSB2aXNpYmlsaWRhZA== |