JP5123592B2 - Safety stock quantity calculation system and safety stock quantity calculation program - Google Patents

Safety stock quantity calculation system and safety stock quantity calculation program Download PDF

Info

Publication number
JP5123592B2
JP5123592B2 JP2007194221A JP2007194221A JP5123592B2 JP 5123592 B2 JP5123592 B2 JP 5123592B2 JP 2007194221 A JP2007194221 A JP 2007194221A JP 2007194221 A JP2007194221 A JP 2007194221A JP 5123592 B2 JP5123592 B2 JP 5123592B2
Authority
JP
Japan
Prior art keywords
day
stock quantity
value
consumption number
calculated
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Expired - Fee Related
Application number
JP2007194221A
Other languages
Japanese (ja)
Other versions
JP2009031965A (en
Inventor
寛 藤原
宏嗣 荒木
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Panasonic Corp
Panasonic Holdings Corp
Original Assignee
Panasonic Corp
Matsushita Electric Industrial Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Panasonic Corp, Matsushita Electric Industrial Co Ltd filed Critical Panasonic Corp
Priority to JP2007194221A priority Critical patent/JP5123592B2/en
Publication of JP2009031965A publication Critical patent/JP2009031965A/en
Application granted granted Critical
Publication of JP5123592B2 publication Critical patent/JP5123592B2/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]

Landscapes

  • General Factory Administration (AREA)

Description

本発明は、商品の安全在庫数を算出するための安全在庫数算出システム及び安全在庫数算出プログラムに関する。   The present invention relates to a safe stock quantity calculation system and a safe stock quantity calculation program for calculating a safe stock quantity of a product.

従来より、商品の消費予定数と消費実績数の標準偏差のばらつき度合いを算出し、算出されたばらつき度合いを商品の調達期間に応じた分だけ商品の許容欠品率に基づく安全係数に乗算することにより商品の安全在庫数を算出する安全在庫数算出プログラムが知られている（特許文献１参照）。
特開２００５−３０６５４３号公報 Conventionally, the degree of variation in the standard deviation between the number of products planned to be consumed and the number of actual consumption is calculated, and the calculated degree of variation is multiplied by the safety factor based on the product's allowable shortage rate by an amount corresponding to the product procurement period. Therefore, a safe stock quantity calculation program for calculating the safe stock quantity of products is known (see Patent Document 1).
JP-A-2005-306543

上記安全在庫数算出プログラムは、常に正値となる標準偏差のみを用いて商品の安全在庫数を算出する構成となっているために、消費予定数が消費実績数より多い場合であっても算出される安全在庫数は正値となる。このため上記安全在庫数算出プログラムによれば、必要数以上の安全在庫数が算出されことにより、安全在庫数が不適切な数になることがあった。   The safety stock quantity calculation program is configured to calculate the safety stock quantity of products using only the standard deviation that is always positive, so it is calculated even when the planned consumption quantity is greater than the actual consumption quantity. The number of safety stocks to be made becomes a positive value. For this reason, according to the above safety stock number calculation program, the safety stock number may become an inappropriate number by calculating the safety stock number more than the necessary number.

本発明は、上記課題を解決するためになされたものであり、その目的は、消費予定数が消費実績数より多い場合であっても適切な安全在庫数を算出可能な安全在庫数算出システム及び安全在庫数算出プログラムを提供することにある。   The present invention has been made to solve the above-mentioned problems, and its purpose is to calculate a safety stock quantity calculation system capable of calculating an appropriate safety stock quantity even when the planned consumption quantity is greater than the actual consumption quantity, and It is to provide a safety stock quantity calculation program.

本発明に係る安全在庫数算出システム及び安全在庫数算出プログラムは、評価期間内の各日について消費実績数と消費予定数の差分値を算出し、差分値を調達日数分加算した値を累積差として算出する処理を評価期間内の各日について実行し、評価期間内における各日の累積差の平均値と標準偏差値を算出し、算出された累積差の平均値と標準偏差値を用いて商品の安全在庫数を算出する。   The safety stock quantity calculation system and the safety stock quantity calculation program according to the present invention calculate a difference value between the actual number of consumptions and the expected consumption number for each day in the evaluation period, and add the difference value to the number of procurement days to calculate the cumulative difference. Is executed for each day in the evaluation period, the average value and the standard deviation value of the cumulative difference for each day in the evaluation period are calculated, and the calculated average value and standard deviation value of the cumulative difference are used. Calculate the safety stock number of the product.

