Inventory planning system and inventory planning method

The inventory planning system addresses transportation capacity strains and demand fluctuations by setting upper limits on transportation volume, reducing costs through advanced planning and minimizing stockouts.

JP7579121B2Active Publication Date: 2024-11-07LOGISTEED LTD
View PDF 6 Cites 0 Cited by

Patent Information

Application Number
JP2020196864
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2020-11-27
Publication Date
2024-11-07
Estimated Expiration
2040-11-27

AI Technical Summary

Technical Problem

The logistics industry faces challenges with strained transportation capacity due to driver shortages and fluctuating demand for products, leading to potential delivery delays and stockouts, especially for seasonal items like apparel and air conditioners.

Method used

An inventory planning system that calculates a predicted demand amount and sets an upper limit on transportation volume based on statistical data of demand forecast errors, determining the amount of goods to transport in advance, considering the number of days until the requested arrival date to minimize costs.

Benefits of technology

This approach reduces storage and disposal costs by planning transportation volumes that meet the upper limits, minimizing the total cost of the supply chain, including transportation, storage, and disposal costs.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007579121000009
    Figure 0007579121000009
  • Figure 0007579121000010
    Figure 0007579121000010
  • Figure 0007579121000011
    Figure 0007579121000011
Patent Text Reader

Abstract

To make an inventory plan that consists of a transport good quantity, a quantity of come-in and come-out goods, and quantity of goods held in stock by day so as not to cause a delivery delay or an out-of-stock good even when the number of transport vehicles has an upper limit.SOLUTION: An inventory planning method performs, by a computation device that executes prescribed processing with an accessible memory, the steps of: determining a transport quantity upper limit in a daily unit on the basis of a demand forecast quantity, and statistic data on a varying demand forecast error according to a number of days until an arrival request day; determining a transport quantity and a number of transportation vehicles so as to satisfy the transport quantity upper limit and an upper limit on the number of transportation vehicles; calculating quantities of come-in and come-out goods, and quantity of goods held in stock from the transport quantity; calculating a transport cost, storage cost and disposal cost from the transport quantity, number of transportation vehicles, quantities of come-in and come-out goods and quantity of goods held in stock; and outputting an inventory plan, in which a total cost being a total sum of the costs is minimum, consisting of the transport quantity, number of transportation vehicles, quantities of come-in and come-out goods, and quantity of goods held in stock.SELECTED DRAWING: Figure 1
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to an inventory planning system and an inventory planning method. [Background technology]

[0002] In conventional logistics operations, inventory plans were created based on order quantities, transportation volumes, and inventory volumes by day and product to minimize total costs.

[0003] The following prior art is known as background art in this technical field. Patent Document 1 describes an ordering method selection system that calculates the order quantity when ordering goods while changing the parameters of various ordering methods such as the regular fixed quantity method, the irregular fixed quantity method, the regular unfixed quantity method, and the irregular unfixed quantity method, simulates the inventory quantity, calculates the total cost required for inventory management, and calculates the specific value of the ordering parameters when the total cost is minimized. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] JP 2017-199282 A Summary of the Invention [Problem to be solved by the invention]

[0005] In recent years, the logistics industry has been strained by a shortage of drivers, which has led to a shortage of transportation capacity. On the other hand, products with sudden changes in demand, or seasonal products such as apparel and air conditioners, which cannot be sold if the opportunity is missed, need to be sold in large quantities during a short busy period.

[0006] Therefore, when an inventory plan is made without taking into consideration the upper limit of the number of units to be transported, as in Patent Document 1, there is a problem that the amount of units exceeding the upper limit will result in delivery delays and shortages.

[0007] Therefore, even when there is a limit on the number of units that can be transported, the challenge is to create an inventory plan that includes daily transportation volumes, incoming and outgoing volumes, and inventory levels so as to avoid delivery delays and stockouts. [Means for solving the problem]

[0008] The present invention provides an inventory planning system having a calculation device that executes a predetermined process and a memory accessible by the calculation device, wherein the calculation device receives as input a previously set demand forecast amount of an item and statistical data of a demand forecast error that changes depending on the number of days until the required arrival date of the item, performs a predetermined process on the demand forecast amount and the statistical data, and determines and outputs an upper limit of the transportation amount of the item. The calculation device uses an upper limit of the number of days for forward transportation in the case of transporting an item ahead of the arrival request date in determining the upper limit of the transportation volume. . Effect of the Invention

[0009] According to one aspect of the present invention, by setting an upper transport volume limit based on demand forecast volume and statistical data on demand forecast error that changes depending on the number of days until the required arrival date, a transport volume that reduces storage costs and disposal costs due to excess inventory that occurs when demand drops can be planned. In addition, by creating an inventory plan that satisfies the upper transport volume limit and the upper transport number limit and minimizes the total cost including the transportation cost, storage cost, and disposal cost added per vehicle, it is possible to determine a transport volume that minimizes the cost of the entire supply chain.

[0010] The details of at least one implementation of the subject matter disclosed herein are set forth in the accompanying drawings and the description below. Other features, aspects, and advantages of the disclosed subject matter will become apparent from the following disclosure, drawings, and claims. [Brief description of the drawings]

[0011] [Figure 1] 1 is a block diagram illustrating an example of a configuration of an inventory planning system according to an embodiment of the present invention. [Diagram 2] FIG. 10 illustrates an example of product information according to the embodiment of the present invention. [Diagram 3] FIG. 11 illustrates an example of base information according to the embodiment of the present invention. [Figure 4] FIG. 2 illustrates an example of demand forecast information according to the embodiment of the present invention. [Diagram 5] FIG. 11 illustrates an example of route information according to the embodiment of the present invention. [Figure 6] FIG. 11 illustrates an example of vehicle type information according to the embodiment of the present invention. [Figure 7] FIG. 11 illustrates an example of transportation constraint information according to the embodiment of the present invention. [Figure 8] FIG. 11 illustrates an example of unit price information according to the embodiment of the present invention. [Figure 9] FIG. 11 illustrates an example of initial inventory information according to the embodiment of the present invention. [Figure 10] FIG. 11 illustrates an example of upper limit stock-out rate information according to the embodiment of the present invention. [Figure 11] FIG. 11 illustrates an example of demand forecast error information according to the embodiment of the present invention. [Figure 12] FIG. 11 illustrates an example of upper limit information of the number of days for advanced transportation according to the embodiment of the present invention. [Figure 13] FIG. 11 illustrates an example of transportation volume upper limit information according to the embodiment of the present invention. [Figure 14] FIG. 11 illustrates an example of transportation volume information according to the embodiment of the present invention. [Figure 15] FIG. 11 illustrates an example of transportation number information according to the embodiment of the present invention. [Figure 16] FIG. 11 illustrates an example of incoming / outgoing inventory information according to the embodiment of the present invention. [Figure 17] FIG. 11 illustrates an example of cost information according to the embodiment of the present invention. [Figure 18] FIG. 11 illustrates an example of stock-out rate information according to the embodiment of the present invention. [Figure 19] 1 is a flowchart illustrating an example of an inventory planning process performed in the inventory planning system according to the embodiment of the present invention. [Figure 20] 1 is a graph illustrating an example of the variance of the forecast error and the number of days until the required arrival date, illustrating an embodiment of the present invention. [Figure 21]10 is a flowchart illustrating an example of evaluation processing performed in the inventory planning system according to the embodiment of the present invention. [Figure 22] FIG. 2 is a diagram showing an example of an input / confirmation screen of the inventory planning system according to the embodiment of the present invention. [Diagram 23] FIG. 13 is a diagram illustrating an example of a confirmation screen for a planning result of the inventory planning system according to the embodiment of the present invention. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0012] Hereinafter, an embodiment of the present invention will be described with reference to the accompanying drawings.

