Inventory management device, inventory management method, and inventory management program

Abstract

We provide inventory management systems and other devices that reduce unnecessary tasks such as internal negotiations, promote sales activities by each department, and improve operational efficiency. [Solution] An inventory management device equipped with a control unit, the control unit registers sales data that associates sales performance information of products, departmental information, and sales quantities, and creates an inventory allocation master for allocating products stored in a purchasing warehouse to sales warehouses based on a warehouse master representing warehouses managed by departments, a warehouse linkage master linking warehouses to purchasing warehouses and sales warehouses, and sales data, and displays a screen representing the inventory allocation master.

Description

Technical Field

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

Background Art

[0002] Regarding inventory management, for example, in Patent Document 1, a configuration is disclosed that enables calculation of the sales rates of products at a representative store and affiliated stores based on the sales results of products at the representative store and the sales results of products at the affiliated stores.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, when a product is a promotional product such as a limited product or a campaign product, competition between stores may occur. In this case, unnecessary operations such as in-house negotiations may occur.

[0005] The present invention has been made in view of the above problems, and an object thereof is to provide an inventory management device, an inventory management method, and an inventory management program that can reduce unnecessary operations such as in-house negotiations, promote promotional activities for each department, and improve business efficiency.

Means for Solving the Problems

[0006] To solve the above-mentioned problems and achieve the objective, the inventory management device according to the present invention is an inventory management device comprising a control unit, the control unit comprising: a reception unit that registers sales data that associates information on product sales performance, department information, and the number of sales; a warehouse master representing warehouses managed by the department; a warehouse linking master that links the warehouses to purchasing warehouses and sales warehouses; and a master creation unit that creates an inventory allocation master for allocating the products stored in the purchasing warehouses to the sales warehouses based on the sales data, and displays a screen representing the inventory allocation master.

[0007] Furthermore, in the inventory management device according to the present invention, the master creation unit is characterized in that it creates the inventory allocation master based on a product master indicating whether or not a product is subject to allocation, the warehouse master, the warehouse linkage master, and the sales data.

[0008] Furthermore, in the inventory management device according to the present invention, the inventory allocation master is characterized in that it is a master that sets records associating the start date of application, information about the sales warehouse, information about the purchasing warehouse, information about the product, and inventory ratios which are coefficients for allocating the product stored in the purchasing warehouse to each sales warehouse.

[0009] Furthermore, in the inventory management device according to the present invention, the inventory ratio is characterized by being the number obtained by dividing the sales figures for each department by the total sales figures within a set period.

[0010] Furthermore, in the inventory management device according to the present invention, the master creation unit is characterized in that it allocates the inventory quantity according to the sales warehouse and updates the current inventory data based on the inventory allocation master, information about the warehouse, information about the product, and current inventory data that associates the inventory quantity.

[0011] Furthermore, in the inventory management device according to the present invention, the product is characterized in that it is a promotional item.

[0012] Furthermore, the inventory management method according to the present invention is an inventory management method to be executed by an inventory management device equipped with a control unit, and is characterized in that the control unit includes: a reception step in which information relating to the sales performance of products, information relating to departments, and sales data associating sales quantities; a master creation step in which a warehouse master representing warehouses managed by the department, a warehouse linkage master linking the warehouses to purchasing warehouses and sales warehouses, and an inventory allocation master for allocating the products stored in the purchasing warehouses to the sales warehouses based on the sales data, and displays a screen representing the inventory allocation master.

[0013] Furthermore, the inventory management program according to the present invention is an inventory management program to be executed by an inventory management device equipped with a control unit, characterized in that the control unit executes: a reception step of registering sales data that associates information on the sales performance of products, information on departments, and the number of sales; a master creation step of creating an inventory allocation master for allocating the products stored in the purchasing warehouses to the respective sales warehouses based on a warehouse master representing warehouses managed by the departments, a warehouse linkage master linking the warehouses to purchasing warehouses and sales warehouses, and the display of a screen representing the inventory allocation master. [Effects of the Invention]

[0014] This invention has the effect of reducing unnecessary tasks such as internal negotiations, promoting sales activities in each department, and improving operational efficiency. [Brief explanation of the drawing]

