JP3535007B2 - Automatic product supply method and automatic product supply device - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an automatic product replenishment method and an automatic product replenishment device for automatically replenishing products from a manufacturer / manufacturer to a retail store or an intermediate wholesale store.

[0002]

2. Description of the Related Art In the case of supplying merchandise from a manufacturing / sales maker to a retail store or an intermediate wholesale store, generally, for example, Japanese Patent Laid-Open No. 05-046637 or Japanese Patent Laid-Open No. 0-063737 has been used.
As described in Japanese Patent Publication No. 9-198448, the retail store or the intermediate wholesaler manages the inventory, lists the missing products, and orders the manufacturers / sales manufacturers, and the manufacturers / sales manufacturers respond accordingly. Had been adopted.

[0003]

The above-mentioned conventional product supply system has the following problems. That is,
Retailers or intermediate wholesalers must perform troublesome ordering work by checking the inventory quantity every business day every day and listing the missing products according to the inventory status and placing an order with the manufacturer / sales manufacturer. There was a problem that it had to be.

Further, there is a problem that it takes too long time (lead time) from the time when the retail store checks the stock quantity to the time when the manufacturer / sale manufacturer delivers the missing product. Taking a case of an intermediate wholesaler as an example, in the morning, shipping work is performed while organizing orders from retail stores, and the final inventory amount is checked in the evening or night of the day, and the next morning. List the products that are missing by the time, place an order with the manufacturer / sales manufacturer, and on the next day the manufacturer / sales manufacturer side prepares the products based on the order table sent from the intermediate wholesaler, It is common to follow a time schedule of delivering merchandise to a wholesale store, and it usually takes two days to order and deliver merchandise. In this way, from ordering to delivery 2
In the conventional merchandise supply system that requires days, it is necessary to exclude merchandise that has already been ordered the previous day at the time of ordering work, so it is often the case that orders are mistakenly placed repeatedly or conversely forgotten. It was happening. Also, at retail stores, etc.
There was also the problem that the amount of inventory would increase by that amount because we had to have an extra inventory for the day.

In consideration of the above-mentioned circumstances, the present invention can shorten the time (lead time) from checking the inventory amount to delivering the product, and can reduce the troublesome product ordering work for a retail store. Another object of the present invention is to provide an automatic product replenishment method and an automatic product replenishment device which can avoid forgetting to place an order for commodities and avoid the situation of reordering commodities, and further reduce the amount of inventory for a retail store or an intermediate wholesale store. .

[0006]

The method for automatically replenishing goods according to claim 1 is used in an automatic replenishing device for automatically replenishing goods from a manufacturer / sales maker to a retail store or an intermediate wholesale store.
A method for automatically replenishing goods , comprising:
Receives inventory data by product / location from a computer at a retail store or an intermediate wholesale store and records the inventory data.
Recorded in the recording means and recorded in the inventory data recording means
While reading out the inventory data, taking out the shipping data for each product at a retail store or an intermediate wholesale store in the last certain period of time from the inventory data, and calculating the total shipping amount for each product in the fetched shipping data. , The total shipping amount is divided by the number of shipping days to calculate the average shipping amount per shipping day, and the standard of the products into which the products are grouped based on the shipping amount ranking by product for the latest past certain period. The standard stock for each product is calculated by multiplying the average shipment amount by the stock factor, and the calculated standard stock is used as the basis for each product.
It is recorded in the semi-inventory recording means and is recorded in the inventory data recording means.
In addition to reading the recorded inventory data,
The warehouse data is a value set to a value lower than the standard inventory.
That when below the reorder point, each according to a difference between the recorded reference stock and the stock data in the standard inventory recording means
Calculate the supply amount of each product and display the calculated supply amount of each product.
It is characterized by showing . In the commodity automatic supply method according to claim 2, in the invention according to claim 1, the ordering point
Select a preset coefficient for the calculated average shipment volume
It is characterized in that it is calculated by multiplying by.

