JP7586732B2 - Appropriate inventory management device, appropriate inventory management method, and appropriate inventory management program - Google Patents

Description

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

Patent Document 1 discloses a configuration in which, when the amount of bulk inventory is greater than the total number of shipments, only the bulk inventory is used for shipments, and, when the amount of bulk inventory is less than the total number of shipments, the bulk inventory is used for shipments, and then the case inventory is used for shipping the remaining number of shipments.

JP 2002-205810 A

However, the invention described in the above-mentioned Patent Document 1 had the problem that it was not possible to use bulk inventory for shipments only for the fractional number of loose items that were a fraction of the shipment quantity of each item, taking into account the number of cases.

The present invention has been made in consideration of the above problems, and aims to provide an optimal inventory management device, an optimal inventory management method, and an optimal inventory management program that can automatically calculate the amount of inventory replenishment from large inventory to small inventory based on the optimal inventory coefficient and the number of backlogged orders, and perform transfer processing.

In order to solve the above-mentioned problems and achieve the object, the optimal inventory management device of the present invention is an optimal inventory management device having a storage unit and a control unit, the storage unit having an item storage means for storing an item master that sets the number of items per case, and an inventory storage means for storing inventory data that sets the case inventory number of the item and the bulk inventory number of the bulk inventory, and the control unit having an order acquisition means for acquiring order data that sets the planned case shipment number of the item and the planned shipment number including the planned bulk shipment number, a counting means for acquiring a counted number that tallies the planned bulk shipment number for each item based on the order data, and a transfer number acquisition means for comparing the bulk inventory number and the aggregated number of the item based on the item master and the inventory data to acquire the number of cases transferred from the case inventory to the bulk inventory.

In the optimal inventory management device according to the present invention, the item master further includes a replenishment stock reference number for the product that is the basis for replenishment judgment, and a replenishment number for the case at the time of inventory replenishment. The control unit further includes a replenishment judgment means for judging whether the replenishment stock reference number is greater than the bulk inventory number of the product based on the item master and the inventory data, and a replenishment number acquisition means for acquiring the replenishment number to be replenished from the case inventory to the bulk inventory based on the inventory data and the item master when the replenishment judgment means judges that the replenishment stock reference number is greater than the bulk inventory number of the product.

In the optimal inventory management device according to the present invention, the inventory data further includes a lot number, the order acquisition means further acquires lot-designated order data that includes a designated lot number of the product and the planned shipping number including the planned case shipping number and the planned bulk shipping number of the product, the aggregation means further acquires a lot-designated aggregate number that aggregates the planned bulk shipping number of the product with the designated lot number based on the lot-designated order data, and the transfer number acquisition means further acquires a lot-designated transfer number that is the number of cases transferred from the case inventory to the bulk inventory with the designated lot number by comparing the bulk inventory number of the designated lot number with the lot-designated aggregate number based on the item master and the inventory data.

In the optimal inventory management device according to the present invention, the tallying means further acquires a remaining tally by tallying the planned bulk shipment quantity of the product other than the designated lot number based on the order data and the lot-designated order data, and the control unit further includes an inventory update means for adding and updating the bulk inventory quantity set in the inventory data based on the item master and the lot-designated transfer quantity, and acquiring the remaining bulk inventory quantity by subtracting the lot-designated tally quantity from the bulk inventory quantity, and the transfer quantity acquisition means further acquires the remaining transfer quantity, which is the number of cases transferred from the case inventory to the bulk inventory, by comparing the remaining bulk inventory quantity with the remaining tally based on the item master.

In addition, in the optimal inventory management device according to the present invention, the storage unit further includes a location storage means for storing a location master that sets the location of the case inventory of the product and the bulk inventory, and the transfer number acquisition means acquires the number of cases transferred from the case inventory to the bulk inventory by comparing the bulk inventory number with the total number of the product based on the location master, the item master, and the inventory data.

In addition, in the optimal inventory management device according to the present invention, the inventory data further includes a lot number, and the replenishment number acquisition means, when the replenishment determination means determines that the replenishment inventory standard number is greater than the bulk inventory number of the product, identifies the cases of the replenishment number to be replenished from the case inventory to the bulk inventory in order of the lot number based on the inventory data and the item master.

In the optimal inventory management device according to the present invention, the product is a food product, an electrical component, an electronic component, or a mechanical component.