[0015] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of the inventory management device in this embodiment. [Figure 2] Figure 2 is a flowchart showing an example of the processing performed by the inventory management device in this embodiment. [Figure 3] Figure 3 shows an example of the processing performed by the inventory management device in this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of the processing of the inventory management device in the present embodiment. [Figure 5] FIG. 5 is a diagram showing an example of the processing of the inventory management device in the present embodiment. [Figure 6] FIG. 6 is a diagram showing an example of the processing of the inventory management device in the present embodiment. [Figure 7] FIG. 7 is a diagram showing an example of the processing of the inventory management device in the present embodiment. [Figure 8] FIG. 8 is a diagram showing an example of the processing of the inventory management device in the present embodiment. [Figure 9] FIG. 9 is a diagram showing an example of the processing of the inventory management device in the present embodiment. [Figure 10] FIG. 10 is a diagram showing an example of the processing of the inventory management device in the present embodiment. [Figure 11] FIG. 11 is a diagram showing an example of the processing of the inventory management device in the present embodiment.

Embodiments for Carrying Out the Invention

[0016] Hereinafter, embodiments of an inventory management device, an inventory management method, and an inventory management program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited by the present embodiment.

[0017] [1. Overview] First, the overview of the present invention will be described.

[0018] <F For example, when a product is a promotional product such as a limited product or a campaign product, when the promotional product is handled by multiple departments, there may be competition between departments. In this case, unnecessary operations such as internal negotiations within the company will occur. Therefore, it is required to reduce internal negotiations as much as possible and enable each department to promote promotional activities.

[0019] Therefore, in this embodiment, a system is provided that automatically allocates the relevant products to the logical warehouses of each department based on the allocation master, by creating an allocation master based on the sales performance of promotional products.

[0020] In this embodiment, although there are actual warehouses for each business unit, the system manages the warehouse information separately as logical warehouses, and inventory management is performed separately for each business unit. For example, if the actual warehouse is "Factory A," the system manages it separately as logical warehouses for each business unit "Department A," "Department B," and "Department C," respectively, and inventory management is performed separately for each business unit.

[0021] [2. Structure] An example of the configuration of the inventory management device 100 according to this embodiment will be described with reference to Figure 1, etc. Figure 1 is a block diagram showing an example of the configuration of the inventory management device 100.

[0022] The inventory management device 100 is built on a commercially available desktop personal computer. However, the inventory management device 100 is not limited to being built on a stationary information processing device such as a desktop personal computer; it may also be built on a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0023] The inventory management device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the inventory management device 100 is connected to communicate via any communication path.

[0024] The communication interface unit 104 connects the inventory management device 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 the function of communicating data with other devices via a communication line. Here, the network 300 has the function of connecting the inventory management device 100 and the server 200 so that they can communicate with each other, and is, for example, the internet or a LAN (Local Area Network). The data stored in the storage unit 106 may be stored in, for example, the server 200.

[0025] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or mouse 112.

[0026] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory 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.

[0027] Furthermore, sales data 106a is registered in the memory unit 106. For example, the memory unit 106 registers sales data 106a, which includes information about the sales performance of a product, information about the department, and the number of sales (quantity). For example, the product may be a promotional product such as a limited edition product or a product for a campaign. Information about the sales performance of a product may include the sales number, sales category, sales date, person in charge, delivery destination, and product information. Information about the product may include a product code to identify the product. Information about the department may include a department code to identify the department.

[0028] Furthermore, the storage unit 106 includes a product master 106b. For example, the product master 106b is a master that indicates whether or not a product is subject to apportionment. Specifically, the product master 106b is a master that sets records that associate product information (product code) with an apportionment flag. The apportionment flag represents, for example, "1" if the product is subject to apportionment, and "0" if the product is not subject to apportionment.

[0029] Furthermore, the storage unit 106 includes a warehouse master 106c. For example, the warehouse master 106c represents warehouses managed by a department. Specifically, the warehouse master 106c is a master that sets records associating warehouse information and department information (department code). For example, warehouse information includes a warehouse code used to identify a warehouse. Thus, the warehouse master 106c registers which department manages each warehouse code.