[0013] FIG. 1 is a block diagram showing an example of the configuration of an inventory planning system according to an embodiment of the present invention.

[0014] The inventory planning system 1 according to the embodiment of the present invention is configured by a computer having a processor (CPU) 11, a communication interface 12, an input / output interface 13, and a memory .

[0015] The processor 11, communication interface (communication IF in the figure) 12, input / output interface (input / output IF in the figure) 13 and memory 14 are connected to each other (not shown) so as to be accessible via communication means such as a bus.

[0016] The processor 11 is a calculation device that executes programs stored in the memory 14. The processor 11 executes various programs to realize various functions of the inventory planning system 1. Note that some of the processing performed by the processor 11 by executing the programs may be executed by other calculation devices (for example, hardware FPGA or ASIC).

[0017] The memory 14 includes a ROM, which is a non-volatile storage element, and a RAM, which is a volatile storage device. The ROM stores unchanging programs (e.g., BIOS, UEFI), etc. The RAM is a high-speed, volatile storage device such as a DRAM (Dynamic Random Access Memory), and temporarily stores programs executed by the processor 11 and data used when executing the programs (e.g., data read from the storage device 2).

[0018] For example, the processor 11 executes a transportation volume upper limit determination program to function as a transportation volume upper limit determination unit f1. The transportation volume upper limit determination unit f1 determines the transportation volume upper limit on a daily basis based on various data including demand forecast information.

[0019] The processor 11 also executes an inventory planning program to function as an inventory planning unit f2. The inventory planning unit f2 creates an inventory plan based on various data including transportation volume upper limit information.

[0020] Moreover, the processor 11 executes a total cost evaluation program to function as a total cost evaluation unit f3. The total cost evaluation unit f3 evaluates the total cost of the inventory plan based on various data including the inventory plan information.

[0021] The processor 11 also executes a screen generation program to function as a screen generation unit f4. The screen generation unit f4 generates data to be displayed on the screen so that the user can visually recognize the transportation volume upper limit determined on a daily basis, the inventory plan, and the total cost and stockout rate.

[0022] The communication interface 12 is a network interface device that controls communications with other devices in accordance with a predetermined protocol.

[0023] The input / output interface 13 is connected to output devices such as a display device (not shown) and a printer (not shown), and input devices such as a keyboard (not shown), a mouse (not shown), and a touch panel (not shown), and is an interface that outputs the results of program execution in a format that can be viewed by the user and receives input from the user.

[0024] The programs executed by the processor 11 are provided to the server via removable media (CD-ROM, flash memory, etc.) or a network, and are stored in a non-volatile memory 14, which is a non-transient storage medium, or in an auxiliary storage device. For this reason, the inventory planning system 1 should preferably have an interface for reading data from the network or removable media.

[0025] The inventory planning system 1 is a computer system configured on a single physical computer, or on multiple logically or physically configured computers, and may also operate on a virtual computer constructed on multiple physical computer resources.

[0026] The inventory planning system 1 is connected to a storage device 2. The storage device 2 has a large-capacity non-volatile storage device such as a magnetic storage device (HDD) or a flash memory (SSD), and stores data used by the processor 11 when executing a program.

[0027] For example, the storage device 2 stores data used for calculation processing by the inventory planning system 1, such as product information i1, base information i2, demand forecast information by day, product, and route i3, route information i4, vehicle type information i5, transportation constraint information by day, route, and vehicle type i6, unit price information by product and base i7, initial inventory information by product and base i8, stock-out rate upper limit information by product i9, demand forecast error information i10, and advanced transportation days upper limit information by product and route i11. Note that product information i1 to advanced transportation days upper limit information i11 are preset information.

[0028] The storage device 2 also stores transportation volume upper limit information o1 by day, product and route, and inventory planning information o2, which are output by the inventory planning system 1 as a result of calculation processing.

[0029] The inventory plan information o2 includes transportation volume information o21 by day, product, and route, transportation volume information o22 by day, vehicle type, and route, incoming / outgoing inventory volume information o23 by day, product, and base, cost information o24, and stockout rate information o25. Details of these pieces of information will be described later. The storage device 2 may also store a program executed by the processor 11.

[0030] In the configuration shown in FIG. 1, the storage device 2 is provided separately from the inventory planning system 1. However, an auxiliary storage device, which is a non-volatile storage device for storing data, may be provided within the inventory planning system 1.

[0031] The inventory planning system 1 may be connected to other systems (for example, a customer POS system 3, a production planning system 4, a warehousing management system 5, and a transportation management system 6) via a communication interface 12.

[0032] The customer POS system is a system for managing the sale of goods at retail stores, and is also used by retail stores to order goods. The production planning system 4 is a system for planning the production of goods at each base such as a factory. The shipping management system 5 is a system for managing the shipping of goods at each base such as a factory or warehouse. The transportation management system 6 is a system for transport companies to manage the operation of transportation means.

[0033] For example, the inventory planning system 1 collects product demand forecast information and order information sent from the customer POS system 3, generates the required arrival date and predicted required quantity for each product, determines the upper limit of transportation volume on a daily basis, and creates and outputs an inventory plan with the lowest cost.

[0034] Based on the output inventory plan, the production planning system 4 can formulate a production plan, the shipping management system 5 can generate shipping instructions, and the transportation management system 6 can generate vehicle dispatch instructions.

[0035] 2 is an example of product information i1. Product information i1 has at least a data item that defines a "product name" (i101). It may also have data items of index values ​​that indicate the load on the storage capacity of the warehouse, such as a "unit weight" (i102) that is the weight per unit quantity of the product, and a "unit volume" (i103) that is the volume per unit quantity of the product.

[0036] In this embodiment, the unit quantity is hereinafter set to pieces, but other units such as cases or pallets may also be used. Also, in this embodiment, the unit of volume is set to cubic meters, but other units such as liters may also be used. Also, a data item of "upper limit of storage days" (i104) may be included. Products for which upper limit of storage days i104 is set must be discarded if the number of days of storage after entering the warehouse exceeds upper limit of storage days i104.

[0037] 3 is an example of base information i2. Base information i2 has at least a data item that defines "base name" (i201). It may also have data items of index values ​​that indicate the upper limit of the storage capacity of the warehouse, such as "inventory storage volume limit" (i203), "inventory storage quantity limit" (not shown), and "inventory storage weight limit" (not shown).

