JP6096067B2 - Inventory management apparatus, inventory management method, and inventory management program - Google Patents

Description

  The present invention relates to a technology for managing product inventory.

  Companies that operate businesses such as manufacturing, logistics, and retail manage inventory of a very large number of products (eg, thousands or tens of thousands). In inventory management, in order to avoid problems such as excess inventory or missing items, it is useful to grasp the future increase / decrease trend in inventory quantity for each product. In addition, there is a demand from an inventory management administrator to extract a product whose inventory quantity has increased or decreased from a plurality of types of product groups.

  As shown in the graphs (a) and (b) of FIG. 10, the stock amount of products is generally produced and increased by a predetermined amount on a certain day, but then gradually increases with the shipment of the products. It will decrease, and it will change so that it will be produced again by a predetermined amount and increased on another day. By looking at such a graph, an inventory management administrator can visually determine the increasing / decreasing tendency of the inventory amount of one type of product. For example, the product of the graph (a) has a short inventory cycle (product production cycle), so the inventory management administrator pays attention to the latest short-term increase / decrease trend. According to the graph (a), since the inventory amount has increased recently, the administrator of inventory management determines that it will continue to increase. On the other hand, the product of the graph (b) has a long inventory cycle, so the manager of inventory management pays attention to the long-term increase / decrease trend. According to the graph (b), since the inventory amount is decreasing as a whole, the inventory management administrator determines that it will continue to decrease.

  However, in order for an inventory management administrator to determine the increase / decrease tendency of the stock quantity of a very large number of products, it is necessary to look at a large number of the above graphs. It takes a lot of time and effort. In addition, the inventory management manager's visual judgment of the increase / decrease trend is subjective, but by objectively judging the increase / decrease trend, products that have increased or decreased inventory quantity from multiple types of product groups. There is a desire to extract.

  Japanese Patent Application Laid-Open No. 2004-151858 discloses calculating a fluctuation range of a stock amount within a unit period from past stock amount actual data when determining whether or not the increase / decrease adjustment of the stock amount is necessary.

JP 2004-295227 A

However, since there is no specific description regarding the unit period in Patent Document 1, an administrator of inventory management may determine one unit period uniformly for any product, for example. As a result, the fluctuation range of the inventory quantity within the unit period may not accurately represent the increase / decrease tendency of the inventory quantity. Further, for example, according to the technique of Patent Document 1, the fluctuation range of the inventory amount varies depending on the unit period determined subjectively by the manager of inventory management. As a result, it is not possible to objectively judge the increase / decrease tendency of the product inventory.
In addition, there is a demand from the manager of inventory management to more accurately extract products whose inventory quantity is increasing or decreasing from a plurality of types of product groups.

In view of such circumstances, it is an object of the present invention to accurately and objectively determine an increase / decrease tendency of inventory quantities of a plurality of types of products that are subject to inventory management.
It is another object of the present invention to more accurately extract products whose inventory quantity is increasing or decreasing by accurately and objectively determining the trend of increase / decrease in inventory quantity of multiple types of products.

In order to achieve the above object, the present invention provides:
In an inventory management device that includes a storage unit and a control unit, and manages inventory of multiple types of products,
The storage unit stores, for each product, inventory information indicating a time change in the inventory amount of the product at a predetermined time interval,
The controller is
By referring to the inventory information, by specifying the time when the product was produced, the average production interval that is the average of the production intervals of the product is calculated,
The larger the average production interval, the larger the parameter section for moving average, and set the past time point from the current time more greatly,
With reference to the inventory information, the inventory quantity in the first parameter section, which is the parameter section retroactive from the current time by the average production interval, is read out, and the inventory quantity of the current inventory quantity for the product is read. Calculate the moving average of 1
With reference to the inventory information, the inventory amount at the past time point for the product is read out by reading the inventory amount in the second parameter interval that is the parameter interval that is backed by the average production interval from the past time point. Calculating the second moving average of
If the difference obtained by subtracting the second moving average value from the first moving average value is positive, it is determined that the stock amount of the product tends to increase, and if the difference is negative, It is characterized by determining that inventory is on a downward trend.
Details will be described later.

