JP2004310409A - Term of delivery reply system and method, and term of delivery verification program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To reply a delivery term to a requested customer as closely as possible to the requested term, in the case of order reception with more than the initially planned limit quantity. <P>SOLUTION: With respect to the items, requested term of delivery and order reception quantity of order reception information, a first verifying part 21 verifies whether or not shipping is possible by the requested term of delivery based on limit quantity and secured quantity until the point of time of the requested term of delivery of the pertinent items of a limit storage part 31. With respect to the items, requested term of delivery and order reception quantity of the order reception information, a second verifying part 22 verifies whether or not shipping is possible by the requested term of delivery based on the maximum limit quantity and secured quantity until the point of time of the requested term of delivery of the pertinent items of a maximum limit storage part 32, and when shipping is possible, decides which calendar bucket limit quantity should be enlarged to which extent, and changes the limit quantity of the pertinent items of the limit storage part 31, and records the secured quantity, and outputs the term of delivery reply to an output device 4. A message notifying part 23 outputs a procurement instruction to instruct which calendar bucket limit quantity should be expanded to which extent with respect to which items to the output device 4. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

【００９４】
また、最大枠数量も事前にＤＢ３上の最大枠情報テーブル３２に、表２のような形式で登録されているものとする。
【００９５】
【表２】