[0038] In this embodiment, the unit of inventory storage volume upper limit i203 is cubic meters, but other units such as liters may be used. Also, data items of index values ​​indicating the upper limit of the warehouse's work capacity, such as "upper limit of incoming volume (i204)" and "upper limit of outgoing volume" (i205), may be included. In addition, data items of information used to determine whether each product can be stored, such as "presence of refrigeration function" (not shown) and "presence of crane" (not shown), may be included.

[0039] It may have a data item of "base operating days" (not shown) that defines the days when goods can be received and shipped from the base (not shown). It may have data items of "address" (i202) and "latitude and longitude" (not shown) that indicate the geographical location of the base.

[0040] 4 is an example of demand forecast information i3 by arrival date, product, and route. The demand forecast information i3 by date, product, and route has at least the following data items: "forecast date" (i302), "requested arrival date" (i303), "product name" (i304), "originating point name" (i305), "destination point name" (i306), and "forecasted demand amount" (i307).

[0041] The forecast date i302 is the date on which the demand forecast data was generated. The demand forecast information i3 indicates that a forecasted requested quantity i307 of a specified product must be delivered to the destination location i306 by the arrival request date i303. The demand forecast information i3 may also have a data item of an order ID i301 that is set for each order. The forecasted requested quantity i307 corresponds to the demand forecast quantity.

[0042] FIG. 5 is an example of route information i4. The route information i4 has data items that define at least the "origin base name" (i401) and the "destination base name" (i402). The origin base name i401 is the name of the base that is the departure point. The destination base name i402 is the name of the base that is the arrival point. In addition, information on "transportation time required" (i403) that defines the time required for transportation from departure from the origin base to arrival at the destination base may be included. When costs proportional to the transportation volume are continuously added as transportation costs, a "transportation unit price" (not shown, units are $ / m3, $ / kg, $ / CS (number of cases), etc.) that is the transportation unit price per unit volume may be defined.

[0043] 6 is an example of vehicle type information i5, which includes data items of "vehicle type name" (i501) and "loading capacity limit" (i502, i503). The loading capacity limits i502 and i503 are the upper limit of the loading capacity per vehicle, and in addition to the weight limit and volume limit shown in the figure, data items of quantity limit (number of pallets, etc.) may be added or replaced with these.

[0044] Fig. 7 is an example of the transport constraint information i6 by date, route and vehicle type. The transport constraint information i6 by date, route and vehicle type has at least the data items of "departure date" (i601), "start point name" (i602) and "destination point name" (i603). A data item of "vehicle type name" (i604) may be prepared so that data can be defined by date, route and vehicle type.

[0045] A data column for "Upper limit of number of vehicles transported" (i605) may be defined to set the maximum number of vehicles per departure date as shown in Figure 7. If a transportation cost proportional to the number of vehicles transported is added per vehicle, a data column for "Unit transportation cost" (i606) may be defined to set the unit cost per vehicle as shown in Figure 7. Note that the upper limit of number of vehicles transported i605 can be treated as an upper limit of transportation capacity.

[0046] 8 is an example of the unit price information i7 by product and location. The unit price information i7 by product and location has at least a data item of "location name" (i702). It may also have a data item of "product name" (i702) and be set for each combination of location and product.

[0047] The "storage cost" (i703) is the cost incurred when storing the product at the base. The "storage work cost" (i704) is the cost incurred when storing or retrieving the product at the base. The storage work cost and the retrieval work cost may be defined separately.

[0048] The "unit cost of disposal" (i705) is the unit cost to be charged when the number of days of storage at the site of the product exceeds the upper limit of storage days i104 and the product is disposed of. The unit of currency may be dollars or yen, etc. The unit of quantity may be CS or pieces, lots, pallets, m3, kg, etc.

[0049] In addition, the system has data items for "equipment name" (not shown) and "workload per CS" (not shown) to define the workload per CS when working using that equipment, and can also separately define a daily workload upper limit for each piece of equipment.

[0050] 9 is an example of initial inventory information i8 by product and location. The initial inventory information i8 has at least the following data items: "product name" (i801), "location name" (i802), "storage start date" (i803), and "initial inventory amount" (i804).

[0051] Initial inventory information i8 allows the user to set the initial inventory amount for each combination of product and location.

[0052] 10 is an example of upper limit information i9 of stockout rate by product. The upper limit information i9 of stockout rate has at least the data items of "product name" (i901) and "upper limit information of stockout rate" (i902).

[0053] The stockout rate upper limit information i9 can set the stockout rate upper limit for each product. The stockout rate upper limit information i9 may be set for each combination of product and destination location by adding a data item of "destination location name" (not shown).

[0054] 11 is an example of the demand forecast error information i10. The demand forecast error information i10 can set statistical values ​​of forecast errors such as "variance of forecast errors" (i1004) for each combination of "product name" (i1001), "destination base name" (i1002), and "number of days until requested arrival date" (i1003).

[0055] In a well-known or publicly known example, the shorter the number of days until the required arrival date, the more likely it is that the order will be confirmed. Therefore, for example, the shorter the number of days until the required arrival date i1003, the smaller the variance of the forecast error may be set.

[0056] Furthermore, compared to standard products for which a constant demand is expected, the variance i1004 of the forecast error can be set to be larger for seasonal products and products whose demand fluctuates suddenly. Furthermore, the variance i1004 of the forecast error can be set for each destination base name i1002 according to the characteristics of orders from that destination base. The variance i1004 of the forecast error can be treated as statistical data of the demand forecast error.

[0057] Instead of "product name" (i1001) and "destination location name" (i1002), a data item "order ID" (not shown) may be added, and the variance of the prediction error may be set for each combination of the number of days until the requested arrival date i1003 for each individual order ID. Also, if the prediction error does not follow a normal distribution, the variance when the prediction is below average and the variance when the prediction is above average may be set (not shown).

[0058] 12 is an example of the information i11 of upper limit of number of days for advanced transportation by product and route. The information i11 of upper limit of number of days for advanced transportation has the data items of "product name" (i1101), "name of departure point" (i1102), "name of arrival point" (i1103), and "upper limit of number of days for advanced transportation" (i1104).

[0059] The information i11 on the upper limit of days for advanced transportation can set an upper limit of days for advanced transportation i1104, which is the upper limit of the number of days between the requested arrival date and the arrival date due to advanced transportation when transportation is carried out earlier than the requested arrival date, for a combination of a product name and a route consisting of a combination of a departure point name and a destination point name.

[0060] 13 is an example of transportation volume upper limit information o1 by day, product, and route output by the inventory planning system 1. The transportation volume upper limit information o1 has data items of "departure date" (o101), "product name" (o102), "origin base name" (o103), "destination base name" (o104), and "transport volume upper limit" (o105).

[0061] The transportation volume upper limit information o1 stores the transportation volume upper limit determined by the inventory planning system 1 for a combination of a departure date, a product name, and a route consisting of a combination of a departure base name and a destination base name.

[0062] Figures 14 to 18 respectively show examples of transportation volume information o21 by day, product, and route, transportation number information o22 by day and route, incoming / outgoing inventory amount information o23 by day, product, and location, cost information o24, and stock-out rate information o25, which make up the inventory planning information o2 output by the inventory planning system 1.