[0030] Furthermore, the storage unit 106 is equipped with a warehouse linking master 106d. In this embodiment, although there are actual warehouses for each business unit (department), the system manages the warehouse information separately as logical warehouses. For example, in this embodiment, the warehouse linking master 106d links warehouses to purchasing warehouses and sales warehouses as warehouse information. Specifically, the warehouse linking master 106d is a master that sets records that associate information about purchasing warehouses and information about sales warehouses. Information about purchasing warehouses includes a purchasing warehouse code to identify the purchasing warehouse. Information about sales warehouses includes a sales warehouse code to identify the sales warehouse. In this way, the warehouse linking master 106d registers the source and destination of the linking by registering the warehouse code. That is, the warehouse linking master 106d registers the code of the purchasing warehouse as the warehouse from which goods are purchased, and the code of the sales warehouse as the warehouse from which goods are sold.

[0031] Furthermore, the inventory allocation master 106e is registered in the storage unit 106. The inventory allocation master 106e is a master for allocating goods stored in the purchasing warehouse to each sales warehouse. For example, the inventory allocation master 106e in the storage unit 106 is registered with the application start date, sales warehouse information (sales warehouse code), purchasing warehouse information (purchasing warehouse code), product information (product code), and inventory ratio associated with it. In other words, the inventory allocation master 106e is a master with records set to associate the application start date, sales warehouse information (sales warehouse code), purchasing warehouse information (purchasing warehouse code), product information (product code), and inventory ratio. The inventory ratio is a coefficient for allocating goods stored in the purchasing warehouse (purchasing department) to each sales warehouse (sales department). For example, the inventory ratio is the number obtained by dividing the sales quantity for each department by the total sales quantity within the set period.

[0032] Furthermore, the storage unit 106 stores current inventory data 106f. For example, the storage unit 106 stores current inventory data 106f, which includes information about the warehouse (warehouse code), information about the product (product code), and inventory quantity, all associated with each other.

[0033] The control unit 102 is a CPU or the like that comprehensively controls the inventory management device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. Functionally, the control unit 102 comprises a reception unit 102a and a master creation unit 102b.

[0034] The reception unit 102a registers the sales data 106a in the storage unit 106. For example, the reception unit 102a displays the sales input screen and receives the sales input information, thereby registering the sales data 106a in the storage unit 106, associating it with information about the sales performance of the product (sales number, sales category, sales date, person in charge, delivery destination, product information (product code)), department information (department code), and the number of sales (quantity).

[0035] The master creation unit 102b creates an inventory allocation master 106e based on the product master 106b, warehouse master 106c, warehouse linkage master 106d, and sales data 106a, to allocate products stored in the purchasing warehouse to sales warehouses, and displays a screen representing the inventory allocation master 106e on the output device 114 (monitor). The master creation unit 102b also allocates the inventory quantity to sales warehouses based on the inventory allocation master 106e and current inventory data 106f, and updates the current inventory data 106f.

[0036] [3. Specific examples of processing] A specific example of the processing (inventory management processing) of the inventory management device of this embodiment will be described with reference to Figures 2 to 11.

[0037] [3.1 Inventory Management Process] Now, with reference to Figure 2, an example of the processing of the inventory management device in this embodiment will be described. Figure 2 is a flowchart showing an example of the processing of the inventory management device 100 in this embodiment.

[0038] First, the reception unit 102a receives sales input information (step S101). For example, the reception unit 102a displays the sales input screen and receives sales input information. At this time, suppose the user uses the input device 112 to input information about the sales performance of the product (sales number, sales category, sales date, person in charge, delivery destination, product information (product code)), department information (department code), and the number of sales (quantity) on the screen. In this case, the reception unit 102a registers the information about the sales performance of the product (sales number, sales category, sales date, person in charge, delivery destination, product information (product code)), department information (department code), and the number of sales (quantity) as sales data 106a in the storage unit 106.

[0039] Next, the master creation unit 102b creates an inventory allocation master (step S102). For example, the master creation unit 102b calculates the inventory ratio based on the product master 106b, the warehouse master 106c, the warehouse linkage master 106d, and the sales data 106a. Then, the master creation unit 102b creates an inventory allocation master 106e to allocate products stored in the purchasing warehouse to each sales warehouse, and displays a screen representing the inventory allocation master 106e.