本発明に係る安全在庫数算出システム及び安全在庫数算出プログラムによれば、消費予定数が消費実績数よりも多い場合には累積差の平均値が負値になることによって安全在庫数が少なく算出されるので、消費予定数が消費実績数よりも多い場合に必要数以上の安全在庫数が算出されることを防止し、適切な安全在庫数を算出することができるという効果がある。 According to the safety stock number calculation system and the safety stock number calculation program according to the present invention, when the planned consumption number is larger than the actual consumption number, the average value of the cumulative difference becomes a negative value so that the safety stock number is calculated to be small. because it is, expected consumption number to prevent the safety that the stock number of Ru is calculated equal to or greater than the number of required if more than the actual consumption numbers, there is an effect that it is possible to calculate the appropriate safety stock quantity.

本発明の実施形態となる安全在庫数算出システム１は、ワークステーション等の汎用又は専用の情報処理装置により構成され、図１に示すように、データベース２と、消費予定履歴格納部３と、安全在庫数算出部４とを主な構成要素として備える。データベース２は、商品の調達に要する日数（調達期間）のデータを商品毎に格納する調達期間マスタＤＢ５と、調達期間だけ先の日の消費予定数のデータを商品及び日単位で格納する消費予定履歴ＤＢ６と、消費実績数のデータを商品及び日単位で格納する消費実績履歴ＤＢ７と、安全在庫数のデータを商品毎に格納する安全在庫数格納ＤＢ８とを備える。   A safety stock quantity calculation system 1 according to an embodiment of the present invention includes a general-purpose or dedicated information processing apparatus such as a workstation, and as shown in FIG. 1, a database 2, a consumption schedule history storage unit 3, a safety The inventory quantity calculation unit 4 is provided as a main component. The database 2 includes a procurement period master DB 5 that stores data on the number of days required for product procurement (purchase period) for each product, and a consumption schedule that stores data on the number of consumptions scheduled for the previous day during the procurement period for each product and day. A history DB 6, a consumption record history DB 7 that stores data on the number of consumption records in units of products and days, and a safety stock number storage DB 8 that stores data on the number of safety stocks for each product are provided.

消費予定履歴格納部３は、情報処理装置内のＣＰＵがＲＯＭ内に記憶されたコンピュータプログラムを実行することにより、調達期間マスタＤＢ５から各商品の調達期間のデータを取得し、調達期間だけ先の日付の商品の消費予定数を日単位で算出し、算出された消費予定数のデータを消費予定履歴ＤＢ６内に格納する。安全在庫数算出部４は、情報処理装置内のＣＰＵがＲＯＭ内に記憶されたコンピュータプログラムを実行することにより、データベース２内に格納されているデータを利用して各商品の安全在庫数を算出し、算出された安全在庫数のデータを安全在庫数格納ＤＢ８内に格納する。   The consumption schedule history storage unit 3 acquires the procurement period data of each product from the procurement period master DB 5 by executing the computer program stored in the ROM by the CPU in the information processing apparatus. The number of planned consumptions of the product on the date is calculated on a daily basis, and the calculated planned consumption number data is stored in the consumption schedule history DB 6. The safety inventory quantity calculation unit 4 calculates the safety inventory quantity of each product using data stored in the database 2 by executing a computer program stored in the ROM by the CPU in the information processing apparatus. Then, the calculated safety stock quantity data is stored in the safety stock quantity storage DB 8.

このような構成を有する安全在庫数算出システム１は、以下に示す差分値算出処理と安全在庫数算出処理を実行することにより、消費予定数が消費実績数よりも多い場合に必要量以上の安全在庫数が算出されことを防止する。以下、図２及び図３に示すフローチャートを参照して、差分値算出処理及び安全在庫数算出処理を実行する際の安全在庫数算出システム１の動作について詳しく説明する。   The safety stock quantity calculation system 1 having such a configuration executes the difference value calculation process and the safety stock quantity calculation process shown below, thereby ensuring a safety level that is greater than the necessary amount when the planned consumption number is greater than the actual consumption number. Prevent inventory numbers from being calculated. Hereinafter, with reference to the flowcharts shown in FIGS. 2 and 3, the operation of the safe stock quantity calculation system 1 when executing the difference value calculation process and the safe stock quantity calculation process will be described in detail.