[0063] 14 is an example of transportation volume information o21 by day, product, and route. The transportation volume information o21 has the following data items: "Departure date" (o2101), "Product name" (o2102), "Departure point name" (o2103), "Destination point name" (o2104), "Vehicle model name" (o2105), and "Transport volume" (o2106).

[0064] The transportation volume information o21 stores the transportation volume o2106 planned as an inventory plan by the inventory planning system 1 for a route combination consisting of a combination of a departure date o2101, a product name o2102, a vehicle model name o2105, a departure base name o2103, and a destination base name o2104.

[0065] 15 is an example of the information o22 on the number of vehicles transported by date, vehicle type, and route. The information o22 on the number of vehicles transported has the following data items: "Departure date" (o2201), "Vehicle type name" (o2202), "Departure base name" (o2203), "Destination base name" (o2204), and "Number of vehicles transported" (o2205).

[0066] The transportation quantity information o22 stores the transportation quantity o2205 planned as an inventory plan by the inventory planning system 1 for a route combination consisting of a departure date o2201, a vehicle model name o2202, a departure base name o2203, and a destination base name o2204.

[0067] 16 is an example of the incoming / outgoing inventory information o23 by day, product, and location. The incoming / outgoing inventory information o23 has the following data items: "date" (o2301), "product name" (o2302), "location name" (o2303), "incoming inventory amount" (o2304), "outgoing inventory amount" (o2305), "waste amount" (o2306), "requested inventory amount" (o2307), "out-of-stock amount" (o2308), and "inventory amount" (o2309).

[0068] The incoming / outgoing inventory information o23 stores, for a combination of date o2301, product name o2302, and base name o2303, the incoming amount o2304, the outgoing amount o2305, the waste amount o2306, the outgoing request amount o2307, the stockout amount o2308, and the inventory amount o2309 that are planned as an inventory plan by the inventory planning system 1. The combination of the incoming amount o2304 and the outgoing amount o2305 can be treated as an incoming / outgoing amount.

[0069] 17 is an example of the cost information o24. The cost information o24 has the following data items: "date" (o2401), "transportation cost" (o2402), "storage cost" (o2403), "disposal cost" (o2404), "warehousing operation cost" (o2405), "shipping operation cost" (o2406), and "total cost" (o2407).

[0070] The cost information o24 stores the costs of transportation, storage, disposal, warehousing, and shipping for each date o2401, calculated for the inventory plan drawn up by the inventory planning system 1, and the total cost o2407, which is the sum of these costs. Other data items such as fixed costs of bases and facilities, production costs, and procurement costs may also be defined (none of which are shown in the figure).

[0071] 18 is an example of the stockout rate information o25. The stockout rate information o25 has the data items of "product name" (o2501), "total requested amount" (o2502), "total stockout amount" (o2503), and "stockout rate" (o2504).

[0072] The stockout rate information o25 stores the total requested quantity o2502, the total stockout amount o2503, and the stockout rate o2504 for each product calculated for the inventory plan drawn up by the inventory planning system 1. By adding data items such as "origin base name" (not shown) and "destination base name" (not shown), information such as the stockout rate for each combination may be stored.

[0073] 19 is a flowchart S1 of inventory planning processing by the inventory planning system 1. This processing is started when a command is received from a user (or administrator) of the inventory planning system 1, or when a calculation start condition such as a weekly calculation date and time is satisfied. In the following explanation, each functional unit is described as the subject of processing, but the processor 11 or the inventory planning system 1 can be interpreted as the subject of processing.

[0074] First, the inventory planning system 1 takes in the product information i1 through the advanced transportation days upper limit information i11 as input data from the storage device 2 (S10).

[0075] Next, the transportation volume upper limit determination unit f1 determines a transportation volume upper limit o105 by day, product and route using data on the forecast demand volume i307 in the demand forecast information i3 by day, product and route and the variance i1004 of the forecast error by number of days i1003 until the requested arrival date in the demand forecast error information i10, and stores it in the transportation volume upper limit information o1 by day, product and route (S11).

[0076] Next, the inventory planning unit f2 creates an inventory plan consisting of transportation volume information o21 by day, product, and route, transportation volume information o22 by day, vehicle type, and route, and incoming / outgoing inventory and inventory volume information o23 by day, product, and base, so as to satisfy the transportation volume upper limit o105 determined in step S11 and the day-by-route-by-vehicle-type-by-vehicle-number upper limit i605 in the day-by-route-by-vehicle-type transportation constraint information i6 (S12).

[0077] Next, the total cost evaluation unit f3 evaluates the total cost o2407, including the costs of transportation, storage, disposal, warehousing, and shipping, and the stock-out rate o2504, when the inventory plan drawn up in step S12 is executed, taking into account the demand forecast error, and stores the results in the cost information o24 and the stock-out rate information o25 (S13).

[0078] Next, the total cost evaluation unit f3 determines whether the stock-out rate o2504 in step S13 satisfies the stock-out rate upper limit i902 set in the product-specific stock-out rate upper limit information i9, and, if there is a tentative solution saved up to that point, whether the total cost o2407 evaluated in step S13 is cheaper than the total cost of the inventory plan of that tentative solution (S14).

[0079] If the total cost in step S13 is lower, the total cost evaluation unit f3 saves the inventory plan drawn up in step S12 and the total cost o2407 and stockout rate o2504 evaluated in step S13 as a provisional solution (S15).

[0080] Next, the total cost evaluation unit f3 determines whether a predetermined termination condition (described later) is satisfied (S16). If the predetermined termination condition is satisfied, the total cost evaluation unit f3 stores the provisional solution as a minimum-cost inventory plan and outputs it (S17).

[0081] If the predetermined end condition is not satisfied, the total cost evaluation unit f3 repeats the processes from step S12 to step S16 until the end condition is satisfied.

[0082] Step S10 will now be described in detail. From the captured input data, the screen generation unit f4 may generate display data, which may then be output from the input / output interface 13 and displayed on a display device or the like.

[0083] For example, d1 shown in Fig. 22 is an example of an input / confirmation screen for inventory planning data. The input / confirmation screen d1 for inventory planning data can display each input data such as transportation constraint information (d11) by date, route, and vehicle type, and demand forecast error information (d12).

[0084] In addition, on the input / confirmation screen d1 for stock planning data, the input data may be directly edited / updated by the user when an edit input data button (d13) is pressed. In addition, the process from step S11 onward shown in FIG. 19 may be started when an execute planning button (d14) is pressed.

[0085] Step S11 will now be described in detail. In step S11, the transportation volume upper limit determination unit f1 determines the transportation volume upper limit o105 by day, product, and route using the forecast demand volume i307 in the demand forecast information i3 by day, product, and route, and the data of the variance i1004 of the forecast error by the number of days i1003 until the arrival request date in the demand forecast error information i10.

[0086] In addition, the data of the upper limit of the number of days of advanced transportation in the information i11 of the upper limit of the number of days of advanced transportation by product and route may be used to determine the upper limit of the transportation volume o105. For example, for a product i ordered from a base w to a base f, the departure date t of the route (f, w) with the starting base f and the destination base w, and the upper limit of the transportation volume trans ub (t, i, f, w) can be determined, for example, as follows:

