System and method for inventory display management tool
A method and system for allocating displays to a plurality of stores grouped into a plurality of store configurations is presented. It includes receiving a plurality of counts, that specifies spaces available in the store configuration for one of a plurality of types of displays, a ranking of a plurality of displays, wherein the ranking is based on a benefit of each of the plurality of displays for the store configuration, and when the plurality of displays are to be allocated to the plurality of stores; determining a subset of the plurality of displays that meet one or more conditions related to at least one of a forecasted sell through or forecasted margin of the plurality of displays for the store, allocating at least some of the displays based on the ranking of the displays, and generating an indication of the allocated displays for output to a user.
1. A method for optimizing an allocation of a plurality of available display structures of a plurality of display structure categories among a plurality of stores grouped into a plurality of store configurations, the method comprising:
assigning, by a display allocation module stored on one or more memories of at least one computing device, a first one or more available display structures of the plurality of available display structures to a first store of the plurality of stores, the assigning based on:
(i) a determination, for each category of one or more display structure categories of the plurality of display structure categories, that the first one or more available display structures meet one or more conditions corresponding to the first store during a period of time in the future when the plurality of available display structures is to be allocated among the plurality of stores, and
(ii) a plurality of counts, each count of the plurality of counts indicative of a respective number of spaces available in a store configuration of the first store for the each category of the one or more display structure categories;
updating, based on the assigning of the first one or more available display structures, the plurality of available display structures to exclude the first one or more available display structures assigned to the first store;
assigning, by the display allocation module to a second store included in the plurality of stores and based on a store configuration of the second store, a second one or more available display structures of the updated plurality of available display structures; and
updating, based on the assigning of the second one or more available display structures, the updated plurality of available display structures to exclude the second one or more available display structures assigned to the second store.
2. The method of claim 1 , wherein the assigning of the first one or more available display structures to the first store is further based on a ranking of available display structures meeting the one or more conditions, the ranking based on respective benefits of the available display structures meeting the one or more conditions for the store configuration of the first store.
3. The method of claim 2 , further comprising determining the ranking of the available display structures meeting the one or more conditions.
4. The method of claim 2 , wherein the respective benefits for the store configuration of the first store are based on at least one of: respective historical sales data, respective models of sales, respective forecasted margins, or respective forecasted sellthroughs corresponding to each available display structure meeting the one or more conditions.
5. The method of claim 1 , wherein the determination that the first one or more available display structures meet the one or more conditions corresponding to the first store is based on one or more of: a threshold corresponding to a maximum number of display structures for a geographic area, a respective threshold corresponding to a number of display structures that are to be distributed to a respective store, or a respective threshold corresponding to a timing of display structure allocation to a respective store.
6. The method of claim 1 , wherein the assigning of the first one or more available display structures to the first store includes determining that at least some of the plurality of available display structures meet the one or more conditions corresponding to the first store during the period of time in the future.
7. The method of claim 6 ,
further comprising ordering the plurality of stores based on at least one of respective forecasted sell throughs or respective forecasted margins of the plurality of stores during the period of time in the future, and filtering the ordered plurality of stores based on values of the at least one of the respective forecasted sell throughs or the respective forecasted margins; and
wherein the determination that the at least some of the plurality of available display structures meet the one or more conditions corresponding to the first store during the period of time in the future is based on the filtering.
8. The method of claim 7 , wherein the ordering of the plurality of stores is further based on at least one of respective geographic locations of the plurality of stores, respective store configurations of the plurality of stores, or respective sizes of the plurality of stores.
9. The method of claim 1 , wherein:
the one or more display structure categories is a first one or more display structure categories,
the one or more conditions is a first one or more conditions, and
the assigning of the second one or more available display structures of the updated plurality of available display structures to the second store is further based on a determination, for each category of a second one or more display structure categories of the plurality of display structure categories, that the second one or more available display structures of the updated plurality of available display structures meet a second one or more conditions corresponding to the second store.
10. A system, comprising:
one or more processors;
one or more non-transitory memories; and
computer-executable instructions that are stored on the one or more non-transitory memories, that specially configure the system, and that, when executed by the one or more processors, cause the system to:
assign a first one or more available display structures of the plurality of available display structures to a first store of the plurality of stores, the assignment based on:
(i) a determination, for each category of one or more display structure categories of the plurality of display structure categories, that the first one or more available display structures meet one or more conditions corresponding to the first store during a period of time in the future when the plurality of available display structures is to be allocated among the plurality of stores, and
(ii) a plurality of counts, each count of the plurality of counts indicative of a respective number of spaces available in a store configuration of the first store for the each category of the one or more display structure categories;
update, based on the assignment of the first one or more available display structures, the plurality of available display structures to exclude the first one or more available display structures assigned to the first store;
assign, to a second store included in the plurality of stores and based on a store configuration of the second store, a second one or more available display structures of the updated plurality of available display structures; and
update, based on the assignment of the second one or more available display structures, the updated plurality of available display structures to exclude the second one or more available display structures assigned to the second store.
11. The system of claim 10 , wherein the assignment of the first one of more available display structures to the first store is further based on a ranking of available display structures meeting the one or more conditions, the ranking based on respective benefits of the available display structures meeting the one or more conditions for the store configuration of the first store.
12. The system of claim 11 , wherein the computer-executable instructions are further executable to cause the system to determine the ranking of the available display structures meeting the one or more conditions.
13. The system of claim 11 , wherein the respective benefits of the available display structures meeting the one or more conditions are based on at least one of respective historical sales data, respective models of sales, respective forecasted margins, or respective forecasted sellthroughs corresponding to each available display structure meeting the one or more conditions.
14. The system of claim 13 , wherein at least one of: the respective forecasted margins include a respective per-item forecasted margin, or the respective forecasted sellthroughs include a respective per-item sell through.
15. The system of claim 13 , wherein the respective benefits of the available display structures meeting the one or more conditions are based on machine learning applied to at least one of the respective historical sales data or the respective models of sales.
16. The system of claim 10 , wherein:
an ordering of the plurality of stores is based on at least one of respective forecasted sell throughs or respective forecasted margins of the plurality of stores during the period of time in the future;
the ordered plurality of stores is filtered based on values of the at least one of the respective forecasted sell throughs or the respective forecasted margins; and
the determination that the first one or more available display structures meet the one or more conditions is based on the filtered, ordered plurality of stores.
17. The system of claim 16 , wherein the ordering of the plurality of stores is further based on at least one of respective geographic locations of the plurality of stores, respective store configurations of the plurality of stores, or respective sizes of the plurality of stores.
18. The system of claim 10 , wherein the one or more conditions include at least one of a margin threshold or a sell through threshold related to display structures.
19. The system of claim 10 , wherein the one or more conditions include at least one of: a threshold corresponding to a maximum number of display structures for a geographic area in which the first store is located, a threshold corresponding to a number of display structures that are to be distributed to the first store, or a threshold corresponding to a timing of display structure allocation to the first store.
20. The system of claim 10 , wherein:
the one or more display structure categories is a first one or more display structure categories,
the one or more conditions is a first one or more conditions, and
assignment of the second one or more available display structures of the updated plurality of available display structures to the second store is further based on a determination, for each category of a second one or more display structure categories of the plurality of display structure categories, that the second one or more available display structures of the updated plurality of available display structures meet a second one or more conditions corresponding to the second store.