JPH0816686A - Inventory management system for bottled beverage - Google Patents

Abstract

PURPOSE:To make the inventory management at each stage of the distribution on-like management by preparing the slips of shipments and inventories, etc., automating the information exchange with a drink maker by a data communication network and performing the inventory management on the distribution route between a manufacture and consumers in real time. CONSTITUTION:A computer 7 is connected to a bar code reader 8 reading and inputting the data of bottled beverage and the bar code reader 8 reads the bar codes 2 to 6 imparted to a cap 1. Data processing is performed for the individual data of the bottle inputted from the bar code reader 8 by the computer 7, the slips of the shipment daily report and the inventory daily report, etc., are prepared and the slips are outputted to a printer 9. Further, by using the data communication network of a public line, data is transferred from a drink shop to the outside by the computer 7 an information exchange is automatically performed and the inventory management is performed in real time. Thus, the monitoring of the sales status and the inventory status at a drink shop is possible in real time and an efficient distribution can be performed.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an inventory management system for commercial use mainly handling beverages, and more specifically, it reads a bar code attached to each bottle when the bottle is opened, collects the individual data, and manages the inventory. The present invention relates to an inventory management system for performing. In addition, it relates to an online commercial inventory management system that shares consumption data of bottled beverages with food and drink stores, wholesalers, and beverage manufacturers, and manages production at beverage manufacturers and inventory management at each distribution stage. is there.

[0002]

2. Description of the Related Art In recent years, in the restaurant industry, the demands of customers have diversified and the contents thereof have become more sophisticated. In addition to this, the number of stores is increasing rapidly as a result of chain store development. Further, in parallel with such business development of mass and mass sales, it is necessary for the same management team to operate a high-class store that responds to the high-class orientation of customers.
It is necessary to manage a diverse group of stores at the same time, such as supplying relatively low-priced products to a large number of stores, handling high-priced products at a small number of stores, and having intermediate stores. .

In order to increase the quality of shops or increase the number of shops, it is necessary to handle a wide variety of bottled beverages at the same time. There are various kinds of bottled beverages such as juices, colas, beers, and sake. For example, taking beer as an example, it has conventionally been sufficient to prepare about one or two brands. For inventory management, it was possible to deal with the remaining quantity of bottles in the case by counting the number of clocks and placing an additional order when the quantity was insufficient.

According to the stock situation at each store, a person in charge orders the stock from one or a plurality of wholesalers by means such as a telephone and adjusts the stock. Further, the wholesaler who receives the order also ships according to the inventory, and at the same time, depending on the inventory state, places an order with another wholesaler or a beverage maker by means such as a telephone. The beverage manufacturer, which is the starting point of the distribution channel, will make production adjustments and inventory adjustments according to the order status from each wholesaler or a major food and beverage store that is directly purchased.

[0005]

However, just by considering beer according to the above-mentioned example, several brands of more than one brand are released from one maker, and several types of each are produced depending on the capacity of the bottle. There is. It is not necessary to have all types of beer in one store, but the number of varieties handled will definitely increase. As described above, under the situation of handling a large number of small quantities, it is very difficult to thoroughly manage the inventory by checking the remaining number of cases in the conventional case. Insufficient management at food and beverage stores at the end of the distribution channel causes not only problems at that store but also at wholesalers and beverage manufacturers upstream in the distribution channel.

[0006] In the present situation where bottled beverages do not have effective inventory control means as described above, problems occur at each stage of food and drink shops, wholesalers and beverage manufacturers, which are the sites of consumption and sales. Since food service is given priority to serving bottled beverages at food and beverage stores, there is no room to keep a record of the delivery of goods. For this reason, the first-in, first-out, which is the basis of inventory management, becomes incomplete. In addition, inventory surveys are postponed, which results in omissions of surveys and leads to forgetting orders. Also for customers, problems such as customer troubles due to out of stock and forgetting to pay for beverages will occur. Forgetting to add beverage accounting
If the frequency increases, it will cause a sales loss at the store, which will lead to a decline in the profit margin of the store, which will be a serious problem that will lead to a deterioration in business performance.

[0007] In the wholesaler, since the transfer between the food and drink store and the beverage maker is carried out by a person, the ordering and ordering work is concentrated, and when the number of items is too large, the clerical work of preparing documents becomes complicated and a contact error occurs. Increase in frequency. As a result, delivery mistakes, inconsistencies in the number of empty bottles, and the like occur, and most of the work time is spent investigating and responding to such cases, which makes the work inefficient.

[0008] The beverage maker always finishes the work of shipping the product in response to the order from the wholesaler. As a result, the actual sales quantity becomes unclear, making it difficult to grasp the actual inventory quantity. In addition to this, the designation of brands is also fluid and it is difficult to formulate a manufacturing plan, and manufacturing activities will continue without knowing the true distribution turnover rate.

