JP2011180676A - Stock management device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To effectively support measures for safety stock of products. <P>SOLUTION: A stock management device has a display part which displays a stock status of the safety stock of products, and supports decision making of the safety stock of the products. The stock management device specifies a calculation method for computing an ideal safety stock level and an actual safety stock level from combo boxes 1404-1405 and a text box 1406, based on a history of the actual inventory of the product, a history of the quantity of the product actually produced and a history of the sales performance of the product, for a product of interest, computes the ideal safety stock level and the actual safety stock level of the product, and displays in the display part, the ideal safety stock level (ideal amount of money for safety stock 1403 indicated by a horizontal straight line) of the computed product and the actual quantity of the safety stock (actual amount of money for safety stock 1402 indicated by a horizontal straight line) of the product, together with the history of the actual inventory of the product (amount of money for inventory 1401 indicated by a bar graph). <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

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

In manufacturing, logistics, and retailing, inventory management of various products is performed. In inventory management, it is important to detect inventory abnormalities at an early stage, such as the occurrence of long-term staying inventory and out-of-stock items, and to take safety inventory measures. In particular, when the demand amount or supply amount fluctuates due to changes in market trends, production plans, supply destinations, or any troubles in the next process, the possibility of occurrence of the abnormality is further increased. Here, the “safety stock” refers to a stock that should be produced in advance in order to prevent a future demand for a product from becoming larger than predicted and the stock from becoming a shortage. Nonetheless, it is not necessary to have a large amount of safety stock, and basically, even if it is temporary, it should not be out of stock. Is always maintained.
Note that Patent Document 1 discloses inventory management that performs accurate replenishment production according to the case of the fluctuation.

JP 2009-271865 A

By the way, in order to detect stock abnormalities at an early stage and to make appropriate safety stock decisions even between people in different positions, such as those in the production department or the management department, It is very effective to display in an easy-to-understand manner. However, in the conventional inventory management technology including the technology of Patent Document 1, basically, the inventory transition is displayed in a list of numbers, and a number of screens are referred to in order to detect an abnormality in inventory. And needed a lot of operations. For this reason, not only is the efficiency of detecting inventory abnormalities poor, but also people with different positions have different perceptions of inventory abnormalities (for example, logistics personnel who are not always able to run out of stocks Sales representatives perceive it as a problem from the point of view of past operations), but it is difficult to make specific decisions.
Therefore, in view of such circumstances, an object of the present invention is to effectively support measures for product safety stock.

In order to achieve the above object, in the present invention, the graph displayed by the display means for the product of interest (which may be a part) is displayed in a time transition of the inventory amount, an ideal safety inventory amount obtained by a predetermined calculation, and a predetermined amount. In addition, the actual safety stock amount obtained by the above judgment is also displayed. This makes it possible for anyone to see at a glance the discrepancy between the ideal safety stock quantity and the actual safety stock quantity, so it is possible to quickly find inventory abnormalities and make appropriate safety stock decisions. . Note that the safety stock quantity is indicated by the quantity or amount of the product that is the target of the safety stock.
Details will be described later.

  ADVANTAGE OF THE INVENTION According to this invention, the countermeasure of the safe stock of a product can be supported effectively.

It is a software block diagram of the inventory management apparatus of this embodiment. It is a figure which shows an example of the data structure of log | history DB001. It is a figure which shows an example of the data structure of the historical data. 3 is a functional configuration diagram illustrating details of a product graph display unit 10. FIG. It is a flowchart which shows the processing content by the inventory performance graph production | generation means 103. FIG. 4 is a flowchart showing the contents of processing by an ideal safety stock quantity calculation means 104. 5 is a flowchart showing the contents of processing by an actual safety stock quantity calculation means 105. It is a flowchart which shows the processing content regarding the ideal safe stock quantity calculation method A. It is a flowchart which shows the processing content regarding the ideal safety stock quantity calculation method B. It is a flowchart which shows the processing content regarding the actual safety stock amount calculation method C. It is a flowchart which shows the processing content regarding the actual safety stock quantity calculation method D. It is a flowchart which shows the processing content regarding the actual safety stock quantity calculation method E. It is a flowchart which shows the processing content regarding the actual safety stock amount calculation method F. It is a display example of a screen displayed on the display unit of the inventory management device. It is a flowchart which shows the processing content required for the thumbnail display for every product. It is a display example of a screen displayed on the display unit of the inventory management apparatus by executing processing necessary for displaying thumbnails for each product.

  A mode for carrying out the present invention (hereinafter referred to as “embodiment”) will be described with reference to the drawings as appropriate.

