JP2002133232A - Order forecast information providing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable a stock supplier to design a planed production and an efficient inventory planning by providing an order forecast information to the stock supplier in advance of actual order placement. SOLUTION: An order planning computer 11 that is a for terminal issuing an instruction to order stock products by a replenishment method of stock on the issuing side and each terminal 2 on each of stock supplier sides a, b and so forth that delivers products based on the order instruction from the order planning computer 11 are connected via a communication line N1, make up the system, and every time designing of the replenishment requirement planning of product, the order planning computer 11 sends the current order forecast information including stock information to each of terminals 2 on the stock suppliers a, b and so forth.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to order management of purchased products when purchasing daily necessities from a manufacturer and selling the products as a company product, and more specifically, provides order prediction information to a supplier. About the system to do.

[0002]

2. Description of the Related Art Order management of purchased products when purchasing daily necessities from a manufacturer and selling it as a company product is described below.
2. Description of the Related Art Conventionally, an order source makes monthly sales forecasts on a monthly basis, and informs the supplier of the sales forecasts in paper or verbally as secret information. The supplier performs a process group based on the secret information and holds the stock to prepare for the next order (this is referred to as conventional technology 1).

[0003] Instead of such a paper or verbal order, an ordering point and an order quantity are set in advance, an order is automatically calculated by a computer, and an order is automatically placed (Japanese Unexamined Patent Publication No. No. 239884) has also been proposed (this is referred to as prior art 2).

[0004]

However, there is a problem in that, when the method is performed by the secret method as in the prior art 1, it is not possible to cope with an order that exceeds the expected quantity in the next month.
In addition, there is a problem that the man-hour of the ordering person for performing monthly forecasting is required, and when there are many items to be handled, the man-hour is also increased.

Further, when the system of the prior art 2 is used, an order for a purchased product is suddenly received from the supplier, so that it is possible to cope with the case where the stock is sufficient, but to cope with the case where the stock is not available. However, there was a problem that the product was out of stock immediately. In addition, there is a problem that if the stock is too large, the burden on the supplier is increased accordingly. In particular,
In the case of daily necessities, model changes are frequently performed, so if the customer carries the inventory, the product immediately becomes an old model product and remains as defective inventory.

The present invention has been made to solve such a problem, and an object of the present invention is to provide an order prediction information to a supplier before an actual order is placed, thereby enabling the supplier to perform planned production. Another object of the present invention is to provide an order prediction information providing system capable of setting up an efficient inventory plan.

[0007]

In order to solve the above-mentioned problems, an order prediction information providing system according to the present invention includes an issuer terminal that issues an order instruction for a purchased product according to a stock replenishment method, and an order terminal based on the order instruction. A terminal on the supplier side for delivering the product is connected via a communication line, and the issuing side terminal prepares a product replenishment request plan each time, and prepares order prediction information including stock information at that time. Is transmitted to the supplier terminal.

According to the present invention having such features,
Before the order instruction is issued, the order prediction information is transmitted from the issuing terminal to the supplier. Based on this issuance prediction information, the next order instruction can be predicted to some extent. And an efficient inventory plan can be established.

According to the order prediction information providing system of the present invention, the order prediction information includes, in addition to the stock information,
It is characterized in that it includes special event planning information and past shipping result information that it has as production information.

According to the present invention having such features,
Based on the event planning information, the supplier can predict when and when a complete order will be placed, and also predict future sales to some extent from past shipping performance information. In addition, an efficient inventory plan can be made.

According to the order prediction information providing system of the present invention, when there are a plurality of suppliers for the same product, the order prediction information transmitted from the issuing terminal to the supplier terminal is: It is characterized in that the result of ratio calculation based on the order ratio for each supplier is transmitted.

According to the present invention having the above features,
Since each supplier is provided with order forecast information according to the ratio of orders placed by itself in the order forecast information of the issuer,
In addition to being able to perform planned production more accurately,
Efficient inventory planning can be performed, and stockouts can be reduced.

[0013]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing the overall configuration of an order prediction information providing system according to the present invention.

This system manufactures and sells various products in-house, and purchases and sells some products (such as daily necessities) from other manufacturers (hereinafter referred to as suppliers) as in-house products. An order planning computer (issuing terminal) 11 installed in the company, and each supplier a, b
Are connected via various communication lines N1.

The manufacturing and sales company has terminals 12, 12,... Installed at the sales offices, and a factory host computer for performing processing such as manufacturing management and inventory allocation upon receiving an order from each sales office. 13, a database server 14 that centrally manages event information (sales expansion planning) from each sales office, inventory information and shipping information from the factory host computer 13, and the order planning computer 11 via the company intranet N 2 and the like. Connected.

