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

Description

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

For example, manufacturing companies that have their own warehouses manage planned inventory. A conventional system for managing planned inventory is disclosed in, for example, Patent Document 1.

JP 2019-45986 A

However, Patent Document 1 does not state anything about how precise planned inventory management can facilitate decisions on adjusting inventory management operations.

The present invention has been made in consideration of the above, and aims to provide an inventory management device, an inventory management method, and an inventory management program that can easily make adjustment decisions for inventory management operations by precisely performing planned inventory management.

In order to solve the above-mentioned problems and achieve the object, the present invention provides an inventory management device equipped with a control unit, the control unit being configured to be able to access a master that registers the order point and maximum inventory quantity for each product for a target warehouse, raw material ordering information, production schedule information, raw material usage schedule information, product shipping schedule information, and current inventory information, and is characterized by having a receipt/delivery schedule information output means that references the master based on the raw material ordering information, production schedule information, raw material usage schedule information, product shipping schedule information, and current inventory information, and displays on a display unit receipt/delivery schedule information including the scheduled receipt/delivery date, scheduled receipt quantity, scheduled delivery quantity, and scheduled inventory quantity for products that fall outside the range of the optimal inventory standard during the period of a specified scheduled receipt/delivery date.

According to one aspect of the present invention, the optimal inventory standard may include a positive planned inventory quantity.

According to one aspect of the present invention, the optimal inventory standard may include a planned inventory quantity being equal to or greater than the order point.

According to one aspect of the present invention, the optimal inventory standard may include the planned inventory quantity being equal to or less than the maximum inventory quantity.

According to one aspect of the present invention, the product may include a fluid.

In order to solve the above-mentioned problems and achieve the objective, the present invention provides an inventory management method executed by an information processing device equipped with a control unit, the control unit being configured to be able to access a master in which the order point and maximum inventory quantity for each product are registered for a target warehouse, as well as raw material ordering information, production schedule information, raw material usage schedule information, product shipping schedule information, and current inventory information, and the control unit includes a receipt/delivery schedule information output process executed based on the raw material ordering information, production schedule information, raw material usage schedule information, product shipping schedule information, and current inventory information, and referring to the master, displays receipt/delivery schedule information including the scheduled receipt/delivery date, scheduled receipt quantity, scheduled shipment quantity, and scheduled inventory quantity on a display unit for products that fall outside the range of the optimal inventory standard during a period of a specified scheduled receipt/delivery date, based on the raw material ordering information, the scheduled production schedule information, the scheduled raw material usage information, the scheduled product shipping information, and the current inventory information.

In order to solve the above-mentioned problems and achieve the object, the present invention is an inventory management program to be executed by an information processing device having a control unit, the control unit being configured to be able to access a master in which the order point and maximum inventory quantity for each product are registered for a target warehouse, as well as raw material ordering information, production schedule information, raw material usage schedule information, product shipping schedule information, and current inventory information, and the control unit is characterized in that the inventory management program executes a receipt/delivery schedule information output process that references the master and displays receipt/delivery schedule information including the scheduled receipt/delivery date, scheduled receipt quantity, scheduled shipment quantity, and scheduled inventory quantity on a display unit for products that fall outside the range of the optimal inventory standard during a period of a specified scheduled receipt/delivery date, based on the raw material ordering information, the scheduled production schedule information, the scheduled raw material usage information, the scheduled product shipping information, and the current inventory information.

The present invention has the effect of making it easier to make adjustment decisions regarding inventory management operations by performing precise planned inventory management.

FIG. 1 is a diagram for explaining an example of surplus inventory (an example of tank inventory overflowing) caused by a change in a production plan. FIG. 2 is a block diagram showing an example of the configuration of the inventory management device according to the present embodiment. FIG. 3 is a flow diagram showing an example of the overall process of the inventory management device according to the present embodiment. FIG. 4 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 5 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 6 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 7 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 8 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 9 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 10 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 11 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 12 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 13 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment. FIG. 14 is a diagram for explaining a specific example of the process of the inventory management device according to the present embodiment.

The embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to this embodiment.

[1. Overview]
For example, manufacturers that have their own warehouses monitor their inventory status on a daily basis and manage whether the quantity is appropriate. In the case of finished products (sales items), they need to manage whether they have sales inventory that can always be shipped out within the amount that can be placed in the warehouse, and in the case of raw materials, they need to manage whether they have the amount required at the time needed to make the product. At the same time, they need to check whether there is surplus inventory (is there warehouse space, is the inventory in a form that can fit in storage tanks). In addition, this inventory management does not only involve understanding current inventory, but also understanding planned inventory in advance, which allows them to carry out improvement activities such as revising procurement plans and shipping plans.

However, in the past, when managing planned inventory, the only thing that was done was to determine when and how much of the planned inventory would be insufficient. Therefore, the person in charge would use that information to re-search the planned inventory before and after, and make adjustments to their work after understanding the planned inventory trends.

In addition, previously, planned inventory management was not performed from the perspective of the maintainable inventory of fluids (tank inventory), which should be taken into consideration in food chemical companies, for example.

Figure 1 is a diagram to explain an example of excess inventory (an example of tank inventory overflowing) due to a change in production plan. For example, let us explain the case where there is one 100 kg tank in a warehouse and the maximum inventory quantity is 100 kg. First, the current inventory of raw materials as of 8/20 is 100 kg. Also, on 8/20, an order was placed for 60 kg of raw materials from the manufacturer with a delivery date of 8/29. On 8/28, 80 kg of raw materials is planned to be used in production, so the planned inventory for 8/28 will be 20 kg. On 8/29, the manufacturer is scheduled to deliver the ordered 60 kg, so the planned inventory will be 80 kg. At this point, there is no problem as this is within the maximum inventory quantity for a 100 kg tank.

However, on August 28th, an urgent manufacturing order came in from an important customer, so the production plan was changed and today's planned production was postponed, and today's production was canceled. On August 29th, 60 kg of the ordered raw materials arrived, but the 100 kg tank already had 100 kg in stock, so it could not be delivered. If planned inventory management is not performed taking into account the maximum inventory quantity, situations like this will occur where raw materials cannot be delivered.

When checking planned inventory, there are various patterns for the items to be checked daily, but in this embodiment, (1) the items that should be checked by referring to planned inventory are checks of appropriate inventory standards (under-stock, under-reorder point, exceeding maximum inventory), and (2) if something fails the check, it will be necessary to check the progress of planned inventory for a certain period of time for further consideration. Based on this, a reference screen (document) that can extract certain data has been created. By checking this screen (document) daily, it is possible to prevent lost sales opportunities and delays in production plans while maintaining a constant inventory status.

In other words, in this embodiment, on the planned inventory reference screen, products that fall outside the range of the optimal inventory standard value for the planned inventory quantity are checked and displayed, and not only the planned inventory quantity at the time when it falls outside the optimal standard value range but also the trend in the planned inventory quantity before and after that is displayed, allowing for precise planned inventory management and making it easy to make adjustment decisions in inventory management operations.

In addition to the planned inventory reference from the perspective of inventory shortages and below-order points, this embodiment also adds the perspective of the maintainable inventory (tank inventory) of fluids, which should be considered in food chemical companies, to the planned inventory reference alert, making it possible to manage ordering plans more precisely.

Examples of optimal inventory standards include (1) checking for predicted shortages in product inventory (checking for negative inventory within a specified range), (2) checking whether the procurement arrangements for parts and materials to be used are in order for the production schedule (checking for negative inventory within a specified range), and (3) checking whether the warehouse's optimal inventory is exceeded (used when fluids are managed in tanks, and checking that safety stock < inventory amount < inventory that can be held in the warehouse (tank)).

2. Configuration
An example of the configuration of the inventory management device 100 according to this embodiment will be described with reference to Fig. 2. Fig. 3 is a block diagram showing an example of the configuration of the inventory management device 100. Fig. 4 is a diagram showing an example of the master and data configuration stored in the storage unit 106.

