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

The inventory management device addresses frequent adjustments by calculating safety stock and order points using historical data and coefficients, reducing manual effort and ensuring inventory management aligns with demand fluctuations.

JP7583753B2Active Publication Date: 2024-11-14OBIC CO LTD
View PDF 6 Cites 0 Cited by

Patent Information

Application Number
JP2022026826
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2022-02-24
Publication Date
2024-11-14
Estimated Expiration
2042-02-24

AI Technical Summary

Technical Problem

Conventional inventory management systems require frequent adjustments to safety stock quantities and order points due to fluctuations in demand, leading to tedious and frequent changes.

Method used

An inventory management device that calculates safety stock numbers and order points based on past handling records, using coefficients to adjust for fluctuations over a predetermined period, allowing these values to be set as constants rather than variables.

Benefits of technology

Reduces the frequency of manual adjustments by linking safety stock quantities and order points to average demand fluctuations, enabling efficient inventory management that adapts to changes in demand without constant recalculations.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007583753000001
    Figure 0007583753000001
  • Figure 0007583753000002
    Figure 0007583753000002
  • Figure 0007583753000003
    Figure 0007583753000003
Patent Text Reader

Abstract

To make it possible to manage inventory using the safety inventory number and ordering points that correspond to fluctuations in demand (the number handled) or the like.SOLUTION: A safety inventory number calculation unit calculates the safety inventory number by multiplying a first coefficient corresponding to the safety inventory number which indicates the minimum inventory number of an item that is set based on past handling records, by the average number of the same item handled in a predetermined period. Furthermore, an order point calculation unit calculates an order point by multiplying a second coefficient corresponding to the order point which is set based on the past handling records and indicates the inventory number to be ordered, by the average number of the same item handled in the predetermined period. This makes it possible to manage inventory based on the safety inventory number and the order point that correspond to fluctuations in demand (the number handled) or the like.SELECTED DRAWING: Figure 5
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

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

[0002] Nowadays, in businesses that supply goods such as parts or materials to manufacturers, in order to prevent shortages or excess inventory of goods, a safety stock level, which indicates the minimum number of goods to be stocked, and an order point, which indicates the number of goods to be ordered, are often set.

[0003] Regarding the safety stock quantity and order point, for example, Patent Document 1 (JP Patent Publication No. 2020-149468 A) discloses a product management system. This product management system has a performance table that holds sales, purchase, and inventory management performance data for each product, and a prediction table that holds the predicted purchase quantity and predicted inventory quantity calculated from the performance data for each product. The prediction target product is classified based on a category including seasonal attributes and trend attributes, and the predicted purchase quantity is calculated based on the purchase quantity stored in the performance table for products classified in the same category as the prediction target product. The predicted purchase quantity is calculated as the arithmetic average of the purchase quantities of products in the same category, and the predicted inventory quantity is calculated based on that.

[0004] This makes it possible to calculate with a high degree of accuracy the predicted numbers for products such as apparel items, whose purchase numbers or stock numbers are greatly influenced by attributes such as trends or seasons, and to perform inventory management without surpluses or shortages. [Prior art documents] [Patent documents]

[0005] [Patent Document 1] JP 2020-149468 A Summary of the Invention [Problem to be solved by the invention]

[0006] However, in the past, the safety stock quantity and order point for each product were managed based on the quantity, which meant that the quantities for managing the safety stock quantity and order point had to be frequently changed every time there was a change in the number of orders or shipments.

[0007] The present invention has been made in consideration of the above-mentioned problems, and aims to provide an inventory management device, an inventory management method, and an inventory management program that are capable of performing inventory management based on safety stock levels and order points that correspond to fluctuations in demand, etc. [Means for solving the problem]

[0008] In order to solve the above problems and achieve the object, the inventory management device according to the present invention includes a safety stock quantity calculation unit that calculates a safety stock quantity by multiplying an average number of the same item handled in a predetermined period by a first coefficient that is set based on past handling records and corresponds to a safety stock quantity indicating the minimum stock quantity of the item, and an order point calculation unit that calculates an order point by multiplying an average number of the same item handled in a predetermined period by a second coefficient that is set based on past handling records and corresponds to an order point indicating the stock quantity at which an order is placed, and wherein the average number of transactions is the average number of transactions in a period of a specified number of months, and the first coefficient and the second coefficient are numbers of months set based on the average number of transactions in the period of the specified number of months.

