JP2003160228A - Product stock monitoring system - Google Patents
Product stock monitoring systemInfo
- Publication number
- JP2003160228A JP2003160228A JP2001359422A JP2001359422A JP2003160228A JP 2003160228 A JP2003160228 A JP 2003160228A JP 2001359422 A JP2001359422 A JP 2001359422A JP 2001359422 A JP2001359422 A JP 2001359422A JP 2003160228 A JP2003160228 A JP 2003160228A
- Authority
- JP
- Japan
- Prior art keywords
- inventory
- shipment
- inventory quantity
- production
- calculating
- 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.)
- Granted
Links
- 238000012544 monitoring process Methods 0.000 title claims abstract description 22
- 238000004519 manufacturing process Methods 0.000 claims abstract description 117
- 238000004364 calculation method Methods 0.000 claims abstract description 50
- 238000013500 data storage Methods 0.000 claims abstract description 20
- 230000007812 deficiency Effects 0.000 claims description 11
- 230000001932 seasonal effect Effects 0.000 claims description 10
- 238000012384 transportation and delivery Methods 0.000 claims description 10
- 238000009472 formulation Methods 0.000 claims description 5
- 239000000203 mixture Substances 0.000 claims description 5
- 239000006185 dispersion Substances 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 10
- 238000013439 planning Methods 0.000 description 6
- 238000012790 confirmation Methods 0.000 description 4
- 238000003860 storage Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 230000002354 daily effect Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 1
- 238000000034 method Methods 0.000 description 1
- 238000004088 simulation Methods 0.000 description 1
- 238000005728 strengthening Methods 0.000 description 1
- 230000007306 turnover Effects 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
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/30—Computing systems specially adapted for manufacturing
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
Description
【０００１】[0001]
【発明の属する技術分野】この発明は、製品の在庫の過
不足を防ぐための製品在庫監視システムに関するもので
ある。BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a product inventory monitoring system for preventing excess or deficiency of product inventory.
【０００２】[0002]
【従来の技術】製品在庫監視システムは、生産・出荷計
画などから製品の将来の在庫数をシミュレーションして
いる。在庫監視者は、在庫の過不足を防止するために、
定期的に在庫数のシミュレーションを行い、生産・出荷
計画を見直している。2. Description of the Related Art A product inventory monitoring system simulates the number of products in stock in the future from a production / shipping plan. The inventory monitor is responsible for preventing excess and deficiency of inventory.
We regularly perform inventory simulations and review production and shipping plans.
【０００３】このように在庫の過不足防止を目的とした
製品在庫監視システムは、現在までに様々提案されてい
る。Various product inventory monitoring systems aimed at preventing excess and deficiency of inventory have been proposed so far.
【０００４】例えば、「経営工学シリーズ１３生産管理
（秋庭雅夫編 日本規格協会）」に記載されている在庫
数の算出方法を利用した従来システムは、需要変動が小
さい製品について、過去の出荷実績と、所定の在庫数を
下回ってから製品が生産され納品されるまでの期間を示
すリードタイムと、ある一定のサービス率とに基づいて
在庫が過剰となったり、在庫が不足したりする恐れの少
ない適正な在庫数を算出することで、在庫過剰や在庫不
足を防止している。For example, the conventional system using the method of calculating the number of stocks described in “Management Engineering Series 13 Production Management (Masao Akiba, Japan Standards Association)” has a past shipment record for products whose demand fluctuations are small. , It is less likely that the inventory will become excessive or insufficient based on the lead time, which indicates the period from the time when the product falls below the specified stock quantity to the time when the product is manufactured and delivered, and a certain service rate. By calculating the appropriate number of stocks, we are preventing excess and shortage of stock.
【０００５】また、特開２０００−１７２７６８号公報
に記載されている従来システムは、需要変動が大きい製
品について、過去の出荷実績とリードタイム中の出荷数
とに基づいて、過去の所定期間における最大および最小
出荷数と１日の平均出荷数とを算出し、それらを基に適
正な在庫数を算出することで、在庫過剰や在庫不足を防
止している。Further, the conventional system described in Japanese Unexamined Patent Publication No. 2000-172768 has a maximum value in a predetermined past period based on the past shipment record and the number of shipments during the lead time for a product having a large demand fluctuation. Also, the minimum shipment number and the average daily shipment number are calculated, and the appropriate inventory number is calculated based on them, thereby preventing an excess inventory or an inventory shortage.
【０００６】[0006]
【発明が解決しようとする課題】従来の製品在庫監視シ
ステムは以上のように、需要変動の小さい製品を対象に
すると、需要変動の大きい製品は、担当者の経験から適
正な在庫数を設定していた。したがって、担当者によっ
てバラツキがあったり、在庫不足を防ぐために在庫数を
多めに設定することで在庫過剰を招いたりするという問
題点があった。As described above, in the conventional product inventory monitoring system, when a product with a small demand fluctuation is targeted, the product with a large demand fluctuation is set with an appropriate inventory quantity based on the experience of the person in charge. Was there. Therefore, there is a problem in that there is variation depending on the person in charge, or excess stock is caused by setting a large number of stocks to prevent stock shortage.
【０００７】また、従来の製品在庫監視システムは、過
去の出荷実績などから在庫数を設定するので、設定条件
に需要見込みや販売強化施策などの生産・出荷計画時の
条件が考慮されていない。このような生産・出荷計画時
の条件によって需要変動が変わると、過去の出荷実績な
どからでは対応できずに在庫過剰や在庫不足を招くとい
う問題点があった。Further, in the conventional product inventory monitoring system, the number of stocks is set based on the past shipment record and the like, so that the setting conditions do not take into consideration the conditions such as demand forecast and sales strengthening policy at the time of production / shipment planning. If demand fluctuations are caused by such conditions at the time of production / shipment planning, there is a problem in that the past shipping record or the like cannot be dealt with, resulting in excess inventory or insufficient inventory.
【０００８】この発明は上記のような問題点を解決する
ためになされたもので、担当者の経験度による在庫数の
バラツキを無くし、さらに生産・出荷計画時の条件によ
る需要変動の変化に対応した確度の高い適正な在庫数を
算出することのできる製品在庫監視システムを得ること
を目的とする。The present invention has been made to solve the above problems, eliminates the variation in the number of stocks due to the experience of the person in charge, and responds to changes in demand fluctuations due to conditions at the time of production / shipment planning. It is an object of the present invention to obtain a product inventory monitoring system capable of calculating an appropriate inventory quantity with high accuracy.
【０００９】[0009]
【課題を解決するための手段】この発明に係る製品在庫
監視システムは、製品の在庫数を管理する製品在庫監視
システムにおいて、過去の出荷実績を記憶する出荷デー
タ記憶手段と、生産・出荷計画の策定から納品までのリ
ードタイム情報を設定するリードタイムマスタ設定手段
と、季節変動のある製品の季節変動情報を設定するシー
ズン期間設定手段と、生産・出荷計画で決定した出荷計
画数を記録する生産・出荷計画・在庫データ記憶手段
と、出荷実績、リードタイム情報および季節変動情報に
基づいて、出荷実績の出荷統計を算出する出荷統計計算
手段と、出荷統計、リードタイム情報および季節変動情
報に基づいて、生産・出荷計画における基準在庫数を算
出する基準在庫数計算手段と、出荷統計における基準在
庫数の占める比率を算出する基準在庫比率計算手段と、
出荷計画数に比率を加えた適正在庫数を算出する適正在
庫数計算手段と、適正在庫数の許容値を設定する在庫許
容台数設定手段と、許容値から適正在庫数の許容範囲を
算出する上限・下限適正在庫数計算手段とを備えたもの
である。SUMMARY OF THE INVENTION A product inventory monitoring system according to the present invention is a product inventory monitoring system for managing the number of products in stock, and a shipment data storage means for storing past shipment records and a production / shipping plan. Lead time master setting means to set lead time information from formulation to delivery, season period setting means to set seasonal variation information for products with seasonal variation, and production to record the number of shipment plans determined by the production / shipping plan.・ Shipping plan / inventory data storage means, shipping statistical calculation means for calculating shipping statistics of shipping results based on shipping results, lead time information and seasonal fluctuation information, and based on shipping statistics, lead time information and seasonal fluctuation information The standard inventory quantity calculation method that calculates the standard inventory quantity in the production / shipping plan and the ratio of the standard inventory quantity in the shipping statistics. And standard inventory ratio calculation means for output,
Appropriate inventory quantity calculation means for calculating the appropriate inventory quantity by adding the ratio to the planned shipment quantity, inventory allowance number setting means for setting the acceptable value of the appropriate inventory quantity, and upper limit for calculating the acceptable range of the appropriate inventory quantity from the acceptable value・ It is equipped with a lower limit appropriate inventory quantity calculation means.
【００１０】また、この発明に係る製品在庫監視システ
ムの基準在庫数計算手段は、生産・出荷計画を策定する
周期での在庫数に対応する生産サイクル在庫数を算出す
る生産サイクル在庫数計算手段と、生産・出荷計画から
出荷までの出荷変動数に対応する変動在庫数を算出する
変動在庫数計算手段と、出荷から納品までの期間中に存
在する在庫数に対応する輸送期間在庫数を算出する輸送
期間在庫数計算手段とを有し、生産サイクル在庫数、変
動在庫数および輸送期間在庫数に基づいて基準在庫数を
算出するものである。Further, the reference inventory quantity calculating means of the product inventory monitoring system according to the present invention is a production cycle inventory quantity calculating means for calculating a production cycle inventory quantity corresponding to the inventory quantity in a cycle for formulating a production / shipping plan. , A variable inventory quantity calculation method that calculates the variable inventory quantity corresponding to the shipment fluctuation quantity from the production / shipping plan to the shipment, and the transportation period inventory quantity corresponding to the inventory quantity that exists during the period from shipment to delivery And a transportation period inventory quantity calculating means, and calculates the reference inventory quantity based on the production cycle inventory quantity, the variable inventory quantity, and the transportation period inventory quantity.
【００１１】また、この発明に係る製品在庫監視システ
ムは、許容範囲に該当しない製品の適正在庫数を自動出
力する在庫過不足計算出力手段を備えたものである。Further, the product inventory monitoring system according to the present invention is provided with an inventory excess / deficiency calculation output means for automatically outputting the proper inventory quantity of the products which do not fall within the allowable range.
【００１２】[0012]
【発明の実施の形態】実施の形態１．以下、図面を参照
しながら、この発明の実施の形態１について詳細に説明
する。図１はこの発明の実施の形態１を示すブロック構
成図である。BEST MODE FOR CARRYING OUT THE INVENTION Embodiment 1. Hereinafter, Embodiment 1 of the present invention will be described in detail with reference to the drawings. 1 is a block diagram showing a first embodiment of the present invention.
【００１３】図１において、製品在庫監視システムは、
過去の出荷実績を記録する出荷データ記憶手段１と、生
産・出荷計画の策定から納品までの期間を示すリードタ
イム中の情報（リードタイム情報）を設定するリードタ
イムマスタ設定手段２と、シーズン性のある製品の需要
変動を考慮して繁忙期と閑散期との生産開始月および終
了月を設定するシーズン期間設定手段３とを備えてい
る。In FIG. 1, the product inventory monitoring system is
Shipping data storage means 1 for recording past shipping results, lead time master setting means 2 for setting information (lead time information) during lead time indicating a period from formulation of a production / shipping plan to delivery, and seasonality And a season period setting means 3 for setting a production start month and a production end month in a busy period and a quiet period in consideration of demand fluctuations of certain products.
【００１４】また、生産・出荷計画で決定した生産計画
数や出荷計画数および現在の在庫数を記録する生産・出
荷計画・在庫データ記憶手段４と、適正な在庫数（適正
在庫数）の上限および下限値を設定する在庫許容台数設
定手段５とを備えている。Further, the production / shipping plan / inventory data storage means 4 for recording the number of production plans and the number of shipment plans determined in the production / shipping plan, and the current inventory quantity, and the upper limit of the appropriate inventory quantity (appropriate inventory quantity) And an allowable inventory number setting means 5 for setting a lower limit value.
【００１５】また、過去の出荷実績などから繁忙期と閑
散期との統計値を算出する出荷統計計算手段６と、生産
・出荷計画での条件をまとめた基準在庫数を算出する基
準在庫数計算手段７と、統計値において基準在庫数の占
める比率を算出する基準在庫比率計算手段８とを備えて
いる。Further, a shipping statistical calculation means 6 for calculating statistical values of the busy period and the off-season based on past shipping results, and a standard inventory quantity calculation for calculating a standard inventory quantity summarizing conditions in the production / shipping plan. It is provided with a means 7 and a reference inventory ratio calculating means 8 for calculating the ratio of the reference inventory number in the statistical value.
【００１６】また、生産・出荷計画で決定した出荷計画
数に基準在庫数の比率を加えた適正在庫数を算出する適
正在庫数計算手段９と、上限値と下限値とに基づいて、
適正在庫数の許容範囲を算出する上限・下限適正在庫数
計算手段１０とを備えている。Further, based on the appropriate inventory quantity calculating means 9 for calculating the appropriate inventory quantity by adding the ratio of the standard inventory quantity to the shipment schedule quantity determined in the production / shipping plan, and the upper limit value and the lower limit value,
An upper limit / lower limit appropriate inventory quantity calculating means 10 for calculating an allowable range of the appropriate inventory quantity is provided.
【００１７】さらに、適正在庫数の許容範囲外となる在
庫過剰または在庫不足の製品を判定して、該当する製品
を自動表示する在庫過不足計算出力手段１１とを備えて
いる。Further, there is provided an inventory excess / insufficiency calculation output means 11 for determining an excess inventory inventory or an inventory inventory which is out of the allowable range of the appropriate inventory quantity and automatically displaying the relevant product.
【００１８】また、基準在庫数計算手段７は、生産サイ
クル在庫数計算手段７１と、変動在庫数計算手段７２
と、輸送期間在庫数計算手段７３とを有しており、生産
・出荷計画においての条件を在庫数（基準在庫数）に換
算した値を算出する。The standard inventory quantity calculating means 7 includes a production cycle inventory quantity calculating means 71 and a variable inventory quantity calculating means 72.
And a transportation period inventory quantity calculation means 73, which calculates a value obtained by converting the conditions in the production / shipping plan into the inventory quantity (standard inventory quantity).
【００１９】次に、図１とともに、図２を参照しなが
ら、この発明の実施の形態１による動作について説明す
る。Next, referring to FIG. 2 together with FIG. 1, the operation according to the first embodiment of the present invention will be described.
【００２０】製品の生産・出荷計画を立てるときには、
生産・出荷計画を立てる（見直す）周期と、計画を立て
て生産されるまでの期間と、出荷から納品までの期間と
の３つの期間（周期）を考慮し、各期間中に必要な在庫
数を算出する。When making a product production / shipment plan,
The number of inventories required during each period, considering the three periods (cycles) of the production / shipment planning (review) cycle, the period until production is planned, and the shipment to delivery period. To calculate.
【００２１】図２において、生産・出荷計画を立てる周
期を生産サイクル、計画を立ててから実際に生産される
までの期間を生産・出荷計画確定期間、出荷から納品ま
での期間を輸送期間と呼んでいる。In FIG. 2, a cycle for making a production / shipping plan is called a production cycle, a period from making a plan to actual production is called a production / shipping plan fixing period, and a period from shipping to delivery is called a transportation period. I'm out.
【００２２】例えば、生産サイクルを１週間、生産・出
荷計画確定期間を３週間、輸送期間を３日とすると、Ｎ
月の第２週に立てられた生産・出荷計画に基づいた製品
は、Ｎ＋１月の第１週の週始めから３日後に各代理店に
納品されることとなる。この生産プロセスは、１週間お
きに行われ、各代理店などへ製品が随時納品される。For example, if the production cycle is 1 week, the production / shipping plan confirmation period is 3 weeks, and the transportation period is 3 days, then N
Products based on the production / shipping plan established in the second week of the month will be delivered to each agency three days after the start of the week of the first week of N + 1 January. This production process is performed every other week, and the products are delivered to each agency or the like at any time.
【００２３】このような日々の出荷データは、製品別に
出荷データ記憶手段１に毎日蓄積され、さらに、週単位
および月単位に換算して蓄積される。なお、蓄積された
出荷データはユーザが任意に検索することができる。Such daily shipping data is stored in the shipping data storage means 1 for each product every day, and further converted into weekly and monthly units and stored. The user can arbitrarily search the stored shipping data.
【００２４】リードタイムマスタ設定手段２は、製品別
に生産サイクルと生産・出荷計画確定期間と輸送期間と
を設定する。The lead time master setting means 2 sets a production cycle, a production / shipping plan decision period, and a transportation period for each product.
【００２５】シーズン期間設定手段３は、例えば、エア
コンのように季節性（シーズン性）が高い製品変動を考
慮することができる繁忙期および閑散期の生産開始月お
よび終了月を製品別に設定する。The season period setting means 3 sets, for each product, a production start month and a production end month in a busy period and a quiet period in which, for example, a product variation having a high seasonality (seasonality) such as an air conditioner can be taken into consideration.
【００２６】生産・出荷計画・在庫データ記憶手段４
は、外部の記憶装置から転送され、前もって計画された
生産計画数および出荷計画数と現在の在庫数とを製品別
に記憶する。Production / shipping plan / stock data storage means 4
Is transferred from an external storage device and stores the number of production plans and the number of shipments planned in advance and the current number of stocks for each product.
【００２７】在庫許容台数設定手段５は、繁忙期および
閑散期の各月における適正な在庫数（適正在庫数）の上
限および下限許容値を製品別に設定する。または、適正
在庫数の割合（上限および下限許容割合値）で設定す
る。The allowable inventory quantity setting means 5 sets the upper and lower limit allowable values of the appropriate inventory quantity (appropriate inventory quantity) in each month of the busy season and the off season, for each product. Alternatively, it is set by the ratio of the appropriate inventory quantity (upper limit and lower limit allowable ratio value).
【００２８】出荷統計計算手段６は、製品出荷データ記
憶手段１からの過去の出荷データ（出荷実績）から、繁
忙期および閑散期の生産月における一月分の出荷数の平
均値（一月分の平均出荷数）と、標準偏差とを算出す
る。The shipment statistical calculation means 6 uses the past shipment data (shipping results) from the product shipment data storage means 1 to calculate the average value of the number of shipments for one month in the production months in the busy season and the off season (for one month). The average number of shipments) and the standard deviation are calculated.
【００２９】基準在庫数計算手段７内の生産サイクル在
庫数計算手段７１は、（１）式によって、平均出荷数か
ら繁忙期および閑散期における生産サイクル分の出荷数
（生産サイクル在庫数）を算出する。The production cycle inventory quantity calculating means 71 in the standard inventory quantity calculating means 7 calculates the shipment quantity (production cycle inventory quantity) for the production cycle in the busy period and the off season from the average shipment quantity by the equation (1). To do.
【００３０】 生産サイクル在庫数＝平均出荷数×生産サイクル ・・・ （１）[0030] Production Cycle Inventory = Average Shipment x Production Cycle (1)
【００３１】変動在庫数計算手段７２は、（２）式によ
って、標準偏差から繁忙期および閑散期における生産・
出荷計画確定期間中の出荷変動に対応する在庫数（変動
在庫数）を算出する。The variable inventory quantity calculating means 72 calculates the standard deviation from the standard deviation according to the equation (2) during the busy season and the off season.
Calculate the inventory quantity (variable inventory quantity) corresponding to shipment fluctuations during the shipment plan finalization period.
【００３２】 変動在庫数＝標準偏差×生産・出荷計画確定期間 ・・・ （２）[0032] Fluctuating inventory = standard deviation x production / shipping plan finalization period (2)
【００３３】輸送期間在庫数計算手段７３は、（３）式
によって、平均出荷数から繁忙期および閑散期における
工場から代理店までの輸送期間中に存在する在庫数（輸
送期間在庫数）を算出する。The transportation period inventory quantity calculating means 73 calculates the inventory quantity (transportation inventory quantity) existing from the average shipment quantity during the transportation period from the factory to the agent in the busy season and the off season from the average shipment quantity by the equation (3). To do.
【００３４】 輸送期間在庫数＝平均出荷数×輸送期間 ・・・ （３）[0034] Transportation period Number of stocks = average number of shipments × transportation period (3)
【００３５】最後に、生産サイクル在庫数と変動在庫数
と輸送期間在庫数との総和により、生産・出荷計画の条
件を在庫数に換算した繁忙期および閑散期における基準
在庫数を算出する。Finally, the reference inventory quantity in the busy period and the off-season is calculated by converting the production / shipping plan conditions into the inventory quantity by the sum of the production cycle inventory quantity, the variable inventory quantity, and the transportation period inventory quantity.
【００３６】 基準在庫数＝生産サイクル在庫数＋変動在庫数＋輸送期間在庫数 ・・・ （４）[0036] Standard inventory quantity = production cycle inventory quantity + variable inventory quantity + transportation period inventory quantity (4)
【００３７】基準在庫比率計算手段８は、（５）式によ
って、基準在庫数および平均出荷数から、平均出荷数に
おける基準在庫数の比率（基準在庫比率）を算出する。The standard stock ratio calculating means 8 calculates the ratio of the standard stock quantity in the average shipment quantity (standard stock ratio) from the standard stock quantity and the average shipment quantity by the equation (5).
【００３８】 基準在庫比率＝基準在庫数÷平均出荷数 ・・・ （５）[0038] Standard inventory ratio = standard inventory quantity / average shipment quantity (5)
【００３９】適正在庫数計算手段９は、（６）式によっ
て、基準在庫比率および出荷計画数から、出荷計画数に
基準在庫比率を加味した繁忙期および閑散期の各月にお
ける適正在庫数を算出する。なお、（６）式中の出荷計
画数は、生産・出荷計画・在庫データ記憶手段４に記録
されている値とする。The appropriate stock quantity calculating means 9 calculates the appropriate stock quantity in each month of the busy season and the off season by adding the standard stock ratio to the shipment plan quantity from the standard stock ratio and the shipment plan quantity by the formula (6). To do. The planned shipping quantity in the equation (6) is a value recorded in the production / shipping planning / stock data storage means 4.
【００４０】 適正在庫数＝基準在庫比率×出荷計画数 ・・・ （６）[0040] Appropriate inventory quantity = standard inventory ratio x planned shipment quantity (6)
【００４１】上限・下限適正在庫数計算手段１０は、
（７）式および（８）式によって、適正在庫数と上限ま
たは下限許容値とから、上限値と下限値とを算出し、繁
忙期および閑散期の各月における適正在庫数の許容範囲
を決定する。The upper limit / lower limit proper inventory quantity calculating means 10 is
Using equations (7) and (8), the upper and lower limits are calculated from the appropriate stock quantity and the upper or lower limit allowable value, and the allowable range of the appropriate stock quantity in each month of the busy season and the off season is determined. To do.
【００４２】 上限適性在庫数＝適正在庫数＋上限許容値 ・・・ （７） 下限適性在庫数＝適正在庫数−下限許容値 ・・・ （８）[0042] Upper-appropriate inventory quantity = appropriate inventory quantity + upper-limit allowable value (7) Lower limit appropriate inventory number = appropriate inventory number-lower limit allowable value (8)
【００４３】在庫過不足計算・出力手段１１は、（９）
式によって、生産計画数と出荷計画数と現在の在庫数と
から、一定期間における生産サイクル毎の予測在庫数
（在庫推移）を算出する。The inventory excess / deficiency calculation / output means 11 is (9)
From the number of production plans, the number of shipment plans, and the current number of stocks, the formula is used to calculate the predicted number of stocks (change in stock) for each production cycle in a certain period.
【００４４】 予測在庫数k＝予測在庫数k-1＋生産計画数k−出荷計画数k ・・・ （９） （ｋ＝日、週、月などの生産サイクル、予測在庫数0＝現在の在庫数）Predicted inventory number k = Predicted inventory number k-1 + Production plan number k -Delivery plan number k (9) (k = Production cycle such as day, week, month, forecasted inventory number 0 = current Stock number)
【００４５】なお、予測在庫数の算出期間（一定期間）
は、生産・出荷計画策定期間としてもよいし、半期の期
間としてもよい。Note that the forecast inventory quantity calculation period (fixed period)
May be a production / shipping plan formulation period or a half-year period.
【００４６】また、予測在庫数の算出サイクルは、各製
品の最短の生産サイクルに合わせて算出される。Further, the calculation cycle of the predicted inventory quantity is calculated in accordance with the shortest production cycle of each product.
【００４７】例えば、生産サイクルを１週間とし、Ｎ月
の第ｋ週の予測在庫数を算出する場合、Ｎ月の第ｋ週の
生産計画数と出荷計画数との差に、第ｋ−１週（前週）
の在庫数（予測在庫数または現在の在庫数）を加えたも
のである。For example, if the production cycle is set to one week and the forecast inventory quantity for the kth week of N month is calculated, the difference between the production plan quantity and the shipment plan quantity for the kth week of N month is calculated by k-1. Week (previous week)
The stock quantity (predicted stock quantity or current stock quantity) is added.
【００４８】続いて、生産サイクル毎に算出された予測
在庫数が、適正在庫数の許容範囲内であることを確認す
る。Then, it is confirmed that the predicted inventory quantity calculated for each production cycle is within the allowable range of the appropriate inventory quantity.
【００４９】ある生産サイクルにおいて、予測在庫数が
適正在庫数の許容範囲外となった場合には、その製品の
生産計画または出荷計画の見直しが必要と判断される。
計画の見直しが必要な製品は、見直し検討の材料とし
て、繁忙期および閑散期での出荷計画数と生産計画数と
予測在庫数とを所定の格納場所に出力する。In a certain production cycle, when the predicted stock quantity is out of the allowable range of the proper stock quantity, it is judged that the production plan or the shipping plan of the product needs to be reviewed.
For products that require a plan review, the number of shipment plans, the number of production plans, and the number of forecast stocks in the busy season and the off season are output to a predetermined storage location as a material for review and examination.
【００５０】次に、図３から図９を参照しながら、具体
的な事例を挙げて、この発明の実施の形態１による動作
について説明する。図３から図９は、この発明の実施の
形態１に係るデータを示す説明図である。Next, referring to FIGS. 3 to 9, the operation according to the first embodiment of the present invention will be described by taking a concrete example. 3 to 9 are explanatory views showing data according to the first embodiment of the present invention.
【００５１】例えば、製品Ａの在庫数を監視する場合、
まず、リードタイムマスタ設定手段２に生産サイクル、
生産・出荷計画確定期間、輸送期間を設定する。例え
ば、生産サイクルを週１回（換言すると月４回）、生産
・出荷計画確定期間を３週間、輸送期間を３日間とす
る。For example, when monitoring the stock quantity of product A,
First, the lead time master setting means 2
Set the production / shipment plan confirmation period and transportation period. For example, the production cycle is once a week (in other words, four times a month), the production / shipping plan confirmation period is 3 weeks, and the transportation period is 3 days.
【００５２】各期間は、月数に換算して設定するので、
一月を「１」、一月を４週とすると、図３のように、週
１回は「０．２５」、３週間は「０．７５」に換算して
設定する。さらに、３日間は、月の実動日数を２１日と
すると、「０．１５（３÷２１＝０．１５）」に換算し
て設定する。Since each period is set in terms of months,
Assuming that January is “1” and January is 4 weeks, as shown in FIG. 3, it is set by converting into “0.25” once a week and “0.75” for 3 weeks. Further, three days are set by converting into “0.15 (3 ÷ 21 = 0.15)” when the number of actual working days of the month is 21 days.
【００５３】シーズン期間設定手段３は、季節によって
需要変動の高い製品を考慮できるように、１年を繁忙期
と閑散期とに分けて、それぞれの生産開始月と生産終了
月とを設定する。The season period setting means 3 divides one year into a busy period and a quiet period, and sets a production start month and a production end month so that a product with a high demand fluctuation depending on the season can be taken into consideration.
【００５４】例えば、図４において、繁忙期の生産開始
月を４月、生産終了月を７月と設定する。また、閑散期
については、生産開始月を８月、生産終了月を３月とい
うように設定する。なお、ここでは、繁忙期についての
み説明を行い、閑散期については説明を省略する。For example, in FIG. 4, the production start month in the busy season is set to April and the production end month is set to July. Also, for the off-season, the production start month is set to August, and the production end month is set to March. In addition, here, only the busy season will be described, and the description of the off-season will be omitted.
【００５５】在庫許容台数設定手段５は、生産・出荷計
画見直しの判断基準となる適正在庫数の上限・下限許容
値を設定する。上限・下限許容値は、製品の台数をその
まま設定するか、図５のように適正在庫数を基準にした
割合（％、上限・下限許容割合値）で設定することもで
きる。例えば、適正在庫数が小さい場合には、台数をそ
のまま設定するとよい。The allowable inventory quantity setting means 5 sets the upper and lower limit allowable values of the appropriate inventory quantity which serves as a criterion for reviewing the production / shipping plan. The upper limit / lower limit allowable value can be set as the number of products as it is, or can be set as a ratio (%, upper limit / lower limit allowable ratio value) based on the appropriate inventory quantity as shown in FIG. For example, when the appropriate stock quantity is small, the quantity may be set as it is.
【００５６】ここでは、適正在庫数に１５％加えた値を
上限とし、適正在庫数から２０％引いた値を下限とす
る。Here, the upper limit is a value obtained by adding 15% to the proper stock quantity, and the lower limit is a value obtained by subtracting 20% from the proper stock quantity.
【００５７】以上の設定内容と、出荷データ記憶手段１
に記憶された過去の出荷データと、生産・出荷計画・在
庫データ記憶手段４に記憶された計画内容および現在の
在庫数とに基づいて、製品別の在庫予測と在庫過不足と
の判定とを行う。The above setting contents and shipping data storage means 1
Based on the past shipment data stored in, the plan contents stored in the production / shipping plan / inventory data storage means 4 and the current number of stocks, inventory prediction for each product and determination of excess or deficiency of inventory are performed. To do.
【００５８】まず、出荷統計計算手段６は、製品Ａの過
去の４月から７月までにおける一月当りの平均出荷数と
標準偏差とを算出する。ここでは、平均出荷数を「１２
１」、標準偏差を「４１」とする。First, the shipment statistics calculation means 6 calculates the average number of shipments and standard deviation of product A per month from April to July in the past. Here, the average number of shipments is "12
1 ”and the standard deviation is“ 41 ”.
【００５９】基準在庫数計算手段７は、製品Ａの生産サ
イクル在庫数と変動在庫数と輸送在庫数とを算出し、在
庫数の総和から基準在庫数を算出する。The standard inventory quantity calculating means 7 calculates the production cycle inventory quantity, the variable inventory quantity, and the transportation inventory quantity of the product A, and calculates the standard inventory quantity from the total of the inventory quantities.
【００６０】まず、生産サイクル在庫計算手段７１は、
出荷統計計算手段６で算出した平均出荷数と、リードタ
イムマスタ設定手段２で設定した生産サイクルとを
（１）式に代入し、（１０）式のように生産サイクル在
庫数を算出する。なお、小数点以下は切り上げる。First, the production cycle inventory calculation means 71
The average shipment quantity calculated by the shipment statistics calculation means 6 and the production cycle set by the lead time master setting means 2 are substituted into the equation (1), and the production cycle inventory quantity is calculated according to the equation (10). Round up the number after the decimal point.
【００６１】 １２１×０．２５ ≒ ３１ ・・・（１０）[0061] 121 × 0.25 ≈ 31 (10)
【００６２】次に、変動在庫数計算手段７２は、出荷統
計計算手段６で算出した標準偏差と、リードタイムマス
タ設定手段２で設定した生産・出荷計画確定期間とを
（２）式に代入し、（１１）式のように変動在庫数を算
出する。なお、小数点以下は切り上げる。Next, the variable inventory quantity calculating means 72 substitutes the standard deviation calculated by the shipping statistics calculating means 6 and the production / shipping plan fixed period set by the lead time master setting means 2 into the equation (2). , The variable stock quantity is calculated as in equation (11). Round up the number after the decimal point.
【００６３】 ４１×０．７５ ≒ ３１ ・・・（１１）[0063] 41 × 0.75 ≈ 31 (11)
【００６４】次に、輸送期間在庫数計算手段７３は、出
荷統計計算手段６で算出した平均出荷数と、リードタイ
ムマスタ設定手段２で設定した輸送期間とを（３）式に
各値を代入すると、（１２）式のように輸送期間在庫数
を算出する。なお、小数点以下は切り上げる。Next, the transportation period inventory quantity calculation means 73 substitutes each value into the equation (3) for the average shipment quantity calculated by the shipment statistics calculation means 6 and the transportation time period set by the lead time master setting means 2. Then, the transportation period inventory quantity is calculated as in the equation (12). Round up the number after the decimal point.
【００６５】 １２１×０．１５ ≒ １９ ・・・（１２）[0065] 121 × 0.15 ≈ 19 (12)
【００６６】以上の３種の在庫数を足して、基準在庫数
を算出する。（１３）式のように、製品Ａの繁忙期にお
ける基準在庫数は、「８１」となる。The standard stock quantity is calculated by adding the above three kinds of stock quantities. As in the equation (13), the standard inventory quantity of the product A in the busy season is “81”.
【００６７】 ３１＋３１＋１９ ＝ ８１ ・・・（１３）[0067] 31 + 31 + 19 = 81 (13)
【００６８】基準在庫比率計算手段８は、基準在庫数計
算手段６で算出された基準在庫数と、出荷統計計算手段
６で算出された平均出荷数とを（５）式に代入し、（１
４）式のように基準在庫比率を算出する。なお、小数点
第２位以下は四捨五入する。The standard stock ratio calculation means 8 substitutes the standard stock quantity calculated by the standard stock quantity calculation means 6 and the average shipment quantity calculated by the shipment statistics calculation means 6 into the equation (5), and (1)
The standard stock ratio is calculated as in equation 4). Round off to the second decimal place.
【００６９】 ８１÷１２１ ≒ ０．６７ ・・・（１４）[0069] 81 ÷ 121 ≈ 0.67 (14)
【００７０】以上の出荷統計計算手段４と、基準在庫数
計算手段５と、基準在庫比率計算手段６とで算出された
各種データを図６に示す。FIG. 6 shows various data calculated by the shipping statistics calculating unit 4, the standard inventory quantity calculating unit 5, and the standard inventory ratio calculating unit 6.
【００７１】続いて、適正在庫数計算手段９は、生産・
出荷計画・在庫データ記憶手段４に記憶された各月の出
荷計画数と、基準在庫比率計算手段６で算出された基準
在庫比率とを（６）式に代入し、繁忙期における各月の
適正在庫数を算出する。４月から７月の繁忙期における
適正在庫数は、（１５）式から（１８）式のように算出
される。なお、小数点以下は切り上げる。Then, the appropriate inventory quantity calculating means 9
The planned shipment number for each month stored in the shipping plan / inventory data storage means 4 and the standard inventory ratio calculated by the standard inventory ratio calculating means 6 are substituted into the equation (6), and the appropriateness of each month during the busy season is calculated. Calculate the inventory quantity. The proper stock quantity during the busy season from April to July is calculated from the equations (15) to (18). Round up the number after the decimal point.
【００７２】 １０００×０．６７ ＝ ６７０ ・・・（１５） １２００×０．６７ ＝ ８０４ ・・・（１６） １５００×０．６７ ＝ １００５ ・・・（１７） ８００×０．６７ ＝ ５３６ ・・・（１８）[0072] 1000 × 0.67 = 670 (15) 1200 × 0.67 = 804 (16) 1500 × 0.67 = 1005 (17) 800 x 0.67 = 536 (18)
【００７３】図７に、製品Ａの繁忙期における各月の出
荷計画数と適正在庫数とを示す。FIG. 7 shows the number of shipment plans and the number of appropriate stocks of the product A in each busy month.
【００７４】上限・下限適正在庫数計算手段１０は、適
正在庫数計算手段９で算出された適正在庫数と、在庫許
容台数設定手段５で設定された上限および下限許容割合
値とに基づいて、適正在庫数の許容範囲を決定する。The upper limit / lower limit proper inventory quantity calculating means 10 is based on the proper inventory quantity calculated by the proper inventory quantity calculating means 9 and the upper limit and lower limit acceptable ratio values set by the allowable inventory quantity setting means 5. Determine the acceptable inventory range.
【００７５】図５のように、在庫許容台数設定手段５で
は、上限許容割合値および下限許容割合値（パーセン
ト）で設定したので、例えば、４月の適正在庫数におけ
る上限および下限許容値は、（１９）式、（２０）式の
ように、適正在庫数に上限許容割合値または下限許容割
合値をそれぞれ乗じた値とする。なお、小数点以下は切
り上げる。As shown in FIG. 5, the allowable inventory number setting means 5 sets the upper limit allowable ratio value and the lower limit allowable ratio value (percentage). As in equations (19) and (20), the appropriate stock quantity is multiplied by the upper limit allowable ratio value or the lower limit allowable ratio value. Round up the number after the decimal point.
【００７６】 ６７０×０．１５ ≒ １０１ ・・・（１９） ６７０×０．２０ ＝ １３４ ・・・（２０）[0076] 670 × 0.15 ≈ 101 (19) 670 × 0.20 = 134 (20)
【００７７】そして、適正在庫数に上限許容値を加え
て、適正在庫数の上限値（上限適正在庫数）を算出す
る。また、適正在庫数から下限許容値を引いて、適正在
庫数の下限値（下限適正在庫数）を算出する。Then, the upper limit allowable value is added to the proper stock quantity to calculate the upper limit value of the proper stock quantity (upper proper stock quantity). Further, the lower limit allowable value is subtracted from the appropriate inventory quantity to calculate the lower limit value of the appropriate inventory quantity (lower limit appropriate inventory quantity).
【００７８】 ６７０＋１０１ ＝ ７７１ ・・・（２１） ６７０−１３４ ＝ ５３６ ・・・（２２）[0078] 670 + 101 = 771 ... (21) 670-134 = 536 ... (22)
【００７９】このような方法で、残りの５月から７月に
ついても上限適正在庫と下限適正在庫とを算出し、繁忙
期における各月の適正在庫数の許容範囲を決定する。図
８に、繁忙期における各月の上限適正在庫数と下限適正
在庫数とを示す。In this manner, the upper limit appropriate inventory and the lower limit appropriate inventory are calculated for the remaining May to July, and the allowable range of the appropriate inventory number of each month in the busy season is determined. FIG. 8 shows the upper limit appropriate inventory number and the lower limit appropriate inventory number for each month during the busy season.
【００８０】在庫過不足計算出力手段１１は、生産・出
荷計画・在庫データ記憶手段４に格納されている繁忙期
における各月の生産計画数、出荷計画数、現在の在庫数
に基づいて、一定期間における生産サイクル毎の在庫予
測（予測在庫数）を算出する。The inventory excess / deficiency calculation output means 11 is constant based on the number of production plans, the number of shipment plans, and the current inventory quantity stored in the production / shipping plan / inventory data storage means 4 for each month during the busy season. Inventory forecast (predicted inventory quantity) is calculated for each production cycle during the period.
【００８１】続いて、予測在庫数が適正在庫数の許容範
囲の範囲内であることを確認し、範囲外の製品について
は、繁忙期直前の在庫数および、繁忙期の生産サイクル
における生産計画数と出荷計画数と在庫予測とを所定の
格納場所に出力する。Next, it is confirmed that the predicted inventory quantity is within the allowable range of the appropriate inventory quantity, and for products outside the range, the inventory quantity immediately before the busy season and the planned production quantity in the production cycle during the busy season. And the planned shipment quantity and the stock forecast are output to a predetermined storage location.
【００８２】例えば、４月第１週の予測在庫数は、（２
３）式のように、４月第１週の生産計画数および出荷計
画数の差分を、３月末の在庫数に加えた値である。For example, the forecast stock quantity for the first week of April is (2
It is a value obtained by adding the difference between the number of production plans and the number of shipment plans for the first week of April to the number of stocks at the end of March, as shown in formula 3).
【００８３】 ７３０＋（３００−２６０） ＝ ７７０ ・・・（２３）[0083] 730+ (300-260) = 770 ... (23)
【００８４】同様に、４月第２週の在庫予測は、（２
４）式のように、４月第１週の在庫予測に、４月第２週
の生産計画数および出荷計画数の差分を加えた値であ
る。Similarly, the inventory forecast for the second week of April is (2
It is a value obtained by adding the difference between the number of production plans and the number of shipment plans for the second week of April to the stock forecast for the first week of April as shown in formula (4).
【００８５】 ７７０＋（２００−２４０） ＝ ７３０ ・・・（２４）[0085] 770+ (200-240) = 730 ... (24)
【００８６】このように、繁忙期の生産サイクルにおけ
る予測在庫数を算出する。図９に、製品Ａの４月の生産
・出荷確定期間における生産サイクル毎の在庫予測（予
測在庫数）を示す。In this way, the estimated stock quantity in the busy production cycle is calculated. FIG. 9 shows the inventory forecast (predicted inventory quantity) for each production cycle of the production / shipping confirmation period of the product A in April.
【００８７】次に、各予測在庫数と、各月の適正在庫数
の許容範囲とを比較して、許容範囲内に収まっているか
どうか確認する。Next, each predicted stock quantity is compared with the allowable range of the appropriate stock quantity of each month, and it is confirmed whether or not the quantity is within the allowable range.
【００８８】例えば、４月第１週の予測在庫数と適正在
庫数の許容範囲とを比較すると、予測在庫数は「７７
０」、上限適正在庫数は「７７１」、下限適正在庫は
「５３６」であり、予測在庫数は範囲内であることがわ
かる。For example, comparing the forecast stock quantity in the first week of April with the allowable range of the proper stock quantity, the forecast stock quantity is "77".
0 ”, the upper limit appropriate inventory number is“ 771 ”, the lower limit appropriate inventory number is“ 536 ”, and it can be seen that the predicted inventory number is within the range.
【００８９】４月第３週の予測在庫数と適正在庫数の許
容範囲とを比較すると、予測在庫数は「８３０」、上限
適正在庫数は「７７１」、下限適正在庫は「５３６」で
あり、在庫予測は範囲外であることがわかる。上限適正
在庫数を上回っていることから、在庫過剰製品であると
判定される。Comparing the forecast stock quantity in the third week of April with the allowable range of the proper stock quantity, the forecast stock quantity is “830”, the upper limit proper stock quantity is “771”, and the lower limit proper stock is “536”. , It can be seen that the inventory forecast is out of range. Since it exceeds the upper limit appropriate inventory quantity, it is determined to be an overstocked product.
【００９０】つまり、製品Ａの４月第３週の生産計画お
よび出荷計画は見直すべきと判定される。また、逆に、
下限適正在庫数を下回っている場合には、在庫不足製品
と判定される。That is, it is determined that the production plan and shipping plan of the third week of April of the product A should be reviewed. On the contrary,
If the quantity is below the lower limit appropriate inventory quantity, it is determined that the product is in short supply.
【００９１】このように、在庫過剰または在庫不足と判
定された製品の各データは、所定の格納場所に出力さ
れ、製品の過不足であることが判別できるように一覧表
（図示せず）などに自動出力される。この一覧表など
は、計画見直しのための材料とされる。As described above, each data of the products determined to be in excess or insufficient in inventory is output to a predetermined storage location, and a list (not shown) or the like can be used to determine whether the products are in excess or insufficient. Is automatically output to. This list is used as a material for reviewing the plan.
【００９２】この実施の形態１では、製品Ａを例にとっ
て説明したが、このような算出方法をすべての製品につ
いて適用すれば、製品毎の過去の出荷実績や傾向と生産
・出荷計画の内容に基づいて、適正な在庫数を算出する
ことができる。In the first embodiment, the product A has been described as an example, but if such a calculation method is applied to all products, the past shipment record and tendency of each product and the contents of the production / shipping plan can be obtained. Based on this, an appropriate inventory quantity can be calculated.
【００９３】また、在庫過剰製品や在庫不足製品を自動
的に出力するので、生産・出荷計画を見直すべき製品を
安易に特定することができる。Further, since the overstocked product and the understocked product are automatically output, it is possible to easily specify the product for which the production / shipping plan should be reviewed.
【００９４】[0094]
【発明の効果】以上のように、この発明によれば、製品
の在庫数を管理する製品在庫監視システムにおいて、過
去の出荷実績を記憶する出荷データ記憶手段と、生産・
出荷計画の策定から納品までのリードタイム情報を設定
するリードタイムマスタ設定手段と、季節変動のある製
品の季節変動情報を設定するシーズン期間設定手段と、
生産・出荷計画で決定した出荷計画数を記録する生産・
出荷計画・在庫データ記憶手段と、出荷実績、リードタ
イム情報および季節変動情報に基づいて、出荷実績の出
荷統計を算出する出荷統計計算手段と、出荷統計、リー
ドタイム情報および季節変動情報に基づいて、生産・出
荷計画における基準在庫数を算出する基準在庫数計算手
段と、出荷統計における基準在庫数の占める比率を算出
する基準在庫比率計算手段と、出荷計画数に比率を加え
た適正在庫数を算出する適正在庫数計算手段と、適正在
庫数の許容値を設定する在庫許容台数設定手段と、許容
値から適正在庫数の許容範囲を算出する上限・下限適正
在庫数計算手段とを備えたので、在庫過不足を発生させ
ない適正な在庫数を自動計算することのできる製品在庫
監視システムが得られる効果がある。As described above, according to the present invention, in a product inventory monitoring system for managing the number of products in stock, a shipment data storage means for storing past shipment results, and a production / production
Lead time master setting means for setting lead time information from formulation of shipping plan to delivery, and season period setting means for setting seasonal variation information of products with seasonal variation,
Production that records the number of shipment plans determined in the production / shipping plan
Based on the shipment plan / inventory data storage means, the shipment statistics, the lead time information, and the seasonal fluctuation information based on the shipment statistics calculation means that calculates the shipment statistics of the shipment results , The standard inventory quantity calculation means for calculating the standard inventory quantity in the production / shipping plan, the standard inventory ratio calculation means for calculating the ratio of the standard inventory quantity in the shipping statistics, and the appropriate inventory quantity which is the shipment planned quantity plus the ratio. Since it is provided with an appropriate inventory quantity calculating means for calculating, an allowable inventory quantity setting means for setting an allowable value of the appropriate inventory quantity, and an upper limit / lower limit appropriate inventory quantity calculating means for calculating an allowable range of the appropriate inventory quantity from the allowable value. There is an effect that a product inventory monitoring system that can automatically calculate an appropriate inventory quantity that does not cause an inventory excess or deficiency can be obtained.
【００９５】また、この発明によれば、基準在庫数計算
手段は、生産・出荷計画を策定する周期での在庫数に対
応する生産サイクル在庫数を算出する生産サイクル在庫
数計算手段と、生産・出荷計画から出荷までの出荷変動
数に対応する変動在庫数を算出する変動在庫数計算手段
と、出荷から納品までの期間中に存在する在庫数に対応
する輸送期間在庫数を算出する輸送期間在庫数計算手段
とを有し、生産サイクル在庫数、変動在庫数および輸送
期間在庫数に基づいて基準在庫数を算出するので、生産
・出荷計画時の条件を加味した適正な在庫数を自動計算
することのできる製品在庫監視システムが得られる効果
がある。Further, according to the present invention, the standard inventory quantity calculating means, the production cycle inventory quantity calculating means for calculating the production cycle inventory quantity corresponding to the inventory quantity in the cycle for formulating the production / shipping plan, Fluctuating inventory quantity calculation means that calculates the variable inventory quantity corresponding to the number of shipment fluctuations from the shipment plan to shipping, and transportation period inventory that calculates the transportation period inventory quantity corresponding to the inventory quantity existing during the period from shipment to delivery Since the standard inventory quantity is calculated based on the production cycle inventory quantity, the variable inventory quantity, and the transportation period inventory quantity, it automatically calculates the appropriate inventory quantity in consideration of the conditions at the time of production / shipment planning. There is an effect that a product inventory monitoring system that can perform is obtained.
【００９６】さらに、この発明によれば、許容範囲に該
当しない製品の適正在庫数を自動出力する在庫過不足計
算出力手段を備えたので、顧客へのサービスレベルを維
持しながら、在庫回転率を向上させることのできる製品
在庫監視システムが得られる効果がある。Further, according to the present invention, since the inventory excess / deficiency calculation output means for automatically outputting the proper inventory quantity of the products not falling within the allowable range is provided, the inventory turnover rate can be maintained while maintaining the service level to the customer. There is an effect that a product inventory monitoring system that can be improved is obtained.
【図１】 この発明の実施の形態１を示すブロック構成
図である。FIG. 1 is a block configuration diagram showing a first embodiment of the present invention.
【図２】 この発明の実施の形態１を説明する説明図で
ある。FIG. 2 is an explanatory diagram illustrating the first embodiment of the present invention.
【図３】 この発明の実施の形態１による設定値を示す
説明図である。FIG. 3 is an explanatory diagram showing set values according to the first embodiment of the present invention.
【図４】 この発明の実施の形態１による設定値を示す
説明図である。FIG. 4 is an explanatory diagram showing set values according to the first embodiment of the present invention.
【図５】 この発明の実施の形態１による設定値を示す
説明図である。FIG. 5 is an explanatory diagram showing set values according to the first embodiment of the present invention.
【図６】 この発明の実施の形態１による算出値を示す
説明図である。FIG. 6 is an explanatory diagram showing calculated values according to the first embodiment of the present invention.
【図７】 この発明の実施の形態１による算出値を示す
説明図である。FIG. 7 is an explanatory diagram showing calculated values according to the first embodiment of the present invention.
【図８】 この発明の実施の形態１による算出値を示す
説明図である。FIG. 8 is an explanatory diagram showing calculated values according to the first embodiment of the present invention.
【図９】 この発明の実施の形態１による算出値を示す
説明図である。FIG. 9 is an explanatory diagram showing calculated values according to the first embodiment of the present invention.
１ 出荷データ記憶手段、２ リードタイムマスタ設定
手段、３ シーズン期間設定手段、４ 生産・出荷計画
・在庫データ記憶手段、５ 在庫許容台数設定手段、６
出荷統計計算手段、７ 基準在庫数計算手段、８ 基
準在庫比率計算手段、９ 適正在庫数計算手段、１０
上限・下限適正在庫数計算手段、１１在庫過不足計算出
力手段、７１ 生産サイクル在庫数計算手段、７２ 変
動在庫数計算手段、７３ 輸送期間在庫数計算手段。1 shipment data storage means, 2 lead time master setting means, 3 season period setting means, 4 production / shipping plan / stock data storage means, 5 inventory allowable number setting means, 6
Shipping statistical calculation means, 7 Standard stock quantity calculation means, 8 Standard stock ratio calculation means, 9 Proper stock quantity calculation means, 10
Upper limit / lower limit proper inventory quantity calculation means, 11 inventory excess / deficiency calculation output means, 71 production cycle inventory quantity calculation means, 72 variable inventory quantity calculation means, 73 transportation period inventory quantity calculation means.
フロントページの続き (72)発明者 佐藤 公紀 東京都千代田区丸の内二丁目２番３号 三 菱電機株式会社内 Ｆターム(参考） 3C100 AA45 BB02 BB03 BB04 BB05 BB14 BB22 BB36 Continued front page (72) Inventor Koki Sato 2-3 2-3 Marunouchi, Chiyoda-ku, Tokyo Inside Ryo Electric Co., Ltd. F-term (reference) 3C100 AA45 BB02 BB03 BB04 BB05 BB14 BB22 BB36
Claims (3)
ステムにおいて、 過去の出荷実績を記憶する出荷データ記憶手段と、 生産・出荷計画の策定から納品までのリードタイム情報
を設定するリードタイムマスタ設定手段と、 季節変動のある製品の季節変動情報を設定するシーズン
期間設定手段と、 前記生産・出荷計画で決定した出荷計画数を記録する生
産・出荷計画・在庫データ記憶手段と、 前記出荷実績、前記リードタイム情報および前記季節変
動情報に基づいて、前記出荷実績の出荷統計を算出する
出荷統計計算手段と、 前記出荷統計、前記リードタイム情報および前記季節変
動情報に基づいて、前記生産・出荷計画における基準在
庫数を算出する基準在庫数計算手段と、 前記出荷統計における前記基準在庫数の占める比率を算
出する基準在庫比率計算手段と、 前記出荷計画数に前記比率を加えた適正在庫数を算出す
る適正在庫数計算手段と、 前記適正在庫数の許容値を設定する在庫許容台数設定手
段と、 前記許容値から前記適正在庫数の許容範囲を算出する上
限・下限適正在庫数計算手段とを備えたことを特徴とす
る製品在庫監視システム。1. A product inventory monitoring system for managing the number of products in stock, a shipment data storage means for storing past shipment results, and a lead time master for setting lead time information from production / shipping plan formulation to delivery. Setting means, season period setting means for setting seasonal variation information of seasonally varying products, production / shipping plan / inventory data storage means for recording the number of shipment plans determined by the production / shipping plan, and the shipment record Shipping statistics calculation means for calculating shipping statistics of the shipping results based on the lead time information and the seasonal fluctuation information, and the production / shipping based on the shipping statistics, the lead time information and the seasonal fluctuation information. A standard inventory quantity calculating means for calculating the standard inventory quantity in the plan, and a ratio of the standard inventory quantity in the shipment statistics are calculated. A standard inventory ratio calculation means, an appropriate inventory quantity calculation means for calculating an appropriate inventory quantity obtained by adding the ratio to the planned shipment quantity, an allowable inventory quantity setting means for setting an allowable value of the appropriate inventory quantity, and the tolerance A product inventory monitoring system, comprising: an upper limit / lower limit appropriate inventory quantity calculating means for calculating the allowable range of the appropriate inventory quantity from a value.
る生産サイクル在庫数を算出する生産サイクル在庫数計
算手段と、 前記生産・出荷計画から出荷までの出荷変動数に対応す
る変動在庫数を算出する変動在庫数計算手段と、 出荷から納品までの期間中に存在する在庫数に対応する
輸送期間在庫数を算出する輸送期間在庫数計算手段とを
有し、 前記生産サイクル在庫数、前記変動在庫数および前記輸
送期間在庫数に基づいて基準在庫数を算出することを特
徴とする請求項１に記載の製品在庫監視システム。2. The standard inventory quantity calculating means calculates the production cycle inventory quantity corresponding to the inventory quantity in the cycle of formulating the production / shipping plan, and the production / shipping plan. Floating inventory quantity calculation means for calculating the variable inventory quantity corresponding to the shipment fluctuation quantity until shipment, and transportation period inventory quantity calculation means for calculating the transportation period inventory quantity corresponding to the inventory quantity existing during the period from shipment to delivery 2. The product inventory monitoring system according to claim 1, further comprising: calculating a reference inventory quantity based on the production cycle inventory quantity, the variable inventory quantity, and the transportation period inventory quantity.
正在庫数を自動出力する在庫過不足計算出力手段を備え
たことを特徴とする請求項１または請求項２の少なくと
も一方に記載の製品在庫監視システム。3. The product inventory according to at least one of claims 1 and 2, further comprising an inventory excess / deficiency calculation output means for automatically outputting the appropriate inventory quantity of products that do not fall within the allowable range. Monitoring system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| JP2001359422A JP4089867B2 (en) | 2001-11-26 | 2001-11-26 | Product inventory monitoring system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| JP2001359422A JP4089867B2 (en) | 2001-11-26 | 2001-11-26 | Product inventory monitoring system |
Publications (3)
| Publication Number | Publication Date |
|---|---|
| JP2003160228A true JP2003160228A (en) | 2003-06-03 |
| JP2003160228A5 JP2003160228A5 (en) | 2005-06-16 |
| JP4089867B2 JP4089867B2 (en) | 2008-05-28 |
Family
ID=19170433
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| JP2001359422A Expired - Fee Related JP4089867B2 (en) | 2001-11-26 | 2001-11-26 | Product inventory monitoring system |
Country Status (1)
| Country | Link |
|---|---|
| JP (1) | JP4089867B2 (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006259859A (en) * | 2005-03-15 | 2006-09-28 | Matsushita Electric Ind Co Ltd | Proper inventory quantity calculating device |
| JP2006344186A (en) * | 2004-06-14 | 2006-12-21 | Univ Of Electro-Communications | Flow control system, method, and program |
| JP2007505401A (en) * | 2003-09-11 | 2007-03-08 | ヴェリタス・オペレーティング・コーポレーション | Data storage analysis mechanism |
| JP2009064277A (en) * | 2007-09-06 | 2009-03-26 | Mitsubishi Electric Corp | Standard inventory control device |
| JP2009126621A (en) * | 2007-11-21 | 2009-06-11 | Panasonic Electric Works Co Ltd | Proper inventory quantity determination system and its method |
| JP2011008513A (en) * | 2009-06-25 | 2011-01-13 | Mitsubishi Electric Corp | Stock reference setting device |
| JP2016048438A (en) * | 2014-08-27 | 2016-04-07 | 三菱電機株式会社 | Proper stock quantity calculation device, proper stock quantity calculation method and program |
| JP2020017127A (en) * | 2018-07-26 | 2020-01-30 | 日本製鉄株式会社 | Proper inventory determination support apparatus, method thereof, and program therefor |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH05225198A (en) * | 1992-02-07 | 1993-09-03 | Sekisui Chem Co Ltd | Production plan preparing device |
| JPH08212270A (en) * | 1995-01-31 | 1996-08-20 | Nippondenso Co Ltd | Production instruction system |
| JPH09128365A (en) * | 1995-10-27 | 1997-05-16 | Hitachi Ltd | Selection method for delivery route |
| JPH11114784A (en) * | 1997-10-08 | 1999-04-27 | Sekisui Chem Co Ltd | Production schedule forming device |
| JPH11345267A (en) * | 1998-06-01 | 1999-12-14 | Hitachi Ltd | Method and system for supporting inventory management job |
| JP2000094276A (en) * | 1998-09-24 | 2000-04-04 | Sekisui Chem Co Ltd | Stockpile plan making device and stockpile plan making method in stock-supply type production system |
| JP2000172768A (en) * | 1998-12-03 | 2000-06-23 | Sekisui Chem Co Ltd | Safety stock volume calculating device |
| JP2000235604A (en) * | 1999-02-16 | 2000-08-29 | Sekisui Chem Co Ltd | Device for making production plan |
| JP2001229319A (en) * | 2000-02-16 | 2001-08-24 | Matsushita Electric Ind Co Ltd | Inventory control method and inventory control device to be used for the method |
-
2001
- 2001-11-26 JP JP2001359422A patent/JP4089867B2/en not_active Expired - Fee Related
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH05225198A (en) * | 1992-02-07 | 1993-09-03 | Sekisui Chem Co Ltd | Production plan preparing device |
| JPH08212270A (en) * | 1995-01-31 | 1996-08-20 | Nippondenso Co Ltd | Production instruction system |
| JPH09128365A (en) * | 1995-10-27 | 1997-05-16 | Hitachi Ltd | Selection method for delivery route |
| JPH11114784A (en) * | 1997-10-08 | 1999-04-27 | Sekisui Chem Co Ltd | Production schedule forming device |
| JPH11345267A (en) * | 1998-06-01 | 1999-12-14 | Hitachi Ltd | Method and system for supporting inventory management job |
| JP2000094276A (en) * | 1998-09-24 | 2000-04-04 | Sekisui Chem Co Ltd | Stockpile plan making device and stockpile plan making method in stock-supply type production system |
| JP2000172768A (en) * | 1998-12-03 | 2000-06-23 | Sekisui Chem Co Ltd | Safety stock volume calculating device |
| JP2000235604A (en) * | 1999-02-16 | 2000-08-29 | Sekisui Chem Co Ltd | Device for making production plan |
| JP2001229319A (en) * | 2000-02-16 | 2001-08-24 | Matsushita Electric Ind Co Ltd | Inventory control method and inventory control device to be used for the method |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2007505401A (en) * | 2003-09-11 | 2007-03-08 | ヴェリタス・オペレーティング・コーポレーション | Data storage analysis mechanism |
| JP2006344186A (en) * | 2004-06-14 | 2006-12-21 | Univ Of Electro-Communications | Flow control system, method, and program |
| JP4706018B2 (en) * | 2004-06-14 | 2011-06-22 | 国立大学法人電気通信大学 | Flow number management system, method, and program |
| JP2006259859A (en) * | 2005-03-15 | 2006-09-28 | Matsushita Electric Ind Co Ltd | Proper inventory quantity calculating device |
| JP2009064277A (en) * | 2007-09-06 | 2009-03-26 | Mitsubishi Electric Corp | Standard inventory control device |
| JP2009126621A (en) * | 2007-11-21 | 2009-06-11 | Panasonic Electric Works Co Ltd | Proper inventory quantity determination system and its method |
| JP2011008513A (en) * | 2009-06-25 | 2011-01-13 | Mitsubishi Electric Corp | Stock reference setting device |
| JP2016048438A (en) * | 2014-08-27 | 2016-04-07 | 三菱電機株式会社 | Proper stock quantity calculation device, proper stock quantity calculation method and program |
| JP2020017127A (en) * | 2018-07-26 | 2020-01-30 | 日本製鉄株式会社 | Proper inventory determination support apparatus, method thereof, and program therefor |
| JP7110793B2 (en) | 2018-07-26 | 2022-08-02 | 日本製鉄株式会社 | Appropriate inventory determination support device, method and program |
Also Published As
| Publication number | Publication date |
|---|---|
| JP4089867B2 (en) | 2008-05-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7379781B2 (en) | Constraint based order optimization system and available to promise system | |
| TW541483B (en) | System and method for ensuring order fulfillment | |
| US6393332B1 (en) | Method and system for providing sufficient availability of manufacturing resources to meet unanticipated demand | |
| US5809479A (en) | On-time delivery, tracking and reporting | |
| JP4759544B2 (en) | Inventory planning system | |
| US20080215180A1 (en) | Arrangement for dynamic lean replenishment and methods therefor | |
| JP2007200185A (en) | Order direction system for directing optimum stock quantity/order quantity | |
| Yadollahi et al. | Managing inventory and service levels in a safety stock‐based inventory routing system with stochastic retailer demands | |
| JP2007140785A (en) | Inventory management system | |
| WO2004033349A1 (en) | Inventory management method, inventory management system, and inventory management program | |
| JP2003160228A (en) | Product stock monitoring system | |
| US20050075920A1 (en) | Projected sales | |
| CN113743862A (en) | Product target inventory determination method and system based on product classification | |
| US6415194B1 (en) | Method and system for providing sufficient availability of manufacturing resources to meet unanticipated demand | |
| US20030171963A1 (en) | Production planning method and system for production planning | |
| JP4901138B2 (en) | Distribution management system | |
| CN114219376A (en) | Household appliance large-scale customized service resource scheduling method based on knowledge graph | |
| JPH11345267A (en) | Method and system for supporting inventory management job | |
| US6397118B1 (en) | Method and system for providing sufficient availability of manufacturing resources to meet unanticipated demand | |
| Lai et al. | A stochastic approach to professional services firms’ revenue optimization | |
| JP2014164501A (en) | Control device, simulation system, control method, and program | |
| JP2006244470A (en) | Delivery date reply system, delivery date reply method, and delivery date reply program | |
| JP2021192143A (en) | Stock control system, stock control method, and program | |
| US20060100729A1 (en) | Method for determination of a lead time | |
| JP2011123912A (en) | Sales, production, and delivery system, and sales, production, and delivery method of steel plate steel strip product |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| A521 | Request for written amendment filed |
Free format text: JAPANESE INTERMEDIATE CODE: A523 Effective date: 20040914 |
|
| A621 | Written request for application examination |
Free format text: JAPANESE INTERMEDIATE CODE: A621 Effective date: 20040914 |
|
| A977 | Report on retrieval |
Free format text: JAPANESE INTERMEDIATE CODE: A971007 Effective date: 20070830 |
|
| A131 | Notification of reasons for refusal |
Free format text: JAPANESE INTERMEDIATE CODE: A131 Effective date: 20070904 |
|
| A521 | Request for written amendment filed |
Free format text: JAPANESE INTERMEDIATE CODE: A523 Effective date: 20071102 |
|
| 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: 20080122 |
|
| A61 | First payment of annual fees (during grant procedure) |
Free format text: JAPANESE INTERMEDIATE CODE: A61 Effective date: 20080221 |
|
| R150 | Certificate of patent or registration of utility model |
Free format text: JAPANESE INTERMEDIATE CODE: R150 Ref document number: 4089867 Country of ref document: JP Free format text: JAPANESE INTERMEDIATE CODE: R150 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20110307 Year of fee payment: 3 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20110307 Year of fee payment: 3 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20120307 Year of fee payment: 4 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20130307 Year of fee payment: 5 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20130307 Year of fee payment: 5 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20140307 Year of fee payment: 6 |
|
| R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |
|
| R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |
|
| R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |
|
| R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |
|
| LAPS | Cancellation because of no payment of annual fees |