≪Configuration≫
FIG. 1 is a software configuration diagram of the inventory management apparatus according to the present embodiment. The inventory management apparatus includes software configurations such as a history DB (Data Base) 001, a product selection unit 002, a specific product history data extraction unit 003, and a product graph display unit 10.

  This inventory management apparatus includes an input unit (eg, pointing device, touch panel), a display unit (eg, display, touch panel), a control unit (eg, CPU (Central Processing Unit)), and a storage unit (eg, memory, ROM (Read A computer including only memory (RAM), random access memory (RAM), and hard disk drive (HDD) as a hardware configuration. This inventory management apparatus stores an inventory management program for realizing the product graph display unit 10 as a software configuration in the storage unit. When the control unit executes this program, processing required for inventory management is executed.

The history DB 001 is a database that stores the actual inventory of products that are subject to inventory management.
FIG. 2 is a diagram illustrating an example of the data structure of the history DB 001. The history DB 001 includes fields such as “product code”, “date”, “production performance amount”, “sales performance amount”, and “inventory performance amount”.

The “product code” is an identification number of a product that is subject to inventory management.
The “date” is a date for determining the actual product inventory, and the inventory transition of the product can be tracked on a daily basis. The week, month, and year may be determined according to the type of product, and tracking may be performed on a weekly, monthly, or yearly basis. For convenience of explanation, it is assumed that the history DB 001 includes a record relating to a daily product.

  “Actual production amount” indicates the actual production amount as a monetary amount when the corresponding product is produced at the factory on the same day. For convenience of explanation, it is shown as a monetary amount. Basically, since the unit price of the product is determined, it may be shown as the quantity of the product.

“Actual sales amount” indicates the actual sales amount as a monetary amount when the corresponding product is sold in the market on that day.
“Inventory actual amount” indicates the actual amount of stock when the corresponding product is stocked in a predetermined space on the day.

  In the history DB 001 in FIG. 2, for example, focusing on the record in the first line, the product with the product code 100001 was produced for ¥ 77,000,000 on February 1, 2009, and is in stock without being sold. It is shown that.

  The product selection unit 002 has a function of selecting a product that the user wants to focus on by inputting from the input unit, and is realized by, for example, an operation on a GUI (Graphic User Interface) screen.

  The specific product history data extraction unit 003 has a function of extracting a record related to the product selected by the product selection unit 002 from the history DB 001. For example, the specific product history data extraction unit 003 is realized by a product information search apparatus for a database such as SQL (Structured Query Language). To do.

The product graph display unit 10 has a function of displaying a product inventory transition or the like in a graph, and includes history data 101, a screen generation unit 100, and a thumbnail display control unit 102.
The history data 101 is data extracted from the history DB 001 by the specific product history data extraction unit 003 and developed in the storage area of the storage unit.

  FIG. 3 is a diagram illustrating an example of the data structure of the history data 101. The history data 101 includes fields such as “Product Code”, “Date”, “Production Actual Amount”, “Sales Actual Amount”, and “Inventory Actual Amount”. The history data 101 shown in FIG. 3 is equivalent to the product in which the product of the product code 100001 is specified by the specific product history data extraction unit 003 and the record relating to the product is extracted from the history DB 001.

Based on the history data 101, the screen generation unit 100 generates a screen depicting a graph such as inventory transition related to the product of interest. Details of the screen generation means 100 will be described later.
The thumbnail display control unit 102 performs control so that the screens generated by the screen generation unit 100 for a plurality of products of interest are displayed as thumbnails. The thumbnail display control means 102 will be described later.

  FIG. 4 is a functional configuration diagram illustrating details of the product graph display unit 10. FIG. 4 shows the history data 101, the screen generation means 100, and the thumbnail display control means 102 already described. The screen generation unit 100 includes an inventory performance graph generation unit 103, an ideal safety stock amount calculation unit 104, an ideal safety stock amount calculation method table 1041, an ideal safety stock amount calculation method selection unit 1042, and a parameter input unit 1043. The actual safety stock quantity calculation means 105, the actual safety stock quantity calculation method table 1051, the actual safety stock quantity calculation method selection means 1052, the ideal safety stock straight line generation means 106, and the actual safety stock straight line generation means 107 Consists of including.

Based on the history data 101, the inventory performance graph generation unit 103 depicts the inventory amount of the product of interest as, for example, a bar graph.
The ideal safety stock amount calculation unit 104 calculates an ideal safety stock amount of the product of interest based on the history data 101. The ideal safety stock quantity may be referred to as an ideal safety stock quantity calculation method A (hereinafter simply referred to as “method A”) registered in the ideal safety stock quantity calculation method table 1041. Method) or an ideal safety stock amount calculation method B (hereinafter simply referred to as “method B”. First calculation method).

  The ideal safe stock quantity calculation technique selection means 1042 selects an ideal safe stock quantity calculation technique designated by the user from the ideal safe stock quantity calculation technique table 1041 by input from the input unit. The selected ideal safety stock calculation method is developed on the memory. The ideal safe stock quantity calculation method selection means 1042 is realized by designation by a GUI operation on the screen of the display unit or designation by an external file. Note that the ideal safety stock quantity calculation unit 104 calculates the ideal safety stock quantity of the product of interest using the selected ideal safety stock quantity calculation method.

  The parameter input means 1043 sets, as a parameter, a safety stock count α used in Method A described later, based on input from the input unit. The set safety stock count α is developed on the memory. The parameter input means 1043 is realized by designation by a GUI operation on the screen of the display unit or designation by an external file.

  The actual safety stock quantity calculation means 105 calculates the actual safety stock quantity of the product of interest based on the history data 101. The actual safety stock quantity is an actual safety inventory quantity calculation method C registered in the actual safety stock quantity calculation method table 1051 (hereinafter, sometimes simply referred to as “method C”, the second calculation method), An actual safety stock calculation method D (hereinafter simply referred to as “method D”; sometimes a second calculation method), an actual safe stock amount calculation method E (hereinafter simply referred to as “method E”) The second calculation method) or the actual safety stock calculation method F (hereinafter sometimes simply referred to as “method F”. The second calculation method).

  The actual safe stock quantity calculation method selection means 1052 selects the actual safe stock quantity calculation method designated by the user from the actual safe stock quantity calculation method table 1051 by input from the input unit. The selected actual safety stock calculation method is developed on the memory. The actual safe stock quantity calculation method selection means 1052 is realized by designation by a GUI operation on the screen of the display unit or designation by an external file. The actual safety stock quantity calculation means 105 calculates the actual safety inventory quantity of the product of interest using the selected actual safety inventory quantity calculation method.

