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

Abstract

To provide a system which simply examines movement of article between stores from the number of stocks and the number of sales so as to perform simulation.SOLUTION: In an inventory management device, a control unit includes: matrix creation means which creates a two-dimensional matrix image showing the number of sales and the number of stocks for each store and each item on the basis of sales information and inventory information; item movement accepting means which accepts item movement information comprising the items, stores being the origin of the movement, stores being the destination of the movement, and the amount of moved items; and matrix updating means which updates the matrix image for each acceptance of the item movement information of the item movement accepting means, in the matrix image created by the matrix creation means, by subtracting the number of moved items from the number of stocks in the store being the movement origin of the item in the item movement information accepted by the item movement accepting means, and adding the number of moved items to the number of stocks of the store being the movement destination of the item.SELECTED DRAWING: Figure 1

Description

The present invention relates to an inventory management device, an inventory management method, and an inventory management program.

In the retail industry, in the case of a business format that has multiple stores, the unit price of products is relatively high, and a sales format that does not maintain a large amount of inventory for each product, depending on the sales situation at each store Therefore, an operation that does not cause loss of sales opportunities by moving products between stores is required.

Until now, it was necessary to grasp the inventory status of other stores, contact them, and request the transfer of products based on the product sales and inventory status of each store, which relied on the judgment of the store manager. , the burden was heavy, and it was difficult to accurately move the goods between stores.

Therefore, a system that can easily consider and simulate the movement of products between stores based on the number of inventories and sales, and automatically propose the movement of products that optimizes the number of inventories between stores based on the number of sales. In addition, a system capable of easily performing from the preparation of product transfer data to the issuance of a transfer instruction is required. So far, no such system is known (Patent Document 1).

JP 2009-199397 A

Therefore, the object of the present invention is to provide a system that can easily study and simulate the movement of goods between stores based on the number of inventories and the number of sales, and to optimize the number of inventories between stores based on the number of sales. To provide a system capable of automatically proposing the movement of goods to be used, and furthermore, a system capable of easily performing from preparation of goods movement data to issuance of a movement instruction.

In order to solve the above-described problems and achieve the object, an inventory management device according to the present invention is an inventory management device comprising a control unit, wherein the control unit calculates the number of sales based on sales information and inventory information. Matrix creation means for creating a two-dimensional matrix diagram displaying stock quantities by store and by product, and product transfer reception for receiving product transfer information consisting of a combination of product, transfer source store, transfer destination store, and transfer quantity and, each time the goods movement receiving means receives the goods movement information, in the matrix diagram created by the matrix creating means, the stock of the transfer source store for the corresponding goods in the goods movement information received by the goods movement receiving means. and matrix updating means for updating the matrix diagram by subtracting the movement quantity from the number and adding the movement quantity to the stock quantity of the destination store for the corresponding product.

Further, in the inventory management apparatus according to the present invention, the control unit adds the product movement information received by the product movement reception means to the product movement data each time the product movement reception means receives the product movement information. It is characterized by further comprising product movement data creation means for updating movement data.

Further, in the inventory management apparatus according to the present invention, the control unit receives an instruction to create a movement instruction in which the product, the store of the origin of the movement, the store of the destination of the movement, and the amount of movement are displayed for each of the combinations. and movement instruction issuing means for creating a movement instruction based on the goods movement information in the goods movement data when the movement instruction issuance and reception means receives a creation instruction. and

In the inventory management apparatus according to the present invention, the control unit further comprises extraction attribute acceptance means for accepting extraction conditions for narrowing down the products for which the matrix creation means creates the matrix diagram based on the attributes thereof. , wherein the matrix creation means creates, based on the extraction conditions received by the extraction attribute receiving means, a matrix diagram excluding products that do not meet the extraction conditions.

Further, the inventory management apparatus according to the present invention includes automatic generation reception means for receiving an instruction to generate merchandise movement information consisting of a combination of merchandise, source store, destination store, and movement quantity; store extracting means for extracting stores with excess inventory exceeding the excess inventory standard and stores with insufficient inventory whose inventory quantity does not meet the minimum inventory standard; The inventory quantity of the store with excess inventory extracted by the store extracting means is reduced to the excess inventory standard or less, or the inventory quantity of the store with excess inventory extracted by the store extraction means is reduced and the store with insufficient inventory extracted by the store extraction means is extracted. By selecting the combination of the source store and the destination store for each product and determining the transfer quantity for each combination, so that the inventory quantity of the product meets the minimum inventory standard, goods movement information generating means for generating goods movement information for each combination of stores, wherein the goods movement data generating means collects the goods movement information generated by the goods movement information generating means to generate goods movement data. characterized by

Further, in the inventory management device according to the present invention, the excess inventory criterion is the sum of the number of sales, the standard inventory quantity for each product and for each store, and the excess secured inventory adjustment quantity for each product and each store, The minimum stock standard is the sum of the number of sales and the standard stock quantity for each product and each store.

Further, in the inventory management device according to the present invention, the merchandise movement information generating means determines the inventory of the original store, which is obtained by subtracting the excess inventory standard from the number of inventories among the excess inventory stores extracted by the store extraction means. In descending order of overstocked store with a larger overstock, the destination store is the understocked store with a larger understocked amount obtained by subtracting the inventory quantity from the minimum inventory standard among the understocked stores extracted by the store extraction means. A combination of the source store and the destination store is selected for each product by offsetting the excessive inventory at the source store and the insufficient inventory at the destination store, and the combination is selected. By separately determining the number of transfers, product transfer information is generated for each product and for each combination of the store at the source of the transfer and the store at the transfer destination.

Further, an inventory management method according to the present invention is an inventory management method executed by an inventory management device having a control unit, wherein the sales amount and the inventory amount are executed by the control unit based on sales information and inventory information. a matrix creation step of creating a two-dimensional matrix diagram displaying by store and by product; and a product transfer reception step of receiving product transfer information consisting of a combination of product, transfer source store, transfer destination store, and transfer quantity. , each time the merchandise movement information is received in the merchandise movement reception step, in the matrix diagram created in the matrix creation step, the stock quantity of the corresponding merchandise in the merchandise movement information received in the merchandise movement reception step. and a matrix update step of updating the matrix diagram by subtracting the movement quantity and adding the movement quantity to the stock quantity of the corresponding product at the destination store at the same time.

Further, an inventory management program according to the present invention is an inventory management program to be executed by an inventory management apparatus having a control unit, and is for executing by the control unit, based on sales information and inventory information. a matrix creation step of creating a two-dimensional matrix diagram showing the stock quantity by store and by product; and, each time the merchandise movement information is received in the merchandise movement receiving step, in the matrix diagram created in the matrix creation step, the stock of the store at the source of movement for the corresponding merchandise in the merchandise movement information received in the merchandise movement receiving step. and a matrix update step of updating the matrix diagram by subtracting the movement quantity from the number and adding the movement quantity to the stock quantity of the corresponding product at the destination store.