According to the present invention, it is possible to accurately and objectively determine the increase / decrease tendency of the inventory quantity of a plurality of types of products that are the targets of inventory management.
Further, according to the present invention, it is possible to accurately extract a product whose stock quantity has increased or decreased by accurately and objectively determining the trend of increase / decrease in the stock quantity of a plurality of types of products.

It is a software block diagram of the inventory management apparatus of this embodiment. It is a data structure figure of inventory information. It is the graphs (A) and (B) which show the time change of the inventory quantity of the comparative example which judges the increase / decrease tendency of inventory quantity using a moving average. It is graph (C) and (D) which show the time change of the stock quantity of the comparative example which shortened the parameter area for a moving average. It is graph (E) and (F) which show the time change of the stock quantity of the comparative example which lengthened the parameter section for a moving average. It is graph (G) and (H) which show the time change of the stock quantity of the comparative example which lengthened the evaluation period for a moving average. It is graph (I) and (J) which show the time change of the stock quantity of the comparative example which shortened the evaluation period for a moving average. It is graph (K) and (L) which show the time change of the stock quantity of a present Example which judges the increase / decrease tendency of a stock quantity using a moving average. It is an example of a display of the increase / decrease tendency degree of a present Example. It is graph (a), (b) which shows the time change of inventory quantity for the manager of inventory management to judge the increase / decrease tendency of inventory quantity visually.

  Next, modes for carrying out the present invention (hereinafter referred to as “embodiments”) will be described with reference to the drawings as appropriate.

≪Configuration≫
The inventory management apparatus 1 of this embodiment is a computer including hardware such as an input unit, an output unit, a control unit, and a storage unit. The input unit includes, for example, an input interface and includes means operated by a user such as a pointing device. The output unit includes, for example, an output interface and includes a display unit such as a display. The control unit includes, for example, a CPU (Central Processing Unit) and a dedicated circuit. The storage unit includes, for example, a storage medium such as a random access memory (RAM), a read only memory (ROM), a hard disk drive (HDD), and a flash (registered trademark) memory. When the control unit is composed of a CPU, information processing by a computer including the control unit is realized by a program execution process by the CPU. Further, the storage unit included in the computer stores a program (including a program for inventory management) that is instructed by the CPU and implements the function of the computer. This realizes cooperation between software and hardware.

  The present embodiment can be realized by a program for executing the information processing, and the program can be provided by being stored in a computer-readable recording medium (eg, CD-ROM). The program can also be provided through a network such as the Internet.

  Referring to FIG. 1, the inventory management apparatus 1 according to the present embodiment includes software components such as an increase / decrease trend calculation unit 11, an inventory graph display unit 12, an increase / decrease trend display unit 13, and inventory information I. Yes.

  The increase / decrease tendency calculation unit 11 refers to the inventory information I for the product specified by the input unit, and calculates the increase / decrease tendency degree of the inventory amount of the product. The increasing / decreasing tendency of the inventory quantity is a value that quantitatively indicates whether the inventory quantity of the product is increasing or decreasing from the present time. Details will be described later.

  The inventory graph display unit 12 refers to the inventory information I for the product specified by the input unit, and displays the PSI (Production, Sales, Inventory) graph on the display unit of the inventory management apparatus 1. Is displayed.

  The increase / decrease trend display unit 13 visualizes the increase / decrease trend calculated by the increase / decrease trend calculation unit 11 on the PSI graph displayed on the display unit of the inventory management apparatus 1 by the inventory graph display unit 12 using, for example, arrows. To display.

  The inventory information I is a database in which the operation results of product inventory management are registered. Specifically, the inventory information I indicates a time change such as a product inventory amount at a predetermined time interval (for example, in units of days). Referring to FIG. 2, the inventory information I has a data structure having items such as “date”, “production volume”, “sales volume”, and “stock volume”, and is generated for each product.

  In “Date”, the date on which product inventory management is executed is registered. In the inventory information I in FIG. 2, entries are created on a daily basis, but can also be registered at time intervals such as one hour, one month, and one year.

