Demand forecasting device and demand forecasting method
The demand forecasting device addresses the challenge of predicting demand for products with different specifications by calculating convergence time and rate, and updating these values based on sales performance, resulting in improved forecasting accuracy and reduced inventory costs.
Patent Information
- Application Number
- JP2022013293
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2022-01-31
- Publication Date
- 2025-04-22
- Estimated Expiration
- 2042-01-31
AI Technical Summary
Existing demand forecasting technologies struggle to accurately predict demand for products with different specifications within the same product group, as these demands can be influenced by promotional measures such as discounts, flyers, and email newsletters.
A demand forecasting device that includes a convergence time calculation unit, a convergence rate calculation unit, and a convergence rate updating unit. This device extracts sales performance information and parent-child item correspondence information to calculate a convergence time and convergence rate, which are then updated based on sales performance to accurately predict demand for products with different specifications.
The solution enables accurate prediction of demand for products with different specifications, taking into account the impact of promotional measures, thereby improving demand forecasting accuracy and reducing inventory costs.
Smart Images

Figure 0007667103000001 
Figure 0007667103000002 
Figure 0007667103000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a demand forecasting device and a demand forecasting method. [Background technology]
[0002] For make-to-stock products, which require a lead time from manufacturing to supply, it is necessary to predict the demand for the product in advance and then procure parts, assemble the product, and transport it to the market according to the results of the prediction. In particular, for products that have the same basic structure but come in a variety of specifications, such as different colors or the presence or absence of additional functions, the parts required and production methods differ for each specification, so it is essential to predict the demand for each product specification.
[0003] Regarding product demand forecasting, for example, Patent Document 1 describes an "integrated demand forecasting device that constructs multiple demand forecasting models based on actual demand amounts stored in a demand actual amount storage means that stores past actual demand amounts, and calculates predicted demand amounts for each of the constructed demand forecasting models." [Prior art documents] [Patent documents]
[0004] [Patent Document 1] JP 2013-131259 A Summary of the Invention [Problem to be solved by the invention]
[0005] The technology described in Patent Document 1 can predict the demand for a product group (a collection of products with the same basic structure. For example, in the case of refrigerators, a group of refrigerators made by the same manufacturer and with the same capacity and grade (high-end, standard, etc.)) based on past demand records. However, the demand for products that belong to the same product group but have different specifications (for example, in the case of refrigerators, differences in color, door opening and closing direction, etc.) can be affected by the implementation or non-implementation of sales promotion measures such as publication in flyers or e-mail magazines, discounts, and changes to in-store displays, and therefore cannot be predicted with high accuracy based on past demand records alone.
[0006] The present invention has been made in consideration of the above points, and aims to make it possible to accurately predict the demand for products that belong to the same product group but have different specifications, which may be affected by whether or not promotional measures are implemented. [Means for solving the problem]
[0007] The present application includes a number of means for solving at least some of the above problems, examples of which are as follows.
[0008] In order to solve the above problem, a demand forecasting device according to one embodiment of the present invention comprises: a convergence time point calculation unit that refers to sales performance information that indicates the sales performance of each product and parent-child item correspondence information that indicates the correspondence between child items of the product and parent items, extracts the sales performance of a parent item that corresponds to a target product as the child item for which demand volume is to be predicted, and calculates a convergence time point T that indicates the time point at which the demand composition ratios of multiple products with different specifications that belong to a product group to which the target product belongs converge, based on the sales performance of the parent item; a composition ratio calculation unit that determines a calculation method using the convergence time point T as a threshold value, and calculates the composition ratio of the target product based on at least one of the sales performance of the parent item and the sales performance of the target product in accordance with the determined calculation method; and a composition ratio update unit that updates the calculated composition ratio using an update coefficient according to a promotional measure. Effect of the Invention
[0009] According to the present invention, it is possible to accurately predict the demand for products with different specifications that belong to the same product group and that may be affected by the implementation or non-implementation of sales promotion measures.
[0010] Problems, configurations, and effects other than those described above will become apparent from the following description of the embodiments. [Brief description of the drawings]
[0011] [Figure 1] FIG. 1 is a block diagram illustrating an example of the configuration of a demand forecasting system. [Diagram 2] FIG. 2 is a block diagram showing an example of the configuration of a typical computer. [Diagram 3] FIG. 3 is a diagram illustrating an example of a data structure of sales performance information. [Figure 4] FIG. 4 is a diagram illustrating an example of a data structure of parent-child item correspondence information. [Diagram 5] FIG. 5 is a diagram illustrating an example of a data structure of the product exhibition information. [Figure 6] FIG. 6 is a diagram showing an example of a data structure of the media publication information. [Figure 7] FIG. 7 is a diagram illustrating an example of a data structure of the sales promotion measure information. [Figure 8] FIG. 8 is a diagram illustrating an example of a data structure of the update coefficient information. [Figure 9] FIG. 9 is a diagram illustrating an example of a data structure of the composition ratio prediction information. [Figure 10] FIG. 10 is a diagram showing an example of the data structure of the updated component ratio information. [Figure 11] FIG. 11 is a diagram illustrating an example of a data structure of the product group demand forecast information. [Figure 12] FIG. 12 is a diagram illustrating an example of a data structure of the product master information. [Figure 13] FIG. 13 is a diagram for explaining the concept of demand forecasting. [Figure 14] FIG. 14 is a flowchart illustrating an example of the demand forecasting process. [Figure 15]FIG. 15 is a flowchart illustrating an example of the process of step S3 in detail. [Figure 16] FIG. 16 is a flowchart illustrating an example of the process of step S4 in detail. [Figure 17] FIG. 17 is a diagram showing an example of the calculation result obtained by the process in step S45. [Figure 18] FIG. 18 is a diagram for explaining an example of the process of step S47 in detail. [Figure 19] FIG. 19 is a flowchart illustrating an example of the process of step S11 in detail. [Figure 20] FIG. 20 is a diagram showing a display example of the output screen. [Figure 21] FIG. 21 is a diagram showing an example of use of the demand forecasting system. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0012] Hereinafter, an embodiment of the present invention will be described with reference to the drawings. In all the drawings for explaining the embodiment, the same members are generally given the same reference numerals, and the repeated description thereof will be omitted. In addition, 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 is understood that the shape, etc. of the components, etc. are substantially approximated or similar to the shape, etc., except when it is specifically specified or considered to be obviously not essential in principle.
[0013] <Configuration example of a demand forecasting system 1 according to an embodiment of the present invention> 1 shows an example of the configuration of a demand forecasting system 1 according to an embodiment of the present invention. The demand forecasting system 1 predicts the demand for a product that is uniquely determined by a product group and specifications. A product group is a collection of products that have the same basic structure, and for example, if the product is a refrigerator, it refers to a group of refrigerators manufactured by the same manufacturer, have the same capacity and grade (high-end, standard, etc.), and are assigned a common model number, and the specifications refer to differences in color and door opening and closing direction of refrigerators assigned a common model number.
[0014] The demand forecasting system 1 includes a demand forecasting device 10, a database 20, and a user terminal 30, which are connected via a network 2. The network 2 is a two-way communication network such as the Internet.
[0015] The demand prediction device 10 is realized by a general computer such as a personal computer.
[0016] 2 shows an example of the configuration of a general computer 100 that realizes the demand forecasting device 10. The computer 100 includes a processor 101, a ROM 102, a RAM 103, an auxiliary storage device 104, a display device 105, an input device 106, a media reading device 107, and an information receiving / transmitting device 108.
[0017] The processor 101 is composed of a central processor unit (CPU) and executes various calculations according to a predetermined program. The read only memory (ROM) 102 stores programs required for starting the computer 100. The RAM 103 stores programs executed by the processor 101 and data required for executing the programs. The auxiliary storage device 104 is composed of, for example, a hard disk drive (HDD) or a solid state drive (SSD), and stores programs and various data. The display device 105 is composed of a liquid crystal display, an organic electro-luminescence (EL) display, and displays various screens. The input device 106 is composed of a keyboard, a mouse, a microphone, and accepts input of commands, voice, and the like from a user. The media reader 107 reads data from a removable storage medium such as a semiconductor memory, and records data on a recording medium. The information receiver / transmitter 108 is composed of a communication module and the like, and transmits and receives data via the network 2.
[0018] In the computer 100, the processor 101 loads a predetermined program stored in the auxiliary storage device 104 into the RAM 103 and executes it, thereby implementing each functional block of the demand forecasting device 10.
[0019] Returning to Fig. 1, the demand prediction device 10 includes functional blocks of a storage unit 11, a processing unit 12, and a communication unit 13.
[0020] The storage unit 11 is realized by the RAM 103 and the auxiliary storage device 104 of the computer 100. The storage unit 11 stores sales performance information 111, parent-child item correspondence information 112, product exhibition information 113, media publication information 114, sales promotion policy information 115, update coefficient information 116, composition ratio forecast information 117, updated composition ratio information 118, product group demand forecast information 119, and product master information 1110.
[0021] The sales performance information 111 is information that indicates the sales performance of the product. The sales performance information 111 is stored in advance in the database 20, and is acquired from the database 20 via the network 2 by the communication unit 13 and stored in the storage unit 11.
[0022] 3 shows an example of the data structure of the sales performance information 111. The sales performance information 111 includes cumulative sales performance 111a and composition ratio transition information 111b.
[0023] The cumulative sales performance 111a indicates the sales performance of each product, which is uniquely identified by the product group (model) and the specifications, from the time of the start of sales. Hereinafter, for example, a product belonging to the product group RS50 and having the specifications LA will be referred to as the product RS50·LA. The same applies to other products.
[0024] In the case of the figure, for example, the cumulative sales volume of the product RS50·LA is 20,000 units, and the cumulative sales volume of the product RS50·RA is 40,000 units. Note that the cumulative sales volume "-" indicates that the corresponding product has not been sold and is scheduled to be sold.
[0025] The composition ratio transition information 111b shows the weekly transition of the composition ratio of the products that make up the product group, calculated based on the cumulative sales performance 111a. In the example shown in the figure, the composition ratios of the products RS50·LA, RS50·RA, RS50·LB, and RS50·RB, which belong to the product group RS50 but have different specifications, are 50%, 30%, 20%, and 0% in the first week after the start of sales, 30%, 30%, 20%, and 20% in the second week, and 20%, 40%, 30%, and 10% in the 52nd week.
[0026] Returning to Fig. 1, parent-child item correspondence information 112 is information that indicates the correspondence between new products (child items) that are on sale or are scheduled to be on sale, and their previous generation old products (parent items). Parent-child item correspondence information 112 is stored in advance in database 20, and is obtained from database 20 via network 2 by communication unit 13 and stored in storage unit 11.
[0027] Fig. 4 shows an example of the data structure of the parent-child item correspondence information 112. In the case of this figure, for example, it is shown that the parent item of the child item product RT50·LA is the product RS50·LA, and the parent item of the child item product RT50·RA is the product RS50·RA.
[0028] Returning to Fig. 1, the product display information 113 is information that indicates the display status of products in a store such as a home appliance retailer. The product display information 113 is stored in advance in the database 20, and is acquired from the database 20 via the network 2 by the communication unit 13 and stored in the storage unit 11.
[0029] Fig. 5 shows an example of the data structure of the product display information 113. In the case of this figure, the date is omitted, and for example, it shows that the product RT50·LA is not on display in the store "X Electric" but is on display in the store "Y Mall".
[0030] Returning to FIG. 1, media publication information 114 is information that indicates the publication ratio in media of products that belong to the same product group but have different specifications. Media publication information 114 is calculated in advance based on the number of images of each product published on EC (Electronic Commerce) sites, each Web page, etc., and the publication ratio of each product (number of images published of each product / total number of images published of products belonging to the product group) and stored in database 20, and is obtained from database 20 via network 2 by communication unit 13 and stored in storage unit 11. The number of images published of each product can be obtained, for example, by using a technique such as image mining on Web pages.
[0031] Fig. 6 shows an example of the data structure of the media publication information 114. In this figure, the dates are omitted, and the publication ratios in the media of four products RT50·LA, RT50·RA, RT50·LB, and RT50·RB belonging to the same product group are shown to be 30%, 50%, 15%, and 5%.
[0032] Returning to FIG. 1, the sales promotion policy information 115 is information indicating the implementation date (including the date that has been implemented and the date that is planned) and the type of sales promotion policy for each product. The sales promotion policy information 115 is stored in advance in the database 20, and is acquired from the database 20 via the network 2 by the communication unit 13 and stored in the memory unit 11. The types of sales promotion policies include discounts, publication in flyers, e-mail newsletters, in-store displays, and media coverage. The user can change the schedule for future sales promotion policies in the sales promotion policy information 115 (FIG. 7).
[0033] Fig. 7 shows an example of the data structure of the sales promotion policy information 115. In the case of this figure, for example, for product RT50·LA, it is shown that an e-mail newsletter was distributed on August 16th, and for product RT50·RA, a flyer was published on August 9th and an e-mail newsletter was distributed on August 16th (or will be implemented). Note that a sales promotion policy "-" indicates that no sales promotion policy will be implemented for the product.
[0034] Returning to Fig. 1, the update coefficient information 116 is information that indicates an update coefficient for updating the composition ratio depending on the presence or absence of a promotional measure. Promotional measures include, in addition to discounts, flyer publication, and e-mail newsletters exemplified in Fig. 7, in-store displays, media publication, etc. The update coefficient information 116 is calculated by the update coefficient calculation unit 124 and stored in the memory unit 11.
[0035] 8 is an example of the update coefficient information 116. In the case of the figure, for example, the update coefficient is 1.8 when flyers are published as a promotional measure, and 0.7 when they are not published. This means that the composition ratio of products for which flyers are published as a promotional measure is multiplied by 1.8, and the composition ratio of products for which flyers are not published is multiplied by 0.7.
[0036] Returning to Fig. 1, composition ratio prediction information 117 is information that represents a composition ratio convergence week T at which the composition ratio of the demand amount of products belonging to the same product group but with different specifications is predicted to converge, a composition ratio convergence start week S at which the convergence is predicted to start, and a composition ratio predicted value. The composition ratio convergence week T is calculated by the convergence time point calculation unit 121, the composition ratio convergence start week S by the convergence start time point calculation unit 122, and the composition ratio predicted value by the composition ratio calculation unit 123, and are stored in the storage unit 11 as composition ratio prediction information 117.
[0037] 9 shows an example of the data structure of the composition ratio prediction information 117. In the case of this figure, for example, the convergence week T of the composition ratio of the product with different specifications belonging to the product group RT50 is the 10th week from the start of sales, the convergence start week S is the 5th week from the start of sales, and the predicted values of the composition ratios of the products with different specifications RT50·LA, RT50·RA, RT50·LB, and RT50·RB belonging to the product group RT50 are 32%, 38%, 25%, and 5%.
[0038] Returning to Fig. 1, the updated composition ratio information 118 is information that represents the transition of the predicted value of the composition ratio that is updated depending on the presence or absence of promotional measures for products that belong to the same product group but have different specifications. The updated composition ratio information 118 is calculated by the composition ratio update unit 125 and stored in the storage unit 11.
[0039] 10 shows an example of the data structure of the updated composition ratio information 118. In the case of this figure, for example, the predicted values of the updated composition ratios of the products RT50·LA, RT50·RA, RT50·LB, and RT50·RB with different specifications belonging to the product group RT50 are 32%, 38%, 25%, and 5% on August 2, 20%, 61%, 16%, and 3% on August 9, and 32%, 38%, 25%, and 5% on August 16.
[0040] Returning to Fig. 1, the product group demand forecast information 119 is information that indicates a forecast value of the demand amount for each product group. The product group demand forecast information 119 is stored in advance in the database 20, and is acquired from the database 20 via the network 2 by the communication unit 13 and stored in the storage unit 11. The demand amount for each product group is forecast using a method such as machine learning or an autoregressive integrated moving average model based on statistical information such as the market size, economic situation, and population size of each country.
[0041] 11 shows an example of the data structure of the product group demand forecast information 119. In the example shown in FIG. 11, the demand forecast value for the product group RT50 is 300 units on August 2, 500 units on August 9, and 350 units on August 16.
[0042] Returning to FIG. 1, the product master information 1110 is information indicating the product category, product family, specifications, sales start date, and sales end date of each product. In the case of home appliances, the product category refers to a classification such as a refrigerator, a washing machine, a TV, etc. The product master information 1110 is stored in advance in the database 20, and is acquired from the database 20 by the communication unit 13 via the network 2 and stored in the storage unit 11.
[0043] 12 shows an example of the data structure of the product master information 1110. In this example, the sales start date of the product RS50·LA, which belongs to the product category A1, is April 1, 2020, and the sales end date is April 5, 2021.
[0044] Of the above-mentioned information, sales performance information 111, parent-child item correspondence information 112, product exhibition information 113, media coverage information 114, sales promotion policy information 115, product group demand forecast information 119, and product master information 1110 may not be stored in memory unit 11, and each piece of information stored in database 20 may be referenced as necessary.
[0045] Returning to Fig. 1, the processing unit 12 is realized by the processor 101 of the computer 100. The processing unit 12 has a convergence time point calculation unit 121, a convergence start time point calculation unit 122, a component ratio calculation unit 123, an update coefficient calculation unit 124, a component ratio update unit 125, a demand amount calculation unit 126, and an output control unit 127.
[0046] The convergence point calculation unit 121 calculates the point in time (expressed in weeks starting from the sales start date; hereinafter referred to as the composition ratio convergence week T) when the composition ratio of the demand for products with different specifications that belong to the same product group will be predicted to converge, based on the sales record information 111, the parent-child item correspondence information 112, and the product master information 1110, in accordance with the convergence calculation process (FIG. 15) described later, and stores the calculated point in time in the composition ratio forecast information 117.
[0047] The convergence start time calculation unit 122 calculates the time (expressed in weeks starting from the sales start date; hereinafter referred to as composition ratio convergence start week S) when the composition ratio of the demand for products with different specifications that belong to the same product group is predicted to start converging, based on the sales result information 111, parent-child item correspondence information 112, composition ratio forecast information 117, and product master information 1110, in accordance with the convergence start time calculation process (FIG. 16) described later, and stores the calculated time in the composition ratio forecast information 117.
[0048] The composition ratio calculation unit 123 calculates a predicted value (predicted value α, β or γ) of the composition ratio of the demand for products that belong to the same product group but have different specifications based on the sales performance information 111, the parent-child item correspondence information 112, the composition ratio forecast information 117, and the product master information 1110, in accordance with the composition ratio calculation process (FIG. 14) described later, and stores this in the composition ratio forecast information 117 as the composition ratio forecast value.
[0049] The update coefficient calculation unit 124 calculates an update coefficient for each product based on the sales performance information 111, the product exhibition information 113, the media publication information 114, and the sales promotion measure information 115 in accordance with the update coefficient calculation process (FIG. 18) described later, and stores the update coefficient in the update coefficient information 116.
[0050] The composition ratio update unit 125 multiplies the composition ratio of the demand for products that belong to the same product group but have different specifications by an update coefficient in accordance with the composition ratio update process (FIG. 13) described later based on the product exhibition information 113, media publication information 114, sales promotion measure information 115, and update coefficient information 116, and further updates the composition ratio by normalizing it, and stores it in updated composition ratio information 118.
[0051] The demand calculation unit 126 calculates the demand for each product by multiplying the product group demand forecast value by the composition ratio of each product based on the updated composition ratio information 118 and the product group demand forecast information 119.
[0052] The output control unit 127 causes the user terminal 30 to display an output screen showing the demand amount of each product calculated by the demand amount calculation unit 126, etc.
[0053] The communication unit 13 is realized by the information receiving / transmitting device 108 of the computer 100. The communication unit 13 connects to the database 20 via the network 2, obtains various types of information, and stores the information in the storage unit 11.
[0054] The database 20 is, for example, an ERP (Enterprise Resource Planning) system. It is assumed that the database 20 stores in advance sales performance information 111, parent-child item correspondence information 112, product exhibition information 113, sales promotion policy information 115, product group demand forecast information 119, and product master information 1110. The user terminal 30 is, for example, a general computer such as a personal computer, and is operated by a user who makes a production plan for a product based on a forecast value of the demand for the product. The user terminal 30 presents to the user an output screen showing the forecast value of the demand for the product obtained from the demand forecasting device 10, etc.
[0055] Next, FIG. 13 is a diagram for explaining the concept of demand forecasting in this embodiment.
[0056] In this embodiment, the following characteristics (1) and (2) regarding product demand are utilized. (1) The composition ratios of products (sub-items) belonging to the same product group with different specifications are correlated with the composition ratios of the products of the corresponding parent item. (2) The composition ratios of products belonging to the same product group with different specifications ultimately converge due to ergonomics (for example, since there are more right-handed people than left-handed people in Japan, the refrigerator door is more in demand to open and close with the right hand, so the right-opening type has more demand than the left-opening type), consumer psychology, living environment, etc.
[0057] Then, the period after the start of product sales is divided into a first period from the start of sales to the week S of the start of composition ratio convergence (excluding the week S of the start of composition ratio convergence), a second period from the week S of the start of composition ratio convergence to the week T of composition ratio convergence (including the week S of the start of composition ratio convergence and excluding the week T of composition ratio convergence), and a third period after the week T of composition ratio convergence (including the week T of composition ratio convergence). The calculation method of the composition ratio is changed according to whether the project planning date (the target date of demand prediction) belongs to any of the first to third periods.
[0058] Specifically, as shown in the upper part of the figure, when the Nth week, which is the project planning date, belongs to the first period (when N < S), for the composition ratio of the target product (sub-item), the composition ratio α after convergence of the parent item calculated based on the cumulative sales performance of the corresponding parent item is adopted.
[0059] Also, as shown in the middle part of the figure, when the Nth week, which is the project planning date, belongs to the second period (when S ≤ N < T), for the composition ratio of the product (sub-item) to be predicted, the composition ratio γ calculated using the composition ratio α and the composition ratio β according to the following formula (1) is adopted. γ = {α × (T - N) + β × (N - S + 1)} / (T - S + 1) ···(1)
[0060] Here, the composition ratio β is a composition ratio calculated based on the cumulative sales performance of the target product (child item) at the current time. The composition ratio β converges after the composition ratio convergence week T. In the second period, the composition ratio of the target product (child item) transitions from α to β, so the composition ratio γ is calculated by combining the composition ratio α and the composition ratio β. Specifically, when week N is close to the composition ratio convergence start week S, the proportion of the parent item's composition ratio α is high, and as week N approaches the composition ratio convergence week T, the proportion of the composition ratio β becomes higher.
[0061] Furthermore, as shown in the lower part of the figure, if the Nth week, which is the planning date, belongs to the third period (T≦N), the composition ratio of the target product (child item) is the composition ratio β, which is calculated based on the cumulative sales performance of the product.
[0062] <Demand forecasting process by the demand forecasting device 10> Next, FIG. 14 is a flowchart illustrating an example of a demand forecasting process performed by the demand forecasting device 10.
[0063] The demand forecasting process, for example, predicts the demand quantities of a product group designated by the user using the user terminal 30, or of a plurality of products with different specifications that belong to the product group to which the product designated by the user belongs. The demand forecasting process is automatically executed at a predetermined timing, for example, by batch processing or the like.
[0064] First, the communication unit 13 connects to the database 20 via the network 2, and acquires sales performance information 111, parent-child item correspondence information 112, product exhibition information 113, media coverage information 114, promotional campaign information 115, and product master information 1110, and stores them in the memory unit 11 (step S1).
[0065] Next, the processing unit 12 sets the product group specified by the user, or the product group to which the product specified by the user belongs, as the target product group for demand forecasting, and sequentially focuses on multiple products with different specifications that belong to the target product group, and executes the following steps S3 to S10 as the target products for demand forecasting (step S2).
[0066] Specifically, the convergence time point calculation unit 121 refers to the sales performance information 111, the parent-child item correspondence information 112, and the product master information 1110, and calculates the composition ratio convergence week T of the target product based on the sales performance of the parent item corresponding to the target product (child item) (step S3).
[0067] 15 is a flowchart detailing an example of the process of step S3. First, the convergence time point calculation unit 121 refers to the parent-child item correspondence information 112 to identify a parent item corresponding to the target product (child item) (step S21). If the parent item corresponding to the target product (child item) is not recorded in the parent-child item correspondence information 112, the product master information 1110 may be referred to, and a product that belongs to the same product category as the target product (child item) and has similar codes representing the product group model and specifications and whose sales start date is earlier than and closest to the sales start date of the target product (child item) may be regarded as the parent item.
[0068] Next, the convergence time calculation unit 121 extracts the sales performance information 111 of the parent item of the target product (child item) (step S22). Next, the convergence time calculation unit 121 sets the period from the start of sales of the parent item to the end of sales in weeks based on the product master information 1110 as the target week t (step S23).
[0069] Next, the convergence time point calculation unit 121 refers to the composition ratio transition information 111b of the sales performance information 111 and calculates Δ shown in the following equation (2), that is, the square of the difference between the composition ratio of the parent item corresponding to the target product (child item) in the target week t and the composition ratio in the previous week (t-1) (step S24). Δ={(composition ratio in target week t)-(composition ratio in previous week (t-1))} 2 (2)
[0070] Next, the convergence time point calculation unit 121 calculates that Δ is 0.05 2 It is determined whether or not it is equal to or smaller than this, that is, whether or not the change in the composition ratio of the parent item between the target week t and the previous week (t-1) is within ±5% (step S25).
[0071] Here, Δ is 0.05 2 If it is determined that the target week t is not equal to or less than the end of the sales week (NO in step S25), the convergence time point calculation unit 121 determines whether the target week t is the end of the sales week (step S26), and if it is determined that the target week t is not the end of the sales week (NO in step S26), the count variable n is initialized to 0 (step S27). 2 This represents the number of consecutive weeks that are less than or equal to 0, and its initial value is 0. Thereafter, the process returns to step S23, the target week t is incremented by 1, and steps S23 and after are repeated. If the convergence time point calculation unit 121 determines that the target week t is the end week of the sales week (YES in step S26), the process proceeds to step S30.
[0072] Conversely, if Δ is 0.05 2 If it is determined that the count variable n is equal to or smaller than the threshold value (YES in step S25), the convergence time point calculation unit 121 increments the count variable n by 1 (step S28).
[0073] Next, the convergence time point calculation unit 121 determines whether the count variable n is 3, and whether the target week t is the sales end week (step S29). If it is determined that the count variable n is not 3 and the target week t is not the sales end week (NO in step S29), the process returns to step S23, the target week t is incremented by 1, and steps S23 and after are repeated.
[0074] Conversely, if it is determined that the count variable n is 3 and / or the target week t is the sales end week (YES in step S29), the process proceeds to step S30.
[0075] Next, the convergence time point calculation unit 121 determines the target week t as the composition ratio convergence week T of the target product (child item) and records it in the composition ratio forecast information 117 (step S30).
[0076] As described above, after the convergence time point calculation unit 121 determines the composition ratio convergence week T of the target product (child item) based on the sales performance of the parent item corresponding to the target product (child item), processing proceeds to step S4 in Figure 14.
[0077] Next, the convergence start time calculation unit 122 calculates the convergence start week S at which the composition ratio of the target product starts to converge, based on the sales performance information 111, the parent-child item correspondence information 112, the composition ratio forecast information 117, and the product master information 1110 (step S4).
[0078] Fig. 16 is a flowchart detailing an example of the processing of step S4. First, the convergence start time calculation unit 122 refers to the parent-child item correspondence information 112 to identify the parent item of the target product (child item) and its parent item (the child item two generations before) (step S41). If the parent item of the target product (child item) is not recorded in the parent-child item correspondence information 112, as in step S21 of Fig. 15, among products that belong to the same product category as the target product (child item) and have similar codes representing the product group model and specifications, a product whose sales start date is before the sales start date of the target product (child item) and is closest to the sales start date of the target product (child item) may be regarded as the parent item. The same applies to the parent item of a parent item.
[0079] Next, the convergence start time calculation unit 122 extracts the parent item of the target product (child item) and the sales performance information 111 of the parent item (step S42).
[0080] Next, the convergence start time calculation unit 122 refers to the composition ratio transition information 111b of the sales performance information 111 of the target product (child item) two generations ago, and specifies the composition ratio of the target product (child item) two generations ago after convergence as the composition ratio α of the parent item of the target product (child item). The convergence start time calculation unit 122 also refers to the composition ratio transition information 111b of the sales performance information 111 of the parent item of the target product (child item), and specifies the composition ratio β of the parent item of the target product (child item) after convergence (step S43).
[0081] Next, based on the product master information 1110, the convergence start time calculation unit 122 sequentially assumes the convergence start week S from week 1 to week T from the sales start date of the parent item to the convergence week T of the composition ratio calculated in step S3 (step S44).
[0082] Next, with the convergence start week S fixed, the convergence start time calculation unit 122 calculates the composition ratio of the Nth week of the target product (sub-item) when the Nth week, which is the planning date, is changed from week 1 to week T according to the case classification shown in FIG. 13 (step S45).
[0083] FIG. 17 shows an example of the calculation result in step S45. However, in the figure, the convergence week T of the composition ratio calculated in step S3 is 10, the composition ratio α of the parent item of the target product (sub-item) calculated in step S43 is 0.270, and the composition ratios β based on the cumulative sales records for N = 1 to 10 are 0.381, 0.397, ···, 0.270, respectively.
[0084] For example, when the convergence start week S = 1, when N week = 1, S ≤ N, and the Nth week belongs to the second period shown in FIG. 13, so the composition ratio γ is calculated according to formula (1). γ=(0.270×(10 - 1)+0.381×1) / 10 = 0.281
[0085] Also, for example, when the convergence start week S = 2, when N week = 1, N < S, and the Nth week belongs to the first period shown in FIG. 13, so the composition ratio α = 0.270 is adopted. Also, when N week = 2, S ≤ N, and the Nth week belongs to the second period shown in FIG. 13, so the composition ratio γ is calculated as follows according to formula (1). γ=(0.270×(10 - 2)+0.397×2) / 10 = 0.295
[0086] Also, when N week = 10, T ≤ N, and the Nth week belongs to the third period shown in FIG. 13, so the composition ratio β = 0.270 is adopted.
[0087] Furthermore, for example, when the convergence start week S = 10, since N < S when N weeks = 1 to 9 and N weeks belong to the first period shown in FIG. 13, the composition ratio α = 0.270 is adopted. When N weeks = 10, since T ≤ N and N weeks belong to the third period shown in FIG. 13, the composition ratio β = 0.270 is adopted.
[0088] Return to FIG. 16. Next, the convergence start time calculation unit 122 determines whether the current convergence start week S is the same as the composition ratio convergence week T (step S46). Here, when it is determined that the current convergence start week S is not the same as the composition ratio convergence week T (NO in step S46), the process returns to step S44, S is incremented by 1, and steps S44 to S46 are repeated.
[0089] Thereafter, when it is determined that the current convergence start week S is the same as the composition ratio convergence week T (YES in step S46), next, for each possible value of the convergence start week S (1 to T), the convergence start time calculation unit 122 calculates the error between the composition ratio of N weeks of the target product (sub-item) when the planned establishment date N weeks is changed from 1 week to (T - 1) weeks and the composition ratio β based on the cumulative sales performance of M weeks (M = 1 to 8) after N weeks, and sets S for which the sum is the minimum as the composition ratio convergence start week S of the target product (step S47). However, M = 1 represents the same week as N weeks, and M = 2 represents the week following N weeks.
[0090] FIG. 18 is a diagram for detailing step S47. From FIG. 17, for example, when the convergence start week S = 1, the composition ratio of N = 1 is 0.281 and the composition ratio β of M = 1 is 0.381, so the error is |0.281 - 0.381| = 0.100. Also, since the composition ratio β of M = 2 is 0.397, the error is |0.281 - 0.397| = 0.116.
[0091] For example, in the convergence start week S=1, the composition ratio for N=2 is 0.295, and the composition ratio β for M=1 is 0.397, so the error is |0.295-0.397|=0.102. Also, the composition ratio β for M=2 is 0.372, so the error is |0.295-0.372|=0.077.
[0092] Then, with S fixed, the value of S that minimizes the sum of the errors calculated for each combination of N and M is determined as the composition ratio convergence start week S for the target product and is stored in the composition ratio forecast information 117.
[0093] As described above, after the convergence start time point calculation unit 122 determines the composition ratio convergence start week S of the target product (child item), the process proceeds to step S5 in FIG.
[0094] Next, the composition ratio calculation unit 123, for example, in accordance with an input from a user, identifies the planned target date (N weeks starting from the sales start date of the target product) for predicting the composition ratio of the target product (step S5). Next, the composition ratio calculation unit 123 references the composition ratio convergence start week S and the composition ratio convergence week T from the composition ratio prediction information 117, and determines to which of the first to third periods the planned target date (N weeks) belongs (step S6). Then, depending on the result of this determination, the process branches to one of steps S7 to S9.
[0095] In other words, if it is determined that N weeks belongs to the first period, the composition ratio calculation unit 123 refers to the composition ratio trend information 111b of the sales performance information 111, and uses the composition ratio of the parent item of the target product (child item) after convergence as the composition ratio α and records it in the composition ratio forecast information 117 (step S7).
[0096] In addition, if it is determined that week N belongs to the second period, the composition ratio calculation unit 123 refers to the sales performance information 111, calculates the composition ratio α based on the cumulative sales performance of the parent item of the target product (child item), calculates the composition ratio β based on the cumulative sales performance of the target product (child item), calculates the composition ratio γ according to formula (1), and records it in the composition ratio prediction information 117 (step S8).
[0097] Furthermore, if it is determined that week N belongs to the third period, the composition ratio calculation unit 123 refers to the sales performance information 111, calculates the composition ratio β based on the cumulative sales performance of the target product (child item), and records it in the composition ratio prediction information 117 (step S9).
[0098] Next, the processing unit 12 determines whether or not there is any product that has not been focused on among multiple products that belong to the same product group as the target product but have different specifications (step S10).If it determines that there is a product that has not been focused on (YES in step S10), the processing returns to step S2, and the next target product is determined, and then steps S3 to S10 are repeatedly executed.
[0099] Then, all products that belong to the same product group but have different specifications are treated as target products, and steps S3 to S10 are executed. If it is determined that there are no products that have not yet been considered (NO in step S10), the process proceeds to step S11.
[0100] Next, the update coefficient calculation unit 124 calculates an update coefficient based on the sales performance information 111, the product exhibition information 113, the media publication information 114, and the sales promotion measure information 115 (step S11).
[0101] 19 is a flowchart detailing an example of the process of step S11. First, the update coefficient calculation unit 124 focuses on the sales promotion measures (discount, flyer publication, e-mail newsletter, in-store display, and media publication) in order (step S51).
[0102] Next, the update coefficient calculation unit 124 refers to the product display information 113, the media publication information 114, and the sales promotion policy information 115, extracts the implementation date of the sales promotion policy of interest for the products belonging to the target product group, and focuses on the extracted implementation dates in order (step S52). Note that, if the sales promotion policy of interest is a store display or a media publication, the date on which each was changed is regarded as the implementation date.
[0103] Next, the update coefficient calculation unit 124 refers to the sales performance information 111 and extracts the sales performance (cumulative sales performance) before and after the implementation of the promotional measure of interest for each product belonging to the target product group (step S53). If the promotional measure of interest is in-store display or media publication, the daily sales performance before and after the day when the in-store display situation or publication ratio changed is extracted. If the promotional measure of interest is discounts, flyer publication, or e-mail newsletters, the weekly sales performance before and after the implementation date is extracted.
[0104] Next, the update coefficient calculation unit 124 calculates (sales performance after promotional measures are implemented) / (sales performance before promotional measures are implemented) for each product belonging to the target product group, both for products that have undergone promotional measures and for products that have not undergone promotional measures (step S54).
[0105] Next, the update coefficient calculation unit 124 determines whether or not there are any implementation dates among the implementation dates of the sales promotion measures that have not yet been focused on (step S55), and if it is determined that there are any implementation dates that have not yet been focused on (YES in step S55), the process returns to step S52 and steps S52 to S55 are repeated.
[0106] Thereafter, if it is determined that there are no implementation dates that have not yet been focused on (NO in step S55), the update coefficient calculation unit 124 calculates the average value of the values calculated in step S54 for the products that have implemented the promotional measure among the products belonging to the target product group, for the number of implementation dates, and stores this as the update coefficient for when the promotional measure of interest has been implemented in the update coefficient information 116. In addition, the update coefficient calculation unit 124 calculates the average value of the values calculated in step S54 for the products that have not implemented the promotional measure among the products belonging to the target product group, for the number of implementation dates, and stores this as the update coefficient for when the promotional measure of interest has not been implemented (step S56).
[0107] Next, the update coefficient calculation unit 124 determines whether or not there are any promotional measures that have not yet been taken into account among the promotional measures (step S57), and if it is determined that there are any promotional measures that have not yet been taken into account (YES in step S57), the processing returns to step S51, and steps S51 to S57 are repeated.
[0108] Thereafter, if it is determined that there are no unfocused promotional measures (NO in step S57), the update coefficients for when each promotional measure is implemented and when it is not implemented have been obtained, and the process proceeds to step S12 in FIG.
[0109] Next, the composition ratio update unit 125 updates the composition ratio of the products belonging to the target product group based on the update coefficient information 116 and the composition ratio prediction information 117, and stores the updated composition ratio information 118 (step S12).
[0110] More specifically, the composition ratio of the products belonging to the target product group stored in the composition ratio prediction information 117 is multiplied by the update coefficient stored in the update coefficient information 116 in accordance with the promotional measure implementation schedule indicated by the promotional measure information 115. Furthermore, the composition ratio is updated by normalizing the values obtained by multiplying the composition ratio of the products belonging to the target product group by the update coefficients so that the sum of these values becomes 100%.
[0111] Specifically, for example, when forecasting demand for products belonging to the product group RT50 on August 9, 2021, it can be seen from the sales promotion measure information 115 (FIG. 7) that a promotional measure will be implemented for the product RT50·RA among the products with different specifications belonging to the product group RT50, and that it will not be implemented for the products RT50·LA, RT50·LB, and RT50·RB. In addition, it can be seen from the update coefficient information 116 (FIG. 18) that the adjustment coefficient when the flyer is posted is 1.8, and when it is not posted, the adjustment coefficient is 0.7. Furthermore, it can be seen from the composition ratio forecast information 117 (FIG. 9) that the composition ratio of LA for the products RT50·LA, RT50·RA, RT50·LB, and RT50·RB with different specifications belonging to the product group RT50 is 32%, 38%, 25%, and 5%. Therefore, the composition ratio after updating and normalizing product RT50·RA is {38%×1.8 / (32%×0.7+38%×1.8+25%×0.7+5%×0.7)}=61%.
[0112] Next, the demand calculation unit 126 calculates a demand forecast value for each product belonging to the target product group by multiplying the demand forecast value for each product group represented by the product group demand forecast information 119 by the updated composition ratio of each product stored in the updated composition ratio information 118 (step S13). Then, the output control unit 127 displays an output screen 200 (FIG. 20) showing the calculated demand forecast value for each product belonging to the target product group on the user terminal 30 connected via the network 2 (step S14). With this, the demand forecasting process by the demand forecasting device 10 is completed.
[0113] According to this demand forecasting process, it is possible to accurately forecast the demand for each product belonging to the same product group, taking into account the implementation of sales promotion measures.
[0114] Next, FIG. 20 shows an example of the display of the output screen 200 displayed on the user terminal 30. The output screen 200 displays the weekly demand forecast value of each product belonging to the same product group and the planned promotional measures. For example, the demand forecast values of the products RT50·LA, RT50·RA, RT50·LB, and RT50·RB, which are different specifications and belong to the product group RT50, for the week of August 9, 2021 are 80, 244, 64, and 12, respectively, and it can be confirmed that only the product RT50·RA is scheduled to be published in a flyer as a promotional measure. As described above, the user can change the implementation schedule of the promotional measures in the promotional measure information 115 (FIG. 7), and the effect of the change can be confirmed by the output screen 200.
[0115] 21 shows an example of application of the demand forecasting system 1 of this embodiment. The demand forecasting system 1 can be applied to a supply chain 2000 that is made up of a manufacturing and distribution community 2001 and a market 2002.
[0116] The manufacturing and distribution community 2001 is a group of companies that procure materials and parts, manufacture products, and transport, ship, and sell the products. For example, in the automobile industry, it is a group of companies such as parts manufacturers, finished vehicle manufacturers, and vehicle mass retailers. The market 2002 orders products from the manufacturing and distribution community 2001, and the manufacturing and distribution community 2001 delivers the products to the market 2002.
[0117] In optimizing a supply chain consisting of a manufacturing and distribution community 2001 and a market 2002, a sales plan is generated by inputting a highly accurate demand forecast for products with different specifications belonging to the same product group, and an MRP (Material Requirements Planning) system is applied in multiple stages. Inputting the sales plan into a supply and demand optimization system 2003 leads to a reduction in deviation from actual demand, making it possible to reduce inventory throughout the supply chain and prevent loss of sales opportunities.
[0118] For example, the demand forecasting system 1 makes it possible to predict in advance orders from the market 2002 as demand amounts for each product group specification required as input to the supply and demand optimization system 2003. This makes it possible for the supply and demand optimization system 2003 to appropriately issue part procurement instructions, production instructions, transportation instructions, shipping instructions, etc. to suppliers, factories, warehouses, sales companies, etc. that are the bases of each manufacturing and distribution community 2001, thereby matching supply and demand and enabling reduction of inventory assets and prevention of loss of sales opportunities.
[0119] The present invention is not limited to the above embodiment, and various modifications are possible. For example, in the present embodiment, the sales plan, the sales promotion plan, the composition ratio forecast, the demand forecast for the product group, the demand forecast for each product group specification, etc. are calculated using weekly values, but daily or monthly values may be used depending on the frequency of the sales plan.
[0120] Also, for example, the above-mentioned embodiment has been described in detail to explain the present invention in an easy-to-understand manner, and is not necessarily limited to having all of the described configurations. Also, the above-mentioned configurations, functions, processing units, processing means, etc. may be realized in hardware by designing a part or all of them, for example, in an integrated circuit. Also, the above-mentioned 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, table, file, etc. that realizes each function can be placed in a memory, a recording device such as a hard disk or SSD, or a recording medium such as an IC card, an SD card, or a DVD. Also, the control lines and information lines are shown as those that are considered necessary for explanation, and do not necessarily show all of the control lines and information lines in the product. In reality, it may be considered that almost all of the configurations are connected to each other. [Explanation of symbols]
[0121] 1 Demand forecasting system, 2 Network, 10 Demand forecasting device, 11 Memory unit, 111 Sales performance information, 111a Cumulative sales performance, 111b Composition ratio transition information, 112 Parent-child item correspondence information, 113 Product exhibition information, 114 Media publication information, 115 Sales promotion policy information, 116 Update coefficient information, 117 Composition ratio forecast information, 118 Updated composition ratio information, 119 Product group demand forecast information, 1110 Product master information, 12 Processing unit, 121 Convergence point calculation unit, 122 Convergence start point calculation unit, 123 Composition ratio calculation unit, 124···update coefficient calculation unit, 125···composition ratio update unit, 126···demand calculation unit, 127···output control unit, 13···communication unit, 20···database, 30···user terminal, 100···computer, 101···processor, 102···ROM, 103···RAM, 104···auxiliary storage device, 105···display device, 106···input device, 107···media reading device, 108···information receiving / transmitting device, 200···output screen, 2000···supply chain, 2001···manufacturing and distribution community, 2002···market, 2003···supply and demand optimization system
Claims
1. a convergence time calculation unit that refers to sales record information that indicates the sales record for each product and parent-child item correspondence information that indicates the correspondence between child items and parent items of the product, extracts the sales record of a parent item that corresponds to a target product as the child item for which demand volume is to be predicted, and calculates a convergence time T that indicates the time when the demand composition ratio of multiple products with different specifications that belong to a product group to which the target product belongs will converge, based on the sales record of the parent item; a composition ratio calculation unit that determines a calculation method using the convergence time point T as a threshold value, and calculates the composition ratio of the target product based on at least one of the sales record of the parent item and the sales record of the target product in accordance with the determined calculation method; a composition ratio update unit that updates the calculated composition ratio by using an update coefficient corresponding to a sales promotion measure; a demand calculation unit that calculates the demand for the target product by multiplying a demand prediction value for a product group to which the target product belongs by the updated composition ratio, The composition ratio calculation unit assumes that the first week to the Tth week from the sales start date of the parent item until the composition ratio convergence week T is a convergence start week S in order, and calculates the composition ratio of the target product in week N when week N, which is the planning date, is changed from week 1 to week T while the convergence start week S is fixed, When it is determined that the target product belongs to the first period from the start of sales to the composition ratio convergence start week S, the composition ratio of the parent item of the target product after convergence is set as a composition ratio α, When it is determined that the target product belongs to a second period from the composition ratio convergence start week S to the composition ratio convergence week T, a composition ratio α is calculated based on a cumulative sales record of the parent item of the target product, and a composition ratio β is calculated based on a cumulative sales record of the target product, and a composition ratio γ is calculated using the composition ratio α and the composition ratio β, When it is determined that the target product belongs to a third period after the composition ratio convergence week T, the composition ratio β is calculated based on the cumulative sales performance of the target product, For each of the possible values (1 to T) of the convergence start week S, the error between the composition ratio of the target product in week N when week N, which is the planning date, is changed from week 1 to week (T-1), and the composition ratio β based on the cumulative sales performance for M weeks (M = 1 to 8) after week N is calculated, and the S with the smallest sum is set as the composition ratio convergence start week S of the target product. With reference to a composition ratio convergence start week S and a composition ratio convergence week T, it is determined whether a planning target date for predicting a composition ratio of the target product input by a user belongs to the first period, the second period, or the third period; When it is determined that the target product belongs to the first period, the composition ratio of the parent item of the target product after convergence is set as a composition ratio α; When it is determined that the target product belongs to the second period, a composition ratio α is calculated based on a cumulative sales record of the parent item of the target product, and a composition ratio β is calculated based on a cumulative sales record of the target product, and a composition ratio γ is calculated using the composition ratio α and the composition ratio β; If it is determined that the target product belongs to the third period, the composition ratio β is calculated based on the cumulative sales performance of the target product. Demand forecasting device.
2. 2. A demand forecasting device according to claim 1, an update coefficient calculation unit that refers to sales promotion policy information that indicates a status of implementation of the sales promotion policy for the product, and calculates the update coefficient based on sales results of the target product before and after the implementation of the sales promotion policy for the target product; A demand forecasting device comprising:
3. 2. A demand forecasting device according to claim 1, The sales promotion measures include at least one of discounts, flyers, e-mail newsletters, in-store displays, and media coverage. Demand forecasting device.
4. 2. A demand forecasting device according to claim 1, The component ratio update unit updates the component ratio by multiplying the calculated component ratio by the update coefficient and normalizing the component ratio. Demand forecasting device.
5. 2. A demand forecasting device according to claim 1, an output control unit that displays a screen showing the calculated demand amount of the target product and a sales promotion measure for the target product; Demand forecasting device.
6. A demand forecasting method using a demand forecasting device, comprising: a convergence time calculation step of extracting sales results of parent items corresponding to a target product as a child item for which demand is to be predicted, by referring to sales results information indicating sales results for each product and parent-child item correspondence information indicating the correspondence between child items and parent items of the product, and calculating a convergence time T indicating the time when the demand composition ratio of multiple products with different specifications that belong to a product group to which the target product belongs will converge, based on the sales results of the parent items; a composition ratio calculation step of determining a calculation method using the convergence time point T as a threshold value, and calculating the composition ratio of the target product based on at least one of the sales record of the parent item and the sales record of the target product in accordance with the determined calculation method; a composition ratio update step of updating the calculated composition ratio by using an update coefficient according to a sales promotion measure; a demand calculation step of multiplying a demand prediction value for a product group to which the target product belongs by the updated composition ratio to calculate the demand for the target product, The composition ratio calculation step assumes that the first week to the Tth week from the sales start date of the parent item until the composition ratio convergence week T is a convergence start week S in order, and calculates the composition ratio of the target product in week N when week N, which is the planning date, is changed from week 1 to week T while the convergence start week S is fixed, When it is determined that the target product belongs to the first period from the start of sales to the composition ratio convergence start week S, the composition ratio of the parent item of the target product after convergence is set as a composition ratio α, When it is determined that the target product belongs to a second period from the composition ratio convergence start week S to the composition ratio convergence week T, a composition ratio α is calculated based on a cumulative sales record of the parent item of the target product, and a composition ratio β is calculated based on a cumulative sales record of the target product, and a composition ratio γ is calculated using the composition ratio α and the composition ratio β, When it is determined that the target product belongs to a third period after the composition ratio convergence week T, the composition ratio β is calculated based on the cumulative sales performance of the target product, For each of the possible values (1 to T) of the convergence start week S, the error between the composition ratio of the target product in week N when week N, which is the planning date, is changed from week 1 to week (T-1), and the composition ratio β based on the cumulative sales performance for M weeks (M = 1 to 8) after week N is calculated, and the S with the smallest sum is set as the composition ratio convergence start week S of the target product. With reference to a composition ratio convergence start week S and a composition ratio convergence week T, it is determined whether a planning target date for predicting a composition ratio of the target product input by a user belongs to the first period, the second period, or the third period; When it is determined that the target product belongs to the first period, the composition ratio of the parent item of the target product after convergence is set as a composition ratio α; When it is determined that the target product belongs to the second period, a composition ratio α is calculated based on a cumulative sales record of the parent item of the target product, and a composition ratio β is calculated based on a cumulative sales record of the target product, and a composition ratio γ is calculated using the composition ratio α and the composition ratio β; If it is determined that the target product belongs to the third period, the composition ratio β is calculated based on the cumulative sales performance of the target product. Demand forecasting methods.
Citation Information
Patent Citations
System for predicting number of articles to be sold
JP2001167079A
Demand predicting and sales promoting method, and its system
JP2002304508A
Device, method, and program for forecasting number of working product
JP2003233696A
Production volume calculating method, device, system and program, and recording medium
JP2004102357A
Demand forecast system, demand forecast method, and demand forecast program for data center
JP2006268529A