According to the system of the present invention, it is possible to easily study and simulate the movement of merchandise between stores based on the number of inventories and the number of sales. Furthermore, based on the number of sales, it is possible to automatically propose product movements that optimize the number of inventories between stores. Furthermore, it is possible to easily perform from the creation of product transfer data to the issuance of a transfer instruction sheet.

FIG. 1 is a block diagram showing an example of the configuration of a PC 100 according to one embodiment. FIG. 2 is a diagram showing an example of a flow from reception of extraction conditions by the extraction attribute reception unit 102g to issuance of a movement instruction by the movement instruction issuance unit 102f in one embodiment. FIG. 3A is a diagram illustrating an example of a movement instruction issuance input screen in an uninput stage according to one embodiment. FIG. 3B is a diagram illustrating an example of a movement instruction issuance input screen after product category input in one embodiment. FIG. 3C is a diagram illustrating an example of a movement instruction issuance input screen at the stage of inputting goods movement information in one embodiment. FIG. 3D is a diagram illustrating an example of a movement instruction issuance input screen after confirming input of product movement information in one embodiment. FIG. 3E is a diagram illustrating an example of a movement instruction issuance input screen after generation of product movement information in one embodiment. FIG. 4A is a diagram showing an example of a product master in one embodiment. FIG. 4B is a diagram illustrating an example of inventory data in one embodiment. FIG. 4C is a diagram illustrating an example of sales data in one embodiment. FIG. 4D is a diagram illustrating an example of a store master in one embodiment. FIG. 4E is a diagram illustrating an example of reference data in one embodiment. FIG. 5 is a diagram for explaining the flow of processing by the store extraction unit 102i and the product movement information generation unit 102j in one embodiment.

An embodiment of the present invention will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1. composition]
Here, an example of the configuration of a PC (personal computer) 100 according to this embodiment including the inventory management device of the present invention will be described with reference to FIG. The configuration of this embodiment is merely an example, and the present invention is not limited to the configuration of this embodiment. Also, in the following description of the configuration, redundant description may be omitted.

FIG. 1 is a block diagram showing an example of the configuration of the PC 100. As shown in FIG. The PC 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input/output interface unit 108, and is a server 200 storing various data (for example, data stored in the storage unit 106, which will be described later). (for example, a Web server, etc.) and a network 300 (for example, the Internet, an intranet, a LAN (Local Area Network), etc.) are communicably connected.

Each unit included in the PC 100 is communicably connected via an arbitrary communication path.

Note that the PC 100 may be, for example, a stationary type such as a desktop personal computer, or a portable type such as a notebook personal computer, a PDA (Personal Digital Assistants), a smart phone, or a tablet personal computer. may be

A control unit 102 is a CPU or the like that controls the PC 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally conceptually includes a matrix creation unit 102a, a product movement reception unit 102b, a matrix update unit 102c, a product movement data creation unit 102d, a movement instruction issue reception unit 102e, a movement instruction issue unit 102f, an extraction attribute It includes a reception unit 102g, an automatic generation reception unit 102h, a shop extraction unit 102i, a product movement information generation unit 102j, and the like.

The matrix creation unit 102a creates a two-dimensional matrix diagram that displays the number of sales and the number of inventories by store and by product based on the sales information and inventory information.

In one embodiment of the two-dimensional matrix diagram created by the matrix creating unit 102a, one of row items and column items on the vertical and horizontal axes is an item by store, and the other is an item by product. , and both the number of sales and the number of inventory for each store and for each product based on the sales information and inventory information are collectively displayed at each intersection of the matrix diagram.

The matrix creation unit 102a creates a two-dimensional matrix diagram displaying the number of sales within a predetermined period and the latest number of inventories based on the sales information and the latest inventory information within the predetermined period.

In this embodiment, the matrix creation unit 102a extracts the sales information within a predetermined period based on the sales date information included in the sales information before creating the matrix diagram, and collects the extracted sales information and the latest inventory. Based on the information, a two-dimensional matrix diagram displaying the number of sales and the latest number of inventories within a predetermined period is created.

In this embodiment, the term "within a predetermined period" refers to a specific period based on the date when the matrix creation unit 102a creates the matrix diagram. can.

In one embodiment, the two-dimensional matrix diagram created by the matrix creating unit 102a can be output at any time via an output device 400 such as a display device such as a display or a projector.

The merchandise movement reception unit 102b receives merchandise movement information including a combination of merchandise (merchandise identifier), source store (store identifier), destination store (store identifier), and the number of items moved (numerical value). One product transfer information includes one product (product identifier), a transfer source store (store identifier), a transfer destination store (store identifier), and a transfer quantity (numerical value).

The products in the product movement information received by the product movement reception unit 102b can be the products displayed in the two-dimensional matrix diagram created by the matrix creation unit 102a. The source store or destination store in the product movement information received by the product movement reception unit 102b may be the store displayed in the two-dimensional matrix diagram created by the matrix creation unit 102a.

The two-dimensional matrix diagram created by the matrix creation unit 102a and the input fields for accepting combinations of products, source stores, destination stores, and the number of transfers are displayed on the same screen, and the display device, which is the output device 400, is displayed. It is preferable to display through With this form, the user can refer to the number of sales and the number of inventories displayed by store and by product in a two-dimensional matrix diagram, and find out which products have excess or deficiency in inventory between stores, and which products are available. The input device 500 (keyboard , mouse, etc.). In addition, the user refers to the number of sales and the number of inventory displayed in the two-dimensional matrix diagram, determines the appropriate combination of the product, the source store, the destination store, and the number of transfers, and selects the appropriate combination. There is no particular limitation as long as the combination can be entered in the input fields to be accepted. Therefore, the screen displaying the two-dimensional matrix diagram created by the matrix creating unit 102a and the screen displaying the input fields for accepting combinations of products, source stores, destination stores, and the number of transfers are linked to each other. It may be in the form of The input field has a confirmation button for confirming the input.

The goods movement reception unit 102b receives an instruction to delete the goods movement information from the goods movement data together with the identification information of the goods movement information. After the user inputs the product movement information including the combination of the product, the source store, the destination store, and the quantity of goods transferred, or after the product movement data generation unit 102i creates the product movement information, the user can generate the product movement information individually or If you want to cancel all of them, you can input an instruction to delete the product movement information and delete the product movement information.