[0009] In order to solve the above-mentioned problems and achieve the object, the inventory management method according to the present invention includes a safety stock quantity calculation step in which a safety stock quantity calculation unit calculates a safety stock quantity by multiplying an average number of the same item handled in a predetermined period by a first coefficient corresponding to a safety stock quantity indicating a minimum inventory quantity of an item, which is set based on past handling records; and an order point calculation step in which an order point calculation unit calculates an order point by multiplying an average number of the same item handled in a predetermined period by a second coefficient corresponding to an order point indicating an inventory quantity for which an order is placed, which is set based on past handling records. and wherein the average number of transactions is the average number of transactions in a period of a specified number of months, and the first coefficient and the second coefficient are numbers of months set based on the average number of transactions in the period of the specified number of months.

[0010] In order to solve the above-mentioned problems and achieve the object, an inventory management program according to the present invention provides a computer that includes a safety stock number calculation unit that calculates a safety stock number by multiplying an average number of the same item handled in a predetermined period by a first coefficient that is set based on past handling records and corresponds to a safety stock number indicating a minimum inventory number of the item, and an order point calculation unit that calculates an order point by multiplying an average number of the same item handled in a predetermined period by a second coefficient that is set based on past handling records and corresponds to an order point indicating an inventory number at which an order is placed, and The average number of transactions is the average number of transactions in a period of a predetermined number of months, and the first coefficient and the second coefficient are numbers of months set based on the average number of transactions in the period of the predetermined number of months; It is characterized by: Effect of the Invention

[0011] According to the present invention, it is possible to effectively manage inventory based on safety stock quantities and order points in response to fluctuations in demand, etc. [Brief description of the drawings]

[0012] [Figure 1] FIG. 1 is a diagram for explaining the inventory management operation in an inventory management device serving as a comparative example. [Diagram 2] FIG. 2 is a diagram showing an outline of the inventory management operation of the inventory management device according to the embodiment. [Diagram 3] FIG. 3 is a block diagram illustrating a hardware configuration of the inventory management device according to the embodiment. [Figure 4] FIG. 4 is a diagram showing the relationship between data linkage items and various master data in the inventory management device according to the embodiment. [Diagram 5] FIG. 5 is a flowchart showing the flow of the operation of calculating the safety stock quantity and order point for each product in the inventory management device according to the embodiment. [Figure 6] FIG. 6 is a diagram showing an example of the order (shipment) data, the product-specific months management master, and the customer-specific product-specific months management master. [Figure 7] FIG. 7 is a diagram showing an example of the monthly quantities (number of items handled) of the same product. [Figure 8]FIG. 8 is a flowchart showing the flow of the calculation operation of the safety stock quantity and the order point for each customer and each product in the inventory management device according to the embodiment. [Figure 9] FIG. 9 is a diagram showing an example of monthly quantities (handling numbers) of the same product for each customer. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0013] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An inventory management device according to an embodiment of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that the present invention is not limited to the present embodiment.

[0014] (overview) In today's inventory management of goods (items), it is preferable to perform inventory management by adjusting safety stock quantity and order point according to fluctuations in demand. For this reason, in an inventory management device that is a comparative example to the inventory management device of the embodiment, safety stock quantity and order point are managed on a quantity basis, as shown in Figure 1(a). The example of Figure 1(a) is an example in which the safety stock quantity is set to "40,000 pieces" and the order point is set to "60,000 pieces" when the average handling quantity (order quantity or shipment quantity), which is the demand for a product with product code "S001", is, for example, "20,000 pieces."

[0015] However, when there is a change in the demand (order quantity or shipment quantity), it is necessary to change the safety stock quantity and the order point each time.In other words, if the average handling quantity (order quantity or shipment quantity) increases from "20,000 units" to "25,000 units," for example, as shown in Figure 1(b), it is necessary to change the safety stock quantity from "40,000 units" to "50,000 units," and the order point from "60,000 units" to "75,000 units."

[0016] If the safety stock quantity and order point are changed in this way in response to fluctuations in the handling quantity, there is a problem that, since fluctuations in the handling quantity occur frequently, it will be necessary to frequently change the safety stock quantity and order point stored in the memory unit (master), which is cumbersome work.

