Demand prediction device and demand prediction method

The demand forecasting device corrects sales quantities during emergencies to improve forecasting accuracy, addressing underestimation issues and ensuring sufficient supply preparation.

JP2024168026APending Publication Date: 2024-12-05HITACHI LTD
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
JP2023084409
Authority / Receiving Office
JP · JP
Patent Type
Applications
Current Assignee / Owner
Filing Date
2023-05-23
Publication Date
2024-12-05

AI Technical Summary

Technical Problem

Existing demand forecasting methods fail to accurately predict future demand during emergencies such as pandemics or natural disasters, leading to underestimation and potential loss of sales opportunities due to supply shortages and inventory issues.

Method used

A demand forecasting device that corrects actual sales quantities during supply shortages and stockouts by increasing them based on predetermined supply quantities and sales plan quantities, using a correction unit to enhance accuracy.

Benefits of technology

Enhances demand forecasting accuracy by correcting sales quantities during emergencies, ensuring adequate supply preparation and minimizing sales losses.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 2024168026000001_ABST
    Figure 2024168026000001_ABST
Patent Text Reader

Abstract

To provide a demand prediction device and a demand prediction method that predict demand with higher accuracy.SOLUTION: A demand prediction device includes: an acquisition unit that acquires an actual supply result quantity of a product in a past predetermined period and an actual sales result quantity of the product in the predetermined period; a determination unit that determines whether the actual supply result quantity is less than a predetermined actual supply result quantity and whether the product is out of stock during the predetermined period; a correction unit that corrects, when it is determined that the actual supply result quantity is less than the predetermined actual supply result quantity and the product is out of stock during the predetermined period, the actual sales result quantity, and a prediction unit that predicts, on the basis of the corrected actual sales result quantity, a demand predict quantity of the product after the predetermined period.SELECTED DRAWING: Figure 1
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to a demand forecasting device and a demand forecasting method. [Background technology]

[0002] When a company supplies or sells products to a customer, if there is a surplus or deficiency in customer demand, excess inventory will be generated or demand will not be met (opportunity loss), leading to a decline in profits. In order to prevent this problem, it is necessary for companies that make up a supply chain, in particular, to produce the product in advance and procure parts for production so that the product can be supplied to customers in the right amount at the right time. To achieve this, it is preferable to predict future demand quantities based on past sales records, for example, and prepare to supply products to the supply chain including customers in an amount that matches the demand quantities. For example, in the technology of Patent Document 1, a planned sales quantity is calculated as the future demand quantity based on the past production quantities, sales quantities, and inventory quantities of the product. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent Publication No. 2021-174452 Summary of the Invention [Problem to be solved by the invention]

[0004] However, when an emergency event such as a pandemic-related lockdown or a natural disaster occurs, parts procurement and production cannot be carried out as planned, resulting in a shortage of product supply and inventory, and the sales volume of the product may decrease compared to the actual demand. If this decreased sales volume is used as past performance to predict future demand, the demand forecast will be based on the supply shortage situation caused by the pandemic even after the pandemic has subsided, and there is a risk of underestimating the demand volume. If parts procurement and production are carried out based on this underestimated demand volume, it will not be possible to prepare a supply to meet the actual demand, and the amount of products that would have been sold after the pandemic has subsided will not be able to be sold, resulting in lost sales opportunities.

[0005] The present invention has been made in consideration of the above circumstances, and has an object to perform demand forecasting with higher accuracy. [Means for solving the problem]

[0006] The present application includes a number of means for solving at least some of the above problems, examples of which are as follows.

[0007] In order to solve the above-mentioned problems, a demand prediction device according to one embodiment of the present invention has an acquisition unit that acquires the actual supply quantity of a product during a specified period in the past and the actual sales quantity of the product during the specified period; a determination unit that determines whether the actual supply quantity is shorter than the specified supply quantity and the product is out of stock during the specified period; a correction unit that corrects the actual sales quantity when it is determined that the actual supply quantity is shorter than the specified supply quantity and the product is out of stock during the specified period; and a prediction unit that predicts a forecasted demand quantity for the product for the specified period and beyond based on the corrected actual sales quantity. Effect of the Invention

[0008] According to the present invention, demand forecasting can be performed with higher accuracy.

[0009] Problems, configurations and effects other than those described above will become apparent from the following description of the embodiments. [Brief description of the drawings]