The optimal inventory management method according to the present invention is an optimal inventory management method to be executed by an optimal inventory management device having a storage unit and a control unit, the storage unit having an item storage means for storing an item master that sets the number of items per case, and an inventory storage means for storing inventory data that sets the case inventory number of the item and the bulk inventory number of the bulk inventory, and the control unit includes an order acquisition step to be executed by the control unit, which acquires order data that sets the planned case shipment number of the item and the planned shipment number including the planned bulk shipment number, a counting step to acquire a counted number that tallies the planned bulk shipment number for each item based on the order data, and a transfer number acquisition step to acquire the number of cases transferred from the case inventory to the bulk inventory by comparing the bulk inventory number and the aggregated number of the item based on the item master and the inventory data.

The appropriate inventory management program according to the present invention is an appropriate inventory management program to be executed by an appropriate inventory management device having a storage unit and a control unit, the storage unit having an item storage means for storing an item master that sets the number of items per case, and an inventory storage means for storing inventory data that sets the case inventory number of the item and the bulk inventory number of the bulk inventory, and the control unit executes an order acquisition step for acquiring order data that sets the planned case shipment number of the item and the planned shipment number including the planned bulk shipment number, a counting step for acquiring a counted number that tallies the planned bulk shipment number for each item based on the order data, and a transfer number acquisition step for comparing the bulk inventory number with the counted number of the item based on the item master and the inventory data to acquire the number of cases transferred from the case inventory to the bulk inventory.

According to the present invention, it is possible to efficiently pick and pack items in a logistics warehouse. In addition, according to the present invention, it is possible to share picking work by forklift and manual work at the same time by managing large inventory (pallets) and small inventory (loose) at different locations. In addition, according to the present invention, although the number of items to be expanded from cases to loose items is usually calculated manually in a warehouse according to the order status, it is possible to logically calculate the number of items to be expanded from cases to loose items from the number of orders. In addition, according to the present invention, it is possible to replenish the stock that is insufficient for the shipping schedule of small lot sizes from the large lot sizes, and further, it is possible to replenish the stock that is insufficient for the safety stock (master setting) of small lot sizes from the large lot sizes. In addition, according to the present invention, it is useful for case/ball or ball/loose, and it is possible to effectively utilize it not only for case/loose. In addition, according to the present invention, it is possible to apply not only to the food industry, where the requirement for packaging management of loose items is very high, but also to other vendors. In addition, the present invention has the advantage of not only being able to manage packaging style, but also being able to manage individual cases with the same code.

FIG. 1 is a diagram showing an example of an appropriate inventory management process according to the present embodiment. FIG. 2 is a diagram showing an example of an appropriate inventory management process in this embodiment. FIG. 3 is a block diagram showing an example of the configuration of an optimum inventory management device according to this embodiment. FIG. 4 is a flowchart showing an example of the process of the optimum inventory management device in this embodiment. FIG. 5 is a diagram showing an example of an appropriate inventory management process in this embodiment. FIG. 6 is a diagram showing an example of an appropriate inventory management process in this embodiment. FIG. 7 is a diagram showing an example of an appropriate inventory management process in this embodiment. FIG. 8 is a diagram showing an example of an appropriate inventory management process in this embodiment. FIG. 9 is a diagram showing an example of an appropriate inventory management process in this embodiment. FIG. 10 is a diagram showing an example of an appropriate inventory management process in this embodiment.

An 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]
First, an overview of the present invention will be described with reference to Figures 1 and 2. Figures 1 and 2 are diagrams showing an example of an appropriate inventory management process in this embodiment.

Previously, in operations involving shipping both large and small lot packages, picking by forklift and manual picking were mixed, so once the number of items to be shipped on the day was decided, picking by forklift and manual picking had to be done simultaneously in parallel, and inventory had to be replenished at the manual bulk shipping area before case shipping by forklift began.

As a result, in the past, when inventory was managed based on the total number of items, it was not possible to grasp the actual situation between pallet-based inventory for large shipments and ball inventory for small shipments, and on-site staff replenished stock at their discretion. This often resulted in waiting times when the picking work was shared among multiple staff or locations.

Therefore, in this embodiment, the system manages case inventory and bulk inventory by separate locations, and provides a mechanism to automatically calculate the amount of inventory to be transferred from the case location to the bulk location based on the appropriate amount of bulk inventory and the planned number of items to be shipped today.