[0017] For this reason, in the inventory management device of the embodiment, the safety stock quantity and order point for each product are set as a "constant number of months (coefficient)" as shown in Figure 2(a). Then, the average of the fluctuating handling quantity is treated as a "variable", and this average handling quantity is multiplied by the number of months (coefficient) to calculate the safety stock quantity and order point for each product. The example in Figure 2(a) is an example in which the safety stock quantity months is set to "2 (months)" and the order point months is set to "3 (months)" for a product with product code "S001".

[0018] As a result, even if the number of safety stock months and the number of order point months are not changed as shown in Figure 2(b), the calculated number of safety stocks and the order point change according to the fluctuation of the average handling quantity, which is a variable. This makes it possible to significantly reduce the work of changing the number of safety stock months and the number of order point months stored in the memory unit.

[0019] (Hardware configuration) Fig. 1 is a block diagram showing a hardware configuration of an inventory management device 1 according to an embodiment. As shown in Fig. 1, the inventory management device 1 includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 may be a display unit such as a monitor device (including a home television). The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function.

[0020] The storage unit 2 may be, for example, a read only memory (ROM), a random access memory (RAM), a hard disk drive (HDD), or a solid state drive (SSD). The storage unit 2 has a product-specific months management master 11, a customer product-specific months management master 12, a customer master 13, and a product master 14, each of which is a storage area. The storage unit 2 also stores an inventory management program for managing safety stock and order point based on the above-mentioned safety stock months and order point months.

[0021] The above-mentioned safety stock number of months and order point number of months are set for each product and stored in the product-specific months management master 11. The above-mentioned safety stock number of months and order point number of months are set for each customer and product and stored in the customer product-specific months management master 12. The safety stock number of months and order point number of months stored in the product-specific months management master 11 and the customer product-specific months management master 12 are set to the number of months corresponding to the amount of inventory that needs to be held, calculated, for example, based on handling data (order data or shipping data) for a specified period in the past (for example, a specified number of months).

[0022] The customer master 13 stores unique codes and names given to each customer in association with each other. The product master 14 stores unique product codes and product names given to each product in association with each other.

[0023] (Functional configuration of inventory management device) The control unit 3 executes the inventory management program stored in the storage unit 2, thereby functioning as a quantity detection unit 21, a number of months detection unit 22, a safety stock quantity calculation unit 23, and an order point calculation unit 24.

[0024] The quantity detection unit 21 detects the handling quantity of the same product from handling data (order data or shipping data) for the past few months, or detects the handling quantity of the same product for each customer. The month number detection unit 22 detects the safety stock number of months (an example of a first coefficient) and order point number of months (an example of a second coefficient) set for the product from the product-specific month number management master 11, or detects the safety stock number of months and order point number of months set for the product from the customer product-specific month number management master 12.

[0025] The safety stock quantity calculation unit 23 calculates the safety stock quantity of the product or the safety stock quantity for that product and customer by multiplying the handling data for the past few months by the number of months of safety stock. The order point calculation unit 24 calculates the order point of that product or the order point of that product and customer by multiplying the handling data for the past few months by the number of months of order point.

[0026] Fig. 4 is a diagram showing the relationship between data linkage items and various master data. As shown in Fig. 4, order data (or shipping data) received from a customer includes various information such as customer code, product code, date, and quantity. Product-specific months management master data 11 stores product codes, safety stock months, and order point months, each associated with each other. Customer-specific months management master data 12 stores customer codes, product codes, safety stock months, and order point months, each associated with each other. Customer master data 13 stores customer codes, and product master data 14 stores product codes.

[0027] As an example, the safety stock quantity calculation unit 23 and the order point calculation unit 24 may refer to the commodity-specific months management master 11 and the customer-specific months management master 12 in order of priority. For example, if the priority of the customer-specific months management master 12 is "1" and the priority of the commodity-specific months management master 11 is "2", the safety stock quantity calculation unit 23 and the order point calculation unit 24 may refer to the customer-specific months management master 12 first, and then the commodity-specific months management master 11, and so on, in order of priority.

[0028] (Calculation of safety stock quantity and order point for each product) The flow chart of Fig. 5 shows the flow of calculation operation of safety stock quantity and order point for each product in the inventory management device 1 of the embodiment. The control unit 3 executes each process of the flow chart of Fig. 5 based on the inventory management program stored in the storage unit 2.