[0010] [Figure 1] FIG. 1 is a schematic diagram showing an example of a functional configuration of a demand prediction device according to the present embodiment. [Figure 2A] FIG. 2A is a schematic diagram showing an example of a data structure of sales plan information according to the present embodiment. [Figure 2B] FIG. 2B is a schematic diagram showing an example of a data structure of sales performance information according to the present embodiment. [Figure 3A] FIG. 3A is a schematic diagram showing an example of a data structure of inventory plan information according to the present embodiment. [Figure 3B] FIG. 3B is a schematic diagram showing an example of a data structure of actual inventory information according to the present embodiment. [Figure 4A] FIG. 4A is a schematic diagram showing an example of a data structure of supply plan information according to the present embodiment. [Figure 4B] FIG. 4B is a schematic diagram showing an example of a data structure of the supply history information according to the present embodiment. [Diagram 5] FIG. 5 is a schematic diagram showing an example of a data structure of out-of-stock information according to the present embodiment. [Figure 6] FIG. 6 is a schematic diagram illustrating an example of a data structure of demand estimation information according to the present embodiment. [Figure 7A] FIG. 7A is a schematic diagram showing an example of a data structure of demand forecast information according to the present embodiment calculated based on the "sales volume" before correction. [Figure 7B] FIG. 7B is a schematic diagram showing an example of a data structure of demand forecast information according to the present embodiment calculated based on the corrected "sales volume." [Figure 8] FIG. 8 is a schematic diagram showing an example of a process performed by the processing unit according to the present embodiment. [Figure 9] FIG. 9 is a schematic diagram showing another example of the process performed by the processing unit according to the present embodiment. [Figure 10]FIG. 10 is a schematic diagram showing another example of the method for correcting the "sales volume" according to this embodiment. [Figure 11] FIG. 11 is a schematic diagram showing an example of the average value of the "sales volume" for the past three years according to this embodiment. [Figure 12] FIG. 12 is a schematic diagram showing an example of a process performed by the processing unit according to the present embodiment when the unit of time period is one day. [Figure 13] FIG. 13 is a schematic diagram showing an example of a screen display of the display unit according to the present embodiment. [Figure 14] FIG. 14 is a schematic diagram of an example of a screen display of the display unit according to this embodiment when the supply shortage impact button is pressed. [Figure 15] FIG. 15 is a flowchart showing an example of a process performed by the demand prediction device according to this embodiment. [Figure 16] FIG. 16 is a schematic diagram showing an example of a hardware configuration of the demand prediction device according to this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0011] Hereinafter, an embodiment of the present invention will be described with reference to the drawings. In all the drawings for describing the embodiment, the same members are generally given the same reference numerals, and the repeated description thereof will be omitted as appropriate. In the following embodiment, the components (including element steps, etc.) are not necessarily essential, unless otherwise specified or considered to be obviously essential in principle. In addition, when "consisting of A", "consisting of A", "having A", or "including A" is used, it is understood that other elements are not excluded, except when it is specifically specified that only the element is included. Similarly, in the following embodiment, when referring to the shape, positional relationship, etc. of the components, etc., it includes those that are substantially similar to or similar to the shape, etc., except when it is specifically specified or considered to be obviously not essential in principle.

[0012] <Present embodiment> 1 is a schematic diagram showing an example of a functional configuration of a demand prediction device according to this embodiment. The demand prediction device 10 is a computer such as a PC (Personal Computer) or a server that predicts the future demand forecast quantity of a product. As an example, the demand prediction device 10 includes a processing unit 11, a storage unit 12, a communication unit 13, a display unit 14, and an input unit 15.

[0013] The communication unit 13 is an interface for connecting the demand prediction device 10 to a network 50 such as a LAN (Local Area Network) or the Internet.

[0014] The display unit 14 is a display device such as a liquid crystal display for displaying various information to the user.

[0015] The input unit 15 is an input device such as a keyboard or a mouse that allows a user to input various pieces of information to the demand prediction device 10. This embodiment is not limited to an embodiment in which a user directly operates the demand prediction device 10, and various pieces of information may be displayed on a terminal device (not shown) connected to the network 50, and the user may input various pieces of information to the demand prediction device 10 from the terminal device.

[0016] The memory unit 12 stores sales plan information 31, sales performance information 32, inventory plan information 33, inventory performance information 34, supply plan information 35, supply performance information 36, supply shortage information 37, stock-out information 38, demand estimation information 39, and demand forecast information 40.

[0017] FIG. 2A is a schematic diagram showing an example of the data structure of the sales plan information 31, and FIG. 2B is a schematic diagram showing an example of the data structure of the sales performance information 32. As shown in FIG.

[0018] The sales plan information 31 is information that associates each of the "product name," "seller," "planned sales period," and "sales plan quantity."

[0019] "Product name" is the name of the product, and "seller" is the seller of the product. Note that "product name" is not necessarily limited to the actual name, and may be information that identifies the product, such as a product code. Similarly, "seller" is not necessarily limited to the actual seller name, and may be a seller code, etc. "Planned sales period" is the period during which the product is planned to be sold. In this example, the unit of period is one week, and the first day of the period is stored in "planned sales period". This also applies to "sales period", "planned inventory period", "inventory period", "planned supply period", "supply period", "out-of-stock period", and "forecast period" described later. "Sales plan quantity" is the sales quantity planned in the "planned sales period".

[0020] The sales record information 32 is information that associates each of the "product name", "seller", "sales period", and "sales record quantity".

[0021] The "sales period" is the period during which the product was actually sold, and the "sales volume" is the actual sales volume of the product during that period.

[0022] FIG. 3A is a schematic diagram showing an example of the data structure of the inventory plan information 33, and FIG. 3B is a schematic diagram showing an example of the data structure of the inventory result information .

[0023] The inventory plan information 33 is information that associates each of the "product name," "location," "planned inventory period," and "planned inventory quantity."

[0024] "Location" is the inventory location of the product, "Planned inventory period" is the period during which inventory is planned at that inventory location, and "Planned inventory quantity" is the quantity of the product that is planned to be in stock at the inventory location during that period.