〔差分値算出処理〕
図２に示すフローチャートは、各日の所定時刻に開始となり、差分値算出処理はステップＳ１の処理に進む。なおこの差分値算出処理におけるステップＳ２の処理は、必ずしも日毎に行う必要はなく、安全在庫数を算出する際に評価期間内の各日について一度に行うようにしてもよい。 [Difference calculation process]
The flowchart shown in FIG. 2 starts at a predetermined time on each day, and the difference value calculation process proceeds to step S1. Note that the process of step S2 in this difference value calculation process does not necessarily have to be performed every day, and may be performed once for each day in the evaluation period when calculating the number of safety stocks.

ステップＳ１の処理では、消費予定履歴格納部３が、調達期間だけ先の日付の商品の消費予定数を算出して消費予定履歴ＤＢ６に格納する。具体的には本日の日付が４月１日であり、調達期間が４日である場合、消費予定履歴格納部３は４月４日の消費予定数を算出して消費予定履歴ＤＢ６に格納する。また図示しない情報処理装置が、その日の消費実績数を集計して消費実績履歴ＤＢ７に格納する。これにより、ステップＳ１の処理は完了し、差分値算出処理はステップＳ２の処理に進む。   In the process of step S1, the consumption schedule history storage unit 3 calculates the planned consumption number of the product with the date earlier than the procurement period and stores it in the consumption schedule history DB 6. Specifically, if today's date is April 1 and the procurement period is 4 days, the consumption schedule history storage unit 3 calculates the number of consumption scheduled for April 4 and stores it in the consumption schedule history DB 6. . In addition, an information processing device (not shown) counts the number of actual consumptions for the day and stores it in the actual consumption history DB 7. Thereby, the process of step S1 is completed and a difference value calculation process progresses to the process of step S2.

ステップＳ２の処理では、安全在庫数算出部４が、その日の消費実績数と消費予定数の差分値（消費実績数−消費予定数）を算出して安全在庫数格納ＤＢ８内に格納する。具体的には本日の日付が４月１日である場合、安全在庫数算出部４は４月１日の消費実績数と消費予定数の差分値を算出して安全在庫数格納ＤＢ８内に格納する。これにより、ステップＳ２の処理は完了し、一連の差分値算出処理は終了する。   In the process of step S2, the safety stock quantity calculation unit 4 calculates a difference value (consumption actual number-consumed consumption number) between the actual consumption number and the expected consumption number on the day and stores it in the safe inventory number storage DB 8. Specifically, when today's date is April 1, the safe stock quantity calculation unit 4 calculates a difference value between the actual consumption quantity and the planned consumption quantity on April 1 and stores it in the safe stock quantity storage DB 8. To do. Thereby, the process of step S2 is completed and a series of difference value calculation processes are complete | finished.

〔安全在庫数算出処理〕
図３に示すフローチャートは、図示しない入力装置を介してユーザが安全在庫数の算出を指示したタイミングで開始となり、安全在庫数算出処理はステップＳ１１の処理に進む。なお安全在庫数の算出を指示する際、ユーザは安全在庫数を評価する期間（評価期間）も指定する。また以下に示す安全在庫数算出処理は商品毎に個別に実行されるものとする。 [Safety inventory calculation process]
The flowchart shown in FIG. 3 starts at the timing when the user instructs the calculation of the safety stock quantity via an input device (not shown), and the safety stock quantity calculation process proceeds to the process of step S11. When instructing the calculation of the safety stock quantity, the user also specifies a period (evaluation period) for evaluating the safety stock quantity. In addition, the safety stock quantity calculation process shown below is executed individually for each product.

