JP2013234035A - Stock management device, stock management method and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To appropriately calculate a quantity of a stock of products whose demand is changed according to the time of the year without requiring a user's time and labor.SOLUTION: Achievement information showing the monthly achievement of shipping of products of one year is stored in a shipping achievement storage part 11. A lower limit stock setting part 15 calculates the lower limit quantity of stock of products based on the achievement information stored in the shipping achievement storage part 11, and stores it in a lower limit stock storage part 12. A stock calculation part 16 calculates the quantity of stock of products based on the achievement information stored in the shipping achievement storage part 11, and sets the lower limit quantity of stock as the quantity of stock of products when the calculated quantity of stock is smaller than the lower limit quantity of stock.

Description

  The present invention relates to an inventory management apparatus, an inventory management method, and a program for calculating the number of products in stock.

  There are known methods for securing an inventory of products whose demand fluctuates depending on the season and time. For example, Patent Document 1 describes predicting (simulating) the number of stocks at a certain period by analyzing the past shipment results of the same period.

JP 2002-179218 A

  When forecasting the number of inventory based on the above-mentioned results, if the number of shipments in the same period in the past is extremely small, the number of inventory to be secured at that time is also expected to be extremely small. There was a case that could not be done.

  Therefore, in this case, the user has to manually input an appropriate number of stocks, which is troublesome. Further, since the number of stocks input by the user varies, it is difficult to manually set an appropriate number of stocks.

  The present invention has been made in view of the above circumstances, and an inventory management apparatus and inventory management that can appropriately calculate the inventory quantity of products whose demand fluctuates depending on the time without requiring a user's trouble. It is an object to provide a method and a program.

In order to achieve the above object, the inventory management apparatus of the present invention provides:
Record storage means for storing record information indicating the record of shipment of products for each predetermined period;
Lower limit inventory calculating means for calculating a lower limit inventory quantity based on the results information stored in the results storing means;
When the stock quantity of the product is calculated based on the performance information stored in the performance storage means, and the calculated stock quantity is smaller than the lower limit stock quantity, the stock having the lower stock quantity as the stock quantity of the product A calculation means;
It is characterized by providing.

  According to the present invention, it is possible to appropriately calculate the number of products in stock whose demand fluctuates depending on the time without requiring the user.