[0025] The inventory performance information 34 is information that associates each of the "product name," "location," "inventory period," and "inventory performance quantity."

[0026] The "inventory period" is the period during which the product was actually in stock at the "base." The "actual inventory quantity" is the actual inventory quantity during that period.

[0027] FIG. 4A is a schematic diagram showing an example of the data structure of the supply plan information 35, and FIG. 4B is a schematic diagram showing an example of the data structure of the supply performance information 36. As shown in FIG.

[0028] The supply plan information 35 is information in which a "product name", a "supplier", a "destination", a "planned supply period", and a "planned supply quantity" are associated with each other.

[0029] "Supply source" is the name of the supplier that supplies the product, and "supply destination" is the name of the delivery destination to which the supplier delivers the product. "Planned supply period" is the period during which the product is planned to be supplied to the "supply destination," and "planned supply quantity" is the quantity of the product that is planned to be supplied during that period.

[0030] The supply record information 36 is information in which the "product name", "supplier", "supply destination", "supply period", and "supply record quantity" are associated with each other.

[0031] The "supply period" is the period during which the product was actually supplied to the "supply destination." The "actual supply quantity" is the actual value of the quantity of the product actually supplied during that period.

[0032] 5 is a schematic diagram showing an example of the data structure of out-of-stock information 38 according to this embodiment. Out-of-stock information 38 is information that associates "product name," "seller," "determination period," and "out-of-stock determination."

[0033] The "determination period" is a period for determining whether or not a product is out of stock. The "out of stock determination" is information indicating whether or not a product was out of stock during the "determination period". If a product was out of stock, the result is "Yes", and if a product was not out of stock, the result is "No".

[0034] In this embodiment, the presence or absence of a stockout is determined based on the "actual inventory quantity" in the actual inventory information 34. For example, it is determined that a stockout occurred during a period in which the "actual inventory quantity" is zero.

[0035] FIG. 6 is a schematic diagram showing an example of a data structure of the demand estimation information 39. As shown in FIG.

[0036] The demand estimation information 39 is information that associates each of the "product name," "seller," "sales period," and "estimated demand quantity."

[0037] The "estimated demand quantity" is an estimate of the demand quantity of a product during a "sales period". The demand quantity is a quantity that indicates the demand for a product, and in this embodiment, the "sales record quantity" from sales record information 32 is used as the "estimated demand quantity", which is an estimate of the demand quantity. However, during a period when there is a shortage or stockout, a product cannot be sold even if it is desired to be sold, and the sales record quantity is smaller than when there is no shortage or stockout. Therefore, in this embodiment, the "sales record quantity" for a period when there is a shortage or stockout is corrected to obtain the "estimated demand quantity" for that period. The method of correction will be described later.

[0038] 7A and 7B are schematic diagrams showing an example of a data structure of the demand forecast information 40. The demand forecast information 40 is information that associates each of a "product name," a "location," a "forecast period," and a "demand forecast quantity."

[0039] The "demand forecast quantity" is a forecast value of the sales quantity of a product in a "forecast period" in the future. In this embodiment, the demand forecast quantity is calculated based on the "sales record quantity" in the sales record information 32 (see FIG. 2B). However, if the "sales record quantity" for a period in which there is a shortage of inventory or a stockout is corrected, the demand forecast quantity is calculated based on the corrected "sales record quantity". FIG. 7A is a schematic diagram showing an example of the data structure of the demand forecast information 40 calculated based on the "sales record quantity" before correction, and FIG. 7B is a schematic diagram showing an example of the data structure of the demand forecast information 40 calculated based on the "sales record quantity" after correction. A method for calculating the "demand forecast quantity" in the demand forecast information 40 will be described later.

[0040] 1 again, the above-mentioned information 31 to 36 is stored in, for example, a storage (not shown) connected to the network 50, and the processing unit 11 acquires it from the storage (not shown) as necessary and stores it in the memory unit 12.

[0041] The processing unit 11 includes a sales information acquisition unit 16, an inventory information acquisition unit 17, a supply information acquisition unit 18, a supply shortage calculation unit 19, a stockout detection unit 20, a determination unit 21, a correction unit 22, a prediction unit 23, and a display control unit 24.

[0042] The sales information acquisition unit 16 acquires the sales plan information 31 and the sales performance information 32 via the network 50 and stores them in the storage unit 12 .

[0043] The inventory information acquisition unit 17 acquires the inventory plan information 33 and the inventory performance information 34 via the network 50 and stores them in the storage unit 12 .

[0044] The supply information acquisition unit 18 acquires the supply plan information 35 and the supply performance information 36 via the network 50 , and stores them in the storage unit 12 .

[0045] The supply shortage calculation unit 19 calculates the supply shortage of the product in a certain period of time. The calculation method will be described with reference to FIG.

[0046] 8 is a schematic diagram showing an example of processing performed by the processing unit 11. In this example, a one-week period is adopted in accordance with the unit of time for each piece of information 31 to 36. Also, the periods in the inventory plan information 33 and the inventory performance information 34 are interpreted as representing the final day of the period resulting from calculation of receipt and payment of demand and supply for each period, and may not represent the inventory plan and performance values ​​at all times within the period.