The display column of the product movement information included in the product movement data and the reception column (for example, button) for receiving the deletion instruction of the product movement information may be displayed on the same screen via the display device, which is the output device 400. preferred.

The goods movement reception unit 102b receives a data confirmation registration instruction of goods movement data. After inputting one or more items of product movement information, the user can confirm and register product movement data including one or more pieces of product movement information when additional input of product movement information is no longer required.

The display column of the product movement information included in the product movement data and the reception column (e.g., button) for receiving the data confirmation registration instruction of the product movement data are displayed on the same screen via the display device that is the output device 400. Morphology is preferred.

Each time the product movement reception unit 102b receives the product movement information, the matrix update unit 102c updates the product movement information received by the product movement reception unit 102b or the product movement information described below in the matrix diagram created by the matrix creation unit 102a. By subtracting the transfer quantity from the stock quantity of the corresponding product at the source store for the corresponding product in the product transfer information generated by the generating unit 102j, and at the same time adding the transfer quantity to the stock quantity at the destination store for the corresponding product, a matrix diagram is obtained. to update. That is, in the matrix diagram, for a certain product, a specific transfer quantity value is transferred from the transfer source store to the product transfer destination store. The user performs an operation of inputting product movement information in order for the product movement reception unit 102b to accept the product movement information, and the store-by-store and By executing (repeating) the task of referring to the number of sales and the number of inventories for each product, it becomes possible to simulate the optimization of the number of inventories between stores for each product.

The product movement data creation unit 102d updates the product movement data by adding the product movement information received by the product movement reception unit 102b to the product movement data each time the product movement reception unit 102b receives the product movement information. Product movement data is an information aggregate of one or more pieces of product movement information.

When the goods movement reception part 102b receives an instruction to delete the goods movement information, the goods movement data creation part 102d adds the goods movement information corresponding to the identification information of the goods movement information to the goods movement data together with the identification information of the goods movement information. Update product movement data by deleting from

The goods movement data creation unit 102d stops updating the goods movement data when the goods movement reception unit 102b receives the data confirmation registration instruction of the goods movement data.

The goods movement data creation unit 102d creates goods movement data by collecting the goods movement information generated by the goods movement information generation unit 102j.

The movement instruction form issuing/receiving unit 102e receives an instruction to issue a movement instruction form in which a product, a source store, a destination store, and a movement quantity are displayed for each combination. The transfer instruction form issuing/receiving unit 102e may accept an instruction to issue a transfer instruction form only after the product transfer accepting unit 102b has received the data confirmation registration instruction of the product transfer data.

The movement instruction issuing unit 102f issues a movement instruction based on the product movement information in the product movement data when the movement instruction issuance receiving unit 102e receives an issue instruction.

The extraction attribute reception unit 102g receives extraction conditions for narrowing down the products for which the matrix creation unit 102a creates a matrix diagram based on the attributes. Attributes for narrowing down the products can be, for example, product category, brand, product number, supplier, and the like. Based on the extraction conditions received by the extraction attribute reception unit 102g, the matrix creation unit 102a creates a matrix diagram excluding products that do not meet the extraction conditions.

The extraction attribute acceptance unit 102g may accept an extraction condition for narrowing down the stores for which the matrix creation unit 102a creates a matrix diagram based on the attributes. Attributes for narrowing down the stores can be, for example, area, store number, contractor, sales amount, and the like. In this embodiment, the matrix creation unit 102a creates a matrix diagram excluding stores that do not meet the extraction conditions, based on the extraction conditions accepted by the extraction attribute acceptance unit 102g.

The automatic generation receiving unit 102h receives an instruction to generate product movement information including a combination of the product, the source shop, the destination shop, and the number of transfers.

The store extracting unit 102i extracts, for each product, stores with excess inventory in which the inventory quantity exceeds the excess inventory standard and stores with insufficient inventory in which the inventory quantity does not meet the minimum inventory standard. In one embodiment, the excess inventory criterion is the sum of the number of sales (the number of sales in a predetermined period), the standard inventory number by product and by store, and the excess secured inventory adjustment number by product and store, The minimum inventory standard is the sum of the number of sales (the number of sales within a predetermined period) and the standard inventory number for each product and each store.

Merchandise extracted by the store extracting unit 102i to determine whether the store is overstocked or understocked meets the extraction conditions received by the extraction attribute receiving unit 102g, and is the object for which the matrix creation unit 102a creates a matrix diagram. It is a commodity. Stores extracted by the store extracting unit 102i as overstocked stores and understocked stores are stores that meet the extraction conditions received by the extraction attribute receiving unit 102g and are targeted for creating a matrix diagram by the matrix creation unit 102a.

The product movement information generation unit 102j increases the inventory quantity of the store with insufficient inventory extracted by the store extraction unit 102i and adjusts the inventory quantity of the store with excess inventory extracted by the store extraction unit 102i to be equal to or less than the excess inventory standard, or In order to reduce the inventory quantity of the store with excess inventory extracted by the extraction unit 102i and the inventory quantity of the store with insufficient inventory extracted by the store extraction unit 102i satisfies the minimum inventory standard, the transfer source store and the transfer destination store are selected for each product. By selecting a combination and determining the number of transfers for each combination, product transfer information is generated for each product and for each combination of the store at the source of the transfer and the store at the transfer destination.

In one embodiment, the product movement information generation unit 102j determines the number of overstocked stores extracted by the store extraction unit 102i from the overstocked stores extracted by the store extraction unit 102i. In order from the excess store, the transfer destination store is selected from the stores with insufficient inventory extracted by the store extraction unit 102i, and the store with the excess inventory obtained by subtracting the inventory quantity from the minimum inventory standard is selected in order from the store with the excess inventory. A combination of a source store and a destination store is selected for each product by canceling out the overstock of the store and the understock of the destination store, and the transfer quantity is determined for each combination. Thus, product movement information is generated for each product and for each combination of the store at the source of the movement and the store at the destination of the movement.

The communication interface unit 104 communicably connects the PC 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 conceptually includes a sales data storage unit 106a, an inventory data storage unit 106b, a product master storage unit 106c, a store master storage unit 106d, a product movement data storage unit 106e, a reference master storage unit 106f, and the like. .

The sales data storage unit 106a stores sales data in which one or more pieces of sales information are summarized. The sales information is organized into sales data by store and by product. The sales information, in one embodiment, includes information on store identifiers, product identifiers, sales dates, sales numbers by sales date, and sales by store and by product.

The inventory data storage unit 106b stores inventory data in which one or more items of inventory information are summarized. Inventory information is organized into inventory data by store and by product. The inventory information, in one embodiment, includes store identifiers, product identifiers, and inventory counts by store and by product. Inventory data is tied with sales data via a store identifier and a goods identifier in the embodiment concerned.