For example, as shown in FIG. 1, in this embodiment, a primary replenishment process is performed to replenish inventory from case shelves to bulk shelves according to the settings in the item master. That is, as shown in FIG. 1, in this embodiment, the current inventory is compared with the appropriate small-lot inventory setting set in the item master, and if the inventory on the bulk shelves is lower, the shortage quantity is automatically moved to a different location by transferring inventory from the case shelves to the bulk shelves.

Also, as shown in FIG. 2, in this embodiment, a secondary replenishment process is performed to replenish inventory from the case shelf to the bulk shelf according to the planned shipment quantity. That is, as shown in FIG. 2, in this embodiment, the current inventory is compared with the planned shipment quantity, and if the bulk shelf inventory is lower, inventory is moved from the case shelf to the bulk shelf, and the shortage quantity is automatically moved to a location, making it possible to carry out replenishment work in advance before shipment. Also, as shown in FIG. 2, in this embodiment, when shipping data is created, inventory for cases and bulk quantities is deducted from the respective locations.

2. Configuration
An example of the configuration of the optimum inventory management device 100 according to this embodiment will be described with reference to Fig. 3. Fig. 3 is a block diagram showing an example of the configuration of the optimum inventory management device 100 according to this embodiment.

As shown in FIG. 3, the optimum inventory management device 100 is a commercially available desktop personal computer. Note that the optimum 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 appropriate 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 appropriate 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 appropriate 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 appropriate 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 touch panel), 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 provide a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

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 instructions 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 item master 106a, a location master 106b, and an inventory database 106c.

The item master 106a is a master that sets the number of items per case. Here, the item master 106a may set the standard number of items to be replenished, which is the basis for determining whether to replenish, and the number of cases to be replenished when replenishing the inventory. The items may also be food, electrical parts, electronic parts, or mechanical parts.

The location master 106b is a master that sets the location of the product inventory. Here, the location master 106b may set the location of the case inventory and the bulk inventory of the product.

The inventory database 106c stores inventory data for products. Here, the inventory database 106c may store inventory data that sets the case inventory number of the product's case inventory and the bulk inventory number of the product's bulk inventory. The inventory data may also be set with a lot number.

The control unit 102 is a CPU or the like that performs overall control of the optimum 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 function and concept, the control unit 102 includes a replenishment determination unit 102a, a replenishment number acquisition unit 102b, an order acquisition unit 102c, a counting unit 102d, a movement number acquisition unit 102e, and an inventory update unit 102f.

The replenishment determination unit 102a determines whether the replenishment inventory standard quantity for a product is greater than the product's bulk inventory quantity based on the item master 106a and inventory data.

The replenishment number acquisition unit 102b acquires the number of replenishment cases to be replenished from the case inventory to the bulk inventory. Here, when the replenishment determination unit 102a determines that the replenishment inventory standard number of the product is greater than the bulk inventory number of the product, the replenishment number acquisition unit 102b may acquire the number of replenishment cases to be replenished from the case inventory to the bulk inventory based on the inventory data and the item master 106a. Also, when the replenishment determination unit 102a determines that the replenishment inventory standard number of the product is greater than the bulk inventory number of the product, the replenishment number acquisition unit 102b may identify the number of replenishment cases to be replenished from the case inventory to the bulk inventory in order of lot number based on the inventory data and the item master 106a.

The order acquisition unit 102c acquires order data for a product. Here, the order acquisition unit 102c may acquire order data that sets the planned shipping quantity, including the planned number of cases of the product and the planned number of loose shipments. The order acquisition unit 102c may also acquire lot-designated order data that sets the designated lot number of the product and the planned shipping quantity, including the planned number of cases of the product and the planned number of loose shipments.

The tallying unit 102d obtains an aggregate number obtained by aggregating the planned bulk shipment quantities for each product based on the order data. Here, the tallying unit 102d may obtain a lot-designated aggregate number obtained by aggregating the planned bulk shipment quantities for products with designated lot numbers based on the lot-designated order data. The tallying unit 102d may also obtain a remaining aggregate number obtained by aggregating the planned bulk shipment quantities for products other than the designated lot number based on the order data and the lot-designated order data.