[0047] As shown in Table 51 in Fig. 8, the supply shortage calculation unit 19 compares the "planned supply quantity" in the supply plan information 35 with the "actual supply quantity" in the actual supply information 36. The supply shortage calculation unit 19 then adopts the "planned supply quantity" as a predetermined supply quantity that serves as a criterion for determining whether or not there is a supply shortage, and calculates the "supply difference amount" obtained by subtracting the "actual supply amount" from the "planned supply amount" for the same period as the supply shortage for that period. In periods when the supply shortage amount is negative, a supply shortage of the product is occurring, and in periods when the supply shortage amount is 0 or more, there is no supply shortage of the product.

[0048] In the example of Figure 8, the supply difference amount is negative during the week beginning on 10 / 17, 10 / 24, and 10 / 31, so there is a supply shortage of the product. On the other hand, the supply difference amount is 0 or greater during the other periods, so there is no supply shortage of the product.

[0049] Referring again to FIG. 1, the stock-out detection unit 20 detects whether a product was out of stock during each period. For example, as shown in table 52 in FIG. 8, the stock-out detection unit 20 determines whether a product was out of stock based on the "actual inventory quantity" in the actual inventory information 34. For example, the stock-out detection unit 20 detects that a stock-out occurred during a period when the "actual inventory quantity" is 0, and determines that a stock-out did not occur during a period when the "actual inventory quantity" is greater than 0.

[0050] In the example of FIG. 8, stockouts occurred during the week beginning on 10 / 24, 10 / 31, 11 / 7, and 11 / 14, but did not occur during the other periods.

[0051] Furthermore, the stock-out detection unit 20 generates stock-out information 38 (see FIG. 5) indicating the result of the detection of the stock-out, and stores the stock-out information 38 in the storage unit 12.

[0052] Referring again to Fig. 1, the determination unit 21 determines whether the "actual supply quantity" is less than the predetermined supply quantity during a certain period and whether a stock-out has occurred during that period.

[0053] 8, the "supply difference amount" is negative and there is a shortage in the week starting on 10 / 24 and 10 / 31. Therefore, the determination unit 21 determines that the "actual supply amount" is less than the predetermined supply amount in these weeks and there is a shortage.

[0054] Referring again to Fig. 1, when the determination unit 21 determines that the "actual supply quantity" in a certain period is less than the predetermined supply quantity and that a stockout has occurred in that period, the correction unit 22 corrects the "actual sales quantity" in that period. The correction method will be described with reference again to Fig. 8.

[0055] As shown in Table 53 in Fig. 8, the correction unit 22 corrects the "actual sales quantity" for one week starting on each of 10 / 24 and 10 / 31, and sets the corrected value as the "estimated demand quantity." As an example, the correction unit 22 corrects the "actual sales quantity" by increasing the "actual sales quantity" for these periods. Since sales performance is pushed down during periods when there is a shortage in supply and stockout of a product, by increasing the "actual sales quantity" in this way, it is possible to obtain the original performance value without shortage in supply or stockout.

[0056] At this time, the correction unit 22 corrects the "sales performance quantity" based on at least one of the "demand forecast quantity" predicted before the period to be corrected and the "sales plan quantity" set before the period to be corrected. In the example of FIG. 8, the "sales plan quantity" for the period to be corrected is set as the "estimated demand quantity" after correction. For example, in the week of 10 / 24, the "sales plan quantity" of "900" becomes the "estimated demand quantity" after correction. The "demand forecast quantity" for the period to be corrected may be set as the "estimated demand quantity" after correction. The "demand forecast quantity" and the "sales plan quantity" are quantities that are set in advance assuming that there is no shortage of supply or stockout of the product. Therefore, by performing correction based on at least one of these quantities, a value close to the "sales performance quantity" when there is no shortage of supply or stockout can be obtained.

[0057] In the example of Figure 8, the "supply plan quantity" is used as the predetermined supply quantity that serves as the criterion for determining whether or not there is a shortage of a product, and a shortage is detected depending on whether the "actual inventory quantity" is 0 or not, but this embodiment is not limited to this, and processing such as that shown in Figure 9 may also be performed.

[0058] Fig. 9 is a schematic diagram showing another example of the processing performed by the processing unit 11. As shown in Table 51 in Fig. 9, in this example, the "supply plan quantity" minus the threshold value of 400 is set as the "surplus supply quantity" which is greater than 0. The "surplus supply quantity" is the lower limit of the quantity of the product that can be supplied with a margin. In this example, the same threshold value of "400" is used for all periods, but the threshold value may be changed for each period.

[0059] Then, the determination unit 21 adopts the "surplus supply quantity" as the predetermined supply quantity, and calculates the "supply shortage amount" which is the difference between the "actual supply quantity" and the "surplus supply quantity". When the "supply shortage amount" is negative, the determination unit 21 determines that the "actual supply quantity" is insufficient compared to the predetermined supply quantity, and when the "supply shortage amount" is equal to or greater than 0, the determination unit 21 determines that the "actual supply quantity" is not insufficient compared to the predetermined supply quantity. By determining whether there is a supply shortage based on the "surplus supply quantity", it is possible to determine that a supply shortage has occurred when there is no more surplus in the supply quantity.