The product master storage unit 106c stores a product master in which information on one or more products is collected. The product information is organized into product data for each product. In one embodiment, the product information includes detailed product information such as product name, brand, supplier, and product category in addition to the product identifier. In this embodiment, the product master is associated with sales data and inventory data via product identifiers.

The store master storage unit 106d stores a store master in which information on one or more stores is collected. The store information is organized into store data for each store. The store information, in one embodiment, includes detailed store information such as store name, store location area, etc., in addition to the store identifier. In this embodiment, the store master is associated with sales data and inventory data via store identifiers.

The goods movement data storage unit 106e stores goods movement data in which one or more pieces of goods movement information are summarized. The product movement information includes product movement information received by the product movement reception unit 102b and product movement information generated by the product movement information generation unit 102j. The product movement data is created or updated by the product movement data creation unit 102d. The product movement information includes a product identifier, a store identifier of the source store, a store identifier of the destination store, and the number of items moved. In this embodiment, the product movement data is associated with sales data and inventory data via store identifiers and product identifiers, respectively.

The reference master storage unit 106f stores a reference master in which one or a plurality of pieces of reference information are compiled. The reference information is organized into reference data for each store and for each product. The reference information, in one embodiment, includes a store identifier, a product identifier, a reference inventory quantity, and a surplus reserved inventory adjustment quantity. In this embodiment, the reference master is associated with sales data and inventory data via store identifiers and product identifiers.

An input device 400 and an output device 500 are connected to the input/output interface section 108 . The output device 400 includes a display device such as a display and a projector, a sound device such as a speaker, a printing device such as a printer, and a device capable of being downloaded in a data file format. As the data file format, a file format known in the art such as PDF, CSV, document file, spreadsheet software file, text file, etc. can be adopted. The input device 500 can use a keyboard, a mouse, a microphone, and a monitor that realizes a pointing device function in cooperation with the mouse.

[2. Concrete example]
Here, using a specific example, the matrix creation unit 102a, the product movement reception unit 102b, the matrix update unit 102c, the product movement data creation unit 102d, the movement instruction issuance reception unit 102e, and the movement instruction in the inventory management apparatus according to the present invention. Information processing by the book issuing unit 102f, the extracted attribute reception unit 102g, the automatic generation reception unit 102h, the store extraction unit 102i, and the product movement information generation unit 102j will be described with reference to FIGS.

FIG. 2 is a diagram showing an example of a flow from reception of extraction conditions by the extraction attribute reception unit 102g to issuance of a movement instruction by the movement instruction issuance unit 102f.

As shown in FIG. 2, in this specific example, first, the user inputs extraction conditions for narrowing down the products or stores for which the matrix diagram is to be created based on their attributes. Upon input, the extraction attribute reception unit 102g receives extraction conditions (S01), and the matrix creation unit 102a creates a matrix diagram based on the received extraction conditions (S02).

Next, the user refers to the matrix diagram created by the matrix creating unit 102a, and if it is determined that there is no store with excess or shortage of product inventory, the process ends (S03-No). If it is determined that there is a store with an excess or deficiency of product inventory (S03-Yes), refer to the matrix diagram to optimize the number of stores with an excess or deficiency of product inventory. (S04-Yes) or to automatically generate the product movement information (S04-No).

When simulating product movement (S04-Yes), first, the user refers to the matrix diagram created by the matrix creation unit 102a, and selects product movement as basic information for moving inventory of specified products between stores. Enter your information. When the product movement information is input, the product movement reception unit 102b receives the product movement information (S05). The matrix diagram is updated (S06).

If the user refers to the matrix diagram updated by the matrix updating unit 102c and determines that there is no store with an excess or deficiency of product inventory (S07-No), the user issues an instruction to finalize and register the product movement data. input. When the data confirmation registration instruction is input, the product movement receiving unit 102b receives the data confirmation registration instruction, and shifts to movement instruction processing (S08). Furthermore, when the user inputs an instruction to issue a movement instruction, the movement instruction issuing unit 102f issues a movement instruction (S09).

If the user refers to the matrix diagram updated by the matrix updating unit 102c and determines that there is a store with excess or deficiency of products (S07-Yes), the matrix diagram updated by the matrix updating unit 102c , and enter the product transfer information as basic information for transferring the stock of the specified product between stores.

On the other hand, if the product movement information is to be automatically generated (S04-No), the user inputs an instruction to generate the product movement information. When an instruction to generate merchandise movement information is input, the automatic generation reception unit 102h receives the instruction to generate merchandise movement information (S10), and the store extracting unit 102i extracts stores with excess inventory and stores with insufficient inventory, The information generation unit 102j generates product movement information based on the extracted overstock stores and understock stores (S11), and based on this, the matrix update unit 102c updates the matrix diagram (S12). After updating the matrix diagram, it is possible to input a data confirmation registration instruction. After the input, the product movement receiving unit 102b receives the data confirmation registration instruction (S08). , the movement instruction issuing unit 102f issues a movement instruction (S09).

Details of the above flow will be described below.

FIG. 3A is a diagram showing a movement instruction issuance input screen in the non-input stage in this specific example. As shown in FIG. 3A, the transfer instruction issuance input screen in this specific example includes input fields 311 to 314 for product classification, brand, product number, and supplier of extraction conditions accepted by the extraction attribute reception unit 102g, and product transfer acceptance. Input fields 321 to 321 for inputting a combination of the product, the source store (destination store), the destination store (destination store), and the number of transfers (number of transfers) included in the product transfer information received by the unit 102b. 324, its input confirmation button 325, a two-dimensional matrix diagram 330 created by the matrix creating unit 102a and updated by the matrix updating unit 102c, the product movement data or the product movement information or the product movement information included in the product movement data are displayed. 340, a detail delete button 351 for deleting specific merchandise movement information from the merchandise movement data displayed in the merchandise movement input content column 340, and the merchandise movement data generation unit 102i. and display the product movement information in the product movement input content column 340; have.

(A) Display of Matrix Diagram First, the user inputs extraction conditions for narrowing down the products for which the matrix creation unit 102a creates a matrix diagram based on the attributes thereof. In the moving instruction issuance input screen in this specific example, there are input fields 311 to 314 for inputting any of product category, brand, product number, and supplier as extraction conditions. When an appropriate code is entered in any of the extraction condition input fields 311 to 314, the extracted attribute acceptance unit 102g accepts the information as an extraction condition, and the matrix creation unit 102a proceeds to create a matrix diagram.