The present invention has been made in view of the above problems, and the computer collects individual data for each bottled beverage sold and opened in a food and drink store by a computer to open the bottled beverage. In addition to monitoring the consumption status and inventory status in real time, data processing, warnings, and preparation of the contents are performed, and the data obtained in real time at the food and drink stores are used by food and drink stores, wholesalers, and beverage manufacturers. It is an object of the present invention to provide an online inventory management system for bottled beverages which can be shared with each other to perform inventory management at each stage of distribution.

[0010]

In order to achieve the above object, in a bottled beverage inventory management system according to the present invention, when a bottled beverage is opened, a barcode printed on the bottle is read by a barcode reader, Bottle serial number of bottled beverage opened from barcode, company name, product name, content amount,
Individual data reading means for reading individual data such as manufacturing period, and a form creating means for inputting this into a computer, performing data processing, and creating forms such as shipping and inventory,
It consists of information exchange means that automatically exchanges information with food and drink shops, wholesalers, and beverage makers through a data communication network using computers and public lines, and manages inventory in real-time in the distribution channel between manufacturers and consumers. Is characterized by.

In this case, the bar code is printed on the crown,
The crown may be opened by a bottle opener with a barcode reader or the barcode may be printed on a portion of the bottle so that the barcode can be read by the barcode reader. Also, the computer of the food and drink store is the P of the store
It is preferable to have a communication means with the OS terminal and an alarm generation means. And it is preferable that this alarm is a combination of a plurality of sounds, voices, and lights.

[0012]

In the bottled beverage stock management system of the present invention having the above-described structure, the bar code is read when the bottled beverage is opened, and the individual data of the opened bottle is input to the computer. Thereby, the bottle serial number, the company name, the product name, the content amount, the manufacturing period, etc. of the bottled beverage actually consumed at the food and beverage store are input to the computer in real time. Data is stored in a computer, and as a result of the totaling work, a daily delivery / monthly report and a daily inventory / monthly report are created and used for inventory management at restaurants. When a sales confirmation signal is given to this computer from a store register and a bottled beverage whose sales have not been confirmed is opened, both a warning and a display on the computer display generate a warning to forget accounting. To do. As a result, it is possible to prevent the charges of the food and drink shops from being charged.

Further, this data is sent to a wholesaler and a beverage maker using a computer and a public line. At the wholesaler, daily sales and monthly reports are created for each item handled and for each customer, which is the basis for inventory management and adjustment. Beverage makers also use it for inventory control and production control. Since the computers of the food and drink store, wholesaler, and beverage maker are connected to each other via the public line, it is possible to check the inventory status of each other via the computer.

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a bottled beverage inventory management system according to the present invention will be described below with reference to the accompanying drawings. FIG. 1 shows the case where the barcodes 2 to 6 are attached to the upper surface of the crown 1 of the bottle. In the figure, the case where five barcodes are printed is drawn as an example. The serial number of the bottle, the company name, and
Corresponds to product name, contents, manufacturing period. These are read by a bottle opener with a barcode reader. When the same barcodes 2 to 6 are attached to the body of the bottle, they are separately read by the barcode reader.

FIG. 2 shows the configuration of the system in the food and beverage store. A bar code reader 8 for reading and inputting data on bottled beverages is connected to the computer 7. The bar code reader 8 is of a bottle opener type when reading the bar codes 2 to 6 attached to the crown 1, and is of a normal type when reading the barcode attached to the bottle. The individual data of the bottle input from the bar code reader 8 is processed by the computer 7, and the daily delivery / monthly report,
It is output to the printer 9 in the form of a daily inventory / monthly report, a daily sales report by item, a beverage order list, an inventory turnover ratio, a profit margin by beverage, and the like. Furthermore, a modem 10 for transferring data from the food and drink store to the outside using a public line is provided to the computer 7.
Is also connected, and the register 10a and the alarm device 10b of the store for receiving the sales confirmation signal inside the food and beverage store and issuing the accounting forgetting alarm are connected. A, B, in the figure
C is an input device of the POS terminal.

The alarm device 10b is provided in a store (not shown) when the beverage is opened in excess of the sales confirmation value by the register 10a to which the sales signal from the POS terminal input device is input based on the order from the customer. At the same time as issuing an alarm such as a buzzer or sound installed at an appropriate position, blink the lamp.