The order planning computer 11 transmits order prediction information to be described later to the terminals 2, 2,... Of the suppliers a, b,.

FIG. 2 shows the configuration of various files managed by the database server 14.

The database server 14 has an event information management file 14a for managing information on events held by businessmen with each retailer, and a standard stock serving as a reference for calculating the order quantity of purchased products to each supplier. And a reference stock / replenishment point management file 14b for managing replenishment points, and a stock result management file 14 for managing real stock, sales expansion stock, and the like.
c, an order information management file 14d that manages information such as the number of reserved inventory and an order depot, an order information management file 14e that manages the number of remaining order by month, and the like, such as product numbers and product names. Product master file 14f that manages information, supplier name of purchased product, supplier FAX
A supplier master file 14g that manages numbers, supplier addresses, and the like, and a supplier ratio master file 14h that manages product numbers, supplier names, order ratios (which will be described later), and the like are provided. .

The order planning computer 11 receives information such as special event information, stock information, shipping information, and order information from the database server 14, and issues an order instruction for the purchased product to each of the terminals 2, 2,. .., And every time a product replenishment request plan is drafted, order prediction information including current stock information and sales expansion information is transmitted to each terminal 2, 2,. . At this time, if the terminal 2 installed in the supplier a is a facsimile machine, the order planning computer 11
The order prediction information is transmitted by facsimile communication, and when the terminal 2 installed in the supplier b is a personal computer, the order prediction information is transmitted by e-mail.

Here, the flow of data by the order prediction information providing system having the above configuration will be briefly described.

A salesperson at each sales office discusses business with a retailer or agency in charge, and when an event plan is agreed upon, a screen of the terminal 12 installed at the sales office is displayed. As the event information, the information "when and how many products of the product number will be used and a fair will be held at the supermarket" will be distributed through the company intranet N2. This information is taken into the event information management file 14a of the database server 14, and the other files 14b-
The information is passed to the order planning computer 11 together with the information managed in 14h, and the order prediction information is calculated. And
The calculation result is transmitted to the terminals 2, 2,... Of each supplier via the communication line N1 for each planning cycle.

An embodiment in which the actual operation is performed using the order prediction information providing system having the above configuration will be described below.

In the present embodiment, it is assumed that the order of the purchased product is calculated in units of three days by the inventory replenishment method as shown in FIG. Then, among the products having a plurality of product numbers, the product of the product number for which the replenishment request has been made is ordered from the supplier.

Here, the reference stock and the replenishment point are defined as A, B, and C according to the actual shipment and procurement lead time (LT).
The reference stock and the replenishment point are determined according to the rank. For example, A rank product: Standard stock = Monthly average shipment quantity x 0.5 months Order lot = Monthly average shipment quantity x 0.25 months Procurement LT = 1 week B rank product: Standard stock = Monthly average shipment quantity x 1.0 Monthly Ordered Lot = Average Monthly Shipment x 0.5 Months Procurement LT = 2 weeks C Rank Product: Standard Inventory = Monthly Average Shipment x 2.0 Months Order Lot = Monthly Average Shipment x 1.0 Months Procurement LT = 1 The month is set.

Conventionally, an order was placed based on this replenishment request. However, there is a risk that the supplier may not be able to respond to the order. In this embodiment, the order quantity planning cycle (three-day cycle in this embodiment) is used. In each case, detailed in-house stock information as shown in FIG. 4 is provided to each supplier as order prediction information. That is, the information is transmitted from the order planning computer 11 to the terminals 2, 2,... Of each supplier.

As shown in FIG. 4, the order prediction information includes a product classification, a product number, a product name, a planned number of sales promotion (planned quantity required at an event), a DP code (shipping depot), a standard stock, a replenishment point, and a remaining order. Quantity (ordered unstocked quantity), real inventory (current inventory: excluding expanded sales inventory), expanded sales inventory (stock already secured for sales expansion planning (event)), shipping results (current year) , Shipment results (previous year).

Each supplier who has received such order prediction information, based on the order prediction information, compares the current year's shipment results with the previous year's shipment results, predicts the current year's sales, and furthermore, checks the current real inventory. And replenishment points to predict how soon inventory will fall below the replenishment point. further,
Since the sales expansion plan quantity is considered to be a quantity that comes as a sudden order, it is possible to determine how much quantity should be prepared this month.

For example, the product number DDDDDDD will be described as an example. The replenishment point of the product of the product number DDDDDD is 10
00 pieces, real stock is 1128 pieces, sales expansion stock is 0 pieces, order remaining quantity is 0 pieces, sales expansion plan number is 1000 pieces (October), and average shipment result in the last half year of this year is 726 pieces / month. Further, as for the shipment results of the previous year, if the shipment is large in September but not so much in other months, it can be determined that there is an order for 1000 pieces in the near future. Furthermore, in September it is likely that there will be an order due to the end of the term, and in October there will be an unexpected 100
It can also be determined that there is likely to be zero orders. Therefore, the supplier has about 1000 pieces of stock,
It is possible to make a planned production that anticipates future orders and an efficient inventory plan, such as a production response of about 1000 to 2000 pieces per month.

