JP5245466B2 - Inventory management device, inventory management method, and program - Google Patents

Description

  The present invention relates to an inventory management device, an inventory management method, and a program that can reduce uneven inventory of products among a plurality of stores.

  When one company develops a plurality of stores, it is necessary to manage the stock of each store. For example, in the inventory management system described in Patent Document 1, each store is provided with a handy terminal and a printer. The host computer at the headquarters manages the inventory status of products for each store as an inventory file. When there is a shortage of products at store A, the store clerk at store B creates a product shipment file at the handy terminal and sends it to the host computer via the telephone communication network. The store clerk at store A creates an arrival file for the received product and sends it to the host computer. The host computer compares the received file with the shipped file, and updates the inventory file if they match.

In the product inventory management system described in Patent Document 2, the inventory data calculation unit of the store server calculates the shelf inventory for the products on the display shelf based on the sales data from the POS terminal, the product supplement data, and the product disposal data. Calculate data, calculate warehouse data for products, and extract discarded products that exceed the sales deadline. When the product on the display shelf is reduced and replenished, or when the product is discarded, the wireless data transmission unit transmits the product and the number of replenishments or the number of discards to the wireless portable terminal, and causes a staff member to replenish or discard the product. The inventory data calculation unit subtracts and updates the calculated upper shelf inventory data when the product is discarded, and adds and updates the calculated upper shelf inventory data according to the number of supplements when the product supplement data receiving unit receives the supplement completion information from the wireless portable terminal.
JP 2003-323480 A JP 2002-140770 A

  The system described in the above literature replenishes a product when the product is insufficient. However, at the end of the period in which the product is sold, how to sell the product becomes important. In order to sell out products, it is preferable to eliminate uneven stock of products among a plurality of stores.

  The present invention has been made in view of the above circumstances, and an object of the present invention is to provide an inventory management device, an inventory management method, and a program that can reduce the uneven inventory of products among a plurality of stores. is there.