It is a block diagram which shows the structure of the inventory management apparatus which concerns on embodiment of this invention. It is a figure which shows the example of the shipping information memorize | stored in the shipping performance memory | storage part. It is a figure which shows the example of the information memorize | stored in the minimum stock storage part. It is a figure which shows the example of the information memorize | stored in the stock standard memory | storage part. It is a figure which shows the example of the information memorize | stored in the stock plan memory | storage part. It is a flowchart for demonstrating operation | movement of a minimum stock setting process. It is a flowchart for demonstrating operation | movement of an inventory calculation process. It is a figure which shows the example of the parameter table for a minimum inventory calculation.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. In the drawings, the same or corresponding parts are denoted by the same reference numerals.

  The inventory management apparatus 10 according to the embodiment of the present invention is an apparatus that appropriately manages the number of products in stock whose demand varies with time. The inventory management apparatus 10 is a computer such as a server that includes a central processing unit (CPU), a read only memory (ROM), a random access memory (RAM), a hard disk drive, and a communication interface. As shown in FIG. 1, the inventory management device 10 functionally includes a shipment record storage unit 11, a lower limit inventory storage unit 12, an inventory reference storage unit 13, an inventory plan storage unit 14, and a lower limit inventory setting unit. 15 and an inventory calculation unit 16.

  The shipment record storage unit 11 stores record information indicating the shipment record of each product for each predetermined period. Specifically, as shown in FIG. 2, the shipment record storage unit 11 stores record information in which the number of shipments by month for the most recent one year is recorded for each product ID representing the product type and type. The The record information stored in the shipment record storage unit 11 is updated every month by an operation from the user or an external system, and the latest shipment record is reflected.

  As shown in FIG. 3, the lower limit inventory storage unit 12 stores, for each product ID, the minimum number of products that must be secured (lower limit inventory number).

  As shown in FIG. 4, the stock reference storage unit 13 stores a reference value for calculating the number of products in stock for each product ID.

  As shown in FIG. 5, the inventory plan storage unit 14 stores the number of inventory (the number of inventory plans) to be secured for the scheduled shipping date for each product ID.

  Returning to FIG. 1, the lower limit inventory setting unit 15 calculates the lower limit inventory number based on the record information stored in the shipment record storage unit 11 and stores it in the lower limit inventory storage unit 12.

  The stock calculation unit 16 calculates the number of stocks to be secured in the designated date of the product designated by the user, and stores it in the stock plan storage unit 14. Specifically, the inventory calculation unit 16 obtains the shipment result of the same month as the designated date of the designated product from the shipment result storage unit 11 and multiplies the reference value of the designated product obtained from the inventory reference storage unit 13. Is calculated as the stock quantity. When the calculated inventory quantity is smaller than the lower limit inventory quantity of the designated product, the inventory calculation unit 16 sets the lower limit inventory quantity as the inventory quantity of the designated product.

  Subsequently, an operation of processing performed in the inventory management apparatus 10 will be described.

  First, the lower limit inventory setting process for setting the lower limit inventory quantity will be described. In the inventory management apparatus 10, the lower limit inventory setting process shown in the flowchart of FIG. 6 is performed every predetermined period (for example, every month).

  First, the lower limit inventory setting unit 15 selects one unprocessed product for which the lower limit inventory number has not yet been set in the current lower limit inventory setting process (step S11). Then, the lower limit stock setting unit 15 acquires the shipping results for one year of the selected product from the shipping result storage unit 11 (step S12).

  Subsequently, the lower limit inventory setting unit 15 specifies three items in order from the smallest number of shipments out of the acquired shipment results for one year (step S13). For example, when the record information shown in FIG. 2 is stored in the shipment record storage unit 11 and the product with the product ID “A001” is selected in step S11, the shipment date “20114” with the product ID “A001” is selected. The shipment number “30” of the month, the shipment number “45” of the shipment date “May 2011”, and the shipment number “45” of the shipment date “June 2011” are specified.

  Subsequently, the lower limit inventory setting unit 15 calculates an average value of the acquired three shipment numbers (step S14). In the above example, the average value “40” is calculated.

  Subsequently, the lower limit inventory setting unit 15 sets (updates) the lower limit inventory number of the product selected in step S11 stored in the lower limit inventory storage unit 12 to the average value calculated in step S14 (step S15).

  Subsequently, the lower limit inventory setting unit 15 determines whether there is an unprocessed product for which the lower limit inventory number is not set (step S16). When there is an unprocessed product (step S16; Yes), the lower limit inventory setting unit 15 repeats the process (step S11 to step S15) of selecting the product and setting the lower limit inventory from the actual shipment. When there is no unprocessed product (step S16; No), the lower limit stock setting process ends.

  As described above, the lower limit inventory setting process reflects the past actual number of shipments.

  Next, an inventory calculation process for calculating the number of products in stock will be described. The user operates the keyboard or the like to input the product ID of the product whose inventory quantity is to be calculated and the year and month to be calculated. In response to this input operation, the inventory management apparatus 10 executes an inventory calculation process shown in FIG.

  First, the inventory calculating unit 16 searches the actual data stored in the shipping actual result storage unit 11 with the product ID and year and month of the product input by the user, and the past period of the same product (same month). Shipment results are acquired (step S21).

  Subsequently, the stock calculation unit 16 searches the stock standard storage unit 13 with the product ID of the product input by the user, and acquires the standard value of this product (step S22).

  Subsequently, the inventory calculating unit 16 multiplies the actual value (number of shipments) indicated by the actual shipping result acquired in Step S21 by the reference value acquired in Step S22 (Step S23).

  Subsequently, the stock calculation unit 16 searches the lower limit stock storage unit 12 with the product ID of the product input by the user, and acquires the lower limit stock number of this product (step S24). Then, the inventory calculating unit 16 determines whether or not the value multiplied in step S23 is larger than the acquired lower limit inventory number (step S25).

  When larger than the lower limit inventory quantity (step S25; Yes), the inventory calculation unit 16 stores the value multiplied in step S23 in the inventory plan storage unit 14 as the inventory plan quantity (step S26).

  When it is equal to or less than the lower limit inventory quantity (step S25; No), the inventory calculation unit 16 stores the lower limit inventory quantity acquired in step S24 in the inventory plan storage unit 14 as the inventory plan quantity (step S27). This is the end of the inventory calculation process.

  Next, the inventory calculation process will be described with a specific example. It is assumed that the shipment record storage unit 11 stores record information as shown in FIG. In addition, it is assumed that the lower limit stock storage unit 12 stores information as shown in FIG. Further, it is assumed that information as shown in FIG. 4 is stored in the stock standard storage unit 13.

  In such a case, a case where the user inputs the product ID “A001” and the year and month “August 2012” and the inventory calculation process is started will be considered. In this case, as the corresponding achievement, the achievement of the product ID “A001”, the shipment date “August 2011”, and the shipment quantity “100” is acquired from the achievement information shown in FIG. Further, since the reference value of the product ID “A001” is “1.2” from the inventory reference storage unit 13 illustrated in FIG. 4, the value obtained by multiplying the number of shipments “100” is “120”. Further, from the lower limit stock storage unit 12 shown in FIG. 3, it can be seen that the lower limit stock quantity of the product ID “A001” is “40”, and the multiplication value “120” is larger. Therefore, the planned number of inventory is “120”.

  Also, consider a case where the user inputs the product ID “A001” and the date “April 2012” to start the inventory calculation process. In this case, the results of the product ID “A001”, the shipping date “April 2011”, and the number of shipments “30” are acquired from the performance information shown in FIG. Therefore, a value obtained by multiplying the reference value “1.2” is “36”. Here, since the lower limit inventory quantity of the product ID “A001” is “40” and is larger than the multiplication value “36”, the planned inventory quantity is “40”.

  As described above, according to this embodiment, when the number of stocks obtained from the number of shipments in the same period in the past is smaller than the lower limit stock number, the lower limit stock number calculated from the past performance is set as the product stock number. Therefore, it is not necessary for the user to manually set the inventory quantity when the inventory quantity is too small, and it is possible to appropriately calculate the inventory quantity of products whose demand fluctuates depending on the time without trouble for the user. Become.

  Further, according to the present embodiment, the lower limit inventory quantity is calculated based on a predetermined number of shipment results selected in order from the smallest shipment number among the past shipment results for a predetermined period. Therefore, it is possible to set an appropriate lower limit inventory quantity without relying on the user's intuition.

  In addition, this invention is not limited to the said embodiment, Of course, the various change in the part which does not deviate from the summary of this invention is possible.

  For example, in the above embodiment, in the lower limit inventory setting process, from the shipment results for one year of the product, three are selected in order from the smallest shipment number, and the average value of the shipment number is set as the lower limit inventory number did. However, the present invention is not limited to this, and for example, an average value with a predetermined weight may be used as the lower limit inventory quantity in the order from the smallest shipment quantity. Further, a value obtained by adding a predetermined margin to the average value of the shipment quantity may be used as the lower limit inventory quantity. Further, the number of shipment results to be selected in order from the smallest number of shipments is not limited to three, and any number can be adopted.

  Further, among the shipment results for one year of products, the number of shipments from the mth smallest to the nth smallest shipment may be specified, and the average value may be set as the lower limit inventory quantity. Further, m and n may be stored in the lower limit inventory calculation parameter table as shown in FIG. 8, and at least one of m and n may be freely changed in accordance with an operation input from the user. . For example, when m and n are set as shown in FIG. 8, the lower limit stock quantity of the product with the product ID “A001” is the one with the second smallest shipment quantity among the shipment results for one year. The average value of the four shipments up to the fifth smallest is the lower limit stock quantity.

  Moreover, in the said embodiment, although the calculation of the minimum inventory quantity and the calculation of the inventory quantity was performed using the shipping performance for one year recorded every month, the period for which the shipping performance is recorded is arbitrary. is there. For example, the lower limit inventory quantity and inventory quantity may be calculated from the shipment results for three years recorded every three months.

  Further, for example, by applying an operation program that defines the operation of the inventory management apparatus 10 according to the present invention to an existing personal computer, an information terminal device or the like, the personal computer or the like functions as the inventory management apparatus 10 according to the present invention. It is also possible to make it.

  Further, the distribution method of such a program is arbitrary. For example, the program can be read by a computer such as a CD-ROM (Compact Disk Read-Only Memory), a DVD (Digital Versatile Disk), an MO (Magneto Optical Disk), or a memory card. It may be distributed by storing in a recording medium, or distributed via a communication network such as the Internet.