The inventory management device 100 is a commercially available desktop personal computer. Note that the inventory management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The inventory management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit of the inventory management device 100 is connected to each other so that they can communicate with each other via any communication path.

The communication interface unit 104 communicatively 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 a function of communicating data with other devices via the communication line. Here, the network 300 has a 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).

An input device 112 and an output device 114 are connected to the input/output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to achieve a pointing device function. 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 the mouse 112. Displaying information on the monitor 114 and the user operating the input device 112 may be referred to as "user operation via a UI."

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work with the OS (Operating System) to give commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes an optimal inventory standard master 106a, a receipt/delivery table 106b, and a current inventory table 106c.

The optimum inventory standard master 106a can be composed of a table or the like that associates and registers the business establishment (warehouse), the product, the order point, which is the lower limit below which an order must be placed, and the maximum inventory quantity, which is the maximum inventory quantity that can be stored in the warehouse. The product may include a fluid. The unit of the product quantity may include a physical unit (kg, liters, etc.), number of pieces, etc.

The receipt and delivery table 106b is a table for storing raw material ordering information, production schedule information, raw material usage schedule information, and production and shipping schedule information. Ordering information may include data on the business establishment, product (raw materials), delivery date, and quantity. Production schedule information may include data on the business establishment, product (finished product), delivery date, and quantity. Raw material usage schedule information may include data on the business establishment, product (raw materials), scheduled usage date, and quantity. Product shipping schedule information may include data on the business establishment, product (finished product), shipping date, and quantity.

The current inventory table 106c is a file for storing current inventory information. The current inventory information may include data on the business, product, and current (current date) inventory quantity.

Returning to FIG. 3, the control unit 102 is a CPU or the like that performs overall control of the inventory management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. In terms of functional concept, the control unit 102 includes a master maintenance unit 102a, a data registration unit 102b, a receipt and payment schedule information output unit 102c, and a screen display control unit 102d.

The master maintenance section 102a is used to edit (set) the optimum inventory standard master 106a by inputting, adding, deleting, changing, etc. data in response to the operator's operations on a master maintenance screen (not shown) displayed on the monitor 114.

The data registration unit 102b, for example, in response to the operator's operations on the input screen displayed on the monitor 114, registers raw material ordering information, production schedule information, raw material usage schedule information, and production and shipping schedule information in the receipt and delivery table 106b, and also registers current inventory information in the current inventory table 106c.

The planned receipt and payment information output unit 102c refers to the optimum inventory standard master 106a based on raw material ordering information, production schedule information, raw material usage schedule information, product shipping schedule information, and current inventory information, and displays on the monitor 114 details of the planned receipt and payment information, including the date, planned incoming quantity, planned outgoing quantity, and planned inventory quantity, for products that fall outside the range of the optimum inventory standard during the specified planned incoming and outgoing date period.

The optimum inventory standard may include a planned inventory quantity being positive. The optimum inventory standard may also include a planned inventory quantity being equal to or greater than the reorder point. The optimum inventory standard may also include a planned inventory quantity being equal to or less than the maximum inventory quantity.

The screen display control unit 102d controls the display and input of various screens (e.g., various data input (registration) screens, master maintenance screens, planned inventory list output screens, etc.) displayed on the monitor 114.

3. Specific Examples
A specific example of the processing of the control unit 102 of the inventory management device 100 in this embodiment will be described with reference to Figures 2 to 14. Figure 3 is a diagram for explaining an overview of the overall processing of the inventory management device 100 in this embodiment.

(3-1. Overall processing)
3, the master maintenance unit 102a executes a master maintenance process (step S1). Specifically, in the master registration process, the master maintenance unit 102a sets data of the optimum inventory standard master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

The data registration unit 102b executes a schedule registration process (step S2). Specifically, in the schedule registration process, the data registration unit 102b registers raw material order information, production schedule information, raw material usage schedule information, and production and shipping schedule information in the receipt and payment table 106b in response to, for example, an operator's operation on an input screen displayed on the monitor 114.