[0007] In item automatic replenishment system according to the third aspect, a product automatic replenishing apparatus for replenishing automatically goods to retailers or intermediate wholesalers from manufacturing and sales maker, from the retail store or the intermediate wholesalers computer and inventory data recording means for receiving and recording by product location-specific inventory data, stock data recorded in the inventory data recording means
The shipment data for each product at the retail store or the intermediate wholesale store for the past certain period of time, which is the latest inventory data , is read, and the total shipment amount for each product of the fetched shipment data is calculated, and the total shipment amount is also calculated. Is divided by the number of shipping days to calculate an average shipping amount per shipping day, and a product grouping unit for grouping the products based on the shipping price ranking of the products in the last certain period in the past. And a standard inventory coefficient setting means for setting a standard inventory coefficient so as not to be multiplied by the average shipping quantity of the products sorted by the product sorting means, and the standard shipping coefficient to the average shipping quantity calculated by the average shipping quantity calculating means. a standard inventory calculation means for calculating a product-specific standard inventory by multiplying by selecting the item-specific coefficients set by the setting means, calculated in the standard inventory calculation means <br/> Standard inventory records to record a quasi-inventory by product
Means and the inventory data recorded in the inventory data recording means, and when the read inventory data is below the ordering point which is a value set to a value lower than the reference inventory , the reference inventory recording means Product replenishment amount calculation means for calculating the replenishment amount of each product according to the difference between the recorded standard inventory and the inventory data, and display means for displaying the replenishment amount of each product calculated by the product replenishment amount calculation means. It is characterized by having and. In the product automatic supply device,
The method of the present invention can be preferably carried out. In the invention of claim 4, in the invention of claim 3, the average shipping amount is calculated.
Select a preset coefficient for the average shipment volume calculated by
Order point calculator that calculates the order point by selecting and multiplying
It is characterized by having steps .

[0008]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a diagram showing an outline of an automatic commodity supply system according to the present invention. In the figure, the upper row shows the work content of the retail store or the intermediate wholesaler side, and the lower row shows the manufacturing
The contents of the work on the side of a sales maker (including a maker that manufactures and sells, a maker that only manufactures, and a corporation such as a company that only sells) are shown.

The outline of the system will be described below in the order of approximate passage of time. At a retail store or an intermediate wholesale store, order data 2 online to the computer 1 of the manufacturer / sale maker by about 9:30 AM on the day of the business day.
To send. The order data 2 sent at this time is data obtained mainly from special order information for sales promotion at retail stores, etc., and is data related to so-called planned items that stand out from the order data of ordinary standard products. In addition, with respect to ordinary standard products, inventory data 3 for each product name and each location is transmitted from a retail store or the like to the computer 1 of the manufacturer / seller through EDI (Electronic Data Interchange). This transmission is performed by about 12:00 AM.

The computer 1 for inventory management of the manufacturer / sales maker calculates the shipment quantity of these standard products based on the order point and the stock quantity. The inventory management computer 1 will now be described. A control unit 100 including a processor such as a CPU includes a display unit 101 such as a display, an input unit 102 such as a keyboard, and the printer 1.
03, the host computer 4, the computer 105 at the retail store or the wholesale store, and the storage unit 120 are connected via the modem 104. The control unit 100
Is a standard inventory calculation means 110 for calculating a standard inventory for each product based on a predetermined standard inventory calculation formula for each product defined between a manufacturer / sale maker and a retail store or an intermediate wholesale store, and the retail store or the intermediate store. When the inventory data for each product / location obtained from a wholesale store falls below the ordering point set to a value lower than the standard inventory recorded in the standard inventory recording means, each product is replenished according to the difference. The product supply amount calculation means 130 for calculating the amount.

Then, the standard inventory calculation means 110 obtains shipping data for each product from a retail store or an intermediate wholesale store in the latest past certain period from the data recorded in the inventory data recording means 121 in the storage section 120. An average shipping amount calculation means 111 for taking out and calculating the total shipping amount for each product of the fetched shipping data, and dividing the total shipping amount by the number of shipping days to calculate an average shipping amount per shipping day.
Product classification means 1 for grouping the above-mentioned products into groups based on the shipping price rankings by product for the latest past certain period.
12, a standard inventory coefficient setting unit 113 for setting a standard inventory coefficient so as not to be multiplied by the average shipping amount of the products sorted by the product sorting unit 112, and the average shipping amount calculation unit 11
A standard inventory calculation unit 114 that calculates a standard inventory by selecting and multiplying the average shipment amount calculated in 1 by the coefficient for each product set by the standard inventory coefficient setting unit 113, and a predetermined average shipment amount. An ordering point calculation means 115 for calculating an ordering point (replenishment point) which becomes a value for replenishing a product when the inventory falls below that coefficient by selecting and multiplying the coefficient.

The storage unit 120 also stores inventory data recording means 121 for receiving and recording inventory data for each product / location from a retail store or an intermediate wholesale store, and a standard inventory calculated by the standard inventory calculation means. A standard inventory recording means 122 for separately recording and an order point recording means 123 for recording the order points calculated by the order point calculating means for each product.
With.

