Safety stock calculation system

The system addresses the challenge of non-normal product demand by using flexible reference periods and simulation to accurately determine safety stock quantities, minimizing stockout risks.

JP7596176B2Active Publication Date: 2024-12-09TISI CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
JP2021028120
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2021-02-25
Publication Date
2024-12-09
Estimated Expiration
2041-02-25

AI Technical Summary

Technical Problem

Conventional methods for calculating safety stock quantities are inadequate when product demand does not follow a normal distribution, leading to inaccurate safety stock calculations.

Method used

A system that calculates safety stock quantities by utilizing multiple reference periods and a demand variation coefficient, allowing for flexible input of warehousing cycles and tolerance rates, and includes simulation and alert mechanisms to verify the appropriateness of calculated stock levels.

Benefits of technology

Enables accurate safety stock calculations even when product demand is not normally distributed, ensuring appropriate stock levels and reducing the risk of stockouts.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007596176000001
    Figure 0007596176000001
  • Figure 0007596176000002
    Figure 0007596176000002
  • Figure 0007596176000003
    Figure 0007596176000003
Patent Text Reader

Abstract

To provide a safe stock quantity calculation system capable of appropriately calculating a safe stock quantity even when actual sales (the number of deliveries) do not follow a normal distribution.SOLUTION: A safe stock quantity calculation system 1 calculates the average of sales results from a first reference time to a first reference period, and calculates a ratio of sales results in a target time with respect to the sales results in the target time of deviation from the average as a deviation rate in the target time. Next, the safe stock quantity calculation system calculates a demand fluctuation coefficient based on a standard deviation of the deviation rate from a second reference time to a second reference period, and then calculates a reference safe stock quantity based on the product of the demand fluctuation coefficient, the average of sales results from a third reference time to a third reference period and a warehouse cycle period. And the safe stock quantity calculation system calculates a safe stock quantity in the target time based on the product of the reference safe stock quantity and the ratio of the average of sales results from the first reference time to the first reference period with respect to the average of sales results from the third reference time to the third reference period.SELECTED DRAWING: Figure 1
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to a system for calculating safety stock quantity. [Background technology]

[0002] The optimum inventory level is the minimum quantity at which the inventory level always exceeds the number of items shipped at the time of sale. The inventory level must exceed the total number of items shipped during the period until the next arrival (inventory cycle). However, the number of items shipped is not constant but fluctuates due to factors such as fluctuations in product demand. In order to avoid the risk of stockouts (the risk that the inventory level at the time of sale will be lower than the number of items shipped) that arises from these fluctuations in the number of items shipped, it is necessary to set the inventory level above the amount expected to be shipped until the next arrival (average number of items shipped during the period); this is known as the "safety stock level."