[0029] First, in step S1, the quantity detection unit 21 detects the quantity of products with the same product code by referring to order (shipment) data for, for example, the past three months. Specifically, an example of order (shipment) data is shown in Fig. 6. This Fig. 6 shows an example in which "300 units" of products with product code "S001" were ordered or shipped to a customer with customer code "A001" on August 20th, and "4200 units" of products with product code "S002" were ordered or shipped to a customer with customer code "A001" on the same August 20th. This Fig. 6 also shows an example in which "1800 units" of products with product code "S002" were ordered or shipped to a customer with customer code "A002" on August 20th.

[0030] Similarly, Fig. 6 shows an example where 500 units of product code "S001" were ordered or shipped to a customer with customer code "A001" on September 20th, and 3,400 units of product code "S002" were ordered or shipped to a customer with customer code "A001" on the same day. Fig. 6 also shows an example where 2,200 units of product code "S002" were ordered or shipped to a customer with customer code "A002" on September 20th.

[0031] In step S1, for example, if it is currently November, the quantity detection unit 21 detects the quantity of products with the same product code, such as "S001", from the order (shipment) data for the past three months of August, September, and October. Figure 7(a) shows the quantity of products with the product code "S001" detected in this way for August, September, and October. In this example, it shows that "300 units" of products with the product code "S001" were ordered or shipped in August, "500 units" in September, and "300 units" in October.

[0032] If it is currently December, the quantity detection unit 21 detects the quantity of the product with the product code “S001” from the order (shipment) data for the past three months, September, October, and November, as shown in FIG. 7(b).

[0033] Next, in step S2, the number of months detection unit 22 refers to the product-specific months management master 11 and detects the safety stock months and order point months set for the product with the product code "S001". FIG. 6(b) is a schematic diagram of the product-specific months management master 11. In the example of FIG. 6(b), the product-specific months management master 11 has "2 (months)" set as the safety stock months for the product with the product code "S001", and "3 (months)" set as the order point months. Therefore, in this example, the number of months detection unit 22 detects "2 (months)" as the safety stock months for the product with the product code "S001", and "3 (months)" as the order point months.

[0034] Next, in step S3, the safety stock calculation unit 23 multiplies the average quantity for the past three months by the number of months of safety stock to calculate the number of safety stocks. Specifically, for example, when calculating the number of safety stocks for November, the unit 23 adds the quantities of the product with the product code "S001" shown in FIG. 7(a) from August to October and divides by "3 (months)" to calculate the average quantity for August to October. The unit 23 then multiplies this average quantity by "2 (months)", which is the number of months of safety stock set in the product-specific months management master 11 described with reference to FIG. 6(b), to calculate the number of safety stocks for November.

[0035] Safety stock for November = ((300 units + 500 units + 300 units) ÷ 3) × 2 ≒ 733 units

[0036] Similarly, when calculating the safety stock quantity for December, for example, the safety stock quantity calculation unit 23 calculates the average quantity for September to November by adding the quantities of the product with the product code "S001" shown in Fig. 7(b) from September to November and dividing by "3 (months)".Then, the safety stock quantity for December is calculated by multiplying this average quantity by "2 (months)", which is the number of months of safety stock set in the product-specific months management master 11 described using Fig. 6(b).

[0037] Safety stock for December = ((500 units + 300 units + 1000 units) ÷ 3) × 2 = 1200 units

[0038] Next, in step S4, the order point calculation unit 24 multiplies the average quantity for the past three months by the order point number of months to calculate the order point. Specifically, for example, when calculating the order point for November, the order point is calculated by adding the quantities for August to October of the product with product code "S001" shown in Figure 7(a) and dividing by "3 (months)" to calculate the average quantity for August to October. The order point for November is then calculated by multiplying this average quantity by "3 (months)", which is the order point number of months set in the product-specific months management master 11 described using Figure 6(b).

[0039] Order quantity for November = ((300 units + 500 units + 300 units) ÷ 3) × 3 = 1100 units

[0040] Similarly, when calculating the reorder point for December, for example, the reorder point calculation unit 24 adds the quantities of the product with product code "S001" shown in Fig. 7(b) from September to November and divides by "3 (months)" to calculate the average quantity from September to November. Then, the reorder point for December is calculated by multiplying this average quantity by "3 (months)", which is the number of months for the reorder point set in the product-specific months management master 11 described using Fig. 6(b).

[0041] Order quantity for December = ((500 units + 300 units + 1000 units) ÷ 3) × 3 = 1800 units