Below, a detailed description will be given of the process up to the display of the matrix diagram 330 shown in FIG.

FIG. 3B is a diagram showing a screen for inputting movement instruction issuance after product category input in this specific example. After the user enters the product classification "1" (glasses frame) in the product classification input field 311, the movement instruction issuance input screen displays a matrix created by narrowing the products to eyeglass frames, as shown in FIG. 3B. Figure 330 shows the stage of displaying diagram 330;

FIG. 4A is a diagram showing a product master in this specific example. As shown in FIG. 4A, the product master in this specific example includes, for each product, a product code (product identifier), product name, brand code (brand identifier), supplier code (supplier identifier), and product category. Product information A01 to A05 consisting of items of codes (product classification identifiers) are summarized. In FIG. 4A, for convenience, the product master includes the brand name together with the brand code (brand identifier), the supplier name together with the supplier code (supplier identifier), and the product classification name together with the product classification code (product classification identifier). However, in practice, for brands, only the brand code (brand identifier) is included in the product master, and the brand master and the brand code (brand identifier ), and with regard to suppliers, only the supplier code (vendor identifier) is included in the product master. It is linked to the supplier master including the supplier name and the supplier code (supplier identifier). Each product category is associated with a product category master including product category codes (product category identifiers) and product category names via product category codes (product category identifiers).

FIG. 4B is a diagram showing inventory data in this specific example. As shown in FIG. 4B, the inventory data in this specific example includes inventory information B01 to B08 consisting of items of a store code (store identifier), a product code (product identifier), and the number of items in stock for each product and each store. It is Note that the inventory data in this specific example is assumed to be inventory data as of December 22, 2021.

FIG. 4C is a diagram showing sales data in this specific example. As shown in FIG. 4C, the sales data in this specific example consists of items of store code (store identifier), product code (product identifier), sales date, and number of sales for each sales date, product, and store. Sales information C01 to C08 are summarized. It is assumed that the sales data in this specific example is the sales data on December 22, 2021.

FIG. 4D is a diagram showing a shop master in this specific example. As shown in FIG. 4D, in the store master in this specific example, store information D01 to D24 including the items of store code (store identifier), store name, and area code are summarized for each store. In FIG. 4D, for the sake of convenience, the store master contains area names together with area codes. Linked via code.

First, when the user enters the product category code "1" (glasses frame) in the product category input field 311, the extraction attribute reception unit 102g selects the product category code "1" as an extraction condition for narrowing down the target products. is received (S01). It is assumed that the user entered the product classification code on December 22, 2021.

Next, the matrix creation unit 102a extracts the product information A01 to A04 of the product classification code "1" from the product information A01 to A05 included in the product master shown in FIG. 4A according to the extraction conditions accepted by the extraction attribute acceptance unit 102g. to extract

Next, the matrix creation unit 102a selects the sales information C01 to C05 and C07 whose sales date is within one month from December 22, 2021, out of the sales information C01 to C08 included in the sales data shown in FIG. 4C. - Extract C08.

Next, as shown in FIG. 3B, the matrix creation unit 102a plots items for each product consisting of the product code and product name based on the extracted product information A01 to A04 on the vertical axis, and the stores shown in FIG. 4D on the horizontal axis. The item for each store consists of area and store code based on all store information D01 to D24 of the master, and the upper row of each intersection of the matrix is the number of sales (sales within one month based on December 22, 2021) The total number of sales based on the information (the same applies hereinafter)), and the lower row is the number of inventories, and the product of the product information A01 to A04 extracted from the inventory information B01 to B08 included in the inventory data shown in FIG. 4B Created based on the inventory information B01-B07 corresponding to the code and the sales information C01-C05/C07/C08 corresponding to the product code of the extracted product information A01-A04 among the extracted sales information C01-C05/C07/C08 and display (S02).

After the matrix diagram is created and displayed, if the user determines that there is an excess or deficiency in the inventory of the product (S03-Yes), (B) while referring to the matrix diagram 330, check whether there is an excess or deficiency of the product. By inputting the merchandise movement information for optimizing the inventory quantity of the store, the merchandise movement data is created while simulating the merchandise movement, and the merchandise movement information is displayed in the commodity movement input content column 340. (S04-Yes), or (C) the product movement information generation unit 102j automatically generates the product movement information and displays the product movement information in the product movement input content column 340. (S04-No).

(B) Simulation of Product Movement When simulating product movement (S04-Yes), the user refers to the matrix diagram 330 shown in FIG. In the entry fields 321 to 324, the product movement information, which is the basic information for moving the inventory of the specified product, is entered in the input fields 321 to 324, and the matrix update unit 102c updates the matrix diagram as shown in FIG. Run a movement simulation.

FIG. 3C is a diagram showing a movement instruction issuance input screen at the stage of inputting goods movement information in this specific example. 3C, the user enters the product code "A00001" in the product input field 321, the shop code "2" in the transfer source store input field 322, and the destination shop as the product transfer information. This is the movement instruction issuance input screen at the stage where the store code "3" is input in the field 323 and the number of movements "25" is input in the input field 324 of the number of movements.

FIG. 3D is a diagram showing a movement instruction issuance input screen after input and confirmation of product movement information in this specific example. The movement instruction issue input screen is displayed by the matrix update unit 102c after the confirm button 325 is pressed on the movement instruction issue input screen shown in FIG. The updated matrix diagram 303 is displayed, and the item movement reception information containing the item movement data received by the item movement receiving unit 102b is displayed in the item movement input content column 340. This is the issuance input screen.

Below, a detailed description will be given of the process from the input of the goods movement information to the updating of the matrix diagram 330 as shown in FIG.

First, as shown in FIG. 3C, the user enters the product code "A00001" in the product input field 321, the store code "2" in the source store input field 322, and the store code "2" in the destination store input field 323, as shown in FIG. Enter the store code “3” and the number of moves “25” in the number of moves input field 324 , and press the input confirmation button 325 . When the input confirmation button 325 is pressed, the product transfer reception unit 102b receives the product code "A00001", the store code (source store) "2", the store code (destination store) "3", and the items entered by the user. Goods movement information consisting of a combination of numbers (movement quantity) "25" is received (S05).

Next, based on the product movement information received by the product movement reception unit 102b, the matrix updating unit 102c updates the matrix diagram 330 shown in FIG. Subtract the number of transfers (transfer quantity) "25" from the inventory quantity "60" to obtain the inventory quantity "35", and move to the inventory quantity "60" for the store code (destination store) "3" for the product code "A00001" The number (transfer quantity) "25" is added to update the matrix diagram 330 shown in FIG. 3D to the stock quantity "85" (S06).

