Appropriate inventory management device, appropriate inventory management method, and appropriate inventory management program
The inventory management system efficiently allocates bulk inventory to shipments of varying sizes by separating case and bulk inventory, enhancing picking and packing operations through automated transfer calculations.
Patent Information
- Application Number
- JP2021029158
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2021-02-25
- Publication Date
- 2024-11-19
- Estimated Expiration
- 2041-02-25
AI Technical Summary
Existing inventory management systems fail to allocate bulk inventory efficiently to shipments of varying sizes, particularly for fractional numbers of items, leading to inefficiencies in picking and packing operations.
An inventory management device and method that separates case and bulk inventory, using an appropriate inventory coefficient to automatically calculate and manage inventory transfers based on order data, ensuring efficient allocation and replenishment.
Facilitates efficient picking and packing by separating large and small inventory, allowing simultaneous forklift and manual picking, and enables effective replenishment of inventory for both large and small lot sizes, reducing waiting times and improving overall warehouse efficiency.
Smart Images

Figure 0007586732000001 
Figure 0007586732000002 
Figure 0007586732000003
Abstract
Description
[Technical field]
[0001] The present invention relates to an optimum inventory management device, an optimum inventory management method, and an optimum inventory management program. [Background technology]
[0002] 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 the remaining number of shipments. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2002-205810 A Summary of the Invention [Problem to be solved by the invention]
[0004] However, the invention described in Patent Document 1 above had a problem in that it was not possible to use bulk inventory for shipments only for the bulk quantities that were fractional parts of the shipment quantity of each item, taking into account the number of cases.
[0005] The present invention has been made in consideration of the above problems, and aims to provide an optimum inventory management device, an optimum inventory management method, and an optimum inventory management program that can automatically calculate the amount of inventory replenishment from large-lot inventory to small-lot inventory based on the optimum inventory coefficient and the number of backorders, and perform transfer processing. [Means for solving the problem]
[0006] 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 equipped with a memory unit and a control unit, wherein the memory unit comprises an item memory means for storing an item master setting the quantity per case of a product, and an inventory memory means for storing inventory data setting the case inventory number of the product in case inventory and the bulk inventory number of the product in bulk inventory, and the control unit comprises an order acquisition means for acquiring order data setting the planned case shipment number of the product and the planned shipping number including the planned bulk shipment number, an aggregation means for acquiring an aggregate number by aggregating the planned bulk shipment number for each product based on the order data, and a transfer number acquisition means for comparing the bulk inventory number with the aggregate number of the product based on the item master and the inventory data, and acquiring the number of cases transferred from the case inventory to the bulk inventory.
[0007] In addition, in the optimum inventory management device of the present invention, the item master further sets a replenishment inventory standard number for the product that is used as a basis for replenishment judgment, and the number of replenishments to be made in the case at the time of inventory replenishment, and the control unit further includes a replenishment judgment means for judging whether the replenishment inventory standard 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 inventory standard number is greater than the bulk inventory number of the product.
[0008] In addition, in the optimal inventory management device of the present invention, the inventory data further has a lot number set, the order acquisition means further acquires lot-designated order data setting 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 counting means further acquires a lot-designated total number which counts the planned bulk shipping number of the product of the designated lot number based on the lot-designated order data, and the transfer number acquisition means further acquires a lot-designated transfer number which is the number of cases of the designated lot number transferred from the case inventory to the bulk inventory by comparing the bulk inventory number of the designated lot number with the lot-designated total number based on the item master and the inventory data.
[0009] In addition, in the optimal inventory management device of the present invention, the counting means further acquires a remaining total number by tallying up the planned bulk shipment quantities 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 number, and acquiring the remaining bulk inventory quantity by subtracting the lot-designated total number from the bulk inventory quantity, and the transfer number acquisition means further compares the remaining bulk inventory quantity with the remaining total number based on the item master, and acquires the remaining transfer number, which is the number of cases transferred from the case inventory to the bulk inventory.
[0010] In addition, in the optimal inventory management device of the present invention, the memory unit further includes a location memory 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 aggregated number of the product based on the location master, the item master, and the inventory data.
[0011] In addition, in the optimum inventory management device of the present invention, the inventory data is further set with a lot number, and when the replenishment determination means determines that the replenishment inventory standard quantity is greater than the bulk inventory quantity of the product, the replenishment quantity acquisition means identifies the cases of the replenishment quantity 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.
[0012] In the optimum inventory management device according to the present invention, the product is a food product, an electric part, an electronic part, or a machine part.
[0013] In addition, the optimum inventory management method of the present invention is an optimum inventory management method to be executed by an optimum inventory management device having a memory unit and a control unit, the memory unit comprising an item memory means for storing an item master setting the quantity of a product per case, and an inventory memory means for storing inventory data setting the case inventory number of the product in case inventory and the bulk inventory number of the product in bulk inventory, and is characterized in that the method includes an order acquisition step to be executed by the control unit, acquiring order data setting the planned case shipment number of the product and the planned shipping number including the planned bulk shipment number, a counting step for acquiring a total number by counting the planned bulk shipment numbers for each product based on the order data, and a transfer number acquisition step for comparing the bulk inventory number with the total number of the product based on the item master and the inventory data, and acquiring the number of cases transferred from the case inventory to the bulk inventory.
[0014] In addition, the optimal inventory management program of the present invention is an optimal inventory management program to be executed by an optimal inventory management device having a memory unit and a control unit, wherein the memory unit comprises an item memory means for storing an item master setting the quantity per case of a product, and an inventory memory means for storing inventory data setting the case inventory number of the product in case inventory and the bulk inventory number of the product in bulk inventory, and the control unit executes an order acquisition step for acquiring order data setting the planned case shipment number of the product and the planned shipping number including the planned bulk shipment number, a counting step for acquiring a total number by counting the planned bulk shipment numbers for each product based on the order data, and a transfer number acquisition step for comparing the bulk inventory number with the total number of the product based on the item master and the inventory data to acquire the number of cases transferred from the case inventory to the bulk inventory. Effect of the Invention
[0015] According to the present invention, it is possible to efficiently carry out picking and packing in a logistics warehouse. 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. According to the present invention, it is possible to logically calculate the number of cases to be expanded into loose from the number of orders, although the number of cases to be expanded into loose is usually calculated manually in a warehouse according to the order status. According to the present invention, it is possible to replenish the shortage of inventory for a small lot size shipping schedule from a large lot size, and furthermore, it is possible to replenish the shortage of inventory for a small lot size safety stock (master setting) from a large lot size. According to the present invention, it is also useful for case / ball or ball / loose, and it is possible to effectively utilize it not only for case / loose. According to the present invention, it is also possible to apply it not only to the food industry, where the requirement for loose packaging management is very high, but also to other vendors. Furthermore, according to the present invention, not only can the packaging style be managed, but also the case can be managed separately using the same code. [Brief description of the drawings]
[0016] [Figure 1] FIG. 1 is a diagram showing an example of an appropriate inventory management process in this embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of an appropriate inventory management process in this embodiment. [Diagram 3] FIG. 3 is a block diagram showing an example of the configuration of the optimum inventory management device in this embodiment. [Figure 4] FIG. 4 is a flowchart showing an example of the process of the optimum inventory management device in this embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of an appropriate inventory management process in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of an appropriate inventory management process in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of an appropriate inventory management process in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of an appropriate inventory management process in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of an appropriate inventory management process in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of an appropriate inventory management process in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0017] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.
[0018] [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.
[0019] Previously, in operations involving shipping both large and small lots, picking by forklift and manual picking were mixed, so once the number of items to be shipped on the day was decided, forklift picking and manual picking had to be carried out simultaneously, and inventory had to be replenished at the area where bulk shipping was done manually before case shipping work began by forklift.
[0020] As a result, in the past, when inventory was managed based on the total number of loose 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.As a result, when picking work was divided among multiple staff or multiple locations, waiting times often occurred.
[0021] Therefore, in this embodiment, a mechanism is provided in which case inventory and bulk inventory are managed by separate locations within the system, and the amount of inventory to be transferred from the case location to the bulk location is automatically calculated based on the appropriate amount of bulk inventory and the planned number of items to be shipped today.
[0022] For example, as shown in Fig. 1, in this embodiment, a primary replenishment process is performed to replenish inventory from the case shelf to the bulk shelf according to the setting of the item master. That is, as shown in Fig. 1, in this embodiment, the current inventory quantity is compared with the appropriate small lot inventory quantity setting set in the item master, and if the bulk shelf inventory is lower, the shortage quantity is automatically moved to a different location by transferring inventory from the case shelf to the bulk shelf.
[0023] Also, as shown in Fig. 2, in this embodiment, a secondary replenishment process is performed in which inventory is replenished from the case shelf to the bulk shelf according to the scheduled shipment quantity. That is, as shown in Fig. 2, in this embodiment, the current inventory quantity is compared with the scheduled 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 withdrawn from each location.
[0024] [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.
[0025] 3, the optimum inventory management device 100 is a commercially available desktop personal computer. 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, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0026] The optimum inventory management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the optimum inventory management device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0027] The communication interface unit 104 communicatively connects the optimum 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 optimum inventory management device 100 and the server 200 to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).
[0028] 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 cooperates with a mouse to realize 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.
[0029] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. 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 as the storage unit 106. The storage unit 106 includes an item master 106a, a location master 106b, and an inventory database 106c.
[0030] The item master 106a is a master that sets the number of items per case. Here, the item master 106a may set a standard number of items to be replenished, which is the basis for replenishment judgment, and the number of cases to be replenished when replenishing the inventory. The items may be food, electric parts, electronic parts, or machine parts.
[0031] The location master 106b is a master that sets the location of the inventory of the product. Here, the location master 106b may set the locations of the case inventory and the bulk inventory of the product.
[0032] The inventory database 106c stores inventory data of 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. Also, the inventory data may be set with a lot number.
[0033] 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 functional concepts, 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.
[0034] The replenishment determination unit 102a determines whether the replenishment stock reference quantity of the product is greater than the bulk stock quantity of the product, based on the item master 106a and the stock data.
[0035] The replenishment number acquisition unit 102b acquires the number of replenishment cases to be replenished from the case stock to the bulk stock. Here, when the replenishment determination unit 102a determines that the replenishment stock reference number of the product is greater than the bulk stock number of the product, the replenishment number acquisition unit 102b may acquire the number of replenishment cases to be replenished from the case stock to the bulk stock based on the inventory data and the item master 106a. Also, when the replenishment determination unit 102a determines that the replenishment stock reference number of the product is greater than the bulk stock number of the product, the replenishment number acquisition unit 102b may identify the number of replenishment cases to be replenished from the case stock to the bulk stock in order of lot numbers based on the inventory data and the item master 106a.
[0036] The order acquisition unit 102c acquires order data for a product. Here, the order acquisition unit 102c may acquire order data in which a planned shipping quantity including a planned case shipping quantity of the product and a planned loose shipping quantity is set. The order acquisition unit 102c may also acquire lot-designated order data in which a designated lot number of the product and a planned shipping quantity including a planned case shipping quantity of the product and a planned loose shipping quantity are set.
[0037] The counting unit 102d acquires a counted number by tallying up the planned bulk shipment quantity for each product based on the order data. Here, the counting unit 102d may acquire a lot-designated count by tallying up the planned bulk shipment quantity of a product with a designated lot number based on the lot-designated order data. The counting unit 102d may also acquire a remaining count by tallying up the planned bulk shipment quantity of a product other than the designated lot number based on the order data and the lot-designated order data.
[0038] The transfer number acquisition unit 102e acquires the number of cases transferred from the case inventory to the bulk inventory. Here, the transfer number acquisition unit 102e may acquire the number of cases transferred from the case inventory to the 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 the inventory data. The transfer number acquisition unit 102e may also acquire the lot-designated transfer number, which 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 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 the case inventory to the 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 the case inventory to the bulk inventory by comparing the bulk inventory number of the product with the total number of the product based on the location master 106b, the item master 106a, and the inventory data.
[0039] The inventory update unit 102f updates the inventory data of the product. 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 transfer quantity, and obtain the remaining bulk inventory quantity by subtracting the lot designated total quantity from the bulk inventory quantity.
[0040] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.
[0041] [Proper inventory management process] Here, an example of an optimum inventory management process in this embodiment will be described with reference to Fig. 4. Fig. 4 is a flowchart showing an example of the process of the optimum inventory management device 100 in this embodiment.
[0042] As shown in FIG. 4, the replenishment determination unit 102a determines whether the replenishment inventory reference quantity of the product is greater than the bulk inventory quantity of the product, based on the item master 106a and the inventory data stored in the inventory database 106c (step SA-1).
[0043] If the replenishment determination unit 102a determines that the replenishment stock reference quantity of the product is not greater than the bulk stock quantity of the product (step SA-1: No), the replenishment determination unit 102a shifts the process to step SA-4.
[0044] On the other hand, if the replenishment determination unit 102a determines that the replenishment stock reference quantity of the product is greater than the bulk stock quantity of the product (step SA-1: Yes), the replenishment determination unit 102a shifts the process to step SA-2.
[0045] 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).
[0046] 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).
[0047] Then, the order acquisition unit 102c acquires order data that sets the planned shipping quantity, including the planned case shipping quantity of the product and the planned loose shipping quantity (step SA-4).
[0048] Then, the counting unit 102d acquires a counted number obtained by counting the planned bulk shipment quantity for each product based on the order data (step SA-5).
[0049] Then, the transfer number obtaining unit 102e determines whether or not the loose inventory number 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).
[0050] Then, if the loose inventory quantity of the product is not less than the total number of the product (step SA-6: No), the transfer number obtaining unit 102e shifts the process to step SA-7.
[0051] Then, when the case shipment planned number 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-7) and terminates the process.
[0052] On the other hand, if the loose inventory quantity of the product is less than the total number of the product (step SA-6: Yes), the transfer number obtaining unit 102e shifts the process to step SA-8.
[0053] Then, the transfer number obtaining unit 102e obtains the number of cases transferred from the case inventory to the bulk inventory based on the location master 106b, the item master 106a, and the inventory data (step SA-8).
[0054] 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 terminates the processing.
[0055] An example of an appropriate inventory management process in this embodiment will now be described with reference to Figures 5 to 10. Figures 5 to 10 are diagrams showing an example of an appropriate inventory management process in this embodiment.
[0056] In the first bulk replenishment process 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 case, when the item master 106a and the location master 106b are set as shown in Fig. 5, and the inventory data of warehouse A is stored in the inventory database 106c, the replenishment inventory standard quantity = 2 cases set in the item master 106a is insufficient with the current inventory quantity = 1 case, as shown in Fig. 6, the replenishment inventory standard quantity = 2 cases set in the item master 106a is controlled to be moved from the case location to the bulk location. Here, in this embodiment, when the replenishment inventory standard quantity = 2 cases is replenished from the case location (CS00000001) to the bulk location (PC00000001) as shown in Fig. 6, the oldest lot numbers are allocated in order.
[0057] Then, the inventory quantity in bulk location 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.As a secondary bulk replenishment process in this embodiment, when order data is acquired and location master 106b is set as shown in FIG. 7, the fractional bulk quantities of the order data are aggregated for each specified lot number as shown in FIG. 8, and if no lot is specified, the fractional bulk quantities of the order data are aggregated as no lot is specified, and the inventory data is referenced.
[0058] Then, as the lot designation processing in this embodiment, as shown in FIG. 9, the aggregated order data is checked to see if replenishment of the designated lot number is necessary, 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).
[0059] In this embodiment, as shown in FIG. 10, for the inventory data in which subtraction and addition are reflected by lot number specification, the total bulk quantity is aggregated, and the effective quantity (remaining bulk inventory quantity) is calculated by subtracting the allocated quantity for the specified lot number as the non-lot specification processing, 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.
[0060] [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 contributing to goals 8 and 9 of the SDGs.
[0061] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0062] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0063] 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.
[0064] 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 known methods.
[0065] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0066] Furthermore, with regard to the optimum inventory management system 100, the components shown in the figures are merely conceptual functional elements, and the system does not necessarily have to be physically configured as shown in the figures.
[0067] 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 in a non-transient computer-readable recording medium that includes 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 for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.
[0068] In addition, this computer program may be stored in an application program server connected to the optimum inventory management device 100 via any network, and it is also possible to download all or part of it as needed.
[0069] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.
[0070] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a configuration that is distributed as a plurality of modules or libraries, and a program that achieves its function by cooperating with a separate program, such as an OS. 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, may use well-known configurations and procedures.
[0071] The various databases etc. stored in the memory unit 106 are storage means 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 etc. used for various processes and providing websites.
[0072] The optimum inventory management device 100 may be configured as an information processing device such as a known personal computer or a 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 installing software (including programs or data) that causes the device to realize the processing described in this embodiment.
[0073] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to 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. [Industrial Applicability]
[0074] The present invention is useful in industries such as food, electrical, electronic, or mechanical parts where there are operations that ship inventory in cases and bulk. [Explanation of symbols]
[0075] 100 Optimal inventory control device 102 Control section 102a Replenishment judgment section 102b Replenishment number acquisition part 102c Order Acquisition Department 102d Counting Department 102e Movement number acquisition part 102F Inventory Update Department 104 Communication interface section 106 Storage section 106a Item Master 106b Location Master 106c Inventory Database 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network
Claims
1. 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:
2. 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.
3. 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 a remaining transfer quantity, which is the number of cases transferred from the case inventory to the bulk inventory, to obtain a remaining transfer quantity.
4. 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.
5. 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.
6. 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.
7. 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:
8. 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.
Citation Information
Patent Citations
System for allocating stock among plural warehouses
JP1994215013A
Part control facility
JP1999059828A
Picking method and device
JP2002205810A
Picking system and picking method
WO2017175301A1