The automatic supply of merchandise is performed by the following procedure using the computer 1 for inventory management. That is, taking an intermediate wholesaler as an example, the inventory data recording means 121 is calculated by the average shipment amount calculating means 111 for each product shipped from the manufacturer / sale maker to the intermediate wholesaler.
From the data recorded in (1), the date of shipment from the intermediate wholesale store to the retail store in the past certain period (for example, the last 3 months) (the inventory amount recorded by the inventory data recording means 121 has decreased). (The shipping date can be determined from the above), the total shipping amount for each product is calculated, the number of shipping days is counted, and the shipping amount is divided by the shipping days from these values, and the average shipping amount per shipping day at the intermediate wholesale store is calculated. Ask.
In addition, the product classification unit 112 divides the products into groups based on the shipping amount ranking of a certain past period (for example, the latest three months). Then, the stock management count setting means 113 sets the coefficient of the reference stock (maximum stock) for each group. That is, the product group is divided into, for example, five according to the shipping amount ranking, and the coefficient of the upper two groups of the ranking is “5”, the coefficient of the next group is “3”, and the coefficient of the lower two groups is “1”. Set. This coefficient is input from the input unit 102.

Then, by the standard inventory calculation means 114,
The standard inventory is calculated for each product by using the average shipment amount at the intermediate wholesale store as a base and multiplying it by the coefficient. That is, the upper two groups in the shipping amount ranking have a standard inventory of five times the average shipping amount, the next group have three times the average shipping amount as the standard inventory, and the lower two groups have the average shipping amount as the standard inventory. Becomes And
The standard inventory is recorded in the recording means 122.

Further, the order point calculation means 115 calculates the average shipping amount per day on the shipping date. That is, the number of order points set for each group divided into the average shipment amount, for example, the upper two groups are “3”, the next group is “2”, and the lower two groups are “1”. The ordering point is calculated by multiplying by such a coefficient. Then, the value is recorded as the order point recording means 1
Record at 23. When the stock at the intermediate wholesale store falls below the calculated ordering point by the product supply amount calculation means, the product supply amount is calculated from the difference, and the value is displayed on the display unit or printed by the printer 103. Based on the display, the manufacturer / sales manufacturer will automatically replenish the product in an appropriate amount.

Here, the respective coefficients of the standard stock and the ordering point are determined by consultation between the manufacturer / sales manufacturer and the intermediate wholesaler (retail shop), and never the original manufacturer / sales manufacturer's own coefficient. It is not a judgment. Then, the shipment quantity from the manufacturing / sales maker at this time is obtained by converting the actual shipment quantity (bullet) per day on the shipment date into a package. The actual shipping quantity is calculated as a product obtained by subtracting the current stock from the standard inventory, divided by the shipping unit, and the quotient multiplied by the shipping unit (that is, a multiple of the shipping unit). If necessary, depending on the loading situation from the manufacturer / sales maker side, for example, the situation where pallets are loaded,
The shipping quantity is slightly increased or decreased.

The above-mentioned calculation of the shipping quantity is performed for all the products to be shipped, and the total time is usually about 5 minutes. As above, if the shipment quantity of the standard product is decided, combine it with the shipment quantity of the product for the plan,
Those data are sent to the host computer 4. When there is an urgent order by telephone or Facsimile, it is input from the terminal 5 of the computer in the form of electronic data, and the data is sent to the host computer 4. Such work is performed at each retail store or each intermediate wholesale store.

The host computer 4 collects the data sent from each retail store or intermediate wholesale store, and checks whether or not the business office of the manufacturing / sales manufacturer has an inventory or whether the inventory is out of stock. . When it is determined that the stock is out of stock or the product is out of stock, the information to that effect is sent to another computer 6 to prompt the delivery of the missing product from the factory warehouse to the business office, or Promote increased production of the product.

After that, in the host computer 4, PM
By 7:30, the information 7 regarding the delivery guide to be sent the next day is sent to the designated retail store or intermediate wholesale store to the computer 8 by communication means such as e-mail, and the confirmation is taken. At this time, the information to be sent is only for online ordered products and standard products subject to automatic replenishment, and products for emergency orders are separately shipped separately. If the time is enough, the emergency-ordered product may be transmitted by the same flight as the standard product that is automatically replenished. The information 7 regarding the delivery guide sent to the retail store or the like is also sent in the form of shipping data 9 to the shipping department of the manufacturer / seller.