Here, in the case of a multi-company purchase in which the same product is ordered from a plurality of suppliers, even if the order prediction information shown in Table 1 is provided to each supplier, Since the order prediction information includes purchase information from all suppliers, the information is not necessarily easy to use for each supplier. Therefore, in the case of such a double purchase, the following measures are taken.

That is, based on the ratio set for each supplier in advance, based on the order prediction information, the number of sales expansion plans, the standard stock, the replenishment point, the real stock, the sales expansion stock, the average shipment, the actual shipment (previous year, current year ) Is calculated, and the result is provided as order prediction information to each supplier. In other words, even if the required replenishment amount is calculated as the order amount, the amount actually ordered to each supplier is “replenishment required amount × the ratio of the vendor”, and the information to be provided is also distributed in a ratio. .

For example, as shown in FIG.
The replenishment request quantity (total order quantity) of the product AAA is 100
Assuming that there are 0 products, the product of this part number AAAAAA
発 注, xx, and △△ have been ordered, and the order ratio of each is 50% for 〇〇, 30% for xx, and △△.
Company 20%, the order volume for these three companies is
〇〇 company: 1000 pieces × 50% = 500 pieces, xx company: 10
00 pieces × 30% = 300 pieces, △ company: 1000 pieces × 20
% = 200 pieces.

Therefore, the order prediction information provided to the three companies is changed from the entire order prediction information shown in FIG. 5 to the order prediction information for each supplier shown in FIGS. 6 to 8, respectively. However, the remaining order number is the remaining order number for the relevant supplier.

[0034]

According to the order prediction information providing system of the present invention, the order prediction information is transmitted from the issuing terminal to the supplier before the order instruction is issued. , The next order instruction can be predicted to some extent. Therefore, it is possible to plan production according to the prediction and to make an efficient inventory plan.

Further, according to the order prediction information providing system of the present invention, the order prediction information includes event planning information and past shipping result information which are held as production information in addition to inventory information. In addition, the supplier can predict when a set of orders will be received based on the event planning information, and also predict future sales to some extent from past shipping result information. Therefore, it is possible to plan production according to the prediction and to make an efficient inventory plan.

Further, according to the order prediction information providing system of the present invention, when there are a plurality of suppliers for the same product, the order prediction information transmitted from the issuing terminal to the supplier terminal is Each supplier is configured to send the result of the ratio calculation based on the ordering ratio to the supplier, so each supplier only receives the ordering prediction information according to the ratio of the ordering order from the issuer. Provided. for that reason,
In addition to being able to perform planned production more accurately,
Efficient inventory planning can be performed, and stockouts can be reduced.

[Brief description of the drawings]

FIG. 1 is a block diagram showing the overall configuration of an order prediction information providing system according to the present invention.

FIG. 2 is an explanatory diagram showing a configuration of various files managed by a database server.

FIG. 3 is an explanatory diagram of a stock replenishment method.

FIG. 4 is an explanatory diagram showing an example of the content of order prediction information provided to a supplier;

FIG. 5 is an explanatory diagram showing an example of original information of order prediction information provided to each supplier.

FIG. 6 is an explanatory diagram showing an example of order prediction information provided to a corresponding supplier calculated by ratio distribution.

FIG. 7 is an explanatory diagram showing an example of order prediction information provided to a corresponding supplier calculated by ratio distribution.

FIG. 8 is an explanatory diagram showing an example of order prediction information provided to a corresponding supplier calculated by ratio distribution.

[Explanation of symbols]

 2 Terminal installed in each supplier 11 Computer for order planning (issuing terminal) 12 Terminal installed in sales office 13 Factory host computer 14 Database server N1 Communication line N2 Intranet

Claims (3)

[Claims] An issuing terminal for issuing an order instruction for a purchased product by a stock replenishment method and a terminal of a supplier for delivering the product based on the order instruction are connected via a communication line. Each time the issuing terminal prepares a product replenishment request plan, it transmits order prediction information including stock information at that time to the supplier terminal, the order prediction information providing system. 2. The order prediction according to claim 1, wherein the order prediction information includes, in addition to the stock information, event planning information held as production information, past shipment result information, and the like. Information system. 3. When there are a plurality of suppliers for the same product, the order prediction information transmitted from the issuing terminal to the supplier terminal is calculated as a ratio based on the order ratio for each supplier. The order prediction information providing system according to claim 1, wherein the result is transmitted.