[0040] Next, the master creation unit 102b updates the current inventory data (step S103). For example, the master creation unit 102b allocates the inventory quantity by sales warehouse based on the inventory allocation master 106e and the current inventory data 106f, and updates the current inventory data 106f.

[0041] [3.2 Specific Examples of Inventory Management Processes] Here, with reference to Figures 3 to 11, a specific example of the processing of the inventory management device in this embodiment will be described. Figures 3 to 11 are diagrams showing an example of the processing of the inventory management device in this embodiment.

[0042] As shown in Figure 3, in this embodiment, sales data is registered. For example, the reception unit 102a displays a sales input screen and receives sales input information, and the user uses the input device 112 to input the sales number "MT001", sales category "Inventory Sales", department code "B001", sales date "2022 / 7 / 10", person in charge "TAN001", delivery destination "NOU01", product code "SH01", and the quantity sold "50kg", etc., onto the screen. In this case, the reception unit 102a registers the sales data 106a in the storage unit 106, associating it with information about the sales performance of the product (sales number "MT001", sales category "Inventory Sales", sales date "2022 / 7 / 10", person in charge "TAN001", delivery destination "NOU01", product code "SH01", etc.), information about the department (department code "B001"), and the quantity sold (quantity "50kg"), etc. For example, if the product with department code "B001" is "ammonia," then the sales quantity is entered as weight, such as "50 kg," and registered in the memory unit 106.

[0043] For example, suppose a user uses the input device 112 to input the sales number "MT001", sales category "Inventory Sales", department code "B001", sales date "2022 / 7 / 10", person in charge "TAN001", delivery destination "NOU01", product code "SH02", and quantity "10 cases" into the screen. In this case, the reception unit 102a registers the sales data 106a in the storage unit 106, associating it with information about the sales performance of the product (sales number "MT001", sales category "Inventory Sales", sales date "2022 / 7 / 10", person in charge "TAN001", delivery destination "NOU01", product code "SH02", etc.), information about the department (department code "B001"), and the number of cases sold (quantity "10 cases"). For example, if the product with department code "B002" is "nitric acid," then the sales quantity is entered as a number, such as "10 cases," and registered in the memory unit 106.

[0044] Similarly, for sales entries related to product code "SH01", the user uses the input device 112 to input the sales number, sales category, department code, sales date, person in charge, delivery destination, product code, sales quantity, etc., on the screen, and the reception unit 102a registers these as sales data 106a in the storage unit 106.

[0045] For example, suppose a user uses the input device 112 to input the sales number "MT002", sales category "Inventory Sales", department code "B002", sales date "2022 / 7 / 8", person in charge "TAN001", delivery destination "NOU02", product code "SH01", and the quantity sold "30kg" into the screen. In this case, the reception unit 102a registers the sales data 106a in the storage unit 106, associating it with information about the sales performance of the product (sales number "MT002", sales category "Inventory Sales", sales date "2022 / 7 / 8", person in charge "TAN001", delivery destination "NOU02", product code "SH01", etc.), information about the department (department code "B002"), and the quantity sold (quantity "30kg").

[0046] Furthermore, suppose the user uses the input device 112 to input the sales number "MT003", sales category "Inventory Sales", department code "B001", sales date "2022 / 7 / 20", person in charge "TAN001", delivery destination "NOU01", product code "SH01", and the quantity sold "20kg" into the screen. In this case, the reception unit 102a registers the sales data 106a in the storage unit 106, associating it with information regarding the sales performance of the product (sales number "MT003", sales category "Inventory Sales", sales date "2022 / 7 / 20", person in charge "TAN001", delivery destination "NOU01", product code "SH01", etc.), information regarding the department (department code "B001"), and the quantity sold (quantity "20kg").

[0047] Furthermore, suppose the user uses the input device 112 to input the sales number "MT004", sales category "Inventory Sales", department code "B003", sales date "2022 / 7 / 22", person in charge "TAN001", delivery destination "NOU01", product code "SH01", and the quantity sold "10kg" into the screen. In this case, the reception unit 102a registers the sales data 106a in the storage unit 106, associating it with information regarding the sales performance of the product (sales number "MT004", sales category "Inventory Sales", sales date "2022 / 7 / 22", person in charge "TAN001", delivery destination "NOU01", product code "SH01", etc.), information regarding the department (department code "B003"), and the quantity sold (quantity "10kg").