[0060] Furthermore, as shown in Table 52, the stock-out detection unit 20 detects that a stock-out has occurred during a certain period when the "actual inventory quantity" during that period is below a surplus inventory quantity that is greater than 0. The surplus inventory quantity is a quantity greater than 0 that allows a product to be stocked with surplus. By determining whether or not there is a stock-out based on the surplus inventory quantity, it is possible to determine that a stock-out has occurred when there is no more surplus inventory.

[0061] Then, as shown in Table 53, the determination unit 21 determines for each period whether the "actual supply quantity" is less than the predetermined supply quantity and whether a stockout has occurred. Depending on the determination result, the correction unit 22 corrects the "actual sales quantity." Note that, although the processing of both Tables 51 and 52 in FIG. 9 is performed in this example, the processing of FIG. 8 described above may be performed for either Table 51 or Table 52.

[0062] In the example of FIG. 9, the "sales plan quantity" is set to the corrected "sales performance quantity" as in FIG. 8, but the correction method is not limited to this.

[0063] Fig. 10 is a schematic diagram showing another example of a method for correcting the "actual sales quantity." In the example of Fig. 10, the correction unit 22 sets α × "demand forecast quantity" + (1-α) × "sales plan quantity" as the corrected "actual sales quantity," and sets the corrected "actual sales quantity" as the "estimated demand quantity." Here, α is a correction coefficient between 0 and 1.

[0064] "Estimated demand quantity (1)", "Estimated demand quantity (2)", and "Estimated demand quantity (3)" in Fig. 10 are the "estimated demand quantities" when α = 0, α = 1, and α = 0.6, respectively. Note that if the "actual sales quantity" after correction is smaller than the "actual sales quantity" before correction, the correction unit 22 does not correct the "actual sales quantity", but sets the "actual sales quantity" before correction to the "estimated demand quantity". The white cells in Fig. 10 are cells in which the "actual sales quantity" before correction is set to the "estimated demand quantity" in this manner.

[0065] Furthermore, in the examples of Figs. 8 to 10, the "sales volume" is corrected to obtain the "estimated demand volume", but the average value of past "sales volume" may be corrected to obtain the "estimated demand volume".

[0066] Figure 11 is a schematic diagram showing an example of the average value of "sales volume" for the past three years. In this example, the average value of "sales volume" for the past three years during the same period is set as "sales volume (average)."

[0067] In this way, the correction unit 22 may use the average value of the "sales volume" over the past N years (N is a natural number) in place of the "sales volume" and correct the average value as described above. Furthermore, when the demand cycle of the product is one year, the average value over the past N years may be used in this way, but when the demand cycle is one month, the average value of the "sales volume" over the past N months may be used. Similarly, when the demand cycle is one week, the average value over the past N weeks may be calculated.

[0068] Furthermore, although the unit of the period is one week in the examples of FIGS. 8 to 11, the unit of the period may be one day.

[0069] Fig. 12 is a schematic diagram showing an example of the processing performed by the processing unit 11 when the unit of time period is one day. When the unit of time period of each piece of information 31-36 is one day, the unit of time period of each table 51-53 in Fig. 12 is also one day, and the correction unit 22 can correct the "sales volume" in the same way as when the unit of time period is one week.

[0070] On the other hand, when the unit period (unit period) of each piece of information 31 to 36 is one week, the supply shortage calculation unit 19 prorates each of the "supply plan quantity" and "actual supply quantity" for one week to the quantity for each day (predetermined period) included in that one week. Then, the supply shortage calculation unit 19 calculates the supply difference amount for each day based on the prorated "supply plan quantity" and "actual supply quantity".

[0071] Furthermore, the stock-out detection unit 20 prorates the "sales plan quantity" and "actual sales quantity" for a week to the quantities for each day included in the week, performs a receipt / payment calculation with the supply plan quantity and actual supply quantity prorated for each day described above, and calculates the "inventory plan quantity" and "actual inventory quantity" for each day. The stock-out detection unit 20 then detects stock-outs for each day based on the calculated "inventory plan quantity" and "actual inventory quantity."

[0072] The determining unit 21 determines for each day whether the "actual supply quantity" is less than the "planned supply quantity" and whether a stock-out has occurred.

[0073] Then, the correction unit 22 prorates each of the "demand forecast quantity," "sales plan quantity," "actual sales quantity," and "estimated demand quantity" for one week to the quantities included in that one week. Then, the correction unit 22 corrects the "actual sales quantity" on a daily basis based on these quantities and the determination result of the determination unit 21.

[0074] By apportioning the quantity for one week to the quantity for each day in this manner, even if the unit of time period for each piece of information 31 to 36 is one week, the "sales volume" can be corrected for each day.

[0075] The apportionment ratio may be determined in advance by the user based on the supply and demand trends for each day in a week. For example, if it is expected that the supply of a product will be greater on weekdays than on Saturdays and Sundays, the "actual supply quantity" may be apportioned using an apportionment ratio that reflects that expectation. For example, the expected ratio between the "actual supply quantity" on weekdays and the "actual supply quantity" on Saturdays and Sundays may be set as the apportionment ratio.