According to the present invention, a total inventory quantity acquisition means for acquiring a total inventory quantity that is a total value of inventory quantities of products in a plurality of stores,
An expected sales quantity acquisition means for acquiring an expected sales quantity of the product for each of the plurality of stores in a predetermined period;
Necessary inventory quantity calculating means for calculating a required inventory quantity that is a value obtained by apportioning the total inventory quantity to the plurality of stores according to the estimated sales quantity;
Obtaining the inventory quantity of the product for each of the plurality of stores, calculating a difference obtained by subtracting the inventory quantity from the necessary inventory quantity for each of the plurality of stores, and reducing the difference of the source of the product A movement instruction generation means for generating movement instruction information indicating a store, a movement destination store of the commodity, and a movement quantity of the commodity;
An inventory management device is provided.

  It should be noted that any combination of the above-described constituent elements and a conversion of the expression of the present invention between a method, an apparatus, a system, a recording medium, a computer program, etc. are also effective as an aspect of the present invention.

  According to the present invention, the movement instruction information indicating the store from which the product is moved, the store from which the product is moved, and the movement quantity of the product so as to reduce the difference obtained by subtracting the inventory quantity from the necessary stock quantity. Is generated. Therefore, by moving the products according to the movement instruction information, it is possible to reduce the uneven inventory of the products among a plurality of stores.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. In all the drawings, the same reference numerals are given to the same components, and the description will be omitted as appropriate.

  FIG. 1 is a block diagram illustrating a functional configuration of the inventory management apparatus according to the present embodiment. The inventory management apparatus includes a total inventory quantity acquisition unit (total inventory quantity acquisition unit) 220, an estimated sales quantity acquisition unit 240, a necessary inventory quantity calculation unit (necessary inventory quantity calculation unit) 250, and a movement instruction generation unit 260. The total inventory quantity acquisition unit 220 acquires a total inventory quantity that is a total value of the inventory quantities of products in a plurality of stores. The expected sales number acquisition unit 240 acquires the expected sales number of products for each of a plurality of stores in a predetermined period (for example, one week). The required inventory quantity calculation unit 250 calculates the required inventory quantity, which is a value obtained by dividing the total inventory quantity among a plurality of stores according to the estimated number of sales, for each store. The movement instruction generation unit 260 acquires the inventory quantity of the product for each of a plurality of stores, calculates the difference obtained by subtracting the inventory quantity from the necessary inventory quantity for each of the stores, and the product so that the difference, that is, the partial inventory is reduced. Movement instruction information indicating the movement source store, the movement destination store of the commodity, and the movement quantity of the commodity is generated. Therefore, by moving the products according to the movement instruction information, it is possible to reduce the uneven inventory of the products among a plurality of stores. Stores include wholesale stores as well as stores that sell products to consumers. In addition to products sold in units of products, products sold in units of physical quantities (such as weight and volume) are also included. Hereinafter, the inventory management apparatus will be described in detail. In this description, it is assumed that the products are sold in units. However, it goes without saying that it can be applied to products sold in physical quantity units as they are.

  1 further includes an input unit 100, an all-store sales history storage unit 110, an execution determination unit 120 (first execution determination unit and second execution determination unit), and a store-specific sales history storage unit 140. , A sales information storage unit 150, an estimated sales number storage unit 160, an estimated sales number calculation unit 170, a movement instruction storage unit 180, and a display unit 280.

  The input unit 100 acquires information input from an operator of the inventory management apparatus. The information to be input is, for example, the product number of a product for which movement instruction information is to be generated, and parameters used to generate movement instruction information. The all-store sales history storage unit 110 stores a total sales history obtained by summing up the sales histories of a plurality of stores. Based on the total sales history stored in the all-store sales history storage unit 110, the execution determination unit 120 determines whether or not the product corresponding to the input product number is to be generated as the movement instruction information.

  The store-specific sales history storage unit 140 stores store-specific sales history data and the number of stocks. The sale information storage unit 150 stores information indicating stores (hereinafter referred to as “sales stores”) where sales are performed for each product. The expected sales number storage unit 160 stores the expected sales number for each product in a predetermined period for each store. The expected sales number calculation unit 170 uses the sales history data for each store to calculate the expected sales number for each store and for each product, and stores it in the expected sales number storage unit 160. The expected sales number calculation unit 170 calculates the expected sales number by, for example, averaging the latest sales numbers for several weeks for each store and each product. The estimated sales number calculation unit 170 performs the above-described processing periodically (for example, every day or every predetermined day of the week). The expected sales number storage unit 160 may store the value input from the input unit 100 as the expected sales number.

  The movement instruction storage unit 180 stores the movement instruction information generated by the movement instruction generation unit 260. The display unit 280 displays the movement instruction information generated by the movement instruction generation unit 260 and allows the operator of the inventory management apparatus to recognize it.

  Although not shown, the inventory management apparatus may include a store information storage unit that stores a store name and a store ID in association with each store. In this case, each functional unit of the inventory management apparatus can refer to the store name or the store ID stored in the store information storage unit as necessary.

  FIG. 2 is a diagram showing the configuration of data stored in the all-store sales history storage unit 110 in a table format. The all-store sales history storage unit 110 stores the total inventory number, the average inventory days, and the total sales history for each product number. The total inventory quantity is a value obtained by totaling the inventory quantity for each store. The average inventory days is a value obtained by averaging the inventory days for each store in all stores. The total sales history includes data indicating the total number of sales of all stores by sales date.

  FIG. 3 is a diagram showing the configuration of data stored in the store-specific sales history storage unit 140 in a table format. The sales history storage unit 140 for each store stores regional information and sales history for each store ID that mutually identifies stores. The area information indicates the area to which the store belongs. The sales history includes data showing a list of the number of sales by product number, the number of stocks by product number, and the number of stock days by product number in the latest period (for example, the latest one week). The sales history includes data indicating the number of inventory, the number of inventory days, and the number of sales for each sales date by product number.

  FIG. 4 is a diagram showing the data structure of the sale information stored in the sale information storage unit 150 in a table format. The sale information storage unit 150 stores information indicating the store ID of the sale store and the first day and the last date of the sale at the sale store for each product number.

  FIG. 5 is a diagram showing the configuration of data stored in the estimated sales number storage unit 160 in a table format. The estimated sales number storage unit 160 corresponds to the store ID, the information indicating the area to which the store indicated by the store ID belongs, and the estimated sales number for a predetermined period (for example, one week) in the store indicated by the store ID, for each product number. I remember it.

  FIG. 6 is a diagram illustrating a configuration of data stored in the movement instruction storage unit 180 in a table format. The movement instruction storage unit 180 stores movement instruction information for each product number and each creation date. The movement instruction information includes a store ID of a source store that is a store from which the product is moved, a store ID of a destination store that is a store to which the product is moved, and the number of moves.

  FIG. 7 is a flowchart for explaining the movement instruction information generation process performed by the inventory management apparatus. First, the operator of the inventory management apparatus inputs the product number of the product that is the target of the movement instruction to the input unit 100 (S10). The execution determination unit 120 of the inventory management apparatus performs a process of examining the sales of the product indicated by the input product number, and determines whether or not to cause the inventory management apparatus to execute the process based on the processing result (S20).

  Specifically, the execution determination unit 120 reads the average inventory days and the total sales history corresponding to the input product number from the all-store sales history storage unit 110. The execution determination unit 120 processes the read total sales history, and the total sales number of the latest period (for example, the latest one week) becomes the total sales number of the previous period (for example, the previous week). On the other hand, it is confirmed whether or not the ratio is equal to or less than a predetermined ratio. When the ratio is equal to or less than the predetermined ratio, it indicates that the product has not been sold rapidly. Therefore, the execution determination unit 120 stops the process performed by the inventory management apparatus.

  Further, the execution determination unit 120 processes the read total sales history, and calculates the average sales number that is a value obtained by dividing the total value of the sales number in the latest period (for example, the latest one week) by the number of stores. The execution determination unit 120 stores the number of stores used here in advance. Then, the execution determination unit 120 confirms whether or not the read average inventory days are equal to or greater than the predetermined number of days and the calculated average sales number is equal to or less than the predetermined number. When the average number of days in stock is greater than or equal to the predetermined number of days and the average number of sales is less than or equal to the predetermined number, it indicates that the product is almost unsold.

  Even if the product unbalanced inventory is eliminated when the product suddenly stops selling or when the product hardly sells, the stock of the product does not decrease. When the inventory of goods does not decrease, the distribution cost required for the return of goods is substantially constant regardless of whether there is a partial inventory. On the other hand, the distribution cost necessary to eliminate the unbalanced inventory is wasted. The processing performed by the execution determination unit 120 can suppress such waste of physical distribution costs.

  The execution determining unit 120 outputs the input product number to the total inventory number acquiring unit 220, the expected sales number acquiring unit 240, and the movement instruction generating unit 260 when causing the inventory management apparatus to execute processing. In addition, the execution determination unit 120 outputs the calculated average number of sales to the movement instruction generation unit 260.

  When the product number is input from the execution determination unit 120, the movement instruction generation unit 260 causes the display unit 280 to display a message prompting the operator of the inventory management apparatus to register various parameters. The operator inputs various parameters to the input unit 100 according to the display on the display unit 280. The input unit 100 outputs the input parameters to the expected sales number acquisition unit 240 and the movement instruction generation unit 260 (S30). The parameters input here include, for example, an increase rate of the expected number of sales at a sale store, a store ID (or store name) of a store to be processed, or information for specifying a region.

  Next, the predicted sales number acquisition unit 240 reads the predicted sales number corresponding to the product number input from the execution determination unit 120 from the predicted sales number storage unit 160 for each of the plurality of store IDs. Then, the estimated sales number acquisition unit 240 calculates the estimated sales numbers of a plurality of stores for each predetermined period by processing the read estimated sales numbers (S40). Details of this processing will be described later using a flowchart. Then, the estimated sales number acquisition unit 240 associates the calculated estimated sales number with the store ID and outputs it to the necessary inventory number calculation unit 250.

  The total inventory quantity acquisition unit 220 reads the total inventory quantity corresponding to the product number input from the execution determination unit 120 from the all-store sales history storage unit 110 and outputs the total inventory quantity to the necessary inventory quantity calculation unit 250 (S50). Next, the required inventory quantity calculation unit 250 calculates the required inventory quantity, which is a value obtained by apportioning the total inventory quantity for each of the plurality of stores by the estimated sales quantity, for each store (S55). Next, the necessary inventory number calculation unit 250 outputs the store ID, the necessary inventory number and the estimated sales number for each store, to the movement instruction generation unit 260 in association with each other.

  Next, the movement instruction generation unit 260 selects a region, and selects a store that belongs to the set region among a plurality of stores indicated by the store ID input from the necessary inventory quantity calculation unit 250 (S60). Next, the movement instruction generation unit 260 performs the processes shown in S65 to S90 below on the selected store.

  First, the movement instruction generation unit 260 sets the number of movement instruction information to be generated (S65). Details of this processing will be described later using a flowchart.

  Next, the movement instruction generation unit 260 sets a movement source candidate store that is a store that should be the movement source of the product and a movement destination candidate store that is a store that should be the movement destination of the product (S70). Details of this processing will be described later using a flowchart.

  Next, the movement instruction generation unit 260 generates movement instruction information (S80). Details of this processing will be described later.

  Next, the movement instruction generation unit 260 stores the generated movement instruction information in the movement instruction storage unit 180 and displays the generated movement instruction information on the display unit 280 (S90).

  The movement instruction generation unit 260 performs the processing shown in S65 to S90 for all regions (S95).

  FIG. 8 is a flowchart for explaining the details of S40 of FIG. First, the expected sales number acquisition unit 240 reads the expected sales number for each store corresponding to the product number input from the execution determination unit 120 and stored in the expected sales number storage unit 160 (S100). Here, when the information for specifying the store ID or the region is input from the input unit 100, the estimated sales number acquiring unit 240 sets the store ID corresponding to the input store ID or the information specifying the input region. This is recognized as the store ID of the store to be processed.

  Next, the expected sales number acquisition unit 240 calculates the average expected sales number by averaging the expected sales numbers for a plurality of stores (S110). Next, the expected sales number acquisition unit 240 selects stores having an estimated sales number greater than the average expected sales number (S120), and calculates the difference between the predicted sales number and the average expected sales number for each selected store (S130). . Next, the expected sales number acquisition unit 240 compresses the expected sales number at the store selected in S120 by multiplying the calculated difference by a compression ratio that is less than 1 to reduce the difference from the average expected sales number ( S140). The expected sales number acquisition unit 240 determines the compression rate using, for example, the average inventory days and the average expected sales number stored in the all-store sales history storage unit 110. The compression ratio decreases as the average inventory days of the product increases, and decreases as the standard deviation of the expected sales number with respect to the average expected sales number increases. By compressing the expected number of sales, it is possible to prevent the product from being concentrated too much in a specific store where the expected number of sales is particularly large.

  The expected sales number acquisition unit 240 reads the sale information corresponding to the product number input from the execution determination unit 120 from the sale information storage unit 150 (S150). Next, the expected sales number acquisition unit 240 selects a store whose store information includes the store ID, and multiplies the estimated sales number of the selected store by the increase rate input from the input unit 100, thereby predicting the selected store. The number of sales is corrected (S160). Thereby, the number of goods received in a sale store can be increased. Therefore, it is possible to prevent the product from remaining unsold at other stores despite the shortage of products at the sale store. The expected sales number acquisition unit 240 may store the increase rate by default and use this increase rate when the increase rate is not input from the input unit 100.

  FIG. 9 is a flowchart for explaining the details of S65 of FIG. First, the movement instruction generation unit 260 uses the product number input from the execution determination unit 120 to read the latest sales number of products for each store from the store sales history storage unit 140 (S305). Next, the movement instruction generation unit 260 determines whether the average number of sales input from the execution determination unit 120 is greater than or equal to a reference value (S310). When it is equal to or greater than the reference value (S310: Yes), the movement instruction generation unit 260 sets the number of stores whose sales number in the latest predetermined period is equal to or more than the average sales number as the number of movement instruction information (S320). When it is less than the reference value (S310: No), the movement instruction generation unit 260 sets the number of stores whose sales number in the latest predetermined period is equal to or more than the reference value in S310 as the number of movement instruction information (S330). ).

  FIG. 10 is a flowchart illustrating a first detailed example of S70 of FIG. First, the movement instruction generation unit 260 reads the number of stocks for each store from the sales history storage unit 140 for each store. Then, the difference obtained by subtracting the inventory quantity from the necessary inventory quantity input from the necessary inventory quantity calculation unit 250 is calculated for each store (S400). Next, the movement instruction generation unit 260 deletes stores whose absolute value of the calculated difference is less than the reference value from the stores to be processed (S410). As a result, it is possible to suppress an increase in physical distribution costs due to a large number of small lot movements.

  Next, the movement instruction generation unit 260 sets a store having a positive difference as a destination candidate store, and sets a store having a negative difference as a source candidate store (S420). Next, the movement instruction generation unit 260 reads the sale information of the target product from the sale information storage unit 150 (S430), and deletes the store whose store ID is included in the sale information from the source candidate store (S440). ). Accordingly, it is possible to prevent the product from being moved from the sale store to another store and the product remaining unsold at the other store even though the product is insufficient at the sale store.

  Next, the movement instruction generation unit 260 reads past movement instruction information including the product number input from the execution determination unit 120 from the movement instruction storage unit 180 (S450). Then, the movement instruction generation unit 260 deletes the store that is the movement destination store in the read movement instruction information from the movement source candidate stores (S460). Thereby, it is possible to suppress the waste of physical distribution costs that the product is picked up from the store where the product has been moved in the past.

  FIG. 11 is a flowchart illustrating a second detailed example of S70 of FIG. In the processing shown in this figure, the same steps as those in FIG.

  First, the movement instruction generation unit 260 performs the processing shown in S400 and S410 of FIG. Next, the movement instruction generation unit 260 gives each store a first ranking in ascending order of difference calculated in S400 (S421). Next, the movement instruction generation unit 260 reads the number of stocks of each store from the sales history storage unit 140 for each store, and gives the second order in ascending order of the read stock number (S422). Next, the movement instruction generation unit 260 assigns the third rank in the order of the smallest expected sales number (S423).

  Next, the movement instruction generation unit 260 calculates points for each store by multiplying each of the first to third ranks after multiplying by different weighting coefficients (S424). Then, the movement instruction generation unit 260 corrects the points by adding the points based on the latest sales history for each store (S425). The points added here are smaller, for example, as the most recent sales number is larger.

  Next, the movement instruction generation unit 260 sets a movement destination candidate store by selecting a predetermined number of stores in descending order of points, and selects a movement source candidate store by selecting a predetermined number of stores in ascending order of points. (S426). Thereafter, the movement instruction generation unit 260 performs the processing shown in S430 to S460 of FIG.

  FIG. 12 is a flowchart for explaining the details of S80 of FIG. First, the movement instruction generation unit 260 selects a store having the largest absolute value of the difference calculated in S410 of FIG. 10 from each of the movement destination candidate stores and the movement source candidate stores that are not yet the targets of the movement instruction (S500). . Next, when the difference between the two selected stores is equal to each other (S510: Yes), the movement instruction generating unit 260 is configured so that the two selected stores are the destination store and the source store, and the difference is the number of movements. The movement instruction information is generated (S560).

  Further, when the difference between the two selected stores is different (S510: No), the movement instruction generating unit 260 calculates and stores an error that is the difference between the two differences (S520). Then, the movement instruction generating unit 260 adds the movement destination candidate store or the movement source candidate store and adds the difference (S530).

  Specifically, when the movement destination candidate store has a smaller absolute value of the difference than the movement source candidate store, the movement instruction generation unit 260 additionally selects a store having the next largest absolute value of the difference among the movement destination candidate stores. . Next, the movement instruction generation unit 260 adds the difference corresponding to the additionally selected store to the difference of the movement destination candidate stores selected in advance.

  In addition, when the movement source candidate store has a smaller absolute value of the difference than the movement destination candidate store, the movement instruction generation unit 260 additionally selects a store having the next largest absolute value of the difference among the movement source candidate stores. Next, the movement instruction generation unit 260 adds the difference corresponding to the additionally selected store to the difference of the movement source candidate stores selected in advance.

  When the absolute value of the difference between the movement destination candidate stores and the magnitude relationship between the absolute values of the differences between the movement source candidate stores are not reversed (S540: No), the movement instruction generation unit 260 returns to S520 and returns the two differences. An error that is the difference between the two is calculated and stored. Then, the processes shown in S530 and S540 are performed again.

  In addition, when the magnitude relationship between the absolute value of the difference of the destination candidate store and the absolute value of the difference of the source candidate store is reversed (S540: Yes), the movement instruction generation unit 260 An error, which is a difference, is calculated and stored (S545). Then, the movement instruction generation unit 260 selects a combination of candidate stores with the smallest error (S550), and generates movement instruction information using this combination (S560).

  Specifically, the source store and the destination store are set according to the combination of the selected candidate stores. One movement instruction information includes one movement source store and one movement destination store. For this reason, the movement instruction generation unit 260 may generate a plurality of movement instruction information having the same movement source store or movement destination store in one process. The number of movements at this time is a smaller value of the absolute value of the difference of the destination store and the absolute value of the difference of the source store. Note that in the movement instruction information including the destination store or the movement source store selected last, the number of movement instructions is the remaining number of products to be moved. When the movement instruction generating unit 260 generates one piece of movement instruction information in a single process, the number of movements of this movement instruction information is the absolute value of the difference of the movement destination store or the absolute value of the difference of the movement source store. .

  The movement instruction generation unit 260 repeats the processing from S500 to S560 described above until the total number of generated movement instruction information is equal to or greater than the number determined in S65 of FIG. 7 (S565: Yes).

  Next, the movement instruction generation unit 260 performs a process of correcting the movement number of the movement instruction information (S570).

  FIG. 13 is a flowchart illustrating the details of S570 in FIG. First, the movement instruction generation unit 260 selects movement instruction information whose movement number is equal to or more than a reference multiple of the expected sales number within a predetermined period of the movement destination store (S700). Next, the movement instruction generation unit 260 corrects the number of movements in the selected movement instruction information to a reference multiple of the expected number of sales within a predetermined period of the movement destination store (S710). This reduces the number of movements in the selected movement instruction information. For this reason, it is possible to suppress the occurrence of unsold goods due to the concentration of more than necessary products at the destination store.

  Next, the movement instruction generation unit 260 apportions the movement number corresponding to the decrease in the selected movement instruction information to other movement instruction information (S720). This prorated process is performed according to the number of movements in the other movement instruction information.

  Next, the processing of the movement instruction generation unit 260 described with reference to FIG. 12 will be specifically described with reference to FIGS. In this example, the movement instruction generation unit 260 needs to set five pieces of movement instruction information. In addition, there are five candidate stores and five candidate stores. In each drawing, (a) shows, in a table format, information indicating that the number of movement source candidate stores is an excess number (difference) and whether or not the movement instruction information has been set. Further, (b) shows, in a table format, the number of deficiencies (difference) and information (denoted as completed) indicating whether or not the destination is the target of movement instruction information for each candidate store. (C) shows the movement instruction information in a table format.

  First, as illustrated in FIG. 14, the movement instruction generation unit 260 selects A as the movement source candidate store and selects E as the movement destination candidate store. These differences, that is, the excess number and the deficiency number are both “20”. For this reason, the movement instruction generation unit 260 generates movement instruction information in which the movement source store is A, the movement destination store is E, and the movement number is “20”.

  Next, as illustrated in FIG. 15, the movement instruction generation unit 260 selects B as the movement source candidate shop and selects F as the movement destination candidate shop. The excess number of stores B is “15”, and the shortage number of stores F is “13”, which are different from each other. At this time, the movement instruction generation unit 260 stores an error “2” that is a difference between them. Then, the movement instruction generation unit 260 selects the next destination candidate store G, and calculates the total value “22” of the shortage numbers of the stores G and F. Thereby, since the magnitude relationship between the excess number and the deficiency number is reversed, the addition process of the destination candidate store is terminated. Then, an error “7”, which is the difference between the excess number and the deficiency number at this stage, is calculated and stored. In this state, the movement instruction generation unit 260 stores two errors, but since the error before adding the destination candidate store is smaller, the movement instruction generation unit 260 moves according to the combination of the stores before adding the destination candidate store. Generate instruction information. The movement source store at this time is B, the movement destination store is F, and the number of movements is “15”. The number of movements may be “13”.

  Next, as illustrated in FIG. 16, the movement instruction generation unit 260 selects C as the movement source candidate shop and selects G as the movement destination candidate shop. The excess number of the store C is “12” and the shortage number of the store G is “9”, which are different from each other. At this time, the movement instruction generation unit 260 stores an error “3” that is a difference between them. Then, the movement instruction generation unit 260 selects H as the next destination candidate store, and calculates a total value “11” of the shortage numbers of the stores H and G. At this stage, since the magnitude relationship between the excess number and the deficiency number is not reversed, the movement instruction generation unit 260 stores an error “1” that is the difference between them. Then, the movement instruction generation unit 260 selects the next destination candidate store I, and calculates the total value “13” of the shortage numbers of the stores H, G, and I. Thereby, since the magnitude relationship between the excess number and the deficiency number is reversed, the addition process of the destination candidate store is terminated. Then, an error “1”, which is the difference between the excess number and the deficiency number at this stage, is calculated and stored. In this state, the movement instruction generation unit 260 stores three errors, but since the error after adding the destination candidate store G or G and H is smaller than the error before adding these, The movement instruction information is generated according to the combination of the stores after adding the destination candidate stores. In the example of this figure, the movement instruction generation unit 260 generates two pieces of movement instruction information. In these movement instruction information, the movement source store is C and the movement destination store is G or H. The movement numbers are “9” and “3”.

  Next, as illustrated in FIG. 17, the movement instruction generation unit 260 selects D as the movement source candidate shop and selects I as the movement destination candidate shop. The excessive number of stores D is “4” and the shortage number of stores I is “2”, which are different from each other. At this time, since there is no next destination candidate store, movement instruction information in which the source store is D and the destination store is I is generated. The number of movements may be either “4” or “2”, but is 2 in the example of this figure.

  Each component of the inventory management apparatus described above includes a CPU, a memory of any computer, a program for realizing the components of the figure loaded in the memory, a storage unit such as a hard disk for storing the program, and a network connection It is realized by any combination of hardware and software centering on the interface. It will be understood by those skilled in the art that there are various modifications to the implementation method and apparatus.

  As described above, according to the present embodiment, the necessary inventory quantity calculation unit 250 calculates the necessary inventory quantity by apportioning the total inventory quantity to each of a plurality of stores according to the estimated sales quantity. The movement instruction generation unit 260 calculates the difference obtained by subtracting the inventory quantity from the necessary inventory quantity for each of the plurality of stores, and the merchandise movement source store, the merchandise movement destination store, and the merchandise movement destination so that the difference becomes smaller. Movement instruction information indicating the number of movements is generated. Therefore, by moving the products according to the movement instruction information, it is possible to reduce the uneven inventory of the products among a plurality of stores.

  In addition, the movement instruction generation unit 260 performs movement instruction information generation processing for each region. For this reason, a movement origin store former movement destination store belongs to the same area. Therefore, it is possible to suppress an increase in physical distribution costs when eliminating the uneven inventory.

  In addition, the execution determination unit 120 performs a process of examining the sales of the product indicated by the input product number, and determines whether or not to cause the inventory management apparatus to execute the process based on the processing result. Even if the product's unbalanced inventory is eliminated when the product suddenly stops selling or when the product becomes almost unsold, the inventory of the product does not decrease, so the logistics costs necessary to eliminate the unbalanced inventory are wasted. Become. The processing performed by the execution determination unit 120 can suppress such waste of physical distribution costs.

  Further, the expected sales number acquisition unit 240 increases the expected sales number at the sale store. Thereby, the number of goods received in a sale store can be increased. Therefore, it is possible to prevent the product from remaining unsold at other stores despite the shortage of products at the sale store.

  In addition, the movement instruction generation unit 260 deletes the sale store from the movement source candidate store. Accordingly, it is possible to prevent the product from being moved from the sale store to another store and the product remaining unsold at the other store even though the product is insufficient at the sale store.

  In addition, the movement instruction generation unit 260 deletes stores whose difference between the required inventory quantity and the inventory quantity is less than the reference value from the shops to be processed. As a result, it is possible to suppress an increase in physical distribution costs due to a large number of small lot movements.

  In addition, the movement instruction generation unit 260 deletes the store that is the movement destination store in the past movement instruction information from the movement source candidate stores. Thereby, it is possible to suppress the waste of physical distribution costs that the product is picked up from the store where the product has been moved in the past.

  In addition, the expected sales number acquisition unit 240 compresses the expected sales number for a store whose expected sales number is larger than the average expected sales number. For this reason, it can suppress that a product concentrates too much on the specific store where the expected number of sales was especially large.

  Further, when the number of movements is equal to or more than the reference sales number within the predetermined period of the destination store, the number of movements is corrected to a reference number of the expected sales number within the predetermined period of the destination store. As a result, it is possible to suppress the occurrence of unsold goods due to the concentration of more than necessary products at the destination store.

