JP2021039532A - Inventory management program, inventory management method and inventory management system - Google Patents

Abstract

To manage inventory using a threshold value matching an inventory status of each user.SOLUTION: An inventory management program is provided for making a computer execute processes of: calculating the number of days in stock in a first period including a plurality of consecutive unit periods from the number of inventories and the number of shipments for each unit period of an item to be processed; based on a predetermined under-reference value for determining whether or not inventory is insufficient and/or a predetermined excess reference value for determining whether or not inventory is excessive, a statistical value of the number of days in stock in a second period different from the first period, and a statistical value of the number of shipments in the second period, calculating a first threshold for determining whether or not the inventory for the item is insufficient and/or a second threshold for determining whether or not the inventory for the item is excessive; and determining whether or not the inventory of the item is insufficient and/or excessive based on the number of days in stock and the first threshold value and/or the second threshold value.SELECTED DRAWING: Figure 6

Description

The present disclosure relates to inventory management programs, inventory management methods and inventory management systems.

An inventory management method has been proposed for the purpose of safe and efficient inventory management. For example, Patent Document 1 predicts inventory quantity fluctuations in round-trip logistics from past shipment record information and the like, and adjusts inventory based on the prediction results.

Japanese Unexamined Patent Publication No. 11-12255 Japanese Unexamined Patent Publication No. 2004-302553 Japanese Unexamined Patent Publication No. 2012-066886

However, in the above method, it is determined whether the inventory is insufficient or excessive based on the number of inventories and the preset upper and lower limit quantities of the inventory, and an instruction to replenish or raise the product is instructed. And its quantity. Therefore, when the quantity of the upper limit value and the lower limit value of the inventory fixed in advance is no longer a value suitable for determining the under or excess of the inventory with respect to the inventory whose situation changes daily, the inventory is under or over. The result of the judgment will not be accurate.

Therefore, in one aspect, the present disclosure provides inventory management using a threshold value that matches the inventory status of each user.

In one embodiment, a process of calculating the number of days in stock in a first period including a plurality of consecutive unit periods from the number of stocks and the number of shipments for each unit period for the item to be processed, and whether or not the stock is insufficient. A predetermined under-reference value for determining whether or not the inventory is excessive, and / or a predetermined excess reference value for determining whether or not the inventory is excessive, a statistical value of the number of days in stock in a second period different from the first period, and the above-mentioned Based on the statistical value of the number of shipments in the second period, the first threshold value for determining whether the inventory for the item is insufficient and / or the second for determining whether the inventory for the item is excessive. A computer for calculating the threshold value of the item and determining whether or not the inventory of the item is insufficient and / or excessive based on the number of days in stock and the first threshold value and / or the second threshold value. Is provided with an inventory management program to be executed.

In one aspect, the present disclosure can perform inventory management using a threshold value that matches the inventory status of each user.

The figure which shows an example of the conventional inventory management. The figure which shows the inventory management system which concerns on one Embodiment. The figure which shows the hardware configuration of the server which concerns on one Embodiment. The figure which shows the hardware configuration of the terminal apparatus which concerns on one Embodiment. A flowchart showing an inventory management method according to an embodiment. The figure for demonstrating the inventory management method which concerns on one Embodiment. The figure which shows the display example of the underdetermination result which concerns on one Embodiment. The flowchart which shows the threshold value calculation method of the under-excess determination which concerns on one Embodiment. The figure for demonstrating the threshold calculation method of the under-excess determination which concerns on one Embodiment. The flowchart which shows the period calculation method of the under-excess determination which concerns on one Embodiment. The figure for demonstrating the period calculation method of the under-excess determination which concerns on one Embodiment. The figure which displayed the under ratio which concerns on one Embodiment and the event information in association with each other.

Hereinafter, one embodiment will be described with reference to the accompanying drawings. In the present specification and the drawings, components having substantially the same functional configuration are designated by the same reference numerals to omit duplicate explanations.

[Inventory control]
In supply and demand adjustment, it is important to understand the inventory status, but it is difficult to manage inventory for a wide variety of products and items. For example, simply automatically extracting an item whose inventory is in an under or excess state (hereinafter, also referred to as "under or over state") may cause the under or excess state of the product to be temporary or chronic. It is difficult for the user to determine whether or not. Therefore, the user cannot accurately grasp whether the product should be dealt with urgently or the product does not need to be dealt with urgently. In particular, when the number of target products in an under or excess state becomes large (for example, hundreds or thousands), the user should check the under or excess state for each product and take urgent measures such as inventory adjustment. It is difficult to determine whether it is a product other than that.

Therefore, if it is possible to automatically extract items that are in an under or excess state and automatically determine whether the under or over state is temporary or chronic, the user can use the determination result to make a more efficient inventory. It becomes possible to manage. In addition, a "threshold" used to determine an understock or excess state, and a "period" of time-series inventory information used to determine whether an understock or excess state is temporary or chronic. If can be set automatically, it is possible to obtain a judgment result that matches the inventory status that changes daily.