ステップＳ１１の処理では、安全在庫数算出部４が、安全在庫数格納ＤＢ８から評価期間内の各日の差分値を読み出し、読み出された差分値を調達期間分加算して累積差を算出する処理を評価期間内の各日について実行する。具体的には、調達期間が４日であり、現在の日付が４月１日である場合、安全在庫数算出部４は、図４に示すように、４月４日から４月７日までの差分値の和（１０＋５＋０−５＝１０）を４月４日における累積差として算出する。そして評価期間が６日である場合には、安全在庫数算出部４は、図４に示すように、４月４日から４月９日までの各日について累積差を算出する。これにより、ステップＳ１１の処理は完了し、安全在庫数算出処理はステップＳ１２の処理に進む。   In the process of step S11, the safety stock quantity calculation unit 4 reads the difference value of each day in the evaluation period from the safety stock quantity storage DB 8, and adds the read difference value for the procurement period to calculate the cumulative difference. Processing is performed for each day within the evaluation period. Specifically, when the procurement period is 4 days and the current date is April 1, the safety stock quantity calculation unit 4 performs the operation from April 4 to April 7 as shown in FIG. The sum of the difference values (10 + 5 + 0−5 = 10) is calculated as the cumulative difference on April 4. When the evaluation period is 6 days, the safety stock quantity calculation unit 4 calculates the cumulative difference for each day from April 4 to April 9, as shown in FIG. Thereby, the process of step S11 is completed, and the safety stock quantity calculation process proceeds to the process of step S12.

ステップＳ１２の処理では、安全在庫数算出部４が、ステップＳ１１の処理により算出された各日の累積差の平均値を算出する。具体的には、図４に示す例で言えば、安全在庫数算出部４は、４月４日から４月９日までの各日の累積差の平均値（（１０＋５−５−１０−１５）／６＝−３．３）を算出する。この図４に示す例では、消費予定数が消費実績数よりも多くなる日（対象日付：４月７日，９日）が多いので、累積差の平均値は負値となる。これにより、ステップＳ１２の処理は完了し、安全在庫数算出処理はステップＳ１３の処理に進む。   In the process of step S12, the safe stock quantity calculation unit 4 calculates the average value of the cumulative difference of each day calculated by the process of step S11. Specifically, in the example shown in FIG. 4, the safety stock quantity calculation unit 4 calculates the average value of the cumulative difference of each day from April 4 to April 9 ((10 + 5-5-10-15). ) /6=-3.3). In the example shown in FIG. 4, since there are many days (target dates: April 7th and 9th) when the planned consumption number is larger than the actual consumption number, the average value of the cumulative difference is a negative value. Thereby, the process of step S12 is completed, and the safety stock quantity calculation process proceeds to the process of step S13.

ステップＳ１３の処理では、安全在庫数算出部４が、ステップＳ１１の処理により算出された各日の累積差の標準偏差を算出する。具体的には、図４に示す例で言えば、安全在庫数算出部４は、４月４日から４月９日までの各日の累積差の標準偏差（９．３）を算出する。これにより、ステップＳ１３の処理は完了し、安全在庫数算出処理はステップＳ１４の処理に進む。   In the process of step S13, the safety stock quantity calculation unit 4 calculates the standard deviation of the cumulative difference of each day calculated by the process of step S11. Specifically, in the example shown in FIG. 4, the safety stock quantity calculation unit 4 calculates the standard deviation (9.3) of the cumulative difference of each day from April 4 to April 9. Thereby, the process of step S13 is completed and the safety stock quantity calculation process proceeds to the process of step S14.

ステップＳ１４の処理では、安全在庫数算出部４が、ステップＳ１２及びステップＳ１３の処理により算出された累積差の平均値及び標準偏差を以下の数式１に代入することにより商品の安全在庫数を算出する。いま数式１中の安全係数αの値を１．６５とすると、図４に示す例では、安全在庫数算出部４は安全在庫数を１２．０（＝−３．３＋１．６５×９．３）と算出する。そしてユーザは、算出された安全在庫数を参考にして４月１日の必要発注数を決定する。これにより、一連の安全在庫数算出処理は終了する。   In the process of step S14, the safe stock quantity calculation unit 4 calculates the safe stock quantity of the product by substituting the average value and standard deviation of the cumulative difference calculated by the processes of step S12 and step S13 into the following formula 1. To do. Assuming that the value of the safety coefficient α in Equation 1 is 1.65, in the example shown in FIG. 4, the safety stock quantity calculation unit 4 sets the safety stock quantity to 12.0 (= −3.3 + 1.65 × 9.3). ) And calculate. Then, the user determines the required order quantity on April 1 with reference to the calculated safety stock quantity. Thereby, a series of safety stock number calculation processing is completed.