[0042] In this way, the inventory management device 1 of the embodiment changes the calculated safety stock number and order point number according to the fluctuation of the average handling quantity, which is a variable, without changing the safety stock number months and order point number months. This significantly reduces the work of changing the safety stock number months and order point number months for each product stored in the product-specific months management master 11. Also, product inventory management can be performed with safety stock number and order point numbers that correspond to fluctuations in demand, etc.

[0043] (Calculation of safety stock quantity and order point by customer and product) Next, the flow chart of Fig. 8 shows the flow of calculation operation of safety stock quantity and order point for each customer and each product in the inventory management device 1 of the embodiment. The control unit 3 executes each process of the flow chart of Fig. 8 based on the inventory management program stored in the storage unit 2.

[0044] First, in step S11, the quantity detection unit 21 refers to the order (shipment) data for the past three months shown in Fig. 6 and detects the quantity of products with the same product code for each customer. For example, if it is currently November, the quantity detection unit 21 detects the quantity of products with product code "S002" for a customer with customer code "A001" from the order (shipment) data for the past three months for August, September, and October, as shown in Fig. 9(a). In the example of Fig. 9(a), the quantities of products with product code "S002" for a customer with customer code "A001" are "4200 units" in August, "3400 units" in September, and "3000 units" in October.

[0045] Also, as shown in Fig. 9(a), the quantity detection unit 21 detects the quantity of the product with the product code "S002" for the customer with the customer code "A002" from the order (shipment) data for the past three months of August, September, and October. In the example of Fig. 9(a), the quantity of the product with the product code "S002" for the customer with the customer code "A002" is "1800 units" in August, "2200 units" in September, and "2000 units" in October.

[0046] For example, if it is currently December, the quantity detection unit 21 detects the quantity of the product with the product code "S002" for the customer with the customer code "A001" from the order (shipment) data for the past three months, September, October, and November, as shown in Fig. 9(b). In the example of Fig. 9(b), the quantity of the product with the product code "S002" for the customer with the customer code "A001" is "3400 units" for September, "3000 units" for October, and "2000 units" for November.

[0047] Also, as shown in Fig. 9(b), the quantity detection unit 21 detects the quantity of the product with the product code "S002" for the customer with the customer code "A002" from the order (shipment) data for the past three months of September, October, and November. In the example of Fig. 9(b), the quantity of the product with the product code "S002" for the customer with the customer code "A002" is "2200 units" for September, "2000 units" for October, and "3000 units" for November.

[0048] Next, in step S12, the number of months detection unit 22 refers to the customer product-specific months management master 12 and detects the safety stock months and order point months set for each customer for the product with the product code "S002". FIG. 6(c) shows a schematic diagram of the customer product-specific months management master 12. In the example of FIG. 6(c), the customer product-specific months management master 12 has "2 (months)" set as the safety stock months and "3 (months)" set as the order point months for the product with the product code "S002" for the customer with the customer code "A001". Therefore, in this example, the number of months detection unit 22 detects "2 (months)" as the safety stock months and "3 (months)" as the order point months for the product with the product code "S002" for the customer with the customer code "A001".

[0049] 6(c), the customer product-specific months management master 12 has the safety stock months set to "2 (months)" and the order point months set to "3 (months)" for the product with product code "S002" for the customer with customer code "A002". Therefore, in this example, the months detection unit 22 detects "2 (months)" as the safety stock months and "3 (months)" as the order point months for the product with product code "S002" for the customer with customer code "A002".

[0050] Next, in step S13, the safety stock quantity calculation unit 23 multiplies the average quantity for the past three months by the number of months of safety stock to calculate the safety stock quantity for each customer. Specifically, for example, when calculating the safety stock quantity for November for a product with a product code of "S002" for a customer with a customer code of "A001", the safety stock quantity calculation unit 23 adds the quantities of the product with the product code of "S002" for the customer with the customer code of "A001" shown in Fig. 9(a) from August to October and divides by "3 (months)". This makes it possible to calculate the average quantity of the product with the product code of "S002" for the customer with the customer code of "A001" from August to October. Then, the safety stock quantity calculation unit 23 multiplies this average quantity by the number of months of safety stock "2 (months)" set in the customer-specific product months management master 12 described using Figure 6 (c), to calculate the safety stock quantity for November of the product code "S002" for the customer code "A001".

[0051] Safety inventory quantity for product "S002" of customer "A001" in November = ((4200 units + 3400 units + 3000 units) ÷ 3) × 2 ≒ 7066 units