As mentioned above, although embodiment was described with reference to drawings, these are illustrations of this invention and various structures other than the above are also employable.
(Appendix 1)
A total inventory quantity acquisition means for acquiring a total inventory quantity that is a total value of the inventory quantities of products in a plurality of stores;
An expected sales quantity acquisition means for acquiring an expected sales quantity of the product for each of the plurality of stores in a predetermined period;
Necessary inventory quantity calculating means for calculating a required inventory quantity that is a value obtained by apportioning the total inventory quantity to the plurality of stores according to the estimated sales quantity;
Obtaining the inventory quantity of the product for each of the plurality of stores, calculating a difference obtained by subtracting the inventory quantity from the required inventory quantity for each of the plurality of stores, and reducing the difference, A movement instruction generation means for generating movement instruction information indicating a store, a movement destination store of the commodity, and a movement quantity of the commodity;
An inventory management device comprising:
(Appendix 2)
In the inventory management apparatus according to attachment 1,
The movement instruction generation means includes
The difference is divided into a transfer source candidate store that is a store that can be negative and can be the source of the product, and a transfer destination candidate store that is the store that can be a destination of the product and the difference is positive. In order from the larger absolute value of the above, by selecting one or more each of the source candidate store and the destination candidate store, the source store and the destination store are determined,
When selecting the source store and the destination store, the difference between the absolute value of the difference sum of the source candidate stores and the absolute value of the difference sum of the destination candidate stores is the largest. Inventory management device to make it smaller.
(Appendix 3)
In the inventory management apparatus according to attachment 1,
The movement instruction generation means includes
The first order is assigned to the plurality of stores in ascending order of the difference, the second order is assigned to the plurality of stores in the order of the small inventory quantity, and the third order is assigned in the order of the expected sales quantity being small. And calculating points by multiplying each of the first to third ranks by multiplying by a weighting coefficient,
Select the candidate store that is the store that can be the source of the product in the order that the point is large, and select the candidate store that is the store that can be the destination of the product in the order that the point is small,
An inventory management apparatus that determines the source store and the destination store by selecting one or more destination candidate stores and one or more destination candidate stores, respectively.
(Appendix 4)
In the inventory management device according to any one of appendices 1 to 3,
Further comprising area information storage means for storing area information indicating an area where each of the plurality of stores is located;
The inventory management device that generates the movement instruction information so that the store from which the product is moved and the store to which the product is moved are in the same region based on the region information.
(Appendix 5)
In the inventory management apparatus according to any one of appendices 1 to 4,
The inventory management device does not generate the movement instruction information when the sales quantity of the product in all stores in the latest period is equal to or less than a predetermined ratio with respect to the sales quantity of the product in the period immediately before the latest period. An inventory management apparatus further comprising first execution determination means for making it.
(Appendix 6)
In the inventory management device according to any one of appendices 1 to 5,
When the average sales quantity of the product in the plurality of stores in the latest period is equal to or less than a predetermined quantity and the average inventory days of the product in the plurality of stores is greater than or equal to a predetermined number of days, the inventory management device displays the movement instruction information. An inventory management apparatus further comprising second execution determination means for preventing generation.
(Appendix 7)
In the inventory management apparatus according to any one of appendices 1 to 6,
The expected sales quantity acquisition means acquires sale information indicating which of the plurality of stores conducts the sale of the product, and the sale information indicates that the sale of the product is performed in the store. Inventory management device that performs processing to increase the expected sales volume.
(Appendix 8)
In the inventory management device according to any one of appendices 1 to 7,
The movement instruction generation means acquires sale information indicating which of the plurality of stores conducts the sale of the product, and sets the store indicating that the sale information performs the sale of the product. An inventory management device that is not in the store of the move source.
(Appendix 9)
In the inventory management apparatus according to any one of appendices 1 to 8,
The said movement instruction production | generation means is an inventory management apparatus which excludes the said shop where the absolute value of the said difference is below a predetermined quantity from the object of the said movement instruction information.
(Appendix 10)
In the inventory management apparatus according to any one of appendices 1 to 9,
A movement instruction storage means for storing the movement instruction information relating to the product generated in the past by the movement instruction generation means;
The movement instruction generating means sets the store indicating that the movement instruction information stored in the movement instruction storage means is a movement destination store as the movement source store in the new movement instruction information. Inventory management device not selected.
(Appendix 11)
In the inventory management apparatus according to any one of appendices 1 to 10,
The expected sales volume acquisition means calculates an average value of the expected sales volume of the plurality of stores, corrects the expected sales volume by reducing the expected sales volume larger than the average value,
The required inventory quantity calculation means is an inventory management apparatus that calculates the required inventory quantity using the corrected expected sales quantity.
(Appendix 12)
In the inventory management apparatus according to any one of appendices 1 to 11,
When the movement quantity of the product indicated by the movement instruction information is more than a predetermined multiple of the expected sales quantity at the store that is the movement destination in the movement instruction information, the movement instruction generation means The transfer quantity of the product is corrected to the predetermined multiple of the expected sales quantity, and the difference in the transfer quantity of the product before and after the correction is distributed to the transfer quantity of the product in one or more other transfer instruction information Inventory management device.
(Appendix 13)
A computer acquiring a total inventory quantity that is a total value of inventory quantities of products in a plurality of stores, and an estimated sales quantity of the products for each of the plurality of stores in a predetermined period;
A computer calculating a required inventory quantity, which is a value obtained by dividing the total inventory quantity into the plurality of stores according to the estimated sales quantity, for each of the stores;
The computer obtains the inventory quantity of the product for each of the plurality of stores, calculates a difference obtained by subtracting the inventory quantity from the required inventory quantity for each of the plurality of stores, and reduces the difference so that the difference of the product is reduced. Generating movement instruction information indicating a movement source store, a movement destination store of the commodity, and a movement quantity of the commodity;
An inventory management method comprising:
(Appendix 14)
A program for causing a computer to function as an inventory management device,
In the computer,
A function of obtaining a total inventory quantity that is a total value of inventory quantities of products in a plurality of stores, and an expected sales quantity of the products for each of the plurality of stores in a predetermined period;
A function for calculating a necessary inventory quantity, which is a value obtained by apportioning the total inventory quantity to the plurality of stores according to the estimated sales quantity, for each of the stores;
Obtaining the inventory quantity of the product for each of the plurality of stores, calculating a difference obtained by subtracting the inventory quantity from the required inventory quantity for each of the plurality of stores, and reducing the difference, A function of generating movement instruction information indicating a store, a store to which the product is moved, and a movement quantity of the product;
A program that realizes