[数１]
安全在庫数＝ＭＡＸ（累積差の平均値＋安全係数α×累積差の標準偏差，０）
以上の説明から明らかなように、本発明の実施形態となる安全在庫数算出システム１は、累積差の平均値と標準偏差値を用いて商品の安全在庫数を算出する。このような構成によれば、消費予定数が消費実績数よりも多い場合には累積差の平均値が負値になることによって安全在庫数が少なく算出されるので、消費予定数が消費実績数よりも多い場合に必要数以上の安全在庫数が算出されことを防止し、適切な安全在庫数を算出することができる。また消費実績数と消費予定数の差分値のばらつきは消費実績数のばらつきよりも小さいので、本発明の実施形態となる安全在庫数算出システム１によれば、消費実績数のばらつきを用いて安全在庫数を算出する手法と比較して、安全在庫数を適切に算出することができる。 [Equation 1]
Number of safety stocks = MAX (average value of cumulative difference + safety coefficient α x standard deviation of cumulative difference, 0)
As is clear from the above description, the safe stock quantity calculation system 1 according to the embodiment of the present invention calculates the safe stock quantity of a product using the average value of the cumulative difference and the standard deviation value. According to such a configuration, when the planned consumption number is larger than the actual consumption number, the average value of the cumulative difference becomes a negative value and the safety stock number is calculated to be small. When the number is larger than that, it is possible to prevent the number of safety stocks exceeding the necessary number from being calculated, and to calculate an appropriate number of safety stocks. In addition, since the variation in the difference value between the actual consumption number and the planned consumption number is smaller than the variation in the actual consumption number, the safety stock number calculation system 1 according to the embodiment of the present invention uses the variation in the actual consumption number for safety. Compared to the method of calculating the stock quantity, the safe stock quantity can be appropriately calculated.

上記実施形態において、図５に示すように、消費予定数が消費実績数より多い日付（図５に示す例では対象日付が４月７日，９日，１１日）については、消費実績数と消費予定数の差分値をゼロとしてもよい。このような構成によれば、消費実績数が消費予定数より多い場合の差分値だけで安全在庫数を算出することになるので、差分値の分布が偏りを持つ場合であっても安全在庫数を正しく算出することができる。また上記実施形態において、累積差の平均値及び標準偏差値に代わりに、消費実績数と消費予定数の差分値の平均値及び標準偏差を用いて安全在庫数を算出するようにしてもよい。このような構成によれば、蓄積されたデータの数が少ない場合であっても適切な安全在庫数を算出することができる。   In the above embodiment, as shown in FIG. 5, for the dates where the scheduled consumption number is greater than the actual consumption number (in the example shown in FIG. 5, the target dates are April 7, 9, and 11), The difference value of the planned consumption number may be zero. According to such a configuration, since the safety stock number is calculated only by the difference value when the actual consumption number is larger than the planned consumption number, even if the difference value distribution is uneven, Can be calculated correctly. Moreover, in the said embodiment, you may make it calculate the number of safety stocks using the average value and standard deviation of the difference value of the actual consumption number and the expected consumption number instead of the average value and standard deviation value of a cumulative difference. According to such a configuration, an appropriate number of safety stocks can be calculated even when the number of accumulated data is small.

以上、本発明者らによってなされた発明を適用した実施の形態について説明したが、この実施の形態による本発明の開示の一部をなす論述及び図面により本発明は限定されることはない。すなわち、上記実施の形態に基づいて当業者等によりなされる他の実施の形態、実施例及び運用技術等は全て本発明の範疇に含まれることは勿論であることを付け加えておく。   As mentioned above, although the embodiment to which the invention made by the present inventors was applied has been described, the present invention is not limited by the description and the drawings that form part of the disclosure of the present invention according to this embodiment. That is, it should be added that other embodiments, examples, operation techniques, and the like made by those skilled in the art based on the above embodiments are all included in the scope of the present invention.