The scheduled receipt and payment information output unit 102c executes the scheduled receipt and payment inventory output process (step S3). Specifically, in the scheduled receipt and payment inventory output process, the scheduled receipt and payment information output unit 102c checks the optimal inventory standard by referring to the optimal inventory standard master 106a based on the raw material order information, production schedule information, raw material usage schedule information, product shipping schedule information, and current inventory information, and creates and displays on the monitor 114 scheduled receipt and payment information (document) including the scheduled receipt and shipment date, scheduled receipt quantity, scheduled shipment quantity, and scheduled inventory quantity for products that fall outside the range of the optimal inventory standard during the specified scheduled receipt and shipment date period.

Optimal inventory standards may include planned inventory quantities being positive, planned inventory quantities being equal to or greater than the reorder point, and planned inventory quantities being equal to or less than the maximum inventory quantity.

The person in charge looks at the planned receipt and payment information and makes operational decisions regarding planned inventory management (step S4).

(3-2. Sample data)
4 to 14 are diagrams showing sample data for explaining a specific example of the processing of the control unit 102 of the inventory management device 100 in this embodiment. A specific example of the processing of the inventory management device 100 in this embodiment will be explained with reference to FIGS. 4 to 14.

(S1: Master registration process)
4 to 8 are diagrams for explaining the master registration process. The master maintenance unit 102a sets data in the optimum inventory standard master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114. In the optimum inventory standard master 106a, information is registered for each business establishment (warehouse) and product, such as an order point, which is the lower limit below which an order must be placed, and a maximum inventory quantity, which is the maximum inventory quantity that can be held in the warehouse.

Figure 4 is a diagram showing an example of registration of the optimum inventory standard master 106a. In the example of the optimum inventory standard master 106a shown in Figure 4, the first line is the business establishment (warehouse) "A", product "W", order point "10", and maximum inventory quantity "100", the second line is the business establishment (warehouse) "A", product "X", order point "20", and maximum inventory quantity "100", the third line is the business establishment (warehouse) "A", product "Y", order point "10", and maximum inventory quantity "100", and the fourth line is the business establishment (warehouse) "A", product "Z", order point "50", and maximum inventory quantity "200".

(S2: Schedule registration process)
5 to 9 are diagrams for explaining the schedule registration process. The data registration unit 102b registers raw material order information, production schedule information, raw material use schedule information, and production shipping schedule information in the receipt and payment table 106b in response to, for example, an operator's operation on an input screen displayed on the monitor 114. In the schedule registration process, daily incoming schedule information (raw material order information, production schedule information) and outgoing schedule information (raw material use schedule information, product shipping schedule information) are registered.

Figure 5 shows an example of raw material ordering information data. In the example of raw material ordering information shown in Figure 5, the first line contains the business location (warehouse) "A", the product (raw material) "W", the delivery date "August 2nd", and the quantity "2".

6 is a diagram showing an example of data of the production schedule information. In the example of the production schedule information shown in FIG.
The first line shows the business location (warehouse) "A", the product (product) "Y", the delivery date "August 2nd", and the quantity "2".

Figure 7 is a diagram showing an example of data for planned raw material usage information. In the example of planned raw material usage information shown in Figure 7, the first line contains the business establishment (warehouse) "A", the product (raw material) "Z", the delivery date "August 2nd", and the quantity "40".

Figure 8 is a diagram showing an example of product shipping schedule information data. In the example of product shipping schedule information shown in Figure 8, the fifth line contains the business establishment (warehouse) "A", the product (product) "Y", the delivery date "August 5th", and the quantity "30".

Figure 9 is a diagram showing an example of current inventory information data. Current inventory information is stock information on the current day (e.g., August 1). In the example of current inventory information shown in Figure 9, the first line shows business establishment (warehouse) "A", product "W", and current inventory quantity "10".