On the other hand, the product movement data creation unit 102d adds the product movement information received by the product movement reception unit 102b to the product movement data, and displays the product movement information included in the product movement data based on the product movement information. In the product movement input content column 340, the store code (source store) "2" and the store name "store 002" based on the store information D02 including the store code in the store master shown in FIG. 4D are entered in the source column. , the store name "Store 003" based on the store information D03 including the store code (destination store) "3" and the store code in the store master shown in FIG. The number of moves (number of moves) "25" is newly displayed in the column of "A00001", the product name "○○ frame 01" including the product code in the product master shown in FIG. 4A, and the number of moves.

After that, the user further refers to the matrix diagram, and if the user determines that there is an excess or deficiency in the inventory of the product (S07-Yes), further inputs the product code of the product into the input field 321 of the product, and Enter the store code of the store with excess inventory in the input field 322 of the transfer source store, enter the store code of the store with insufficient inventory in the input field 323 of the destination store, and enter the quantity that will eliminate the excess or deficiency. is entered in the movement number input field 324 and the input confirmation button 325 is pressed.

(C) Automatic Generation of Product Movement Information When automatic generation of product movement information is to be performed (S04-No), the user causes the product movement information generation unit 102j to automatically generate the product movement information and fills in the product movement input content column 340. The product inventory optimization button 352 for displaying product movement information is pressed. By pressing the merchandise inventory optimization button 352, the automatic generation reception unit 102h receives an instruction to generate merchandise movement information (S10).

When the automatic generation reception unit 102h receives an instruction to generate product movement information (S10), the store extraction unit 102i extracts stores with excessive inventory and stores with insufficient inventory. Product movement information is generated based on the store and the store with insufficient inventory (S11).

In the following, the processing flow of the store extraction unit 102i and the product movement information generation unit 102j will be described in detail by picking up only the product "○○ frame 01" that has generated sales at a plurality of stores.

FIG. 3E is a diagram showing a movement instruction issuance input screen after generation of product movement information in this specific example. The movement instruction issuance input screen is obtained when the user presses the commodity inventory optimization button 352 on the movement instruction issuance input screen shown in FIG. (S10), the product movement information generating unit 102j automatically generates the product movement information (S11), and the generated product movement information is displayed in the product movement input content field 340. This is the movement instruction issue input screen.

FIG. 4E is a diagram showing reference data in this specific example. As shown in FIG. 4E, the reference data in this specific example includes inventory information consisting of a store code (store identifier), a product code (product identifier), a standard inventory quantity, and a surplus secured inventory adjustment quantity for each product and each store. Reference information including E01-E04 is summarized.

FIG. 5 is a diagram for explaining the processing flow of the store extraction unit 102i and the product movement information generation unit 102j.

FIG. 5(a) shows the store name, product name, inventory quantity based on the inventory master shown in FIG. 4B, and FIG. The number of sales based on the sales master shown in FIG. 4E, the reference inventory number and the excess secured inventory adjustment number based on the reference master shown in FIG. It is the table|surface which summarized the stock shortage obtained by subtracting a number. The excess inventory standard is the sum of the number of sales, the standard inventory number, and the excess secured inventory adjustment number, and the minimum inventory standard is the sum of the sales volume and the standard inventory number.

FIG. 5(b1) shows, for each store, stores with insufficient inventory extracted by the store extracting unit 102i, the store name, product name, inventory quantity based on the inventory master, and inventory inventory obtained by subtracting the inventory quantity from the minimum inventory standard ( ("minimum standard of stock-inventory"), the number to be allocated, and the remaining number after allocation obtained by subtracting the number to be allocated from the shortfall in inventory, together with the ranking in descending order of the shortfall in inventory. 5(b2) to (b4) are tables with the same items as in FIG. 5(b1), but in FIG. While the balance after allocation is the same, in FIGS. , in that the number to be allocated increases and the remaining number after allocation decreases in accordance with the generation of the product movement information.

FIG. 5(c1) shows, for each store, the excess inventory stores extracted by the store extraction unit 102i, the store name, the product name, the inventory quantity based on the inventory master, and the excess inventory obtained by subtracting the excess inventory standard from the inventory quantity ( "Inventory quantity-excess inventory criteria"), the number of allocations, and the remaining number after allocation obtained by subtracting the number of allocations from the excess inventory, together with the ranking in descending order of excess inventory. 5(c2) to (c4) are tables of the same items as in FIG. 5(c1), but in FIG. 5(c1), the number of allocations is "0" in all stores 5(c2)-(c4), the product movement information is generated stepwise as shown in corresponding FIGS. The difference is that the number of allocations increases and the remaining number after allocation decreases in accordance with the generation of movement information.

5(d1) to (d3) are tables summarizing the product movement information including the quantity of goods moved for each stage of generation of the product movement information, for each product, and for each combination of the source store and the destination store. FIG. 5(d1) corresponds to FIGS. 5(b2) and 5(c2), respectively, FIG. 5(d2) corresponds to FIGS. 5(b3) and 5(c3), respectively, and FIG. ) correspond to FIGS. 5(b4) and 5(c4), respectively.

First, when the automatic generation receiving unit 102h receives an instruction to generate the product movement information, the store extracting unit 102i detects excess inventory stores whose inventory quantity exceeds the excess inventory criterion, i.e., excess inventory obtained by subtracting the excess inventory criterion from the inventory quantity. ("Inventory quantity-Excessive inventory criteria") is a positive value of the four stores shown in Fig. 5(a). Two stores are extracted, and on the other hand, the number of stores with insufficient inventory that does not meet the minimum inventory standard, that is, the number of inventory minus the inventory number from the minimum inventory standard ("minimum inventory standard - inventory count") is a positive value. As shown in FIG. 5(b1), two stores "store 003" and "store 004" are extracted from the four stores shown in FIG. 5(a).

As shown in FIG. 5(c1), the product movement information generating unit 102j sorts the two stores extracted by the store extracting unit 102i as overstock stores (source stores) as "store 002" in descending order of overstock. , and "Store 001" are assigned rank numbers "1" and "2". On the other hand, as shown in FIG. 5(b1), the product movement information generation unit 102j sorts the two stores extracted by the store extraction unit 102i as stores with insufficient inventory (stores to be moved) in descending order of the inventory shortage. Ranks "1" and "2" are assigned to "store 003" and "store 004".