The daily production amount of the product is registered for the item “production amount”.
The daily sales volume of the product is registered for the item “sales volume”.
The daily stock amount of the product is registered for the item “stock amount”.
In the present embodiment, the values of the production volume, sales volume, and inventory volume are represented by quantities, but they may be represented by an amount obtained by multiplying the quantity by the unit price of the product.

  The user can calculate the increase / decrease tendency degree of the inventory amount of the product by designating the product to be inventory managed from the input unit of the inventory management device 1. The increase / decrease tendency calculation unit 11 calculates a moving average value and an average inventory amount in order to calculate the increase / decrease tendency.

・・・式１ The moving average value ma (n, t) of the stock quantity in the parameter section n at the time point t (expressed in units of days in the present embodiment) is calculated by the following formula 1.

... Formula 1

  Here, I (τ) is the stock quantity at the time τ. For the parameter section n, for example, when obtaining the 5-day moving average value for the past 5 days from Monday to Friday, n = 5, and the 25-day moving average value for the past one month excluding Saturday and Sunday is obtained. Sometimes n = 25.

・・・式２ Further, the average stock quantity μ (u, t) between the time points u to t (u <t) is calculated by the following equation 2. Here, I (τ) is the stock quantity at the time τ.

... Formula 2

・・・式３ The increase / decrease tendency calculation part 11 calculates the increase / decrease tendency degree r of a product by the following formula 3.

... Formula 3

  Here, d is an average production interval, which is an average of product production intervals. Assuming that a performance period, which is a period during which product inventory is managed, is l, and p is a production count, which is the number of times a product is produced within the performance period l, d = 1 / p. The actual period l can be obtained as a period from the date when the product inventory information I is created to the current date. The number of productions p can be obtained as the number of numerical values other than 0 registered in the item “Production amount” of the product inventory information I. If d is not a natural number, for example, the decimal part may be rounded off.

  In Equation 3, the time point t is the current time, which is the current date in the present embodiment. The first term ma (d, t) of the numerator on the right side of Equation 3 is the moving average of the inventory quantity in the parameter section (first parameter section) that goes back from the current date t by the average production interval d on the current date t. Value (first moving average value). In addition, the second term ma (d, t−d) of the numerator on the right side of Equation 3 is the inventory in the parameter section (second parameter section) that goes back by the average production interval d from the date t−d as the past time point. It is the moving average value (second moving average value) of the quantity on the day t-d as the past time point.

  The control unit of the inventory management device 1 determines that the stock amount of the product tends to increase if the difference ma (d, t) −ma (d, t−d) on the right side of Equation 3 is positive. If the difference is negative, it is determined that the inventory amount of the product tends to decrease. However, details of the determination by the control unit of the inventory management apparatus 1 will be described later.

  The denominator μ (t−d, t) in Equation 3 is an average inventory amount from the date td as the past time point to the current date t. By dividing the difference between the two moving average values on the right side of Equation 3 by the average inventory quantity, the difference in magnitude due to the difference in inventory quantity between various products managed in inventory is reduced. be able to. That is, the value of the increase / decrease tendency r in Expression 3 is normalized.