【００９６】
上記の例では、枠メッシュ（日付）は週単位を表している。
【００９７】
以下の説明では、当週（本日が含まれる週）の枠は無効であり、その週の枠は利用不可とする。
【００９８】
この場合、回答納期も週単位となる。日単位の納期回答を行う場合には、日メッシュで枠数量，引当数量および最大枠数量を管理する。納期回答対象となる品目（製品）は数千件になる場合もあり、また枠メッシュは納期回答を行う期間分保持している。
【００９９】
枠情報テーブル３１および最大枠情報テーブル３２には、品目数×枠メッシュ分のレコードが存在し、数万〜数十万件のデータ量となるため、以降の手順を人手で行うのは大変困難である。このため、許容される時間内に納期回答を行うためには、コンピュータを用いた本実施例を実現する必要がある。
【０１００】
営業担当者が、品目Ａを要求納期９月１０日に受注数量５０個、という受注情報をキーボード１からコンピュータに入力したとする。
【０１０１】
まず、第１の検証部２１は、受注情報として入力された要求納期までの枠数量の総量と引当数量の総量との差を求める。これは、枠情報テーブル３１から品目＝品目Ａ、メッシュ開始日付が要求納期以前かつ本日以降のレコードを抽出し、抽出したレコードについて枠数量と引当数量との差の和をとることで利用可能枠数量を求める。この処理は、ＤＢ３に対し、以下のようなイメージのＳＱＬ（Ｓｔｒｕｃｕｒｅｄ Ｑｕｅｒｙ Ｌａｎｇｕａｇｅ）を発行することで取得する。
【０１０２】
ＳＥＬＥＣＴ
ＳＵＭ （枠数量−引当数量）
ＦＲＯＭ 枠情報テーブル
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付 ＢＥＴＷＥＥＮ 本日 ＡＮＤ ９／１０
【０１０３】
ＤＢ３を使わない場合は、枠情報テーブル３１に当たる情報をハードディスクから１行ずつ読み込み、品目＝品目Ａ、メッシュ開始日付が要求納期以前かつ本日以降の行についてのみ、（枠数量−引当数量）を加算するループ処理を行う。
【０１０４】
本実施例では、本日が８／２９と仮定すると、利用可能枠数量として２０個が得られる。
【０１０５】
ここで求めた利用可能枠数量の２０個と受注数量の５０個とを比較し、２０個の利用可能枠数量では３０個不足することを判断する。
【０１０６】
次に、第２の検証部２２は、最大枠数量での充足状況を調べるために、最大枠情報テーブル３２から品目＝品目Ａ、メッシュ開始日付が要求納期以前かつ本日以降のレコードを抽出し、抽出したレコードについて最大枠数量の総量を求め、枠情報テーブル３１から品目＝品目Ａ、メッシュ開始日付が要求納期以前かつ本日以降のレコードを抽出し、抽出したレコードについて引当数量の総量を求める。ここで求めた最大枠数量の総量と引当数量の総量との差が、最大枠数量を用いた場合の利用可能最大枠数量となる。この処理はＤＢ３に対し、以下のようなイメージのＳＱＬを発行することで取得する。
【０１０７】
ＳＥＬＥＣＴ
ＳＵＭ （最大枠数量）
ＦＲＯＭ 最大枠情報テーブル
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付 ＢＥＴＷＥＥＮ 本日 ＡＮＤ ９／１０
【０１０８】
ＳＥＬＥＣＴ
ＳＵＭ （引当数量）
ＦＲＯＭ 枠情報テーブル
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付 ＢＥＴＷＥＥＮ 本日 ＡＮＤ ９／１０
【０１０９】
ＤＢ３を使わない場合は、最大枠情報テーブル３２に当たる情報をハードディスクから１行ずつ読み込み、品目＝品目Ａ、メッシュ開始日付が要求納期以前かつ本日以降の行についてのみ、最大枠数量を加算するループ処理と、枠情報テーブル３１に当たる情報をハードディスクから１行ずつ読み込み、品目＝品目Ａ、メッシュ開始日付が要求納期以前かつ本日以降の行についてのみ、引当数量を加算するループ処理とを行う。
【０１１０】
本実施例では、本日が８月２９日と仮定すると、実行結果として１つ目のＳＱＬで２４０個が得られ、２つ目のＳＱＬで１８０個が得られ、これらの差として利用可能最大枠数量は６０個が得られる。
【０１１１】
受注数量が５０個、利用可能最大枠数量が６０個であることから利用可能最大枠数量であれば納期回答が可能であることがわかり、先ほど求めた不足分３０個の枠数量を拡大することで納期回答を行い、９月１０日を回答納期とする。
【０１１２】
次に、不足分３０個の枠数量を拡大する。
【０１１３】
登録方法は、枠情報テーブル３１および最大枠情報テーブル３２のそれぞれから品目＝品目Ａ、メッシュ開始日付が回答納期以前かつ本日以降のレコードをメッシュ開始日付の遅い順に抽出し、最大枠情報テーブル３２の最大枠数量を超えない範囲で不足分を補うまで枠情報テーブル３１の枠数量を拡大してデータを更新していく。
【０１１４】
枠情報テーブル３１および最大枠情報テーブル３２のそれぞれからのデータ取り出しは、以下のようなＳＱＬをＤＢ３に対して発行することで行う。
【０１１５】
ＳＱＬ１：
ＳＥＬＥＣＴ
メッシュ開始日付
，最大枠数量
ＦＲＯＭ 最大枠情報テーブル
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付 ＢＥＴＷＥＥＮ 本日 ＡＮＤ ９／１０
ＯＲＤＥＲ ＢＹ メッシュ開始日付 ＤＥＳＣ
【０１１６】
ＳＱＬ２：
ＳＥＬＥＣＴ
メッシュ開始日付
，枠数量
ＦＲＯＭ 枠情報テーブル
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付 ＢＥＴＷＥＥＮ 本日 ＡＮＤ ９／１０
ＯＲＤＥＲ ＢＹ メッシュ開始日付 ＤＥＳＣ
【０１１７】
本例では、ＳＱＬｌについては、メッシュ開始日付が９月８日、最大枠数量が１２０個のデータと、メッシュ開始日付が９月１日、最大枠数量が１２０個のデータとが取り出される。
【０１１８】
また、ＳＱＬ２については、メッシュ開始日付が９月８日、枠数量が１００個のデータと、メッシュ開始日付が９月１日、枠数量が１００個のデータとが取り出される。
【０１１９】
９月８日を含む週の枠数量については、１２０−１００＝２０個の余地があるので、まず２０個分拡大し枠数量を更新する。
【０１２０】
枠情報テーブル３１の更新は、品目およびメッシュ開始日付をキーとして枠数量を更新する。
【０１２１】
ＳＱＬのイメージは、以下のようになる。
【０１２２】
ＵＰＤＡＴＥ 枠情報テーブル
ＳＥＴ 枠数量＝枠数量＋２０
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付＝９／８
【０１２３】
９月１日を含む週の枠数量については、１２０−１００＝２０個の余地があるが、残りの不足分は１０個であるので、１０個分拡大し枠数量を更新する。
【０１２４】
枠情報テーブル３１の更新は、品目およびメッシュ開始日付をキーとして枠数量を更新する。
【０１２５】
ＳＱＬのイメージは、以下のようになる。
【０１２６】
ＵＰＤＡＴＥ 枠情報テーブル
ＳＥＴ 枠数量＝枠数量＋１０
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付＝９／１
【０１２７】
次に、９月１０日が回答納期の受注５０個分を枠情報テーブル３１の引当数量に登録する。
【０１２８】
登録方法は、枠情報テーブル３１から品目＝品目Ａ、メッシュ開始日付が回答納期以前かつ本日以降のレコードをメッシュ開始日付の遅い順に抽出し、枠数量を超えない範囲で引当数量を増やしてデータを更新していく。
【０１２９】
枠情報テーブル３１からのデータ取り出しは、以下のようなイメージのＳＱＬをＤＢ３に対して発行することで行う。
【０１３０】
ＳＥＬＥＣＴ
メッシュ開始日付
，枠数量
，引当数量
ＦＲＯＭ 枠情報テーブル
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付 ＢＥＴＷＥＥＮ 本日 ＡＮＤ ９／１０
ＯＲＤＥＲ ＢＹ メッシュ開始日付 ＤＥＳＣ
【０１３１】
本例では、品目が品目Ａ、メッシュ開始日付が９月８日、メッシュ終了日付が９月１４日、枠数量が１２０個、引当数量が８０個のデータと、品目が品目Ａ、メッシュ開始日付が９月１日、メッシュ終了日付が９月７日、枠数量が１１０個、引当数量が１００個のデータとが取り出される。
【０１３２】
先の手順により枠数量を拡大したので、その結果が反映された状態で取得できる。
【０１３３】
９月８日を含む週の枠数量については、１２０−１８０＝４０個の余地があるので、まず４０個分拡大し引当数量を更新する。
【０１３４】
枠情報テーブル３１の更新は、品目およびメッシュ開始日付をキーとして引当数量を更新する。
【０１３５】
ＳＱＬのイメージは、以下のようになる。
【０１３６】
ＵＰＤＡＴＥ 枠情報テーブル
ＳＥＴ 引当数量＝枠数量＋４０
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付＝９／８
【０１３７】
９月１日を含む週の枠数量については、１１０−１００＝１０個の余地があるので、受注数量の残り１０個分拡大し引当数量を更新する。
【０１３８】
枠情報テーブル３１の更新は、品目およびメッシュ開始日付をキーとして引当数量を更新する。
【０１３９】
ＳＱＬのイメージは、以下のようになる。
【０１４０】
ＵＰＤＡＴＥ 枠情報テーブル
ＳＥＴ 引当数量＝枠数量＋１０
ＷＨＥＲＥ 品目＝’品目Ａ’
ＡＮＤ メッシュ開始日付＝９／１
【０１４１】
ＤＢ３を使わない場合は、ハードディスクから１行ずつメモリに読み込んで処理を行い、メモリ上で更新した後、ハードディスクへのランダムアクセスで書き込みを行うことで処理するが、詳細はＤＢＭＳのロジックとなるため、省略する。
【０１４２】
［第２の実施の形態の一実施例］
図１１は、図６に示した第２の実施の形態に係る納期回答システムの一実施例を示すブロック図である。本実施例の納期回答システムは、受注記憶装置としての受注情報ファイル１と、納期検証装置としてのコンピュータで実行される納期検証プログラム２と、記憶装置としてのＤＢ３と、納期回答記憶装置としての納期回答ファイル４とから、その主要部が構成されている。ＤＢ３には、枠記憶部としての枠情報テーブル３１と、最大枠記憶部としての最大枠情報テーブル３２とが備えられている。
【０１４３】
本実施例の納期回答システムの動作については、図６に示した第２の実施の形態に係る納期回答システムの動作および図１０に示した第１の実施の形態に係る納期回答システムの一実施例の動作から容易に類推可能であるので、詳しい説明を割愛する。
【０１４４】
［第３の実施の形態の一実施例］
図１２は、図７に示した第３の実施の形態に係る納期回答システムの一実施例を示すブロック図である。本実施例の納期回答システムは、受注記憶装置としての受注情報ファイル１と、納期検証装置としてのコンピュータで実行される納期検証プログラム２と、記憶装置としてのＤＢ３と、納期回答記憶装置としての納期回答ファイル４と、情報伝達媒体としてのインターネット５とから、その主要部が構成されている。ＤＢ３には、枠記憶部としての枠情報テーブル３１と、最大枠記憶部としての最大枠情報テーブル３２と、メッセージ通知先記憶部としてのメッセージ通知先情報テーブル３３とが備えられている。
【０１４５】
本実施例の納期回答システムの動作については、図７に示した第３の実施の形態に係る納期回答システムの動作および図１０に示した第１の実施の形態に係る納期回答システムの一実施例の動作から容易に類推可能であるので、詳しい説明を割愛する。
【０１４６】
【発明の効果】
第１の効果は、受注が確定した時点の納期回答において当初計画した枠数量以上の受注が入っても人手をかけることなく顧客からの要求納期をなるべく満足する納期回答が出せることである。その理由は、当初計画した枠数量と、最大限努力すれば対応可能な最大枠数量とを登録しておき、当初計画した枠数量以上の受注が入った場合に自動的に最大枠数量まで必要なだけ枠数量を拡大して納期回答するためである。
【０１４７】
第２の効果は、当初計画した枠数量より多くの枠数量が必要になったときに枠数量を拡大するアクションをとるための管理工数を減らすことができることである。その理由は、どの品目に対して枠数量を、いつ、どれだけ拡大する必要があるかを適切な担当者に自動的に通知するためである。
【図面の簡単な説明】
【図１】本発明の第１の実施の形態に係る納期回答システムの構成を示すブロック図である。
【図２】図１中の納期検証装置の処理を示すフローチャートである。
【図３】第１の実施の形態に係る納期回答システムにおいて、枠数量として部材ベンダに提示しているフォーキャスト数量を使っている一例を示す図である。
【図４】第１の実施の形態に係る納期回答システムにおいて、図３に示す状態で入力装置から受注情報があった場合を示す図である。
【図５】第１の実施の形態に係る納期回答システムにおいて、図４に示す状態で入力装置から受注情報があった場合を示す図である。
【図６】本発明の第２の実施の形態に係る納期回答システムの構成を示すブロック図である。
【図７】本発明の第３の実施の形態に係る納期回答システムの構成を示すブロック図である。
【図８】図７中の納期検証装置の処理を示すフローチャートである。
【図９】第３の実施の形態に係る納期回答システムにおいて、受注記憶装置に納期回答をまだ行っていない受注情報が記憶され、メッセージ通知先記憶部に通知先情報として、品目Ａおよび品目ＣはベンダＸ、品目ＢはベンダＹが記憶されている場合を示す図である。
【図１０】本発明の第１の実施の形態に係る納期回答システムの一実施例を示すブロック図である。
【図１１】本発明の第２の実施の形態に係る納期回答システムの一実施例を示すブロック図である。
【図１２】本発明の第３の実施の形態に係る納期回答システムの一実施例を示すブロック図である。
【符号の説明】
１ 入力装置，受注記憶装置，キーボード，受注情報ファイル
２ 納期検証装置，納期検証プログラム
３ 記憶装置，データベース（ＤＢ）
４ 出力装置，納期回答記憶装置，ディスプレイ，納期回答ファイル
２１ 第１の検証部
２２ 第２の検証部
２３ メッセージ通知部
３１ 枠記憶部，枠情報テーブル
３２ 最大枠記憶部，最大枠情報テーブル
３３ メッセージ通知先記憶部，メッセージ通知先情報テーブル
Ａ１ 引当可能枠数量算出ステップ
Ａ２ 受注数量以上判定ステップ
Ａ３ 最大引当可能枠数量算出ステップ
Ａ４ 受注数量以上判定ステップ
Ａ５ 回答納期探索ステップ
Ａ６ 枠数量必要数量分拡大ステップ
Ａ７ 調達指示出力ステップ
Ａ７’ 調達指示記録ステップ
Ａ８ 引当数量記録ステップ
Ａ９ 納期回答出力ステップ
Ａ９’ 回答納期記録ステップ
Ａ１０ 全件回答終了判定ステップ
Ａ１１ 回答対象受注情報１件取り出しステップ
Ａ１２ 調達指示通知ステップ[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a delivery date answering system, and more particularly to a delivery date answering system that answers a delivery date of a product based on a material procurement plan, a production plan, a load plan, and the like in response to an order received from a customer.
[0002]
[Prior art]
Conventional delivery date response systems provide delivery date answers using only the current inventory and work-in-progress status, and provide delivery date answers using only advance sales, production, and material ordering plans. Literature 1 and Patent Literature 2).
[0003]
On the other hand, based on the production capacity of the production line and the working days in the planning cycle, the capacity quota, which is the producible quantity, is determined, and each time the producible product is allocated in the planning cycle, the determined capacity is determined. Subtract the quantity of the allocated product from the quota quantity to obtain the remaining capacity quota quantity, determine whether the quantity of the ordered product of each order falls within the capacity quota quantity of each production line, and deliver. A delivery date calculation method that calculates a scheduled date is known (for example, see Patent Document 3).
[0004]
Also, a delivery date answering system for determining a delivery date for a shipment quantity requested in a shipment delivery time period based on a stock quantity, a production plan quantity, and a shipment quantity of a shipment month of a product and months before the delivery month is known (for example, And Patent Document 4).
[0005]
On the other hand, according to the above-mentioned conventional technology, when the requested delivery date from the customer cannot be satisfied, the planned quantity is manually reviewed each time the order is confirmed.
[0006]
[Patent Document 1]
JP-A-06-28362 (page 2-3, FIG. 3)
[Patent Document 2]
Japanese Patent Application Laid-Open No. 2000-288092 (page 5, FIG. 1)
[Patent Document 3]
JP 2001-100832 (pages 4-7, see FIG. 1)
[Patent Document 4]
JP-A-2002-189784 (page 4, FIG. 1)
[0007]
[Problems to be solved by the invention]
However, the conventional technology has the following problems.
[0008]
The first problem is that it is difficult to obtain a delivery date answer that satisfies the customer's requested delivery date. The reason is that it is difficult to maintain an appropriate stock quantity or to increase the accuracy of a plan made in advance. In order to satisfy the requested delivery date from the customer, it is possible to have a sufficient quantity of stock or a sufficient quantity of a production plan and a material procurement schedule and a load plan accordingly. However, holding a large amount of stock or ordering more materials than necessary in a state where the actual order has not been finalized leads to an increase in inventory. On the other hand, if the requested delivery date from the customer cannot be satisfied, the customer will not be satisfied, and in some cases, the order will be lost.
[0009]
The second problem is that if the planned quantity is manually reviewed each time an order is confirmed, a large number of management steps are required. It is necessary to flexibly implement a delivery date response that satisfies the customer's requested delivery date as much as possible without requiring a large number of man-hours when the order is confirmed without excessive inventory and material orders.
[0010]
An object of the present invention is to provide a delivery date answering system for answering the delivery date of a product based on a material procurement plan, a production plan, a load plan, and the like in response to an order from a customer. Another object of the present invention is to provide a delivery date answering system, a delivery date answering method, and a delivery date verification program capable of giving a delivery date answer as requested by a customer.
[0011]
[Means for Solving the Problems]
The delivery date response system according to the present invention includes a frame storage unit that stores a frame amount and a reserved amount for each item for each calendar bucket, and a maximum frame storage unit that stores a maximum frame amount for each item for each calendar bucket. With respect to the item, the requested delivery date, and the ordered quantity of the order information provided from the input device, the product can be shipped to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the frame storage unit. A first verification unit that verifies whether or not there is a delivery date, and outputs a delivery date response to the output device if it can be shipped to the requested delivery date; and the first verification unit verifies that shipment is impossible to the requested delivery date. When the item, the requested delivery date, and the ordered quantity of the order information given from the input device are stored in the maximum slot storage unit and the maximum slot quantity up to the required delivery date of the corresponding item stored in the maximum slot storage unit. Was done Verify whether the item can be shipped to the requested delivery date based on the allocated quantity up to the requested delivery date, determine if the calendar bucket frame size and how much should be expanded if shipping is possible, A second verification unit that changes the slot quantity of the corresponding item in the storage unit and records the reserved quantity, and then outputs a delivery date response to the output device. The second verification unit verifies that the product can be shipped to the requested delivery date. And a message notifying unit for outputting to the output device a message instructing how much the number of calendar bucket frames should be expanded for the corresponding item.
[0012]
In addition, the delivery date reply system of the present invention includes a frame storage unit that stores a frame amount and a reserved amount for each item for each calendar bucket, and a maximum frame storage that stores a maximum frame amount for each item for each calendar bucket. And the requested delivery date based on the frame quantity and reserved quantity up to the requested delivery date of the corresponding item stored in the frame storage unit with respect to the item, the requested delivery date and the ordered quantity of the order information given from the order storage device. A first verification unit that verifies whether or not shipment is possible, and stores a delivery date answer in a delivery date answer storage device if the shipment is possible in the requested delivery date; When it is verified that there is, for the item of the order information provided from the order storage device, the requested delivery date and the order quantity, the maximum frame quantity and the requested frame date up to the required delivery date of the corresponding item stored in the maximum frame storage unit. Previous Based on the reserved quantity of the corresponding item up to the required delivery date stored in the frame storage unit, it is verified whether or not it can be shipped to the required delivery date, and if it can be shipped, the amount of the calendar bucket in which calendar bucket is increased by how much. A second verification unit that changes the frame quantity of the corresponding item in the frame storage unit and records the reserved quantity, and then stores the delivery date answer in the delivery date answer storage device; and the requested delivery date by the second verification unit. And a message notification unit for storing in the delivery date response storage device a message instructing how much the number of frames in which calendar bucket is to be expanded for the corresponding item verified to be shippable. .
[0013]
Further, the delivery date answering system of the present invention includes a frame storage unit that stores the frame quantity and the reserved quantity for each item for each calendar bucket, and a maximum frame storage that stores the maximum frame quantity for each item for each calendar bucket. Unit, a message notification destination storage unit that stores a message notification destination for each item, and a corresponding item stored in the frame storage unit with respect to the item, requested delivery date, and order quantity of the order information provided from the order storage device. A first verification that verifies whether or not shipment can be made to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date, and if the shipment can be made to the requested delivery date, stores the delivery date answer in the delivery date answer storage device. And when the first verification unit verifies that the product cannot be shipped in the requested delivery date, the maximum limit is set for the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device. Whether the product can be shipped to the requested delivery date based on the maximum quantity of the corresponding item stored in the storage unit up to the required delivery date and the reserved quantity of the relevant item up to the required delivery date stored in the frame storage unit. Verifying, if shipping is possible, determining how much the amount of the frame of the calendar bucket is to be expanded, and changing the frame amount of the corresponding item in the frame storage unit, recording the reserved amount, and then storing the delivery date response in the delivery date response storage device. And a message for instructing how much the number of calendar bucket frames should be expanded for the corresponding item verified to be shippable on the requested delivery date by the second verification unit. And a message notification unit that notifies the notification destination of the message stored in the message notification destination storage unit via an information transmission medium.
[0014]
Furthermore, the delivery date answering system of the present invention has a frame information table storing the frame quantity and the reserved quantity for each item for each calendar bucket, and a maximum frame storing the maximum frame quantity for each item for each calendar bucket. The information table and the requested delivery date based on the quantity of the order, the requested delivery date and the order quantity given from the input device, based on the slot quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the slot information table. A first verification unit that verifies whether the product can be shipped and outputs a delivery date response to an output device if the product can be shipped to the requested delivery date; and that the first verification unit cannot ship the product to the requested delivery date. Is verified, the item, the requested delivery date, and the ordered quantity of the order information given from the input device are the maximum items up to the required delivery date of the corresponding item stored in the maximum frame information table. Based on the quantity and the reserved quantity of the corresponding item up to the requested delivery date stored in the slot information table, it is verified whether or not it can be shipped to the requested delivery date, and if it can be shipped, which calendar bucket slot quantity is A second verification unit that determines whether or not to expand the size, changes the frame quantity of the corresponding item in the frame information table, records the reserved quantity, and outputs a delivery date response to the output device; and a request from the second verification unit. A message notifying unit that outputs to the output device a message instructing how much the number of frames of the calendar bucket should be expanded for the item verified to be shippable by the delivery date.
[0015]
In addition, the delivery date response system of the present invention includes a frame information table that stores a frame amount and a reserved amount for each item for each calendar bucket, and a maximum frame information that stores the maximum frame amount for each item for each calendar bucket. The table, the requested delivery date and the requested delivery date based on the item quantity, the requested delivery date and the ordered quantity of the order information given from the order storage device based on the frame quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the frame information table. A first verification unit that verifies whether the product can be shipped and outputs a delivery date response to an output device if the product can be shipped to the requested delivery date; and that the first verification unit cannot ship the product to the requested delivery date. Is verified, the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device are stored in the maximum slot information table until the requested delivery date of the corresponding item is reached. Verify whether or not it is possible to ship to the requested delivery date based on the reserved quantity up to the requested delivery date of the corresponding item stored in the slot information table and the slot information table, and determine which calendar bucket slot quantity if shipping is possible. A second verification unit that determines how much to expand, changes the frame quantity of the corresponding item in the frame information table, records the reserved quantity, and outputs a delivery date response to the output device; and the second verification unit. A message notification unit for storing in the delivery date response storage device a message instructing how much the frame quantity of which calendar bucket is to be expanded for the item verified to be shippable by the requested delivery date. And
[0016]
Further, the delivery date answering system of the present invention includes a frame information table storing the frame quantity and the reserved quantity for each item for each calendar bucket, and a maximum frame information storing the maximum frame quantity for each item for each calendar bucket. Table, a message notification destination information table that stores a message notification destination for each item, and a corresponding item stored in the frame information table with respect to the item, requested delivery date, and order quantity of the order information given from the order storage device. A first verification that verifies whether or not shipment can be made to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date, and if the shipment can be made to the requested delivery date, stores the delivery date answer in the delivery date answer storage device. And when the first verification unit verifies that the product cannot be shipped in the requested delivery date, the item, the requested delivery date, and the reception date of the order information provided from the order storage device. Shipment to the requested delivery date based on the maximum quantity of the quantity up to the required delivery date of the corresponding item stored in the maximum information table and the quantity of the corresponding item stored up to the required delivery date stored in the information table. After verifying whether or not it is possible, determine how much the number of slots in which calendar bucket should be expanded if shipping is possible, change the slot quantity of the corresponding item in the slot information table and record the allocation quantity, and then A second verification unit that stores a delivery date answer in a delivery date answer storage device, and the amount of the calendar bucket frame for the corresponding item verified to be shippable to the requested delivery date by the second verification unit; A message notification unit that notifies a message destination instructing whether to enlarge the message to a notification destination of the message stored in the message notification destination information table via an information transmission medium. And wherein the Rukoto.
[0017]
Still further, in the delivery date reply system according to the present invention, the second verification unit allocates the increased allocation quantity in the range from the calendar bucket close to the required delivery date to the past in the range of the maximum frame quantity.
[0018]
In the delivery date reply system of the present invention, when the second verification unit verifies that the shipment cannot be performed at the requested delivery date, the requested delivery date is moved to the next calendar bucket in the future direction to search for an answer delivery date. The feature is that the verification is repeated until the product can be shipped.
[0019]
On the other hand, according to the delivery date reply method of the present invention, the first verification unit stores, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the ordered quantity of the order information provided from the input device. Verifies whether or not it is possible to ship to the requested delivery date based on the frame quantity and the reserved quantity of the corresponding item stored in the frame storage unit up to the requested delivery date, and answers the delivery date if it can be shipped to the requested delivery date. And outputting the item of the order information provided from the input device when the second verification unit verifies that the product cannot be shipped in the requested delivery date by the second verification unit. The maximum quota quantity for each item with respect to the requested delivery date and the order quantity is stored in the maximum quota storage unit that stores the maximum quota quantity for each item for each calendar bucket, and the maximum quota quantity until the requested delivery date of the corresponding item and stored in the quota storage unit. Of the applicable item Verify whether it is possible to ship to the requested delivery date based on the allocation amount up to the request delivery date, determine if the calendar bucket frame quantity should be expanded how much if shipping is possible, and A step of outputting the delivery date response to the output device after changing the quota quantity of the corresponding item and recording the reserved quantity, and a message that the message notification unit has been verified that the second verification unit can ship the requested delivery date. Outputting to the output device a message instructing how much the number of calendar bucket frames should be expanded for the item.
[0020]
Further, in the delivery date reply method according to the present invention, the first verification unit may determine, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the order quantity of the order information provided from the order storage device. It verifies whether or not it is possible to ship to the requested delivery date based on the frame quantity and the reserved quantity of the corresponding item up to the requested delivery date stored in the stored frame storage unit, and if it can be shipped to the requested delivery date, the delivery date The step of storing the answer in the delivery date answering device; and the order information given from the order receiving storage device when the second verifying unit verifies that the shipment cannot be made in the requested delivery date by the first verifying unit. The maximum frame quantity up to the required date of delivery of the corresponding item stored in the maximum frame storage unit storing the maximum frame quantity for each item for each item with respect to the item, the requested delivery date and the order quantity, and the frame storage unit Remembered in Verify whether or not the item can be shipped to the requested delivery date based on the reserved quantity up to the requested delivery date, determine if the calendar bucket frame size and how much should be expanded if shipping is possible, A step of storing the delivery date answer in the delivery date storage device after changing the frame quantity of the corresponding item in the storage unit and recording the reserved quantity, and that the message notification unit can be shipped to the requested delivery date by the second verification unit. Storing in the delivery date response storage device a message instructing how much the number of calendar bucket frames is to be expanded for the verified item.
[0021]
Further, in the delivery date reply method according to the present invention, the first verification unit may determine, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the order quantity of the order information provided from the order storage device. It verifies whether or not it is possible to ship to the requested delivery date based on the frame quantity and the reserved quantity of the corresponding item up to the requested delivery date stored in the stored frame storage unit, and if it can be shipped to the requested delivery date, the delivery date A step of storing the answer in a delivery date answer storage device, and receiving an order received from the order storage device when the second verification unit verifies that the shipment cannot be performed in the requested delivery date by the first verification unit. The maximum frame quantity up to the required delivery date of the corresponding item stored in the maximum frame storage unit storing the maximum frame quantity for each item with respect to the item, the requested delivery date, and the order quantity of the information for each calendar bucket, and the frame storage Note in the section Based on the allocated quantity up to the requested delivery date of the applicable item, verify whether it can be shipped on the requested delivery date, and if it can be shipped, determine how much the calendar bucket frame quantity should be expanded, and A step of storing the delivery date answer in the delivery date answer storage device after changing the frame quantity of the corresponding item in the frame storage section and recording the reserved quantity; and a message notifying section capable of shipping the requested delivery date by the second verification section. A message instructing how much the number of calendar bucket frames is to be expanded for the item verified to be present is notified to the notification destination of the message stored in the message notification destination storage unit via the information transmission medium. And a step of performing
[0022]
Still further, in the delivery date reply method according to the present invention, the first verification unit may determine, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the ordered quantity of the order information provided from the input device. It verifies whether or not it is possible to ship to the requested delivery date based on the frame quantity and the reserved quantity of the applicable item stored in the stored frame information table up to the requested delivery date, and if it can be shipped to the requested delivery date, the delivery date Outputting the answer to the output device; and, when the second verification unit verifies that the shipment cannot be performed on the requested delivery date by the first verification unit, the item of the order information provided from the input device. , The maximum quota quantity of each item with respect to the requested delivery date and the order quantity stored in the maximum quota information table storing the maximum quota quantity of each item for each calendar bucket, and the maximum quota quantity and the quota information table up to the requested delivery date of the corresponding item. Verifies whether the item can be shipped to the requested delivery date based on the reserved quantity of the corresponding item up to the requested delivery date stored in, and if so, determines how much the calendar bucket frame quantity and how much should be expanded A step of outputting a delivery date response to an output device after changing the slot quantity of the corresponding item in the slot information table and recording the reserved quantity, and a message notifying section which can ship the requested delivery date by the second verification section. Outputting to the output device a message instructing how much the number of calendar bucket frames is to be expanded for the item for which it has been verified.
[0023]
Further, in the delivery date reply method according to the present invention, the first verification unit may determine, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the order quantity of the order information provided from the order storage device. It verifies whether or not it is possible to ship to the requested delivery date based on the frame quantity and the reserved quantity of the applicable item stored in the stored frame information table up to the requested delivery date, and if it can be shipped to the requested delivery date, the delivery date Outputting the answer to the output device; and, when the second verification unit verifies that the shipment cannot be performed in the requested delivery date by the first verification unit, the second verification unit checks the order information provided from the order storage device. The maximum quota quantity and the quota information table of the corresponding item up to the requested punctuation date stored in the maximum quota information table storing the maximum quota quantity for each item with respect to the item, the requested delivery date and the order quantity for each calendar bucket. Verifies whether it can be shipped to the requested delivery date based on the reserved quantity of the relevant item up to the requested delivery date stored in the file, and if it can be shipped, determines which calendar bucket frame quantity to expand and how much. Deciding, changing the quota quantity of the corresponding item in the quota information table and recording the reserved quantity, and then outputting the delivery date response to the output device, and the message notification unit can be shipped to the requested delivery date by the second verification unit. And storing in the delivery date response storage device a message instructing how much the number of calendar bucket frames is to be expanded for the item for which the verification is made.
[0024]
Further, in the delivery date reply method according to the present invention, the first verification unit may determine, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the order quantity of the order information provided from the order storage device. It verifies whether or not it is possible to ship to the requested delivery date based on the frame quantity and the reserved quantity of the applicable item stored in the stored frame information table up to the requested delivery date, and if it can be shipped to the requested delivery date, the delivery date The step of storing the answer in the delivery date answering device; and the order information given from the order receiving storage device when the second verifying unit verifies that the shipment cannot be made in the requested delivery date by the first verifying unit. The maximum quota quantity and reserved quantity up to the requested delivery date of the corresponding item stored in the maximum quota information table that stores the maximum quota quantity for each item for each item, required delivery date and order quantity for each calendar bucket Verify whether or not it can be shipped on the required delivery date based on, determine if and how much the number of calendar bucket slots to be expanded if possible, and change the slot quantity of the corresponding item in the slot storage unit A step of storing the delivery date response in the delivery date answering device after recording the allocation quantity, and a message notifying unit for determining which calendar bucket the corresponding item is verified to be able to ship to the requested delivery date by the second verification unit. Notifying, via an information transmission medium, a message instructing how much to increase the number of frames to the message notification destination stored in the message notification destination storage unit.
[0025]
Still further, the delivery date reply method of the present invention is characterized in that the second verification unit allocates the allocated quantity to be increased in a range from the calendar bucket close to the required delivery date in the past to the maximum frame quantity in order.
[0026]
Also, in the delivery date reply method of the present invention, when the second verification unit verifies that shipment is impossible at the requested delivery date, the requested delivery date is moved to the next calendar bucket in the future to search for an answer delivery date. The feature is that the verification is repeated until the product can be shipped.
[0027]
On the other hand, the delivery date verification program of the present invention stores a computer in a frame storage unit that stores a frame quantity and an allocation quantity for each item for each calendar bucket, and a maximum storage capacity for storing the maximum frame quantity for each item for each calendar bucket. The requested storage date and time for the item, the requested delivery date, and the ordered quantity of the order information given from the frame storage unit and the requested delivery date are stored based on the frame quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the frame storage unit. It verifies whether or not it can be shipped, and if it can be shipped to the requested delivery date, a first verification unit that outputs a delivery date answer to the output device. The first verification unit may not be able to ship to the requested delivery date. When it is verified, the maximum frame quantity and the frame of the item, the requested delivery date, and the ordered quantity of the order information given from the input device up to the required delivery date of the corresponding item stored in the maximum frame storage unit. Verify whether the item can be shipped to the requested delivery date based on the reserved quantity of the relevant item up to the requested delivery date stored in the storage unit, and if it can be shipped, how much the calendar bucket frame quantity should be expanded The second verification unit that changes the frame quantity of the corresponding item in the frame storage unit, records the reserved quantity, and outputs a delivery date response to the output device, and can ship the requested delivery date by the second verification unit Is operated as a message notification unit that outputs to the output device a message instructing how much the number of calendar bucket frames is to be expanded for the corresponding item verified to be.
[0028]
In addition, the delivery date verification program of the present invention stores a computer in a frame storage unit that stores a frame quantity and an allocation quantity of each item for each calendar bucket, and a maximum storage quantity that stores a maximum frame quantity of each item for each calendar bucket. The requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the frame storage unit with respect to the item, the requested delivery date, and the ordered quantity of the order information given from the frame storage unit and the order storage device. A first verification unit that stores a delivery date answer in a delivery date response storage device if the shipment date can be shipped to the requested delivery date, and the first verification unit cannot ship the requested delivery date. When it is verified that there is an item, the requested delivery date, and the ordered quantity of the order information given from the order storage device, the maximum frame up to the required delivery date of the corresponding item stored in the maximum frame storage unit. Verify whether the item can be shipped to the requested delivery date based on the quantity and the reserved quantity of the corresponding item up to the requested delivery date stored in the frame storage unit. A second verification unit that determines whether or not to expand only, changes the frame quantity of the corresponding item in the frame storage unit, records the reserved quantity, and then stores the delivery date answer in the delivery date answer storage device, and the second verification unit. Operating as a message notification unit that stores in the delivery date response storage device a message instructing how much the number of frames in which calendar bucket is to be expanded for the corresponding item verified to be able to be shipped in the requested delivery date. Features.
[0029]
Further, the delivery date verification program according to the present invention may include a computer storing a frame storage unit that stores a frame quantity and an allocation quantity for each item for each calendar bucket, and a maximum storage quantity that stores a maximum frame quantity for each item for each calendar bucket. A frame storage unit, a message notification destination storage unit that stores a message notification destination for each item, an item of order information given from an order storage device, a corresponding delivery date, and a corresponding item stored in the frame storage unit with respect to a requested order quantity. A first verification that verifies whether or not shipment can be made to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date, and if the shipment can be made to the requested delivery date, stores the delivery date answer in the delivery date answer storage device. When the first verification unit verifies that the shipment cannot be made within the requested delivery date, the order, the requested delivery date, and the ordered quantity of the order information provided from the order storage device are returned. Whether the item can be shipped to the required delivery date based on the maximum quantity of the corresponding item stored in the maximum storage unit up to the required delivery date and the reserved quantity of the relevant item up to the required delivery date stored in the frame storage unit Verifies whether or not, if it can be shipped, decides how much the number of calendar buckets is to be expanded, and changes the frame quantity of the corresponding item in the frame storage unit, records the reserved quantity, and then sends the delivery date response to the delivery date. A second verification unit stored in the answer storage device, and how much the number of calendar bucket frames to be expanded for the corresponding item verified to be shippable on the requested delivery date by the second verification unit. A message notification unit for notifying, via an information transmission medium, a message to be instructed to a message notification destination stored in the message notification destination storage unit.
[0030]
Still further, the delivery date verification program of the present invention stores a computer with a slot information table storing the slot quantity and the reserved quantity for each item for each calendar bucket, and the maximum slot quantity for each item for each calendar bucket. Requested delivery date based on the maximum slot information table, the item of the order information given from the input device, the requested delivery date and the ordered quantity, based on the slot quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the slot information table. A first verification unit that verifies whether or not it can be shipped to the requested delivery date, and outputs a delivery date response to the output device if the shipment can be performed at the requested delivery date. Is verified, the requested delivery date of the corresponding item stored in the maximum frame information table with respect to the item, the requested delivery date, and the ordered quantity of the order information given from the input device. Based on the maximum quota quantity up to and the reserved quantity of the applicable item up to the required delivery date stored in the quota information table, it is verified whether or not it is possible to ship to the requested delivery date. A second verification unit that determines how much the slot quantity is to be expanded, changes the slot quantity of the corresponding item in the slot information table, records the reserved quantity, and outputs a delivery date response to an output device; and the second verification unit. The verification unit operates as a message notification unit that outputs to the output device a message that instructs how much the number of calendar bucket frames is to be expanded for the corresponding item verified to be shippable on the requested delivery date. Features.
[0031]
In addition, the delivery date verification program of the present invention stores the computer in a frame information table storing the frame quantity and the reserved quantity for each item for each calendar bucket, and a maximum information for storing the maximum frame quantity for each item for each calendar bucket. The requested delivery date based on the frame quantity and the reserved quantity of the corresponding item stored in the frame information table with respect to the item, the requested delivery date, and the ordered quantity of the order information given from the order information storage device. A first verification unit that verifies whether or not it can be shipped to the requested delivery date, and outputs a delivery date response to the output device if the shipment can be performed at the requested delivery date. Is verified, the requested delivery date of the corresponding item stored in the maximum frame information table with respect to the item, the requested delivery date, and the ordered quantity of the order information given from the order storage device. Verifies whether or not the item can be shipped to the requested delivery date based on the maximum slot quantity up to the point and the reserved quantity of the corresponding item up to the requested delivery date stored in the slot information table. A second verification unit that determines how much the number of frames is to be increased, changes the number of frames of the corresponding item in the frame information table, records the allocated number, and then outputs a delivery date response to an output device; and the second verification unit. Operates as a message notification unit that stores in the delivery date response storage device a message instructing how much the number of calendar bucket slots should be expanded for the corresponding item that has been verified to be shippable by the requested delivery date by the verification unit. It is characterized by making it.
[0032]
Further, the delivery date verification program according to the present invention is a computer which stores a computer with a frame information table storing the frame quantity and the reserved quantity of each item for each calendar bucket, and a maximum information storing the maximum frame quantity of each item for each calendar bucket. A frame information table, a message notification destination information table for storing a message notification destination for each item, an item of order information given from an order storage device, a corresponding item stored in the frame information table for a requested delivery date and an order quantity. A first verification that verifies whether or not shipment can be made to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date, and if the shipment can be made to the requested delivery date, stores the delivery date answer in the delivery date answer storage device. And when the first verification unit verifies that the shipment cannot be made within the requested delivery date, the item of the order information provided from the order storage device and the requested delivery date. And the requested delivery date based on the maximum slot quantity up to the requested delivery date of the corresponding item stored in the maximum slot information table and the reserved quantity up to the requested delivery date of the corresponding item stored in the slot information table with respect to the order quantity. Verifies whether or not it can be shipped to the customer, and if so, determines how much the calendar bucket's quota should be expanded, and changes the quota of the corresponding item in the quota information table and records the reserved quantity And a second verification unit that stores the delivery date answer in the delivery date answer storage device, and which calendar bucket frame quantity is determined for the corresponding item verified to be shippable to the requested delivery date by the second verification unit. A message for notifying, via an information transmission medium, a message indicating how much the message is to be expanded to a message notification destination stored in the message notification destination information table. Characterized in that operate as di notification unit.
[0033]
Still further, the delivery date verification program of the present invention is characterized in that the second verification unit allocates the allocated quantity to be increased in the range of the maximum frame quantity sequentially from the calendar bucket close to the required delivery date in the past direction.
[0034]
In addition, the delivery date verification program of the present invention, when the second verification unit verifies that shipment is impossible at the requested delivery date, moves the requested delivery date to the next calendar bucket in the future to search for an answer delivery date. The feature is that the verification is repeated until the product can be shipped.
[0035]
In FIG. 1, the frame storage unit 31 stores frame information serving as a basis for a delivery date response such as a material procurement plan, a production plan, and a load plan in chronological order, for example, monthly. The frame information is the number of material procurement plans if it is based on the material procurement plan, the number of production plans if it is based on the production plan, and the man-hour if it is based on the load plan. In addition, the frame storage unit 31 also stores an allocation quantity indicating how many of the frame quantities have been used for the delivery date response as a result of the delivery date response.
[0036]
The first verification unit 21 receives order information from the input device 1. For example, it is assumed that an order quantity of 5 units has been given to the item AAA-12345 with the requested delivery date 02/09/12 as the order information. The first verification unit 21 checks the frame information on the item AAA-12345 from the frame storage unit 31. If the available AAA quantity of the item AAA-12345 stored in the frame storage unit 31 as of 02/09/12 is larger than 5, the response delivery date is answered as requested and "02/09/12". The available slot quantity is a difference between the total slot quantity up to 02/09/12 stored in the slot storage unit 31 and the total reserved quantity. If the available quota quantity of the item AAA-12345 stored in the quota storage unit 31 as of 02/09/12 is smaller than 5, the requested quota date cannot be met with the initially planned quota quantity.
[0037]
In such a case, the second verification unit 22 checks the maximum amount of the item AAA-12345 as of 02/09/12 stored in the maximum amount storage unit 32, and stores the maximum amount in the frame storage unit 31. The difference from the reserved quantity up to 02/09/09 is calculated. If this difference is greater than 5, the response delivery date is answered as requested and "02/09/12" is answered. At the same time, the second verification unit 22 enlarges the frame quantity of the item AAA-12345 stored in the frame storage unit 31 by the required quantity, and sends a notification that the frame quantity has been expanded to the message notification unit. Ask 23. The message notification unit 23 that has received the request notifies the user that the number of slots needs to be increased.
[0038]
In this way, it is possible to respond to the order information that does not satisfy the required delivery date according to the requested delivery date from the customer as much as possible.
[0039]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.
[0040]
[First Embodiment]
Referring to FIG. 1, a delivery date answering system according to a first embodiment of the present invention includes an input device 1 such as a keyboard, a delivery date verification device 2 operated by program control, a storage device 3 for storing information, An output device 4 such as a display device or a printing device constitutes a main part thereof.
[0041]
The storage device 3 includes a frame storage unit 31 and a maximum frame storage unit 32.
[0042]
The frame storage unit 31 stores the frame quantity of each item for each calendar bucket such as period, quarter, month, week, and day. The frame information is the planned number of material procurement, the planned number of production, the number of man-hours, and the like. Further, of these pieces of frame information, the allocation quantity allocated to the actual confirmed order is stored for each item and calendar bucket in the same manner as the frame quantity.
[0043]
The maximum quota storage unit 32 stores the maximum quota quantity for each item for each calendar bucket such as term, quarter, month, week, and day. The same item as that stored in the frame storage unit 31 is stored in the maximum calendar storage unit 32 in the same calendar bucket. The maximum quota quantity is the maximum number of material procurement plans, production plans, man-hours, etc., which can be increased without making large adjustments when there is a confirmed order larger than the originally planned quota quantity. For example, if materials are procured from an external vendor, and the order quantity is up to 20% of the initially proposed forecast quantity, and the contract quantity with the external vendor permits the order quantity, the offered forecast quantity Is the quota quantity, and the quantity increased by 20% can be defined as the maximum quota quantity.
[0044]
The delivery date verification device 2 includes a first verification unit 21, a second verification unit 22, and a message notification unit 23.
[0045]
The first verification unit 21 compares the item quantity, the requested delivery date, and the ordered quantity of the order information provided from the input device 1 with the frame quantity and the reserved quantity up to the required delivery date of the corresponding item stored in the frame storage unit 31. It verifies whether or not it can be shipped on the required delivery date, and outputs a delivery date response to the output device 4 if it can be shipped on the required delivery date.
[0046]
The second verification unit 22 determines the maximum frame quantity and the frame up to the requested date of the corresponding item stored in the maximum frame storage unit 32 with respect to the item, the requested delivery date, and the ordered quantity of the order information provided from the input device 1. Based on the reserved quantity of the relevant item up to the required delivery date stored in the storage unit 31, it is verified whether or not the product can be shipped to the required delivery date, and if it can be shipped, the amount of the frame of which calendar bucket is increased by how much. Is determined, the frame quantity of the corresponding item in the frame storage unit 31 is changed and the reserved quantity is recorded, and then the delivery date response is output to the output device 4.
[0047]
The message notification unit 23 sends to the output device 4 a message (hereinafter referred to as a procurement instruction), which is verified by the second verification unit 22 and instructs how much the number of calendar bucket slots is to be expanded for which item. By outputting the information, a person in charge of operation such as a person in charge of material order is notified.
[0048]
Referring to FIG. 2, the processing of the delivery date verification device 2 includes an allocatable frame quantity calculation step A1, an order quantity or more determination step A2, a maximum allocatable frame quantity calculation step A3, an order quantity or more determination step A4, It consists of a delivery date search step A5, a required quantity expansion step A6, a procurement instruction output step A7, a reserved quantity recording step A8, and a delivery date reply output step A9.
[0049]
Next, the overall operation of the delivery date answering system according to the first embodiment thus configured will be described in detail with reference to FIGS.
[0050]
The order information provided from the input device 1 is supplied to the first verification unit 21.
[0051]
The first verification unit 21 checks the frame information of the item input as the order information stored in the frame storage unit 31, and determines the total amount of the frame quantity and the total amount of the allocated quantity until the requested delivery date input as the order information. And find the difference. The difference between the total amount of the quota and the total amount of the quota becomes the quota quota that can be allocated to a new order at the requested delivery date (step A1).
[0052]
Next, the first verification unit 21 compares the order quantity input as the order information with the obtained reservable frame quantity, and checks whether or not the reservable frame quantity is equal to or greater than the order quantity (step A2).
[0053]
If the allocatable slot quantity is equal to or greater than the order quantity, the first verification unit 21 allocates the order quantity to the requested delivery date, and records the allocation quantity of the corresponding item in the frame storage unit 31 (step A8). Then, a delivery date response with the requested delivery date as the response delivery date is given to the output device 4 (step A9).
[0054]
If it is determined in step A2 that the allocatable slot quantity is less than the order quantity, the first verification unit 21 gives the order information to the second verification unit 22.
[0055]
The second verification unit 22 checks the maximum quota information of the item input as the order information stored in the maximum quota storage unit 32, and determines the total amount and the quota of the maximum quota quantity until the requested delivery date input as the order information. The difference between the allocated quantity up to the requested delivery date stored in the storage unit 31 and the total quantity is determined. The difference between the total amount of the maximum quota quantity and the total quantity of the quota quantity is the maximum quota quantity that can be allocated to a new order at the requested delivery date when the quota quantity is expanded to the maximum quota quantity (step A3).
[0056]
Next, the second verification unit 22 compares the order quantity input as the order information with the obtained maximum quota quantity, and checks whether the maximum quota quantity is equal to or more than the order quantity (step A4). ).
[0057]
When it is determined that the maximum allocatable slot quantity is less than the order quantity (NO in step A4), the second verification unit 22 sets the date of interest in units of calendar buckets stored in the frame storage unit 31. Proceeding in the future direction, the same order information is delivered again to the first verification unit 21 with the date of interest as the requested delivery date, and the same processing is repeated until the answer delivery date is obtained. (Step A5)
[0058]
If the maximum allocatable slot quantity is equal to or larger than the order quantity (yes in step A4), the second verification unit 22 increases the slot quantity of the corresponding item in the slot storage unit 31 by the required quantity of the slot quantity (step S4). A6) The procurement instruction for instructing how much the number of frames of which calendar bucket of which item is to be expanded is output to the output device 4 through the message notification unit 23 (step A7). Finally, the second verification unit 22 allocates the order quantity to the requested delivery date and records the allocated quantity of the corresponding item in the frame storage unit 31 (step A8), and then sets the requested delivery date as the answer delivery date. Is given to the output device 4 (step A9).
[0059]
Next, a description will be given using a specific example.
[0060]
FIG. 3 is an example in which the forecast quantity presented to the member vendor is used as the frame information. As shown in FIG. 3, the frame storage unit 31 stores the weekly amount of the item A in the weekly bucket in the same manner as the frame amount. On the other hand, in the maximum quota storage unit 32, the maximum quota quantity of the item A in September is registered as a weekly bucket with a 20% increase in the quota quantity. This assumes that a contract has been made with the component vendor to deal with an increase in the forecast quantity of up to 20%.
[0061]
In this state, if there is order information from the input device 1 indicating that the number of items A is 10 in September 2 weeks, this order information is supplied to the first verification unit 21. The first verification unit 21 examines the frame information of the item A input as the order information stored in the frame storage unit 31 and determines the amount of the frame until September 2 of the requested delivery date input as the order information. The difference between the total amount (200 pieces) and the total amount of the allocation quantity (180 pieces) is obtained, and it is determined that there are 20 allocationable frame quantities. Next, the first verification unit 21 compares 10 pieces of the order quantity input as the order information and 20 pieces of the allocatable capacity quantity, and since the available capacity quantity is equal to or more than the order quantity, the first verification unit 21 calculates the requested delivery date. It is determined that allocation is possible, and the order quantity of 10 pieces is allocated in September 2 weeks of the requested delivery date, and the quantity of allocation in September 2 weeks in the frame storage unit 31 is changed from the current 80 pieces to 90 pieces to record. After that, a delivery date reply with the response delivery date as the required delivery date of September 2 weeks is given to the output device 4.
[0062]
FIG. 4 shows a case where the input device 1 receives the order information of 30 items A in the second week of September 2 with the same frame quantity, reserved quantity, and maximum frame quantity as in FIG. The first verification unit 21 examines the frame information of the item A input as the order information stored in the frame storage unit 31 and determines the amount of the frame until September 2 of the requested delivery date input as the order information. The difference between the total amount (200 pieces) and the total amount of the allocation quantity (180 pieces) is obtained, and it is determined that there are 20 allocationable frame quantities. Next, the first verification unit 21 compares the order quantity of 30 pieces entered as the order information with the reserve quantity of 20 pieces. The information is provided to the second verification unit 22. The second verification unit 22 checks the maximum quota information of the item A input as the order information stored in the maximum quota storage unit 32, and determines the maximum requested delivery date input as the order information until September 2 weeks. The difference between the total amount of the frame quantity (240 pieces) and the total quantity of the allocation quantity (180 pieces) is determined, and it is determined that there is a maximum available quantity of 60 pieces. Next, the second verification unit 22 compares the order quantity of 30 pieces input as the order information with the maximum reserve quantity of 60 pieces, and determines that the maximum reserve quantity is larger than the order quantity. Judgment that it is possible to allocate by the delivery date, after expanding the frame quantity for the September 2 weeks in the frame storage unit 31 by the shortage of the frame quantity by 10 and changing from the current 100 to 110 to record The procurement instruction to the effect that the frame quantity of the item A needs to be increased by 10 pieces in the week of September 2 through the message notification section 23 is output to the output device 4 and the quantity of the order 10 pieces in the week 2 of the requested delivery date Is recorded, the allocation quantity for the September 2 week in the frame storage unit 31 is changed from the current 80 pieces to 110 pieces and recorded, and then the delivery date answer with the answer delivery date as the required delivery date of September 2 weeks is output. Give to device 4.
[0063]
In the example of FIG. 4, in the past, in the range of the quota amount, it cannot be allocated until September 3 weeks, and the response delivery date is delayed with respect to the requested delivery date. Is dynamically expanded to provide a delivery date according to the required delivery date.
[0064]
FIG. 5 shows a case where the input device 1 receives order information of 170 items A in the second week of September 2 with the same frame quantity, reserved quantity, and maximum frame quantity as those in FIG. The first verification unit 21 examines the frame information of the item A input as the order information stored in the frame storage unit 31 and determines the amount of the frame until September 2 of the requested delivery date input as the order information. The difference between the total amount (200 pieces) and the total amount of the allocation quantity (180 pieces) is obtained, and it is determined that there are 20 allocationable frame quantities. Next, the first verification unit 21 compares 170 pieces of the order quantity input as the order information with 20 pieces of the allocatable slot quantity. The information is provided to the second verification unit 22. The second verification unit 22 checks the maximum quota information of the item A input as the order information stored in the maximum quota storage unit 32, and determines the maximum requested delivery date input as the order information until September 2 weeks. The difference between the total amount of the frame quantity (240 pieces) and the total quantity of the allocation quantity (180 pieces) is determined, and it is determined that there is a maximum available quantity of 60 pieces. Next, the second verification unit 22 compares 170 pieces of the order quantity input as the order information with 60 pieces of the maximum reservable quantity, and determines that the maximum reservable quantity is less than the order quantity. It is determined that allocation is impossible due to the delivery date, and the date of interest is advanced in the future direction in units of calendar buckets stored in the frame storage unit 31, and is set to be September 3 weeks. Here, again, the first verification unit 21 verifies the item A against the order information indicating that the order quantity is 170 pieces in the delivery date of September 3 weeks. In this example, as of September 3rd, the allocatable slot quantity is (100 + 100 + 150)-(100 + 80 + 50) = 120 pieces, and the order quantity is insufficient for 50 pieces. Provided to the section 22. The second verification unit 22 checks the maximum quota information of the item A input as the order information stored in the maximum quota storage unit 32, and determines the total quantity (420 pieces) of the maximum quota quantity until September 3rd. The difference between the allocated quantity and the total quantity (230 pieces) is obtained, and it is determined that there is a maximum available quantity of 190 pieces. Next, the second verification unit 22 compares the order quantity of 170 pieces entered as the order information with the maximum reserve quantity of 190 pieces, and focuses on the fact that the maximum reserve quantity is equal to or more than the order quantity. It is determined that the allocation can be made by date, and the frame quantity of the corresponding item in the frame storage unit 31 is expanded by 50 for the shortage of the frame quantity, and the frame quantity for the September 3rd week is changed from the current 150 to 180, 9 After changing the frame quantity for the two weeks of the month from the current 100 pieces to 120 pieces and recording, the item A is expanded by 20 pieces in the second week of September and 30 pieces in the third week of September through the message notification section 23. The procurement instruction to the effect that it is necessary is output to the output device 4, and 40 pieces are allocated in September 2 weeks and 130 pieces are allocated in September 3 weeks. To 120 pieces, and change the reserve quantity for September 3 weeks from the current 50 pieces to 180 pieces and record After Tsu, give the delivery date reply was September 3 weeks of the request delivery delay the answer delivery to the output device 4.
[0065]
In the example of FIG. 5, in the range of the quota quantity, the available quota quantity is insufficient even in September 4 weeks, and the delivery date cannot be answered. However, the quota quantity is dynamically expanded based on the maximum quota quantity. The delivery date is answered.
[0066]
According to the first embodiment, the initially planned quota quantity and the maximum quota quantity that can be dealt with with the maximum effort are registered, and when an order is received that exceeds the initially planned quota quantity, it is automatically registered. In order to respond to the delivery date by expanding the frame quantity as much as necessary up to the maximum frame quantity, even if an order exceeds the originally planned quantity in the delivery date response when the order is confirmed, the requested delivery date from the customer without any labor This has the effect of providing a delivery date answer that is as satisfying as possible.
[0067]
Also, when more quota is needed than originally planned, the appropriate person is automatically notified when and how much quota needs to be increased for which item. This has the effect of reducing the number of management steps required to take an action to increase the number of slots.
[0068]
[Second embodiment]
Next, a second embodiment of the present invention will be described in detail with reference to the drawings.
[0069]
Referring to FIG. 6, in the delivery date reply system according to the second embodiment, the order receiving storage device 1 is different from the input device 1 in the delivery date reply system according to the first embodiment shown in FIG. The only difference is that the delivery date answer storage device 4 is provided instead of the output device 1 in the delivery date answering system according to the first embodiment. Therefore, the other parts which are not particularly mentioned are denoted by the same reference numerals and their detailed description is omitted.
[0070]
The order storage device 1 is a storage device such as a fixed disk in itself or another system. The delivery date verification device 2 performs batch processing on a plurality of order information stored in the order storage device 1 and performs the same operation as the delivery date reply system according to the first embodiment shown in FIG. The delivery date answer storage device 4, which is a storage device such as a fixed disk in the own system or another system, collectively stores the delivery date answer.
[0071]
In the delivery date reply system according to the second embodiment configured as described above, although there is a difference between real-time processing and batch processing, the delivery date reply system according to the first embodiment shown in FIG. It goes without saying that the same effect can be obtained.
[0072]
Since the operation of the delivery date reply system according to the second embodiment is more similar to the operation of the delivery date reply system according to the third embodiment described later, the delivery date reply according to the third embodiment is performed. The detailed description of the operation of the system will be omitted with the description of the operation of the system.
[0073]
[Third Embodiment]
Referring to FIG. 7, in the delivery date reply system according to the third embodiment, a message notification destination storage unit 33 and an information transmission medium 5 are added to the configuration in the second embodiment shown in FIG. The only difference is. Therefore, the other parts which are not particularly mentioned are denoted by the same reference numerals and their detailed description is omitted.
[0074]
The message notification destination storage unit 33 stores, for each item, a notification destination for notifying a procurement instruction that the number of slots needs to be increased, and also stores a procurement instruction to be notified. The message notification unit 23 has a function of collectively providing the information transmission medium 5 for each procurement instruction to be notified to the same notification destination in accordance with the information stored in the message notification destination storage unit 33. The information transmission medium 5 has an information transmission function such as e-mail, group fair, and the like.
[0075]
Referring to FIG. 8, the processing of the delivery date verification device 2 includes an allocatable slot quantity calculation step A1, an order quantity or more determination step A2, a maximum allocatable slot quantity calculation step A3, an order quantity or more determination step A4, Delivery date search step A5, required quantity expansion step A6, procurement instruction recording step A7 ', reserved quantity recording step A8, delivery date response recording step A9', answer completion judgment step A10 for all items, response target It consists of an order information taking out step A11 and a procurement instruction notifying step A12.
[0076]
Next, the operation of the delivery date answering system according to the third embodiment thus configured will be described in detail with reference to FIG. 7 and FIG.
[0077]
The operations of the first verification unit 21 and the second verification unit 22 in the delivery date reply system according to the third embodiment shown in steps A1 to A6 and A8 in FIG. The operation is the same as the operation of the first verification unit 21 and the second verification unit 22 in the delivery date reply system according to the embodiment, and thus the description is omitted.
[0078]
In step A11, one piece of order information requiring a delivery date response is extracted from the order information stored in the order storage device 1 and given to the first verification unit 21. An answer delivery date is obtained by the above-described procedure for the extracted order information. At this time, if the frame quantity is expanded in step A6, a procurement instruction indicating how much the frame quantity of which calendar bucket of which item is expanded is recorded in the message notification destination storage section 33 through the message notification section 23 (step A7). ').
[0079]
In the delivery date reply system according to the first embodiment shown in FIG. 1, the requested delivery date reply is given to the output device 4 in step A9. The delivery date response is stored and accumulated in the delivery date storage device 4 (step A9 ').
[0080]
Next, if the delivery date response has not been completed for all the order information that requires the delivery date response among the order information stored in the order storage device 1 (NO in step A10), the delivery date verification device 2 returns to step A11 again. The control is returned, and processing is performed for the next order information to be answered.
[0081]
If the delivery date response has been completed for all orders that require the delivery date response (Yes in step A10), the message notification unit 23 sends the procurement instruction stored in the message notification destination storage unit 33 from the item to the notification destination. The information transmission medium 5 is specified, and given to the information transmission medium 5 so as to be collectively notified for each procurement instruction of the same notification destination (steps A10 and A12).
[0082]
Next, a specific example will be described.
[0083]
As shown in FIG. 9, the order storage device 1 stores three pieces of order information, ie, order information 1, order information 2, and order information 3 for which the delivery date has not yet been sent. As information, it is assumed that the item A and the item C store the vendor X, and the item B stores the vendor Y.
[0084]
First, the order information 1, which is the first order information, is retrieved from the order storage device 1 (step A11), and the answer delivery date is obtained. Here, as shown in FIG. 9, it is assumed that a delivery date response on the premise of an increase in the number of five slots is obtained in the second week of September. In step A6, the message notification destination storage unit sends a procurement instruction indicating that it is necessary to increase the number of items A by 5 units in September 2 weeks after the number of slots of item A is increased in units of 5 units in September 2 weeks. 33 (step A7 '). Then, after recording the allocation quantity (step A8), the response delivery date September 2 weeks for the ordered item A in the order information 1 is recorded in the delivery date answer storage device 4 (step A9 ').
[0085]
Next, since the order information for which the delivery date has not been answered remains in the order storage device 1, the next order information 2 is extracted from the order storage device 1 (step A11), and the answer delivery date is obtained. Here, as shown in FIG. 9, it is assumed that a delivery date response on the premise of an increase in the quantity of two slots is obtained in the second week of September. In step A6, after the quantity of the two items is expanded in the second week of September 2 for the item B, a procurement instruction indicating that the number of the item B needs to be increased by two in the second week of September 2 is sent to the message notification destination storage unit. 33 (step A7 '). Then, after recording the allocation quantity (step A8), the response delivery date of September 2 weeks for the ordered item B of the order information 2 is recorded in the delivery date answer storage device 4 (step A9 ').
[0086]
Subsequently, since the order storage information for which the delivery date response has not yet been made remains in the order storage device 1, the next order information 3 is extracted from the order storage device 1 (step A11), and the answer delivery date is obtained. Here, as shown in FIG. 9, it is assumed that a delivery date response is obtained in September 3 weeks on the assumption that the quantity of one slot is expanded. In step A6, the message notification destination storage unit sends a procurement instruction indicating that it is necessary to increase the number of items C by one in September 3 weeks after the number of slots in item C is increased by one in September 3 weeks. 33 (step A7 '). Then, after recording the reserved quantity (step A8), the response delivery date of September 3 weeks for the ordered item C in the order information 3 is recorded in the delivery date answer storage device 4 (step A9 ').
[0087]
As a result, there is no order information for which the delivery date has not yet been answered in the order storage device 1, and the procurement instruction stored so far in the message notification destination storage unit 33 is determined from the item, and the notification destination is determined. The instructions are put together, and the procurement instruction for the item A and the item C is notified to the vendor X and the procurement instruction for the item B is notified to the vendor Y via the information transmission medium 5 (step A12).
[0088]
【Example】
[One Example of First Embodiment]
As a specific example of realizing the delivery date reply system according to the first embodiment shown in FIG. 1 using a computer, a delivery date verification executed by a computer as an input device 1 and a computer as a delivery date verification device 2 Examples of using a hard disk as the program and the storage device 3 and using a display as the output device 4 are given.
[0089]
Each data in the frame storage unit 31 and the maximum frame storage unit 32 is stored on a hard disk. However, when actually used, a database (hereinafter abbreviated as DB) is generally used. In this case, the frame storage unit 31 is a frame information table, and the maximum frame storage unit 32 is a maximum frame information table. When data is accessed by a DBMS (Database Management System), it is automatically controlled whether data is retrieved from the hard disk or data read from the hard disk is expanded in a memory and retrieved from the memory. .
[0090]
FIG. 10 is a block diagram showing an example of the delivery date reply system according to the first embodiment having the above-described configuration. Corresponding portions are denoted by corresponding reference numerals, and detailed description thereof will be omitted.
[0091]
Next, the operation of this embodiment will be described based on the configuration of FIG.
[0092]
It is assumed that the frame quantity and the allocation quantity are registered in advance in the frame information table 31 on the DB 3 in the format as shown in Table 1.
[0093]
[Table 1]

[0094]
It is also assumed that the maximum slot quantity is registered in advance in the maximum slot information table 32 on the DB 3 in the format as shown in Table 2.
[0095]
[Table 2]

[0096]
In the above example, the frame mesh (date) represents a week unit.
[0097]
In the following description, the frame of the current week (the week including today) is invalid, and the frame of the week is unavailable.
[0098]
In this case, the response delivery date is also on a weekly basis. When the delivery date is answered on a daily basis, the frame quantity, the reserved quantity, and the maximum frame quantity are managed by a daily mesh. The number of items (products) for which the delivery date is to be answered may be several thousand, and the frame mesh is held for the period for which the delivery date is to be answered.
[0099]
In the frame information table 31 and the maximum frame information table 32, records of the number of items × frame mesh exist, and the data amount is tens of thousands to hundreds of thousands, so that it is very difficult to perform the following procedures manually. It is. For this reason, in order to give a delivery date within an allowable time, it is necessary to implement this embodiment using a computer.
[0100]
It is assumed that the sales person inputs the order information indicating that the order quantity of the item A is 50 on the required delivery date of September 10 from the keyboard 1 to the computer.
[0101]
First, the first verification unit 21 obtains a difference between the total amount of the quota quantity and the total quantity of the reserved quantity up to the requested delivery date input as the order information. This is done by extracting records from the frame information table 31 where the item = item A and the mesh start date is before the requested delivery date and after today, and for the extracted records, the sum of the difference between the frame quantity and the reserved quantity is used. Find the quantity. This processing is obtained by issuing an SQL (Structured Query Language) of the following image to the DB3.
[0102]
SELECT
SUM (quota quantity-reserved quantity)
FROM frame information table
WHERE Item = 'Item A'
AND Mesh Start Date BETWEEN TODAY AND 9/10
[0103]
When the DB3 is not used, the information corresponding to the frame information table 31 is read line by line from the hard disk, and the item = item A, and (frame amount-allocated amount) is added only for the line whose mesh start date is before the requested delivery date and after today. Perform loop processing.
[0104]
In the present embodiment, assuming today is 8/29, 20 pieces of available slots are obtained.
[0105]
By comparing the obtained available quota quantity of 20 pieces with the order quantity of 50 pieces, it is determined that the available quota quantity of 20 pieces is short of 30 pieces.
[0106]
Next, the second verification unit 22 extracts records of the item = item A, the mesh start date of which is before the requested delivery date and after this date from the maximum slot information table 32 in order to check the satisfaction status with the maximum slot quantity, The total amount of the maximum quota quantity is obtained for the extracted records, and the record of the item = item A, the mesh start date of which is before the required delivery date and after today is extracted from the quota information table 31, and the total quantity of the allocated quantity is obtained for the extracted records. The difference between the total amount of the maximum allocation amount and the total amount of the allocation amount obtained here is the maximum available allocation amount when the maximum allocation amount is used. This processing is obtained by issuing an SQL of the following image to DB3.
[0107]
SELECT
SUM (Maximum quota)
FROM maximum frame information table
WHERE Item = 'Item A'
AND Mesh Start Date BETWEEN TODAY AND 9/10
[0108]
SELECT
SUM (Reserved quantity)
FROM frame information table
WHERE Item = 'Item A'
AND Mesh Start Date BETWEEN TODAY AND 9/10
[0109]
When the DB3 is not used, the information corresponding to the maximum frame information table 32 is read from the hard disk one line at a time, and the loop processing of adding the maximum frame quantity only for the line where the item = item A and the mesh start date is before the requested delivery date and after today. Then, the information corresponding to the frame information table 31 is read line by line from the hard disk, and a loop process of adding the allocation quantity only for the line where the item = item A and the mesh start date is before the requested delivery date and after today is performed.
[0110]
In the present embodiment, assuming that today is August 29, the execution result will be 240 in the first SQL, 180 in the second SQL, and the maximum available frame as the difference between them. The quantity is 60 pieces.
[0111]
Since the order quantity is 50 pieces and the maximum available quantity is 60 pieces, it is understood that the delivery date can be answered if the maximum available quantity is available, and the shortage quantity of 30 pieces obtained earlier was expanded. , And the response date is September 10th.
[0112]
Next, the shortage of 30 pieces is expanded.
[0113]
The registration method is as follows: items = item A, and records in which the mesh start date is before the answer delivery date and after today are extracted from each of the frame information table 31 and the maximum frame information table 32 in the order of the latest mesh start date. The data is updated by expanding the frame quantity of the frame information table 31 until the shortage is compensated for within a range not exceeding the maximum frame quantity.
[0114]
Data extraction from each of the frame information table 31 and the maximum frame information table 32 is performed by issuing the following SQL to the DB 3.
[0115]
SQL1:
SELECT
Mesh start date
, Maximum frame quantity
FROM maximum frame information table
WHERE Item = 'Item A'
AND Mesh Start Date BETWEEN TODAY AND 9/10
ORDER BY Mesh start date DESC
[0116]
SQL2:
SELECT
Mesh start date
, Frame quantity
FROM frame information table
WHERE Item = 'Item A'
AND Mesh Start Date BETWEEN TODAY AND 9/10
ORDER BY Mesh start date DESC
[0117]
In this example, for SQLl, data with a mesh start date of September 8 and a maximum frame quantity of 120, and data with a mesh start date of September 1 and a maximum frame quantity of 120 are extracted.
[0118]
For SQL2, data with a mesh start date of September 8 and a frame quantity of 100 pieces, and data with a mesh start date of September 1 and a frame quantity of 100 pieces are extracted.
[0119]
Regarding the frame quantity for the week including September 8, there is room for 120−100 = 20, so the frame quantity is first expanded to 20 and updated.
[0120]
The update of the frame information table 31 updates the frame quantity using the item and the mesh start date as keys.
[0121]
The image of SQL is as follows.
[0122]
UPDATE frame information table
SET quota quantity = quota quantity + 20
WHERE Item = 'Item A'
AND mesh start date = 9/8
[0123]
Regarding the frame quantity for the week including September 1, there is room for 120−100 = 20 pieces, but the remaining shortage is 10, so the quantity is expanded by 10 and the frame quantity is updated.
[0124]
The update of the frame information table 31 updates the frame quantity using the item and the mesh start date as keys.
[0125]
The image of SQL is as follows.
[0126]
UPDATE frame information table
SET quota quantity = quota quantity + 10
WHERE Item = 'Item A'
AND mesh start date = 9/1
[0127]
Next, 50 orders received with a response date of September 10 are registered in the allocation quantity of the frame information table 31.
[0128]
The registration method is to extract records from the frame information table 31 where the item = item A and the mesh start date is before the answer delivery date and after this date in the order of the latest mesh start date, and increase the allocation quantity within a range not exceeding the frame quantity to transfer the data. Update.
[0129]
Data extraction from the frame information table 31 is performed by issuing an SQL of the following image to the DB 3.
[0130]
SELECT
Mesh start date
, Frame quantity
, Reserved quantity
FROM frame information table
WHERE Item = 'Item A'
AND Mesh Start Date BETWEEN TODAY AND 9/10
ORDER BY Mesh start date DESC
[0131]
In this example, the item is item A, the mesh start date is September 8, the mesh end date is September 14, the frame quantity is 120 pieces, the allocation quantity is 80 pieces, and the item is item A, mesh start date , The mesh end date is September 7, the frame quantity is 110, and the allocation quantity is 100.
[0132]
Since the number of slots has been expanded by the above procedure, it can be obtained with the result reflected.
[0133]
Since there is room for 120-180 = 40 for the weekly amount including September 8, the allocation amount is first expanded and the allocated amount is updated.
[0134]
To update the frame information table 31, the allocation quantity is updated using the item and the mesh start date as keys.
[0135]
The image of SQL is as follows.
[0136]
UPDATE frame information table
SET allocation quantity = frame quantity + 40
WHERE Item = 'Item A'
AND mesh start date = 9/8
[0137]
Regarding the frame quantity for the week including September 1, there is room for 110-100 = 10 pieces. Therefore, the remaining quantity of the order quantity is expanded to 10 pieces and the reserved quantity is updated.
[0138]
To update the frame information table 31, the allocation quantity is updated using the item and the mesh start date as keys.
[0139]
The image of SQL is as follows.
[0140]
UPDATE frame information table
SET reserved quantity = frame quantity + 10
WHERE Item = 'Item A'
AND mesh start date = 9/1
[0141]
When the DB3 is not used, the processing is performed by reading the data from the hard disk one line at a time into the memory, updating the data on the memory, and then writing the data by random access to the hard disk. Is omitted.
[0142]
[One Example of Second Embodiment]
FIG. 11 is a block diagram showing an example of a delivery date reply system according to the second embodiment shown in FIG. The delivery date reply system according to the present embodiment includes an order receipt information file 1 as an order storage device, a delivery date verification program 2 executed by a computer as a delivery date verification device, a DB 3 as a storage device, and a delivery date as a delivery date response storage device. The answer file 4 constitutes the main part. The DB 3 includes a frame information table 31 as a frame storage unit and a maximum frame information table 32 as a maximum frame storage unit.
[0143]
Regarding the operation of the delivery date answering system of the present embodiment, the operation of the delivery date answering system according to the second embodiment shown in FIG. 6 and the implementation of the delivery date answering system according to the first embodiment shown in FIG. Detailed explanation is omitted because it can be easily analogized from the operation of the example.
[0144]
[One Example of Third Embodiment]
FIG. 12 is a block diagram showing an example of a delivery date reply system according to the third embodiment shown in FIG. The delivery date reply system according to the present embodiment includes an order receipt information file 1 as an order storage device, a delivery date verification program 2 executed by a computer as a delivery date verification device, a DB 3 as a storage device, and a delivery date as a delivery date response storage device. The main part is composed of the answer file 4 and the Internet 5 as an information transmission medium. The DB 3 is provided with a frame information table 31 as a frame storage unit, a maximum frame information table 32 as a maximum frame storage unit, and a message notification destination information table 33 as a message notification destination storage unit.
[0145]
Regarding the operation of the delivery date reply system of the present embodiment, the operation of the delivery date reply system according to the third embodiment shown in FIG. 7 and one implementation of the delivery date reply system according to the first embodiment shown in FIG. Detailed explanation is omitted because it can be easily analogized from the operation of the example.
[0146]
【The invention's effect】
The first effect is that, even if an order larger than the originally planned quantity is received in the delivery date response at the time when the order is confirmed, a delivery date answer that satisfies the requested delivery date from the customer as much as possible can be issued without any labor. The reason is that the initially planned quota quantity and the maximum quota quantity that can be handled with maximum effort are registered, and when the order is received more than the originally planned quota quantity, it is automatically necessary to reach the maximum quota quantity The reason is to increase the number of slots and answer the delivery date.
[0147]
The second effect is that, when a larger number of frames is required than originally planned, the number of management steps for taking an action to increase the number of frames can be reduced. The reason is to automatically notify the appropriate person in charge of which item, when and how much the quota needs to be expanded.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a configuration of a delivery date reply system according to a first embodiment of the present invention.
FIG. 2 is a flowchart showing a process of a delivery date verification device in FIG. 1;
FIG. 3 is a diagram illustrating an example of using a forecast quantity presented to a member vendor as a frame quantity in the delivery date answering system according to the first embodiment.
FIG. 4 is a diagram showing a case in which order information is received from the input device in the state shown in FIG. 3 in the delivery date reply system according to the first embodiment.
FIG. 5 is a diagram showing a case where order information is received from the input device in the state shown in FIG. 4 in the delivery date reply system according to the first embodiment.
FIG. 6 is a block diagram showing a configuration of a delivery date reply system according to a second embodiment of the present invention.
FIG. 7 is a block diagram showing a configuration of a due date reply system according to a third embodiment of the present invention.
FIG. 8 is a flowchart showing processing of the delivery date verification device in FIG. 7;
FIG. 9 In the delivery date reply system according to the third embodiment, order receipt information for which delivery date reply has not yet been made is stored in the order receipt storage device, and the message notification destination storage unit stores items A and C as notification destination information. Is a diagram illustrating a case where a vendor X is stored and an item B stores a vendor Y.
FIG. 10 is a block diagram showing an example of a delivery date reply system according to the first embodiment of the present invention.
FIG. 11 is a block diagram showing an example of a delivery date reply system according to a second embodiment of the present invention.
FIG. 12 is a block diagram showing an example of a due date reply system according to a third embodiment of the present invention.
[Explanation of symbols]
1 input device, order storage device, keyboard, order information file
2 Delivery date verification device, delivery date verification program
3 Storage device, database (DB)
4 Output device, delivery date storage device, display, delivery date answer file
21 First Verification Unit
22 Second verification unit
23 Message notification section
31 Frame storage unit, frame information table
32 Maximum frame storage unit, maximum frame information table
33 Message notification destination storage unit, message notification destination information table
A1 Allocable amount calculation step
A2 Judgment step for order quantity or more
A3 Maximum allocatable frame quantity calculation step
A4 Ordered quantity determination step
A5 Answer delivery date search step
A6 Frame quantity required quantity expansion step
A7 Procurement instruction output step
A7 'Procurement instruction recording step
A8 Allocated quantity recording step
A9 Delivery time answer output step
A9 'Response delivery date recording step
A10 Step to judge the end of all answer
A11 Step for extracting one order entry information
A12 Procurement instruction notification step

Claims (24)

A frame storage unit that stores a frame quantity and a reserved quantity for each item for each calendar bucket;
A maximum quota storage unit that stores the maximum quota quantity for each item for each calendar bucket;
With respect to the item, the requested delivery date, and the order quantity of the order information given from the input device, the product can be shipped to the requested delivery date based on the frame quantity and the reserved quantity of the corresponding item stored in the frame storage unit up to the required delivery date. A first verification unit that verifies whether or not the product can be shipped to the requested delivery date and outputs a delivery date answer to an output device;
When the first verification unit verifies that the shipment cannot be made within the requested delivery date, the items, the requested delivery date, and the ordered quantity of the order information provided from the input device are stored in the maximum frame storage unit. Verifies whether the product can be shipped to the requested delivery date based on the maximum quantity of the corresponding item up to the required delivery date and the reserved quantity of the relevant item up to the required delivery date stored in the frame storage unit, and can be shipped. Then, the second verification of determining which calendar bucket frame quantity should be increased by how much, changing the frame quantity of the corresponding item in the frame storage unit, recording the reserved quantity, and then outputting the delivery date response to the output device. Department and
A message notifying unit for outputting to the output device a message instructing how much the number of calendar bucket slots should be increased for the corresponding item verified to be shippable on the requested delivery date by the second verifying unit; Delivery time reply system characterized by having. A frame storage unit that stores a frame quantity and a reserved quantity for each item for each calendar bucket;
A maximum quota storage unit that stores the maximum quota quantity for each item for each calendar bucket;
With respect to the item of the order information provided from the order storage device, the requested delivery date, and the order quantity, it can be shipped to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the frame storage unit. A first verification unit that verifies whether there is a delivery date, and stores a delivery date answer in a delivery date answer storage device if it can be shipped to the requested delivery date;
When it is verified by the first verification unit that the shipment cannot be made within the requested delivery date, the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device are stored in the maximum frame storage unit. Verifying whether or not the item can be shipped to the required delivery date based on the maximum quantity of the relevant item up to the required delivery date and the reserved quantity of the relevant item up to the required delivery date stored in the frame storage unit, and then shipping If possible, determine how much the calendar bucket frame quantity should be expanded and how much, and after changing the frame quantity of the corresponding item in the frame storage unit and recording the reserved quantity, store the delivery date answer in the delivery date answer storage device. The verification unit of 2,
A message notification for storing in the delivery date response storage device a message instructing how much the number of calendar bucket frames is to be expanded for the corresponding item verified to be shippable to the requested delivery date by the second verification unit. And a delivery date answering system. A frame storage unit that stores a frame quantity and a reserved quantity for each item for each calendar bucket;
A maximum quota storage unit that stores the maximum quota quantity for each item for each calendar bucket;
A message notification destination storage unit that stores a message notification destination for each item;
With respect to the item of the order information provided from the order storage device, the requested delivery date, and the order quantity, it can be shipped to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the frame storage unit. A first verification unit that verifies whether there is a delivery date, and stores a delivery date answer in a delivery date answer storage device if it can be shipped to the requested delivery date;
When it is verified by the first verification unit that the shipment cannot be made within the requested delivery date, the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device are stored in the maximum frame storage unit. Verifying whether or not the item can be shipped to the required delivery date based on the maximum quantity of the relevant item up to the required delivery date and the reserved quantity of the relevant item up to the required delivery date stored in the frame storage unit, and then shipping If possible, determine how much the calendar bucket frame quantity should be expanded and how much, and after changing the frame quantity of the corresponding item in the frame storage unit and recording the reserved quantity, store the delivery date answer in the delivery date answer storage device. The verification unit of 2,
A message instructing how much the number of calendar bucket slots is to be expanded for the corresponding item verified to be shippable by the requested delivery date by the second verification unit is stored in the message notification destination storage unit. A message notification unit for notifying a notification destination of the received message via an information transmission medium. A frame information table that stores the frame quantity and the reserved quantity for each item for each calendar bucket,
A maximum quota information table storing the maximum quota quantity for each item for each calendar bucket,
With respect to the item, the requested delivery date, and the order quantity of the order information provided from the input device, the product can be shipped to the requested delivery date based on the slot quantity and the reserved quantity of the corresponding item stored in the slot information table up to the requested delivery date. A first verification unit that verifies whether or not the product can be shipped to the requested delivery date and outputs a delivery date answer to an output device;
When it is verified by the first verification unit that the shipment cannot be made within the requested delivery date, the items, the requested delivery date, and the ordered quantity of the order information provided from the input device are stored in the maximum frame information table. Verifies whether or not it is possible to ship to the requested delivery date based on the maximum quantity of the applicable item up to the required delivery date and the reserved quantity of the relevant item up to the required delivery date stored in the above frame information table, and it is possible to ship If so, determine which calendar bucket frame quantity should be increased by how much, change the frame quantity of the corresponding item in the frame information table, record the allocated quantity, and then output the delivery date response to the output device. Department and
A message notifying unit for outputting to the output device a message instructing how much the number of calendar bucket slots should be increased for the corresponding item verified to be shippable on the requested delivery date by the second verifying unit; Delivery time reply system characterized by having. A frame information table that stores the frame quantity and the reserved quantity for each item for each calendar bucket,
A maximum quota information table storing the maximum quota quantity for each item for each calendar bucket,
With respect to the item of the order information provided from the order storage device, the requested delivery date, and the ordered quantity, it can be shipped to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the frame information table. A first verification unit that verifies whether or not there is, and outputs a delivery date response to an output device if it can be shipped to the requested delivery date;
When the first verification unit verifies that the shipment cannot be made within the requested delivery date, the items, the requested delivery date, and the ordered quantity of the order information provided from the order storage device are stored in the maximum frame information table. Verify whether or not it is possible to ship to the required delivery date based on the maximum quantity of the applicable item up to the required delivery date and the reserved quantity of the relevant item up to the required delivery date stored in the frame information table. If possible, determine how much the number of calendar bucket frames should be expanded, and change the frame quantity of the corresponding item in the frame information table, record the allocated quantity, and output the delivery date response to the output device. A verification unit;
A message notification for storing in the delivery date response storage device a message instructing how much the number of calendar bucket frames is to be expanded for the corresponding item verified to be shippable to the requested delivery date by the second verification unit. And a delivery date answering system. A frame information table that stores the frame quantity and the reserved quantity for each item for each calendar bucket,
A maximum quota information table storing the maximum quota quantity for each item for each calendar bucket,
A message notification destination information table that stores a message notification destination for each item;
With respect to the item of the order information provided from the order storage device, the requested delivery date, and the ordered quantity, it can be shipped to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date of the corresponding item stored in the frame information table. A first verification unit that verifies whether there is a delivery date, and stores a delivery date answer in a delivery date answer storage device if it can be shipped to the requested delivery date;
When the first verification unit verifies that the shipment cannot be made within the requested delivery date, the items, the requested delivery date, and the ordered quantity of the order information provided from the order storage device are stored in the maximum frame information table. Verify whether or not it is possible to ship to the required delivery date based on the maximum quantity of the applicable item up to the required delivery date and the reserved quantity of the relevant item up to the required delivery date stored in the frame information table. If possible, determine how much the calendar bucket frame quantity should be expanded, and change the frame quantity of the corresponding item in the frame information table, record the reserved quantity, and then store the delivery date answer in the delivery date answer storage device. A verification unit of 2,
A message instructing how much the number of calendar bucket slots should be increased for the corresponding item verified to be shippable by the requested delivery date by the second verification unit is stored in the message notification destination information table. A message notification unit for notifying a notification destination of the received message via an information transmission medium. 2. The method according to claim 1, wherein the second verification unit allocates the allocation quantity to be increased in the range of the maximum frame quantity sequentially from the calendar bucket close to the required delivery date in the past direction. 7. The delivery date reply system according to claim 4, claim 5, or claim 6. When the second verification unit verifies that shipment is impossible at the requested delivery date, the request delivery date is moved to the next calendar bucket in the future to search for an answer delivery date, and the verification is repeated until shipment is possible. 8. The delivery date answering system according to claim 1, wherein the delivery date reply system is characterized in that: The first verification unit is stored in a frame storage unit that stores, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the order quantity of the order information provided from the input device. Verifying whether the product can be shipped to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date of the corresponding item, and outputting a delivery date answer to the output device if the item can be shipped to the requested delivery date;
When the second verification unit verifies that the product cannot be shipped at the requested delivery date by the first verification unit, the second verification unit determines the item, the requested delivery date, and the ordered quantity of the order information provided from the input device. The maximum frame quantity of each item stored in the maximum frame storage unit storing the maximum frame quantity for each calendar bucket up to the required delivery date of the corresponding item and the maximum frame volume of the corresponding item stored in the frame storage unit until the required delivery date of the corresponding item are stored. Verify whether or not the shipment can be made on the requested delivery date based on the reserved quantity, and if so, determine how much the number of calendar bucket frames should be expanded, and determine the frame quantity of the corresponding item in the frame storage unit. Outputting the delivery date answer to the output device after changing the
A message notifying unit outputs to the output device a message instructing how much the number of calendar bucket slots should be expanded for the corresponding item verified to be shippable on the requested delivery date by the second verification unit. A delivery date answering method. A first verification unit is stored in a frame storage unit that stores, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, requested delivery date, and order quantity of the order information provided from the order storage device. Verifying whether or not it is possible to ship to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date of the applicable item, and storing the delivery date answer in the delivery date answering device if it can be shipped to the requested delivery date. ,
When the second verification unit verifies that the shipment cannot be performed in the requested delivery date by the first verification unit, the second verification unit checks the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device. The maximum frame quantity up to the required delivery date of the corresponding item stored in the maximum frame storage unit storing the maximum frame quantity for each item for each calendar bucket and the requested frame date of the corresponding item stored in the frame storage unit Verify whether it can be shipped on the requested delivery date based on the reserved quantity of, and if it can be shipped, determine how much the number of calendar bucket slots should be expanded, and check the slot of the corresponding item in the slot storage unit. A step of storing the delivery date answer in the delivery date storage device after changing the quantity and recording the reserved quantity,
A delivery date reply storage device stores a message indicating that the message notification unit indicates how much the number of calendar bucket frames is to be expanded for the corresponding item verified to be shippable to the requested delivery date by the second verification unit. And storing the information in a delivery date. A first verification unit is stored in a frame storage unit that stores, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device. Verifying whether the item can be shipped to the requested delivery date based on the frame quantity and the reserved quantity of the corresponding item up to the requested delivery date, and if the item can be shipped to the requested delivery date, storing the delivery date answer in the delivery date answer storage device When,
When the second verification unit verifies that the product cannot be shipped by the requested delivery date by the first verification unit, the second verification unit checks the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device. The maximum frame quantity up to the required delivery date of the corresponding item stored in the maximum frame storage unit that stores the maximum frame quantity for each item for each calendar bucket, and the requested frame date of the relevant item stored in the frame storage unit Verify whether it can be shipped on the requested delivery date based on the reserved quantity of, and if it can be shipped, determine how much the number of calendar bucket frames should be expanded, and A step of storing the delivery date answer in the delivery date answer storage device after changing the quantity and recording the reserved quantity,
The message notifying unit sends a message instructing how much the number of calendar bucket slots should be expanded for the corresponding item verified to be shippable to the requested delivery date by the second verification unit. Notifying a notification destination of the message stored in the storage unit via an information transmission medium. The first verification unit stores the frame quantity and the reserved quantity for each item with respect to the item, the requested delivery date, and the ordered quantity of the order information provided from the input device, in the frame information table. Verifying whether the product can be shipped to the required delivery date based on the frame quantity and the reserved quantity of the applicable item up to the required delivery date, and outputting a delivery date response to an output device if the item can be shipped to the required delivery date;
When the second verification unit verifies that the product cannot be shipped in the requested delivery date by the first verification unit, the second verification unit determines the item, the requested delivery date, and the ordered quantity of the order information provided from the input device. The maximum quota quantity for each item stored in the maximum quota information table that stores the maximum quota quantity for each calendar bucket up to the required delivery date of the corresponding item, and the maximum quota quantity for the corresponding item stored in the quota information table until the required delivery date Verify whether or not the shipment can be made on the requested delivery date based on the reserved quantity, and if so, determine which calendar bucket frame quantity should be expanded and how much, and determine the frame quantity of the corresponding item in the frame information table. And outputting the delivery date response to the output device after recording and recording the allocated quantity, and the message verification unit verifies that the second verification unit can ship the requested delivery date. Promise method characterized by a step of outputting to an output device a message indicating whether to expand the frame number of any calendar buckets how for. A first verification unit is stored in a frame information table storing, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device. Verifying whether or not it is possible to ship to the requested delivery date based on the frame quantity and the reserved quantity up to the required delivery date of the applicable item, and outputting a delivery date answer to the output device if it can be shipped to the requested delivery date,
When the second verification unit verifies that the shipment cannot be performed in the requested delivery date by the first verification unit, the second verification unit checks the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device. The maximum slot quantity of each item stored in the maximum slot information table that stores the maximum slot quantity of each item for each calendar bucket up to the required delivery date of the corresponding item and the maximum slot quantity of the corresponding item stored in the slot information table until the requested delivery date of the corresponding item Verify whether it can be shipped in the requested delivery date based on the reserved quantity of, and if it can be shipped, determine how much the number of calendar bucket slots should be expanded, and check the slot of the corresponding item in the slot information table. A step of outputting the delivery date response to an output device after changing the quantity and recording the reserved quantity,
A delivery date reply storage device stores a message indicating that the message notification unit indicates how much the number of calendar bucket frames is to be expanded for the corresponding item verified to be shippable to the requested delivery date by the second verification unit. And storing the information in a delivery date. A first verification unit is stored in a frame information table storing, for each calendar bucket, a frame quantity and a reserved quantity for each item with respect to the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device. Verifying whether or not it is possible to ship to the requested delivery date based on the frame quantity and the reserved quantity up to the requested delivery date of the applicable item, and storing the delivery date answer in the delivery date answering device if it can be shipped to the requested delivery date. ,
When the second verification unit verifies that the shipment cannot be performed in the requested delivery date by the first verification unit, the second verification unit checks the item, the requested delivery date, and the ordered quantity of the order information provided from the order storage device. Whether or not it is possible to ship to the requested delivery date based on the maximum slot quantity up to the requested delivery date and the reserved quantity of the corresponding item stored in the maximum slot information table storing the maximum slot quantity for each item for each calendar bucket , Determine which calendar bucket frame quantity should be expanded by how much if it can be shipped, change the frame quantity of the corresponding item in the frame storage unit, record the reserved quantity, and then send the delivery date answer to the delivery date answering device. A step of storing the
The message notifying unit sends a message instructing how much the number of calendar bucket slots should be expanded for the corresponding item verified to be shippable to the requested delivery date by the second verification unit. Notifying a notification destination of the message stored in the storage unit via an information transmission medium. 10. The method according to claim 9, wherein the second verification unit allocates the allocation quantity to be increased in the range of the maximum frame quantity in order from the calendar bucket close to the requested delivery date in the past direction. 15. The delivery date reply method according to claim 12, claim 13, or claim 14. When the second verification unit verifies that shipment is impossible at the requested delivery date, the request delivery date is moved to the next calendar bucket in the future to search for an answer delivery date, and the verification is repeated until shipment is possible. The delivery date reply method according to claim 9, claim 10, claim 11, claim 12, claim 13, claim 14, or claim 15. The computer is provided with a frame storage unit that stores the frame amount and the allocation amount for each item for each calendar bucket, a maximum frame storage unit that stores the maximum frame amount for each item for each calendar bucket, and an input device. Verifies whether or not it is possible to ship to the requested delivery date based on the item quantity, requested delivery date, and ordered quantity of the order information based on the frame quantity and reserved quantity of the corresponding item stored in the frame storage unit up to the requested delivery date. A first verification unit that outputs a delivery date response to an output device if it can be shipped to the requested delivery date, and a first verification unit that outputs the delivery date response from the input device when the first verification unit verifies that the shipment cannot be performed by the requested delivery date. For the item, the requested delivery date, and the ordered quantity of the received order information, the maximum frame quantity up to the requested delivery date of the corresponding item stored in the maximum frame storage unit and the requested delivery date of the corresponding item stored in the frame storage unit Verifies whether the shipment can be made on the requested delivery date based on the allocation quantity up to the point, determines if the quantity of the calendar bucket can be expanded by how much if it can be shipped, and A second verification unit that outputs a delivery date response to an output device after changing the frame quantity and recording the allocation quantity, and a corresponding item that has been verified by the second verification unit to be able to be shipped on the requested delivery date. A delivery date verification program for operating as a message notification unit that outputs to a output device a message instructing how much the number of frames of a calendar bucket should be expanded. The computer is provided with a frame storage unit that stores the frame quantity and the allocation quantity for each item for each calendar bucket, a maximum frame storage unit that stores the maximum frame quantity for each item for each calendar bucket, and an order storage device. Verifies whether or not it is possible to ship to the requested delivery date, based on the item quantity, requested delivery date, and order quantity of the received order information, based on the frame quantity and reserved quantity of the corresponding item stored in the frame storage unit up to the requested delivery date. If it is possible to ship the requested delivery date, a first verification unit that stores the delivery date response in the delivery date response storage device. For the item, the requested delivery date, and the ordered quantity of the order information given from the storage device, the maximum frame quantity up to the required delivery date of the corresponding item stored in the maximum frame storage unit and the maximum frame number stored in the frame storage unit. Verify whether the item can be shipped to the requested delivery date based on the reserved quantity up to the requested delivery date, determine if the calendar bucket frame amount should be expanded by how much if shipping is possible, and The second verification unit stores the delivery date answer in the delivery date answer storage device after changing the slot quantity of the corresponding item of the corresponding unit and recording the reserved quantity, and verifies that the product can be shipped to the requested delivery date by the second verification unit. A delivery date verification program for operating as a message notification unit for storing in a delivery date answer storage device a message instructing how much the number of calendar bucket frames should be expanded for the applicable item. The computer stores a frame storage unit that stores the frame quantity and the allocation quantity for each item for each calendar bucket, a maximum frame storage unit that stores the maximum frame quantity for each item for each calendar bucket, and a message notification destination. For each item of the order information provided from the order storage device, the requested delivery date and the order quantity stored from the message notification destination storage unit to be stored for each item, the frame quantity and the allocation up to the required delivery date of the corresponding item stored in the frame storage unit The first verification unit, which verifies whether the product can be shipped on the required delivery date based on the quantity, and if the product can be shipped on the required delivery date, stores the delivery date response in the delivery date response storage device, When it is verified that the product cannot be shipped by the delivery date, the item, the requested delivery date, and the order quantity of the order information given from the order storage device are compared with the item stored in the maximum storage unit. It verifies whether or not it is possible to ship to the requested delivery date based on the maximum quota quantity up to the requested delivery date and the reserved quantity of the corresponding item stored in the slot storage unit up to the requested delivery date, and if it can be shipped, A second verification unit that determines how much the frame quantity of the calendar bucket is to be expanded, changes the frame quantity of the corresponding item in the frame storage unit, records the reserved quantity, and stores the delivery date answer in the delivery date answer storage device; And storing, in the message notification destination storage unit, a message instructing how much the number of calendar bucket slots should be expanded for the corresponding item verified to be shippable by the requested delivery date by the second verification unit. A delivery date verification program for operating as a message notification unit that notifies a notification destination of a given message via an information transmission medium. The computer is provided with a frame information table storing the frame quantity and the allocation quantity for each item for each calendar bucket, a maximum frame information table storing the maximum frame quantity for each item for each calendar bucket, and an input device. Verifies whether or not it is possible to ship to the requested delivery date based on the item quantity, requested delivery date, and ordered quantity of the order information based on the frame quantity and reserved quantity of the corresponding item stored in the frame information table up to the requested delivery date. A first verification unit that outputs a delivery date response to an output device if it can be shipped to the requested delivery date, and a first verification unit that outputs the delivery date response from the input device when the first verification unit verifies that the shipment cannot be performed by the requested delivery date. For the item, the requested delivery date, and the ordered quantity of the received order information, the maximum slot quantity and the slot information table stored in the maximum slot information table up to the requested delivery date of the corresponding item. Validate whether or not shipment is possible on the required delivery date based on the stored reserve quantity of the relevant item up to the required delivery date, and if shipping is possible, determine which calendar bucket frame quantity and how much should be expanded. A second verification unit that changes the frame quantity of the corresponding item in the frame information table and records the reserved quantity, and then outputs a delivery date response to an output device; and that the second verification unit can ship the product to a requested delivery date. A delivery date verification program for operating as a message notification unit that outputs to the output device a message instructing how much the number of frames in which calendar bucket is to be expanded for the verified item. The computer is provided with a frame information table storing the frame quantity and the allocation quantity for each item for each calendar bucket, a maximum frame information table storing the maximum frame quantity for each item for each calendar bucket, and an order storage device. Verifies whether it is possible to ship to the requested delivery date based on the item quantity, requested delivery date, and ordered quantity of the received order information based on the slot quantity and reserved quantity of the corresponding item stored in the slot information table up to the requested delivery date. A first verification unit that outputs a delivery date response to an output device if the shipment can be made by the requested delivery date, and when the first verification unit verifies that the shipment cannot be made by the requested delivery date, the order storage device The maximum frame quantity and the frame information up to the requested date of delivery of the corresponding item stored in the maximum frame information table with respect to the item, the requested delivery date and the ordered quantity of the order information given from Verify that the item can be shipped to the requested delivery date based on the reserved quantity of the relevant item up to the requested delivery date stored in the table, and if it can be shipped, determine which calendar bucket frame quantity and how much should be expanded. The second verification unit that determines, changes the frame quantity of the corresponding item in the frame information table, records the reserved quantity, and outputs a delivery date response to the output device, and the second verification unit can ship the requested item to the requested date of delivery. A delivery date verification program for operating as a message notifying unit for storing a message instructing how much the number of calendar bucket frames is to be expanded for a corresponding item verified to be present in a delivery date response storage device. The computer uses a frame information table that stores the frame quantity and the allocation quantity for each item for each calendar bucket, a maximum frame information table that stores the maximum frame quantity for each item for each calendar bucket, and a message notification destination. The message notification destination information table stored for each item, the item of order information given from the order storage device, the requested delivery date and the order quantity, the frame quantity and the allocation up to the requested delivery date of the corresponding item stored in the frame information table. The first verification unit, which verifies whether the product can be shipped on the required delivery date based on the quantity, and if the product can be shipped on the required delivery date, stores the delivery date response in the delivery date response storage device, When it is verified that shipment is impossible by the delivery date, the maximum frame information for the item, the requested delivery date, and the order quantity of the order information given from the order storage device. Verify that the product can be shipped to the required delivery date based on the maximum quantity of the relevant item stored in the table up to the required delivery date and the reserved quantity of the relevant item up to the required delivery date stored in the frame information table. Then, if it is possible to ship, determine how much the amount of the frame of the calendar bucket should be increased and change the frame amount of the corresponding item in the frame information table, record the reserved amount, and then send the delivery date answer to the delivery date answer storage device. A second verification unit to be stored, and a message instructing how much the number of calendar bucket frames should be expanded for the corresponding item verified to be shippable on the requested delivery date by the second verification unit. Delivery date detection for operating as a message notification unit that notifies a notification destination of a message stored in the message notification destination information table via an information transmission medium. Program. 20. The method according to claim 19, wherein the second verification unit allocates the allocation quantity to be increased in the range of the maximum frame quantity in order from the calendar bucket close to the requested delivery date in the past direction. The delivery date verification program according to claim 20, 21 or 22. When the second verification unit verifies that shipment is impossible at the requested delivery date, the request delivery date is moved to the next calendar bucket in the future to search for an answer delivery date, and the verification is repeated until shipment is possible. The delivery date verification program according to any one of claims 17, 18, 18, 19, 20, 21, 22, or 23, characterized in that:

Images