After that, the product movement information generation unit 102j determines that the post-allocation balance obtained by subtracting the allocation quantity from the excess inventory (inventory quantity - excess inventory criterion) among the excess inventory stores (source store) is not “0”. The remaining amount after allocation obtained by subtracting the amount to be allocated from the remaining amount after allocation of the higher ranked stores and the number of insufficient inventory among the stores with insufficient inventory (destination store) (minimum inventory standard - number of items in stock) is " The same number as the lower number of the remaining number after allocation of the higher-ranking store that is not 0" is newly used as the transfer quantity, and the allocation number of the store with excess inventory (source store) and By repeating the process of adding to each allocated quantity of the store with insufficient stock (destination store), the product movement information including the combination of the source store and the destination store and the movement quantity is generated step by step (S11).

First, as shown in FIG. 5(c1), the product movement information generating unit 102j selects the store with excess inventory (source store) that has a higher rank of "1" than the remaining number after allocation that is not "0". The post-allocation balance of the second “store 002” is “25”. On the other hand, as shown in FIG. Since the post-allocation balance of "Store 003", which is ranked "1", which is higher than 0, is "30", the post-allocation balance is "25" and the post-allocation balance is "30". The lower numerical value "25" is added as a new transfer quantity to the allocated quantity "0" of "store 002" and the allocated number "0" of "store 003". 5(c2), the number of allocations for "store 002" is set to "25" (remaining number after allocation is "0"), and as shown in FIG. Let it be "25" (remaining number after being allocated is "5").

At the same time, as shown in FIG. 5(d1), the product movement information generation unit 102j generates a combination of the excess inventory store "store 002" and the inventory shortage store "store 003" in which the movement quantity is added to the number of allocations and the number of allocations. as a combination of the source store and the destination store, new product movement information including the product "○○ frame 01" and the number of movements "25" is generated.

Next, as shown in FIG. 5(c2), the product movement information generating unit 102j selects the store with excess inventory (source store) that has a higher rank of "2" than the remaining number after allocation that is not "0". , the remaining number after allocation of "store 001" is "15". On the other hand, as shown in FIG. Since the post-allocation balance of "Store 003", which is ranked "1", which is higher than "0", is "5", the balance after allocation is "15" and the balance after allocation is "5". ”, the lower value “5” is added as a new transfer quantity to the allocated quantity “0” of “store 001” and the allocated quantity “25” of “store 003”, As shown in FIG. 5(c3), the number of allocations for "store 001" is set to "5" (remaining number after allocation is "10"), and as shown in FIG. is "30" (remaining number after allocation is "0").

At the same time, as shown in FIG. 5(d2), the product movement information generation unit 102j generates a combination of the excess inventory store "store 001" and the inventory shortage store "store 003" in which the movement quantity is added to the number of allocations and the number of allocations. as a combination of the source store and the destination store, new product movement information including the product "○○ frame 01" and the number of movements "5" is generated.

Next, as shown in FIG. 5(c3), the product movement information generating unit 102j selects the store with excess inventory (source store), which has a higher rank of "2" than the remaining number after allocation that is not "0". , the remaining number after allocation of "store 001" is "10", and on the other hand, as shown in FIG. Since the post-allocation balance of "Store 004", which is ranked higher than "0" and ranked "2", is "20", the balance after allocation is "10" and the balance after allocation is "20". ”, the lower value “10” is added as a new transfer quantity to the allocation quantity “5” of “store 001” and the allocated quantity “0” of “store 004”, As shown in FIG. 5(c4), the number of allocations for "store 001" is set to "15" (remaining number after allocation is "0"), and as shown in FIG. is "10" (remaining number after allocation is "10").

At the same time, as shown in FIG. 5(d3), the product movement information generation unit 102j generates a combination of the excess inventory store "store 001" and the inventory shortage store "store 004" in which the movement quantity is added to the number of allocations and the number of allocations. as a combination of the source store and the destination store, new product movement information including the product "○○ frame 01" and the number of movements "10" is generated.

As shown in FIG. 5(c4), the product movement information generation unit 102j determines that there are no stores with excess inventory (source stores) that do not have a post-allocation balance of "0". Finish generating new information.

Based on the product movement information generated by the product movement information generation unit 102j shown in (d3) of FIG. 01"), subtract the transfer number (transfer quantity) "15 (=5+10)" from the inventory quantity "50" of the source store code (store "Store 001") "1" to obtain the inventory quantity "35", The number of transfers (transfer quantity) "25" is subtracted from the inventory quantity "60" of the transfer source store code (store "Store 002") "2" to obtain the inventory quantity "35", and the transfer destination store code (store "Store 003") Add the transfer number (transfer quantity) "30 (= 25 + 5)" to the inventory quantity "60" of "3" to make the inventory quantity "90", and the destination store code (store "store 004") "4" '' is added to the inventory quantity "20" (movement quantity) "10" to set the inventory quantity "30", and the matrix diagram 330 shown in FIG. 3E is updated (S12).

On the other hand, the product movement information generation unit 102j displays all of the product movement information generated by the product movement information generation unit 102j shown in FIG. 5(d3) and the contents of the product movement data as shown in FIG. 3E. It is displayed in the commodity movement input content column 340 .

(D) Confirmation registration of goods movement data and issuance of movement instruction When the user wants to finally confirm the contents of the goods movement data displayed in the goods movement input content field 340, the confirmation button 354 accepts the data confirmation registration instruction. is pressed, the goods movement reception unit 102b receives the data confirmation registration instruction of the goods movement data (S08), and shifts to the movement instruction process according to the contents of the goods movement data displayed in the goods movement input content column 340. do.

If the user wants to issue a movement instruction sheet based on the contents of the merchandise movement data displayed in the commodity movement input content field 340, the user can press the print button 353 for accepting the issuance instruction of the movement instruction sheet. The issue acceptance unit 102e accepts an instruction to issue a transfer instruction, and the transfer instruction issuing unit 102f issues the transfer instruction based on the product transfer information in the product transfer data displayed in the product transfer input content column 340. (S09).

As described above, according to the system of the present invention, it is possible to easily study and simulate the movement of merchandise between stores based on the number of inventories and the number of sales. Furthermore, based on the number of sales, it is possible to automatically propose product movements that optimize the number of inventories between stores. Furthermore, it is possible to easily perform from the creation of product transfer data to the issuance of transfer instructions.