The ideal safety stock straight line generation means 106 describes the ideal safety stock quantity calculated by the ideal safety stock quantity calculation means 104 by, for example, a horizontal straight line.
The actual safety stock straight line generation unit 107 depicts the actual safety stock amount calculated by the actual safety stock amount calculation unit 105, for example, as a horizontal straight line.

<< Process >>
Next, the processing content of the inventory management apparatus of this embodiment is demonstrated in detail. The subject of the processing described below is the control unit of the inventory management apparatus.

FIG. 5 is a flowchart showing the contents of processing by the inventory performance graph generation means 103.
First, in step S501, one record is extracted from the history data 101 (for example, in order from the top) and read. After extraction, the process proceeds to step S502.

In step S502, the date included in the extracted record is held in the variable d. After the hold, the process proceeds to step S503.
In step S503, the actual inventory amount included in the extracted record is held in the variable v. After holding, the process proceeds to step S504.

  In step S504, a bar graph is drawn with the X value d and the Y value v in the graph area with the date as the X coordinate and the actual inventory amount as the Y coordinate. After drawing, the process proceeds to step S505.

In step S505, it is determined whether or not there is a record in the history data 101 in which the drawing has not been processed. If it exists (Yes in Step S505), the process returns to Step S501, and Steps S501 to S504 are performed on the unprocessed record. If it does not exist (No in step S505), it means that the drawing of the bar graph has been completed, and the entire process is terminated.
The graphic data of the drawn bar graph is stored on the memory and displayed on the display unit.

FIG. 6 is a flowchart showing the contents of processing by the ideal safety stock amount calculation means 104.
First, in step S601, the ideal safety stock amount calculation method selected by the user is referred to. After the reference, the process proceeds to step S602.

  In step S602, it is determined whether or not the selected ideal safety stock amount calculation method is the method A. If it is method A (Yes in step S602), the process proceeds to step S603. If it is not the method A (No in step S602), it means that the method B is selected, and the process proceeds to step S604.

In step S603, the parameter input unit 1043 refers to the safety stock count α that is used in the technique A and is preliminarily developed in the memory. After the reference, the process proceeds to step S604.
In step S604, the selected ideal safe stock quantity calculation method is executed. After execution, the process proceeds to step S605.

In step S605, an ideal safety stock quantity that is an execution result when the ideal safety stock quantity calculation method is executed is output. By outputting, the entire process is completed.
The output straight line indicating the ideal safety stock amount is stored as graphic data on the memory and displayed on the display unit.

FIG. 7 is a flowchart showing the contents of processing by the actual safety stock quantity calculation means 105.
First, in step S701, an actual safety stock amount calculation method (any of methods C to F) selected by the user is referred to. After the reference, the process proceeds to step S702.

In step S702, the selected actual safety stock amount calculation method is executed. After execution, the process proceeds to step S702.
In step S703, the actual safety stock quantity that is the execution result when the actual safety stock quantity calculation method is executed is output. By outputting, the entire process is completed.
The output straight line indicating the actual safety stock quantity is stored in the memory as graphic data and displayed on the display unit.