[0076] In addition, if it is expected that there will be more demand for a product on Saturdays and Sundays than on weekdays, the estimated ratio of the "actual sales quantity" on Saturdays and Sundays to the "actual sales quantity" on weekdays can be used as the proration ratio. In this way, by using the estimated ratio of the "actual supply quantity" or "actual sales quantity" on each day as the proration ratio, the demand trend for each day can be reflected in the prorated quantity.

[0077] Referring again to Fig. 1, the prediction unit 23 predicts the "demand forecast quantity" of a product for a certain predetermined period onward, based on the "sales actual quantity" for that predetermined period, generates demand forecast information 40 indicating the prediction results, and stores it in the storage unit 12. If the "sales actual quantity" has been corrected, the prediction unit 23 predicts the "demand forecast quantity" based on the corrected "sales actual quantity".

[0078] Methods for predicting the demand forecast quantity include the moving average method, the exponential smoothing method, the regression analysis method, and the weighted moving average method. The demand forecast quantity may also be predicted by a time series analysis method using ARIMA (Autoregressive Integrated Moving Average) or multiple regression. Furthermore, the demand forecast quantity may also be predicted by machine learning.

[0079] The display control unit 24 causes the display unit 14 to display a "demand forecast quantity" of the product predicted based on the uncorrected "sales actual quantity" and a "demand forecast quantity" based on the corrected "sales actual quantity" in a comparable manner. The display control unit 24 may display these "demand forecast quantities" on the display unit of a terminal device (not shown) connected to the network 50.

[0080] Fig. 13 is a schematic diagram of an example of a screen display of the display unit 14. As shown in Fig. 13, a forecast window 60 is displayed on the display unit 14. The forecast window 60 is a window showing the time transition of the "demand forecast quantity", and includes a demand forecast button 61 and a supply shortage impact button 62.

[0081] When the user presses the demand forecast button 61, the display control unit 24 displays a trend graph 63 indicating the "demand forecast quantity" of the product predicted based on the uncorrected "sales actual quantity" in the forecast window 60. If the user wishes to check the "demand forecast quantity" based on the corrected "sales actual quantity", the user presses the supply shortage impact button 62.

[0082] FIG. 14 is a schematic diagram of an example of a screen display on the display unit 14 when the supply shortage impact button 62 is pressed. As shown in FIG. 14, when the supply shortage impact button 62 is pressed, the display control unit 24 displays a transition graph 63 based on the uncorrected "sales actual quantity" along with a transition graph 64 showing the "demand forecast quantity" based on the corrected "sales actual quantity". The display control unit 24 aligns the time axes of the transition graphs 63, 64 to display the transition graphs 63, 64 in a comparable manner. This allows the user to understand the impact of product supply shortages and stockouts on the future "demand forecast quantity".

[0083] FIG. 15 is a flowchart showing an example of a process performed by the demand prediction device 10 according to the present embodiment.

[0084] First, the prediction unit 23 judges whether there is a demand forecast calculation request (step S10). For example, the prediction unit 23 judges that there is a calculation request (YES) when the demand forecast button 61 in the forecast window 60 is pressed, and judges that there is no calculation request (NO) when the demand forecast button 61 is not pressed. If NO is judged here, the process ends.

[0085] On the other hand, if the determination is YES, the process proceeds to step S11. In step S11, the processing unit 11 acquires information 31 to 36. For example, the sales information acquisition unit 16 acquires sales plan information 31 and sales performance information 32, and the inventory information acquisition unit 17 acquires inventory plan information 33 and inventory performance information 34. Furthermore, the supply information acquisition unit 18 acquires supply plan information 35 and supply performance information 36.

[0086] The acquired information 31 to 36 each include a common past period, which will be referred to as the evaluation period hereinafter. In the examples of Figures 2A to 4A, the first day of the evaluation period is 2022 / 10 / 3, and the last day of the evaluation period is the last day of the week starting from 2022 / 11 / 7.

[0087] Next, the prediction unit 23 predicts the "demand forecast quantity" based on the "sales performance quantity" before correction (step S12). For example, the prediction unit 23 predicts the "demand forecast quantity" for the future after the evaluation period based on the "sales performance quantity" in the sales performance information 32 for the evaluation period. Then, the prediction unit 23 generates demand forecast information 40 (see FIG. 7A) indicating the prediction result and stores it in the storage unit 12.

[0088] Next, the display control unit 24 displays the prediction result of the "demand forecast quantity" based on the "sales performance quantity" before correction (step S13). For example, the display control unit 24 displays the prediction result in a transition graph 63 as shown in FIG.

[0089] Next, the correction unit 22 determines whether there is a correction request for the "sales volume" (step S14). For example, the correction unit 22 determines that there is a correction request (YES) when the supply shortage impact button 62 in the forecast window 60 is pressed, and determines that there is no correction request (NO) when the supply shortage impact button 62 is not pressed.

[0090] If the answer here is YES, the process proceeds to step S15, where the supply shortage calculation unit 19 calculates the supply shortage of the commodity for each period (week) included in the evaluation period.