[3. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
Since this embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, it is possible to contribute to Goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

In addition, since this embodiment can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[4. Other embodiments]
Although the embodiments of the present invention have been described so far, the present invention may be implemented in various different embodiments other than the above-described embodiments within the scope of the technical idea described in the claims. is.

For example, among the processes described in the above embodiments, all or part of the processes described as being performed automatically can be manually performed, or the processes described as being performed manually can also be performed automatically by known methods.

In addition, unless otherwise specified, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configurations shown in the above documents and drawings can be changed arbitrarily.

Also, with respect to the PC 100, each component shown in the figure is functionally conceptual, and does not necessarily have to be physically configured as shown in the figure.

For example, all or any part of the processing functions provided by each device constituting the PC 100, particularly each processing function performed by the control unit, is implemented by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and is stored in each apparatus as necessary. read mechanically. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

Also, this computer program may be stored in an application program server connected to the PC 100 via any network, and it is possible to download all or part of it as required.

Also, the program for executing the processing described in the present embodiment may be stored in a non-temporary computer-readable recording medium, and may be configured as a program first product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc, etc. shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single structure, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

Further, the PC 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which arbitrary peripheral devices are connected. Also, the PC 100 may be implemented by installing software (including programs, data, etc.) that causes the PC 100 to implement the processing described in the present embodiment.

Furthermore, the specific form of distribution and integration of devices is not limited to the one shown in the figure, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

INDUSTRIAL APPLICABILITY The present invention is useful, for example, for inventory management in the retail industry that develops multiple stores such as consumer electronics mass retailers.

100 PCs
102 control unit 102a matrix creation unit 102b goods movement reception unit 102c matrix update unit 102d goods movement data generation unit 102e movement instruction issue reception unit 102f movement instruction publication unit 102g extraction attribute reception unit 102h automatic generation reception unit 102i store extraction unit 102j Product movement information generation unit 104 Communication interface unit 106 Storage unit 106a Sales data storage unit 106b Inventory data storage unit 106c Product master storage unit 106d Store master storage unit 106e Product transfer data storage unit 108 Input/output interface unit 200 Server 300 Network 400 Input device 500 output device

Claims (9)

An inventory management device comprising a control unit,
The control unit
a matrix creation means for creating a two-dimensional matrix diagram showing the number of sales and the number of inventories by store and by product based on the sales information and inventory information;
a product movement receiving means for receiving product movement information consisting of a combination of a product, a source store, a destination store, and a movement quantity;
Each time the goods movement receiving means receives the goods movement information, in the matrix diagram created by the matrix creating means, the number of stocks of the movement source store for the corresponding goods in the goods movement information received by the goods movement receiving means is calculated. matrix updating means for updating the matrix diagram by subtracting the transfer quantity and adding the transfer quantity to the stock quantity of the corresponding product at the destination store;
An inventory management device comprising: The control unit
a goods movement data creating means for updating the goods movement data by adding the goods movement information received by the goods movement receiving means to the goods movement data each time the goods movement receiving means receives the goods movement information. The inventory management device according to claim 1, wherein: The control unit
a movement instruction form issuing/receiving means for receiving an instruction to create a movement instruction form indicating the goods, the store of the source of movement, the store of the destination of movement, and the quantity of movement for each of the combinations;
movement instruction issuing means for creating a movement instruction based on the goods movement information in the goods movement data when the movement instruction issuing and receiving means receives a creation instruction;
3. The inventory management device of claim 2, further comprising: The control unit
further comprising extraction attribute reception means for receiving extraction conditions for narrowing down the products for which the matrix creation means creates the matrix diagram based on the attributes thereof,
4. The matrix drawing according to any one of claims 1 to 3, wherein said matrix creation means creates a matrix diagram in which products not conforming to said extraction conditions are excluded based on the extraction conditions received by said extraction attribute reception means. The inventory control device described in the paragraph. automatic generation receiving means for receiving an instruction to generate product movement information consisting of a combination of the product, the source shop, the destination shop, and the quantity of goods transferred;
store extracting means for extracting, by product, stores with excess inventory exceeding the excess inventory standard and stores with insufficient inventory having the inventory number below the minimum inventory standard;
The number of inventories of the stores with insufficient inventory extracted by the store extracting means is increased, and the number of inventories of the excess inventory stores extracted by the store extracting means is equal to or less than the excess inventory standard, or the excess inventory extracted by the store extracting means is increased. A combination of a source store and a destination store is selected for each product so that the inventory of the store is reduced and the inventory of the store with insufficient inventory extracted by the store extracting means satisfies the minimum inventory standard, and is selected for each combination. commodity movement information generating means for generating commodity movement information for each commodity and for each combination of a source store and a destination store by determining a movement quantity;
goods movement data creating means for creating goods movement data by collecting the goods movement information generated by the goods movement information generating means;
2. The inventory management device of claim 1, further comprising: The excess inventory standard is the sum of the number of sales, the standard inventory number by product and by store, and the excess secured inventory adjustment number by product and by store, and the minimum inventory standard is the sales volume and the product 6. The inventory management device according to claim 5, which is the total value of the reference inventory quantity for each store. The product movement information generating means, for the store of the movement source, sequentially from the overstock store with the larger excess inventory obtained by subtracting the excess inventory standard from the number of inventory among the excess inventory stores extracted by the store extraction means, With respect to the destination store, excess inventory of the source store is selected in order from the stores with insufficient inventory obtained by subtracting the number of inventories from the minimum inventory standard among the stores with insufficient inventory extracted by the store extracting means. By selecting a combination of the source store and the destination store for each product and determining the transfer quantity for each combination, by canceling out the inventory shortage at the destination store 7. The inventory management device according to claim 5 or 6, wherein the product movement information is generated for each combination of the store of the movement source and the store of the movement destination. An inventory management method executed in an inventory management device comprising a control unit,
executed by the control unit;
a matrix creation step of creating a two-dimensional matrix diagram displaying the number of sales and the number of inventories by store and by product based on the sales information and inventory information;
a product transfer reception step for receiving product transfer information consisting of a combination of product, source store, destination store, and transfer quantity;
Each time the merchandise movement information is received in the merchandise movement reception step, in the matrix diagram created in the matrix creation step, the number of stocks at the source store for the corresponding merchandise in the merchandise movement information received in the merchandise movement reception step is calculated. a matrix update step of updating the matrix diagram by subtracting the transfer quantity and adding the transfer quantity to the stock quantity of the corresponding product at the destination store;
An inventory management method comprising: An inventory management program to be executed by an inventory management device having a control unit,
for causing the control unit to execute
a matrix creation step of creating a two-dimensional matrix diagram displaying the number of sales and the number of inventories by store and by product based on the sales information and inventory information;
a product transfer reception step for receiving product transfer information consisting of a combination of product, source store, destination store, and transfer quantity;
Each time the merchandise movement information is received in the merchandise movement reception step, in the matrix diagram created in the matrix creation step, the number of stocks at the source store for the corresponding merchandise in the merchandise movement information received in the merchandise movement reception step is calculated. a matrix update step of updating the matrix diagram by subtracting the transfer quantity and adding the transfer quantity to the stock quantity of the corresponding product at the destination store;
An inventory management program comprising:

Images