FIG. 8 is a flowchart showing the processing contents related to the ideal safety stock quantity calculation method A. This process is included in step S604.
First, in step S <b> 801, the procurement lead time LT is calculated from production record data that is a value registered in “production record amount” of the history data 101. The procurement lead time means a period from when an order for a product is received until the arrival (sale) of the product is completed. The procurement lead time LT is expressed by the following equation.

LT = (length of period) ÷ (number of productions)

Here, the “period length” means the length of the period of the data included in the history data 101. For example, according to the history data 101 shown in FIG. It means 6 days of February 6, 2009 (provided that the product is produced on February 7, 2009). “Production count” means the number of times a product is produced during the period. According to the history data 101 shown in FIG. And the number of productions = 1. However, when two or more days in which “production result amount” is greater than 0 are consecutive, records of consecutive days are collectively counted as one. After calculating the procurement lead time LT, the process proceeds to step S802.

  In step S <b> 802, the standard deviation σ is calculated from the sales record data that is a value registered in the “sales record amount” of the history data 101. This standard deviation σ means a variation in the actual sales amount (that is, demand) of the product, and is 2 of the difference between the individual value registered in the “sales actual amount” of the history data 101 and the average value of these values. It is indicated by the square root of the average of the sum of multipliers. After calculating the standard deviation σ, the process proceeds to step S803.

  In step S803, a value of α × σ × √LT is obtained by using the safety stock count α developed in the memory, the procurement lead time LT, and the standard deviation σ, and the value is held in the variable x. After holding, the process proceeds to step S804.

In step S804, the value held in the variable x (that is, α × σ × √LT) is set as an ideal safety stock amount. By setting, the entire process is completed.
Here, σ means a standard deviation for one day, and σ × √LT means a standard deviation for LT days. The safety stock count α is a value arbitrarily set by the user, for example, from the input unit. For example, when it is desired to set the probability of preventing a stock shortage state to 95% on a certain day, α is set to 0. .95 is set. At this time, the value of α × σ × √LT is a standard deviation that has a probability of preventing a stock shortage state during the period of the procurement lead time LT to be 95% or more. This means that an inventory quantity that has an occurrence probability within 5% is regarded as ideal.

  FIG. 9 is a flowchart showing the processing contents related to the ideal safety stock amount calculation method B. This process is included in step S604. Method B uses the maximum deviation of the total sales performance amount during the procurement lead time as an ideal safety stock amount.

  First, in step S <b> 901, the procurement lead time LT is calculated from production record data that is a value registered in the “production record amount” of the history data 101. After calculating the procurement lead time LT, the process proceeds to step S902.

  In step S902, one record (for example, one record from the beginning) is extracted from the history data 101, and sales record data that is a value registered in “sales record amount” is set in the variable v. After setting, the process proceeds to step S903.

  In step S903, it is determined whether v is greater than 0, that is, whether the product has been sold. If v is greater than 0 (Yes in step S903), the process proceeds to step S904, and if not (No in step S903), the process returns to step S902 to extract one next record. By the processing in steps S902 and S903, the first day on which the sales performance is greater than 0 (actually sold) is specified.

  In step S904, a variable i is set and 0 is substituted for the variable i. After the substitution, go to step S905. The variable i means the date of the history data 101, and i = 0 means the start date of the procurement lead time LT.

  In step S905, one record is extracted from the history data 101 (for example, one record from which the sales performance amount is larger than 0 after setting the variable i), and the sales performance data is set to the variable v. . After setting, the process proceeds to step S906.

In step S906, i + 1 is substituted into the variable i (the date is lowered by one day). After the substitution, go to step S907.
In step S907, it is determined whether or not the relational expression i <LT is satisfied. If the relational expression is satisfied (Yes in step S907), it means that the date of interest has not reached the end date of the procurement lead time LT, and the process proceeds to step S908. If the relational expression is not satisfied (No in step S907), it means that the date of interest has reached the end date of the procurement lead time LT, and the process proceeds to step S909.

  In step S908, the value of the variable v corresponding to the set variable i, that is, the actual sales amount of the product on the date of interest is stored in the array a. After storing, the process proceeds to step S910.

  In step S909, the total value of the array a, that is, the total amount of the sales performance amount of the product during the procurement lead time LT stored in the array a is stored in the array b. After storing, the process proceeds to step S910.

  In step S910, it is determined whether or not the relational expression LT <(record number of history data) is satisfied. If the relational expression is satisfied (Yes in step S910), it means that there are records in the history data 101 that have not been referred to in the present process, and step S911 is used to refer to all records. Proceed to On the other hand, if the relational expression is not satisfied (No in step S910), it means that all the records of the history data 101 have been referred to, and the process proceeds to step S913.

  In step S911, it is determined whether or not the relational expression i <LT is satisfied. If the relational expression is satisfied (Yes in step S911), it means that the date of interest has not reached the end date of the procurement lead time LT, and the process returns to step S905. As a result, the actual sales amount for the next date stored in the array a is searched, and another total amount of the actual sales amount for the product during the procurement lead time LT starting from the next date is obtained. , Stored in the array b. On the other hand, if the relational expression is not satisfied (No in step S911), it means that the date of interest has reached the end date of the procurement lead time LT, and the total value of the array a is obtained in step S909. The process proceeds to step S912.

  In step S912, the total value of the array a is obtained and stored in the array b (see step S909). After the array a is cleared, the process returns to step S904. Thereby, the process for obtaining the total value of the array a stored in the array b is repeated.

