JP2005266863A - Consumption forecast system of drink - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To minimize trouble for a clerk to go round in a store as much as possible and rapidly respond to a customer. <P>SOLUTION: The system is provided with a first means for measuring a remaining amount of drink in a drink container of a customer at a predetermined time interval, a second means for calculating a drink consuming speed of the customer on the basis of the remaining amount of the drink at the predetermined time interval measured by the first measuring means, a third means for calculating a forecasted time until a latest remaining amount measured by the first means is less than a threshold value by the drink consuming speed, and a fourth means for alarming when the calculated forecasted time is less than a previously set time value. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a beverage consumption prediction system that performs consumption prediction of beverages such as beer, liquor, and juice ordered by customers in large restaurants and beer halls.

Conventionally, as a technique for managing the remaining amount of customer beverages in large restaurants, for example, the one described in Patent Document 1 below is known.
The thing of the following patent document 1 is related with the inventory management of the drink of the sales form which installs a drink bar in a shop, for example, and a customer himself / herself voluntarily picks up his drink to a drink bar. This is a management of beverage remaining amount and inventory management in units of stores.
JP 2001-249966 A

However, the technology described in Patent Document 1 is a sales form in which a drink bar is installed and the customer himself / herself can get a drink, thereby saving the labor of the store clerk and allowing the customer to change when he / she likes it. With regard to a store that does not have a drink bar or a drink that is not free to change, the store clerk must always look around the store and accept orders from customers.
In particular, customers who order alcoholic beverages tend to place orders again when their beverages run out. At that time, the customer needs to look for the store clerk, or press the store clerk call button to call the store clerk, or wait for the order until the store clerk looks around.
In particular, there is a problem that the longer the time it takes for a store clerk to pick up an order without the customer's beverage, the customer will judge that the customer service attitude at the store is worse and the reputation of the store will be lowered. .

  An object of the present invention is to provide a consumption prediction system for a customer's beverage that makes it possible for a store clerk to travel around the store as much as possible and to promptly respond to the customer.

In order to achieve the above object, the present invention provides a first means for measuring a beverage remaining amount in a customer's beverage container at a predetermined time interval, and a beverage remaining amount at a predetermined time interval measured by the first measurement means. And second means for calculating the beverage consumption rate of the customer based on the above, and third means for calculating the predicted time until the latest remaining amount measured by the first means becomes less than a threshold value based on the beverage consumption rate And a fourth means for issuing a warning when the calculated predicted time is smaller than a preset time value.
In addition, when there is past performance data recorded by the customer's cumulative beverage amount, beverage type, food ordering at the same time, and temperature, the third means refers to this performance data, A prediction time is calculated.

According to the present invention, it is possible to predict when the remaining amount of beverage ordered by the customer will run out, know when the clerk will go to the customer to order, can take the order in a timely manner, and the clerk goes around the store. The effort can be reduced as much as possible.
In addition, the forecast takes into account information that has an impact on the beverage consumption rate, so it is possible to know the appropriate ordering time, and the store clerk will take orders more efficiently. It is possible to improve store evaluation and customer satisfaction.

Hereinafter, an embodiment for carrying out the present invention will be specifically described with reference to the drawings.
FIG. 1 is a system configuration diagram showing an embodiment of the present invention.
The beverage consumption prediction system according to the present embodiment includes a local LAN 6 in a store, a portable order input device 1 in which a store clerk inputs orders from customers, and beverage containers such as mugs and cups carried to customers and customer order information. It consists of an order management server 4 that records an identifier, a remaining amount measuring device 3 that measures the remaining amount of a beverage container 2, and a remaining amount warning device 5 that warns a customer beverage remaining amount and predicts consumption.
The order input device 1 has the same configuration as a PDA-type POS terminal used in a large restaurant, an order input switch 8, a small display input content display device 9 for confirming the input content, and controls them. Control unit 7 and communication control unit 10.
The order input device 1 performs processing according to the procedure shown in FIG.
That is, the store clerk uses the order input device 1 when receiving an order and when placing a drink at a customer seat. When receiving an order, a seat identifier is input in step S11. Thereafter, the order details are input in step S112, and the order details are transmitted to the order data management server 4 through the local LAN 6 using the communication control unit 10 in step S113.
On the other hand, when the beverage ordered by the customer is placed at the customer seat, the seat identifier and the container identifier are input in step S121, and transmitted to the order data management server 5 using the communication control unit 10 in the next step S122.
The communication control unit 10 transmits / receives data to / from the order data management server 4 via the local area LAN 7.

The order data management server 4 includes a control unit 18, a communication control unit 19, and an order data recording DB 20, and is a so-called DB server.
The content of the order data record DB 20 has an order data table configuration as in the example shown in FIG. 3, and consists of an order data table 210 and an order beverage data table 220, and the order content data transmitted from the order input device 1 and The container identifier data transmitted in step S122 in FIG. 2 is recorded in association with the seat identifier.
The communication control unit 19 has a function of transmitting and receiving data with the order input device 1 and the remaining amount measuring device 3 via the local area LAN 6.