The transfer number acquisition unit 102e acquires the number of cases transferred from case inventory to bulk inventory. Here, the transfer number acquisition unit 102e may acquire the number of cases transferred from case inventory to bulk inventory by comparing the bulk inventory number of the product with the total number of the product based on the item master 106a and inventory data. The transfer number acquisition unit 102e may also acquire the lot-designated transfer number, which is the number of cases transferred from case inventory to bulk inventory with the designated lot number, by comparing the bulk inventory number of the designated lot number with the lot-designated total number based on the item master 106a. The transfer number acquisition unit 102e may also acquire the remaining transfer number, which is the number of cases transferred from case inventory to bulk inventory, by comparing the remaining bulk inventory number with the remaining total number based on the item master 106a. The transfer number acquisition unit 102e may also acquire the number of cases transferred from case inventory to bulk inventory by comparing the bulk inventory number of the product with the total number of the product based on the location master 106b, item master 106a, and inventory data.

The inventory update unit 102f updates inventory data for products. Here, the inventory update unit 102f may add and update the bulk inventory quantity set in the inventory data based on the item master 106a and the lot-designated movement count, and obtain the remaining bulk inventory quantity by subtracting the lot-designated total quantity from the bulk inventory quantity.

3. Specific Examples
A specific example of this embodiment will be described with reference to FIGS.

[Proper inventory management process]
An example of an optimum inventory management process in this embodiment will now be described with reference to Fig. 4. Fig. 4 is a flowchart showing an example of a process of the optimum inventory management device 100 in this embodiment.

As shown in FIG. 4, the replenishment determination unit 102a determines whether the replenishment inventory standard quantity for the product is greater than the bulk inventory quantity for the product based on the inventory data stored in the item master 106a and the inventory database 106c (step SA-1).

Then, if the replenishment determination unit 102a determines that the replenishment stock reference quantity for the product is not greater than the bulk stock quantity for the product (step SA-1: No), it transitions the process to step SA-4.

On the other hand, if the replenishment determination unit 102a determines that the replenishment inventory standard quantity for the product is greater than the bulk inventory quantity for the product (step SA-1: Yes), it transitions the process to step SA-2.

Then, the replenishment number acquisition unit 102b acquires the number of cases to be replenished from the case inventory to the bulk inventory based on the inventory data stored in the inventory database 106c and the item master 106a (step SA-2).

Then, when the replenishment number of cases is replenished from the case inventory to the bulk inventory, the inventory update unit 102f updates the inventory data stored in the inventory database 106c (step SA-3).

Then, the order acquisition unit 102c acquires order data that sets the planned shipping quantity, including the number of cases of the product and the number of individual items planned to be shipped (step SA-4).

Then, the counting unit 102d obtains a count of the planned individual shipment quantities for each product based on the order data (step SA-5).

Then, the movement number acquisition unit 102e determines whether the loose inventory quantity of the product is less than the total number of the product based on the inventory data stored in the inventory database 106c (step SA-6).

Then, if the number of loose items in stock is not less than the total number of items (step SA-6: No), the movement count acquisition unit 102e transitions the process to step SA-7.

Then, when the planned case shipment quantity is picked up from the case inventory and the total number of items is picked up from the bulk inventory, the inventory update unit 102f updates the inventory data stored in the inventory database 106c (step SA-7) and ends the process.

On the other hand, if the number of loose items in stock is less than the total number of items (step SA-6: Yes), the movement count acquisition unit 102e transitions the process to step SA-8.

Then, the transfer number acquisition unit 102e acquires the number of cases transferred from case inventory to bulk inventory based on the location master 106b, item master 106a, and inventory data (step SA-8).

Then, when the transfer number of cases is moved from the case inventory to the bulk inventory, the number of cases scheduled for shipment is picked up from the case inventory, and the total number of products is picked up from the bulk inventory, the inventory update unit 102f updates the inventory data stored in the inventory database 106c (step SA-9) and ends the process.

Here, an example of the appropriate inventory management process in this embodiment will be described with reference to Figures 5 to 10. Figures 5 to 10 are diagrams showing an example of the appropriate inventory management process in this embodiment.