<< Example >>
Next, an example when the inventory management apparatus 1 of the present embodiment is used will be described. In the description, reference is made to a comparative example in which a determination different from the above-described determination of the increase / decrease tendency of the inventory amount is made.

  Conventional determination of the increase / decrease trend of product inventory using a moving average is to calculate the difference between the current moving average value and the moving average value in the past of the inventory amount within a given parameter section, The determination was based on the positive / negative of the difference.

  For example, referring to FIG. 3, for a product with a short inventory cycle shown in the graph (A), the user pays attention to a short-term increase / decrease trend, so the moving average value at the present time and the moving average at a past time point close to the current time Find the difference from the value. And since the said difference is positive, it is judged that the stock quantity of a product is increasing. Also, for products with a long inventory cycle shown in the graph (B), the user pays attention to the long-term increase / decrease trend, so the difference between the moving average value at the present time and the moving average value at the past time point far from the current time is obtained. . And since the said difference is negative, it judges that the stock quantity of a product is in the decreasing tendency.

  However, in such a determination, (1) how to take a parameter section for moving average, (2) how to take an evaluation period for moving average, that is, for the current time as one end of the evaluation period, Depending on the point in time at which the past point in time is set, the increasing / decreasing tendency of the stock amount of the product changes, and an accurate and objective judgment cannot be made.

  For example, referring to FIG. 4, when the parameter interval is set to be short, for a product with a short inventory cycle shown in the graph (C), the moving average curve is not affected by the inventory cycle, It accurately represents an increasing trend. On the other hand, for products with a long inventory cycle shown in the graph (D), the moving average curve changes suddenly due to the influence of the inventory cycle, and the overall inventory trend is decreasing. Is not accurately represented. Therefore, when the parameter section is set to be short, it is impossible to grasp the increase / decrease tendency of the inventory amount of the product having a long inventory cycle.

  Further, referring to FIG. 5, when the parameter interval is set to be long, the moving average curve is too gradual for the product having a short inventory cycle shown in the graph (E). It cannot be expressed accurately. On the other hand, for a product with a long inventory cycle shown in the graph (F), the moving average curve accurately represents the overall decreasing trend of the inventory quantity without being affected by the inventory cycle. Therefore, when the parameter interval is set to be long, it is not possible to grasp the increase / decrease tendency of the inventory amount of the product having a short inventory cycle.

  In general, with regard to the determination of the increase / decrease trend of product inventory using the conventional moving average, a single parameter interval was defined uniformly for any product regardless of the product inventory cycle. As shown in FIGS. 4 and 5, there are products that cannot grasp the increase / decrease tendency of the inventory amount.

  In addition, referring to FIG. 6, when the evaluation period is set to be long, the past time point is too far from the present time so as to judge the increase / decrease tendency in the long term for products with a short inventory cycle shown in the graph (G). The difference between the two moving average values becomes negative, and it is determined that the stock amount of the product is decreasing. For this reason, the moving average curve cannot accurately represent the latest increase in inventory quantity. On the other hand, for a product with a long inventory cycle shown in the graph (H), the moving average curve accurately represents the overall decreasing trend of the inventory quantity by judging the increasing / decreasing tendency over a long period of time. Therefore, when the evaluation period is set to be long, it is not possible to grasp the increase / decrease tendency of the inventory amount of the product having a short inventory cycle.

  Further, referring to FIG. 7, when the evaluation period is set to be short, for a product with a short inventory cycle shown in the graph (I), the moving average curve is obtained by determining the increase / decrease tendency in a short period. It accurately represents the latest increasing trend. On the other hand, for products with a long inventory cycle shown in graph (J), the past time point is too close to the present time so as to judge the increase / decrease trend in a short period, and the difference between the two moving average values becomes positive. It will be judged that the stock quantity of is increasing. For this reason, the moving average curve cannot accurately represent the overall decreasing tendency of the inventory amount. Therefore, when the evaluation period is set short, it is not possible to grasp the increase / decrease tendency of the inventory amount of products having a long inventory cycle.

  In general, with regard to the determination of the trend of increase / decrease in product inventory using the conventional moving average, a single evaluation period was defined for each product independently of the product inventory cycle. As shown in FIGS. 6 and 7, there are products that cannot grasp the increase / decrease tendency of the inventory amount.

  Therefore, in the present embodiment, the parameter interval and the evaluation period for the moving average are determined according to the inventory cycle interval. Specifically, an inventory cycle interval is treated as a product production interval, and an average product production interval is calculated. The parameter interval is set larger as the average production interval is larger. Furthermore, the larger the average production interval is, the larger the evaluation period is set, that is, the past time point from the present time is set further backward.

  Referring to FIG. 8, for a product with a short inventory cycle shown in the graph (K), the parameter section is set short and the evaluation period from the present time to the past time is set short. Therefore, the moving average curve can accurately represent the latest increase tendency of the inventory quantity without being caught by the long-term increase / decrease tendency of the inventory quantity. At this time, the difference between the two moving average values of the numerator of the increase / decrease tendency degree r in Expression 3 is positive, and the increase tendency can be expressed. Further, for a product with a long stock cycle shown in the graph (L), the parameter section is set to be long and the evaluation period from the present time to the past time is set to be long. Therefore, the moving average curve can accurately represent the long-term decreasing trend of the inventory quantity without being caught by the short-term increase / decrease tendency of the inventory quantity. At this time, the difference between the two moving average values of the numerator of the increasing / decreasing tendency degree r in Expression 3 is negative, and the decreasing tendency can be expressed.

  The increase / decrease tendency degree r in Equation 3 provides an objective judgment result of the increase / decrease tendency of the inventory quantity for any product having various inventory cycles by using the average production interval d representing the inventory cycle. can do. For example, a product in which the difference between two moving average values of the numerator of the increase / decrease tendency degree r is positive from the inventory information I can be accurately extracted, and only the products whose inventory amount tends to increase can be accurately extracted. It is possible to accurately extract only the products whose inventory amount is decreasing by identifying products in which the difference between the two moving average values of the numerator is negative. A user operates the input unit of the inventory management device 1 to acquire the extraction result, thereby easily grasping a product whose inventory amount is increasing or a product that is decreasing.

  Further, the increase / decrease tendency of the inventory amount can be quantitatively determined based on the difference between the two moving average values used for the increase / decrease tendency degree r. For example, it is possible to accurately extract only products in which the difference between the two moving average values of the numerator of the increase / decrease tendency r is equal to or greater than a predetermined positive value, and the inventory quantity is increasing significantly. It is possible to accurately extract only products in which the difference between the two moving average values is equal to or less than a predetermined negative value and the inventory amount is in a large decreasing tendency. The user operates the input unit of the inventory management device 1 to acquire the extraction result, thereby easily grasping a product whose inventory quantity is in a large increasing tendency or a product in which the inventory quantity is decreasing significantly.

  Based on the calculation result of the increase / decrease tendency calculation unit 11, the user displays a list of products whose inventory amount tends to increase on the display unit or the inventory amount tends to decrease by an operation from the input unit of the inventory management device 1. Can be listed on the display. However, the user can visualize and display the increase / decrease tendency r of one product on the display unit of the inventory management device 1 by an operation from the input unit of the inventory management device 1. The apparatus 1 can assist the judgment of the increase / decrease tendency of the inventory quantity.

  Referring to FIG. 9, for the PSI graph of one product displayed on the display unit of the inventory management apparatus 1 by the inventory graph display unit 12, the user operates the input unit to display the display screen of the display unit of the inventory management apparatus 1. Put a check mark in the check box for the comment “Display increase / decrease in inventory”. Then, the increase / decrease tendency display part 13 can display the increase / decrease tendency degree r calculated by the increase / decrease tendency calculation part 11 with an arrow. If the difference between the moving average value at the present time and the moving average value at the past time is positive, the arrow extends from the past time point of the moving average to the upper right toward the current time, and indicates an increasing trend of the inventory amount. If it is negative, it extends to the lower right and indicates a downward trend in inventory. The slope of the arrow represents the degree of increase in inventory quantity or the degree of decrease in reduction tendency.