The remaining amount measuring device 3 is attached to each beverage container 2 used by a customer, such as a beer mug, pitcher, bottle of sake, or glass, and measures the weight of the beverage container 2, a dip switch 13, a measurement start switch 14, and a measurement end. A switch 15, a communication control unit 16, a timer 17 and a control unit 11 for controlling them are provided.
The operation of the remaining amount measuring device 3 will be described with reference to FIG.
The store clerk sets individual identification information for each container by the dip switch 13 before opening the store (step S21), and sets the interval time of the timer for measuring the weight (step S22).
When the store clerk brings the beverage ordered by the customer to the customer's seat, the timer start is executed by turning on the measurement start switch 14 (step S23), and the timer 17 is operated.
Beverages placed at customer seats are consumed by customers. Therefore, the weight of the container 2 is measured by the weight sensor 12 (step S24), and the measured weight, the container identifier input in step S21, and the elapsed time of the timer 17 are used as measurement data via the communication control unit 16. It transmits to the remaining amount warning device 5.

Thereafter, the process waits in step S26 for the weight measurement interval time set by the dip switch 13 in step S21 to elapse. If the interval time of the weight measurement set in the timer 17 has passed, it is determined whether the measurement end switch 15 has been pressed. If the measurement end switch 15 has not been pressed, the process returns to step S24, the remaining amount (weight) of the beverage in the container 2 is repeatedly measured at the set time interval of the timer 17, and the measurement data is transmitted to the remaining amount warning device 5. To do.
If the measurement end switch 15 is pressed, the weight measurement is stopped and finished. The measurement end switch 15 is pressed by the store clerk when the store clerk lowers the beverage container 2 from the customer seat.
In addition, about the measurement start switch 14 and the measurement end switch 15, the structure which only a shop clerk can operate and a customer cannot operate is desirable. For example, it is desirable to have a configuration that can be operated only by a remote control device carried by a store clerk (which may be provided in the order input device 1).

The remaining amount warning device 5 is a device including a control unit 21, a communication control unit 22, a temperature sensor 23, a prediction data recording DB 24, a consumption prediction program 25, a remaining amount display program 26, a speaker 27, a keyboard 28, and a display 29. For example, it is composed of a personal computer.
The prediction data recording DB 24 provided in the remaining amount warning device 5 is a database having a configuration including the remaining amount data table 600, the already drinking condition data table 610, the simultaneous order condition table 620, and the remaining consumption consumption result table 630 shown in FIGS. It is.
In the remaining amount data table 600, a condition ID, a beverage type, a remaining amount, an air temperature, a drunk drinking condition ID, and a simultaneous order condition ID are managed. Among these, the condition ID, the already-drinking condition ID, and the simultaneous ordering condition ID are the condition ID of the remaining consumption record data table 630, the already-drinking condition ID of the already-drinking condition data table 610, and the simultaneous ordering condition of the simultaneous ordering condition table 620, respectively. It points to ID.
The remaining amount warning device 5 displays the seat identifier, remaining time, current remaining amount, and type of each beverage container 2 shown in FIG. Further, the beverage container 2 that has no remaining amount and needs to be ordered from the customer is displayed in reverse color so that the store clerk can understand. FIG. 8 illustrates a state in which the fact that the remaining amount of the customer with the seat identifier = 03 has decreased is displayed in reverse color.

The operation of the consumption time prediction program 25 provided in the remaining amount warning device 5 will be described using the flowchart of FIG.
First, the weight of each container 2 containing a beverage and the remaining threshold time for warning are set (step S301).
Next, it is determined whether or not the operation of the remaining amount warning device 5 is finished (step S302). If not finished, the reception of the remaining amount data from the remaining amount measuring device 3 is waited (step S303).
When the communication control unit 22 receives the remaining amount data, a reception process is executed (step S304), and the remaining amount is obtained. When detecting the remaining amount, the weight of the container 2 itself is subtracted from the weight of the container 2 containing the beverage. In addition, the difference between the latest remaining amount data and the remaining amount data received last time or the previous time is obtained, divided by the elapsed time, and the consumption rate per reception time interval of the remaining amount data (unit = grams / sec) Calculate