[0091] Next, the stock-out detection unit 20 detects whether the product was out of stock during each period (week) included in the evaluation period (step S16). Then, the stock-out detection unit 20 generates stock-out information 38 (see FIG. 5) indicating the result of the stock-out detection, and stores it in the storage unit 12.

[0092] Next, the determination unit 21 determines whether the predetermined period (week) during which the supply shortage and stockout occurred is within the evaluation period (step S17). If the determination is YES, the process proceeds to step S18.

[0093] In step S18, the correction unit 22 corrects the "actual sales quantity" for the specified period (week) during which the supply shortage and stockout occurred by increasing the "actual sales quantity" that was depressed during that specified period (week).

[0094] Next, the prediction unit 23 predicts the future "demand forecast quantity" after the predetermined period (week) when the supply shortage and stockout occurred based on the corrected "sales record quantity" (step S19). Then, the prediction unit 23 generates demand forecast information 40 (see FIG. 7B) indicating the prediction result and stores it in the storage unit 12.

[0095] Next, the display control unit 24 displays the prediction result of the "demand forecast quantity" based on the corrected "sales performance quantity" (step S20). For example, the display control unit 24 displays the prediction result in a transition graph 64 as shown in FIG.

[0096] This completes the basic processing performed by the demand forecasting device 10 according to this embodiment. Note that the processing also ends in the same manner when a NO decision is made in any of steps S10, S14, and S17.

[0097] According to the present embodiment described above, the sales volume for a period during which a product supply shortage or stockout occurs is corrected, so that the demand during that period is not underestimated. Therefore, it is possible to perform demand forecasting with higher accuracy based on the corrected sales volume.

[0098] <Hardware configuration> Next, a hardware configuration of the demand prediction device 10 according to this embodiment will be described.

[0099] FIG. 16 is a schematic diagram showing an example of a hardware configuration of the demand prediction device 10 according to this embodiment.

[0100] 16, the demand prediction device 10 includes a storage device 10a, a memory 10b, a processor 10c, an input device 10d, a display device 10e, a communication interface 10f, and a media reader 10g. These components are connected to each other by a bus 10i.

[0101] The storage device 10a is a non-volatile storage device such as a hard disk drive (HDD) or a solid state drive (SSD), and stores a demand forecasting program 100 according to this embodiment.

[0102] The demand forecasting program 100 may be recorded in a computer-readable recording medium 10h, and the processor 10c may read the demand forecasting program 100 from the recording medium 10h.

[0103] The recording medium 10h may be, for example, a physically portable recording medium such as a CD-ROM (Compact Disc - Read Only Memory), a DVD (Digital Versatile Disc), or a USB (Universal Serial Bus) memory. A semiconductor memory such as a flash memory or a hard disk drive may also be used as the recording medium 10h.

[0104] The demand forecasting program 100 may be stored in a device connected to a public line, the Internet, a LAN (Local Area Network), etc. In that case, the processor 10c may read and execute the demand forecasting program 100.

[0105] The memory 10b is hardware that temporarily stores data, such as a dynamic random access memory (DRAM), and the demand forecasting program 100 is deployed thereon.

[0106] The processor 10c is a CPU (Central Processing Unit) or a GPU (Graphical Processing Unit) that controls each part of the demand forecasting device 10. The processor 10c cooperates with the memory 10b to execute the demand forecasting program 100, thereby implementing the processing unit 11 in FIG.

[0107] The storage unit 12 in FIG. 1 is realized by a storage device 10a and a memory 10b.

[0108] The input unit 10d is an input device such as a keyboard or a mouse for implementing the input unit 15 in FIG.

[0109] The display device 10e is a display device such as a liquid crystal display for implementing the display unit 14 in FIG.

[0110] The communication interface 10f is hardware such as a network interface card (NIC) for connecting the demand prediction device 10 to the network 50. The communication interface 10f realizes the communication unit 13 in FIG.

[0111] The medium reading device 10g is hardware such as a USB reader for reading data recorded on the recording medium 10h.

[0112] The effects described in this specification are merely examples and are not limiting, and other effects may also be present.

[0113] The present invention is not limited to the above-described embodiments, and various modifications are included. 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 including all of the components described. In addition, it is possible to replace a part of the configuration of one embodiment with the configuration of another embodiment, and it is also possible to add the configuration of another embodiment to the configuration of one embodiment. In addition, it is possible to add, delete, or replace a part of the configuration of each embodiment with another configuration.

[0114] In addition, each of the above configurations, functions, processing units, processing means, etc. may be realized in hardware by designing a part or all of them as an integrated circuit, for example. In addition, each of the above configurations, functions, etc. may be realized in software by a processor interpreting and executing a program that realizes each function. Information such as a program, a judgment table, and a file that realizes each function can be placed in a memory, a storage device such as an HDD or SSD, or a recording medium such as an IC (Integrated Circuit) card, an SD (Secure Digital) card, or a DVD (Digital Versatile Disc). In addition, the control lines and information lines are shown as those considered necessary for explanation, and not all control lines and information lines are necessarily shown in the product. In reality, it may be considered that almost all configurations are connected to each other. [Explanation of symbols]