Finally, in step S913, the maximum value of the values stored in the array b is specified, the average value of the values stored in the array b is obtained, and the difference between the maximum value and the average value, that is, the maximum value in the array b is determined. The deviation is calculated, and the calculated maximum deviation is set as an ideal safety stock quantity. By determining the ideal safety stock, the entire process is terminated.
The ideal safety stock amount determined by Method B is determined more in line with the current status of product inventory, that is, reflecting the inventory history more deeply than that determined by Method A. .

  FIG. 10 is a flowchart showing the processing contents related to the actual safety stock quantity calculation method C. This process is included in step S702. In Method C, the actual amount of inventory in stock on the day before the most recent manufacturing date (product production date) is used as the actual safety stock amount.

  First, in step S1001, one record is extracted from the tail (date is the latest) of the history data 101, the date is set as a variable d, and the production performance amount on that date is set as a variable v. After setting, the process proceeds to step S1002.

  In step S1002, it is determined whether or not v is greater than 0, that is, whether or not a product has been produced. If v is greater than 0 (Yes in step S1002), the process proceeds to step S1003. Otherwise (No in step S1002), the process proceeds to step S1004.

  In step S1003, the actual inventory amount of the day before the date indicated by the variable d is obtained from the history data 101, and the actual inventory amount is set as the actual safety inventory amount. By determining the actual safety stock amount, the entire process is completed.

  In step S1004, it is determined whether or not there is an unprocessed record in the history data 101. If there is an unprocessed record (Yes in step S1004), the process returns to step S1001, and this process is repeated for the record. If there is no unprocessed record (No in step S1004), the process proceeds to step S1005.

In step S1005, since there is no record (production date) indicating product production in the history data 101, the actual safety stock quantity is set to zero. By determining the actual safety stock amount, the entire process is completed.
The actual safety stock amount determined by the method C has an advantage that it can be easily obtained because it only searches for the actual stock price on the day before the latest production date.

  FIG. 11 is a flowchart showing the processing contents related to the actual safety stock quantity calculation method D. This process is included in step S702. In Method D, the average value of the actual stock price on the day before the manufacturing date is used as the actual safety stock amount.

  First, in step S1101, one record is extracted from the tail of the history data 101, the date is set in the variable d, and the production performance amount on that date is set in the variable v. After setting, the process proceeds to step S1102.

  In step S1102, it is determined whether v is greater than 0, that is, whether a product has been produced. If v is greater than 0 (Yes in step S1102), the process proceeds to step S1103, and if not (No in step S1102), the process proceeds to step S1104.

  In step S1103, the actual inventory price of the day before the date indicated by the variable d is obtained from the history data 101, and the actual inventory price is stored in the array a. After storing, the process proceeds to step S1104.

  In step S1104, it is determined whether or not there is an unprocessed record in the history data 101. If there is an unprocessed record (Yes in step S1104), the process returns to step S1101, and this process is repeated for that record. If there is no unprocessed record (No in step S1104), it means that all the actual inventory amounts on the day before the production date stored in the array a are specified, and the process proceeds to step S1105.