Next, order data corresponding to the container identifier is acquired from the order data management server 4 (step S305). The order data acquired in step S305 is the item ordered at the same time and the beverage type and quantity indicated by the container identifier.
Next, the current temperature detected by the temperature sensor 23 is acquired (step S306).
Next, the remaining amount in the beverage container 2 of the customer calculated in step S304 is determined. If the remaining amount is less than the threshold value, it is regarded as “no remaining amount”, and the process proceeds to step S312b.
However, if the remaining amount is greater than the threshold, it is determined that “there is a remaining amount”, the process proceeds to step S308, and the actual data is searched. That is, the remaining consumption actual speed with the same condition is obtained from the remaining amount data table 600 of FIG. 6 under the same conditions as the order data acquired in step S305 and the temperature detected in step S306.
A specific example of obtaining the remaining consumption actual speed in steps 306 to 308 will be described.
For example, a customer orders “beer large” (contents 700 g) and “green soybeans”, the container identifier of the beer mug is “1001”, the temperature is 28 ° C., and 200 g of beer has already been drunk. When the amount is 500 grams, the weight data from the remaining amount measuring device 3 is sent with the container identifier “1001” and the remaining amount “500 grams”.
The seat identifier “01” is traced from the container identifier of the order beverage data table 220, and the simultaneous order product is known as “green soybean” from the order data table 210. It can be seen from the simultaneous order condition table 620 that the simultaneous order condition ID of “green soybeans” is “0000000002”.
Further, it can be seen from the ordered beverage data table 220 that the beverage ordered so far is only “large beer”, and the weight data and the ordered beverage data 220 are compared. As can be seen, the already-drinking condition ID is “0000000002” from the already-drinking condition data table 620 of FIG.
From the remaining amount data table 600 of FIG. 6A, the simultaneous order condition ID is “0000000002”, the already drinking condition ID is “0000000002”, the remaining amount is “500”, and the current temperature is 28 degrees by the temperature sensor 23. It can be seen that the condition ID “0000000002” matches the above.
From the remaining consumption record table 630 in FIG. 7B, the consumption record speeds with the matching condition ID “0000000002” are “5.64 [g / sec]” and “8.15 [g / sec]”. I understand.
In this way, you can set the conditions that affect the drinking speed, such as how much you have already drunk since you sat down, what food you ordered at the same time, how much temperature, etc. For example, if the temperature is high, or if the food you ordered is spicy or greasy, the consumption of beer will be faster, and conversely if there is a lot of drinking, the consumption will be slower, etc.) In addition, by accumulating the measured value of the actual consumption speed as statistical data, it is possible to more accurately predict when to order the next beverage.

Next, if there is a condition ID in the remaining consumption record data table 630 in FIG. 7B in step S309, the process proceeds to step S310a and the corresponding consumption record speed is set as the remaining consumption speed. In this case, if there are a plurality of items that match the condition, the average value of the actual consumption speed is set as the remaining consumption speed.
In step S309, when there is no remaining amount consumption record data under the same conditions, the process proceeds to step S310b, and the consumption rate calculated in step S304 is set as the remaining amount consumption rate.
Next, in step S311, if the value obtained by multiplying the remaining amount consumption speed by the remaining amount exceeds the remaining threshold time set in step S301, step S312b is executed, and the display item shown in FIG. The information is transferred to the display program 26 and a warning display in which the color of the seat identifier is reversed is performed.
If the remaining time is within the remaining threshold time set in step S301, the display items shown in FIG. 8 are transferred to the remaining amount display program 26 to perform normal display.
Next, in step S313, the current remaining amount, the condition, and the consumption speed calculated in step S304 are added to the remaining amount data table 600.
If there is no condition for determining the actual consumption speed in the remaining amount data table 600 in step 309, “type” and “drinking amount” are added to the already-drinking condition table 610 using the data obtained so far as a condition. The newly made ID (“already drinking conditions”), the simultaneously ordered data are added to the simultaneous order table 620 of FIG. 7A, and the newly made ID (“simultaneous order ID”) and “ After adding the “drinking type”, “remaining amount”, and “temperature” to the remaining amount data table 600 to improve the condition accuracy when obtaining the remaining remaining consumption result value, the process returns to step S302.

1 is a system configuration diagram showing an embodiment of the present invention. It is a flowchart which shows operation | movement of an order input device. It is a figure which shows the example of a memory content of order data record DB. It is a flowchart which shows operation | movement of a residual amount measuring apparatus. It is a flowchart which shows the process sequence of the consumption time prediction program of a residual amount warning apparatus. It is a figure which shows a part of memory | storage content of prediction data recording DB. It is a figure which shows a part of memory | storage content of prediction data recording DB. It is a figure which shows the residual amount display example of a residual amount warning apparatus.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Order input device 2 ... Beverage container 3 ... Remaining amount measuring device 4 ... Order data management server 5 ... Remaining amount warning device 6 ... Local area LAN
8 ... Order input switch 12 ... Weight sensor 13 ... Dip switch 14 ... Measurement start switch 15 ... Measurement end switch 17 ... Timer 20 ... Order data record DB
23 ... Temperature sensor 24 ... Predicted data record DB
25 ... Consumption time prediction program 26 ... Remaining amount display program 29 ... Display

Claims (2)

A system for predicting consumption of beer, juice, liquor and other beverages ordered by customers at restaurants,
First means for measuring the remaining amount of beverage in the customer's beverage container at predetermined time intervals;
The second means for calculating the beverage consumption rate of the customer based on the beverage remaining amount measured at the predetermined time interval measured by the first measuring means, and the latest remaining amount measured by the first means is less than the threshold value. A third means for calculating the predicted time until the beverage consumption rate,
A beverage consumption prediction system comprising: a fourth means for issuing a warning when the calculated predicted time is smaller than a preset time value.   If there is past performance data recorded by the customer's cumulative beverage quantity, beverage type, food ordering at the same time, and temperature, the third means refers to this performance data and predicts the estimated time The beverage consumption prediction system according to claim 1, wherein:

Images