For example, FIG. 1 shows an example of conventional inventory management. In the example of FIG. 1, it is determined from the number of inventories on the previous day whether the inventory on the current day is too small or excessive, and the number of next shipments or productions is determined based on the determination result. At this time, a "threshold value" is used to determine whether the inventory is too low or too high. If the threshold value is not an appropriate value for determining whether the inventory is too low or too large, the judgment result of the inventory status will not be accurate.

Further, in the example of FIG. 1, not only the previous day (1 day ago) but also the inventory information of 2 days to 7 days ago is used to determine the under or excess state of each day, and based on the determination, more than half are under or over states. In some cases, it is determined to be in a chronic under or excess state, and in other cases, it is determined to be in a temporary under or excess state. In this case, 7 days was used as the "period" of the inventory information used for determining the under or excess state. If the period is not an appropriate value for determining whether the under or excess state is temporary or chronic, the inventory status judgment result will not be accurate.

Therefore, in the inventory management system according to the present embodiment, the setting of the threshold value and the period is automated. This makes it possible to set and update thresholds and periods according to the latest inventory status. As a result, inventory management can be performed for each user using a threshold value and a period that match the inventory status. Furthermore, the load of inventory management processing can be reduced by automating the setting of the threshold value and the period.

[Inventory management system]
Hereinafter, the inventory management system according to the embodiment will be described with reference to FIG. FIG. 2 is a diagram showing an inventory management system 1 according to an embodiment. The inventory management system 1 has a server 10 and a terminal device 20. The server 10 is connected to the terminal device 20 of the user (user of the inventory management system 1) via the network 40.

The server 10 executes the inventory management method according to the embodiment, extracts items in an understock or excess state, and determines whether the under or excess state is temporary or chronic. Further, the server 10 has a "threshold value" used to determine an understock or excess state, and among the stored time-series inventory information (log information), the understock or excess state is temporary or is. The "period" of the inventory information used to determine whether it is chronic is determined, and the threshold value and the setting of the period are updated at a predetermined timing.

The terminal device 20 displays the result of the insufficient or excessive inventory determined by the server 10 on the display using a browser or the like. The terminal device 20 may receive a notification from the server 10 about the result of the inventory shortage or excess state determined by the server 10.

The server 10 may be an information processing device such as a computer, or may be a server on a network that provides a cloud service. A plurality of computers in the inventory management system 1 cooperate with each other so that a part or all of the processing performed by the server 10 is executed by the inventory management system 1 or another server on the network 40, and the remaining processing is executed by the server 10. Then, a series of processes for inventory management may be performed.

As an example of the terminal device 20, a portable device such as a smartphone or a tablet terminal, a personal computer, a wearable device such as an HMD (Head Mount Display) or an FMD (Face Mount Display) may be used. As another example of the terminal device 20, an information processing device such as a computer may be used.

The terminal device 20 may perform inventory management instead of the server 10. In this case, the inventory management system 1 does not have to have the server 10. For example, the terminal device 20 may have the function of the server 10 described below, and the terminal device 20 may perform inventory management.

[Server function configuration]
Next, an example of the functional configuration of the server 10 will be described with reference to FIG. The server 10 includes a communication unit 11, a reception unit 12, a calculation unit 13, a determination unit 14, a display control unit 15, and a storage unit 16.

The communication unit 11 communicates with the terminal device 20 and other computers connected to the network 40. The reception unit 12 receives requests from the terminal device 20 and other computers.

The calculation unit 13 calculates the number of days in stock in the first period including a plurality of consecutive unit periods from the number of stocks and the number of shipments of the item to be processed for each unit period. The calculation unit 13 has a predetermined under-reference value for determining whether or not the inventory is insufficient and / or a predetermined excess reference value for determining whether or not the inventory is excessive, and a second period different from the first period. Based on the statistical value of the number of days in stock in the above and the statistical value of the number of shipments in the second period, a first threshold value for determining whether or not the inventory of the item is insufficient and / or the inventory of the item. A second threshold value for determining whether or not is excessive is calculated. The under-reference value and / or the excess reference value may be set for each user who uses the determination result of whether or not the inventory of the item is under-and / or over-excess.

The determination unit 14 determines whether or not the inventory of the item is insufficient and / or excessive based on the number of days in stock and the first threshold value and / or the second threshold value.

The calculation unit 13 may determine the first period from a plurality of predetermined candidate periods based on the ratio of days when the number of shipments within each candidate period is 1 or more. The second period is predetermined, such as one year or half a year.

The display control unit 15 displays whether or not the inventory of the item is insufficient and / or excessive. The display control unit 15 may display the ratio of understock and / or the ratio of excess inventory for each item. The display control unit 15 may display the event information in association with the ratio in which the inventory of the item is insufficient and / or the ratio in which the inventory of the item is excessive.

The storage unit 16 has an inventory information database 30, a shipping information database 31, and an event information database 32. The inventory information database 30 stores the number of inventories for each product or item in chronological order. The shipping information database 31 stores the number of shipments for each product or item in chronological order. The event information database 32 stores the product or item in association with the event.