≪Summary≫
According to the present embodiment, it is possible to accurately and objectively judge the increase / decrease tendency of the inventory amount of a plurality of types of products that are the targets of inventory management. Since the interval parameters and evaluation period for the moving average are determined using the average production interval of products, it is possible to uniformly evaluate the increase / decrease trend in inventory for multiple types of products with different production cycles. is there.
In addition, by accurately and objectively determining the increase / decrease tendency of the stock quantity of a plurality of types of products, it is possible to accurately extract products whose stock quantity has increased or decreased.
In addition, the positive or negative difference in the difference between the moving average value of the current inventory amount and the moving average value of the inventory amount at the past time can be used to qualitatively determine the product inventory amount increase / decrease. The difference value can be normalized by dividing the difference by the amount to obtain the increase / decrease tendency degree r. For example, when displaying a list of PSI graphs for each product in the thumbnail format on the display unit of the inventory management apparatus 1, when the increase / decrease tendency is also displayed with arrows on each of the PSI graphs, the size of the arrow is increased by the normalization. Therefore, the display space of the display unit can be used effectively.

≪Others≫
Parameters for the moving average value of the current inventory amount (the first term of the numerator on the right side of Equation 3) and the parameters for the moving average value of the inventory amount at the past time point (the second term of the numerator on the right side of Equation 3) At least one of the sections can be made larger or smaller than the average production interval d of the products. For example, d can be αd (0 <α <1, or α> 1).

  The past time point, which is the time when the moving average value of the second inventory amount is calculated, may go back further from the time point going back by the average production interval from the current time point, or may be lowered. Specifically, the time point td of the second term of the right-side molecule of Formula 3 can be set to t-βd (0 <β <1 or β> 1). If necessary, the past time point td of the denominator of the right side of Equation 3 may be set as the t-βd.

  The display unit of the inventory management apparatus 1 can also display a moving average curve together with a graph that displays a change in inventory quantity over time. For example, with respect to the PSI graph shown in FIG. 9, a moving average curve determined from the moving average value ma (n, t) of Equation 1 may be displayed together. At this time, the average production interval d may be substituted for the parameter interval n.

  By displaying such a moving average curve, the user can easily grasp the increase / decrease tendency of the overall inventory amount from the past to the present for the display target product. Further, if the average production interval d which is not automatically set by the user in the parameter section n but is automatically calculated from the inventory information I is adopted, a moving average curve based on an objective evaluation is generated. For this reason, a user, particularly a novice user, can more quickly and accurately determine the tendency to increase or decrease the inventory amount.

  In addition, the display of the moving average curve allows the user to easily grasp the seasonality of the stock representing the transition characteristics of the stock quantity of the product depending on the season. The seasonality of inventory is mainly characterized by high demand periods of the product (eg, demand for products in the fourth quarter of each year is greater than other periods, etc.). Retailers or wholesalers need to secure inventory in preparation for increased sales during high demand periods. Also, it is customary to gradually increase inventory before production reaches its peak in order to level production resources at the factory.

  These circumstances are reflected in, for example, the PSI graph and the moving average curve shown in FIG. Therefore, the user can grasp the seasonality of the stock of the display target product by looking at the PSI graph and the moving average curve. In addition, the user can prevent inventory shortage or excess in a high demand period by grasping the seasonality of inventory. For example, referring to the moving average curve, it was confirmed that the amount of inventory in the high demand period of the previous year was excessive and that the amount of inventory in the high demand period of the previous year was suppressed to some extent. It is possible to reliably predict the amount of inventory required in the demand period.

