Methods and systems for inventory planning and control
Methods and systems for visualizing an inventory management and control. One method comprises receiving and aggregating inventory data from a plurality of nodes of a retail enterprise, scheduling a plurality of purchase orders for at least one item type based on the inventory data, generating inventory projections for the at least one item type based on the inventory data and the plurality of purchase orders, and rendering on a display, as part of a visualization tool user interface, a graphical view representing the inventory projections for the at least one item type, wherein the graphical view automatically updates based on inputs received for adjusting at least one purchase order of the plurality of purchase orders and inputs received for selecting at least one node or at least one group of nodes from the plurality of nodes.
1. A method for visualizing an inventory management and control for a retail enterprise, the method comprising:
receiving and aggregating inventory data from a plurality of nodes of the retail enterprise;
scheduling a plurality of purchase orders for at least one item type based on the inventory data;
executing a first simulation to generate projected inventory levels for the at least one item type based on the inventory data and the plurality of purchase orders;
rendering on a display, as part of a visualization tool user interface, a single graph that displays, over time, past demand for the at least one item type, past inventory levels for the at least one item type, current inventory levels for the at least one item type, the plurality of purchase orders for the at least one item type, projected inventory levels for the at least one item type, and projected fulfilled and unfulfilled demand for the at least one item type, wherein the single graph displays a purchase order on a horizontal axis of the single graph at a time when the purchase order is to be automatically executed, and wherein the past demand is visually separated by a fulfilled past demand represented by a first color and an unfulfilled past demand represented by a second color, the second color being brighter than the first color;
receiving, via the visualization tool user interface, an input adjusting at least one purchase order of the plurality of purchase orders by at least performing:
displaying a chart that displays the purchase order and includes a column corresponding to a time for the purchase order; and
receiving, in a date selection field located in the column corresponding to the time for the purchase order, a modification of the time when the purchase order is to be automatically executed;
in response to receiving the input, automatically executing a second simulation using a modified time when the purchase order is to be automatically executed received via the date selection field to generate updated projected inventory levels for the at least one item type and to generate updated projected fulfilled and unfulfilled demand for the at least one item type;
dependent on the second simulation, updating the single graph in real time to display the updated projected inventory levels for the at least one item type, to display the updated projected fulfilled and unfulfilled demand for the at least one item type, and to display the purchase order on the horizontal axis of the single graph at the modified time when the purchase order is to be automatically executed; and
automatically generating and displaying an alert in the visualization tool user interface in response to determining, based on updated inventory data received from the plurality of nodes, that an actual inventory level deviates from the updated projected inventory levels determined by executing the second simulation using the modified time when the purchase order is to be automatically executed.
2. The method of claim 1 , wherein the input adjusting the at least one purchase order includes adjusting one of:
(1) a timing of the at least one purchase order;
(2) a quantity of the at least one item type in the at least one purchase order;
(3) a constraint of the at least one item type in the at least one purchase order, and
(4) adding an additional purchase order to the plurality of purchase orders.
3. The method of claim 1 , wherein at least one node of the plurality of nodes is a distribution center.
4. The method of claim 1 , wherein the inventory data includes projected orders and projected item receipts corresponding to the plurality of purchase orders.
5. The method of claim 1 , the method further comprising:
receiving inputs selecting a frequency for aggregating the inventory data, wherein the inventory data is aggregated based on the frequency.
6. The method of claim 5 , wherein the frequency for aggregating the inventory data is one of daily, weekly, and hourly.
7. The method of claim 1 , the method further comprising:
calculating at least one of a projected revenue and a projected profit based on the projected fulfilled and unfulfilled demand for the at least one item type.
8. The method of claim 1 , wherein the projected inventory levels for the at least one item are updated in real-time on the single graph as the inputs adjusting the at least one purchase order are received.
9. The method of claim 1 , the method further comprising:
receiving additional inputs which define a constraint, wherein the constraint limits at least one constrained purchase order of the plurality of purchase orders; and
adjusting at least one other purchase orders of the plurality of purchase orders based on the constraint.
10. The method of claim 9 , wherein adjusting the at least one other purchase order includes increasing a quantity of the at least one item type in the at least one other purchase order in advanced of the at least one constrained purchase order.
11. The method of claim 9 , wherein the adjusting the at least one other purchase order is done automatically.
12. The method of claim 1 , the method further comprising:
based on the updated projected inventory levels generated by the simulation, identifying a projected stockout event based on the updated projected inventory levels being lower than a projected demand for the at least one item type; and
displaying, as part of the visualization tool user interface, an alert for the projected stockout event.
13. The method of claim 1 , the method further comprising:
receiving movement inputs to move a plurality of items of the at least one item type between nodes of the plurality of nodes; and
updating, automatically, the inventory data based on the movement inputs.
14. The method of claim 1 , wherein the group of nodes represents a geographical region.
15. An inventory management and control system comprising:
at least one processor;
at least one memory storage device, the memory storage device storing instructions which when executed by the at least one processor cause the inventory management and control system to:
receive and aggregate inventory data from a plurality of nodes of a retail enterprise;
schedule a plurality of purchase orders for at least one item type based on the inventory data;
execute a first simulation to generate projected inventory levels for the at least one item type based on the inventory data and the plurality of purchase orders;
render on a display, as part of a visualization tool user interface, a single graph that displays, over time, past demand for the at least one item type, past inventory levels for the at least one item type, current inventory levels for the at least one item type, the plurality of purchase orders for the at least one item type, projected inventory levels for the at least one item type, and projected fulfilled and unfulfilled demand for the at least one item type, wherein the single graph displays a purchase order on a horizontal axis of the single graph at a time when the purchase order is to be automatically executed, and wherein the past demand is visually separated by a fulfilled past demand represented by a first color and an unfulfilled past demand represented by a second color, the second color being brighter than the first color;
receive, via the visualization tool user interface, an input adjusting at least one purchase order of the plurality of purchase orders by at least performing:
displaying a chart that displays the purchase order and includes a column corresponding to a time for the purchase order; and
receiving, in a date selection field located in the column corresponding to the time for the purchase order, a modification of the time when the purchase order is to be automatically executed;
in response to receiving the input, automatically execute a second simulation using a modified time when the purchase order is to be automatically executed received via the date selection field to generate updated projected inventory levels for the at least one item type and to generate updated projected fulfilled and unfulfilled demand for the at least one item type; and
dependent on the second simulation, update the single graph in real time to display the updated projected inventory levels for the at least one item type, to display the updated projected fulfilled and unfulfilled demand for the at least one item type, and to display the purchase order on the horizontal axis of the single graph at the modified time when the purchase order is to be automatically executed.
16. The inventory management and control system of claim 15 , wherein the instructions, when executed by the at least one processor, further cause the inventory management and control system to:
receive additional inputs which define a constraint, wherein the constraint limits at least one constrained purchase order of the plurality of purchase orders; and
adjust at least one other purchase orders of the plurality of purchase orders based on the constraint.
17. The inventory management and control system of claim 16 , wherein to adjust the at least one other purchase order includes to increase a quantity of the at least one item type in the at least one other purchase order in advanced of the at least one constrained purchase order.
18. The inventory management and control system of claim 16 , wherein to adjust the at least one other purchase order is done automatically.
19. One or more non-transitory computer-readable storage devices storing data instructions that, when executed by at least one processing device cause the at least one processing device to:
receive and aggregate inventory data from a plurality of nodes of a retail enterprise;
schedule a plurality of purchase orders for at least one item type based on the inventory data;
execute a first simulation to generate projected inventory levels for the at least one item type based on the inventory data and the plurality of purchase orders;
render on a display, as part of a visualization tool user interface, a single graph that displays, over time, past demand for the at least one item type, past inventory levels for the at least one item type, current inventory levels for the at least one item type, the plurality of purchase orders for the at least one item type, projected inventory levels for the at least one item type, and projected fulfilled and unfulfilled demand for the at least one item type, wherein the single graph displays a purchase order on a horizontal axis of the single graph at a time when the purchase order is to be automatically executed;
receive, via the visualization tool user interface, an input adjusting at least one purchase order of the plurality of purchase orders by at least performing:
displaying a chart that displays the purchase order and a date selection field corresponding to a time for the purchase order; and
receiving, in the date selection field, a modification of the time when the purchase order is to be automatically executed;
in response to receiving the input, automatically execute a second simulation using a modified time when the purchase order is to be automatically executed received via the date selection field to generate updated projected inventory levels for the at least one item type and to generate updated projected fulfilled and unfulfilled demand for the at least one item type; and
dependent on the second simulation, update the single graph to display the updated projected inventory levels for the at least one item type, to display the updated projected fulfilled and unfulfilled demand for the at least one item type, and to display the purchase order on the horizontal axis of the single graph at the modified time when the purchase order is to be automatically executed.