[0048] Furthermore, suppose the user uses the input device 112 to input the sales number "MT005", sales category "Direct Delivery", department code "B003", sales date "2022 / 7 / 29", person in charge "TAN001", delivery destination "NOU01", product code "SH01", and the quantity sold "10kg" into the screen. In this case, the reception unit 102a registers the sales data 106a in the storage unit 106, associating it with information regarding the sales performance of the product (sales number "MT005", sales category "Direct Delivery", sales date "2022 / 7 / 29", person in charge "TAN001", delivery destination "NOU01", product code "SH01", etc.), information regarding the department (department code "B003"), and the quantity sold (quantity "10kg").

[0049] Similarly, for sales entries related to product codes "SH02," "SH04," and "SH05," the user uses the input device 112 to enter the sales number, sales category, department code, sales date, person in charge, delivery destination, product code, and sales quantity on the screen, and the reception unit 102a registers these as sales data 106a in the storage unit 106.

[0050] Here, as shown in Figure 4, for example, in product master 106b, the allocation target flag for product code "SH01" is registered as "1", indicating that the product is subject to allocation, and the allocation target flag for product code "SH02" is registered as "0", indicating that the product is subject to allocation. In other words, the product with product code "SH01" is subject to allocation.

[0051] Furthermore, as shown in Figure 5, for example, the warehouse master 106c has department codes "B001", "B002", "B003", and "B004" registered for each warehouse code "A_B001", "A_B002", "A_B003", and "A_B004". In other words, warehouse codes "A_B001", "A_B002", "A_B003", and "A_B004" are managed in the departments of department codes "B001", "B002", "B003", and "B004", respectively.

[0052] Furthermore, as shown in Figure 6, for example, the warehouse linkage master 106d has the code "A_B004" registered as a warehouse for purchasing goods, and the codes "A_B001", "A_B002", and "A_B003" registered as warehouses for selling goods. In other words, the warehouse linkage master 106d links warehouses to the code "A_B004" for purchasing warehouses and the codes "A_B001", "A_B002", and "A_B003" for selling warehouses.

[0053] Next, in this embodiment, an inventory allocation master is created. First, the master creation unit 102b displays a list screen as shown in Figure 7. For example, on the list screen, the master creation unit 102b displays an input field where product codes representing products can be entered sequentially, an input field for entering the implementation date as a set period, an input field for entering the application start date, an input field for entering the code of the purchasing warehouse, and display buttons "Set Initial Value" and "Register".

[0054] For example, suppose a user uses the input device 112 to enter only the product code "SH01" in the product input field on the list screen, enters "2022 / 7 / 1" to "2022 / 7 / 31" in the implementation date input field, enters "2023 / 4 / 1" in the application start date input field, enters the supplier warehouse code "A_B004" in the supplier warehouse input field, and presses the display button "Set Initial Values". At this time, the master creation unit 102b creates the inventory allocation master 106e based on the product master 106b, warehouse master 106c, warehouse linkage master 106d, and sales data 106a, and displays a list screen as shown in Figure 8 as the screen representing the inventory allocation master 106e.

[0055] As shown in Figure 8, for example, a display field representing the inventory allocation master 106e is added to the list screen in Figure 7. Specifically, in the first row of the display field representing the inventory allocation master 106e, the effective start date "2023 / 4 / 1", the sales warehouse code "A_B001", the purchasing warehouse code "A_B004", the product code "SH01", and the inventory ratio "0.7" are displayed, corresponding to the row number "1" representing the first row. In addition, in the second row of the display field, the effective start date "2023 / 4 / 1", the sales warehouse code "A_B002", the purchasing warehouse code "A_B004", the product code "SH01", and the inventory ratio "0.2" are displayed, corresponding to the row number "2" representing the second row. Additionally, in the third row of the display area, the effective date "2023 / 4 / 1", sales warehouse code "A_B003", procurement warehouse code "A_B004", product code "SH01", and inventory percentage "0.1" are displayed, corresponding to the row number "3" that represents the third row.