It is a block diagram which shows the structure of the inventory management apparatus in embodiment. It is a figure which shows the structure of the data which all the store sales log | history memory | storage parts 110 have memorize | stored in a table format. It is a figure which shows the structure of the data which the sales log | history memory | storage part 140 classified by store has memorize | stored in the table format. It is a figure which shows the data structure of the sale information which the sale information storage part 150 has memorize | stored in a table format. It is a figure which shows the structure of the data which the estimated sales number memory | storage part 160 has memorize | stored in a table format. It is a figure which shows the structure of the data which the movement instruction | command storage part 180 has memorize | stored in a table format. It is a flowchart for demonstrating the production | generation process of the movement instruction information which an inventory management apparatus performs. It is a flowchart explaining the detail of S40 of FIG. It is a flowchart explaining the detail of S65 of FIG. It is a flowchart explaining the 1st detailed example of S70 of FIG. It is a flowchart explaining the 2nd detailed example of S70 of FIG. It is a flowchart explaining the detail of S80 of FIG. 13 is a flowchart for explaining details of S570 in FIG. FIG. 13 is a table diagram specifically explaining processing of a movement instruction generation unit 260 described with reference to FIG. 12. FIG. 13 is a table diagram specifically explaining processing of a movement instruction generation unit 260 described with reference to FIG. 12. FIG. 13 is a table diagram specifically explaining processing of a movement instruction generation unit 260 described with reference to FIG. 12. FIG. 13 is a table diagram specifically explaining processing of a movement instruction generation unit 260 described with reference to FIG. 12.