[0115] 10...demand forecasting device, 10a...storage device, 10b...memory, 10c...processor, 10d...input device, 10e...display device, 10f...communication interface, 10g...media reading device, 10h...recording medium, 10i...bus, 11...processing device, 12...storage unit, 13...communication unit, 14...display unit, 15...input unit, 16...sales information acquisition unit, 17...inventory information acquisition unit, 18...supply information acquisition unit, 19...supply shortage calculation unit, 20...out-of-stock detection unit, 21...determination unit, 22... Correction section, 23... prediction section, 24... display control section, 31... sales plan information, 32... sales performance information, 33... inventory plan information, 34... inventory performance information, 35... supply plan information, 36... supply performance information, 37... supply shortage information, 38... stockout information, 39... demand estimation information, 40... demand forecast information, 50... network, 51-53... table, 60... forecast window, 61... demand forecast button, 62... supply shortage impact button, 63, 64... trend graph, 100... demand forecast program.

Claims

1. an acquisition unit that acquires a past supply quantity of a product during a predetermined period of time and a past sales quantity of the product during the predetermined period; a determination unit that determines whether the past supply quantity is less than a predetermined supply quantity and whether the product is out of stock during the predetermined period; a correction unit that corrects the sales volume when it is determined that the supply volume is less than the predetermined supply volume and the product is out of stock during the predetermined period; a prediction unit that predicts a demand forecast quantity of the product after the predetermined period based on the corrected sales result quantity; A demand forecasting device having the above configuration.

2. The demand forecasting device according to claim 1, a display control unit that causes a display unit to display a demand forecast quantity of the commodity predicted based on the uncorrected sales actual quantity and the demand forecast quantity based on the corrected sales actual quantity in a comparable manner; The demand forecasting device further comprises:

3. The demand forecasting device according to claim 1, The correction unit corrects the sales volume by increasing the sales volume. Demand forecasting device.

4. The demand forecasting device according to claim 3, the correction unit corrects the sales performance quantity for the specified period based on at least one of a demand forecast quantity predicted before the specified period and a sales plan quantity set before the specified period; Demand forecasting device.

5. The demand forecasting device according to claim 1, the determination unit determines that the product is out of stock during the specified period when the actual inventory quantity of the product during the specified period is lower than a surplus inventory quantity that is greater than 0; Demand forecasting device.

6. The demand forecasting device according to claim 1, The predetermined supply quantity is a surplus supply quantity greater than 0. Demand forecasting device.

7. The demand forecasting device according to claim 1, The acquiring unit acquires supply performance information indicating the supply performance quantity for each unit period including a plurality of the predetermined periods, and sales performance information indicating the sales performance quantity for each unit period, the determination unit makes the determination based on a quantity obtained by proportionally dividing the actual supply quantity and the actual sales quantity in the unit period among a plurality of the predetermined periods; The correction unit corrects the apportioned sales volume. Demand forecasting device.

8. The demand forecasting device according to claim 7, the apportioned actual supply quantity is a quantity obtained by apportioning the actual supply quantity in the unit period to a plurality of the predetermined periods by using an estimated ratio of the ratio of the actual supply quantities in each of the plurality of predetermined periods as a proration ratio, The prorated sales volume is a volume obtained by prorating the sales volume in the unit period among the plurality of specified periods by using an estimated ratio of the sales volume in each of the plurality of specified periods as a proration ratio. Demand forecasting device.

9. The computer acquiring a supply record quantity of the product during a past predetermined period and a sales record quantity of the product during the past predetermined period; determining whether the actual supply quantity is less than a predetermined supply quantity and whether the product is out of stock during the predetermined period; correcting the sales volume when it is determined that the supply volume is less than the predetermined supply volume and the product is out of stock during the predetermined period; predicting a demand forecast quantity of the commodity after the predetermined period based on the corrected sales actual quantity; A demand forecasting method to perform.

10. The demand forecasting method according to claim 9, The computer, a step of displaying, on a display unit, a demand forecast quantity of the commodity predicted based on the uncorrected sales actual quantity and the demand forecast quantity based on the corrected sales actual quantity in a comparable manner; The demand forecasting method further comprises:

11. The demand forecasting method according to claim 9, The computer corrects the sales volume by increasing the sales volume. Demand forecasting methods.

12. The demand forecasting method according to claim 11, the computer corrects the sales performance quantity for the specified period based on at least one of a demand forecast quantity predicted before the specified period and a sales plan quantity set before the specified period; Demand forecasting methods.

13. The demand forecasting method according to claim 9, the computer determines that the product is out of stock during the specified period when the actual inventory quantity of the product during the specified period is lower than a surplus inventory quantity that is greater than 0; Demand forecasting methods.

14. The demand forecasting method according to claim 9, The predetermined supply quantity is a surplus supply quantity greater than 0. Demand forecasting methods.

15. The demand forecasting method according to claim 9, The computer includes: Acquire supply record information indicating the supply record quantity for each unit period including a plurality of the predetermined periods, and acquire sales record information indicating the sales record quantity for each unit period; Proportionately dividing the supply record quantity and the sales record quantity in the unit period into quantities in a plurality of the predetermined periods, and make the determination based on the quantities; Correct the prorated sales volume; Demand forecasting methods.

Citation Information

Patent Citations

  • Order support device and order support method

    JP2021174452A