[0087] ·set: Planning date: 0, 1, …, T · Product collection: I A set of orders for product i, destination location w, and required date τ: O(i, w, τ)

[0088] ·Constant: Below, o∈O, t∈T Procurement LT (Lead Time): ProcLT Upper limit of number of days for advanced transportation of product i and route (f, w): MoveUpDayCntUB Variance of demand forecast error for product i, arrival point w, and number of days until arrival request date ρ: σ(i, w, ρ) Forecasted demand quantity for order o: OrderQty(o) · Request date of order o: ArrivalDay(o) The forecasted demand quantity of order o that can be departed on departure date t: OrderQty(o,t) can be expressed as follows:

[0089]

number

[0090] Here, the weighting coefficient of the variance in determining the upper limit of the transportation volume is k Then, · Formula for determining upper limit of transportation volume for product i, departure date t, and route (f, w): trans ub (t, i, f, w) can be expressed as follows:

[0091]

number

[0092] The above formula (2) calculates the upper transportation volume limit for each departure date as the sum of the values ​​obtained by subtracting from the forecast request volume i307 of the orders, weighted by a coefficient, the variance of the demand forecast according to the number of days from the departure date to the requested arrival date of the order, for all orders of the target product and route that can be transported on that departure date.

[0093] Here, the variance σ(i, w, ρ) of the demand forecast may be set for each product name, arrival point, and number of days until the required arrival date i1003 as in the example of Figure 11 described above, or a function may be used in which the variance is large when the number of days until the required arrival date is long and the variance decreases as the number of days until the required arrival date becomes shorter, as in the graph of Figure 20. Depending on the slope at which the variance decreases as the number of days until the required arrival date becomes shorter, functions such as (a), (b), and (c) in the figure may be used.

[0094] Next, the details of step S12 will be described. In step S12, an inventory plan is created that includes transportation volume information o21 by day, product, and route, transportation volume information o22 by day, vehicle type, and route, and incoming / outgoing inventory information o23 by day, product, and base, so as to satisfy the transportation volume upper limit o105 determined in step S11 and the transportation volume upper limit i105 by day, route, and vehicle type in the transportation constraint information i6 by day, route, and vehicle type.

[0095] As a method of creating an inventory plan, for example, all possible combinations of transportation volume, number of transported vehicles, incoming / outgoing volume, inventory volume, waste volume, and stockout volume may be automatically generated to generate all possible inventory plans. Then, from all the generated inventory plans, the process from step S12 to step S16 may be repeated for each inventory plan to search for all possible combinations, and an inventory plan that satisfies the upper limit of stockout rate i902 and minimizes the total cost o2407 may be determined.

[0096] Another method of creating an inventory plan is to allocate transportation to capacity slots with leeway up to the upper transport volume limit o105 and the upper transport number limit i605 so as to fulfill the required quantity of that order, starting with the order with the latest requested arrival date out of all orders, and then to determine the transportation volume o2106 by day, product, and route by allocating the amount exceeding the capacity slots ahead of schedule.

[0097] For departure date t, route p, vehicle type v, and product i, the number of vehicles transported vcnt(t, p, v) can be calculated based on the transportation volume trans(t, p, v, i) using the following formula.

[0098] The constants are Unit volume of item i: ItemUnitVol(i) · Upper limit of vehicle volume for vehicle type v: VehicleVolUB(i) The calculation formula for the number of transported vehicles vcnt(t, p, v) can be expressed as follows:

[0099]

number

[0100] In the above formula (3), only the volume is considered as the upper load capacity limit i503. However, if weight is also considered, for example, the larger of the number of transported vehicles calculated for the upper load capacity limit and the number of transported vehicles calculated for the upper load weight limit may be used.

[0101] Based on the above transportation volume, the warehousing volume by day, by location, and by product o2304 is calculated as the total value of the transportation volumes of all routes from the upstream for the same arrival date and the same product.

[0102] The inventory volume by day, location, and product o2304 is calculated as the total value of the transportation volume of all routes from the upstream for the same arrival date and the same product.

[0103] The amount of waste by day, location, and product is calculated as the total value of the inventory amount by location and product for which the number of days stored from the storage start date exceeds the upper limit on that day.

[0104] For date t, location w, and product i, the inventory amount stock(t, w, i) by day, location, and product is calculated using the incoming amount in(t, w, i), the outgoing amount out(t, w, i), and the discarded amount dispose(t, w, i) calculated using the above method, using the following formula.

[0105] The constants are Initial stock amount: InitStock(w, i) Then, the inventory quantity stock(t, w, i) can be expressed by the following equation.

[0106]

number

[0107] When defining the inventory storage volume upper limit i203, the incoming amount upper limit i204, and the outgoing amount upper limit i205 in the base information i2, the incoming amount or outgoing amount exceeding the upper limit can be corrected to be equal to or less than the upper limit, and the amount can be regarded as being out of stock.

[0108] The stockout quantity shortage(t,w,i) by day, location, and product is calculated as follows for a set P of routes downstream of location w, using the request quantity requestQty(t,p,i) (p∈P) from downstream.

[0109] The formula for calculating the outgoing request quantity requestQty(t, w, i) from downstream to base w is expressed as follows.

[0110]

number

[0111] The formula for calculating the shortage amount shortage(t, w, i) is expressed as follows.

[0112]

number

[0113] Next, step S13 will be described in detail. In step S13, the total cost o2407, including the costs of transportation, storage, disposal, warehousing, and shipping, and the stockout rate o2504, when the inventory plan drawn up in step S12 is executed, are evaluated taking into account the demand forecast error. A flowchart S2 of an example of the evaluation process performed in step S13 is shown in FIG. 21.

[0114] First, in step S21, the total cost evaluation unit f3 generates an expected demand amount by day, product, and route that is expected as actual demand, based on the forecast demand amount i307 in the demand forecast information i3 by day, product, and route, and the variance i1004 of the forecast error in the demand forecast error information i10. The expected demand amount can be generated by adding random noise, etc., generated based on the variance i1004 of the forecast error to the forecast demand amount i307.

[0115] Next, in step S22, the total cost evaluation unit f3 simulates the transportation volume, the number of vehicles transported, the incoming / outgoing volume, the inventory volume, the waste volume, the stockout volume, and the outgoing request volume when the actual demand is the estimated request volume generated in step S21 and a difference between the forecast and actual demand occurs when the inventory plan drawn up based on the demand forecast in step S12 is executed, for each day from the first day of the planning period until the final day is reached.

[0116] For example, if demand falls short on a certain day, some of the inventory prepared for that demand will become surplus and will be rolled over to the next day. If demand rises on a certain day and exceeds the inventory, a shortage will occur, the inventory will reach zero, and it will be rolled over to the next day. By repeating this process until the final day, it is possible to simulate the trends in each quantity, taking into account errors in the demand forecast.

[0117] Finally, in step S23, the total cost evaluation unit f3 evaluates the total cost and the stockout rate based on the transportation volume, the number of transported vehicles, the incoming / outgoing volume, the inventory volume, the waste volume, the stockout volume, and the outgoing request volume obtained as a result of the simulation, using the following equations.