In this embodiment, the current inventory quantity in the bulk location is compared with the replenishment process setting in the item master 106a, and the bulk location is replenished to the appropriate inventory quantity. In this embodiment, when the item master 106a and location master 106b are set as shown in FIG. 5 and the inventory data for warehouse A is stored in the inventory database 106c, as shown in FIG. 6, the replenishment inventory standard quantity set in the item master 106a is 2 cases, but the current inventory quantity is insufficient at 1 case. Therefore, the replenishment inventory standard quantity set in the item master 106a, 2 cases, is controlled to be moved from the case location to the bulk location. Here, in this embodiment, as shown in FIG. 6, when the replenishment inventory standard quantity = 2 cases is replenished from the case location (CS00000001) to the bulk location (PC00000001), the oldest lot numbers are allocated in order.

Then, the inventory quantity in bulk locations is compared with the fractional bulk quantity of the planned shipping quantity (backorder quantity) on the day the primary bulk replenishment process is executed, and the shortage is replenished from the case location. In this embodiment, as the secondary bulk replenishment process, when order data is acquired and location master 106b is set as shown in FIG. 7, the fractional bulk quantities in the order data are aggregated for each specified lot number as shown in FIG. 8, and when no lot is specified, the fractional bulk quantities in the order data are aggregated with no lot specified, and the inventory data is referenced.

Then, as shown in FIG. 9, the lot designation process in this embodiment checks whether the designated lot number needs to be replenished in the aggregated order data, and since there is a shortage of inventory for the designated lot number in the bulk location, the inventory for the designated lot number is replenished from the case location (CS00000002) to the bulk location (PC00000002).

In this embodiment, as shown in FIG. 10, for the non-lot designation processing, the total bulk quantity is aggregated for inventory data that reflects subtraction and addition by lot number designation, and the effective quantity (remaining bulk inventory quantity) is calculated by subtracting the allocated quantity for the designated lot number, and inventory is replenished from the case location to the bulk location based on a comparison between the remaining bulk inventory quantity and the remaining aggregated quantity.