[Functional configuration of terminal device]
Next, an example of the functional configuration of the terminal device 20 will be described. The terminal device 20 includes an operation unit 21, a communication unit 22, a control unit 23, a display unit 24, and a storage unit 25. The operation unit 21 inputs a touch operation or a keyboard operation by a user who uses the terminal device 20. The communication unit 22 communicates with the server 10 and other computers connected to the network 40.

The control unit 23 executes a predetermined process based on the information input by the operation unit 21 in response to the user's touch operation or keyboard operation. For example, the control unit 23 launches an inventory management application based on an operation performed by the user, and requests the server 10 to execute an inventory management method for determining an inventory shortage or excess state.

The display unit 24 displays the determination result of the insufficient or excessive inventory executed by the server 10 on the display of the terminal device 20 by using, for example, a browser. The storage unit 25 stores information such as a determination result regarding inventory management determined by the server 10.

[Server hardware configuration]
Next, an example of the hardware configuration of the server 10 will be described with reference to FIG. FIG. 3 is a diagram showing a hardware configuration of the server 10 according to the embodiment. The server 10 includes an input device 111, a display device 112, an external I / F 113, a communication I / F 114, a ROM 115, a RAM 116, a CPU 117, and an auxiliary storage device 118. Each part is connected to each other by a bus.

The input device 111 is, for example, a touch panel, a keyboard, and a mouse, and is used to perform various input operations on the server 10. The display device 112 is, for example, a touch panel type display and displays various data.

The external I / F 113 is an interface with an external device. The external device includes a recording medium 113a and the like. The server 10 can read and write to the recording medium 113a via the external I / F 113. The recording medium 113a includes, for example, an SD memory card, a USB (Universal Serial Bus) memory, and the like.

The communication I / F 114 is an interface for connecting the server 10 to the network. The server 10 communicates with the terminal device 20 and other devices via the communication I / F 114.

The ROM 115 is a non-volatile semiconductor memory that can retain data even when the power is turned off. The RAM 116 is a volatile semiconductor memory that temporarily holds programs and data. The CPU 117 is an arithmetic unit that reads a program or data from, for example, an auxiliary storage device 118 or a ROM 115 onto the RAM 116 and executes an inventory management process.

The auxiliary storage device 118 is a non-volatile auxiliary storage device that stores programs and data. The inventory management program may be stored in the auxiliary storage device 118.

The function of the server 10 shown in FIG. 2 is realized by the server 10 having the hardware configuration shown in FIG. For example, the function of the communication unit 11 is realized by the communication I / F 114. Each function of the reception unit 12, the calculation unit 13, the determination unit 14, and the display control unit 15 is realized by the CPU 117 executing the inventory management program. The function of the storage unit 16 is realized by the ROM 115, the RAM 116, or the auxiliary storage device 118.

[Hardware configuration of terminal device]
Next, an example of the hardware configuration of the terminal device 20 will be described with reference to FIG. FIG. 4 is a diagram showing a hardware configuration of the terminal device 20 according to the embodiment. The terminal device 20 according to the present embodiment includes a display 211, a CPU 212, a memory 213, a touch panel 214, and a communication I / F (interface) 215.

The CPU 212 controls each part of the terminal device 20 in an integrated manner. The function provided in the terminal device 20 is realized by the CPU 212 reading a program stored in a memory 213 composed of a ROM, a RAM, or the like into a RAM or the like and executing the program. For example, the CPU 212 can request the server 10 to execute the inventory management method by reading the application program stored in the memory 213 into a RAM or the like and executing the application program. As a result, the CPU 212 realizes overall control of the terminal device 20 and each function mounted on the terminal device 20.

The display 211 may be a liquid crystal display or an organic EL (electroluminescence) display. The touch panel 214 is installed so as to be superposed on the display 211, whereby the user can receive an input operation performed by directly touching the touch panel 214 with a finger while looking at the screen of the display 211. The touch panel 214 is an input device that detects a touch position by a finger or the like and a detection amount such as a capacitance or an electric resistance amount indicating a contact state at the touch position. As a result, the user's operation can be detected from the coordinates of the touch position with respect to the screen of the terminal device 20. Examples of the sensor include a pressure sensor, a capacitance sensor, an optical sensor and the like.

The communication I / F 215 is an interface for connecting the terminal device 20 to the network. The terminal device 20 communicates with the server 10 and other devices via the communication I / F 215.

The function of the terminal device 20 shown in FIG. 2 is realized by the terminal device 20 having the hardware configuration shown in FIG. For example, the function of the operation unit 21 is realized by the touch panel 214. The function of the communication unit 22 is realized by the communication I / F 215. The function of the control unit 23 is realized by the CPU 212 executing a predetermined program. The function of the display unit 24 is realized by the display 211. The function of the storage unit 25 is realized by the memory 213.

[Inventory management method]
Next, an example of the inventory management method according to the present embodiment will be described with reference to FIGS. 5 and 6. FIG. 5 is a flowchart showing an inventory management method according to an embodiment. FIG. 6 is a diagram for explaining an inventory management method according to an embodiment. This process may be executed periodically such as once / day or every predetermined time, or may be executed irregularly such as when there is a request for inventory management from the terminal device 20.