[0056] The display field representing the inventory allocation master 106e is editable. For example, if a user selects the first row of the display field using the input device 112, the master creation unit 102b displays an editing screen as shown in Figure 9. For example, on the editing screen, the master creation unit 102b displays the row number "1", the start date "2023 / 4 / 1", the sales warehouse code "A_B001", the purchase warehouse code "A_B004", the product code "SH01", the inventory ratio "0.7", and the display button "Register".

[0057] For example, a user can use the input device 112 to specify on the editing screen that the product with product code "SH01" is "ammonia". For example, if a user uses the input device 112 to press the display button "Register" on the editing screen, the master creation unit 102b reflects the content edited on the editing screen in the first row of the display column representing the inventory allocation master 106e on the list screen in Figure 8.

[0058] Figure 10 shows the process by which the inventory allocation master 106e in the list screen of Figure 8 is created.

[0059] When a user presses the display button "Set Initial Value" using the input device 112, the master creation unit 102b first retrieves the target data based on the product master 106b, warehouse master 106c, warehouse linkage master 106d, and sales data 106a. For example, in the product master 106b, the product with product code "SH01" is subject to apportionment, so the master creation unit 102b retrieves sales data 106a from the storage unit 106 that has the product code "SH01", a sales date within the range of implementation dates "2022 / 7 / 1" to "2022 / 7 / 31", and a sales category of "Inventory Sales". However, if the sales category is "Direct Shipment", it is not a record of selling purchased goods, so the master creation unit 102b excludes sales data 106a with a sales category of "Direct Shipment".

[0060] As shown in Figure 10, for example, the master data creation unit 102b acquires data from the storage unit 106 that associates sales data 106a with information about the sales performance of the product (sales number "MT001", sales category "Inventory Sales", sales date "2022 / 7 / 10", person in charge "TAN001", delivery destination "NOU01", product code "SH01", etc.), information about the department (department code "B001"), and the number of units sold (quantity "50kg").

[0061] Furthermore, the master data creation unit 102b acquires data from the storage unit 106 as sales data 106a, which includes information about the sales performance of the product (sales number "MT002", sales category "Inventory Sales", sales date "2022 / 7 / 8", person in charge "TAN001", delivery destination "NOU02", product code "SH01", etc.), information about the department (department code "B002"), and the number of units sold (quantity "30kg").

[0062] Furthermore, the master data creation unit 102b acquires data from the storage unit 106 as sales data 106a, which includes information about the sales performance of the product (sales number "MT003", sales category "Inventory Sales", sales date "2022 / 7 / 20", person in charge "TAN001", delivery destination "NOU01", product code "SH01", etc.), information about the department (department code "B001"), and the number of units sold (quantity "20kg").

[0063] Furthermore, the master data creation unit 102b acquires data from the storage unit 106 as sales data 106a, which includes information about the sales performance of the product (sales number "MT004", sales category "Inventory Sales", sales date "2022 / 7 / 22", person in charge "TAN001", delivery destination "NOU01", product code "SH01", etc.), information about the department (department code "B003"), and the number of units sold (quantity "10kg").

[0064] Here, the master data creation unit 102b calculates the inventory ratio as the ratio of sales figures (quantities) by department. The inventory ratio is the number obtained by dividing the sales figures by department by the total sales figures within the set period (within the range of implementation dates "2022 / 7 / 1" to "2022 / 7 / 31"). In the example shown in Figure 10, the sales figures within the set period (within the range of implementation dates "2022 / 7 / 1" to "2022 / 7 / 31") are "50kg", "30kg", "20kg", and "10kg".

[0065] Therefore, for the department with department code "B001", the sales figures for the products are "50kg" and "20kg". Thus, the inventory ratio is (50+20)÷(50+30+20+10)=0.7.

[0066] Furthermore, for the department with department code "B002," the sales record for the product shows a sales quantity of "30 kg." Therefore, the inventory ratio is 30 ÷ (50 + 30 + 20 + 10) = 0.3.

[0067] Furthermore, for the department with department code "B003," the sales record for the product shows a sales quantity of "10 kg." Therefore, the inventory ratio is 10 ÷ (50 + 30 + 20 + 10) = 0.1.