Then, in the shipping department, necessary products are prepared on the basis of the shipping data 9 to prepare for shipping, and after confirmation from a retail store or the like, the products are delivered the next day. Further, the purchase data 10 of the delivered product is transmitted to the computer of the retail store or the intermediate wholesale store.

With such a system, as shown in FIG. 3, the products to be shipped from the manufacturer / sales manufacturer to the retail store are divided into standard items and planned items, but only the standard items. Manufacturers and sellers will automatically replenish products based on the order points of retailers, etc. and the amount of stock, and the planned products will be supplied based on orders from retailers or intermediate wholesalers. Become.

In the above-mentioned automatic commodity supply system, for a standard commodity, the retail store or the like sends an order table, and the manufacturer / sales manufacturer side does not deliver the product based on the order table, but the manufacturer / sale manufacturer side sends the commodity from the retail store or the like. Based on the inventory data that comes in, the optimum supply amount is directly calculated and the product is automatically supplied to retail stores, etc. Therefore, it is calculated backward from the shipping time of the manufacturer / sales manufacturer side, the preparation time required for shipping, the retail store In consideration of the time to send the information 7 of the delivery guide to and confirm it, the product procurement time of the manufacturer / sales manufacturer, and the time to calculate the shipping quantity for each retail store or intermediate wholesaler, It is possible to shift the time to obtain inventory data 3 from stores etc. to the latest time (when it is delayed more than that, the next day's delivery will not be in time), so to speak, time management of product replenishment It has become possible to be carried out at a pace of production and sales of the manufacturer regarding. As a result, AM1
If the inventory data is sent by 2:00, the required products can be delivered by the next day, and the lead time can be greatly shortened. Therefore, as shown in FIG. 4, the intermediate wholesaler can cover 90% of the orders received on the day, and the inventory can be significantly reduced.

Further, for each product shipped from the manufacturer / sale maker to the retail store or the intermediate wholesale store, the shipping amount from the retail store or the intermediate wholesale store in the past fixed period is calculated and the number of shipping days is counted, and The shipping amount is divided by the number of shipping days from the value to find the average shipping amount per shipping day, and the products are divided into groups based on the shipping amount ranking in the past certain period, and the coefficient of the standard inventory is set for each group. Since the standard inventory is set for each product by multiplying the average shipment amount by the coefficient, the simple and practical inventory management can be performed, and the shipping amount ranking data is updated one by one. Just by updating to, there is no problem even for products such as sunscreen cream and shampoo whose shipment volume changes depending on the season Inventory management has become can be performed.

[0024]

[0025]

As described above, according to the method for automatically replenishing goods according to the first aspect, the manufacturer / sales manufacturer obtains the stock data for each product / location from the retail store or the intermediate wholesaler and manufactures the product. -Calculate the standard inventory for each product based on the standard inventory calculation formula for each product established between the sales maker and the retail store or the intermediate wholesale store, and for each product / location obtained from the retail store or the intermediate wholesale store. When the inventory data falls below the standard inventory by a specified amount, the manufacturer / supplier automatically supplies the product to the retail store or the intermediate wholesale store according to the difference, so the retail store sends the order table. Based on this, the manufacturer / sales maker does not deliver the product, but the manufacturer / sales maker directly calculates the optimal supply amount based on the inventory data sent from the retail store, etc., and delivers the product to the retail store etc. Since it is intended to dynamic supply, it has become to be able to significantly reduce the lead time. Further, it is possible to reduce the troublesome product ordering work for retail stores and the like, and to avoid the situation of forgetting to order products or repeatedly ordering products. Furthermore, the inventory amount can be reduced for retail stores or intermediate wholesalers. . In addition, for manufacturing and sales manufacturers, it is possible to reduce distribution costs by pursuing in-vehicle delivery efficiency. In addition, shipping date from retail stores or intermediate wholesalers 1
Since the standard inventory is constructed based on the daily shipment volume and the shipping price is added, simple and actual inventory management can be performed. Not only stores, but also manufacturers and sales manufacturers can further reduce inventory.

[Brief description of drawings]

FIG. 1 is a schematic diagram of an automatic commodity supply method according to an embodiment of the present invention.

FIG. 2 is a block diagram of an inventory management computer used for implementing the method of the present invention.

FIG. 3 is a diagram showing a flow of products classified by type in the same product automatic supply method.

FIG. 4 is a diagram showing a transmission timing of inventory data of an intermediate wholesale store using the same product automatic supply method.

[Explanation of symbols]

1 computer 2 order data 3 inventory data 4 host computer 5 terminal 6 computer 7 information about delivery guide 8 computer 9 shipping data 10 purchasing data 100 control unit 101 display unit 102 input unit 103 printer 110 standard inventory calculation means 111 average shipping amount Calculating means 112 Product sorting means 113 Standard inventory coefficient setting means 114 Standard inventory calculating means 115 Ordering point calculating means 120 Storage section 121 Inventory data recording means 122 Standard inventory recording means 123 Ordering point recording means 130 Product replenishment amount calculating means

─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Yu Okamoto 1-3-7 Honjo, Sumida-ku, Tokyo Within Lion Co., Ltd. (56) Reference JP-A-9-218899 (JP, A) Nikkei Communication, Nikkei BP, November 4, 1991, 113, p. 38-45 Logistics Systems, Nikkei Logistics Systems Association, October 30, 1996, Volume 5, No. 6, p. 48-50 Measurement and Control, The Society of Instrument and Control Engineers, March 10, 1998, Volume 37, Issue 3, p. 174-178 Edited by Yuji Kobayashi, Specific Measures and Success Cases of Japanese ECR / QR, Management Information Publishing Co., Ltd., March 5, 1998, p. 20-33, 60-63, 118-125, 158, 159 (58) Fields investigated (Int.Cl. ⁷ , DB name) G06F 17/60 118 G06F 17/60 320 JISST file (JOIS)

Claims (4)

(57) [Claims] 1. A product automatic replenishing device for automatically replenishing a product from a manufacturing / sales maker to a retail store or an intermediate wholesale store.
A method for automatically replenishing goods , wherein the apparatus for automatically replenishing merchandise receives inventory data for each product / location from a computer of a retail store or an intermediate wholesale store and records inventory data.
The inventory data recorded in the inventory data recording means.
Out of the inventory data, shipping data for each product at a retail store or an intermediate wholesale store in a recent past certain period is extracted, and the total shipment amount for each product of the extracted shipping data is calculated. The shipping amount is divided by the number of shipping days to calculate the average shipping amount per shipping day, and the standard inventory coefficient of the products into which the products are grouped is calculated based on the shipping amount ranking by product for the latest past certain period. , recorded in the average calculated by product standard inventory by multiplying the shipments, standard inventory record means the calculated standard inventory by product
And, reading the inventory data that has been recorded in the inventory data recording means
With out the read when the inventory data is below the reorder point is a value set to a value lower than the reference stock, the recorded reference inventory to the standard inventory recording means wherein
An automatic product replenishment method, characterized in that the replenishment amount of each product is calculated according to the difference from the inventory data, and the calculated replenishment amount of each product is displayed . 2. The ordering point is the calculated average shipment quantity.
Product automatic replenishment process of claim 1, wherein the this <br/> be calculated by multiplying by selecting the preset coefficients. 3. An automatic product replenishing device for automatically replenishing products from a manufacturing / sales maker to a retail store or an intermediate wholesale store, wherein inventory data by product / location is obtained from a computer of the retail store or intermediate wholesale store. Inventory data recording means for receiving and recording, and reading the inventory data recorded in the inventory data recording means.
Out, is taken out by product shipment data in retail stores or intermediate wholesalers of the stock data immediate vicinity of the past predetermined period, it calculates a by product Total delivery of their extraction shipment data, said total shipments Is divided by the number of shipping days to calculate an average shipping amount per shipping day, and a product grouping unit for grouping the products based on the shipping price ranking of the products in the last certain period in the past. And a standard inventory coefficient setting means for setting a standard inventory coefficient so as not to be multiplied by the average shipping quantity of the products sorted by the product sorting means, and the standard shipping coefficient calculated by the average shipping quantity calculating means to the standard inventory coefficient. a standard inventory calculation means for calculating a product-specific standard inventory by multiplying by selecting the item-specific coefficients set by the setting means, the reference standing calculated by the standard inventory calculation means Serial refrigerator a by product
The standard inventory recording means for recording and the inventory data recorded in the inventory data recording means are read.
With out the read when the inventory data is below the reorder point is a value set to a value lower than the reference stock, the recorded reference inventory to the standard inventory recording means wherein
It is provided with a product replenishment amount calculation means for calculating the replenishment amount of each product according to the difference from the inventory data, and a display means for displaying the replenishment amount of each product calculated by the product replenishment amount calculation means. A featured product automatic supply device. 4. A flat rate calculated by the average shipping amount calculation means.
By selecting and multiplying the uniform shipping amount with a preset coefficient
4. The commodity automatic replenishing device according to claim 3, further comprising an ordering point calculating means for calculating the ordering point .