When this process is executed, the calculation unit 13 acquires the inventory quantity and the shipment quantity for each item in the first period (step S1). The "first period" is a period of the date corresponding to the number of stocks and the number of shipments used for determining the under or excess state among the number of stocks and the number of shipments stored in the time series. The automation of the setting of the first period will be described later with reference to FIG. In the present embodiment, for example, the first period is set to 7 days from immediately before (previous day: 2017/7/1), and the calculation unit 13 is stored in the inventory information database 30 from the previous day (1 day before) to 7 days before. The number of stocks and the number of shipments stored in the shipping information database 31 from the previous day (1 day ago) to 7 days ago are acquired. FIG. 6 shows an example of the inventory information database 30. The inventory information database 30 stores a product code, a category, a date from the previous day (2017/7/1) to 7 days ago (2017/7/7), and the number of stocks. Further, FIG. 6 shows an example of the shipping information database 31. The shipping information database 31 stores the product code, category, the date from the previous day (2017/7/1) to 7 days ago (2017/7/7), and the number of shipments. However, the number of stocks stored in the inventory information database 30 and the number of shipments stored in the shipping information database 31 shown in FIG. 6 are examples of inventory information used for determining an under or excess state, and are limited to this. I can't. The product code and category stored in the inventory information database 30 and the shipping information database 31 are product and item identification information. In step S1 of FIG. 5, not only the latest inventory status (for example, the previous day) but also the inventory quantity and the shipment quantity in the first period are acquired.

In FIG. 5, next, the calculation unit 13 calculates the number of days in stock from the number of stocks and the number of shipments for each item in the acquired first period (step S2). The number of days in stock is calculated from the number of stocks in each day / the average number of shipments. The average number of shipments is the average value of the number of shipments in the first period. The number of days in stock indicates how many days the goods are stored in stock. In other words, the number of days in stock indicates how many days the product will run out.

With reference to FIG. 6, the average number of shipments for 7 days is 12.5 (rounded down to the second decimal place), and the number of days in stock is "4" for each day from July 1, 2017 to July 7, 2017. , "2.4", "8", "7", "4.8", "4", "2.4".

In FIG. 5, next, the determination unit 14 determines whether the number of days in stock is equal to or less than the underthreshold value (step S3). If the determination unit 14 determines that the number of days in stock is larger than the underthreshold value, the determination unit 14 proceeds to step S6. When the determination unit 14 determines that the number of days in stock is equal to or less than the underthreshold value, it determines that the inventory is understocked (step S4), and determines the understock ratio (step S5).

In the example of FIG. 6, when the underthreshold value is “5”, the determination unit 14 compares the number of days in stock on each day from July 1, 2017 to July 7, 2017 with the underthreshold value “5”, and 2017. It is determined that the 5th days of / 7/1, 7/2, and 7 / 5-7 / 7 are understock. As a result, the determination unit 14 determines that the underage ratio is about 70% (= 5/7).

In FIG. 5, next, the determination unit 14 determines whether the number of days in stock is equal to or greater than the excess threshold value (step S6). If the determination unit 14 determines that the number of days in stock is smaller than the excess threshold value, the determination unit 14 proceeds to step S9. When the determination unit 14 determines that the number of days in stock is equal to or greater than the excess threshold value, it determines that the inventory is excessive (step S7) and determines the excess ratio (step S8).

In the example of FIG. 6, when the excess threshold value is “8”, the determination unit 14 compares the number of days in stock on each day of 2017/7/1 to 2017/7/7 with the excess threshold value “8” and 2017. It is determined that one day of / 7/3 is excess inventory. As a result, the determination unit 14 determines that the excess ratio is about 14% (= 1/7).

In FIG. 5, next, the display control unit 15 displays the ratio of the understate and the ratio of the excess state for each item on the display 211 of the terminal device 20 (step S9), and ends this process. FIG. 7 is a diagram showing a display example of an underdetermination result according to one embodiment. As shown in FIG. 7, the inventory under-state is displayed for each of the 7 days from July 7, 2017 to July 7, 2017, and the ratio of the under-state is displayed. In the example shown in FIG. 7, the excess judgment result is not displayed, but for example, the excess judgment result also displays the excess inventory state on each day of 7 days from 2017/7/1 to 2017/7/7. At the same time, the ratio of the excess state may be displayed.

According to the inventory management method described above, not only the latest (for example, the previous day) inventory, but also the period of the date corresponding to the preset number of inventory and the number of shipments used for determining the under or excess state (first period). ), The user can determine whether the inventory is chronic or temporary by determining and displaying the insufficient or excessive state of the inventory from the number of inventories and the number of shipments in the time series. For example, the user may determine that the state of insufficient inventory is chronic from the display of the underrate ratio of 70% shown in FIG. 7. The percentage of chronic or non-chronic is determined by the user.