[0003] Conventionally, a system for predicting safety stock quantity has been proposed (for example, see Patent Document 1). Conventionally, safety stock quantity has generally been calculated using the following formula. Safety stock quantity = Safety factor x Standard deviation of average number of shipments over the period x Square root of receipt cycle Here, the safety coefficient is a coefficient calculated based on the stockout tolerance rate, which is a value set based on the number of stockouts that can occur in 100 shipments (for example, if five stockouts are allowed, the stockout tolerance rate is 5%). [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Patent No. 5968513 Summary of the Invention [Problem to be solved by the invention]

[0005] However, while the conventional method for calculating safety stock is effective when the shipping volume is normally distributed, there is a problem in that the safety stock cannot be calculated appropriately when the shipping volume is not normally distributed. However, in many cases, product demand fluctuates, and the shipping volume rarely follows a normal distribution.

[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a safety stock quantity calculation system that can appropriately calculate safety stock quantity even when sales performance (shipment number) does not follow a normal distribution. [Means for solving the problem]

[0007] The safety stock number calculation system of the present invention includes a storage unit in which information on past sales performance and inventory performance is stored for each predetermined period, a target period for calculating safety stock number, a first reference period and a first reference period referred to when calculating past sales performance for calculating the safety stock number for the target period, a second reference period and a second reference period referred to when calculating a demand variation coefficient for calculating the safety stock number for the target period, a third reference period and a third reference period referred to when calculating a base safety stock number for calculating the safety stock number for the target period, and an input unit for inputting a warehousing cycle period, an average calculation unit for calculating an average of sales performance from the first reference period to the first reference period, and a demand variation coefficient calculation unit which calculates the demand variation coefficient based on the standard deviation of the deviation rate from the second reference time to the second reference period; a standard safety stock quantity calculation unit which calculates the standard safety stock quantity based on the product of the demand variation coefficient, the average of the sales performance from the third reference time to the third reference period, and the warehousing cycle period; and a safety stock quantity calculation unit which calculates the safety stock quantity for the target time based on the product of the standard safety stock quantity and the ratio of the average of the sales performance from the first reference time to the first reference period to the average of the sales performance from the third reference time to the third reference period.

[0008] According to this configuration, the reference time and reference period (first reference time and first reference period) used to calculate the past sales performance for calculating the safety stock quantity for the target time, the reference time and reference period (second reference time and second reference period) used to calculate the demand fluctuation coefficient, the reference time and reference period (third reference time and third reference period) used to calculate the standard safety stock quantity, and the inventory cycle period can be changed as desired. This makes it possible to find the optimal value of the demand fluctuation coefficient (demand fluctuation tendency), and to properly calculate the safety stock quantity even if the sales performance (shipment quantity) is not normally distributed.

[0009] In addition, in the safety stock quantity calculation system of the present invention, the input unit receives a fourth reference time and a fourth reference period for simulating an inventory quantity, and a stock-out tolerance rate that defines an upper limit of a tolerable range of a stock-out rate, and the safety stock quantity calculation system may include an inventory simulation number calculation unit that calculates an inventory simulation number for a target period based on a difference between the safety stock quantity for the target period and the inventory actual value for the period preceding the target period, an inventory simulation number calculation unit that calculates an inventory simulation number for a target period based on a sum of a difference between sales actual value for the target period from the inventory actual value for the period preceding the target period and the inventory simulation number, a stock-out rate calculation unit that calculates a ratio of a total number of stock-outs from the fourth reference time to the fourth reference period to a total sales actual value from the fourth reference time to the fourth reference period as a stock-out rate, and a determination unit that determines whether the stock-out rate is within a tolerance range defined by the stock-out tolerance rate.

[0010] According to this configuration, it is possible to determine whether the stock-out rate calculated by simulating the stock quantity using the calculated safety stock quantity is within an allowable range. This makes it easy to verify whether the calculated safety stock quantity (the reference time and reference period inputted to calculate the safety stock quantity) are appropriate in terms of stock-out risk.

[0011] In addition, the safe stock quantity calculation system of the present invention may include a second determination unit that determines whether the inventory simulation quantity is greater than the actual inventory quantity from the fourth reference time to the fourth reference period, and an alert output unit that outputs an alert when the second determination unit determines that the inventory simulation quantity is greater than the actual inventory quantity.

[0012] According to this configuration, if the inventory simulation number calculated by simulating the inventory number using the calculated safety stock number is greater than the inventory performance, an alert is output. This makes it easy to know whether the calculated safety stock number (the reference time and reference period input to calculate the safety stock number) is appropriate from the perspective of the optimal inventory number.

[0013] The method of the present invention is a method executed by a safety stock number calculation system, in which information on past sales results and inventory results is stored for each predetermined period, and a target period for calculating a safety stock number, a first reference period and a first reference period referred to when calculating past sales results for calculating a safety stock number for the target period, a second reference period and a second reference period referred to when calculating a demand variation coefficient for calculating a safety stock number for the target period, a third reference period and a third reference period referred to when calculating a standard safety stock number for calculating a safety stock number for the target period, and a warehousing cycle period are inputted, and the method includes an average calculation step of calculating an average of sales results from the first reference period to the first reference period, and an average calculation step of calculating an average of sales results from the first reference period to the first reference period. the deviation rate calculation step of calculating a ratio of the deviation between actual sales and the average to actual sales for the target period as a deviation rate for the target period; a demand variation coefficient calculation step of calculating the demand variation coefficient based on a standard deviation of the deviation rate from the second reference period to the second reference period; a standard safety stock number calculation step of calculating the standard safety stock number based on the product of the demand variation coefficient, the average of actual sales from the third reference period to the third reference period, and the inventory cycle period; and a safety stock number calculation step of calculating the safety stock number for the target period based on the product of the standard safety stock number and the ratio of the average of actual sales from the first reference period to the first reference period to the average of actual sales from the third reference period to the third reference period.

[0014] With this method, as with the above system, the reference time and reference period (first reference time and first reference period) used to calculate past sales results for calculating the safety stock quantity for the target time, the reference time and reference period (second reference time and second reference period) used to calculate the demand fluctuation coefficient, the reference time and reference period (third reference time and third reference period) used to calculate the standard safety stock quantity, and the inventory cycle period can be changed as desired. This makes it possible to find the optimal value for the demand fluctuation coefficient (demand fluctuation tendency), and to properly calculate the safety stock quantity even if the sales results (shipment quantity) are not normally distributed.

[0015] The program of the present invention is a program executed by a computer included in a safety stock calculation system, wherein the safety stock calculation system stores information on past sales results and inventory results for each predetermined period, and a target period for calculating the safety stock number, a first reference period and a first reference period referred to when calculating past sales results for calculating the safety stock number for the target period, a second reference period and a second reference period referred to when calculating a demand variation coefficient for calculating the safety stock number for the target period, a third reference period and a third reference period referred to when calculating a base safety stock number for calculating the safety stock number for the target period, and a warehousing cycle period are input, and the program causes the computer to calculate an average of sales results from the first reference period to the first reference period. a deviation rate calculation process for calculating a ratio of the deviation between the sales actual for the target period and the average to the sales actual for the target period as a deviation rate for the target period; a demand variation coefficient calculation process for calculating the demand variation coefficient based on the standard deviation of the deviation rate from the second reference period to the second reference period; a standard safety stock quantity calculation process for calculating the standard safety stock quantity based on the product of the demand variation coefficient, the average of the sales actual for the third reference period to the third reference period, and the warehousing cycle period; and a safety stock quantity calculation process for calculating the safety stock quantity for the target period based on the product of the standard safety stock quantity and the ratio of the average of the sales actual for the third reference period to the average of the sales actual for the third reference period to the third reference period.

[0016] As with the above system, this program also allows you to freely change the reference time and reference period (first reference time and first reference period) used to calculate past sales results to calculate the safety stock quantity for the target time, the reference time and reference period (second reference time and second reference period) used to calculate the demand fluctuation coefficient, the reference time and reference period (third reference time and third reference period) used to calculate the standard safety stock quantity, and the inventory cycle period. This makes it possible to find the optimal value for the demand fluctuation coefficient (demand fluctuation tendency), and to properly calculate the safety stock quantity even if the sales results (shipment quantity) are not normally distributed. Effect of the Invention

[0017] According to the present invention, even if the sales performance (shipment amount) does not follow a normal distribution, the safety stock amount can be appropriately calculated. [Brief description of the drawings]

[0018] [Figure 1] 1 is a block diagram showing a configuration of a safety stock quantity calculation system according to an embodiment of the present invention. FIG. [Diagram 2] FIG. 11 is a diagram showing an example of past sales results and past inventory results. [Diagram 3] 11A and 11B are diagrams illustrating an example of calculation results of safety stock quantity and simulation results of stock quantity. [Figure 4] FIG. 2 is a flow diagram for explaining an operation of the safety stock quantity calculation system according to the embodiment of the present invention. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0019] A safety stock number calculation system according to an embodiment of the present invention will be described below with reference to the drawings. In this embodiment, a safety stock number calculation system used in an inventory management system that manages finished goods inventory, raw materials inventory, intermediate goods inventory, etc. will be described as an example.

[0020] The configuration of a safety stock calculation system according to an embodiment of the present invention will be described with reference to the drawings. Fig. 1 is a block diagram showing the configuration of a safety stock calculation system according to the present embodiment. As shown in Fig. 1, the safety stock calculation system 1 includes an input unit 2, an output unit 3, a storage unit 4, and a control unit 5.

[0021] The input unit 2 is an input interface that accepts input from a user, and is composed of, for example, a keyboard and a mouse. The input unit 2 receives inputs of a target time for calculating the safety stock quantity, a reference time and a reference period (first reference time and first reference period) to be referred to when calculating past sales performance for calculating the safety stock quantity for the target time, a reference time and a reference period (second reference time and second reference period) to be referred to when calculating a demand fluctuation coefficient for calculating the safety stock quantity for the target time, a reference time and a reference period (third reference time and third reference period) to be referred to when calculating a standard safety stock quantity for calculating the safety stock quantity for the target time, a stock-out cycle period, and the like. The input unit 2 also receives inputs of a reference time and a reference period (fourth reference time and fourth reference period) to simulate the stock quantity, a stock-out tolerance rate that determines the upper limit of the tolerance range of the stock-out rate, and the like.

[0022] The output unit 3 is an output interface that outputs to a user, and is composed of, for example, a display and a speaker. As shown in Fig. 3, the output unit 3 outputs the calculation results of the safety stock quantity (e.g., the demand variation coefficient, the standard safety stock quantity, the safety stock quantity, etc.) and the simulation results of the stock quantity (e.g., the number of simulated incoming goods, the number of simulated stock, the stock-out rate, etc.) which will be described later. In addition, as will be described later, the output unit 3 outputs an alert when it is determined that the number of simulated stocks is greater than the actual stock.

[0023] The storage unit 4 is composed of a HDD, a memory, etc., and stores various data. For example, as shown in Fig. 2, the storage unit 4 stores information on past sales performance and inventory performance for each predetermined period (for example, one month). In the example of Fig. 2, monthly data on sales performance and inventory performance from April 2017 to December 2019 is stored in the storage unit 4.

[0024] The control unit 5 is composed of a CPU and the like, and has a function of performing various data processing. As shown in Fig. 1, the control unit 5 has an average calculation unit 50, a deviation rate calculation unit 51, a demand fluctuation coefficient calculation unit 52, a reference safety stock quantity calculation unit 53, a safety stock quantity calculation unit 54, a storage simulation quantity calculation unit 55, an inventory simulation quantity calculation unit 56, a stockout rate calculation unit 57, a judgment unit 58, and a second judgment unit 59.

[0025] The average calculation unit 50 has a function of calculating an average of sales results from the first reference time to the first reference period. For example, when the target time for calculating the safety stock quantity is "April 2018" and the first reference time and the first reference period are "six months from the same month of the previous year," the average calculation unit 50 calculates a moving average of sales results (shipment results) for six months from "April 2017 to December 2017." In this embodiment, the average of sales results (shipment results) for six months (April 2017 to December 2017) from the same month of the previous year to the target time (April 2018) is calculated as "519" (see circled number 1 in FIG. 3).

[0026] The deviation rate calculation unit 51 has a function of calculating the ratio of the deviation between the sales performance in the target period and the average to the sales performance in the target period as the deviation rate of the target period. In this embodiment, first, the deviation between the sales performance in the target period "409" and the average "519" is calculated as "-110 (=409-519)" (see circled number 2 in Fig. 3), and the ratio of this deviation to the sales performance in the target period "-26.77 (=-110 / 409 x 100)" is calculated as the deviation rate of the target period (see circled number 3 in Fig. 3).

[0027] The demand variation coefficient calculation unit 52 has a function of calculating the demand variation coefficient based on the standard deviation of the deviation rate from the second reference time to the second reference period. For example, when the second reference time and the second reference period are "April 2018 to December 2019", the standard deviation of the deviation rate from "April 2018 to December 2019", "66.18%", is calculated as the demand variation coefficient (see circled number 4 in FIG. 3).

[0028] The standard safety stock calculation unit 53 has a function of calculating the standard safety stock quantity based on the product of the demand variation coefficient, the average of the sales performance from the third reference time to the third reference period, and the inventory cycle period. For example, when the third reference time and the third reference period are "from April 2017 to December 2019" and the inventory cycle period is "1 (=30 days / 30)", the product "339 (=66.18 x 512 x 1)" of the demand variation coefficient "66.18%", the average of the sales performance "512" from "April 2017 to December 2019", and the inventory cycle period "1" is calculated as the standard safety stock quantity (see circled number 5 in FIG. 3).

[0029] The safety stock calculation unit 54 has a function of calculating the safety stock for the target period based on the product of the ratio of the average of the sales results from the first reference period to the first reference period to the average of the sales results from the third reference period to the third reference period and the standard safety stock. As described above, in this embodiment, the average of the sales results from the first reference period to the first reference period is "519", the average of the sales results from the third reference period to the third reference period is "512", and the standard safety stock is "339", so the safety stock for the target period (April 2018) is calculated as "343 (=519 / 512×339)" (see circled number 6 in FIG. 3).

[0030] The inventory simulation number calculation unit 55 has a function of calculating the inventory simulation number for the target period based on the difference between the safety stock number for the target period and the inventory performance for the period preceding the target period (however, if the difference is a negative number, the calculation is 0). In this embodiment, the safety stock number for the target period (April 2018) is "343", and the inventory performance for the period preceding the target period (March 2018) is "1658". In this case, since the difference between the safety stock number for the target period and the inventory performance for the period preceding the target period is "-1315 (negative number)", the inventory simulation number is calculated as "0" (see circled number 7 in FIG. 3).

[0031] The inventory simulation number calculation unit 56 has a function of calculating the inventory simulation number for the target period based on the sum of the difference in sales performance for the target period from the inventory performance for the period preceding the target period and the inventory simulation number. In this embodiment, the difference in sales performance for the target period (April 2018) from the inventory performance for the period preceding the target period (March 2018) is "1249 (=1658-409)" and the inventory simulation number is "0", so the inventory simulation number is calculated as "1249 (=1249+0)" (see circled number 8 in FIG. 3).

[0032] The out-of-stock rate calculation unit 57 has a function of calculating the ratio of the total number of out-of-stock items from the fourth reference time to the fourth reference period to the total sales performance from the fourth reference time to the fourth reference period as the out-of-stock rate. For example, when the fourth reference time and the fourth reference period are "April 2018 to December 2019", the ratio of the total number of out-of-stock items from "April 2018 to December 2019" to the total sales performance is calculated as "0.91% (=99 / 10915×100)" as the out-of-stock rate.

[0033] The determination unit 58 has a function of determining whether the stockout rate is within the allowable range determined by the stockout allowance rate. For example, if the stockout allowance rate is "5%," the stockout rate calculated as above, "0.91%, is determined to be within the allowable range.

[0034] The second determination unit 59 has a function of determining whether the simulated inventory number is greater than the actual inventory number from the fourth reference time to the fourth reference period. In this embodiment, it is determined that the average simulated inventory number "810" from "May 2018 to December 2019" is not greater than the average actual inventory number "1825." If it is determined that the simulated inventory number is greater than the actual inventory number, an alert is output from the output unit 3.

[0035] The operation of the safety stock quantity calculation system 1 configured as above will be described with reference to the flow chart of FIG.

[0036] When calculating the safety stock quantity using the safety stock quantity calculation system 1 of this embodiment, first, input the reference time and the reference period, etc., in the input unit 2 (S1). Specifically, the target time for calculating the safety stock quantity (e.g., April 2018), the first reference time and the first reference period (e.g., six months from the same month of the previous year), the second reference time and the second reference period (e.g., from April 2018 to December 2019), the third reference time and the third reference period (e.g., from April 2017 to December 2019), the inventory cycle period (e.g., 1), the fourth reference time and the fourth reference period (e.g., from April 2018 to December 2019), and the stockout tolerance rate (e.g., 5%) are input.

[0037] Then, in the safety stock number calculation system 1, the average of the sales results from the first reference time to the first reference period (e.g., 519) is calculated (S2), and the ratio of the deviation between the sales results from the target time and the average to the sales results from the target time (e.g., -26.77) is calculated as the deviation rate of the target time (S3). Next, the standard deviation of the deviation rate from the second reference time to the second reference period (e.g., 66.18%) is calculated as the demand variation coefficient (S4), and the product of the demand variation coefficient, the average of the sales results from the third reference time to the third reference period, and the inventory cycle period (e.g., 339) is calculated as the standard safety stock number (S5). Then, the product of the ratio of the average of the sales results from the first reference time to the first reference period to the average of the sales results from the third reference time to the third reference period, and the standard safety stock number (e.g., 343) is calculated as the safety stock number for the target time (S6).

[0038] Furthermore, in safety stock number calculation system 1, the difference between the safety stock number for the target period and the inventory performance for the period preceding the target period (for example, 0 if the number is negative) is calculated as the inventory simulation number for the target period (S7), and the sum of the difference in the sales performance for the target period from the inventory performance for the period preceding the target period and the inventory simulation number (for example, 1249) is calculated as the inventory simulation number for the target period (S8). Then, the ratio (for example, 0.91%) of the total number of stockouts from the fourth reference period to the fourth reference period to the total sales performance from the fourth reference period to the fourth reference period is calculated as the stockout rate (S9).

[0039] Next, it is determined whether the stockout rate is within the allowable range determined by the stockout tolerance rate (S10), and if it is determined that it is not within the allowable range, the process returns to inputting the reference time, reference period, etc. (S1). If it is determined that it is within the allowable range, it is determined whether the inventory simulation number is greater than the inventory performance from the fourth reference time to the fourth reference period (S11), and if it is determined that the inventory simulation number is greater than the inventory performance, an alert is output from the output unit 3 (S12).

[0040] According to the safety stock number calculation system 1 of this embodiment, the reference time and the reference period (first reference time and first reference period) to be calculated when calculating the past sales performance for calculating the safety stock number of the target time, the reference time and the reference period (second reference time and second reference period) to be referred to when calculating the demand fluctuation coefficient, the reference time and the reference period (third reference time and third reference period) to be referred to when calculating the standard safety stock number, and the inventory cycle period can be changed arbitrarily. This makes it possible to obtain the optimal value of the demand fluctuation coefficient (demand fluctuation tendency), and to properly calculate the safety stock number even when the sales performance (shipment number) is not normally distributed.

[0041] In addition, in this embodiment, it is possible to judge whether the stock-out rate calculated by simulating the stock quantity using the calculated safety stock quantity is within an allowable range, which makes it easy to verify whether the calculated safety stock quantity (the reference time and reference period inputted to calculate the safety stock quantity) are appropriate in terms of stock-out risk.

[0042] In addition, in this embodiment, if the inventory simulation number calculated by simulating the inventory number using the calculated safety stock number is greater than the inventory actual number, an alert is output. This makes it easy to know whether the calculated safety stock number (the reference time and reference period input to calculate the safety stock number) is appropriate from the perspective of the optimal inventory number.

[0043] Although the embodiments of the present invention have been described above by way of example, the scope of the present invention is not limited to these, and changes and modifications can be made according to the purpose within the scope of the claims. [Industrial Applicability]

[0044] As described above, the safety stock quantity calculation system of the present invention has the effect of being able to properly calculate safety stock quantities even when sales performance (shipment volume) does not follow a normal distribution, and is useful when applied to inventory management systems that manage finished goods inventory, raw materials, and in-process inventory, etc. [Explanation of symbols]

[0045] 1. Safety stock calculation system 2 Input section 3. Output section 4 Storage section 5. Control section 50 Average calculation part 51 Deviation rate calculation section 52 Demand fluctuation coefficient calculation section 53 Standard Safety Stock Calculation Section 54 Safety Stock Calculation Section 55 Inventory Simulation Number Calculation Section 56 Inventory Simulation Quantity Calculation Section 57 Stockout Rate Calculation Section 58 Judgment section 59 Second Judgment Section

Claims

1. a storage unit in which information on past sales results and inventory results is stored for each predetermined period; an input section for inputting a target time period for calculating safety stock quantity, a first reference time period and a first reference period referred to when calculating past sales performance for calculating the safety stock quantity for the target time period, a second reference time period and a second reference period referred to when calculating a demand fluctuation coefficient for calculating the safety stock quantity for the target time period, a third reference time period and a third reference period referred to when calculating a standard safety stock quantity for calculating the safety stock quantity for the target time period, and a warehousing cycle period; an average calculation unit that calculates an average of sales results from the first reference time to the first reference period; a deviation rate calculation unit that calculates a ratio of a deviation between the sales performance in the target period and the average to the sales performance in the target period as a deviation rate for the target period; a demand fluctuation coefficient calculation unit that calculates the demand fluctuation coefficient based on a standard deviation of the deviation rate from the second reference time to the second reference period; a standard safety stock quantity calculation unit that calculates the standard safety stock quantity based on the demand fluctuation coefficient, a product of an average of sales results from the third reference time to the third reference period, and the inventory cycle period; a safety stock quantity calculation unit that calculates a safety stock quantity for the target period based on a product of a ratio of an average of sales results from the first reference time to the first reference period to an average of sales results from the third reference time to the third reference period and the standard safety stock quantity; A safety stock quantity calculation system comprising:

2. a fourth reference time and a fourth reference period for simulating an inventory quantity, and a stock-out allowance rate that determines an upper limit of an allowable range of a stock-out rate, The safety stock quantity calculation system includes: a simulation inventory quantity calculation unit that calculates a simulation inventory quantity for a target period based on a difference between a safety stock quantity for the target period and an inventory actual result for a period preceding the target period; an inventory simulation number calculation unit that calculates an inventory simulation number for a target period based on the sum of a difference between a sales performance of the target period and an inventory performance of a period preceding the target period and the inventory simulation number; a stock-out rate calculation unit that calculates a stock-out rate as a ratio of a total number of stock-outs from the fourth reference time to the fourth reference period to a total sales performance from the fourth reference time to the fourth reference period; a determination unit that determines whether the stock-out rate is within an allowable range determined by the stock-out allowable rate; The safety stock quantity calculation system according to claim 1 .

3. a second determination unit that determines whether the inventory simulation quantity is greater than the inventory actual result from the fourth reference time to the fourth reference period; an alert output unit that outputs an alert when the second determination unit determines that the inventory simulation number is greater than the inventory actual result; The safety stock quantity calculation system according to claim 2 .

4. A method executed in a safety stock quantity calculation system, comprising: The safety stock quantity calculation system includes: Past sales and inventory information is stored for each specified period. A target time period for calculating the safety stock quantity, a first reference time period and a first reference period to be referred to when calculating past sales performance for calculating the safety stock quantity for the target time period, a second reference time period and a second reference period to be referred to when calculating a demand fluctuation coefficient for calculating the safety stock quantity for the target time period, a third reference time period and a third reference period to be referred to when calculating a standard safety stock quantity for calculating the safety stock quantity for the target time period, and a warehousing cycle period are inputted, The method comprises: an average calculation step of calculating an average of sales results from the first reference time to the first reference period; a deviation rate calculation step of calculating a ratio of a deviation between the sales performance in the target period and the average to the sales performance in the target period as a deviation rate for the target period; a demand fluctuation coefficient calculation step of calculating the demand fluctuation coefficient based on a standard deviation of the deviation rate from the second reference time to the second reference period; A standard safety stock quantity calculation step of calculating the standard safety stock quantity based on the demand fluctuation coefficient, a product of an average of sales results from the third reference time to the third reference period, and the inventory cycle period; a safety stock quantity calculation step of calculating a safety stock quantity for the target period based on a product of a ratio of an average of sales results from the first reference time to the first reference period to an average of sales results from the third reference time to the third reference period and the standard safety stock quantity; The method according to claim 1, further comprising:

5. A program executed by a computer included in a safety stock calculation system, The safety stock quantity calculation system includes: Past sales and inventory information is stored for each specified period. A target time period for calculating the safety stock quantity, a first reference time period and a first reference period to be referred to when calculating past sales performance for calculating the safety stock quantity for the target time period, a second reference time period and a second reference period to be referred to when calculating a demand fluctuation coefficient for calculating the safety stock quantity for the target time period, a third reference time period and a third reference period to be referred to when calculating a standard safety stock quantity for calculating the safety stock quantity for the target time period, and a warehousing cycle period are inputted, The program causes the computer to an average calculation process for calculating an average of sales results from the first reference time to the first reference period; a deviation rate calculation process for calculating a ratio of a deviation between the sales performance in the target period and the average to the sales performance in the target period as a deviation rate for the target period; A demand fluctuation coefficient calculation process for calculating the demand fluctuation coefficient based on a standard deviation of the deviation rate from the second reference time to the second reference period; A standard safety stock quantity calculation process for calculating the standard safety stock quantity based on the demand fluctuation coefficient, the product of an average of sales results from the third reference time to the third reference period, and the inventory cycle period; A safety stock quantity calculation process for calculating a safety stock quantity for the target period based on a product of a ratio of an average of sales results from the first reference time to the first reference period to an average of sales results from the third reference time to the third reference period and the standard safety stock quantity; A program characterized by executing the above.

Citation Information

Patent Citations

  • Exhaust gas cleaning device in motorcycle

    JP1984068513A

  • Safety stock volume calculating device

    JP2000172768A

  • System and method for inventory management

    US20140156348A1

  • Safe stock amount calculation method, safe stock amount calculation device, order making moment calculation method, order making moment calculation device, and order making amount calculation method

    WO2004022463A1