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

Abstract

<P>PROBLEM TO BE SOLVED: To provide an inventory management device for gathering merchandise inventories together in a specific store. <P>SOLUTION: The inventory management device includes: the amount-of-necessary-inventories calculating means 250 for calculating the amount of necessary inventories being a value obtained by distributing the total amount of necessary inventories in a plurality of stores proportionally into the plurality of stores according to an estimated amount of unit sales of each different store for each of the stores; an inventory-gathering store-selecting means 260 for acquiring the present amount of inventories for each different store, calculating a difference obtained by subtracting the present amount of inventories from the amount of necessary inventories in each different store, and selecting an inventory-gathering store by using the difference; and a transfer instruction-generating means 260 for generating transfer instruction information showing: the inventory-gathering store selected by the inventory-gathering store-selecting means 260 as a store gathering merchandise; and stores which are not selected by the inventory-gathering store selecting means 260 as a merchandise gathering store. <P>COPYRIGHT: (C)2010,JPO&amp;INPIT

Description

  The present invention relates to an inventory management apparatus, an inventory management method, and a program that can aggregate inventory of products in a store where the products are expected to be sold.

  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 the product, it is preferable to collect the stock of the product in a specific store.

  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 for collecting inventory of products in a specific store.

According to the present invention, a total inventory quantity acquisition means for acquiring a total inventory quantity that is a total value of current 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;
The current inventory quantity of the product for each of the plurality of stores is acquired, a difference obtained by subtracting the current inventory quantity from the required inventory quantity is calculated for each of the plurality of shops, and the aggregation destination is obtained from the plurality of stores using the difference. Aggregation destination store selection means for selecting a store,
Movement instruction information indicating the aggregation destination store selected by the aggregation destination store selection unit as a store to which the product is moved, and indicating the store not selected by the aggregation destination store selection unit as a store from which the product is moved Movement instruction generating means for generating;
An inventory management device is provided.