In addition, the determination results of the under and excess states in the time series are visualized in an easy-to-understand manner and displayed on the user's terminal device 20. As a result, the user can easily grasp the insufficient or excessive state of inventory, and can efficiently formulate a demand plan and a supply and demand plan. For example, if the understock ratio is 30% or less, the user determines that the understock condition is temporary and does not respond immediately. For example, if the understock ratio is 70% or more, the understock condition is chronic. It can be determined that it can be dealt with immediately.

If the under-threshold value and the excess-threshold value indicating the quantity of the lower limit of inventory and the upper limit of inventory are not suitable values for judging the under- or excess of inventory with respect to the number of inventories whose situation changes daily, the judgment result of under- or over-inventory Will not be obtained accurately. Therefore, in the inventory management method according to the present embodiment, the setting of the "under-threshold value" and the "excess threshold value" used for determining the under- or excess state is automated based on the judgment reference value specified by the user and the past results. .. The setting of the "first period" is also automated based on the candidate period (candidate period) of the first period and the number of days in which shipment occurs. As a result, inventory management can be performed using an underthreshold value, an excess threshold value, and a period that match the inventory status of each user. Hereinafter, the automation of the setting of the “under-threshold value” and the “excess threshold value” will be described with reference to FIGS. 8 and 9, and then the setting of the “first period” will be described with reference to FIGS. 10 and 11.
[Automation of threshold setting]
An example of setting the threshold value for the under-excess determination used in the inventory management method according to the present embodiment will be described with reference to FIGS. 8 and 9. FIG. 8 is a flowchart showing a threshold value calculation method for the under-excess determination according to the embodiment. FIG. 9 is a diagram for explaining a threshold value calculation method for the under-excess determination according to the embodiment. This process may be executed periodically once a day, every predetermined time, etc., or may be executed irregularly, such as when there is a request for setting an underthreshold value and an overthreshold value from the terminal device 20. May be good.

When this process is started, the calculation unit 13 acquires the under-reference value and the excess reference value (step S11). The under-reference value and the over-reference value are set to values specified in advance by the user. For example, as shown in FIG. 9, a case where the under-reference value is set to 30% minus and the excess reference value is set to 30% plus by the user's specification will be described as an example. However, the under-reference value and the over-reference value are not limited to being set by the user, and may be set by the server 10.

In FIG. 8, next, the calculation unit 13 calculates the median number of days in stock in the second period and the median number of shipments in the second period (step S12). The "second period" is a predetermined period, and is set to one year in the example of FIG. That is, in the example of FIG. 9, the calculation unit 13 calculates the number of inventories for the past one year stored in the inventory information database 30 in time series. In addition, the number of shipments for the past one year stored in the shipment information database 31 in chronological order is calculated. Then, from the inventory quantity and the shipment quantity for the past one year, an inventory days database that stores the inventory days for the past one year (= inventory quantity for each day / average shipment quantity) is created. Based on the created inventory days database, the calculation unit 13 calculates the median inventory days for the past year as the normal inventory days. In the example of FIG. 9, the case where the normal stock days are calculated as "5.5" is shown.

Further, in the example of FIG. 9, the calculation unit 13 calculates the median number of shipments for the past one year as the normal number of shipments from the number of shipments for the past one year stored in the shipping information database 31 in chronological order. To do. In the example of FIG. 9, the case where the normal shipment number is calculated as “12.5” is shown.

In FIG. 8, next, the calculation unit 13 calculates the under-threshold value based on the under-reference value, the median inventory days in the second period, and the median number of shipments in the second period (step S13). ). Next, the calculation unit 13 calculates the excess threshold value based on the excess reference value, the median inventory days in the second period, and the median number of shipments in the second period (step S14), and this process is performed. To finish.

The under-threshold value is a threshold value used for determining that the inventory of goods for each item is under-stocked, and is calculated by multiplying the number of normal inventories by (100-A)%. The excess threshold is a threshold used for determining the excess inventory, and is usually calculated by the number of stocks × (100 + A)%. The A value is an under or excess ratio and varies depending on the product handled by the user. Therefore, in the example shown in FIG. 9, the A value, that is, the under-reference value is set to "30% minus" and the excess reference value is set to "30% plus" based on the user's designation.

The calculation unit 13 calculates the number of normal stocks as 66 (= 5.5 × 12.0) from the formula of the number of normal stocks = the number of days of normal stocks × the number of normal shipments. Then, the calculation unit 13 calculates the underthreshold value as 46 (= 66 × 0.7) from the formula of the underthreshold value = the number of normal stocks × (100-A)%. Further, the calculation unit 13 calculates the excess threshold value as 86 (= 66 × 1.3) from the formula of excess threshold value = normal stock quantity × (100 + A)%.

The automation of setting the underthreshold value and the excess threshold value, which are the threshold values for determining the understatement and the excess state of inventory, has been described above. It is assumed that the inventory management method of FIG. 5 is executed after the underthreshold value is updated periodically or irregularly by this processing and the underthreshold value is changed from 5 to 3. Then, it is determined that the inventory on the two days of 2017/7/2 and 2017/7/7 is insufficient with respect to the number of inventory days on each day shown in FIG. Similarly, when the inventory management method of FIG. 5 is executed after the excess threshold is changed from 8 to 6 by this processing, 2017/7/3 and 2017 with respect to the inventory days of each day shown in FIG. It is determined that the inventory for 2 days of / 7/4 is in excess. According to this, by updating the setting of the under-threshold value and the over-threshold value, the results of the under-inventory and the over-inventory can be different.