DESCRIPTION OF SYMBOLS 10 Inventory management apparatus 11 Shipment performance memory | storage part 12 Lower limit stock memory | storage part 13 Inventory reference | standard storage part 14 Inventory plan memory | storage part 15 Lower limit stock setting part 16 Inventory calculation part

Claims (6)

Record storage means for storing record information indicating the record of shipment of products for each predetermined period;
Lower limit inventory calculating means for calculating a lower limit inventory quantity based on the results information stored in the results storing means;
When the stock quantity of the product is calculated based on the performance information stored in the performance storage means, and the calculated stock quantity is smaller than the lower limit stock quantity, the stock having the lower stock quantity as the stock quantity of the product A calculation means;
An inventory management device comprising: The lower limit inventory calculating means obtains a predetermined number of achievements in order from the smallest number of shipments among the achievements for each predetermined period indicated by the achievement information stored in the achievement storage means, and the predetermined number obtained Based on the actual result of the minute, the lower limit inventory number is calculated,
The inventory management apparatus according to claim 1, wherein: The lower limit inventory calculating means is based on the results from the mth smallest number to the nth smallest number among the results for each predetermined period indicated by the result information stored in the result storage means. Calculating the lower limit inventory quantity;
The inventory management apparatus according to claim 1, wherein: Allowing a user to set at least one of m and n;
The inventory management apparatus according to claim 3, wherein: Stores track record information indicating the track record of product shipments for each specified period,
Calculate the lower limit inventory quantity based on the stored performance information,
Calculate the inventory quantity of the product based on the stored performance information, and if the calculated inventory quantity is less than the lower limit inventory quantity, the lower limit inventory quantity is the inventory quantity of the product,
An inventory management method characterized by that. Computer
A record storage means for storing record information indicating a record of shipment of products for each predetermined period;
Lower limit inventory calculating means for calculating a lower limit inventory quantity based on the results information stored in the results storing means;
When the stock quantity of the product is calculated based on the performance information stored in the performance storage means, and the calculated stock quantity is smaller than the lower limit stock quantity, the stock having the lower stock quantity as the stock quantity of the product Calculation means,
Program to function as.

Images