(S3: Scheduled receipt and delivery inventory output process)
10 to 13 are diagrams for explaining the planned receipt and delivery inventory output process. The planned receipt and delivery information output unit 102c checks the optimal inventory standard by referring to the optimal inventory standard master 106a based on the raw material order information, production schedule information, raw material use schedule information, product shipping schedule information, and current inventory information, and creates a detailed list of the planned receipt and delivery information including the planned receipt and delivery date, the planned receipt quantity, the planned delivery quantity, and the planned inventory quantity for products that fall outside the range of the optimal inventory standard during the period of the designated planned receipt and delivery date, and displays it on the monitor 114. The optimal inventory standard may include the planned inventory quantity being positive, the planned inventory quantity being equal to or greater than the order point, and the planned inventory quantity being equal to or less than the maximum inventory quantity.

The output logic for scheduled receipt and payment information will be explained with reference to Figures 10 to 13. Figure 10 is a diagram showing an example of the display of the scheduled inventory list output screen. The scheduled inventory list output screen has an input field for the business location (warehouse), an input field for the scheduled entry/exit date, and a field (check box) for specifying the output category ("negative inventory extraction", "below reorder point", "exceeds maximum inventory") that is the appropriate inventory standard. On the scheduled inventory list output screen, when the business location (warehouse), scheduled entry/exit date, and output category ("negative inventory extraction", "below reorder point", "exceeds maximum inventory") that is the appropriate inventory standard are specified and the "search button" is pressed, extraction is performed using the specified extraction conditions.

In the example of the planned inventory list output screen shown in Figure 10, the current date is 2021/8/1, the business location is "A", the planned arrival and departure dates are up to "2021/8/31", and the output categories are "negative inventory extraction", "below order point", and "exceeding maximum inventory". Below, we will explain the case of extraction using these extraction conditions.

Figure 11 is a diagram for explaining extraction logic (part 1). 1. Within the range of planned arrival and departure dates specified on the planned inventory list output screen, data is extracted from the current inventory information in the current inventory table 106c and the raw material ordering information, production schedule information, raw material usage schedule information, and product shipping schedule information in the receipt and delivery table 106b, and the planned inventory quantity is calculated.

As shown in Figure 11, create planned receipt and payment information including the business location, product, planned entry/exit date (including the current date), inventory quantity (current), planned entry quantity, planned exit quantity, and planned inventory quantity. The inventory quantity (current) is obtained from the current inventory information. The planned entry quantity is calculated by calculating the quantity of entry with a future delivery date from raw material ordering information and planned production information. The planned exit quantity is calculated from planned raw material usage information and planned product shipment information. The planned inventory quantity is calculated from the current inventory quantity (August 1st) + planned entry quantity - planned exit quantity. In addition, the planned inventory quantity for the next day and beyond is calculated from the previous row's planned inventory quantity + planned entry quantity - planned exit quantity.

In the example shown in FIG. 11, the 8th line has the business location "A", product "X", planned arrival/return date "August 1st (current date)", stock quantity (current) "10", and planned stock quantity "10". The 9th line has the business location "A", product "X", planned arrival/return date "August 2nd", planned arrival quantity "2", and planned stock quantity "12 (=10 + 2)". The 10th line has the business location "A", product "X", planned arrival/return date "August 5th", planned shipment quantity "15", and planned stock quantity "-3 (=12 - 15)".

Figure 12 is a diagram for explaining extraction logic (part 2). 2. Standard value information for the quantity for judging stock shortages, the order point, and the maximum stock quantity is added to determine the data that needs to be extracted. Figure 12 is Figure 11 with standard value information for the quantity for judging stock shortages, the order point, and the maximum stock quantity added. The quantity for judging stock shortages is "0" regardless of the type of product. The order point and maximum stock quantity are obtained from the optimum stock standard master 106a using the product as a key.

In Figure 12, for business location "A," product "X," and planned arrival/removal date "August 5," the planned inventory quantity is "-3," and since the planned inventory quantity is < 0, it is determined that there is a shortage of inventory.

For business location "A," product "Y," and date "August 5," the planned inventory quantity is "12," and since the planned inventory quantity is less than the order point "20," it is determined that the order point has been exceeded.

For business location "A," product "Z," and date "August 5," the planned inventory quantity is "260," and since the planned inventory quantity is greater than the maximum inventory quantity "200," it is determined that the maximum inventory quantity has been exceeded.