Explanation of symbols

100 Input Unit 110 All-Store Sales History Storage Unit 120 Execution Determination Unit 140 Store-Based Sales History Storage Unit 150 Sale Information Storage Unit 160 Expected Sales Number Storage Unit 170 Expected Sales Number Calculation Unit 180 Movement Instruction Storage Unit 220 Total Inventory Quantity Acquisition Unit 240 Expected sales number acquisition unit 250 Necessary inventory number calculation unit 260 Movement instruction generation unit 280 Display unit

Claims (12)

A total inventory quantity acquisition means for acquiring a total inventory quantity that is a total value of the inventory quantities of products in a plurality of stores;
An expected sales quantity acquisition means for acquiring an expected sales quantity of the product for each of the plurality of stores in a predetermined period;
Necessary inventory quantity calculating means for calculating a required inventory quantity that is a value obtained by apportioning the total inventory quantity to the plurality of stores according to the estimated sales quantity;
Obtaining the inventory quantity of the product for each of the plurality of stores, calculating a difference obtained by subtracting the inventory quantity from the required inventory quantity for each of the plurality of stores, and reducing the difference, A movement instruction generation means for generating movement instruction information indicating a store, a movement destination store of the commodity, and a movement quantity of the commodity;
With
The movement instruction generation means includes
The first order is assigned to the plurality of stores in ascending order of the difference, the second order is assigned to the plurality of stores in the order of the small inventory quantity, and the third order is assigned in the order of the expected sales quantity being small. And calculating points by multiplying each of the first to third ranks by multiplying by a weighting coefficient,
Select the candidate store that is the store that can be the source of the product in the order that the point is large, and select the candidate store that is the store that can be the destination of the product in the order that the point is small,
Determining the source store and the destination store by selecting one or more each of the source candidate stores and the destination candidate stores,
An inventory management device. The inventory management apparatus according to claim 1 ,
Further comprising area information storage means for storing area information indicating an area where each of the plurality of stores is located;
The inventory management device that generates the movement instruction information so that the store from which the product is moved and the store to which the product is moved are in the same region based on the region information. In the inventory management apparatus according to claim 1 or 2 ,
The inventory management device does not generate the movement instruction information when the sales quantity of the product in all stores in the latest period is equal to or less than a predetermined ratio with respect to the sales quantity of the product in the period immediately before the latest period. An inventory management apparatus further comprising first execution determination means for making it. In the inventory management apparatus as described in any one of Claims 1-3 ,
When the average sales quantity of the product in the plurality of stores in the latest period is equal to or less than a predetermined quantity and the average inventory days of the product in the plurality of stores is greater than or equal to a predetermined number of days, the inventory management device displays the movement instruction information. An inventory management apparatus further comprising second execution determination means for preventing generation. In the inventory control apparatus as described in any one of Claims 1-4 ,
The expected sales quantity acquisition means acquires sale information indicating which of the plurality of stores conducts the sale of the product, and the sale information indicates that the sale of the product is performed in the store. Inventory management device that performs processing to increase the expected sales volume. In the inventory control apparatus as described in any one of Claims 1-5 ,
The movement instruction generation means acquires sale information indicating which of the plurality of stores conducts the sale of the product, and sets the store indicating that the sale information performs the sale of the product. An inventory management device that is not in the store of the move source. In the inventory control apparatus as described in any one of Claims 1-6 ,
The said movement instruction production | generation means is an inventory management apparatus which excludes the said shop where the absolute value of the said difference is below a predetermined quantity from the object of the said movement instruction information. In inventory control apparatus according to any one of claims 1-7,
A movement instruction storage means for storing the movement instruction information relating to the product generated in the past by the movement instruction generation means;
The movement instruction generating means sets the store indicating that the movement instruction information stored in the movement instruction storage means is a movement destination store as the movement source store in the new movement instruction information. Inventory management device not selected. In the inventory control apparatus as described in any one of Claims 1-8 ,
The expected sales volume acquisition means calculates an average value of the expected sales volume of the plurality of stores, corrects the expected sales volume by reducing the expected sales volume larger than the average value,
The required inventory quantity calculation means is an inventory management apparatus that calculates the required inventory quantity using the corrected expected sales quantity. In inventory control apparatus according to any one of claims 1-9,
When the movement quantity of the product indicated by the movement instruction information is more than a predetermined multiple of the expected sales quantity at the store that is the movement destination in the movement instruction information, the movement instruction generation means The transfer quantity of the product is corrected to the predetermined multiple of the expected sales quantity, and the difference in the transfer quantity of the product before and after the correction is distributed to the transfer quantity of the product in one or more other transfer instruction information Inventory management device. A computer acquiring a total inventory quantity that is a total value of inventory quantities of products in a plurality of stores, and an estimated sales quantity of the products for each of the plurality of stores in a predetermined period;
A computer calculating a required inventory quantity, which is a value obtained by dividing the total inventory quantity into the plurality of stores according to the estimated sales quantity, for each of the stores;
The computer obtains the inventory quantity of the product for each of the plurality of stores, calculates a difference obtained by subtracting the inventory quantity from the required inventory quantity for each of the plurality of stores, and reduces the difference so that the difference of the product is reduced. Generating movement instruction information indicating a movement source store, a movement destination store of the commodity, and a movement quantity of the commodity;
With
In the movement instruction generation step, the computer
The first order is assigned to the plurality of stores in ascending order of the difference, the second order is assigned to the plurality of stores in the order of the small inventory quantity, and the third order is assigned in the order of the expected sales quantity being small. And calculating points by multiplying each of the first to third ranks by multiplying by a weighting coefficient,
Select the candidate store that is the store that can be the source of the product in the order that the point is large, and select the candidate store that is the store that can be the destination of the product in the order that the point is small,
Determining the source store and the destination store by selecting one or more each of the source candidate stores and the destination candidate stores ,
An inventory management method characterized by A program for causing a computer to function as an inventory management device,
In the computer,
A function of obtaining a total inventory quantity that is a total value of inventory quantities of products in a plurality of stores, and an expected sales quantity of the products for each of the plurality of stores in a predetermined period;
A function for calculating a necessary inventory quantity, which is a value obtained by apportioning the total inventory quantity to the plurality of stores according to the estimated sales quantity, for each of the stores;
Obtaining the inventory quantity of the product for each of the plurality of stores, calculating a difference obtained by subtracting the inventory quantity from the required inventory quantity for each of the plurality of stores, and reducing the difference, A function of generating movement instruction information indicating a store, a store to which the product is moved, and a movement quantity of the product;
Realized,
The movement instruction generation function is
The first order is assigned to the plurality of stores in ascending order of the difference, the second order is assigned to the plurality of stores in the order of the small inventory quantity, and the third order is assigned in the order of the expected sales quantity being small. And calculating points by multiplying each of the first to third ranks by multiplying by a weighting coefficient,
Select the candidate store that is the store that can be the source of the product in the order that the point is large, and select the candidate store that is the store that can be the destination of the product in the order that the point is small,
Determining the source store and the destination store by selecting one or more each of the source candidate stores and the destination candidate stores ,
A program characterized by

Images