本発明の実施形態となる安全在庫数算出システムの構成を示すブロック図である。It is a block diagram which shows the structure of the safe stock quantity calculation system used as embodiment of this invention. 本発明の実施形態となる差分値算出処理の流れを示すフローチャート図である。It is a flowchart figure which shows the flow of the difference value calculation process used as embodiment of this invention. 本発明の実施形態となる安全在庫数算出処理の流れを示すフローチャート図である。It is a flowchart figure which shows the flow of the safe stock quantity calculation process used as embodiment of this invention. 本発明に係る安全在庫数算出処理の一例を説明するための図である。It is a figure for demonstrating an example of the safety stock number calculation process which concerns on this invention. 本発明に係る安全在庫数算出処理の応用例を説明するための図である。It is a figure for demonstrating the application example of the safety stock number calculation process which concerns on this invention.

符号の説明Explanation of symbols

１：安全在庫数算出システム
２：データベース
３：消費予定履歴格納部
４：安全在庫数算出部
５：調達期間マスタＤＢ
６：消費予定履歴ＤＢ
７：消費実績履歴ＤＢ
８：安全在庫数格納ＤＢ 1: Safety stock quantity calculation system 2: Database 3: Consumption schedule history storage unit 4: Safety stock quantity calculation unit 5: Procurement period master DB
6: Consumption schedule history DB
7: Consumption result history DB
8: Safety stock number storage DB

Claims (5)