[0052] Similarly, when calculating the safety stock quantity for November of the product code "S002" for the customer code "A002", the safety stock quantity calculation unit 23 adds the quantities of the product code "S002" for the customer code "A002" shown in FIG. 9(a) from August to October and divides by "3 (months)". This allows the average quantity of the product code "S002" for the customer code "A002" from August to October to be calculated. Then, the safety stock quantity calculation unit 23 multiplies this average quantity by "2 (months)", which is the number of months of safety stock for the customer code "A002" set in the customer product monthly number management master 12 described using FIG. 6(c), to calculate the safety stock quantity for November of the product code "S002" for the customer code "A002".

[0053] Safety inventory quantity for product "S002" of customer "A002" in November = ((1800 units + 2200 units + 2000 units) ÷ 3) × 2 = 4000 units

[0054] Next, in step S14, safety stock calculation unit 23 calculates the sum of the safety stocks calculated for each customer as the safety stock for the product with product code "S002". In the above example, the safety stock for November for product "S002" of customer "A001" is "7066 units", and the safety stock for November for product "S002" of customer "A002" is "4000 units". Therefore, safety stock calculation unit 23 calculates the safety stock for November for product "S002" by calculating "7066 units + 4000 units = 11066 units".

[0055] Also, for example, when calculating the safety stock quantity for December of the product code "S002" for the customer code "A001", the safety stock quantity calculation unit 23 adds the quantities of the product code "S002" for the customer code "A001" shown in FIG. 9(b) from September to November and divides by "3 (months)". This allows the average quantity of the product code "S002" for the customer code "A001" from September to November to be calculated. Then, the safety stock quantity calculation unit 23 multiplies this average quantity by "2 (months)", which is the number of months of safety stock set in the customer product-specific months management master 12 described using FIG. 6(c), to calculate the safety stock quantity for December of the product code "S002" for the customer code "A001".

[0056] Safety inventory quantity for product "S002" of customer "A001" in December = ((3400 units + 3000 units + 2000 units) ÷ 3) × 2 = 5600 units

[0057] Similarly, when calculating the safety stock quantity for December of the product code "S002" for the customer code "A002", the safety stock quantity calculation unit 23 adds the quantities of the product code "S002" for the customer code "A002" shown in FIG. 9(b) from September to November and divides by "3 (months)". This allows the average quantity of the product code "S002" for the customer code "A002" from September to November to be calculated. Then, the safety stock quantity calculation unit 23 multiplies this average quantity by "2 (months)", which is the number of months of safety stock for the customer code "A002" set in the customer product-specific months management master 12 described using FIG. 6(c), to calculate the safety stock quantity for December of the product code "S002" for the customer code "A002".

[0058] Safety inventory quantity for product "S002" of customer "A002" in December = ((2200 units + 2000 units + 3000 units) ÷ 3) × 2 = 4800 units.

[0059] Next, in step S14, safety stock calculation unit 23 calculates the sum of the safety stocks calculated for each customer as the safety stock for the product with product code "S002". In the above example, the December safety stock for product "S002" for customer "A001" is "5600 units", and the December safety stock for product "S002" for customer "A002" is "4800 units". Therefore, safety stock calculation unit 23 calculates the December safety stock for product "S002" by calculating "5600 units + 4800 units = 10400 units".

[0060] Next, in step S15, the order point calculation unit 24 multiplies the average quantity for the past three months by the order point number of months to calculate the order point for each customer. Specifically, for example, when calculating the order point for November for a product with product code "S002" for a customer with customer code "A001", the order point calculation unit 24 adds the quantities of the product with product code "S002" for the customer with customer code "A001" shown in Fig. 9(a) from August to October and divides by "3 (months)". This makes it possible to calculate the average quantity of the product with product code "S002" for the customer with customer code "A001" from August to October. Then, the order point calculation unit 24 multiplies this average quantity by the order point of "3 (months)" set in the customer-specific product-by-month management master 12 described using Figure 6 (c), to calculate the order point for November of the product code "S002" for the customer code "A001".

[0061] The order quantity for product "S002" for customer "A001" in November = ((4200 units + 3400 units + 3000 units) ÷ 3) × 3 = 10600 units

[0062] Similarly, when calculating the order point for November for the product code "S002" for the customer code "A002", the order point calculation unit 24 adds the quantities of the product code "S002" for the customer code "A002" shown in FIG. 9(a) from August to October and divides by "3 (months)". This allows the average quantity of the product code "S002" for the customer code "A002" from August to October to be calculated. The order point calculation unit 24 then multiplies this average quantity by "3 (months)", which is the order point number of months for the customer code "A002" set in the customer-product-specific months management master 12 described with reference to FIG. 6(c), to calculate the order point for November for the product code "S002" for the customer code "A002".