In the present embodiment, components realized by hardware can be realized by software, and components realized by software can be realized by hardware.
Moreover, a new technique can be realized by appropriately combining the technical matters described in the present embodiment.
Other specific configurations of hardware, software, database, and the like can be changed as appropriate without departing from the spirit of the present invention.

DESCRIPTION OF SYMBOLS 1 Inventory management apparatus 11 Increase / decrease tendency calculation part 12 Inventory graph display part 13 Increase / decrease tendency display part I Inventory information

Claims (6)

In an inventory management device that includes a storage unit and a control unit, and manages inventory of multiple types of products,
The storage unit stores, for each product, inventory information indicating a time change in the inventory amount of the product at a predetermined time interval,
The controller is
By referring to the inventory information, by specifying the time when the product was produced, the average production interval that is the average of the production intervals of the product is calculated,
As the average production interval is larger, the moving average parameter section is set to be larger, and when setting the past time point from the current time more greatly, the past time point is traced back from the current time by the average production interval. As of time
With reference to the inventory information, the inventory quantity in the first parameter section, which is the parameter section retroactive from the current time by the average production interval, is read out, and the inventory quantity of the current inventory quantity for the product is read. Calculate the moving average of 1
With reference to the inventory information, the inventory amount at the past time point for the product is read out by reading the inventory amount in the second parameter interval that is the parameter interval that is backed by the average production interval from the past time point. Calculating the second moving average of
If the difference obtained by subtracting the second moving average value from the first moving average value is positive, it is determined that the stock amount of the product tends to increase, and if the difference is negative, An inventory management device characterized by determining that the inventory amount is in a decreasing trend. The controller is
The inventory management apparatus according to claim 1, wherein a product in which the difference is positive or a product in which the difference is negative is extracted from the inventory information. The controller is
The inventory management apparatus according to claim 1, wherein a product in which the difference is a predetermined positive value or a product in which the difference is a predetermined negative value or less is extracted from the inventory information. The controller is
Referring to the inventory information, for the product, calculate the average inventory amount from the past time to the current time,
The inventory management apparatus according to any one of claims 1 to 3, wherein an increase / decrease tendency degree is calculated by dividing the difference by the average inventory amount. In an inventory management method in an inventory management apparatus that includes a storage unit and a control unit and performs inventory management of a plurality of types of products,
The storage unit stores, for each product, inventory information indicating a time change in the inventory amount of the product at a predetermined time interval,
In the control unit,
Calculating an average production interval, which is an average of product production intervals, by referring to the inventory information and identifying a point in time when the product is produced;
As the average production interval is larger, the moving average parameter section is set to be larger, and when setting the past time point from the current time more greatly, the past time point is traced back from the current time by the average production interval. A time step,
With reference to the inventory information, the inventory quantity in the first parameter section, which is the parameter section retroactive from the current time by the average production interval, is read out, and the inventory quantity of the current inventory quantity for the product is read. Calculating a moving average value of 1;
With reference to the inventory information, the inventory amount at the past time point for the product is read out by reading the inventory amount in the second parameter interval that is the parameter interval that is backed by the average production interval from the past time point. Calculating a second moving average value of:
If the difference obtained by subtracting the second moving average value from the first moving average value is positive, it is determined that the stock amount of the product tends to increase, and if the difference is negative, And a step of determining that the inventory amount is in a decreasing trend. In an inventory management program for causing a computer including a storage unit and a control unit to function as an inventory management apparatus that performs inventory management of a plurality of types of products,
The storage unit stores, for each product, inventory information indicating a time change in the inventory amount of the product at a predetermined time interval,
In the control unit,
A process of calculating an average production interval that is an average of the production intervals of products by specifying the time when the production of the product was performed with reference to the inventory information;
As the average production interval is larger, the moving average parameter section is set to be larger, and when setting the past time point from the current time more greatly, the past time point is traced back from the current time by the average production interval. and the process of the time,
With reference to the inventory information, the inventory quantity in the first parameter section, which is the parameter section retroactive from the current time by the average production interval, is read out, and the inventory quantity of the current inventory quantity for the product is read. A process of calculating a moving average value of 1,
With reference to the inventory information, the inventory amount at the past time point for the product is read out by reading the inventory amount in the second parameter interval that is the parameter interval that is backed by the average production interval from the past time point. A process of calculating a second moving average value of
If the difference obtained by subtracting the second moving average value from the first moving average value is positive, it is determined that the stock amount of the product tends to increase, and if the difference is negative, And a process for determining that the inventory quantity is decreasing.

Images