The median number of days in stock in the second period is a value in the middle of the number of days in stock in the second period by searching for the number of days in stock in one year in ascending order. In the average value of the number of days in stock in the second period, if the number of days in stock in the second period contains an extremely large value, the influence of that value becomes large, so it is possible to take the median value rather than the average value. preferable. However, the median number of days in stock in the second period and the average number of days in stock in the second period are both examples of statistical values for the number of days in stock in the second period.

Similarly, in the average value of the number of shipments in the second period, if the number of shipments in the second period contains an extremely large value, the influence of that value becomes large, so the median value is taken from the average value. Is preferable. However, the median number of shipments in the second period and the average number of shipments in the second period are both examples of statistical values of the number of shipments in the second period.

The under-threshold value calculated by such calculation is an example of the first threshold value calculated based on the under-reference value, the statistical value of the number of days in stock in the second period, and the statistical value of the number of shipments in the second period. Further, the excess threshold value calculated by such calculation is an example of the second threshold value calculated based on the excess reference value, the statistical value of the number of stock days in the second period, and the statistical value of the number of shipments in the second period. is there.

[Automation of period setting]
Next, an example of setting the number of stocks used for the under-excess determination and the period for acquiring the number of shipments (the period for the under-excess determination) will be described with reference to FIGS. 10 and 11. FIG. 10 is a flowchart showing a method of calculating the period of the under-excess determination according to the embodiment. FIG. 11 is a diagram for explaining a method for calculating the period of the under-excess determination according to the embodiment. This process may be executed periodically such as once / day or every predetermined time, or may be executed irregularly when there is a request from the terminal device 20 to set a period for underestimation or excess determination. May be good.

When this process is started, the calculation unit 13 calculates the ratio of the number of days in which the number of shipments within the preset candidate period is 1 or more for each candidate period (step S15). The maximum candidate period is 30 days, and a plurality of candidate periods are prepared in advance. It is assumed that the frequency of inventory review (inventory) varies from user to user, but it is considered too long to assume that inventory is reviewed on a one-year or six-month basis. Considering that products are shipped and received on a daily basis, it is considered preferable that the period is about 30 days at the longest from the latest (previous day).

Therefore, in the present embodiment, for example, as shown in FIG. 11, the minimum of the period is set to 7 days, the maximum is set to 30 days, and the candidate period is set to 4 days, 14 days, 21 days, and 30 days. .. However, the length of the candidate period, the minimum value of the candidate period, and the maximum value of the candidate period are not limited to this, and may be other days. Further, the candidate period is not limited to four if a plurality of candidate periods are set in advance.

In FIG. 10, next, the determination unit 14 determines whether there is a candidate period in which the ratio of the number of days shipped within the candidate period is 1 or more is less than half of the period (step S16). In this way, the candidate period is selected from 7 days, 14 days, 21 days, and 30 days, and the determination is made based on the actual number of shipments. The meaning of setting the threshold of the actual number of shipments to "half" is that shipments due to campaigns etc. are temporary, so select a period that includes days when there is no actual shipment, and the inventory is not under- or excessive. This is so that it can be determined. The period referred to here is the period of the above candidates (7 days, 14 days, 21 days, 30 days), and by setting the date with the actual shipment record (number of actual shipments) as the threshold value to half of the total. The period includes days when there is no shipping record.

Next, in step S16 of FIG. 10, when the determination unit 14 determines that there is no candidate period in which the ratio of the number of days shipped within the candidate period is 1 or more is less than half of the period, this process ends. On the other hand, when the determination unit 14 determines that there is a candidate period in which the ratio of the number of days shipped within the candidate period is 1 or more is less than half of the period, the determination unit 14 determines the shortest candidate period as the "first period". (Step S17).

The shortest candidate period is 7 days if less than half of the days have a shipping record in 7 days, more than half of the days have a shipping record in 7 days, and less than half of the days have a shipping record in 14 days. In the case, it is 14 days. The shortest candidate period is 21 days if the number of days with a shipping record of 7 days and 14 days is more than half, and less than half of the days with a shipping record of 21 days, and 30 days other than the above.

For example, based on the shipping information database 31, the calculation unit 13 calculates the number of shipping records as the number of shipping records on a weekly basis from immediately before. As a result, in the example of FIG. 11, it is assumed that the actual number of shipments is more than half in 7 days and the actual number of shipments is less than half in 14 days, 21 days, and 30 days. In this case, the determination unit 14 sets 14 days, which is the shortest period in which the actual number of shipments is half or less, as the first period.