FIG. 3 shows an inventory management system for bottled beverages according to the present embodiment when a system connecting food and drink shops, wholesalers and beverage makers is constructed. In the figure, the register 10a and alarm device 10b of the store connected to the computer of the food and drink store are omitted. The public line 11 has a modem 10 of a food and drink store,
A wholesaler modem 12 and a beverage maker modem 13 are connected. At the wholesaler, the modem 12 is the computer 14
It is connected to the. The computer 14 processes the data in the form of a daily sales report / monthly report for each customer, a daily sales report / monthly report for each item, an inventory turnover rate for each item, a delivery instruction for each customer, and a delivery / invoice based on the inventory status data from the restaurant. , To the printer 15. In the beverage maker, the modem 13 is connected to the computer 16. The computer 16, based on the inventory status data from the wholesaler or food and drink store, sells by item, average distribution period, sell by actual consumption date, forecasted order quantity,
The data is processed in the form of a manufacturing instruction sheet and output to the printer 17.

In the bottled beverage inventory management system of FIG.
Computers that manage the stocks of food and drink shops, wholesalers, and beverage manufacturers are online via public lines. Therefore, it becomes possible to manage information exchange very flexibly. For example, it becomes possible for large food and drink shops to purchase directly from a beverage manufacturer without going through a wholesaler. Further, it is possible for a wholesaler to monitor the stock situation of food and drink stores at any time and make business contact with the sales contact when the stock amount decreases. Furthermore, it is possible to create and add a function to automatically place an order when the stock quantity drops below a certain quantity. Another advantage is that restaurants, wholesalers, and beverage manufacturers can mutually understand the consumption status and inventory status of beverages, and can constantly obtain guidelines for optimizing the production volume and inventory volume. To be

The present invention is not limited to the above-mentioned embodiment. For example, although a printer is used for data output, a computer display can be used as a substitute, and the data output content is also an embodiment. Items other than those shown can also be used.

[0020]

As described above, according to the present invention, by acquiring the data when the bottled beverage is opened, it is possible to determine the sales status and the stock status in the food and beverage store based on the actual consumption of the bottled beverage. It enables real-time monitoring, mechanizes work such as form creation and ordering work, speeds up response, and improves work certainty. Further, by communicating signals with the register of the store, it becomes an effective system for preventing forgetting to put the accounting at the store and maintaining an appropriate profit margin of the store.

[0021] An online information network is formed by connecting computers for inventory management of food and beverage stores, wholesalers and beverage manufacturers, and data based on the consumption results of bottled beverages opened at the food and beverage stores is shared at each stage of distribution to make mutual inventory. It can be used for management to prevent overproduction, overstock, out-of-stock, etc. in the entire distribution channel and realize efficient distribution.

[Brief description of drawings]

FIG. 1 is an explanatory diagram of a crown with a barcode in an embodiment of a bottled beverage inventory management system according to the present invention.

FIG. 2 is a configuration block diagram of a computer system of a food and drink shop in an embodiment of a bottled beverage inventory management system according to the present invention.

FIG. 3 is a system configuration block diagram in which a food and drink store, a wholesale store, and a beverage maker are connected in the embodiment of the bottled beverage inventory management system according to the present invention.

[Explanation of symbols]

 1 ... Crown 2 to 6 ... Bar code 7 ... Food and drink computer 8 ... Bar code reader 9, 15, 17 ... Printer 10, 12, 13 ...・ Modem 10a ・ ・ ・ Store register 10b ・ ・ ・ Alarm device 11 ・ ・ ・ ・ Public line 14 ・ ・ ・ ・ Wholesale computer 16 ・ ・ ・ ・ ・ ・ Beverage maker computer A, B, C ・ ・ ・ POS terminal input apparatus

Claims (5)

[Claims] 1. When a bottled beverage is opened, the barcode printed on the bottle is read by a barcode reader, and the bottle serial number, company name, product name, content, manufacturing period, etc. of the bottled beverage opened from the barcode are displayed. Individual data reading means for reading individual data, a form creating means for inputting this to a computer, processing data, and creating forms such as shipping and stocking, and a food and drink store, wholesaler by a data communication network with a computer and a public line. An inventory management system for bottled beverages, which comprises information exchange means for automatically exchanging information with a beverage maker, and performs inventory control in real time on the distribution channel between the manufacturer and the consumer. 2. The inventory management system for bottled beverages according to claim 1, wherein a bar code is printed on the crown, and the crown is opened by a bottle opener with a barcode reader. 3. The bottled beverage inventory management system according to claim 1, wherein a bar code is printed on a part of the bottle, and the bar code is read by a bar code reader. 4. The food and drink computer has a sales confirmation means for receiving a sales confirmation signal from a register and an alarm generation means for issuing an alarm when the number of bottled beverages exceeds the sales confirmation number. It is equipped with a PO in the register
4. The bottled beverage inventory management system according to claim 1, further comprising a sales input means for receiving a sales signal from the S terminal input device. 5. The bottled beverage inventory management system according to claim 4, wherein the alarm comprises a plurality of combinations of sound, voice and light.