Further, according to the present invention, the information that identifies at least one aggregation destination store that should aggregate the inventory of products in a plurality of stores is acquired, and the aggregation destination that selects the aggregation destination store from the plurality of stores according to the information Store selection means,
Total inventory quantity acquisition means for acquiring a total inventory quantity that is a total value of current inventory quantities of the products in the plurality of stores;
An expected sales volume acquisition means for acquiring an expected sales volume of the product for each of the aggregation destination stores in a predetermined period;
Movement instruction information indicating the aggregation destination store selected by the aggregation destination store selection unit as a store to which the product is moved, and indicating the store not selected by the aggregation destination store selection unit as a store from which the product is moved Movement instruction generating means for generating;
A necessary inventory quantity, which is a value obtained by dividing the total inventory quantity into the aggregation destination stores according to the estimated sales quantity, is calculated for each aggregation destination store, and the inventory quantities of the plurality of stores after movement are the required A movement amount calculating means for calculating a movement amount indicated by each of the movement instruction information so as to be an inventory quantity;
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 inventory of products can be collected in a specific store by moving the products according to the movement instruction information.

  FIG. 1 is a block diagram illustrating a functional configuration of the inventory management apparatus according to the embodiment. This inventory management apparatus includes a total inventory quantity acquisition unit (total inventory quantity acquisition unit 220), an expected sales quantity acquisition part (expected sales quantity acquisition part 240), a required inventory quantity calculation part (necessary inventory quantity calculation part 250), and an aggregation destination. A store selection unit (movement instruction generation unit 260) and a movement instruction generation unit 260 are provided. 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 volume of the product for each of a plurality of stores in a predetermined period. The required inventory quantity calculation unit 250 calculates the required inventory quantity, which is a value obtained by apportioning the total inventory quantity to a plurality of stores according to the estimated sales quantity, for each store. The aggregation destination store selection unit obtains the inventory quantity of products for each store, calculates the difference obtained by subtracting the inventory quantity from the required inventory quantity for each store, and uses the difference to select the aggregation destination store from the plurality of stores. select. The movement instruction generation unit 260 indicates the aggregation destination store selected by the aggregation destination store selection unit as the store to which the product is moved, and indicates the store that has not been selected by the aggregation destination store selection unit as the store from which the product is moved. Generate instruction information. Therefore, by moving the products according to the movement instruction information, it is possible to collect the inventory of the products in stores where the products are expected to be sold.

  The aggregation destination store selection unit acquires information for specifying the aggregation destination store, and selects an aggregation destination store from a plurality of stores according to the information. At this time, the movement instruction generation unit 260 also functions as a movement amount calculation unit, and calculates a necessary inventory quantity, which is a value obtained by apportioning the total inventory quantity to the aggregation destination stores according to the estimated sales quantity, for each aggregation destination store. The amount of movement indicated by each piece of movement instruction information is calculated so that the inventory quantity of the aggregation destination store after movement becomes the necessary inventory quantity. For this reason, by moving the products according to the movement instruction information, it is possible to collect the inventory of the products in stores where the products are expected to be sold.

  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.

  The inventory management apparatus shown in FIG. 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.

  In the input unit 100, the number of stores of the aggregation destination store is input from an operator of the inventory management apparatus. 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 includes 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 stock quantity is a value obtained by summing the current stock 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 in the latest period (for example, the latest one week), the current stock number by product number, and the stock days by product number. The sales history includes data indicating the current number of stocks, the number of stock 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 a first example of movement instruction information generation processing performed by the inventory management apparatus. This figure shows a process when the inventory management apparatus automatically selects an aggregation destination store. First, the operator of the inventory management apparatus inputs the product number of products to be aggregated into 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 products are suddenly stopped selling and when the products are hardly sold, even if the products are collected in a specific store, it is not expected that the inventory of the products will decrease. When the inventory of the product does not decrease, the distribution cost required for the return of the product is substantially constant regardless of whether or not the product is aggregated. On the other hand, the distribution cost necessary for performing the aggregation 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 the number of aggregation destination stores. The operator inputs the number of aggregation destination stores to the input unit 100 according to the display on the display unit 280. The number of aggregation destinations input here is, for example, the number for each region. The input unit 100 outputs the number of input aggregation destination stores to the expected sales number acquisition unit 240 and the movement instruction generation unit 260 (S30). Here, the input unit 100 may be input by the operator with other parameters (for example, the rate of increase in the estimated number of sales at a sale store) or information specifying the region. In this case, the input data is output to the expected sales number acquisition unit 240 and the movement instruction generation unit 260.

  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 S70 to S90 below on the selected store.

  First, the movement instruction generation unit 260 sets a movement source store, which is a store to be a movement source of products, and a collection destination store of products (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 S70 to S90 for all regions (S95). Note that the movement instruction generation unit 260 may perform the processes shown in S70 to S90 only for the area designated by the operator of the inventory management apparatus.

  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 region is input from the input unit 100, the expected sales number acquisition unit 240 uses the store ID corresponding to the information for specifying the input region as the store ID of the store to be processed. Recognize.

  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 a first detailed example of S70 of FIG. First, the movement instruction generation unit 260 reads the current inventory quantity for each store from the sales history storage unit 140 for each store. Then, a difference obtained by subtracting the current 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 selects the stores in descending order of the number of aggregation destination stores input from the input unit 100. Thereby, the aggregation destination store is set. Moreover, the movement instruction generation unit 260 sets all the remaining stores as movement source stores (S410). Next, the movement instruction generation unit 260 reads the sale information of the target product from the sale information storage unit 150 (S420), and adds a store whose store information includes the store ID to the aggregation destination store (S430). . Thereby, it can suppress that goods move from a sale store to another store, and goods run short in a sale store. In this addition process, the store having the smallest difference among the stores set in advance as the aggregation destination store may be changed to the source store.

  FIG. 10 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. 9 are denoted by the same step numbers and description thereof is omitted.

  First, the movement instruction generation unit 260 performs the process shown in S400 of FIG. Next, the movement instruction generation unit 260 gives each store a first ranking in ascending order of difference calculated in S400 (S411). Next, the movement instruction generation unit 260 reads the current inventory quantity of each store from the sales history storage unit 140 for each store, and gives the second order in ascending order of the read inventory quantity (S412). Next, the movement instruction generation unit 260 assigns the third rank in the order from the smallest expected sales number (S413).

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

  Next, the movement instruction generation unit 260 sets the aggregation destination stores by selecting the stores in descending order by the number of aggregation destination stores input from the input unit 100, and sets all the remaining stores as the movement source stores. (S416). Thereafter, the movement instruction generation unit 260 performs the processing shown in S420 and S430 of FIG.

  FIG. 11 is a flowchart for explaining the details of S80 of FIG. First, the movement instruction generation unit 260 recalculates and corrects the necessary inventory quantity by apportioning the total inventory quantity, which is the total value of the current inventory quantity of all stores, to the aggregation destination store according to the expected sales quantity. At this time, the necessary stock quantity of the movement source store becomes 0 (S500). Next, the movement instruction generating unit 260 calculates a difference obtained by subtracting the current inventory quantity from the corrected necessary inventory quantity for each store (S510).

  Next, the movement instruction generation unit 260 selects an aggregation destination store and a movement source store having the largest absolute value of the difference (S520), and generates movement instruction information (S530). In this movement instruction information, the two selected stores are the movement destination store and the movement source store, and the number of movements is the smaller of the absolute value of the difference of the aggregation destination store and the absolute value of the difference of the movement source store. .

  Next, the movement instruction generation unit 260 corrects the difference between the two selected stores (S540). Specifically, the difference of the aggregation destination store is reduced by the number of movements of the generated movement instruction information, and the difference of the movement source store is increased by the number of movements of the generated movement instruction information (that is, approaches 0). .

  The movement instruction generation unit 260 repeats the processing shown in S520 to S540 until the difference between all the movement source stores and the aggregation destination store becomes 0 (S550).

  Next, the process performed by the movement instruction generation unit 260 described in S500 of FIGS. 9 and 11 will be specifically described using the table of FIG. In this example, five stores are selected, and the number of aggregation destination stores is set to two. The current inventory numbers of the stores A, B, C, D, and E are 20, 15, 3, 10, and 2, respectively. In addition, the necessary inventory numbers of the stores A, B, C, D, and E are 5, 25, 1, 18, and 1, respectively.

  First, the movement instruction generation unit 260 sets the first to third ranks for each store, multiplies them by a weighting coefficient, and adds them. In the example shown in the figure, the weighting coefficient of the first rank is 0.2, the weighting coefficient of the second rank is 0.8, and the weighting coefficient of the third rank is 0. For this reason, the third ranking is not shown. The points of the stores A, B, C, D, and E are 2.6, 5, 1.2, 4, and 1.4, respectively. Then, the movement instruction generation unit 260 selects two stores B and D in descending order of points, and sets these two stores B and D as aggregation destination stores.

  Next, the movement instruction generation unit 260 corrects the necessary inventory number so that all the inventory is concentrated in the stores B and D. The total inventory number of all stores is 50, and the ratio of the necessary inventory numbers before correction of stores B and D (that is, the ratio of expected sales numbers) is 25:18. For this reason, the necessary inventory numbers of the corrected stores B and D are 29 and 21, respectively.

  Next, the processing performed by the movement instruction generation unit 260 shown in S510 and subsequent steps in FIG. 11 will be specifically described with reference to the table diagrams of FIGS. In each figure, (a) is the excessive number of products at the source store (the absolute value of the difference), the number of products that have been moved as the target of the movement instruction information, and the products that are not the target of the movement instruction. (Number of remaining). (B) shows the number of goods shortage (absolute value of the difference) at the aggregation destination store, the number of goods that have been moved as the target of the movement instruction information, and the number of goods that are not the target of the movement instruction. ing. (C) shows the generated movement instruction information.

  First, as illustrated in FIG. 13, the movement instruction generation unit 260 selects the aggregation destination store B and the movement source store A having the largest absolute value of the difference from each of the aggregation destination store and the movement source store. Movement instruction information indicating that the commodity is moved to the aggregation destination store B is generated. The excess number (the absolute value of the difference) of the movement source store A is 20, and the shortage number (the absolute value of the difference) of the aggregation destination store B is 14. For this reason, in the movement instruction information generated this time, the movement number is 14, which is the shortage number of the aggregation destination store B. Then, the movement instruction generation unit 260 sets the remaining number, which is the corrected difference, to 6 for the movement source store A and 0 for the aggregation destination store B.

  Next, as illustrated in FIG. 14, the movement instruction generation unit 260 selects the aggregation destination store D and the movement source store A having the largest absolute value of the remaining number, and moves the product from the movement source store A to the aggregation destination store D. The movement instruction information indicating that is generated. The absolute value of the remaining number of the movement source store A is 6, and the absolute value of the remaining number of the aggregation destination store D is 11. For this reason, in the movement instruction information generated this time, the number of movements is 6, which is the remaining number of the movement source store A. Then, the movement instruction generation unit 260 sets the remaining number, which is the corrected difference, to 0 at the movement source store A and to 5 at the aggregation destination store D.

  Next, as illustrated in FIG. 15, the movement instruction generation unit 260 selects the aggregation destination store D and the movement source store C having the largest absolute value of the remaining number, and moves the product from the movement source store C to the aggregation destination store D. The movement instruction information indicating that is generated. In this movement instruction information, the number of movements is 3, which is the remaining number of the movement source store C. Then, the movement instruction generation unit 260 sets the remaining number, which is the corrected difference, to 0 at the movement source store C and 2 at the aggregation destination store D.

  Then, the movement instruction generation unit 260 generates movement instruction information indicating that the product is moved from the movement source store E to the aggregation destination store D. In this movement instruction information, the number of movements is 2. Then, the movement instruction generation unit 260 sets the remaining number, which is the corrected difference, to 0 in each of the movement source store E and the aggregation destination store D. Thereby, since the remaining number of all stores has become 0, the movement instruction generation unit 260 ends the generation process of movement instruction information.

  FIG. 16 is a flowchart for explaining a second example of the movement instruction information generation process performed by the inventory management apparatus. This figure shows the process when the operator of the inventory management apparatus manually selects the aggregation destination store. Hereinafter, processes similar to those in the first example are denoted by the same reference numerals, and description thereof is omitted.

  First, the inventory management apparatus performs the processing shown in S10 and S20 of FIG. Next, the movement instruction generation unit 260 causes the display unit 280 to perform a display that prompts the user to input information (for example, store ID or store name) that identifies the aggregation destination store. The operator of the inventory management apparatus inputs information for specifying the aggregation destination store to the input unit 100 according to the display on the display unit 280 (S32). The input information is output from the input unit 100 to the expected sales number acquisition unit 240 and the movement instruction generation unit 260.

  Next, the expected sales number acquisition unit 240 reads the expected sales number of the store corresponding to the information input from the input unit 100 from the expected sales number storage unit 160, and processes the read expected sales number, so that the predetermined sales period is obtained. The expected number of sales is calculated for each aggregation destination store (S40). The details of this process are the same as the process shown in FIG. 8 except that the expected sales number is calculated for each aggregation destination store.

  Next, the movement instruction generation unit 260 performs the processes shown in S50, S60, S70, S80, S90, and S95. At this time, in S70, the movement instruction generation unit 260 sets the store input from the input unit 100 as an aggregation destination store and sets the remaining stores as movement source stores. Details of the processes other than S70 are the same as those in the first example, and thus the description thereof is omitted.

  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 movement instruction generation unit 260 generates the movement instruction information indicating the aggregation destination store as the store to which the product is moved and the stores other than the aggregation destination store as the store from which the product is moved. To do. Further, the aggregation destination store is a store where the operator of the inventory management apparatus selects a store that can be expected to be sold, or the store where the movement instruction generation unit 260 has a large number of sales in the latest period (for example, the most recent week). It is set by selecting. Therefore, by moving the products according to the movement instruction information, it is possible to collect the inventory of the products in stores where the products are expected to be sold.

  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.

As mentioned above, although embodiment of this invention was described with reference to drawings, these are the illustrations of this invention, Various structures other than the above are also employable.
(Invention 1)
A total inventory quantity obtaining means for obtaining a total inventory quantity that is a total value of current 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;
The current inventory quantity of the product for each of the plurality of stores is acquired, a difference obtained by subtracting the current inventory quantity from the required inventory quantity is calculated for each of the plurality of shops, and aggregated from the plurality of stores using the difference. Aggregation destination store selection means for selecting a destination store,
Movement instruction information indicating the aggregation destination store selected by the aggregation destination store selection unit as a store to which the product is moved and indicating the store not selected by the aggregation destination store selection unit as a store from which the product is moved Movement instruction generating means for generating;
An inventory management device comprising:
(Invention 2)
In the inventory management apparatus according to the invention 1,
The aggregation destination store selection means includes:
The first order is given to the plurality of stores in the order of small difference, the second order is given to the plurality of shops in the order of the current inventory quantity being small, and the third rank is given to the smallest expected sales quantity. And calculating points by multiplying each of the first to third ranks by multiplying by a weighting coefficient,
An inventory management apparatus that selects the aggregation destination store in descending order of the points.
(Invention 3)
In the inventory management apparatus according to the invention 1 or 2,
The movement instruction generation means includes
By dividing the total inventory quantity into each of the aggregation destination stores according to the estimated sales quantity, the necessary inventory quantity of the aggregation destination store is corrected, and the necessary inventory quantity not selected for the aggregation destination store is To 0,
The inventory management apparatus which produces | generates the said movement instruction | indication information so that the stock quantity of each of these several stores after movement becomes the said required stock quantity.
(Invention 4)
Collecting information specifying at least one or more aggregation destination stores that should aggregate the inventory of products in a plurality of stores, an aggregation destination store selecting means for selecting the aggregation destination store from a plurality of stores according to the information,
Total inventory quantity acquisition means for acquiring a total inventory quantity that is a total value of current inventory quantities of the products in the plurality of stores;
An expected sales volume acquisition means for acquiring an expected sales volume of the product for each of the aggregation destination stores in a predetermined period;
Movement instruction information indicating the aggregation destination store selected by the aggregation destination store selection unit as a store to which the product is moved and indicating the store not selected by the aggregation destination store selection unit as a store from which the product is moved Movement instruction generating means for generating;
A necessary inventory quantity, which is a value obtained by dividing the total inventory quantity into the aggregation destination stores according to the estimated sales quantity, is calculated for each aggregation destination store, and the inventory quantities of the plurality of stores after movement are the required A movement amount calculating means for calculating a movement amount indicated by each of the movement instruction information so as to be an inventory quantity;
An inventory management device comprising:
(Invention 5)
In the inventory management apparatus as described in any one of invention 1-4,
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.
(Invention 6)
In the inventory management device according to any one of the inventions 1 to 5,
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.
(Invention 7)
In the inventory management apparatus according to any one of the inventions 1 to 6,
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 number and the average inventory days of the product in the plurality of stores is equal to or more than 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.
(Invention 8)
A computer obtaining a total inventory quantity that is a sum of current inventory quantities of goods at a plurality of stores;
The computer obtaining an expected sales volume of the product for each of the plurality of stores in a predetermined period;
The computer calculates 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 for each of the stores;
The computer obtains a current inventory quantity of the product for each of the plurality of stores, calculates a difference obtained by subtracting the current inventory quantity from the required inventory quantity for each of the plurality of shops, and uses the difference to Selecting an aggregation destination store from the store;
The computer generating the movement instruction information indicating the aggregation destination store as a store to which the product is moved and indicating the store other than the aggregation destination store as the store from which the product is moved;
An inventory management method comprising:
(Invention 9)
The computer acquires information that identifies at least one aggregation destination store that should aggregate the inventory of products in a plurality of stores, and selects the aggregation destination store from a plurality of stores according to the information;
The computer obtaining a total inventory quantity that is a total value of a current inventory quantity of the product in the plurality of stores;
The computer obtaining an expected sales volume of the product for each aggregation destination store in a predetermined period;
The computer generating the movement instruction information indicating the aggregation destination store as a store to which the product is moved and indicating the store other than the aggregation destination store as the store from which the product is moved;
The computer calculates a necessary inventory quantity that is a value obtained by apportioning the total inventory quantity to the aggregation destination stores according to the estimated sales quantity for each of the aggregation destination stores, and the inventory of each of the plurality of stores after movement Calculating the amount of movement indicated by each of the movement instruction information so that the quantity becomes the required inventory quantity;
An inventory management method comprising:
(Invention 10)
A computer-executable program comprising:
The ability to get the total inventory quantity, which is the total value of the current inventory quantity of goods at multiple stores,
A function of obtaining an estimated sales volume of the product 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;
The current inventory quantity of the product for each of the plurality of stores is acquired, a difference obtained by subtracting the current inventory quantity from the required inventory quantity is calculated for each of the plurality of shops, and the aggregation destination is obtained from the plurality of stores using the difference. The ability to select a store,
A function of generating the movement instruction information indicating the aggregation destination store as a store to which the product is moved, and indicating the store other than the aggregation destination store as the store from which the product is moved;
A program that realizes
(Invention 11)
A computer-executable program comprising:
A function of acquiring information specifying at least one aggregation destination store that should aggregate inventory of products in a plurality of stores, and selecting the aggregation destination store from the plurality of stores according to the information;
A function of obtaining a total inventory quantity that is a total value of a current inventory quantity of the product in the plurality of stores;
A function of acquiring an expected sales volume of the product for each of the aggregation destination stores in a predetermined period;
A function of generating the movement instruction information indicating the aggregation destination store as a store to which the product is moved, and indicating the store other than the aggregation destination store as the store from which the product is moved;
A necessary inventory quantity, which is a value obtained by dividing the total inventory quantity into the aggregation destination stores according to the estimated sales quantity, is calculated for each aggregation destination store, and the inventory quantities of the plurality of stores after movement are the required A function of calculating a movement amount indicated by each of the movement instruction information so as to be an inventory quantity;
A program that realizes

It is a block diagram which shows the function structure of the inventory management apparatus concerning 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 1st example of 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 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. FIG. 12 is a table diagram specifically illustrating processing performed by the movement instruction generation unit 260 described in S <b> 500 of FIGS. 9 and 11. FIG. 12 is a table for specifically explaining processing performed by a movement instruction generation unit 260 shown in and after S510 in FIG. 11. FIG. 12 is a table for specifically explaining processing performed by a movement instruction generation unit 260 shown in and after S510 in FIG. 11. FIG. 12 is a table for specifically explaining processing performed by a movement instruction generation unit 260 shown in and after S510 in FIG. 11. It is a flowchart for demonstrating the 2nd example of the production | generation process of the movement instruction information which an inventory management apparatus performs.

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 (10)

A total inventory quantity obtaining means for obtaining a total inventory quantity that is a total value of current 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;
The current inventory quantity of the product for each of the plurality of stores is acquired, a difference obtained by subtracting the current inventory quantity from the necessary inventory quantity is calculated for each of the plurality of shops, and the difference is large among the plurality of stores. Aggregation destination store selection means for preferentially selecting the store as the aggregation destination store,
Movement instruction information indicating the aggregation destination store selected by the aggregation destination store selection unit as a store to which the product is moved and indicating the store not selected by the aggregation destination store selection unit as a store from which the product is moved Movement instruction generating means for generating;
The movement instruction information is not generated when the sales volume of the product in all stores in the latest period is equal to or less than a predetermined ratio with respect to the sales volume of the product in the period immediately preceding the latest period. Execution determination means;
An inventory management device comprising: The inventory management apparatus according to claim 1,
The aggregation destination store selection means includes:
The first order is given to the plurality of stores in the order of small difference, the second order is given to the plurality of shops in the order of the current inventory quantity being small, and the third rank is given to the smallest expected sales quantity. And calculating points by multiplying each of the first to third ranks by multiplying by a weighting coefficient,
An inventory management apparatus that selects the aggregation destination store in descending order of the points. In the inventory management apparatus according to claim 1 or 2,
The movement instruction generation means includes
By dividing the total inventory quantity into each of the aggregation destination stores according to the estimated sales quantity, the necessary inventory quantity of the aggregation destination store is corrected, and the necessary inventory quantity not selected for the aggregation destination store is To 0,
The inventory management apparatus which produces | generates the said movement instruction | indication information so that the stock quantity of each of these several stores after movement becomes the said required stock quantity. Collecting information specifying at least one or more aggregation destination stores that should aggregate the inventory of products in a plurality of stores, an aggregation destination store selecting means for selecting the aggregation destination store from a plurality of stores according to the information,
Total inventory quantity acquisition means for acquiring a total inventory quantity that is a total value of current inventory quantities of the products in the plurality of stores;
An expected sales volume acquisition means for acquiring an expected sales volume of the product for each of the aggregation destination stores in a predetermined period;
Movement instruction information indicating the aggregation destination store selected by the aggregation destination store selection unit as a store to which the product is moved and indicating the store not selected by the aggregation destination store selection unit as a store from which the product is moved Movement instruction generating means for generating;
A necessary inventory quantity, which is a value obtained by dividing the total inventory quantity into the aggregation destination stores according to the estimated sales quantity, is calculated for each aggregation destination store, and the inventory quantities of the plurality of stores after movement are the required A movement amount calculating means for calculating a movement amount indicated by each of the movement instruction information so as to be an inventory quantity;
The movement instruction information is not generated when the sales volume of the product in all stores in the latest period is equal to or less than a predetermined ratio with respect to the sales volume of the product in the period immediately preceding the latest period. Execution determination means;
An inventory management device comprising: In the inventory management apparatus as described in any one of Claims 1-4,
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 control apparatus as described in any one of Claims 1-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 number and the average inventory days of the product in the plurality of stores is equal to or more than 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. A computer obtaining a total inventory quantity that is a sum of current inventory quantities of goods at a plurality of stores;
The computer obtaining an expected sales volume of the product for each of the plurality of stores in a predetermined period;
The computer calculates 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 for each of the stores;
The computer acquires a current inventory quantity of the product for each of the plurality of stores, calculates a difference obtained by subtracting the current inventory quantity from the required inventory quantity for each of the plurality of shops, and from among the plurality of stores, A step of preferentially selecting a store with a larger difference as an aggregation destination store ;
The computer generating the movement instruction information indicating the aggregation destination store as a store to which the product is moved and indicating the store other than the aggregation destination store as the store from which the product is moved;
When the sales volume of the product in all stores in the latest period is less than a predetermined ratio with respect to the sales volume of the product in the period immediately preceding the latest period, the step of not generating the movement instruction information; ,
An inventory management method comprising: The computer acquires information that identifies at least one aggregation destination store that should aggregate the inventory of products in a plurality of stores, and selects the aggregation destination store from a plurality of stores according to the information;
The computer obtaining a total inventory quantity that is a total value of a current inventory quantity of the product in the plurality of stores;
The computer obtaining an expected sales volume of the product for each aggregation destination store in a predetermined period;
The computer generating the movement instruction information indicating the aggregation destination store as a store to which the product is moved and indicating the store other than the aggregation destination store as the store from which the product is moved;
The computer calculates a necessary inventory quantity that is a value obtained by apportioning the total inventory quantity to the aggregation destination stores according to the estimated sales quantity for each of the aggregation destination stores, and the inventory of each of the plurality of stores after movement Calculating the amount of movement indicated by each of the movement instruction information so that the quantity becomes the required inventory quantity;
When the sales volume of the product in all stores in the latest period is less than a predetermined ratio with respect to the sales volume of the product in the period immediately preceding the latest period, the step of not generating the movement instruction information; ,
An inventory management method comprising: A computer-executable program comprising:
The ability to get the total inventory quantity, which is the total value of the current inventory quantity of goods at multiple stores,
A function of obtaining an estimated sales volume of the product 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;
The current inventory quantity of the product for each of the plurality of stores is acquired, a difference obtained by subtracting the current inventory quantity from the necessary inventory quantity is calculated for each of the plurality of shops, and the difference is large among the plurality of stores. A function that selects stores as priority stores as stores ,
A function of generating the movement instruction information indicating the aggregation destination store as a store to which the product is moved, and indicating the store other than the aggregation destination store as the store from which the product is moved;
A function of preventing the generation of the movement instruction information when the sales volume of the product in all stores in the latest period is equal to or less than a predetermined ratio with respect to the sales volume of the product in a period immediately preceding the latest period; ,
A program that realizes A computer-executable program comprising:
A function of acquiring information specifying at least one aggregation destination store that should aggregate inventory of products in a plurality of stores, and selecting the aggregation destination store from the plurality of stores according to the information;
A function of obtaining a total inventory quantity that is a total value of a current inventory quantity of the product in the plurality of stores;
A function of acquiring an expected sales volume of the product for each of the aggregation destination stores in a predetermined period;
A function of generating the movement instruction information indicating the aggregation destination store as a store to which the product is moved, and indicating the store other than the aggregation destination store as the store from which the product is moved;
A necessary inventory quantity, which is a value obtained by dividing the total inventory quantity into the aggregation destination stores according to the estimated sales quantity, is calculated for each aggregation destination store, and the inventory quantities of the plurality of stores after movement are the required A function of calculating a movement amount indicated by each of the movement instruction information so as to be an inventory quantity;
A function of preventing the generation of the movement instruction information when the sales volume of the product in all stores in the latest period is equal to or less than a predetermined ratio with respect to the sales volume of the product in a period immediately preceding the latest period; ,
A program that realizes

Images