[0063] The order quantity for product "S002" for customer "A002" in November = ((1800 units + 2200 units + 2000 units) ÷ 3) × 3 = 6000 units

[0064] Next, in step S16, the order point calculation unit 24 adds up the order points calculated for each customer and calculates the sum as the order point for the product with product code "S002". In the above example, the order point for November for product "S002" for customer "A001" is "10,600 units", and the order point for November for product "S002" for customer "A002" is "6,000 units". Therefore, the order point calculation unit 23 calculates the order point for November for product "S002" by calculating "10,600 units + 6,000 units = 16,600 units".

[0065] For example, when calculating the reorder point for December for a product with a product code of "S002" for a customer with a customer code of "A001", the reorder point calculation unit 24 adds the quantities of the product with the product code of "S002" for the customer with the customer code of "A001" shown in FIG. 9(b) from September to November, and divides by "3 (months)". This makes it possible to calculate the average quantity of the product with the product code of "S002" for the customer with the customer code of "A001" from September to November. The reorder point calculation unit 24 then multiplies this average quantity by the reorder point of "3 (months)" set in the customer-specific product number of months management master 12 described with reference to FIG. 6(c), thereby calculating the reorder point for December for the product code of "S002" for the customer with the customer code of "A001".

[0066] The order quantity for product "S002" for customer "A001" in December = ((3400 units + 3000 units + 2000 units) ÷ 3) × 3 = 8400 units

[0067] Similarly, when calculating the order point for December for a product with a product code of "S002" for a customer with a customer code of "A002", the order point calculation unit 24 adds the quantities of the product with the product code of "S002" for the customer with the customer code of "A002" shown in FIG. 9(b) from September to November, and divides by "3 (months)". This allows the average quantity of the product with the product code of "S002" for the customer with the customer code of "A002" from September to November to be calculated. The order point calculation unit 24 then multiplies this average quantity by "3 (months)", which is the order point number of months for the customer with the customer code of "A002", set in the customer-product-specific-months management master 12 described with reference to FIG. 6(c), to calculate the order point for December for the product code of "S002" for the customer with the customer code of "A002".

[0068] "A002" customer's December order quantity for "S002" product = ((2200 units + 2000 units + 3000 units) ÷ 3) × 3 = 7200 units

[0069] Next, in step S16, the order point calculation unit 24 adds up the order points calculated for each customer and calculates the sum as the order point for the product with product code "S002". In the above example, the order point for customer "A001" for product "S002" in December is "8,400 units", and the order point for customer "A002" and product "S002" in December is "7,200 units". Therefore, the order point calculation unit 24 calculates the order point for product "S002" in December by calculating "8,400 units + 7,200 units = 15,600 units".

[0070] In this way, the inventory management device 1 of the embodiment changes the calculated safety stock number and order point number according to the fluctuation of the average handling quantity, which is a variable, without changing the safety stock number of months and order point number of months. This makes it possible to significantly reduce the work of changing the safety stock number of months and order point number of months for each customer and product stored in the customer-product-specific months management master 12. Also, product inventory management can be performed with the safety stock number and order point for each customer and product that correspond to fluctuations in demand, etc.

[0071] (Effects of the embodiment) As is clear from the above explanation, the inventory management device 1 in the embodiment sets the safety stock quantity and the number of months corresponding to the order point for each product or for each product and customer, and multiplies this safety stock quantity and the number of months corresponding to the order point by the number of orders, shipments, etc. handled to calculate the safety stock quantity and the order point.

[0072] As a result, the calculated safety stock number and order point number change according to the fluctuation of the average handling quantity, which is a variable, without changing the safety stock number months and order point number months. This makes it possible to significantly reduce the work of changing the safety stock number months and order point number months for each customer and product stored in the product-specific month number management master 11 or the customer-specific product-specific month number management master 12. Also, product inventory management can be performed with the safety stock number and order point for each customer and product that correspond to the fluctuation of demand (handling quantity), etc.

[0073] In addition, as shown in FIG. 6(c), by setting the customer product-specific months management master 12 using the customer code and product code as keys, the safety stock quantity and order point "months" of the same product handled by multiple customers can be set for each customer representative, thereby enabling inventory management.