For the products that were the subject of the judgment in 3.2, the planned receipt and payment information is re-extracted for the planned entry and exit dates specified on the planned inventory list output screen, "August 1, 2021 (current date) to August 31, 2021", and displayed on the planned receipt and payment information output screen. Figure 13 is a diagram showing an example of the display of the planned receipt and payment information output screen. In the example shown in the figure, products "X", "Y", and "Z" from "August 1, 2021 (current date) to August 31, 2021" are extracted. An alert is displayed for products that fall outside the range of the optimal inventory standard. In addition to the planned inventory quantity at the time when it is determined that the inventory quantity is outside the range of the optimal inventory standard, the trend in the planned inventory quantity before and after that is displayed, making it easy to make adjustment decisions in the planned inventory management work.

(S4: Business judgment)
The person in charge looks at the planned receipt and payment information and makes a business decision on planned inventory management. Figure 14 is a diagram for explaining an example of business decision. For example, (1) in the case of negative inventory of business establishment "A", product "X", planned arrival/return date "August 5", and planned inventory quantity "-3", if the product is a product, it cannot be shipped, and if raw materials, it cannot be manufactured, so measures are taken such as bringing forward the planned arrival date of August 6, or moving the planned shipment date to August 6.

(2) In regards to the under-ordering of business location "A," product "Y," date "August 5," and planned inventory quantity "12," normally an ordering operation would be necessary since the under-ordering would occur. However, since the product is scheduled to arrive the following day, it can be determined that no action is required in this case.

(3) The maximum inventory quantity for business location "A", product "Z", date "August 5th", and planned inventory quantity "260" is exceeded, meaning that items cannot be placed in the warehouse. For example, this is common in the chemical industry, and items cannot be placed in tanks or silos. Measures can be taken to bring forward the scheduled shipment on August 6th or to reduce the scheduled arrival on August 5th to 100.

As described above, according to this embodiment, the system includes an optimum inventory standard master 106a in which the order point and maximum inventory quantity for each product are registered for a target warehouse, and a receipt/delivery schedule information output unit 102c which refers to the optimum inventory standard master 106a based on raw material ordering information, production schedule information, raw material usage schedule information, product shipment schedule information, and current inventory information, and displays receipt/delivery schedule information including the scheduled receipt/delivery date, scheduled receipt quantity, scheduled shipment quantity, and scheduled inventory quantity on the monitor 114 for products that fall outside the range of the optimum inventory standard during a specified period of scheduled receipt/delivery dates. Therefore, by precisely performing scheduled inventory management, it becomes possible to easily make adjustment decisions for inventory management operations.
In addition, by checking the planned receipt and payment information (documents) on a daily basis, it is possible to keep inventory levels constant and prevent lost sales opportunities and delays in production plans.

[4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)]
This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

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

5. Other embodiments
The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

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 using a known method.

In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

Furthermore, with regard to the inventory management device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the inventory management device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the inventory management device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the inventory management device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile This includes any "portable physical media" such as a Blu-ray (registered trademark) Disc, and a Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit are storage devices such as RAM, ROM, etc., fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

The inventory management device 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 any peripheral device is connected. The inventory management device 100 may also be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments may be implemented in any combination, or the embodiments may be implemented selectively.

REFERENCE SIGNS LIST 100 Inventory management device 102 Control unit 102a Master maintenance unit 102b Data registration unit 102c Receipt and payment schedule information output unit 102d Screen display control unit 104 Communication interface unit 106 Storage unit 106a Optimal inventory standard master 106b Receipt and payment table 106c Current inventory table 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (6)

