The present invention relates to an order quantity determination system, an order quantity determination method, and an order quantity determination program which determine order quantities of products.
Various methods for appropriately determining the order quantities of products to reduce unnecessary stock or out-of-stock condition have been proposed. For example, Patent Literature (PTL) 1 describes an inventory management system which, when goods are delivered or ordered periodically, determines the order quantity of the goods with higher accuracy. The system described in PTL 1 predicts the demand within a target prediction period which is a period from a time point of delivery in response to ordering to a time point of next delivery.
Further, the system described in PTL 1 calculates a prediction-error-addressing safety stock for absorbing a difference between the predicted demand quantity and the actual demand quantity to address the prediction error, and then calculates the order quantity, taking account of delivery delay as well, as follows: order quantity=predicted demand quantity−stock on hand−stock on order+(prediction-error-addressing safety stock+delivery-delay-addressing safety stock).
PTL 1: Japanese Patent Application Laid-Open No. 2009-187151
In the system described in PTL 1, the safety stock quantity is determined on the basis of an actual prediction error in the past, calculated from the difference between the actual demand quantity and the predicted demand quantity. However, when the error is calculated on the basis of the actual demand quantity and the predicted demand quantity, the error may include, not only the error of the prediction itself, but also an error due to a factor unanticipated at the time of prediction (such as, for example, an unexpected event).
Further, the system described in PTL 1 determines the safety stock on the basis of a predetermined service rate, safety factor, and the like when the distribution of actual predicting errors follows the normal distribution. It is preferable from the standpoint of sales that opportunity loss and abandonment loss are both restricted low. However, with the method described in PTL 1, the safety stock value would vary depending on the setting of the service rate, so it is hard to say that the opportunity loss and the abandonment loss are both restricted low.
In view of the foregoing, an object of the present invention is to provide an order quantity determination system, an order quantity determination method, and an order quantity determination program which are capable of determining the order quantity in such a way as to reduce both the opportunity loss and the abandonment loss.
An order quantity determination system according to the present invention includes: error calculation means which calculates an error in a demand quantity predicted by a prediction model, the prediction model predicting demand quantities of products, on the basis of a difference between a predicted demand quantity calculated using the prediction model and past result data that was not used in learning of the prediction model, and, from a predicted demand quantity during a covered time slot representing a delivery interval and a predicted demand quantity during a sales permitted period representing a period until abandonment, which are calculated for each product using the prediction model, calculates an error in the predicted demand quantity during the covered time slot and an error in the predicted demand quantity during the sales permitted period; safety stock quantity calculation means which calculates an occurrence probability of the predicted demand quantity during the covered time slot, for each product, from the error in the predicted demand quantity during the covered time slot, calculates an occurrence probability of the predicted demand quantity during the sales permitted period, for each product, from the error in the predicted demand quantity during the sales permitted period, and calculates a safety stock quantity from the two occurrence probabilities calculated; and order quantity calculation means which calculates an order quantity of each product, from a stock quantity anticipated at a time point of delivery, the predicted demand quantity during the covered time slot, and the safety stock quantity.
An order quantity calculation method according to the present invention includes: calculating an error in a demand quantity predicted by a prediction model, the prediction model predicting demand quantities of products, on the basis of a difference between a predicted demand quantity calculated using the prediction model and past result data that was not used in learning of the prediction model; from a predicted demand quantity during a covered time slot representing a delivery interval and a predicted demand quantity during a sales permitted period representing a period until abandonment, which are calculated for each product using the prediction model, calculating an error in the predicted demand quantity during the covered time slot and an error in the predicted demand quantity during the sales permitted period; calculating an occurrence probability of the predicted demand quantity during the covered time slot, for each product, from the error in the predicted demand quantity during the covered time slot; calculating an occurrence probability of the predicted demand quantity during the sales permitted period, for each product, from the error in the predicted demand quantity during the sales permitted period; calculating a safety stock quantity from the two occurrence probabilities calculated; and calculating an order quantity of each product, from a stock quantity anticipated at a time point of delivery, the predicted demand quantity during the covered time slot, and the safety stock quantity.
An order quantity determination program according to the present invention causes a computer to perform: error calculation processing of calculating an error in a demand quantity predicted by a prediction model, the prediction model predicting demand quantities of products, on the basis of a difference between a predicted demand quantity calculated using the prediction model and past result data that was not used in learning of the prediction model, and, from a predicted demand quantity during a covered time slot representing a delivery interval and a predicted demand quantity during a sales permitted period representing a period until abandonment, which are calculated for each product using the prediction model, calculating an error in the predicted demand quantity during the covered time slot and an error in the predicted demand quantity during the sales permitted period; safety stock quantity calculation processing of calculating an occurrence probability of the predicted demand quantity during the covered time slot, for each product, from the error in the predicted demand quantity during the covered time slot, calculating an occurrence probability of the predicted demand quantity during the sales permitted period, for each product, from the error in the predicted demand quantity during the sales permitted period, and calculating a safety stock quantity from the two occurrence probabilities calculated; and order quantity calculation processing of calculating an order quantity of each product, from a stock quantity anticipated at a time point of delivery, the predicted demand quantity during the covered time slot, and the safety stock quantity.
According to the present invention, it is possible to determine the order quantity in such a way as to reduce both the opportunity loss and the abandonment loss.
An embodiment of the present invention will be described below with reference to the drawings.
A method for calculating the order quantity in the present invention will be outlined first.
In the present embodiment, the order quantity E is determined at the time point of ordering, taking account of the stock B anticipated at the time point of delivery as well as a predicted demand quantity C from the ordering until the delivery and a safety stock quantity D for absorbing variability of the demand prediction.
The storage unit 20 stores masters for use in various processing, past result data on product sales and the like, a prediction model for use in prediction, and others. The storage unit 20 is implemented by, for example, a magnetic disk.
The predicted demand quantity calculation means 11 calculates a predicted demand quantity for each product. The predicted demand quantity calculation means 11 in the present embodiment calculates a predicted demand quantity during a covered time slot and a predicted demand quantity during a sales permitted period for each product.
The covered time slot refers to a period from a time point of delivery to a time point of next delivery, or, a delivery interval. The sales permitted period refers to a period from when a product is delivered until when the product is abandoned, or, a period in which the product is available for sale. In the example shown in
Specifically, the predicted demand quantity calculation means 11 uses a prediction model which predicts demand quantities, to calculate the respective predicted demand quantities. The prediction model used is, for example, a prediction model that predicts a demand quantity on a product category basis (predicted category-wise demand quantity) by day. In this case, the predicted demand quantity calculation means 11 firstly adds up the latest sales results in a category unit, and calculates a sales composition ratio by hour of day. Then, the predicted demand quantity calculation means 11 may multiply the daily predicted result by the calculated sales composition ratio as an hourly distribution rate, to calculate the predicted category-wise demand quantity by hour.
In this case, the predicted demand quantity calculation means 11 further calculates a predicted demand quantity of each single product, from the predicted category-wise demand quantity calculated by hour. For example, the predicted demand quantity calculation means 11 may proportionally distribute the predicted category-wise demand quantity on the basis of the past sales results (sales composition ratios) of the products, to calculate the predicted demand quantity for each single product. Moreover, in order to increase the accuracy of the predicted demand quantity for each single product, the predicted demand quantity calculation means 11 may set only the product(s) for which there remains a stock at the time point of ordering, as the target(s) of distribution.
The description has been given in the present embodiment of the case where the predicted demand quantity calculation means 11 calculates a predicted demand quantity for each single product from the predicted category-wise demand quantity calculated by hour. Alternatively, the safety stock quantity calculation means 14 (described later) may calculate the predicted demand quantity for each single product.
When the predicted demand quantity during the covered time slot and the predicted demand quantity during the sales permitted period have already been calculated for each product, the order quantity determination system 10 does not need to have the predicted demand quantity calculation means 11. In this case, the predicted demand quantity during the covered time slot and the predicted demand quantity during the sales permitted period may be stored in the storage unit 20, for example.
The stock quantity calculation means 12 calculates a stock quantity anticipated at the time point of delivery. In the example shown in
The stock quantity calculation means 12 may acquire the scheduled delivery quantity from, for example, a master in the storage unit 20 that stores the quantities already ordered. Further, the stock quantity calculation means 12 may use a prediction engine that predicts a total number of sales of the product in a day, to calculate the predicted demand quantity from the ratio of the time from the ordering to the delivery.
It should be noted that the stock quantity calculation means 12 may calculate the stock quantity at the time point of ordering, from the actual sales quantity and the actual delivery quantity from a certain time point (for example, midnight) the stock quantity at which can be confirmed. Such computation can eliminate the need to actually count the number of pieces in stock.
The error calculation means 13 calculates an error in the demand quantity predicted by a prediction model. Specifically, the error calculation means 13 calculates an error in the prediction model by day, from the predicted demand quantity during the covered time slot and the predicted demand quantity during the sales permitted period calculated for each product. Here, the target prediction model is a prediction model that predicts the demand quantity on a product basis or on a product category basis, which is for example the prediction model used by the predicted demand quantity calculation means 11 to predict the demand quantities. In the case where the order quantity determination system does not include the predicted demand quantity calculation means 11, this prediction model is the one used to derive the predicted demand quantity during the covered time slot and the predicted demand quantity during the sales permitted period.
In the present embodiment, the error calculation means 13 does not calculate the error by comparing the actual demand quantity and the predicted demand quantity as described in PTL 1, for example; it calculates the error in the demand quantity on the basis of the past result data that is available at the time point when a prediction model is generated.
Specifically, the past result data is divided into a learning section and a determination section, and the data in the learning section is used to generate a prediction model. Thereafter, the data in the determination section is used to verify the accuracy (validity) of the prediction model. The error calculation means 13 uses the verified accuracy (i.e. an error rate representing the discrepancy between the predicted result based on the data in the determination section and the actual result) as the accuracy of the prediction model. In this manner, the error calculation means 13 in the present embodiment calculates the error by using a part of the past result data, existing at the time of learning of the prediction model, that was not used in the learning of the prediction model.
Firstly, the error calculation means 13 uses the data in the determination section to calculate an error rate by day. The error rate is calculated, for example, by the following Expression 1. It should be noted that the error calculation means 13 may exclude the data for the day on which sales result (+opportunity loss) was “0” from the target of computation. Further, when it is possible to obtain the opportunity loss, the error calculation means 13 may utilize the value obtained by adding the opportunity loss to the sales result.
Error rate=(predicted demand quantity in the determination section−sales result (+opportunity loss) in the determination section)/sales result (+opportunity loss) in the determination section (Expression 1)
The error calculation means 13 calculates an average of the error rates calculated by day. That is, the error calculation means 13 calculates the error rate on average of the predicted demands for each category. The error rate average is calculated, for example, by the following Expression 2.
Error rate average=(Σ error rate)/the number of days in the determination section (Expression 2)
Further, the error calculation means 13 calculates a standard deviation of the error rate. That is, the error calculation means 13 calculates the degree of dispersion of the predicted demand quantity from the average. The error rate standard deviation is calculated, for example, by the following Expression 3.
Error rate standard deviation=(Σ(sales result (+opportunity loss) in the determination section−error rate average)/the number of days in the determination section ̂1/2) (Expression 3)
It should be noted that the error rate average and the error rate standard deviation are indices concerning a prediction model, so they are calculated at the time of updating the prediction model.
Next, the error calculation means 13 calculates an error in the predicted demand quantity during the covered time slot, on the basis of the calculated error rate average and error rate standard deviation of the prediction model. Specifically, the error calculation means 13 calculates a predicted demand quantity average and a predicted demand quantity standard deviation during the covered time slot.
The predicted demand quantity average σ1 during the covered time slot is calculated, for example, by the following Expression 4, and the predicted demand quantity standard deviation μ1 is calculated, for example, by the following Expression 5.
Predicted demand quantity average (σ1) during the covered time slot=predicted demand quantity during the covered time slot+predicted demand quantity during the covered time slot×error rate average (Expression 4)
Predicted demand quantity standard deviation (μ1) during the covered time slot=predicted demand quantity average during the covered time slot×error rate standard deviation (Expression 5)
For example, assume that the error rate average=−5%, the error rate standard deviation=0.24, and the predicted demand quantity during the covered time slot is 40. In this case, the calculations are as follows:
Predicted demand quantity average (σ1) during the covered time slot=40+40×(−5/100)=38
Predicted demand quantity standard deviation (μ1) during the covered time slot=38×0.24=9.2
Similarly, the error calculation means 13 calculates an error in the predicted demand quantity during the sales permitted period, on the basis of the calculated error rate average and error rate standard deviation of the prediction model. Specifically, the error calculation means 13 calculates a predicted demand quantity average and a predicted demand quantity standard deviation during the sales permitted period.
The predicted demand quantity average σ2 during the sales permitted period is calculated, for example, by the following Expression 6, and the predicted demand quantity standard deviation μ2 is calculated, for example, by the following Expression 7.
Predicted demand quantity average (σ2) during the sales permitted period=predicted demand quantity during the sales permitted period+predicted demand quantity during the sales permitted period×error rate average (Expression 6)
Predicted demand quantity standard deviation (μ2) during the sales permitted period=predicted demand quantity average during the sales permitted period×error rate standard deviation (Expression 7)
For example, assume that the error rate average=−5%, the error rate standard deviation=0.24, and the predicted demand quantity during the sales permitted period is 60. In this case, the calculations are as follows:
Predicted demand quantity average (σ2) during the sales permitted period=60+60×(−5/100)=57
Predicted demand quantity standard deviation (μ2) during the sales permitted period=57×0.24=13.8
The safety stock quantity calculation means 14 uses the calculated error by day to calculate the safety stock quantity for each product. In the example shown in
Firstly, the safety stock quantity calculation means 14 calculates an occurrence probability of the predicted demand quantity during the covered time slot, from the predicted demand quantity average and the predicted demand quantity standard deviation during the covered time slot. Specifically, the safety stock quantity calculation means 14 creates a normal distribution indicating the occurrence probability for each product, from the predicted demand quantity average and the predicted demand quantity standard deviation during the covered time slot.
For example, even when the predicted demand quantity during the covered time slot is 40, there is a probability that the product sells 40 or more pieces (specifically, the portion to the right of the broken line in
Taking account of the safety stock quantity to address such variability of the demand leads to a decreased height of the curve illustrated in
Similarly, the safety stock quantity calculation means 14 calculates an occurrence probability of the predicted demand quantity during the sales permitted period, from the predicted demand quantity average and the predicted demand quantity standard deviation during the sales permitted period. Specifically, the safety stock quantity calculation means 14 creates a normal distribution indicating the occurrence probability for each product, from the predicted demand quantity average and the predicted demand quantity standard deviation during the sales permitted period.
As in the case of the prediction for the covered time slot, even when the predicted demand quantity during the sales permitted period is 60, there is a probability that the product sells only 60 pieces or less (specifically, the portion to the left of the broken line in
Taking account of the safety stock quantity to address such variability of the demand as well leads to a decreased height of the curve illustrated in
It should be noted that, as different products have different sales permitted periods, the safety stock quantity calculation means 14 calculates the occurrence probability of the predicted demand quantity during the sales permitted period for each product. The safety stock quantity calculation means 14 thus calculates the occurrence probability of the predicted demand quantity during the covered time slot and the occurrence probability of the predicted demand quantity during the sales permitted period, for each product, from the calculated error by day.
As explained before, if the probability of occurrence of stockout and the probability of occurrence of abandonment can both be lowered, the opportunity loss and the abandonment loss can both be decreased. Thus, the safety stock quantity calculation means 14 calculates an appropriate safety stock quantity on the basis of the two calculated occurrence probabilities (the occurrence probability of the predicted demand quantity during the covered time slot and the occurrence probability of the predicted demand quantity during the sales permitted period).
A description will be given of specific methods of calculating the safety stock quantity on the basis of the two occurrence probabilities. The first method of calculating the safety stock quantity uses the predicted demand quantity at the point of intersection of two normal distributions as the predicted demand quantity to be added to the stock quantity.
The point of intersection of these two normal distributions can be calculated by the following Expression 8. In the Expression 8, “x” represents [predicted demand quantity+safety stock quantity] during the covered time slot.
An expected value of the opportunity loss and that of the abandonment loss are each calculated as a sum of products of the predicted demand quantity and the occurrence probability. In other words, the sum of products of the predicted demand quantity and the occurrence probability represents the integral (area) of the normal distribution corresponding to the range of the predicted demand quantity.
When the point of intersection of the two normal distributions is used for calculation of the safety stock quantity, it is possible to minimize the sum of the expected values of the opportunity loss and the abandonment loss (i.e. the sum of the areas of the two), although the expected values of the opportunity loss and the abandonment loss differ in magnitude from each other. In this manner, the safety stock quantity calculation means 14 may calculate the safety stock quantity so as to minimize the sum of the expected values of the opportunity loss and the abandonment loss.
Specifically, the safety stock quantity is calculated as a difference between the predicted demand quantity at the point of intersection and the predicted demand quantity during the covered time slot (safety stock quantity=predicted demand quantity at the point of intersection−predicted demand quantity during the covered time slot). For example, assume that the calculation result of x=48 is obtained in the example shown in
The second method of calculating the safety stock quantity uses a predicted demand quantity for which the two expected values become equal in magnitude to each other as the predicted demand quantity to be added to the stock quantity.
Further, the vertical bold line illustrated in
The predicted demand quantity for which the two expected values become equal in magnitude can be calculated by the following Expression 9. In the Expression 9 as well, “x” represents [predicted demand quantity+safety stock quantity] during the covered time slot.
When the predicted demand quantity for which the two expected values become equal in magnitude is used for calculation of the safety stock quantity, it is possible to make the magnitudes of the expected values of the opportunity loss and the abandonment loss equal to each other, although the sum of the expected values of the opportunity loss and the abandonment loss (i.e. the sum of the two areas) is not minimized. In this manner, the safety stock quantity calculation means 14 may calculate the safety stock quantity so as to make the expected values of the opportunity loss and the abandonment loss equal to each other. As in the first method, the safety stock quantity is calculated as follows: safety stock quantity=predicted demand quantity at the point of intersection−predicted demand quantity during the covered time slot.
Which one of the first and second methods to use for calculating the safety stock quantity may be determined in advance in accordance with the product category, user intention, and the like. Further, the safety stock quantity calculation means 14 may adjust the safety stock quantity by multiplying the safety stock quantity by a preset adjustment rate in preparation for abrupt change in sales quantity.
The order quantity calculation means 15 calculates an order quantity for each product, from a stock quantity anticipated at the time point of delivery, the predicted demand quantity during the covered time slot, and the safety stock quantity. Specifically, the order quantity calculation means 15 may add up the stock quantity anticipated at the time point of delivery and the safety stock quantity and subtract therefrom the stock quantity anticipated at the time point of delivery, to obtain the resultant value as the order quantity. In the example shown in
The predicted demand quantity calculation means 11, the stock quantity calculation means 12, the error calculation means 13, the safety stock quantity calculation means 14, and the order quantity calculation means 15 are implemented by the CPU of a computer that operates in accordance with a program (order quantity determination program). For example, the program may be stored in the storage unit 20, and the CPU may read the program and operate as the predicted demand quantity calculation means 11, the stock quantity calculation means 12, the error calculation means 13, the safety stock quantity calculation means 14, and the order quantity calculation means 15 in accordance with the program.
Alternatively, the predicted demand quantity calculation means 11, the stock quantity calculation means 12, the error calculation means 13, the safety stock quantity calculation means 14, and the order quantity calculation means 15 may each be implemented by dedicated hardware. Still alternatively, the order quantity determination system according to the present invention may be constituted by two or more physically separate devices connected in a wired or wireless manner.
A description will now be given of the operation of the order quantity determination system in the present embodiment.
The error calculation means 13 uses past result data to calculate an error in the demand quantity predicted by the prediction model (step S13). Specifically, the error calculation means 13 calculates an error rate average and an error rate standard deviation of the prediction model as the errors in the prediction model. Next, the error calculation means 13 calculates, from a predicted demand quantity during a covered time slot and a predicted demand quantity during a sales permitted period, an error in the predicted demand quantity during the covered time slot and an error in the predicted demand quantity during the sales permitted period (step S14). Specifically, the error calculation means 13 calculates a predicted demand quantity average and a predicted demand quantity standard deviation for each of the covered time slot and the sales permitted period.
The safety stock quantity calculation means 14 calculates an occurrence probability of the predicted demand quantity during the covered time slot, for each product, from the error in the predicted demand quantity during the covered time slot (step S15). The safety stock quantity calculation means 14 further calculates an occurrence probability of the predicted demand quantity during the sales permitted period, for each product, from the error in the predicted demand quantity during the sales permitted period (step S16). The safety stock quantity calculation means 14 then calculates a safety stock quantity from the two calculated occurrence probabilities (step S17).
The order quantity calculation means 15 calculates an order quantity for each product, from a stock quantity anticipated at the time point of delivery, the predicted demand quantity during the covered time slot, and the safety stock quantity (step S18).
As described above, in the present embodiment, the error calculation means 13 calculates an error in the demand quantity predicted by a prediction model, on the basis of a difference between the predicted demand quantity calculated using the prediction model and the past result data that was not used in learning of the prediction model. Further, from the predicted demand quantity during the covered time slot and the predicted demand quantity during the sales permitted period calculated for each product using the prediction model, the error calculation means 13 calculates an error in the predicted demand quantity during the covered time slot and an error in the predicted demand quantity during the sales permitted period. The safety stock quantity calculation means 14 calculates an occurrence probability of the predicted demand quantity during the covered time slot, for each product, from the error in the predicted demand quantity during the covered time slot, calculates an occurrence probability of the predicted demand quantity during the sales permitted period, for each product, from the error in the predicted demand quantity during the sales permitted period, and calculates a safety stock quantity from the two calculated occurrence probabilities. Then, the order quantity calculation means 15 calculates an order quantity for each product, from a stock quantity anticipated at the time point of delivery, the predicted demand quantity during the covered time slot, and the safety stock quantity. It is thus possible to determine the order quantity in such a way as to reduce both the opportunity loss and the abandonment loss.
The present invention will now be outlined.
With this configuration, it is possible to determine the order quantity in such a way as to reduce both the opportunity loss and the abandonment loss.
Further, the safety stock quantity calculation means 82 may calculate an expected value of opportunity loss, which is a sum of multiplications of any predicted demand quantity not less than a quantity obtained by summing the predicted demand quantity during the covered time slot and the safety stock quantity by the occurrence probability of that predicted demand quantity, and an expected value of abandonment loss, which is a sum of multiplications of any predicted demand quantity not more than a quantity obtained by summing the predicted demand quantity during the sales permitted period and the safety stock quantity by the occurrence probability of that predicted demand quantity, and calculate the safety stock quantity by using a predicted demand quantity for which the expected value of the opportunity loss and the expected value of the abandonment loss coincide with each other.
With this configuration, the occurrence probabilities of the opportunity loss and the abandonment loss can be made equal to each other, and accordingly, the probabilities of occurrence of the losses themselves can be restricted low.
Alternatively, the safety stock quantity calculation means 82 may calculate the safety stock quantity by using a predicted demand quantity for which the occurrence probability of the predicted demand quantity during the covered time slot and the occurrence probability of the predicted demand quantity during the sales permitted period coincide with each other.
With this configuration, the sum of the expected values of the opportunity loss and the abandonment loss can be minimized, and accordingly, the losses that may occur can be restricted low.
Further, the error calculation means 81 may calculate an error rate average and an error rate standard deviation of the prediction model as errors of that prediction model, and calculate the errors in the predicted demand quantities during the covered time slot and during the sales permitted period on the basis of the error rate average and the error rate standard deviation calculated.
At this time, the error calculation means 81 may calculate a predicted demand quantity average and a predicted demand quantity standard deviation for each of the covered time slot and the sales permitted period, on the basis of the error rate average and the error rate standard deviation of the prediction model.
Then, the safety stock quantity calculation means 82 may create, for each product, normal distributions indicating the occurrence probabilities of the predicted demand quantities during the covered time slot and during the sales permitted period, from the predicted demand quantity averages and the predicted demand quantity standard deviations during the covered time slot and during the sales permitted period.
The order quantity determination system 80 may further include predicted demand quantity calculation means (for example, predicted demand quantity calculation means 11) which calculates a predicted demand quantity by day for each category, by using a prediction model that predicts, by day, a predicted category-wise demand quantity which is a demand quantity on a product category basis. The predicted demand quantity calculation means may proportionally distribute the predicted category-wise demand quantity on the basis of a past sales composition ratio and an hourly sales composition ratio of each product, to calculate a predicted demand quantity of each single product by hour. The error calculation means 81 may calculate, from the predicted demand quantity of each single product calculated by hour, corresponding predicted demand quantities during the covered time slot and during the sales permitted period.
The order quantity determination system 80 may further include stock quantity calculation means (for example, stock quantity calculation means 12) which calculates the stock quantity anticipated at the time point of delivery, from a stock quantity at a time point of ordering.
A part of or all of the above embodiment may also be described as, but not limited to, the following appendices.
(Supplementary note 1) An order quantity determination system comprising: error calculation means which calculates an error in a demand quantity predicted by a prediction model, the prediction model predicting demand quantities of products, on the basis of a difference between a predicted demand quantity calculated using the prediction model and past result data that was not used in learning of the prediction model, and, from a predicted demand quantity during a covered time slot representing a delivery interval and a predicted demand quantity during a sales permitted period representing a period until abandonment, which are calculated for each product using the prediction model, calculates an error in the predicted demand quantity during the covered time slot and an error in the predicted demand quantity during the sales permitted period; safety stock quantity calculation means which calculates an occurrence probability of the predicted demand quantity during the covered time slot, for each product, from the error in the predicted demand quantity during the covered time slot, calculates an occurrence probability of the predicted demand quantity during the sales permitted period, for each product, from the error in the predicted demand quantity during the sales permitted period, and calculates a safety stock quantity from the two occurrence probabilities calculated; and order quantity calculation means which calculates an order quantity of each product, from a stock quantity anticipated at a time point of delivery, the predicted demand quantity during the covered time slot, and the safety stock quantity.
(Supplementary note 2) The order quantity determination system according to Supplementary note 1, wherein the safety stock quantity calculation means calculates an expected value of opportunity loss which is a sum of multiplications of any predicted demand quantity not less than a quantity obtained by summing the predicted demand quantity during the covered time slot and the safety stock quantity by the occurrence probability of that predicted demand quantity, and an expected value of abandonment loss which is a sum of multiplications of any predicted demand quantity not more than a quantity obtained by summing the predicted demand quantity during the sales permitted period and the safety stock quantity by the occurrence probability of that predicted demand quantity, and calculates the safety stock quantity by using a predicted demand quantity for which the expected value of the opportunity loss and the expected value of the abandonment loss coincide with each other.
(Supplementary note 3) The order quantity determination system according to Supplementary note 1, wherein the safety stock quantity calculation means calculates the safety stock quantity by using a predicted demand quantity for which the occurrence probability of the predicted demand quantity during the covered time slot and the occurrence probability of the predicted demand quantity during the sales permitted period coincide with each other.
(Supplementary note 4) The order quantity determination system according to any one of Appendices 1 to 3, wherein the error calculation means calculates an error rate average and an error rate standard deviation of the prediction model as errors of the prediction model, and calculates each of the errors in the predicted demand quantities during the covered time slot and during the sales permitted period on the basis of the error rate average and the error rate standard deviation calculated.
(Supplementary note 5) The order quantity determination system according to Supplementary note 4, wherein the error calculation means calculates a predicted demand quantity average and a predicted demand quantity standard deviation for each of the covered time slot and the sales permitted period, on the basis of the error rate average and the error rate standard deviation of the prediction model.
(Supplementary note 6) The order quantity determination system according to Supplementary note 5, wherein the safety stock quantity calculation means creates, for each product, normal distributions indicating the occurrence probabilities of the predicted demand quantities during the covered time slot and during the sales permitted period, from the predicted demand quantity averages and the predicted demand quantity standard deviations during the covered time slot and during the sales permitted period.
(Supplementary note 7) The order quantity determination system according to any one of Appendices 1 to 6, comprising: predicted demand quantity calculation means which calculates a predicted demand quantity by day for each category by using a prediction model that predicts by day a predicted category-wise demand quantity which is a demand quantity on a product category basis, wherein the predicted demand quantity calculation means proportionally distributes the predicted category-wise demand quantity on the basis of a past sales composition ratio and an hourly sales composition ratio of each product, to calculate a predicted demand quantity of each single product by hour, and the error calculation means calculates, from the predicted demand quantity of each single product calculated by hour, corresponding predicted demand quantities during the covered time slot and during the sales permitted period.
(Supplementary note 8) The order quantity determination system according to any one of Appendices 1 to 7, comprising: stock quantity calculation means which calculates the stock quantity anticipated at the time point of delivery from a stock quantity at a time point of ordering.
(Supplementary note 9) An order quantity calculation method comprising: calculating an error in a demand quantity predicted by a prediction model, the prediction model predicting demand quantities of products, on the basis of a difference between a predicted demand quantity calculated using the prediction model and past result data that was not used in learning of the prediction model; from a predicted demand quantity during a covered time slot representing a delivery interval and a predicted demand quantity during a sales permitted period representing a period until abandonment, which are calculated for each product using the prediction model, calculating an error in the predicted demand quantity during the covered time slot and an error in the predicted demand quantity during the sales permitted period; calculating an occurrence probability of the predicted demand quantity during the covered time slot, for each product, from the error in the predicted demand quantity during the covered time slot; calculating an occurrence probability of the predicted demand quantity during the sales permitted period, for each product, from the error in the predicted demand quantity during the sales permitted period; calculating a safety stock quantity from the two occurrence probabilities calculated; and calculating an order quantity of each product, from a stock quantity anticipated at a time point of delivery, the predicted demand quantity during the covered time slot, and the safety stock quantity.
(Supplementary note 10) The order quantity determination method according to Supplementary note 9, comprising: calculating an expected value of opportunity loss which is a sum of multiplications of any predicted demand quantity not less than a quantity obtained by summing the predicted demand quantity during the covered time slot and the safety stock quantity by the occurrence probability of that predicted demand quantity, and an expected value of abandonment loss which is a sum of multiplications of any predicted demand quantity not more than a quantity obtained by summing the predicted demand quantity during the sales permitted period and the safety stock quantity by the occurrence probability of that predicted demand quantity; and calculating the safety stock quantity by using a predicted demand quantity for which the expected value of the opportunity loss and the expected value of the abandonment loss coincide with each other.
(Supplementary note 11) The order quantity determination method according to Supplementary note 9, comprising: calculating the safety stock quantity by using a predicted demand quantity for which the occurrence probability of the predicted demand quantity during the covered time slot and the occurrence probability of the predicted demand quantity during the sales permitted period coincide with each other.
(Supplementary note 12) An order quantity determination program for causing a computer to perform: error calculation processing of calculating an error in a demand quantity predicted by a prediction model, the prediction model predicting demand quantities of products, on the basis of a difference between a predicted demand quantity calculated using the prediction model and past result data that was not used in learning of the prediction model, and, from a predicted demand quantity during a covered time slot representing a delivery interval and a predicted demand quantity during a sales permitted period representing a period until abandonment, which are calculated for each product using the prediction model, calculating an error in the predicted demand quantity during the covered time slot and an error in the predicted demand quantity during the sales permitted period; safety stock quantity calculation processing of calculating an occurrence probability of the predicted demand quantity during the covered time slot, for each product, from the error in the predicted demand quantity during the covered time slot, calculating an occurrence probability of the predicted demand quantity during the sales permitted period, for each product, from the error in the predicted demand quantity during the sales permitted period, and calculating a safety stock quantity from the two occurrence probabilities calculated; and order quantity calculation processing of calculating an order quantity of each product, from a stock quantity anticipated at a time point of delivery, the predicted demand quantity during the covered time slot, and the safety stock quantity.
(Supplementary note 13) The order quantity determination program according to Supplementary note 12, causing the computer, in the safety stock quantity calculation processing, to calculate an expected value of opportunity loss which is a sum of multiplications of any predicted demand quantity not less than a quantity obtained by summing the predicted demand quantity during the covered time slot and the safety stock quantity by the occurrence probability of that predicted demand quantity, and an expected value of abandonment loss which is a sum of multiplications of any predicted demand quantity not more than a quantity obtained by summing the predicted demand quantity during the sales permitted period and the safety stock quantity by the occurrence probability of that predicted demand quantity, and calculate the safety stock quantity by using a predicted demand quantity for which the expected value of the opportunity loss and the expected value of the abandonment loss coincide with each other.
(Supplementary note 14) The order quantity determination program according to Supplementary note 12, causing the computer, in the safety stock quantity calculation processing, to calculate the safety stock quantity by using a predicted demand quantity for which the occurrence probability of the predicted demand quantity during the covered time slot and the occurrence probability of the predicted demand quantity during the sales permitted period coincide with each other.
While the present invention has been described with reference to the embodiment and examples, the present invention is not limited to the embodiment or examples above. Various modifications understandable by those skilled in the art can be made to the configurations and details of the present invention within the scope of the present invention.
This application claims priority based on Japanese Patent Application No. 2016-172529 filed on Sep. 5, 2016, the disclosure of which is incorporated herein in its entirety.
10 order quantity determination system
11 predicted demand quantity calculation means
12 stock quantity calculation means
13 error calculation means
14 safety stock quantity calculation means
15 order quantity calculation means
20 storage unit
Number | Date | Country | Kind |
---|---|---|---|
2016-172529 | Sep 2016 | JP | national |
Filing Document | Filing Date | Country | Kind |
---|---|---|---|
PCT/JP2017/026841 | 7/25/2017 | WO | 00 |