As described above, the inventory management system according to the present embodiment automates the setting of the underthreshold value and the excess threshold value. In addition, the setting of the first period used for the under-excess determination is automated. Thereby, the under-threshold value and the excess-threshold value and the first period used for the under-excess determination can be updated according to the latest inventory status. As a result, inventory management can be performed using the under-threshold value and the excess-threshold value that match the inventory status for each user and the first period used for the under-excess determination. In addition, the load of inventory management processing can be reduced by automating the setting of the underthreshold value and the excess threshold value and the setting of the first period used for the underestimation / excess determination.

It is also possible to display the calculated ratio of the understock and the excess inventory in the first period in association with the event information held in the first period. According to this, it is possible to visualize the information of the determination result of the under or over state of the time series and the event information and display the relation in an easy-to-understand manner. As a result, the user can take measures against the shortage and excess of inventory in consideration of the event.

FIG. 12 is a diagram showing the ratio of the inventory shortage state according to the embodiment and the event information on the display 211 of the terminal device 20 in association with each other. In the example of FIG. 12, each item of the product code, the category, the event name, the start date, and the end date is stored in the event information database 32. Thereby, based on the product code and the category, the event information such as the event name, the start date, and the end date can be displayed in association with the judgment result of the insufficient or excessive inventory. This makes it possible to visualize the relationship between the state or ratio of understock or excess inventory and the event. Note that FIG. 12 shows a screen example in which the result of the understock is visualized, but the present invention is not limited to this, and the result of the excess inventory, the understock ratio, and the excess ratio may be visualized.

In the above explanation, an example of a display method for visualizing the result of the under or excess state for one item is shown, but when there are many items of goods, the items with the under or excess ratio are preferentially displayed in the list. Then, it may be presented to the user. The user can promptly take measures such as increasing the production amount and increasing the number of inventories, preferentially from the items having the under-percentage or the high-over-percentage. In addition, when the display control unit 15 narrows down the category to be searched by the user and searches for the insufficient or excessive inventory, the display control unit 15 may display a list of items narrowed down to that category. The determination result of the under or excess state can be displayed on the server 10 side as well. The inventory management method according to the present embodiment can be suitably used by all users who have inventories, such as manufacturing, retail, and distribution.

As described above, according to the inventory management system according to the embodiment, the first under-threshold value and the excess threshold value that match the inventory status of each user and the first under-excess determination that matches the inventory status of each user. Inventory management can be performed using the period of.

Although the inventory management program, the inventory management method, and the inventory management system have been described above by the above-described embodiment, the inventory management program, the inventory management method, and the inventory management system according to the present disclosure are not limited to the above-described embodiment. Various modifications and improvements are possible within the scope of disclosure. Further, when a plurality of the above-described embodiments and modifications exist, they can be combined within a consistent range.

With respect to the above description, the following sections will be further disclosed.
(Appendix 1)
The process of calculating the number of days in stock in the first period including a plurality of consecutive unit periods from the number of stocks and the number of shipments for each unit period for the item to be processed, and
A predetermined under-reference value for determining whether or not inventory is insufficient and / or a predetermined excess reference value for determining whether or not inventory is excessive, and the number of days in stock in a second period different from the first period. Based on the statistical value and the statistical value of the number of shipments in the second period, the first threshold value for determining whether or not the inventory for the item is insufficient and / or whether or not the inventory for the item is excessive. And the process of calculating the second threshold value to determine
A process of determining whether or not the inventory of the item is insufficient and / or excessive based on the number of days in stock and the first threshold value and / or the second threshold value.
An inventory management program that lets your computer run.
(Appendix 2)
It has a process of determining the first period from a plurality of predetermined candidate periods based on the ratio of days in which the number of shipments within each candidate period is one or more.
The inventory management program described in Appendix 1.
(Appendix 3)
It has a process of indicating whether the inventory of the item is under and / or over.
The inventory management program described in Appendix 1 or 2.
(Appendix 4)
It has a process of displaying the ratio of the item in stock being insufficient and / or the ratio of the item in stock being excessive and the event information in association with each other.
The inventory management program described in Appendix 3.
(Appendix 5)
The under-reference value and / or the excess reference value is determined for each user who uses the determination result of whether or not the inventory of the item is under-and / or over-excess.
The inventory management program according to any one of Appendix 1 to 4.
(Appendix 6)
The process of calculating the number of days in stock in the first period including a plurality of consecutive unit periods from the number of stocks and the number of shipments for each unit period for the item to be processed, and
A predetermined under-reference value for determining whether or not inventory is insufficient and / or a predetermined excess reference value for determining whether or not inventory is excessive, and the number of days in stock in a second period different from the first period. Based on the statistical value and the statistical value of the number of shipments in the second period, the first threshold value for determining whether or not the inventory for the item is insufficient and / or whether or not the inventory for the item is excessive. And the process of calculating the second threshold value to determine
A process of determining whether or not the inventory of the item is insufficient and / or excessive based on the number of days in stock and the first threshold value and / or the second threshold value.
The inventory management method that the computer performs.
(Appendix 7)
It has a process of determining the first period from a plurality of predetermined candidate periods based on the ratio of days in which the number of shipments within each candidate period is one or more.
The inventory management method described in Appendix 6.
(Appendix 8)
It has a process of indicating whether the inventory of the item is under and / or over.
The inventory management method according to Appendix 6 or 7.
(Appendix 9)
It has a process of displaying the ratio of the item in stock being insufficient and / or the ratio of the item in stock being excessive and the event information in association with each other.
The inventory management method described in Appendix 8.
(Appendix 10)
The under-reference value and / or the excess reference value is determined for each user who uses the determination result of whether or not the inventory of the item is under-and / or over-excess.
The inventory management method according to any one of Appendix 6 to 9.
(Appendix 11)
From the number of stocks and the number of shipments for each unit period for the item to be processed, the number of days in stock in the first period including a plurality of consecutive unit periods is calculated.
A predetermined under-reference value for determining whether or not inventory is insufficient and / or a predetermined excess reference value for determining whether or not inventory is excessive, and the number of days in stock in a second period different from the first period. Based on the statistical value and the statistical value of the number of shipments in the second period, the first threshold value for determining whether or not the inventory for the item is insufficient and / or whether or not the inventory for the item is excessive. A calculation unit that calculates a second threshold value for determining
A determination unit that determines whether or not the inventory of the item is too low and / or too high based on the number of days in stock and the first threshold value and / or the second threshold value.
Inventory management system with.
(Appendix 12)
The determination unit determines the first period from a plurality of predetermined candidate periods based on the ratio of days when the number of shipments within each candidate period is 1 or more.
The inventory management system according to Appendix 11.
(Appendix 13)
It has a display control unit that displays whether or not the inventory of the item is too low and / or too high.
The inventory management system according to Appendix 11 or 12.
(Appendix 14)
The display control unit displays the event information by associating the ratio of the item with an insufficient inventory and / or the ratio of the item with an excess inventory.
The inventory management system according to Appendix 13.
(Appendix 15)
The under-reference value and / or the excess reference value is determined for each user who uses the determination result of whether or not the inventory of the item is under-and / or over-excess.
The inventory management system according to any one of Appendix 11-14.