[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.

In addition, with regard to the optimal 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 appropriate inventory management device 100, particularly the processing functions performed by the control unit 102, 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 appropriate 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 an OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into a 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 optimal 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, and may also 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 this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit 106 are storage devices such as memory devices such as RAM and ROM, 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 website provision.

The optimum 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 optimum inventory management device 100 may 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 can be implemented in any combination, or the embodiments can be implemented selectively.

The present invention is useful in industries such as food, electrical and electronic components, or mechanical parts, where inventory is shipped in cases and bulk.

REFERENCE SIGNS LIST 100 Optimal inventory management device 102 Control unit 102a Replenishment determination unit 102b Replenishment number acquisition unit 102c Order acquisition unit 102d Counting unit 102e Movement number acquisition unit 102f Inventory update unit 104 Communication interface unit 106 Storage unit 106a Item master 106b Location master 106c Inventory database 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (8)

An appropriate inventory management device including a memory unit and a control unit,
The storage unit is
an item storage means for storing an item master in which is set the number of items per case, a standard number of items to be replenished as a criterion for replenishment, and the number of items to be replenished in the case at the time of replenishment ;
an inventory storage means for storing inventory data that sets the case inventory number of the case inventory of the product and the bulk inventory number of the bulk inventory of the product;
Equipped with
The control unit is
a replenishment determination means for determining whether the replenishment stock reference quantity is greater than the bulk stock quantity of the product based on the item master and the inventory data;
a replenishment quantity acquisition means for acquiring the replenishment quantity to be replenished from the case inventory to the bulk inventory based on the inventory data and the item master when the replenishment determination means determines that the replenishment stock reference quantity is greater than the bulk inventory quantity of the product;
An order acquisition means for acquiring order data that sets a planned shipping quantity including a planned case shipping quantity and a planned loose shipping quantity of the product;
a counting means for acquiring a counted number obtained by counting the planned bulk shipping quantity for each of the products based on the order data;
a transfer number acquisition means for acquiring the number of cases transferred from the case inventory to the bulk inventory by comparing the bulk inventory number with the total number of the products based on the item master and the inventory data;
An appropriate inventory management device comprising: The inventory data is
In addition, a lot number is set,
The order acquisition means includes:
Furthermore, lot-designated order data is acquired, which sets the designated lot number of the commodity and the planned shipping quantity including the planned case shipping quantity and the planned bulk shipping quantity of the commodity,
The tallying means is
Furthermore, a lot-designated total number is obtained by tallying up the planned bulk shipping quantity of the product having the designated lot number based on the lot-designated order data;
The movement number acquisition means
The optimum inventory management device according to claim 1, further comprising: a comparison of the bulk inventory quantity of the designated lot number with the lot designated total quantity based on the item master and the inventory data, and obtaining a lot designated transfer quantity, which is the number of cases of the designated lot number transferred from the case inventory to the bulk inventory. The tallying means is
Further, a remaining total number is obtained by totaling the planned bulk shipping quantity of the product other than the designated lot number based on the order data and the lot designation order data,
The control unit is
an inventory update means for updating the bulk inventory quantity set in the inventory data based on the item master and the lot designated movement quantity, and obtaining a remaining bulk inventory quantity obtained by subtracting the lot designated total quantity from the bulk inventory quantity;
Further comprising:
The movement number acquisition means
The optimum inventory management device according to claim 2, further comprising: a comparison of the remaining bulk inventory quantity with the remaining total quantity based on the item master ; and obtaining a remaining transfer quantity, which is the number of cases transferred from the case inventory to the bulk inventory. The storage unit is
a location storage means for storing a location master in which the location of the case inventory of the product and the location of the bulk inventory are set;
Further comprising:
The movement number acquisition means
The optimum inventory management device according to claim 1, characterized in that the number of cases transferred from the case inventory to the bulk inventory is obtained by comparing the number of loose inventory items with the total number of items based on the location master, the item master, and the inventory data. The inventory data is
In addition, a lot number is set,
The replenishment number acquisition means
The optimum inventory management device as described in claim 1, characterized in that when the replenishment determination means determines that the replenishment inventory standard quantity is greater than the bulk inventory quantity of the product, the device identifies the cases of the replenishment quantity to be replenished from the case inventory to the bulk inventory in order of lot number based on the inventory data and the item master . The said product is
6. The proper inventory management device according to claim 1 , wherein the goods are food, electric parts, electronic parts, or machine parts. A method for controlling an appropriate inventory by an appropriate inventory control device having a storage unit and a control unit,
The storage unit is
an item storage means for storing an item master in which is set the number of items per case, a standard number of items to be replenished as a criterion for replenishment, and the number of items to be replenished in the case at the time of replenishment ;
an inventory storage means for storing inventory data that sets the case inventory number of the case inventory of the product and the bulk inventory number of the bulk inventory of the product;
Equipped with
Executed by the control unit,
a replenishment determination step of determining whether the replenishment stock reference quantity is greater than the bulk stock quantity of the product based on the item master and the inventory data;
a replenishment quantity acquisition step of acquiring the replenishment quantity to be replenished from the case inventory to the bulk inventory based on the inventory data and the item master when it is determined in the replenishment determination step that the replenishment stock reference quantity is greater than the bulk inventory quantity of the product;
An order acquisition step of acquiring order data that sets a planned shipping quantity including a planned case shipping quantity and a planned loose shipping quantity of the product;
a counting step of acquiring a counted number by counting the planned bulk shipping quantity for each of the products based on the order data;
a transfer number acquisition step of acquiring the number of cases transferred from the case inventory to the bulk inventory by comparing the bulk inventory number with the aggregated number of the products based on the item master and the inventory data;
A method for proper inventory management comprising: An appropriate inventory management program to be executed by an appropriate inventory management device having a storage unit and a control unit,
The storage unit is
an item storage means for storing an item master in which is set the number of items per case, a standard number of items to be replenished as a criterion for replenishment, and the number of items to be replenished in the case at the time of replenishment ;
an inventory storage means for storing inventory data that sets the case inventory number of the case inventory of the product and the bulk inventory number of the bulk inventory of the product;
Equipped with
In the control unit,
a replenishment determination step of determining whether the replenishment stock reference quantity is greater than the bulk stock quantity of the product based on the item master and the inventory data;
a replenishment quantity acquisition step of acquiring the replenishment quantity to be replenished from the case inventory to the bulk inventory based on the inventory data and the item master when it is determined in the replenishment determination step that the replenishment stock reference quantity is greater than the bulk inventory quantity of the product;
An order acquisition step of acquiring order data that sets a planned shipping quantity including a planned case shipping quantity and a planned loose shipping quantity of the product;
a counting step of acquiring a counted number by counting the planned bulk shipping quantity for each of the products based on the order data;
a transfer number acquisition step of acquiring the number of cases transferred from the case inventory to the bulk inventory by comparing the bulk inventory number with the aggregated number of the products based on the item master and the inventory data;
A proper inventory management program to achieve this.

Images