[0068] Next, the master creation unit 102b retrieves from the storage unit 106 the warehouse linkage master 106d that has a registered code matching the procurement warehouse code "A_B004" entered in the list screen, and retrieves the sales warehouse codes "A_B001", "A_B002", and "A_B003" that are associated with the procurement warehouse code "A_B004" in the retrieved warehouse linkage master 106d. Subsequently, the master creation unit 102b uses the retrieved sales warehouse codes "A_B001", "A_B002", and "A_B003" to identify the department codes "B001", "B002", and "B003", which are the departments that manage the warehouses, from the warehouse master 106c.

[0069] The master creation unit 102b then displays data in the first row of the display field representing the inventory allocation master 106e on the list screen in Figure 8, associating the start date "2023 / 4 / 1", the sales warehouse code "A_B001", the purchasing warehouse code "A_B004", the product code "SH01", and the inventory ratio "0.7". The master creation unit 102b also displays data in the second row of the display field representing the inventory allocation master 106e on the list screen in Figure 8, associating the start date "2023 / 4 / 1", the sales warehouse code "A_B002", the purchasing warehouse code "A_B004", the product code "SH01", and the inventory ratio "0.2". Furthermore, the master creation unit 102b displays data on the list screen in the third row of the display column representing the inventory allocation master 106e in Figure 8, associating the start date of application "2023 / 4 / 1", the sales warehouse code "A_B003", the purchase warehouse code "A_B004", the product code "SH01", and the inventory ratio "0.1".

[0070] Here, for example, suppose the user uses the input device 112 to press the display button "Register" on the list screen in Figure 8. At this time, the master creation unit 102b displays a list screen as shown in Figure 11, which represents the inventory allocation process.

[0071] As shown in Figure 11, the master creation unit 102b displays the procurement warehouse code "A_B004", the product code "SH01", and the display button "Register" on the list screen.

[0072] Figure 11 also shows the process by which inventory quantities are allocated to each sales warehouse.

[0073] For example, as shown in Figure 11, the storage unit 106 has registered current inventory data 106f, associated with warehouse code "A_B004", product code "SH01", and inventory quantity "100kg". The storage unit 106 also has registered current inventory data 106f, associated with warehouse code "A_B004", product code "SH02", and inventory quantity "40kg". Furthermore, the storage unit 106 also has registered current inventory data 106f, associated with warehouse code "A_B003", product code "SH01", and inventory quantity "500kg".

[0074] When a user presses the "Register" button using the input device 112, the system retrieves the target data based on the inventory allocation master 106e and the current inventory data 106f. For example, the master creation unit 102b retrieves the current inventory data 106f from the storage unit 106, where the warehouse code is "A_B004" and the product code is "SH01". Then, the master creation unit 102b allocates the inventory quantity by sales warehouse based on the retrieved current inventory data 106f and the inventory allocation master 106e, which has a purchasing warehouse code that matches the warehouse code "A_B004" in the retrieved current inventory data 106f, and recreates the current inventory data 106f. In other words, the master creation unit 102b updates the current inventory data 106f.

[0075] Specifically, first, the master creation unit 102b registers current inventory data 106f, associated with warehouse code "A_B001", product code "SH01", and inventory quantity "70kg", etc., into the storage unit 106. The master creation unit 102b then registers current inventory data 106f, associated with warehouse code "A_B002", product code "SH01", and inventory quantity "20kg", etc., into the storage unit 106. The master creation unit 102b then registers current inventory data 106f, associated with warehouse code "A_B003", product code "SH01", and inventory quantity "10kg", etc., into the storage unit 106. Finally, the master creation unit 102b deletes current inventory data 106f, associated with warehouse code "A_B004", product code "SH01", and inventory quantity "100kg", etc., from the storage unit 106. As a result, the master data creation unit 102b updates the current inventory data 106f.

[0076] As described above, according to this embodiment, the actual warehouses for each business unit (department) are managed in the system as logical warehouses linked to purchasing warehouses and sales warehouses, and an allocation master is created based on the sales performance of the products, and the relevant products are automatically allocated to the logical warehouses of each department based on the allocation master. For this reason, according to this embodiment, for example, if the product is a promotional product such as a limited edition product or a product for a campaign, unnecessary tasks such as internal negotiations can be reduced, promotional activities can be promoted by each department, and the efficiency of operations can be improved.