[0118] The constants are the transportation cost TransUnitCost(t, p, v), the storage cost StockUnitCost(w, i), the disposal cost DisposalUnitCost(w, i), the entry cost InputUnitCost(w, i), and the shipping cost OutputUnitCost(w, i).

[0119] The variables are total cost (totCost), transportation cost (transCost), storage cost (stockCost), disposal cost (disposalCost), inputCost, shipping cost (outputCost), and stockout rate (shortageRate).

[0120] The cost calculation formula can be expressed as follows:

[0121]

number

[0122] The formula for calculating the stockout rate can be expressed as follows:

[0123]

number

[0124] In the above example, the transportation cost transCost (o2402) is calculated per vehicle, but a variable cost term that is continuously calculated in proportion to the transportation volume may be added.

[0125] Next, steps S14 and S15 will be described in detail. In the example of Fig. 19, only when the upper limit i902 of the stockout rate is satisfied and the total cost o2407 is lower than the tentative solution, the provisional solution is stored, but even when the upper limit i902 of the stockout rate is not satisfied, the provisional solution may be stored as a plan that relaxes the condition of the upper limit i902 of the stockout rate, and even when the total cost o2407 is higher, all plans may be stored as the next best plan, etc.

[0126] Step S16 will now be described in detail. As termination conditions for the process in Fig. 19, an upper limit for the number of repetitions of the process from step S12 to step S16, a lower limit for the total cost o2407, a lower limit for the improvement rate of the total cost o2407, and the like are set, and when the upper or lower limit is reached, it is determined that the termination conditions are met and the process proceeds to step S17.

[0127] If the termination condition is not satisfied, the processes from step S12 to step S16 are repeated. In this case, in step S12, for example, in the case of exhaustive search, an inventory plan may be generated for combinations of unsearched transport volume, number of transported vehicles, incoming / outgoing volume, inventory volume, waste volume, and stockout volume. Alternatively, a new inventory plan may be generated by increasing or decreasing some of the quantities in the inventory plan of the provisional solution.

[0128] The details of step S17 will be described. The total cost evaluation unit f3 stores the provisional solution as a cost-minimizing inventory plan, and the screen generation unit f4 generates display data. The generated data is output from the input / output interface 13 and displayed on a display device or the like.

[0129] 23 is a display example of a confirmation screen d2 for the planning results. The confirmation screen d2 may display the planning results (d21) of the transportation volume upper limit by day, product, and route, and the planning results (d22) of the inventory plan.

[0130] Also, as described above, if plans other than the minimum-cost plan have been saved, pressing the display other plan button (d23) at the bottom of the figure may display plans other than the minimum-cost plan, allowing the user to compare the minimum-cost inventory plan with the other plans and select the most preferable plan. Pressing the adopt button (d24) may adopt the displayed inventory plan and use it in actual operations.

[0131] As a display of the inventory planning results d22, a time series graph showing the number of transported vehicles, the required amount, and the stock amount for each date may be displayed (d221). The graph of the number of transported vehicles may display the upper limit and the planned value of the number of transported vehicles by route and vehicle type. The graph of the required amount may display the forecasted required amount i307 by forecast date set in the demand forecast information i3 by day, product, and route, and the estimated required amount by day, product, and route generated in step S21 of FIG. 21 and used in the simulation taking into account the demand forecast error. The graph of the inventory amount may display the inventory amount by product.

[0132] In addition, the time series graph d221 may display a comparison between an inventory plan (d2211) drawn up without a transportation volume upper limit and an inventory plan (d2212) with the minimum cost calculated with a transportation volume upper limit. In the example of Fig. 23, the predicted demand volume as of May and June is 30 units for each of products A to C, whereas the expected demand volume assumed as the actual demand volume is 22 units for each product.

[0133] In contrast, in the plan with no upper limit on transportation volume (d2211), in order to meet the upper limit on the number of units to be transported, 30 units of A and B were transported ahead of schedule during May and June, which caused demand to fall to 22 units each in July, resulting in surplus inventory of 8 units each of A and B.

[0134] On the other hand, in the minimum cost inventory plan with transportation volume upper limit (d2212) using the transportation volume upper limit determined in step S11, 10 units of each of products A to C are transported ahead of schedule in each of May and June, and after the required quantity of each product is confirmed as 22 units in July, 2 units of each of products A to C are transported, reducing the surplus inventory of A to C to zero. Also, the number of vehicles in July was reduced in line with the downward swing in demand.

[0135] As a display of the inventory plan creation result d22, the total cost of the creation result may be displayed in a stacked graph for each cost item (d222). Also, the stockout rate of the creation result may be displayed in a graph together with the stockout rate upper limit (d223). As in the example of Figure 23, both the cost d222 and the stockout rate d223 may be displayed to compare the result of creation without a transportation volume upper limit and the minimum cost inventory plan created with a transportation volume upper limit determined.

[0136] In the above example, a method for searching for a plan with the minimum total cost o2407 was shown by generating all combinations or increasing or decreasing a part of the quantity of a provisional solution to generate a new inventory plan, but the present invention is not limited to such a method. For example, an inventory plan may be created under the above-mentioned input conditions so as to minimize the total cost by a mathematical optimization method such as mixed integer programming.

[0137] In the above, a method for formulating an inventory plan with the minimum total cost o2407 has been described. However, for example, based on the demand forecast information i3 by day, product, and route, an inventory plan may be generated in which products are shipped and transported in the order of earliest requested dates so that the requested quantity can be delivered by the input arrival requested date i303.

[0138] <Conclusion> As described above, the inventory planning system 1 of this embodiment can plan a transportation volume that reduces storage costs and disposal costs due to surplus inventory that occurs when demand drops, by setting the transportation volume upper limit o105 based on the demand forecast volume (forecasted required volume i307) and statistical data of the demand forecast error that changes according to the number of days until the arrival request date i1003 (variance of the forecast error i1004). Also, by planning an inventory plan that satisfies the above-mentioned transportation volume upper limit and transportation number upper limit and minimizes the total cost including the transportation cost, storage cost, and disposal cost added per vehicle, it is possible to determine the transportation volume that minimizes the cost of the entire supply chain.

[0139] The inventory planning system 1 of this embodiment has been developed in consideration of the above problems, and plans divided transportation ahead of the busy season, taking into account the upper limit of the number of vehicles to be transported. In this case, in order to reduce excess inventory when actual demand falls short of the forecast, during periods when the number of days until the requested arrival date is long and the accuracy of the demand forecast is low, the transportation volume is determined to minimize the amount of transportation ahead of the peak season.

[0140] The above is achieved by the following steps. First, a daily and product-specific transportation volume upper limit is set based on the predicted demand volume by day and product, and the accuracy of the demand forecast, which changes depending on the number of days until the required arrival date. Next, taking into account the determined daily and product-specific transportation volume upper limit and the daily transportation number upper limit, an inventory plan is created consisting of transportation volumes, incoming and outgoing volumes, and inventory volumes by day and product. The total cost, which is the sum of the costs of transportation, storage, disposal, work, etc. required to execute the plan, is calculated, and an inventory plan that minimizes the total cost is created.