[0074] [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, and can therefore contribute to Goals 8 and 9 of the SDGs.

[0075] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of Goals 12, 13, and 15 of the SDGs.

[0076] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

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

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

[0080] Furthermore, with regard to the inventory management device 1, the components shown in the figures are merely conceptual functional components, and the device does not necessarily have to be physically configured as shown in the figures.

[0081] For example, the processing functions of the inventory management device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be realized in whole or in part by a CPU (Central Processing Unit) 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 containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the inventory management device 1 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processing is recorded in a storage unit such as a ROM or HDD. This computer program is executed by being loaded into a RAM, and constitutes the control unit 3 in cooperation with the CPU.

[0082] In addition, the inventory management program of this inventory management device 1 may be stored in another server device connected to the inventory management device 1 via any network, and it is also possible to download all or part of it as needed.

[0083] In addition, the inventory management 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 term "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.

[0084] 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 distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading a recording medium in the inventory management device 1 shown in the embodiment, as well as the installation procedure after reading.

[0085] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.

[0086] The inventory management device 1 may be configured as an information processing device such as a known personal computer device or a workstation, or may be configured as an information processing device connected to any peripheral device. The information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.

[0087] Furthermore, the specific form of distribution and integration of the devices is not limited to those 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 function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0088] The present invention is useful for businesses that perform inventory management by reviewing safety stock and order points in response to increases or decreases in the number of orders. [Explanation of symbols]

[0089] 1. Inventory management device 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 11 Product-specific months management master 12 Customer product-specific months management master 13 Customer Master 14 Product Master 21 Quantity detection unit 22 Month Number Detection Unit 23 Safety Stock Calculation Section 24 Order point calculation section

Claims

1. a safety stock quantity calculation unit that calculates a safety stock quantity by multiplying an average number of the same item handled in a predetermined period by a first coefficient corresponding to a safety stock quantity indicating a minimum inventory quantity of the item, the safety stock quantity being set based on past handling records; an order point calculation unit that calculates an order point by multiplying the average number of items handled of the same product in a predetermined period by a second coefficient that is set based on past handling records and corresponds to an order point indicating an inventory quantity to be ordered, The average number of transactions is the average number of transactions over a period of a predetermined number of months, The first coefficient and the second coefficient are months set based on the average number of handlings during a period of a predetermined number of months; An inventory management device comprising:

2. The safety stock quantity calculation unit calculates the safety stock quantity by adding up the safety stock quantity calculated for each customer for a predetermined period, the order point calculation unit calculates the order point by adding up the order points calculated for each customer for a predetermined period; 2. The inventory management device according to claim 1,

3. a safety stock quantity calculation step in which a safety stock quantity calculation unit calculates a safety stock quantity by multiplying an average handling quantity of the same item in a predetermined period by a first coefficient corresponding to a safety stock quantity indicating a minimum inventory quantity of the item, the first coefficient being set based on past handling records; an order point calculation step in which an order point calculation unit calculates an order point by multiplying the average number of items handled for a predetermined period by a second coefficient corresponding to an order point indicating an inventory quantity to be ordered, the second coefficient being set based on past handling records; The average number of transactions is the average number of transactions over a period of a predetermined number of months, The first coefficient and the second coefficient are months set based on the average number of handlings during a period of a predetermined number of months; An inventory management method comprising:

4. Computer, a safety stock quantity calculation unit that calculates a safety stock quantity by multiplying an average number of the same item handled in a predetermined period by a first coefficient corresponding to a safety stock quantity indicating a minimum inventory quantity of the item, the safety stock quantity being set based on past handling records; functioning as an order point calculation unit that calculates an order point by multiplying the average number of items handled for a predetermined period by a second coefficient that corresponds to an order point indicating an inventory quantity to be ordered and that is set based on past handling records; The average number of transactions is the average number of transactions over a period of a predetermined number of months, The first coefficient and the second coefficient are months set based on the average number of handlings during a period of a predetermined number of months; An inventory management program that features:

Citation Information

Patent Citations

  • Stock control system, its stock control method and recording medium with program for stock control recorded

    JP2001253512A

  • Physical distribution management support system

    JP2002099595A

  • Order quantity calculation system

    JP2005015140A

  • Information processing device, information processing system, information processing method and program

    JP2015108928A

  • Proper inventory determination support apparatus, method thereof, and program therefor

    JP2020017127A