In step S1105, the average value of the actual inventory amount stored in the array a is calculated, and the average value is set as the actual safety stock amount. By determining the actual safety stock amount, the entire process is completed.
It can be said that the actual safety stock amount determined by the method D is determined in accordance with the current state of the actual product inventory, that is, reflecting the inventory history more deeply than that determined by the method C.

  FIG. 12 is a flowchart showing the processing contents related to the actual safety stock quantity calculation method E. This process is included in step S702. In Method E, the actual amount of inventory in the latest inventory valley (the amount of inventory on the day when the inventory is less than the previous and subsequent days) is used as the actual safety inventory amount.

  First, in step S1201, one record is extracted from the tail of the history data 101, the date is set as the variable d, and the actual stock price on that date is set as the variable v. After setting, the process proceeds to step S1202.

  In step S1202, it is determined whether the actual inventory price on the day before the date indicated by the variable d is greater than the actual inventory price indicated by the variable v. If it is larger (Yes in Step S1202), the process proceeds to Step S1203, and if not (No in Step S1202), the process proceeds to Step S1205.

  In step S1203, it is determined whether or not the actual inventory amount on the day after the date indicated by the variable d (next day) is larger than the actual inventory amount indicated by the variable v. If it is larger (Yes in step S1203), it means that the actual inventory amount indicated by the variable v indicates “stock valley”, and the process proceeds to step S1204; otherwise (No in step S1203), the process proceeds to step S1205. .

  In step S1204, the actual inventory amount indicated by the variable v is set as the actual safety inventory amount. By determining the actual safety stock amount, the entire process is completed.

  In step S1205, it is determined whether or not there is an unprocessed record in the history data 101. If there is an unprocessed record (Yes in step S1205), the process returns to step S1201, and this process is repeated for that record. If there is no unprocessed record (No in step S1205), the process proceeds to step S1206.

In step S1206, since there is no record indicating “valid of inventory” in the history data 101, the actual safety stock quantity is set to zero. By determining the actual safety stock amount, the entire process is completed.
The actual safety stock quantity determined by the technique E has higher reliability of the actual safety stock quantity than those obtained by the technique C and the technique D. Normally, the update timing of the history DB 001 is executed out of the current state of the production site of the product (on the data), so the actual inventory amount has increased even though it has not been produced, or even though it has been produced, There may be a situation where a “valley of inventory” has not occurred. In response to such a situation, Method E is not affected by a shift in update timing because the “stock valley” is specified in the history data 101.

  FIG. 13 is a flowchart showing the processing contents related to the actual safety stock quantity calculation method F. This process is included in step S702. In Method F, the average value of the stock price in the valley of the stock is used as the actual safety stock amount.

  First, in step S1301, one record is extracted from the tail of the history data 101, the date is set in the variable d, and the actual inventory amount on that date is set in the variable v. After setting, the process proceeds to step S1302.

  In step S1302, it is determined whether or not the actual inventory price on the day before the date indicated by the variable d is greater than the actual inventory price indicated by the variable v. If it is larger (Yes in Step S1302), the process proceeds to Step S1303. Otherwise (No in Step S1302), the process proceeds to Step S1305.

  In step S1303, it is determined whether or not the actual inventory price on the day after the date indicated by the variable d (next day) is greater than the actual inventory price indicated by the variable v. If it is larger (Yes in Step S1303), it means that the actual inventory amount indicated by the variable v indicates “Inventory Valley”, and proceeds to Step S1304, otherwise (No in Step S1303), proceeds to Step S1305. .

  In step S1304, the actual inventory amount indicated by the variable v is stored in the array a. After storing, the process proceeds to step S1305.

  In step S1305, it is determined whether or not there is an unprocessed record in the history data 101. If there is an unprocessed record (Yes in step S1305), the process returns to step S1301, and this process is repeated for that record. If there is no unprocessed record (No in step S1305), it means that all inventory actual amounts of “stock valley” stored in the array a are specified, and the process proceeds to step S1306.

In step S1306, the average value of the actual inventory amount stored in the array a is calculated, and the average value is set as the actual safety stock amount. By determining the actual safety stock amount, the entire process is completed.
It can be said that the actual safety stock amount determined by the method F is determined in accordance with the current state of the actual product inventory, that is, reflecting the inventory history more deeply than that determined by the method E.

  FIG. 14 is a display example of a screen displayed on the display unit of the inventory management apparatus. In the combo box 1404, an ideal safety stock quantity calculation method (A, B) is selected. In the combo box 1405, an actual safety stock amount calculation method (C to F) is selected. In the text box 1406, the value of the inventory safety coefficient α (0.97 in FIG. 14) used in the ideal safety stock quantity calculation method A is input.

  When the redraw button 1407 is pressed after the above input is completed, a graph 1401 of the actual inventory amount is displayed in the actual graph generation unit 103 in the graph display area 1408 (shaded display in FIG. 14). At the same time, an ideal safety stock amount (amount) 1403 and an actual safety stock amount (amount) 1402 are displayed in a straight line by the ideal safety stock straight line generation means 106 and the actual safety stock straight line generation means 107. The ideal safety stock straight line generation means 106 and the actual safety stock straight line generation means 107 respectively use the ideal safety stock quantity 1403 and the actual safety stock quantity 1402 as the values of the Y axis (vertical axis) and the X axis (horizontal). Draw a straight line parallel to the axis. However, drawing is not performed when the value of the Y axis is 0.

  If the display as shown in FIG. 14 is performed, the person concerned (for example, the person in the production department or the person in the management department) who witnessed the display can easily grasp whether the safety stock is good or bad. For example, in FIG. 14, since the actual safety stock amount exceeds the ideal safety stock amount by a considerable amount, it is possible to confirm the occurrence of long-term staying inventory. It can be seen that even if the safety stock quantity is reduced to about half, it will not be out of stock with a probability of 97%.

  If the ideal safety stock amount exceeds the actual safety stock amount, the actual safety stock amount that we have been continually adopting on the assumption that there are no worries about missing items is actually a missing item. This means that there is a high risk of falling into a state, and such an abnormality can be easily confirmed by performing a display as shown in FIG.