[0141] A representative example of the invention disclosed in this embodiment is as follows: That is, an inventory planning system has a calculation device that executes a predetermined process and a memory accessible by the calculation device, and the calculation device determines an upper limit of a transportation volume based on a demand forecast volume and statistical data of a forecast error such as a variance of a demand forecast error that changes according to the number of days until a required arrival date, determines a transportation volume and a number of transported vehicles so as to satisfy the upper limit of the transportation volume and the upper limit of the number of transported vehicles, calculates an inbound / outbound volume and an inventory volume from the transportation volume, calculates costs of transportation, storage, disposal, work, etc. from the transportation volume, the number of transported vehicles, the inbound / outbound volume, and the inventory volume, and outputs an inventory plan consisting of the transportation volume, the number of transported vehicles, the inbound / outbound volume, and the inventory volume when a total cost, which is the sum of the costs, is minimized.

[0142] The inventory planning system of the above embodiment can be configured as follows.

[0143] (1) An inventory planning system (1) having a calculation device (processor 11) that executes a predetermined process and a memory (14) accessible to the calculation device (11), wherein the calculation device (11) receives as input a previously set demand forecast amount of an item (forecasted demand amount i307) and statistical data of a demand forecast error (forecast error variance i1004) that changes depending on the number of days until the required arrival date of the item (i1003), performs a predetermined process on the demand forecast amount (i307) and the statistical data (i1004), and determines and outputs an upper transportation volume limit (o105) for the item on a daily basis.

[0144] With the above configuration, the inventory planning system 1 can plan transportation volumes that reduce storage costs and disposal costs due to surplus inventory that arise when demand declines, by setting an upper transportation volume limit on a daily basis based on the demand forecast volume and statistical data of demand forecast error that changes depending on the number of days until the required arrival date.

[0145] (2) The inventory planning system according to (1) above, wherein the calculation device (11) uses an upper limit of the number of days for advanced transportation (upper limit of days for advanced transportation i1104) in the case of transporting an article ahead of the required arrival date (i303) in determining the upper limit of the transportation volume (o105).

[0146] With the above configuration, the inventory planning system 1 plans divided transportation ahead of the busy season, taking into account the upper limit of the number of vehicles to be transported i605. At that time, it becomes possible to reduce excess inventory when actual demand falls short of the forecast. In addition, the inventory planning system 1 can also reduce the number of vehicles in line with the fall in demand.

[0147] (3) The inventory planning system according to (2) above, wherein the calculation device (11) determines a transportation amount (o2106) of the item so as to satisfy the determined upper transportation amount limit (o105) and a preset transportation capacity limit (upper number of transported vehicles limit i605 and vehicle model name i604), calculates incoming and outgoing volumes and inventory amounts from the transportation amount (o2106), and outputs an inventory plan (d2) consisting of the transportation amount (o2106), the incoming and outgoing volumes (incoming volume o2304 and outgoing volume o2305), and the inventory amount (o2306).

[0148] With the above configuration, the inventory planning system 1 can set the transportation volume upper limit o105 based on the demand forecast volume and statistical data of the demand forecast error (the variance of the forecast error i1004) that changes depending on the number of days until the requested arrival date i1003, thereby planning the transportation volume that reduces the storage costs and disposal costs due to surplus inventory that arise when demand falls.

[0149] (4) An inventory planning system as described in (3) above, characterized in that the calculation device (11) calculates and outputs at least one of the transportation cost (o2402), the storage cost (o2403), the disposal cost (o2404), and the incoming / outgoing work cost (o2405, o2406) based on the determined transportation volume (o2106), the incoming / outgoing volume (o2304, o2305), the inventory volume (o2306), and a preset transportation unit cost (i606), storage unit cost (i703), disposal unit cost (i705), and the incoming / outgoing work unit cost (i704).

[0150] With the above configuration, by creating an inventory plan that satisfies the upper transport volume limit and upper transport number limit and minimizes the total cost, including the transport cost, storage cost, and disposal cost added per vehicle, it is possible to determine the transport volume that minimizes the cost of the entire supply chain.

[0151] (5) An inventory planning system according to (4) above, wherein the calculation device (11) calculates a total cost (o2407) which is the sum of the calculated transportation cost (o2402), storage cost (o2403), disposal cost (o2404), and incoming / outgoing operation costs (o2405, o2406), and outputs an inventory plan (d2) consisting of the transportation volume (o2106), incoming / outgoing volume (o2304, o2305), and inventory volume (o2306) which minimizes the total cost (o2407).

[0152] With the above configuration, the inventory planning system 1 can determine the transportation volume that minimizes the cost of the entire supply chain by creating an inventory plan that satisfies the upper transport volume limit and the upper transport number limit and minimizes the total cost, including transportation costs, storage costs, and disposal costs added on a per-vehicle basis.

[0153] (6) An inventory planning system according to (5) above, characterized in that the calculation device (11) calculates and outputs a stock-out rate (o2504) based on the determined transportation volume (o2106), incoming and outgoing volumes (o2304, o2305), and inventory volume (o2306).

[0154] With the above configuration, the inventory planning system 1 is able to reduce the stock-out rate by creating an inventory plan that satisfies the upper limit of transportation volume and the upper limit of transportation number, and minimizes the total cost, including transportation costs, storage costs, and disposal costs, which are added per vehicle.

[0155] (7) The inventory planning system according to (6) above, wherein the calculation device (11) outputs the inventory plan (d2) in which the stock-out rate (o2504) satisfies a predetermined upper limit of the stock-out rate (i902) and the total cost (o2407) is minimized.

[0156] With the above configuration, the inventory planning system 1 is able to reduce the stock-out rate by creating an inventory plan that satisfies the upper limit of transportation volume and the upper limit of transportation number, and minimizes the total cost, including transportation costs, storage costs, and disposal costs, which are added per vehicle.

[0157] (8) The inventory planning system according to (7) above, wherein the calculation device (11) defines the transportation capacity upper limit (i605, i604) as an upper limit of the number of transported units (i605), determines a transportation volume (o2106) so as to satisfy the transportation volume upper limit (o105) and the upper limit of the number of transported units (i605), calculates the number of transported units required from the transportation volume (o2106), and calculates the transportation cost (o2402) based on the transportation volume (o2106), the number of transported units (o2205), and the transportation unit cost (i605).

[0158] With the above configuration, the inventory planning system 1 allocates transportation to capacity slots with leeway up to the upper limit of transportation volume o105 and the upper limit of transportation volume i605 so as to satisfy the requested volume of an order, starting from the order with the latest requested arrival date among all possible combinations of transportation volume, number of transported vehicles, incoming and outgoing volumes, inventory volume, waste volume, and stockout volume, and allocates the amount exceeding the capacity slots ahead of schedule, thereby planning transportation volumes that reduce storage costs and waste costs due to excess inventory that occurs when demand drops. Note that transportation volumes o2106 by day, product, and route may also be determined.

[0159] (9) The inventory planning system according to (2) above, wherein the calculation device (11) determines the transportation volume (o2106) so as to ship and transport products in the order of the earliest arrival required date (i303) so as to satisfy the transportation volume upper limit (o105) and the transportation capacity upper limits (i605, i604).