調達期間だけ先の日付の商品の消費予定数を日毎に記憶する消費予定数記憶部と、
前記商品の消費実績数を日毎に記憶する消費実績数記憶部と、
前記消費予定数記憶部内及び前記消費実績数記憶部内に記憶されている情報を参照して、評価期間内の各日について消費実績数と消費予定数の差分値を算出し、差分値を調達日数分加算した値を累積差として算出する処理を評価期間内の各日について実行し、評価期間内における各日の累積差の平均値と標準偏差値を算出し、算出された累積差の平均値と標準偏差値を用いて商品の安全在庫数を算出する安全在庫数算出部と
を備えることを特徴とする安全在庫数算出システム。 The planned consumption number storage unit that stores the planned consumption number of products with a date earlier than the procurement period every day,
A consumption record number storage unit for storing the consumption record number of the product every day;
Referring to the information stored in the planned consumption number storage unit and the actual consumption number storage unit, the difference value between the actual consumption number and the planned consumption number is calculated for each day in the evaluation period, and the difference value is calculated as the number of procurement days. Executes the process of calculating the added value as a cumulative difference for each day in the evaluation period, calculates the average value and standard deviation value of the cumulative difference for each day in the evaluation period, and calculates the calculated average value of the cumulative difference And a safety stock quantity calculation unit for calculating the safety stock quantity of the product using the standard deviation value. 調達期間だけ先の日付の商品の消費予定数を日毎に記憶する消費予定数記憶部と、
前記商品の消費実績数を日毎に記憶する消費実績数記憶部と、
前記消費予定数記憶部内及び前記消費実績数記憶部内に記憶されている情報を参照して、評価期間内の各日について消費実績数と消費予定数の差分値を算出し、差分値を調達日数分加算した値を累積差として算出する処理を評価期間内の各日について実行し、評価期間内における各日の累積差の平均値と標準偏差値を算出し、算出された累積差の平均値と標準偏差値を用いて商品の安全在庫数を算出する安全在庫数算出部とを備え、
前記安全在庫数算出部は、前記累積差の標準偏差値に安全係数を乗じた数に、前記累積差の平均値を加算した数と、ゼロとの大きい方を商品の安全在庫数とする
ことを特徴とする安全在庫数算出システム。 The planned consumption number storage unit that stores the planned consumption number of products with a date earlier than the procurement period every day,
A consumption record number storage unit for storing the consumption record number of the product every day;
Referring to the information stored in the planned consumption number storage unit and the actual consumption number storage unit, the difference value between the actual consumption number and the planned consumption number is calculated for each day in the evaluation period, and the difference value is calculated as the number of procurement days. Executes the process of calculating the added value as a cumulative difference for each day in the evaluation period, calculates the average value and standard deviation value of the cumulative difference for each day in the evaluation period, and calculates the calculated average value of the cumulative difference And a safety stock quantity calculation unit for calculating the safety stock quantity of the product using the standard deviation value ,
The safety stock quantity calculation unit calculates the safety stock quantity of a product, which is the greater of the number obtained by multiplying the standard deviation value of the cumulative difference by a safety coefficient and the average value of the cumulative difference and zero. A safety stock quantity calculation system characterized by the above. 請求項１または請求項２に記載の安全在庫数算出システムにおいて、前記安全在庫数算出部は、消費予定数が消費実績数より大きい日についてはその日の差分値をゼロとすることを特徴とする安全在庫数算出システム。 The safety stock quantity calculation system according to claim 1 or 2 , wherein the safety stock quantity calculation unit sets a difference value of the day to zero for a day when the planned consumption quantity is larger than the actual consumption quantity. Safety stock quantity calculation system. 調達期間だけ先の日付の商品の消費予定数を日毎に消費予定数記憶部内に記憶する処理と、
前記商品の消費実績数を日毎に消費実績数記憶部内に記憶する処理と、
前記消費予定数記憶部内及び前記消費実績数記憶部内に記憶されている情報を参照して、評価期間内の各日について消費実績数と消費予定数の差分値を算出し、差分値を調達日数分加算した値を累積差として算出する処理を評価期間内の各日について実行し、評価期間内における各日の累積差の平均値と標準偏差値を算出し、算出された累積差の平均値と標準偏差値を用いて商品の安全在庫数を算出する処理と
をコンピュータに実行させることを特徴とする安全在庫数算出プログラム。 A process for storing the planned consumption number of products for the date earlier than the procurement period in the planned consumption number storage unit for each day;
A process of storing the actual consumption number of the product in the actual consumption number storage unit every day;
Referring to the information stored in the planned consumption number storage unit and the actual consumption number storage unit, the difference value between the actual consumption number and the planned consumption number is calculated for each day in the evaluation period, and the difference value is calculated as the number of procurement days. Executes the process of calculating the added value as a cumulative difference for each day in the evaluation period, calculates the average value and standard deviation value of the cumulative difference for each day in the evaluation period, and calculates the calculated average value of the cumulative difference And a computer for executing a process for calculating a safe stock quantity of a product using a standard deviation value. 調達期間だけ先の日付の商品の消費予定数を日毎に消費予定数記憶部内に記憶する処理と、
前記商品の消費実績数を日毎に消費実績数記憶部内に記憶する処理と、
前記消費予定数記憶部内及び前記消費実績数記憶部内に記憶されている情報を参照して、評価期間内の各日について消費実績数と消費予定数の差分値を算出し、差分値を調達日数分加算した値を累積差として算出する処理を評価期間内の各日について実行し、評価期間内における各日の累積差の平均値と標準偏差値を算出し、
算出された累積差の標準偏差値に安全係数を乗じた数に、算出された累積差の平均値を加算した数と、ゼロとの大きい方を商品の安全在庫数として算出する処理と
をコンピュータに実行させることを特徴とする安全在庫数算出プログラム。 A process for storing the planned consumption number of products for the date earlier than the procurement period in the planned consumption number storage unit for each day;
A process of storing the actual consumption number of the product in the actual consumption number storage unit every day;
Referring to the information stored in the planned consumption number storage unit and the actual consumption number storage unit, the difference value between the actual consumption number and the planned consumption number is calculated for each day in the evaluation period, and the difference value is calculated as the number of procurement days. The process of calculating the value obtained by adding the minutes as a cumulative difference is executed for each day in the evaluation period, and the average value and the standard deviation value of the cumulative difference for each day in the evaluation period are calculated.
A computer that calculates the standard deviation value of the calculated cumulative difference multiplied by the safety factor and adds the average value of the calculated cumulative difference, and the process of calculating the greater of zero as the safety stock number of the product A safety stock quantity calculation program characterized in that the program is executed.
JP2007194221A 2007-07-26 2007-07-26 Safety stock quantity calculation system and safety stock quantity calculation program Expired - Fee Related JP5123592B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2007194221A JP5123592B2 (en) 2007-07-26 2007-07-26 Safety stock quantity calculation system and safety stock quantity calculation program

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP2007194221A JP5123592B2 (en) 2007-07-26 2007-07-26 Safety stock quantity calculation system and safety stock quantity calculation program