[Thumbnail display]
Next, a technique for displaying the ideal safety stock quantity and the actual safety stock quantity as thumbnails for each product will be described. This thumbnail display control is realized by the thumbnail display control means 102.

  FIG. 15 is a flowchart showing the processing content required for displaying thumbnails for each product. The subject of processing is a control unit of the inventory management apparatus, which is realized by the screen generation means 100 and the thumbnail display control means 102.

  First, in step S1501, a record of a product p from the history data 101 is extracted using the product code of the product p as a search key. After extraction, the process proceeds to step S1502.

  In step S1502, the inventory history graph generation unit 103 generates an inventory history graph that depicts the inventory amount of the product p as a bar graph. After the generation, go to step S1503.

In step S1503, the ideal safety stock straight line generating means 106 generates a straight line indicating the ideal safety stock quantity of the product p. After the generation, go to step S1504.
In step S1504, the actual safety stock straight line generating means 107 generates a straight line indicating the actual safe stock amount of the product p. After the generation, the process proceeds to step S1505.

  In step S1505, the generated inventory history graph, the straight line indicating the ideal safety stock amount, and the straight line indicating the actual safety stock amount are combined to generate a thumbnail of the graph of the product p and add it to the thumbnail list. After the addition, the process proceeds to step S1506.

  In step S1505, it is determined whether or not there is an unprocessed record in the history data 101. If there is an unprocessed record (Yes in step S1506), the process returns to step S1501, and this process is repeated for that record. If there is no unprocessed record (No in step S1506), it means that thumbnails have been generated for all products, and the entire process ends.

  FIG. 16 is a display example of a screen displayed on the display unit of the inventory management apparatus by executing the processing necessary for displaying thumbnails for each product. In the combo box 1602, an ideal safety stock quantity calculation method (A, B) is selected. In the combo box 1603, an actual safety stock amount calculation method (C to F) is selected. In the text box 1604, the value of the inventory safety coefficient α (0.97 in FIG. 16) used in the ideal safety stock quantity calculation method A is input.

  When the redraw button 1605 is pressed after the above input is completed, a thumbnail of the graph is displayed for each product by the thumbnail display control unit 102 in the thumbnail list display area 1601. Since the display of each thumbnail is basically the same as that shown in FIG. 14, its description is omitted.

  If the thumbnail display of FIG. 16 is performed, a product having an abnormality in its stock can be identified instantly. That is, it can be seen that the product in which the straight line indicating the ideal safety stock amount and the straight line indicating the actual safety stock amount are greatly deviated is relatively short or in a long-term stay state.

≪Summary≫
According to the present embodiment, the following effects can be obtained. In other words, the ideal safety stock amount and the actual safety stock amount are displayed together on the graph showing the inventory transition of the safety stock, so the person who viewed the display is ideal for anyone in any position. By confirming the difference between the actual safety stock quantity and the actual safety stock quantity, the soundness of the safety stock can be confirmed. Therefore, it is possible to easily make a safety stock decision for a product that requires countermeasures.
Also, if thumbnails are displayed for each product, it is possible to instantly identify an abnormal product having a large discrepancy between the ideal safety stock quantity and the actual safety stock quantity.
If the actual safety stock quantity is calculated using the method E or the method F, the “stock valley” is specified in the history data 101, so the update timing of the history DB 001 (functions as an inventory management device). It is not affected by errors due to the timing of inputting data (various actual amounts) to the computer.