[0077] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions within companies, thereby enabling contributions to SDGs Goals 8 and 9.

[0078] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0079] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[0080] [5. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

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

[0082] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0083] Furthermore, with respect to the inventory management device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

[0084] For example, the processing functions of the inventory management device 100, particularly those performed by the control unit, may be implemented entirely or partially by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the inventory management device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) records a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0085] Furthermore, this computer program may be stored on an application program server connected to the inventory management device 100 via any network, and it is possible to download all or part of it as needed.

[0086] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, 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-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0087] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0088] The various databases stored in the memory unit are storage means such as RAM, ROM, other memory devices, hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0089] Furthermore, the inventory management device 100 may be configured as an information processing device such as a known personal computer or workstation, or as an information processing device to which any peripheral devices are connected. Alternatively, the inventory management device 100 may be implemented by installing software (including programs or data, etc.) on the device that enables the processing described in this embodiment.

[0090] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]

[0091] This invention is useful in the logistics industry, for example, in industries that handle purchased goods, manufactured goods, etc. [Explanation of symbols]

[0092] 100 Inventory Management Devices 102 Control Unit 102a Reception Desk 102b Master Creation Department 104 Communication Interface Section 106 Storage section 106a Sales Data 106b Product Master 106c Warehouse Master 106d Warehouse Linking Master 106e Inventory Allocation Master 106f Current Inventory Data 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks

Claims

1. An inventory management device equipped with a control unit, The control unit, A reception department that registers sales data that links product sales performance, departmental information, and sales figures, A master creation unit creates an inventory allocation master for allocating the goods stored in the purchasing warehouse to the respective sales warehouses, based on a warehouse master representing the warehouses managed by the department, a warehouse linkage master linking the warehouses to purchasing warehouses and sales warehouses, and the sales data, and displays a screen representing the inventory allocation master. An inventory management device characterized by being equipped with the following features.

2. The aforementioned master creation unit, Based on a product master indicating whether or not a product is subject to apportionment, the warehouse master, the warehouse linkage master, and the sales data, the inventory apportionment master is created. The inventory management device according to claim 1, characterized by the following:

3. The aforementioned inventory allocation master is a master that sets up records that associate the start date of application, information about the sales warehouse, information about the purchasing warehouse, information about the product, and inventory ratios, which are coefficients for allocating the products stored in the purchasing warehouse to each sales warehouse. An inventory management device according to claim 1 or 2, characterized by the above.

4. The aforementioned inventory ratio is the number obtained by dividing the sales volume for each department by the total sales volume during the set period. The inventory management device according to claim 3, characterized by the following:

5. The aforementioned master creation unit, Based on the inventory allocation master, the warehouse information, the product information, and the current inventory data which associates the inventory quantity, the inventory quantity is allocated according to the sales warehouse, and the current inventory data is updated. An inventory management device according to claim 1 or 2, characterized by the above.

6. The aforementioned product is a promotional item. An inventory management device according to claim 1 or 2, characterized by the above.

7. An inventory management method to be executed by an inventory management device equipped with a control unit, In the control unit, A reception step for registering sales data that associates information on product sales performance, departmental information, and sales figures, A master creation step involves creating an inventory allocation master for allocating the goods stored in the purchasing warehouse to the respective sales warehouses, based on a warehouse master representing the warehouses managed by the department, a warehouse linkage master linking the warehouses to purchasing warehouses and sales warehouses, and the sales data, and displaying a screen representing the inventory allocation master. An inventory management method characterized by including [this].

8. An inventory management program to be executed by an inventory management device equipped with a control unit, In the control unit, A reception step for registering sales data that associates information on product sales performance, departmental information, and sales figures, A master creation step involves creating an inventory allocation master for allocating the goods stored in the purchasing warehouse to the respective sales warehouses, based on a warehouse master representing the warehouses managed by the department, a warehouse linkage master linking the warehouses to purchasing warehouses and sales warehouses, and the sales data, and displaying a screen representing the inventory allocation master. An inventory management program characterized by its ability to execute certain actions.

Images