1 Inventory management system 10 Server 11 Communication unit 12 Reception unit 13 Calculation unit 14 Judgment unit 15 Display control unit 16 Storage unit 20 Terminal device 21 Operation unit 22 Communication unit 23 Control unit 24 Display unit 25 Storage unit 30 Inventory information database 31 Shipping information Database 32 Event information database

Claims (7)

The process of calculating the number of days in stock in the first period including a plurality of consecutive unit periods from the number of stocks and the number of shipments for each unit period for the item to be processed, and
A predetermined under-reference value for determining whether or not inventory is insufficient and / or a predetermined excess reference value for determining whether or not inventory is excessive, and the number of days in stock in a second period different from the first period. Based on the statistical value and the statistical value of the number of shipments in the second period, the first threshold value for determining whether or not the inventory for the item is insufficient and / or whether or not the inventory for the item is excessive. And the process of calculating the second threshold value to determine
A process of determining whether or not the inventory of the item is insufficient and / or excessive based on the number of days in stock and the first threshold value and / or the second threshold value.
An inventory management program that lets your computer run. It has a process of determining the first period from a plurality of predetermined candidate periods based on the ratio of days in which the number of shipments within each candidate period is one or more.
The inventory management program according to claim 1. It has a process of indicating whether the inventory of the item is under and / or over.
The inventory management program according to claim 1 or 2. It has a process of displaying the ratio of the item in stock being insufficient and / or the ratio of the item in stock being excessive and the event information in association with each other.
The inventory management program according to claim 3. The under-reference value and / or the excess reference value is determined for each user who uses the determination result of whether or not the inventory of the item is under-and / or over-excess.
The inventory management program according to any one of claims 1 to 4. The process of calculating the number of days in stock in the first period including a plurality of consecutive unit periods from the number of stocks and the number of shipments for each unit period for the item to be processed, and
A predetermined under-reference value for determining whether or not inventory is insufficient and / or a predetermined excess reference value for determining whether or not inventory is excessive, and the number of days in stock in a second period different from the first period. Based on the statistical value and the statistical value of the number of shipments in the second period, the first threshold value for determining whether or not the inventory for the item is insufficient and / or whether or not the inventory for the item is excessive. And the process of calculating the second threshold value to determine
A process of determining whether or not the inventory of the item is insufficient and / or excessive based on the number of days in stock and the first threshold value and / or the second threshold value.
The inventory management method that the computer performs. From the number of stocks and the number of shipments for each unit period for the item to be processed, the number of days in stock in the first period including a plurality of consecutive unit periods is calculated.
A predetermined under-reference value for determining whether or not inventory is insufficient and / or a predetermined excess reference value for determining whether or not inventory is excessive, and the number of days in stock in a second period different from the first period. Based on the statistical value and the statistical value of the number of shipments in the second period, the first threshold value for determining whether or not the inventory for the item is insufficient and / or whether or not the inventory for the item is excessive. A calculation unit that calculates a second threshold value for determining
A determination unit that determines whether or not the inventory of the item is too low and / or too high based on the number of days in stock and the first threshold value and / or the second threshold value.
Inventory management system with.

Images