≪Others≫
The above-described embodiment is suitable for carrying out the present invention, but the form of implementation is not limited to these, and various modifications can be made without departing from the gist of the present invention. Is possible.

  For example, in this embodiment, when a holiday is included in the date indicated by the history DB 001 or the history data 101, the inventory transition excluding the holiday can be displayed. Therefore, the day before or the day after the day when the actual sales amount referred to when determining the “valley of inventory” is determined to be the day before the production date, or the day after the day is to be treated as meaning the previous business day or the next business day. Can do.

  In the present embodiment, the (horizontal) straight line indicated by the ideal safety stock quantity and the (horizontal) straight line indicated by the actual safety stock quantity are highlighted by appropriately changing the line type, thickness, color, and the like. May be. For an inventory transition graph of a product in which the difference between the ideal safety stock quantity and the actual safety stock quantity is large, a warning may be displayed by changing the color of the entire display screen.

  In addition, the thumbnail display according to the present embodiment may change the vertical and horizontal widths of the thumbnails, change the number arranged in a horizontal row, change the number arranged in a vertical row (grid format), or arrange commands from the user. Thus, the products having a larger (or smaller) difference between the ideal safety stock quantity and the actual safety stock quantity may be rearranged so that they are displayed in order from the top.

  In addition to the procurement lead time, the lead time of the present embodiment includes development lead time, production lead time, delivery lead time, or a combination of these in consideration of product characteristics and manufacturing convenience. You may make it use.

  In addition, in the display of the inventory transition graph, it is a matter of course that these additional information may be described together with consideration of the clarity of the graph, such as a numerical value of the inventory amount and a comment describing the state of the safety stock. .

  Other specific configurations of hardware, software, flowcharts, databases, and the like can be changed as appropriate without departing from the spirit of the present invention.

001 history DB (data indicating the history of actual product inventory, data indicating the history of actual product production, and data indicating the history of product sales)
10. Product graph display unit 101 History data (data indicating the history of actual product inventory, data indicating the history of actual production of products, data indicating the history of actual sales of products)
DESCRIPTION OF SYMBOLS 100 Screen generation means 102 Thumbnail display control means 103 Inventory performance graph generation means 104 Ideal safe stock quantity calculation means 105 Real safety stock quantity calculation means 106 Ideal safety stock straight line generation means 107 Real safety stock straight line generation means 1041 Ideal safety stock calculation method table (stores first calculation method)
1051 Actual safety stock calculation method table (stores second calculation method)

Claims (9)

In the inventory management device that has a display unit that displays the stock status of the product safety stock, and supports decision making of the product safety stock,
The storage unit of the inventory management device includes:
For each product, data indicating the history of actual product inventory, data indicating the history of product production, and data indicating the history of product sales are stored for each product.
Storing a first calculation method for calculating an ideal safety stock amount of a product and a second calculation method for calculating an actual safety stock amount of the product;
The control unit of the inventory management device includes:
For the product specified from the input unit, the ideal safety stock amount of the product is calculated using the first calculation method based on the history of the actual production amount of the product and the history of the actual sales amount of the product. Control to
Control for calculating the actual safety stock amount of the product by using the second calculation method based on the history of the actual product inventory amount of the product and, if necessary, the history of the actual production amount of the product. When,
And a control for displaying the calculated ideal safety stock quantity of the product and the actual safety stock quantity of the product together with the history of the actual inventory quantity of the product on the display unit. Inventory management device. The control unit of the inventory management device includes:
In the graph where the horizontal axis indicates time and the vertical axis indicates the actual product inventory, ideal safety stock, and actual safety stock, the bar graph displays the history of actual product inventory. The inventory management apparatus according to claim 1, further comprising: a control that displays the calculated ideal safety stock amount of the product and the actual safety stock amount of the product in a horizontal line. The control unit of the inventory management device includes:
The inventory according to claim 1 or 2, wherein a thumbnail for the display is generated for each product, and control is performed to display the thumbnail in a predetermined format for each product on the display unit. Management device. The control unit of the inventory management device includes:
Product procurement lead time calculated from the safety stock count α input from the input unit, the standard deviation σ of the product sales actual amount calculated from the history of the actual sales amount of the product, and the history of the actual production amount of the product The inventory management device according to any one of claims 1 to 3, wherein an LT is used to perform control such that an ideal safety stock quantity of the product is α × σ × √LT. . The control unit of the inventory management device includes:
The total value of the actual sales amount of the product within the period indicated by the procurement lead time of the product calculated from the history of the actual production amount of the product is calculated, and the ideal safety stock amount of the product is calculated based on the total value. The control which makes a maximum deviation is performed. The inventory management apparatus in any one of Claims 1-3 characterized by the above-mentioned. The control unit of the inventory management device includes:
The inventory management apparatus according to any one of claims 1 to 3, wherein the actual safety stock quantity of the product is controlled to be an actual inventory quantity on the day before the latest production date of the product. . The control unit of the inventory management device includes:
4. The control for executing the actual safety stock amount of the product as an average value of the actual stock amount on the day before the production date of the product included in the predetermined period. The inventory management device described in Crab. The control unit of the inventory management device includes:
The actual safety stock amount of the product is controlled so as to be the actual stock amount on the latest date that is smaller than the actual stock amount on the preceding and succeeding days of the product. The inventory management apparatus in any one of. The control unit of the inventory management device includes:
Performing control to set the actual safety stock quantity of the product to an average value of the actual inventory quantity on a day that is less than the actual inventory quantity on the preceding and succeeding days of the product included in the predetermined period. The inventory management apparatus according to any one of claims 1 to 3.

Images