[0160] With the above configuration, the inventory planning system 1 generates an inventory plan for shipping and transporting products in the order of earliest requested dates, thereby making it possible to deliver the requested quantity by the inputted arrival requested date i303 based on the demand forecast information i3.

[0161] As described above, the present invention is not limited to the above-described embodiments, and includes various modified examples and equivalent configurations within the spirit of the appended claims. For example, the above-described embodiments have been described in detail to clearly explain the present invention, and the present invention is not necessarily limited to those having all of the configurations described. Furthermore, a part of the configuration of one embodiment may be replaced with the configuration of another embodiment. Furthermore, the configuration of another embodiment may be added to the configuration of one embodiment. Furthermore, a part of the configuration of each embodiment may be added, deleted, or replaced with another configuration.

[0162] In addition, each of the above-mentioned configurations, functions, processing units, processing means, etc. may be realized in hardware, for example by designing some or all of them as an integrated circuit, or may be realized in software by a processor interpreting and executing a program that realizes each function.

[0163] Information such as programs, tables, and files that realize each function can be stored in a storage device such as a memory, a hard disk, or an SSD (Solid State Drive), or in a recording medium such as an IC card, an SD card, or a DVD.

[0164] In addition, the control lines and information lines shown are those considered necessary for the explanation, and do not necessarily show all the control lines and information lines necessary for implementation. In reality, it can be considered that almost all components are connected to each other. [Explanation of symbols]

[0165] 1. Inventory planning system 2 Storage device 11 Processors 12 Communication Interface 13 Input / Output Interface 14. Memory f1 Transport time limit determination section f2 Inventory Planning Department f3 Total cost evaluation section f4 screen generator i1 Product Information i2 Location Information i3 Demand forecast information i4 Route Information i5 car model information i6 Transportation restriction information i7 unit price information i8 initial stock information i9 Stockout rate upper limit information i10 Demand forecast error information o1 Transport volume limit information o2 Inventory planning information o21 Transportation volume information o22 Transport volume information o23 Inventory and inventory information o24 Cost Information o25 Stockout Rate Information

Claims

1. A computing device for executing a predetermined process; and a memory accessible to the computing device, the computing device receives as input a preset demand forecast amount of the item and statistical data of a demand forecast error that changes depending on the number of days until the required arrival date of the item, performs a predetermined process on the demand forecast amount and the statistical data, and determines and outputs an upper limit of the transportation amount of the item on a daily basis; The inventory planning system according to claim 1, wherein the calculation device uses an upper limit of the number of days for which transportation can be brought forward when transporting an item ahead of the required arrival date in determining the upper limit of the transportation volume.

2. The inventory planning system of claim 1, The inventory planning system is characterized in that the calculation device determines a transportation volume of the item so as to satisfy the determined transportation volume upper limit and a predetermined transportation capacity upper limit, calculates incoming / outgoing volumes and inventory volumes from the transportation volume, and outputs an inventory plan consisting of the transportation volume, the incoming / outgoing volumes, and the inventory volume.

3. The inventory planning system of claim 2, The inventory planning system is characterized in that the calculation device calculates and outputs at least one of a transportation cost, a storage cost, a disposal cost, and a loading / unloading operation cost based on the determined transportation volume, loading / unloading volume, and inventory volume, and a preset transportation unit cost, storage unit cost, disposal unit cost, and loading / unloading operation unit cost.

4. The inventory planning system of claim 3, The inventory planning system is characterized in that the calculation device calculates a total cost which is the sum of the calculated transportation costs, storage costs, disposal costs, and incoming and outgoing work costs, and outputs an inventory plan consisting of transportation volumes, incoming and outgoing volumes, and inventory volumes which minimize the total cost.

5. The inventory planning system of claim 4, The inventory planning system is characterized in that the calculation device calculates and outputs a stockout rate based on the determined transportation volume, incoming / outgoing volume, and inventory volume.

6. The inventory planning system of claim 5, The inventory planning system is characterized in that the calculation device outputs the inventory plan in which the stock-out rate satisfies a predetermined stock-out rate upper limit and the total cost is minimized.

7. The inventory planning system of claim 6, The inventory planning system is characterized in that the calculation device defines the transportation capacity upper limit as an upper limit on the number of transported units, determines a transportation volume so as to satisfy the transportation volume upper limit and the transportation number upper limit, calculates the required number of transported units from the transportation volume, and calculates the transportation cost based on the transportation volume, the number of transported units, and the transportation unit price.

8. The inventory planning system of claim 1, The inventory planning system is characterized in that the calculation device determines a transportation volume so that products are shipped and transported in order of the earliest required arrival date so as to satisfy the transportation volume upper limit and a preset transportation capacity upper limit.

9. An inventory planning method for creating an inventory plan using a computer having an arithmetic unit that executes a predetermined process and a memory accessible by the arithmetic unit, comprising: an input step in which the computer inputs a preset demand forecast amount of an item and statistical data of a demand forecast error that changes depending on the number of days until the arrival date of the item; a transportation volume upper limit determination step in which the computer performs a predetermined process on the demand forecast volume and the statistical data to determine and output an upper limit on the transportation volume of the item on a daily basis; Including, In the transportation volume upper limit determination step, a maximum number of days for transportation of an item ahead of said required arrival date, when said upper limit of said transportation volume is determined; 10. The inventory planning method of claim 9, comprising: a transportation amount determination step in which the computer determines a transportation amount of the item so as to satisfy the determined transportation amount upper limit and a preset transportation capacity upper limit; an inventory plan output step in which the computer calculates an incoming / outgoing amount and an inventory amount from the transportation amount, and outputs an inventory plan including the transportation amount, the incoming / outgoing amount, and the inventory amount; The inventory planning method further comprising:

11. The inventory planning method of claim 10, comprising: An inventory planning method characterized by further comprising a cost output step in which the computer calculates and outputs at least one of a transportation cost, a storage cost, a disposal cost, and a loading / unloading operation cost based on the determined transportation volume, loading / unloading volume, and inventory volume, and a preset transportation unit cost, storage unit cost, disposal unit cost, and loading / unloading operation unit cost.

12. The inventory planning method of claim 11, comprising: The inventory planning method is characterized in that the inventory plan output step calculates a total cost which is the sum of the calculated transportation costs, storage costs, disposal costs, and incoming and outgoing work costs, and outputs an inventory plan consisting of transportation volumes, incoming and outgoing volumes, and inventory volumes which minimizes the total cost.

13. The inventory planning method of claim 12, comprising: The inventory planning method further comprises a stockout rate output step in which the computer calculates and outputs a stockout rate based on the determined transportation volume, incoming / outgoing volume, and inventory volume.

Citation Information

Patent Citations

  • Preparing method for transport plan and system therefor

    JP2000062916A

  • Demand forecast method, inventory plan decision method, demand forecast system and inventory plan decision system

    JP2009230555A

  • Schedule determination method, schedule determination program and schedule determination system

    JP2016181039A

  • Arrangement manner selection system, arrangement manner selection method and program

    JP2017199282A

  • Inventory management apparatus, inventory management method, and program

    JP2019192002A