Publications (2)

Publication Number Publication Date
JP2009031965A JP2009031965A (en) 2009-02-12
JP5123592B2 true JP5123592B2 (en) 2013-01-23

Family

ID=40402411

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2007194221A Expired - Fee Related JP5123592B2 (en) 2007-07-26 2007-07-26 Safety stock quantity calculation system and safety stock quantity calculation program

Country Status (1)

Country Link
JP (1) JP5123592B2 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20170066303A (en) * 2014-09-30 2017-06-14 미쓰비시덴키 가부시키가이샤 Order number determining method, order number determining apparatus, computer readable recording medium recording an order number determining program, and order number determining program recorded in medium

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105469231A (en) * 2014-09-30 2016-04-06 三菱电机株式会社 Order number decision method and order number decision device

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2003312849A (en) * 2002-04-25 2003-11-06 Hitachi Ltd Stock scheduling method
JP3991811B2 (en) * 2002-08-06 2007-10-17 株式会社日立製作所 Inventory control system and inventory control method

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20170066303A (en) * 2014-09-30 2017-06-14 미쓰비시덴키 가부시키가이샤 Order number determining method, order number determining apparatus, computer readable recording medium recording an order number determining program, and order number determining program recorded in medium
KR102115726B1 (en) * 2014-09-30 2020-05-27 미쓰비시덴키 가부시키가이샤 Order number determining method, order number determining apparatus, computer readable recording medium recording an order number determining program, and order number determining program recorded in medium

Also Published As

Publication number Publication date
JP2009031965A (en) 2009-02-12

Similar Documents

Publication Publication Date Title
Bollerslev et al. A discrete-time model for daily S & P500 returns and realized variations: Jumps and leverage effects
EP1376422A3 (en) System and apparatus for project risk management
JP2009140350A (en) Supply chain evaluation system, method, and program
Dogan Bootstrapping for confidence interval estimation and hypothesis testing for parameters of system dynamics models
Karlsen et al. Management of project contingency and allowance
US20110196718A1 (en) System and method for forecasting in the presence of multiple seasonal patterns in print demand
US8589270B2 (en) Retail planning application and method for consumer products
JP4566980B2 (en) Supply plan formulation system, supply plan formulation program, and supply plan formulation method
Gordon et al. A note: Common due date assignment for a single machine scheduling with the rate-modifying activity
Bayer et al. Balancing work: bidding strategies and workload dynamics in a project‐based professional service organisation
JP5123592B2 (en) Safety stock quantity calculation system and safety stock quantity calculation program
Rebennack et al. Optimal storage design for a multi-product plant: A non-convex MINLP formulation
JP2017070134A (en) Power prediction method
Techt Goldratt and the Theory of Constraints: The Quantum Leap in Management
CN105590260A (en) Time-discontinuous investment quality evaluating method and device
Heer et al. Automation, Economic Growth, and the Labor Share-A Comment on Prettner (2019)
Yimmee et al. Fuzzy goal programming for aggregate production and logistics planning
JP2002012308A (en) Inventory management method
Thomas Scheduling Algorithm with Optimization of Employee Satisfaction
JP2009126621A (en) Proper inventory quantity determination system and its method
US20220051189A1 (en) Automatic negotiation apparatus, automatic negotiation method, and computer-readable recording medium
JP6927553B2 (en) Information processing equipment, control methods, and programs
JP2009173435A (en) System and program for calculating of safe stock quantities
JP6688898B2 (en) Order parameter generation support device and order parameter generation method
JP2006318289A (en) System, method and program for deciding production request quantity by supply-demand balance calculation

Legal Events

Date Code Title Description
A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20100622

A711 Notification of change in applicant

Free format text: JAPANESE INTERMEDIATE CODE: A712

Effective date: 20120111

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20120116

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20120214

A521 Written amendment

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20120322

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20121002

A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20121026

FPAY Renewal fee payment (prs date is renewal date of database)

Free format text: PAYMENT UNTIL: 20151102

Year of fee payment: 3

R150 Certificate of patent (=grant) or registration of utility model

Free format text: JAPANESE INTERMEDIATE CODE: R150

LAPS Cancellation because of no payment of annual fees