An inventory management device having a control unit,
The control unit is
For the target warehouse, a master that registers the order point and maximum stock quantity for each product,
Raw material ordering information, production schedule information, raw material usage schedule information, product shipping schedule information, current inventory information,
is configured to be accessible to
a receipt/delivery schedule information output means for displaying, on a display unit, receipt/delivery schedule information including a scheduled receipt/delivery date, a scheduled receipt quantity, a scheduled delivery quantity, and a scheduled inventory quantity for a product that falls outside the range of an appropriate inventory standard during a designated scheduled receipt/delivery date period, based on the raw material order information, the production schedule information, the raw material use schedule information, the product delivery schedule information, and the current inventory information , with reference to the master;
The optimal inventory standard includes a positive planned inventory quantity;
The receipt and payment schedule information output means
The planned inventory quantity is calculated by calculating the number of inventory items with delivery dates in advance from the raw material ordering information and the production schedule information,
The planned shipping quantity is calculated from the planned raw material usage information and the planned product shipping information,
The inventory management device is characterized in that the planned inventory quantity is calculated by adding the inventory quantity of the current inventory information on that day to the planned incoming quantity minus the planned outgoing quantity, and the planned inventory quantity for the next day and thereafter is calculated by adding the planned inventory quantity of the previous row to the planned incoming quantity minus the planned outgoing quantity . 2. The inventory management device according to claim 1 , wherein the optimum inventory standard includes a planned inventory quantity being equal to or greater than an order point. 3. The inventory management device according to claim 1 , wherein the optimum inventory standard includes a condition that a planned inventory quantity is equal to or less than a maximum inventory quantity. 4. The inventory management device according to claim 1 , wherein the merchandise includes a fluid. An inventory management method executed by an information processing device having a control unit,
The control unit is
For the target warehouse, a master that registers the order point and maximum stock quantity for each product,
Raw material ordering information, production schedule information, raw material usage schedule information, product shipping schedule information, current inventory information,
is configured to be accessible to
Executed in the control unit:
a receipt/delivery schedule information output step of displaying receipt/delivery schedule information including a scheduled receipt/delivery date, a scheduled receipt quantity, a scheduled delivery quantity, and a scheduled inventory quantity on a display unit for products that fall outside the range of the optimal inventory standard during a designated scheduled receipt/delivery date based on the raw material order information, the production schedule information, the raw material use schedule information, the product delivery schedule information, and the current inventory information, with reference to the master ;
The optimal inventory standard includes a positive planned inventory quantity;
In the receipt and payment schedule information output step,
The planned inventory quantity is calculated by calculating the number of inventory items with delivery dates in advance from the raw material ordering information and the production schedule information,
The planned shipping quantity is calculated from the planned raw material usage information and the planned product shipping information,
The inventory management method is characterized in that the planned inventory quantity is calculated by adding the inventory quantity of the current inventory information on that day to the planned incoming quantity minus the planned outgoing quantity, and the planned inventory quantity for the next day and thereafter is calculated by adding the planned inventory quantity of the previous line to the planned incoming quantity minus the planned outgoing quantity . An inventory management program to be executed by an information processing device having a control unit,
The control unit is
For the target warehouse, a master that registers the order point and maximum stock quantity for each product,
Raw material ordering information, production schedule information, raw material usage schedule information, product shipping schedule information, current inventory information,
is configured to be accessible to
The control unit ,
an inventory management program for executing a receipt/delivery schedule information output step of displaying receipt/delivery schedule information including a scheduled receipt/delivery date, a scheduled receipt quantity, a scheduled delivery quantity, and a scheduled inventory quantity on a display unit for products that fall outside the range of an appropriate inventory standard during a specified scheduled receipt/delivery date period, by referring to the master based on the raw material ordering information, the production schedule information, the raw material usage schedule information, the product shipping schedule information , and the current inventory information;
The optimal inventory standard includes a positive planned inventory quantity;
In the receipt and payment schedule information output step,
The planned inventory quantity is calculated by calculating the number of inventory items with delivery dates in advance from the raw material ordering information and the production schedule information,
The planned shipping quantity is calculated from the planned raw material usage information and the planned product shipping information,
said planned inventory quantity is calculated from the inventory quantity of said current inventory information on that day + said planned incoming quantity - said planned outgoing quantity, and said planned inventory quantity for the next day and thereafter is calculated from the planned inventory quantity of the previous line + planned incoming quantity - planned outgoing quantity .

Images