JP6802492B2 - Seat allocation support device, seat allocation support program, and seat allocation support method - Google Patents

Description

The present invention relates to a seat allocation support device for supporting seat allocation work, a seat allocation support program, and a seat allocation support method.

In general, when allocating group customers to a restaurant table, it is considered that allocating as many group customers as possible to the capacity set for each table leads to an improvement in the profitability of the restaurant. Therefore, for example, a minimum number of people may be set for each table, such as allocating at least 3 people for a 4-person table (see, for example, Patent Document 1).

Japanese Unexamined Patent Publication No. 2006-31472

By the way, when one of the tables is assigned to the two-person group while the two-person table and the four-person table are vacant, the table utilization efficiency is higher when the two-person table is assigned. However, it is more comfortable for a two-person group to eat at a large four-person table, and even if a large number of foods and drinks are ordered at once, the table will not overflow. Therefore, there is a possibility that sales will be higher if a four-person table is assigned.

An object of the present invention is to provide a seating support device, a seating support program, and a seating support method capable of assisting in determining which table a specific type of user group should be assigned to.

The seating support device according to the present invention includes an acquisition processing unit that acquires history information including information on each type of user group that has used restaurants in the past, information on tables used, and information on ordered foods and drinks. It is provided with a derivation processing unit for deriving an index showing profitability or profitability when a specific type of user group uses a specific table or a specific type of table based on the history information.

In the seating support program according to the present invention, historical information including information on each type of user group who used a restaurant in the past, information on a table used, and information on ordered food and drink in one or a plurality of processors. Is a seating support program that obtains the above-mentioned history information and derives an index showing profitability or profitability when a specific type of user group uses a specific table or a specific type of table.

In the seat allocation support method according to the present invention, history information including information on each type of user group who has used the restaurant in the past, information on the table used, and information on the ordered food and drink is acquired. Based on the history information, an index showing profitability or profitability when a specific type of user group uses a specific table or a specific type of table is derived.

According to the present invention, there is provided a seating support device, a seating support program, and a seating support method capable of assisting in determining which table a specific type of user group should be assigned to.

FIG. 1 is a block diagram showing a configuration of a seat allocation support system according to an embodiment of the present invention. FIG. 2 is a diagram showing an example of user information used in the seat allocation support system according to the embodiment of the present invention. FIG. 3 is a diagram showing an example of table information used in the seating support system according to the embodiment of the present invention. FIG. 4 is a diagram showing an example of reservation information used in the seat allocation support system according to the embodiment of the present invention. FIG. 5 is a diagram showing an example of history information used in the seat allocation support system according to the embodiment of the present invention. FIG. 6 is a flowchart showing an example of a procedure of seating support processing executed by the seating support device in the seating support system according to the embodiment of the present invention. FIG. 7 is a flowchart showing an example of a procedure of new reservation processing executed by the seating support device in the seating support system according to the embodiment of the present invention. FIG. 8 is a flowchart showing an example of a procedure of new reservation processing executed by the seating support device in the seating support system according to the embodiment of the present invention. FIG. 9 is a flowchart showing an example of a walk-in processing procedure executed by the seating support device in the seating support system according to the embodiment of the present invention. FIG. 10 is a flowchart showing an example of a walk-in processing procedure executed by the seating support device in the seating support system according to the embodiment of the present invention. FIG. 11 is a diagram showing an example of a user group information input page displayed on a store terminal in the seat allocation support system according to the embodiment of the present invention. FIG. 12 is a diagram showing an example of a first seat allocation support page displayed on a store terminal in the seat allocation support system according to the embodiment of the present invention. FIG. 13 is a diagram showing an example of a reservation registration confirmation page displayed on a store terminal in the seat allocation support system according to the embodiment of the present invention. FIG. 14 is a diagram showing an example of a second seat allocation support page displayed on a store terminal in the seat allocation support system according to the embodiment of the present invention. FIG. 15 is a diagram showing an example of an allocation confirmation page displayed on a store terminal in the seat allocation support system according to the embodiment of the present invention. FIG. 16 is a diagram showing an example of an advice page displayed on a store terminal in the seat allocation support system according to the embodiment of the present invention.

Hereinafter, embodiments of the present invention will be described with reference to the accompanying drawings for the purpose of understanding the present invention. The following embodiments are examples that embody the present invention, and do not limit the technical scope of the present invention.

[Seat allocation support system 1]
As shown in FIG. 1, the seating support system 1 according to the embodiment of the present invention includes a seating support device 2, one or more store terminals 3, and one or more user terminals 4. The seat allocation support device 2 and the store terminal 3 can communicate with each other via a communication network N1 such as the Internet, LAN, WAN, or a public telephone line. The same applies to the seat allocation support device 2 and the user terminal 4.

The seat allocation support device 2 is a device for supporting the seat allocation work of allocating a table to a group of users who use a restaurant. The store terminal 3 is an information processing device operated by the manager of the restaurant. The user terminal 4 is an information processing device operated by a user of a restaurant.

[Seat allocation support device 2]
As shown in FIG. 1, the seat allocation support device 2 is a server including a control unit 21, a storage unit 22, an operation display unit 23, a communication I / F 24, and the like. The seat allocation support device 2 is not limited to one computer, and may be a computer system in which a plurality of computers operate in cooperation with each other. In addition, various processes executed by the seat allocation support device 2 may be distributed and executed by one or a plurality of processors.

The communication I / F 24 connects the seat allocation support device 2 to the communication network N1 by wire or wirelessly, and establishes a predetermined communication protocol with external devices such as the store terminal 3 and the user terminal 4 via the communication network N1. It is a communication interface for executing the following data communication.

The operation display unit 23 is a user interface including a display unit such as a liquid crystal display or an organic EL display that displays various information, and an operation unit such as a mouse, keyboard, or touch panel that accepts operations.

The storage unit 22 is a non-volatile storage unit such as an HDD (Hard Disk Drive) or an SSD (Solid State Drive) that stores various types of information. Specifically, data such as user information D1, table information D2, reservation information D3, and history information D4 are stored in the storage unit 22. Here, FIG. 2 is a diagram showing an example of user information D1. FIG. 3 is a diagram showing an example of table information D2. FIG. 4 is a diagram showing an example of reservation information D3. FIG. 5 is a diagram showing an example of history information D4.

As shown in FIG. 2, the user information D1 includes information such as a user ID, a password, and a store ID corresponding to each user (for example, a restaurant manager) of the store terminal 3. The user ID is identification information for identifying the user, and the user ID and password are used in the user login process. The store ID is identification information for identifying a restaurant managed or managed by the user.

The table information D2, the reservation information D3, and the history information D4 are stored for each store. Hereinafter, the table information D2, the reservation information D3, and the history information D4 relating to the store A will be described.

As shown in FIG. 3, the table information D2 includes information such as the capacity and seat type corresponding to each table installed in the restaurant (here, the store A). The capacity is the capacity of the table. The seat type is a seat type (chair, tatami room, etc.) of the table.

As shown in FIG. 4, the reservation information D3 includes the store visit date, store visit time, number of people, table, reservation date, member composition, etc. corresponding to each user group who has reserved the restaurant (here, store A). Information such as the purpose of use is included. The usage date is a day when the user group visits the restaurant. The store visit time is the time when the user group visits the restaurant. The number of people is the number of people in the user group. The table is a table assigned to the user group. The reservation date is the date when the reservation of the user group is accepted. The member composition is information on the member composition of the user group (user group including elderly people, user group including infants, couples, families with children, etc.). The purpose of use indicates the purpose (entertainment, banquet, anniversary, etc.) for the user group to use the restaurant. The member composition and the information of the purpose of use may be input by the representative of the user group at the time of applying for the reservation of the user group, or the management of the restaurant when the reservation of the user group is accepted. May be entered by a person or employee. The reservation information D3 also includes information such as the name of the representative of the user group, the telephone number of the representative of the user group, and the food and drink course to be provided to the user group. You may be.

Every time a new reservation is accepted, information about the reservation is registered in the reservation information D3 at any time. In addition, the reservation information D3 is updated at any time each time a change in the registered reservation contents (for example, store visit date, store visit time, number of people, etc.) is accepted.

As shown in FIG. 5, the history information D4 includes the usage date, usage time, number of people, table, member composition, purpose of use, and number of orders corresponding to each user group using the restaurant (store A in this case). , Table unit price and other information is included. The usage date is the date when the user group uses the restaurant. The usage time is the time when the user group uses the restaurant (use start time). The number of people is the number of people in the user group. The table is a table assigned to the user group. The member composition is information on the member composition of the user group (user group including elderly people, user group including infants, couples, families with children, etc.). The purpose of use indicates the purpose (entertainment, banquet, anniversary, etc.) for the user group to use the restaurant. The number of orders is the number of foods and drinks ordered by the user group at the restaurant. The number of orders may be the number of orders excluding drinks (that is, the number of ordered foods). The table unit price is a fee paid by the user group to the restaurant. Various information included in the history information D4 may be automatically acquired from the reservation information D3, or may be input by a restaurant manager or an employee.

As another embodiment, a part or all of information such as user information D1, table information D2, reservation information D3, and history information D4 is stored in a server accessible from the seating support device 2. Is also possible. Then, the control unit 21 of the seat allocation support device 2 may acquire various information from the server and execute each process such as the seat allocation support process (see FIGS. 6 to 10) described later.

In addition, the storage unit 22 has a user group information input page P1 (see FIG. 11), a first seat allocation support page P21 (see FIG. 12), a reservation registration confirmation page P31 (see FIG. 13), and a second allocation, which will be described later. Data such as the seat support page P22 (see FIG. 14), the allocation confirmation page P32 (see FIG. 15), and the advice page P4 (see FIG. 16) are also stored.

Further, the storage unit 22 stores a control program such as a seating support program for causing the control unit 21 to execute the seating support processing (see FIGS. 6 to 10) described later. For example, the seating support program is non-temporarily recorded on a computer-readable recording medium such as a CD or DVD, and a reading device such as a CD drive or a DVD drive included in the seating support device 2 (not shown). It is read by and stored in the storage unit 22.

The control unit 21 has control devices such as a CPU, a ROM, and a RAM. The CPU is a processor that executes various arithmetic processes. The ROM is a non-volatile storage unit in which control programs such as a BIOS and an OS for causing the CPU to execute various arithmetic processes are stored in advance. The RAM is a volatile or non-volatile storage unit that stores various types of information, and is used as a temporary storage memory (working area) for various processes executed by the CPU. Then, the control unit 21 controls the seat allocation support device 2 by executing various control programs stored in advance in the ROM or the storage unit 22 on the CPU.

By the way, in a restaurant, when one of the tables is assigned to a group of two people with the two-person table and the four-person table vacant, the table utilization efficiency is higher when the two-person table is assigned. However, it is more comfortable for a two-person group to eat at a large four-person table, and even if a large number of foods and drinks are ordered at once, the table will not overflow. Therefore, there is a possibility that sales will be higher if a four-person table is assigned. In the seat allocation support system 1 according to the present embodiment, it is possible to support the determination of which table the user group of a specific type should be assigned by the configuration and operation as described below.

Specifically, as shown in FIG. 1, the control unit 21 includes various types such as an acquisition processing unit 211, a derivation processing unit 212, a presentation processing unit 213, a selection processing unit 214, an advice processing unit 215, and a reservation processing unit 216. Includes processing unit. The control unit 21 functions as the processing unit by executing various processes according to the seat allocation support program on the CPU. Further, a part or all of the processing unit may be composed of an electronic circuit. The seating support program may be a program for causing a plurality of processors to function as the processing unit.

The acquisition processing unit 211 acquires the history information D4 from, for example, the storage unit 22. As described above, the history information D4 includes information on each type (number of people, member composition, purpose of use, etc.) of each user group who used the restaurant in the past, information on the table used, and information on the ordered food and drink ( For example, the number of orders, the table unit price, etc.) are included. In addition, in the history information D4, as "information about the ordered food and drink", identification information for identifying the ordered food and drink, price information indicating the price of the ordered food and drink, and the cost of the ordered food and drink Information such as cost information indicating the above, profit information indicating the profit obtained by using the user group, and the like may be included.

Based on the history information D4 acquired by the acquisition processing unit 211, the derivation processing unit 212 sets an index indicating profitability or profitability when a specific type of user group uses a specific table or a specific type of table. Derived. The indicators showing profitability are, for example, predicted profit and average profit. The index showing profitability is, for example, the number of forecast orders, the forecast table unit price (forecast sales), the average number of orders, the average table unit price (average sales), and the like. For example, the derivation processing unit 212 may derive the expected number of orders or the estimated table unit price when a specific type of user group (for example, a group of two people) uses a specific table (for example, private room table E). Good (see FIG. 13). In addition, the derivation processing unit 212 determines the estimated number of orders or the estimated table unit price when a specific type of user group (for example, a two-person group) uses a specific type of table (for example, a chair-type four-person table). The indicated index may be derived (see FIG. 12).

Information on the type of the user group may be input through the operation display unit 33 of the store terminal 3 (see FIG. 11). That is, the information on the type of the user group may be input by the manager of the restaurant. Alternatively, the information on the type of the user group may be input through the operation display unit 43 of the user terminal 4. That is, the information on the type of the user group may be input by the user who applies for the reservation of the restaurant.

The derivation processing unit 212 indicates profitability or profitability when a specific type of user group uses the specific table or the specific type table on a specific date or a specific date and time based on the history information D4. An index may be derived. For example, the derivation processing unit 212 uses the specific table or the specific type table on the usage date or the usage date and time in which at least one of the month, the date, the day of the week, and the time zone is the same as the specific date or the specific date and time. The index may be derived based on the history information D4 for the type of user group. In a general restaurant, the number of orders and the table unit price change greatly depending on the time of day and the day of the week. For example, the number of orders and the unit price of a table may increase during the dinner time than during the lunch time. In addition, the number of orders and the table unit price may increase during the Friday dinner time than during the Wednesday dinner time. In such a case, the derivation processing unit 212 uses the specific type or the specific type of table on the use date or use date and time in which the day of the week and the time zone are the same as the specific day or the specific date and time. The index may be derived based on the history information D4 about the person group. As a result, the derivation processing unit 212 can derive a more accurate index.

The presentation processing unit 213 presents the index derived by the derivation processing unit 212. For example, the presentation processing unit 213 transmits information indicating the index to the store terminal 3 through the communication I / F 24, and causes the operation display unit 33 of the store terminal 3 to display the index (see FIGS. 12 to 15).

The derivation processing unit 212 may derive the index for each table that can be assigned to the user group of the specific type (see step S25 in FIG. 7 or step S55 in FIG. 9). In this case, the presentation processing unit 213 may present the index for each table (see FIG. 13 or FIG. 15).

The selection processing unit 214 selects a table to be assigned to the user group of the specific type based on the index for each of the tables derived by the derivation processing unit 212. For example, the selection processing unit 214 selects a table to be assigned to the specific type of user group based on the predicted group unit price for each table and the ratio of the number of people in the user group to the capacity of the table. For example, the selection processing unit 214 selects the table having the highest predicted table unit price among the tables excluding the “reserved table”, the “non-assignable table”, and the “recommended securing table” described later, for the user of the specific type. It may be selected as a table to be assigned to a group (that is, a “recommended allocation table” described later). The "recommended reservation table" is a table in which more sales or profits can be expected if the user group of the specific type is not assigned and is reserved for another user group. Is. In the "recommended securing table", for example, the unit price ratio (that is, the ratio of the predicted table unit price to the average table unit price of the table) is equal to or more than a predetermined threshold value A, and the number of people ratio (that is, the user group to the capacity of the table). (Ratio of the number of people) is a table in which the predetermined threshold value B or more is set.

The advice processing unit 215 presents advice information according to the index derived by the derivation processing unit 212. For example, the advice processing unit 215 transmits the advice information according to the index to the store terminal 3 through the communication I / F 24, and displays the advice information (for example, the target number of orders) on the operation display unit 33 of the store terminal 3. (See FIG. 16). In addition, the advice processing unit 215 provides advice information according to the difference between the indexes between the tables (for example, "when allocating a two-person table, the predicted number of ordered foods is one item as compared with the case where a four-person table is assigned." It will be reduced, so let's do our best to order one extra item. ") May be presented.

The reservation processing unit 216 makes a new reservation from the specific type of user group who wishes to use the restaurant on a specific day or a specific date and time based on the index derived by the out-licensing processing unit 212. Determine if it should be accepted. For example, the reservation processing unit 216 specifies the predicted group unit price for each table and the past average group unit price for each table for all the tables available to the user group on the specific date or the specific date and time. If the conditions are met, it may be determined that new reservations from the user group should not be accepted. More specifically, the reservation processing unit 216 determines the unit price ratio (that is, the ratio of the forecast table unit price to the average table unit price) for all the tables available to the user group on the specific date or the specific date and time. ) Is less than the threshold value B, it may be determined that new reservations from the user group should not be accepted. Alternatively, the reservation processing unit 216 may use the user when the average table unit price is higher than the predicted table unit price for all the tables available to the user group on the specific date or the specific date and time. It may be determined that new reservations from the group should not be accepted.

The reservation processing unit 216 may present advice information according to the determination result. For example, the reservation processing unit 216 transmits a message indicating whether or not to accept a new reservation from the user group to the store terminal 3 through the communication I / F 24, and sends the message to the operation display unit 33 of the store terminal 3. It may be displayed. The advice information is not limited to the message, and may be presented as, for example, a change in the display mode of the table selection keys K22 to K28 shown in FIG. For example, the table selection key K28 and the table selection key K26 shown in FIG. 12 indicate that the private room table F and the private room table G are "recommended securing tables", and the two user groups are divided into the private room table F and the private room table F. Indicates that it should not be assigned to private room table G. When the display mode of all the table selection keys is a display mode indicating a "reserved table" or a "reserved recommended table", the display means that new reservations from the user group should not be accepted.

Further, the reservation processing unit 216 accepts a new reservation from the user group when the determination result is positive, and when the determination result is negative, the reservation processing unit 216 is new from the user group. Reservations may not be accepted (ie, rejected). As a result, the reservation processing unit 216 automatically accepts and rejects new reservations, which saves the user the trouble of accepting and rejecting new reservations.

[Store terminal 3]
As shown in FIG. 1, the store terminal 3 includes a control unit 31, a storage unit 32, an operation display unit 33, a communication I / F 34, and the like. The store terminal 3 is an information processing device such as a mobile phone, a smartphone, a tablet terminal, or a personal computer.

Specifically, the restaurant manager logs in to the seat allocation support device 2 by entering the user ID and password on the predetermined login page displayed on the store terminal 3, and enters the management page of his / her restaurant. to access. Then, the administrator can call the user group information input page P1 as shown in FIG. 11 from the management page and input the user group information. The user group information is information about a user group who wants to use the restaurant. For example, when the administrator receives an application for a new reservation by telephone from a user, the administrator can call the user group information input page P1 and input the user group information. In addition, the administrator can call the user group information input page P1 and input the user group information when the user group visits the store (so-called walk-in) without making a reservation. The data of the user group information input page P1 (for example, a web page described in HTML) is transmitted from the seat allocation support device 2 to the store terminal 3.

The communication I / F 34 connects the store terminal 3 to the communication network N1 by wire or wirelessly, and performs data communication according to a predetermined communication protocol with an external device such as the seat allocation support device 2 via the communication network N1. It is a communication interface to execute.

The operation display unit 33 is a user interface including a display unit such as a liquid crystal display or an organic EL display that displays information such as various web pages, and an operation unit such as a mouse, keyboard, or touch panel that accepts operations.

The storage unit 32 is a non-volatile storage unit such as an HDD (Hard Disk Drive), an SSD (Solid State Drive), or a flash memory that stores various types of information. For example, a control program such as a browser program is stored in the storage unit 32. Specifically, the browser program is a control program for causing the control unit 31 to execute communication processing with an external device such as the seating support device 2 according to a communication protocol such as HTTP (Hypertext Transfer Protocol).

The control unit 31 has control devices such as a CPU, a ROM, and a RAM. The CPU is a processor that executes various arithmetic processes. The ROM is a non-volatile storage unit in which control programs such as a BIOS and an OS for causing the CPU to execute various processes are stored in advance. The RAM is a volatile or non-volatile storage unit that stores various types of information, and is used as a temporary storage memory (working area) for various processes executed by the CPU. Then, the control unit 31 controls the store terminal 3 by executing various control programs stored in advance in the ROM or the storage unit 32 on the CPU.

Specifically, the control unit 31 functions as the browser processing unit 311 by executing various processes according to the browser program stored in the storage unit 32. The browser processing unit 311 displays a web page provided from the seating support device 2 via the communication network N1 on the operation display unit 33, and inputs an operation for the operation display unit 33 to the seating support device 2. It is possible to do it. A part or all of the processing units included in the control unit 31 may be composed of electronic circuits.

[User terminal 4]
As shown in FIG. 1, the user terminal 4 includes a control unit 41, a storage unit 42, an operation display unit 43, a communication I / F 44, and the like. The user terminal 4 is an information processing device such as a mobile phone, a smartphone, a tablet terminal, or a personal computer.

Specifically, the user of the restaurant acquires the data of the search page (not shown) from the seat allocation support device 2 by inputting a predetermined URL on the user terminal 4, and displays the data on the operation display unit 33. Display the search page. Then, the user searches for a restaurant that matches the desired conditions (for example, a restaurant that can be used by a group of a desired number of people at a desired date and time), and desires from the restaurants presented as the search result. You can select a restaurant and apply for a new reservation for that restaurant. When the user makes an application for a new reservation for a specific restaurant, information such as the date of visit, the time of visit, and the number of visitors is notified to the manager of the restaurant as the user group information. Alternatively, the user group information may be recorded in the storage unit 22 of the seat allocation support device 2 and appropriately referred to from the store terminal 3.

The communication I / F44 connects the user terminal 4 to the communication network N1 by wire or wirelessly, and data communication according to a predetermined communication protocol with an external device such as the seat allocation support device 2 via the communication network N1. Is a communication interface for executing.

The operation display unit 43 is a user interface including a display unit such as a liquid crystal display or an organic EL display that displays information such as various web pages, and an operation unit such as a mouse, keyboard, or touch panel that accepts operations.

The storage unit 42 is a non-volatile storage unit such as an HDD (Hard Disk Drive), an SSD (Solid State Drive), or a flash memory that stores various types of information. For example, a control program such as a browser program is stored in the storage unit 42. Specifically, the browser program is a control program for causing the control unit 41 to execute communication processing with an external device such as the seating support device 2 according to a communication protocol such as HTTP (Hypertext Transfer Protocol).

The control unit 41 has control devices such as a CPU, a ROM, and a RAM. The CPU is a processor that executes various arithmetic processes. The ROM is a non-volatile storage unit in which control programs such as a BIOS and an OS for causing the CPU to execute various processes are stored in advance. The RAM is a volatile or non-volatile storage unit that stores various types of information, and is used as a temporary storage memory (working area) for various processes executed by the CPU. Then, the control unit 41 controls the user terminal 4 by executing various control programs stored in advance in the ROM or the storage unit 42 on the CPU.

Specifically, the control unit 41 functions as the browser processing unit 411 by executing various processes according to the browser program stored in the storage unit 42. The browser processing unit 411 displays the web page provided from the seating support device 2 via the communication network N1 on the operation display unit 43, and inputs the operation for the operation display unit 43 to the seating support device 2. It is possible to do it. A part or all of the processing units included in the control unit 41 may be composed of electronic circuits.

[Seat allocation support processing]
Hereinafter, the seating support process executed by the control unit 21 of the seating support device 2 will be described with reference to FIGS. 6 to 10.

The present invention can be regarded as an invention of a seating support method for executing one or more steps included in the seating support process, and one or more of the seating support processes described here. Steps may be omitted as appropriate. The execution order of each step in the seat allocation support process may be different as long as the same effect is produced. Further, here, a case where each step in the seat allocation support process is executed by the control unit 21 will be described as an example, but each step in the seat allocation support process is distributedly executed by a plurality of processors. A seat support method can also be considered as another embodiment.

The seat allocation support process may be terminated at an arbitrary timing in response to a specific operation by the user (for example, an operation of an end button (not shown)).

<Step S11>
First, in step S11, the control unit 21 causes the operation display unit 33 of the store terminal 3 to display the user group information input page P1 as shown in FIG. Specifically, the control unit 21 transmits the data of the user group information input page P1 to the store terminal 3 in response to a user operation on the operation display unit 33 of the store terminal 3. As a result, the user group information input page P1 is displayed on the operation display unit 33 of the store terminal 3.

As shown in FIG. 11, the user group information input page P1 includes a plurality of radio buttons R11 and R12 for inputting user group information and a plurality of input fields B11 to B15. The radio buttons R11 and R12 selectively indicate whether the user group wishing to use the restaurant is a user group applying for a new reservation or a walk-in user group. This is an operation key for selecting. Only when the radio button R11 corresponding to the new reservation is selected, the input operation to the input fields B11 and B12 is possible. The input field B11 is an input field for inputting the visit date of the user group applying for a new reservation, and the input field B12 is an input field for inputting the visit time of the user group.

The input field B13 is an input field for inputting the number of people in the user group. The input field B14 is an input field for inputting the member composition of the user group (for example, a couple, an infant, a child, an elderly person, etc.). The input field B14 is an input field for inputting the purpose of use of the user group (for example, anniversary, banquet, entertainment, etc.). The input field B14 and the input field B15 may be omitted.

<Step S12>
In step S12, the control unit 21 acquires the user group information input through the user group information input page P1. For example, when the operation key K11 included in the user group information input page P1 is operated, the control unit 21 acquires information indicating the selected state of the radio buttons R11 and R12 at that time, and the input fields B11 to B15. Acquires the content entered in as user group information.

In another embodiment, the control unit 21 receives an application for a new reservation from the user terminal 4 to the seat allocation support device 2 instead of acquiring the user group information through the user group information input page P1. The user group information recorded in the storage unit 22 of the seat allocation support device 2 at the time of the operation may be acquired from the storage unit 22.

<Step S13>
In step S13, the control unit 21 determines whether or not the user group information acquired in step S12 is the user group information corresponding to the new reservation. Specifically, when the radio button R11 is selected on the user group information input page P1, the control unit 21 determines that the user group information is the user group information corresponding to the new reservation. Then, when it is determined that the user group information is the user group information corresponding to the new reservation (S13: Yes), the process travels to step S14. On the other hand, when it is determined that the user group information is the user group information corresponding to the walk-in (S13: No), the process proceeds to step S15.

<Step S14>
In step S14, the control unit 21 executes a new reservation process. The details of the new reservation process will be described later. When the new reservation process is completed, the seat allocation support process is completed.

<Step S15>
In step S15, the control unit 21 executes the walk-in process. The details of the walk-in process will be described later. When the walk-in process is completed, the seat allocation support process is completed.

[New reservation processing]
Next, the new reservation process executed in step S14 will be described with reference to FIGS. 7 and 8.

<Step S21>
In step S21, the control unit 21 causes the operation display unit 33 of the store terminal 3 to display the first seat allocation support page P21 as shown in FIG. Specifically, the control unit 21 transmits the data of the first seat allocation support page P21 to the store terminal 3. As a result, the first seat allocation support page P21 is displayed on the operation display unit 33 of the store terminal 3. The first seat allocation support page P21 includes a user group information area A21, a reservation status area A22, and a prediction information area A23, but in the state immediately after being displayed in step S21, the user Information is displayed only in the group information area A21, and no information is displayed in the reservation status area A22 and the prediction information area A23.

The user group information is displayed in the user group information area A21. Further, the user group information area A21 includes a change key K21 for changing the user group information. When the change key K21 is operated, the first seat allocation support page P21 is closed and the user group information input page P1 is redisplayed.

In the reservation status area A22, as the reservation status information, information indicating the reservation status of each table at the store visit date and time indicated by the user group information is displayed. The reservation status information is displayed in the reservation status area A22 in step S31 described later.

In the forecast information area A23, as forecast information, the forecast order number and the forecast table unit price of the user group corresponding to the user group information are displayed for each table type. The predicted number of orders is a predicted value of the number of orders when the user group is assigned to the table corresponding to the table type. The predicted table unit price is a predicted value of the table unit price when the user group is assigned to the table corresponding to the table type. The prediction information is displayed in the prediction information area A23 in step S33 described later.

<Step S22>
In step S22, the control unit 21 has the following step S23 from among a plurality of tables installed in the restaurant (here, as shown in FIG. 3, seven tables from table A to private room table G). The table to be processed in S29 is selected as the table of interest.

<Step S23>
In step S23, the control unit 21 determines whether or not the attention table is reserved at the store visit date and time indicated by the user group information. Specifically, the control unit 21 determines whether or not the attention table is reserved based on the reservation information D3 stored in the storage unit 22. Then, when it is determined that the attention table is reserved (S23: Yes), the process proceeds to step S24. On the other hand, if it is determined that the attention table is not reserved (S23: No), the process proceeds to step S25.

<Step S24>
In step S24, the control unit 21 sets the attention table as a "reserved table". Then, the process proceeds to step S29.

<Step S25>
In step S25, the control unit 21 (derivation processing unit 212) derives the predicted table unit price when the user group indicated by the user group information is assigned to the attention table. Hereinafter, an example of the method for deriving the unit price of the forecast table will be described.

The control unit 21 (acquisition processing unit 211) acquires the history information D4 from the storage unit 22. Then, the control unit 21 (derivation processing unit 212) extracts a record that satisfies all of the following first and third conditions from the plurality of records included in the history information D4.

(First condition)
A record in which the usage date and usage time satisfy a predetermined relationship with the store visit date and store visit time indicated by the user group information. For example, a record in which the day of the week and the time zone corresponding to the usage date and the usage time match the day of the week and the time zone corresponding to the store visit date and the store visit time indicated by the user group information. The visit date indicated by the user group information is an example of the "specific date" of the present invention. In addition, the store visit date and store visit time indicated by the user group information is an example of the "specific date and time" of the present invention.

(Second condition)
A record relating to a user group of the same type as the user group indicated by the user group information. The user group of the same type as the user group indicated by the user group information is an example of the "user group of a specific type" of the present invention.

(Third condition)
A record about the same table as the noteworthy table. The same table as the table of interest is an example of the "specific table" of the present invention.

The control unit 21 derives a predicted table unit price when the attention table is assigned to the user group indicated by the user group information based on the records extracted based on the first condition to the third condition. .. Specifically, the control unit 21 derives the average value of the table unit prices in the records extracted based on the first condition to the third condition as the predicted table unit price. That is, in the past, the forecast table unit price is such that the user group of the same type as the user group indicated by the user group information sets the attention table on the same day and time zone as the store visit date and time indicated by the user group information. The average value of the table unit price when used is shown.

<Step S26>
In step S26, the control unit 21 (derivation processing unit 212) derives the average table unit price of the attention table. Specifically, the control unit 21 extracts records satisfying the following fourth and fifth conditions from the plurality of records included in the history information D4.

(Fourth condition)
A record in which the usage date and usage time satisfy a predetermined relationship with the store visit date and store visit time indicated by the user group information. For example, a record in which the day of the week and the time zone corresponding to the usage date and the usage time match the day of the week and the time zone corresponding to the store visit date and the store visit time indicated by the user group information.

(Fifth condition)
A record about the same table as the noteworthy table.

The control unit 21 derives the average table unit price of the attention table based on the records extracted based on the fourth condition and the fifth condition. Specifically, the control unit 21 derives the average value of the table unit prices in the records extracted based on the fourth condition and the fifth condition as the average table unit price. That is, the average table unit price indicates the average value of the table unit price when an unspecified user group uses the attention table in the past on the same day of the week and time zone as the store visit date and time indicated by the user group information. ing.

<Step S27>
In step S27, the control unit 21 (reservation processing unit 216) calculates the ratio of the forecast table unit price derived in step S25 to the average table unit price derived in step S26 (hereinafter, referred to as a unit price ratio). Then, it is determined whether or not the unit price ratio is smaller than the predetermined threshold value A (for example, 70%). For example, when the average table unit price is 10,000 yen and the forecast table unit price is 8,000 yen, the unit price ratio is 80%. Further, when the average table unit price is 6000 yen and the forecast table unit price is 4000 yen, the unit price ratio is 67%. Then, when it is determined that the unit price ratio is smaller than the threshold value A (S27: Yes), the process proceeds to step S29. On the other hand, when it is determined that the number ratio is equal to or greater than the threshold value A (S27: No), the process proceeds to step S28.

<Step S28>
In step S28, the control unit 21 (reservation processing unit 216) calculates the ratio of the number of people in the user group (hereinafter referred to as the number ratio) indicated by the user group information to the capacity of the attention table, and the number ratio. Is smaller than a predetermined threshold value B (for example, 50%). For example, when the capacity of the attention table is four and the number of people in the user group is two, the number ratio is 50%. Further, when the capacity of the attention table is 8 and the number of people in the user group is 2, the ratio of the number of people is 25%. As described above, the ratio of the number of people indicates the efficiency of table utilization. Then, when it is determined that the number ratio is smaller than the threshold value B (S28: Yes), the process proceeds to step S29. On the other hand, when it is determined that the number ratio is equal to or greater than the threshold value B (S28: No), the process proceeds to step S30.

<Step S29>
In step S29, the control unit 21 (reservation processing unit 216) sets the attention table as the “recommended securing table”. Then, the process proceeds to step S30. Of the unreserved tables, it is better to reserve the "reserved recommended table" for another user group without allocating the user group corresponding to the user group information. Or it is a table where profits are expected.

<Step S30>
In step S30, the control unit 21 selects as the attention table among the plurality of tables installed in the restaurant (here, seven tables from the table A to the private room table G as shown in FIG. 3). Determine if there are any tables that are not. Then, when it is determined that there is a table that has not been selected as the table of interest (S30: Yes), the process returns to step S22. On the other hand, if it is determined that there is no table that has not been selected as the table of interest (S30: No), the process proceeds to step S31.

<Step S31>
In step S31, the control unit 21 (selection processing unit 214) selects a table to be assigned to the user group corresponding to the user group information as a “assignment recommended table”. For example, the control unit 21 selects the table having the highest predicted table unit price as the “allocation recommended table” among the tables that are not set in the “reserved table” or the “reserved recommended table”. Then, the control unit 21 sets a table other than the "reserved table", the "recommended reservation table", and the "recommended allocation table" as the "empty table".

<Step S32>
In step S32, the control unit 21 (reservation processing unit 216) has a plurality of table selection keys K22 to K28 corresponding to a plurality of tables installed in the restaurant in the reservation status area A22 of the first seat allocation support page P21. Is displayed. Then, the control unit 21 makes each display mode of the table selection keys K22 to K28 different according to the reservation status of the corresponding table. For example, the control unit 21 displays the table selection keys (here, table selection keys K22 to K25) corresponding to the table set as the “empty table” in step S31 in the first display mode (for example, a white background color). Display with. Further, the control unit 21 displays the table selection keys (here, table selection keys K26 and K28) corresponding to the table set in the “recommended reservation table” in step S29 in the second display mode (for example, a light gray background). Display in color). Further, the control unit 21 displays the table selection key corresponding to the table set in the “reserved table” in step S24 in the third display mode (for example, a dark gray background color). Further, the control unit 21 displays the table selection key (here, the table selection key K27) corresponding to the table set in the “assignment recommendation table” in step S31 in the fourth display mode (for example, a light red background color). Display with.

It should be noted that each of the table selection keys may be displayed in a different display mode depending on the predicted table unit price of the corresponding table. For example, the higher the predicted table unit price of the corresponding table, the darker the background color (for example, dark red) is displayed, and the lower the predicted table unit price of the corresponding table, the lighter the background color (for example, light red). It may be displayed as. As a result, the restaurant manager can easily distinguish between a table having a high predicted table unit price and a table having a low predicted table unit price of the corresponding table simply by looking at the table selection key.

Further, in the present embodiment, the reservation status of each table is displayed by the table selection keys K22 to K28, but in other embodiments, the reservation status of each table may be displayed in a table format.

<Step S33>
In step S33, the control unit 21 (derivation processing unit 212) derives the prediction information for each predetermined table type. For example, the control unit 21 derives the predicted order number, the average order number, the predicted table unit price, and the average table unit price for each predetermined table type.

For example, the estimated number of orders for the table type of the "four-person table (chair)" (that is, the chair-type four-person table) is derived as follows.

The control unit 21 (acquisition processing unit 211) acquires the history information D4 from the storage unit 22. Then, the control unit 21 (derivation processing unit 212) extracts a record that satisfies all of the following sixth and eighth conditions from the plurality of records included in the history information D4.

(6th condition)
A record in which the usage date and usage time satisfy a predetermined relationship with the store visit date and store visit time indicated by the user group information. For example, a record in which the day of the week and the time zone corresponding to the usage date and the usage time match the day of the week and the time zone corresponding to the store visit date and the store visit time indicated by the user group information.

(7th condition)
A record relating to a user group of the same type as the user group indicated by the user group information.

(8th condition)
A record relating to a table (here, table C and table D) corresponding to the table type of "four-person table (chair)". The table corresponding to the table type of the "four-person table (chair)" is an example of the "specific type table" of the present invention.

The control unit 21 corresponds to the table type of "four-person table (chair)" in the user group indicated by the user group information based on the records extracted based on the sixth condition to the seventh condition. Derive the expected number of orders when the table is assigned. Specifically, the control unit 21 derives the average value of the number of orders in the records extracted based on the sixth condition to the eighth condition as the predicted order number.

In addition, the average number of orders for each table type of "four-person table (chair)" is derived as follows.

The control unit 21 extracts records satisfying the following ninth and tenth conditions from the plurality of records included in the history information D4.

(9th condition)
A record in which the usage date and usage time satisfy a predetermined relationship with the store visit date and store visit time indicated by the user group information. For example, a record in which the day of the week and the time zone corresponding to the usage date and the usage time match the day of the week and the time zone corresponding to the store visit date and the store visit time indicated by the user group information.

(10th condition)
A record relating to a table (here, table C and table D) corresponding to the table type of "four-person table (chair)".

The control unit 21 derives the average number of orders for each table type of the "four-person table (chair)" based on the records extracted based on the ninth condition and the tenth condition. Specifically, the control unit 21 derives the average value of the number of orders in the records extracted based on the ninth condition and the tenth condition as the average number of orders.

<Step S34>
In step S34, the control unit 21 (presentation processing unit 213) displays the derivation result in step S33 as the prediction information in the prediction information area A23 on the first seating support page P21. Then, the process proceeds to step S41 of FIG.

<Step S41>
In step S41, the control unit 21 determines whether or not any one of the plurality of tables installed in the restaurant has been selected. Specifically, the control unit 21 operates the table when any of the plurality of table selection keys K22 to K28 displayed in the reservation status area A22 on the first seat allocation support page P21 is operated. It is determined that the table corresponding to the selection key has been selected. However, in the present embodiment, the operation for the table selection key corresponding to the "reserved table" is not accepted, and only the operation for the table selection key corresponding to the "empty table" or the "recommended reservation table" is accepted. .. Then, when it is determined that any of the tables has been selected (S41: Yes), the process proceeds to step S42. On the other hand, if it is determined that none of the tables has been selected (S41: No), the process of step S41 is repeated until it is determined that any of the tables has been selected.

<Step S42>
In step S42, the control unit 21 (derivation processing unit 212) derives the prediction information regarding the selected table. For example, the control unit 21 derives the predicted order number, the average order number, the predicted table unit price, and the average table unit price of the selected table. As for the forecast table unit price and the average table unit price, the forecast table unit price and the average table unit price derived in step S25 and step S26 may be diverted.

<Step S43>
In step S43, as shown in FIG. 13, the control unit 21 (presentation processing unit 213) displays the reservation registration confirmation page P31 corresponding to the selected table (here, the private room table E) as an operation display of the store terminal 3. It is displayed on the unit 33. On the reservation registration confirmation page P31, the capacity and seat type of the selected table are displayed based on the table information D2 stored in the storage unit 22. Further, on the reservation registration confirmation page P31, the prediction information derived in step S42 is displayed.

The reservation registration confirmation page P31 includes a reservation registration key K31 and a cancellation key K32. The reservation registration key K31 is an operation key for accepting a new reservation related to the user group information and registering the application content of the new reservation in the reservation information D3. The cancel key K32 is an operation key for closing the reservation registration confirmation page P31.

The restaurant manager can appropriately determine whether or not to accept the new reservation by referring to the information displayed on the reservation registration confirmation page P31, the information displayed in the prediction information area A23, and the like. It will be possible.

In this embodiment, the table selection key K28 corresponding to the table set in the "recommended securing table" (here, the table selection key K28 corresponding to the private room table F or the table selection key K26 corresponding to the private room table G). ) Is also operated, the reservation registration confirmation page P31 is displayed. Therefore, in the present embodiment, the restaurant manager can also assign the user group indicated by the user group information to the table set in the "securing recommended table", if necessary. However, in another embodiment, the reservation registration confirmation page P31 may be displayed only when the table selection key corresponding to the table set in the "assignment recommended table" or the "empty table" is operated. As a result, it is possible to prevent the user group indicated by the user group information from being erroneously assigned to the table set in the "recommended reservation table".

<Step S44>
In step S44, the control unit 21 determines whether or not the reservation registration operation has been performed. Specifically, the control unit 21 determines that the reservation registration operation has been performed when the reservation registration key K31 included in the reservation registration confirmation page P31 is operated. Then, when it is determined that the reservation registration operation has been performed (S44: Yes), the process proceeds to step S47. On the other hand, if it is determined that the reservation registration operation has not been performed (S44: No), the process proceeds to step S45.

<Step S45>
In step S45, the control unit 21 determines whether or not the cancel operation has been performed. Specifically, the control unit 21 determines that the cancel operation has been performed when the cancel key K32 included in the reservation registration confirmation page P31 is operated. Then, when it is determined that the cancel operation has been performed (S45: Yes), the process proceeds to step S46. On the other hand, if it is determined that the cancel operation has not been performed (S45: No), the process returns to the step S44.

<Step S46>
In step S46, the control unit 21 closes the reservation registration confirmation page P31. Then, the process returns to the step S41.

<Step S47>
In step S47, the control unit 21 executes the reservation registration process. In the reservation registration process, the user group information and information about the selected table are registered in the reservation information D3 stored in the storage unit 22. Then, the new reservation process is completed.

[Walk-in processing]
Next, the walk-in process executed in step S15 (FIG. 6) will be described with reference to FIGS. 9 and 10.

<Step S51>
In step S51, the control unit 21 causes the operation display unit 33 of the store terminal 3 to display the second seat allocation support page P22 as shown in FIG. Specifically, the control unit 21 transmits the data of the second seat allocation support page P22 to the store terminal 3. As a result, the second seat allocation support page P22 is displayed on the operation display unit 33 of the store terminal 3. The second seat allocation support page P22 includes a user group information area A24, a usage status area A25, and a prediction information area A26, but in the state immediately after being displayed in step S51, the user Information is displayed only in the group information area A24, and no information is displayed in the usage status area A25 and the prediction information area A26.

The user group information is displayed in the user group information area A24. In the user group information area A24 on the second seat allocation support page P22, the current date and time is displayed as the store visit date and time. Further, the user group information area A24 includes a change key K21 for changing the user group information. When the change key K21 is operated, the second seating support page P22 is closed and the user group information input page P1 is redisplayed.

In the usage status area A25, information indicating the current usage status of each table is displayed as usage status information. The usage status information is displayed in the usage status area A25 in step S62 described later.

In the forecast information area A26, as forecast information, the forecast order number and the forecast table unit price of the user group corresponding to the user group information are displayed for each table type. The prediction information is displayed in the prediction information area A26 in step S64 described later.

<Step S52>
In step S52, the control unit 21 has the following step S53 from among a plurality of tables installed in the restaurant (here, as shown in FIG. 3, seven tables from table A to private room table G). The table to be processed in S59 is selected as the table of interest.

<Step S53>
In step S53, the control unit 21 determines whether or not the attention table is in use or reserved. Specifically, the control unit 21 determines whether or not the table of interest is in use or reserved based on the table usage status information (not shown) stored in the storage unit 22. The table usage status information is updated in real time according to a change in the usage status of each table, for example, in response to a user operation on the operation display unit 33 of the store terminal 3. Then, when it is determined that the attention table is in use or reserved (S53: Yes), the process proceeds to step S54. On the other hand, when it is determined that the attention table is neither in use nor reserved (S53: No), the process proceeds to step S55.

<Step S54>
In step S54, the control unit 21 sets the attention table as a “non-assignable table”. Then, the process proceeds to step S59.

<Step S55>
In step S55, the control unit 21 (derivation processing unit 212) derives the predicted table unit price when the user group indicated by the user group information is assigned to the attention table. Since the method for deriving the unit price of the prediction table is the same as that in step S25 (FIG. 7), description thereof will be omitted here.

<Step S56>
In step S56, the control unit 21 (derivation processing unit 212) derives the average table unit price of the attention table. Since the method for deriving the average table unit price is the same as that in step S26 (FIG. 7), description thereof will be omitted here.

<Step S57>
In step S57, the control unit 21 calculates the unit price ratio based on the average table unit price derived in step S56 and the predicted table unit price derived in step S55, and the unit price ratio is the threshold value A. Determine if it is less than (eg, 70%). Then, when it is determined that the unit price ratio is smaller than the threshold value A (S57: Yes), the process proceeds to step S59. On the other hand, when it is determined that the number ratio is equal to or greater than the threshold value A (S57: No), the process proceeds to step S58. The control unit 21 may change the value of the threshold value A in the step S27 (FIG. 7) and the step S57. For example, the control unit 21 may make the value of the threshold value A used in the step S57 lower than the value of the threshold value A used in the step S27. This is because tables that are not currently in use are likely to remain vacant, so even if the unit price ratio is low, it is more likely to assign a user group that corresponds to the user group information. This is because there is a high possibility that sales or profits can be expected.

<Step S58>
In step S58, the control unit 21 calculates the number-of-person ratio for the attention table and determines whether or not the number-of-person ratio is smaller than the threshold value B (for example, 50%). Then, when it is determined that the number ratio is smaller than the threshold value B (S58: Yes), the process proceeds to step S59. On the other hand, when it is determined that the number ratio is equal to or greater than the threshold value B (S58: No), the process proceeds to step S60. The control unit 21 may change the value of the threshold value B in the step S28 (FIG. 7) and the step S58. For example, the control unit 21 may make the value of the threshold value B used in the step S58 lower than the value of the threshold value B used in the step S28. This is because tables that are not currently in use are likely to remain vacant, so even if the number ratio is low, it is more likely to assign a user group that corresponds to the user group information. This is because there is a high possibility that sales or profits can be expected.

<Step S59>
In step S59, the control unit 21 sets the attention table as the “recommended securing table”. Then, the process proceeds to step S60. Of the tables that can be assigned to the user group corresponding to the user group information, it is better to reserve the "reserved recommended table" for another user group without allocating the user group. It is a table where more sales or profits are expected.

<Step S60>
In step S60, the control unit 21 selects as the attention table among the plurality of tables installed in the restaurant (here, seven tables from the table A to the private room table G as shown in FIG. 3). Determine if there are any tables that are not. Then, when it is determined that there is a table that has not been selected as the table of interest (S60: Yes), the process returns to step S52. On the other hand, if it is determined that there is no table that has not been selected as the table of interest (S60: No), the process proceeds to step S61.

<Step S61>
In step S61, the control unit 21 (selection processing unit 214) selects a table to be assigned to the user group corresponding to the user group information as a “assignment recommended table”. For example, the control unit 21 selects the table having the highest predicted table unit price as the “allocation recommended table” among the tables that are not set in the “non-assignable table” or the “reserved recommended table”. Then, the control unit 21 sets a table other than the “unassignable table”, the “recommended allocation table”, and the “recommended allocation table” as the “empty table”.

<Step S62>
In step S62, the control unit 21 displays a plurality of table selection keys K22 to K28 corresponding to the plurality of tables installed in the restaurant in the usage status area A25 on the second seat allocation support page P22. Then, the control unit 21 makes each display mode of the table selection keys K22 to K28 different according to the usage status of the corresponding table. For example, the control unit 21 displays the table selection keys (here, table selection keys K23 and K24) corresponding to the table set as the “empty table” in step S61 in the first display mode (for example, a white background color). Display with. Further, the control unit 21 displays the table selection key (here, the table selection key K28) corresponding to the table set in the “recommended securing table” in step S59 in the second display mode (for example, a light gray background color). Display with. Further, the control unit 21 displays the table selection keys (here, table selection keys K22, K26, K27) corresponding to the table set in the “unassignable table” in step S54 in a third display mode (for example, dark gray). The background color of) is displayed. Further, the control unit 21 displays the table selection key (here, the table selection key K25) corresponding to the table set in the “assignment recommendation table” in step S61 in the fourth display mode (for example, a light red background color). Display with.

<Step S63>
In step S63, the control unit 21 (derivation processing unit 212) derives the prediction information for each predetermined table type in the same manner as in step S33 (FIG. 7). For example, the control unit 21 derives the predicted order number, the average order number, the predicted table unit price, and the average table unit price for each predetermined table type.

<Step S64>
In step S64, the control unit 21 (presentation processing unit 213) displays the derivation result in step S63 as the prediction information in the prediction information area A26 on the second seating support page P22. Then, the process proceeds to step S71 of FIG.

<Step S71>
In step S71, the control unit 21 determines whether or not any of the plurality of tables installed in the restaurant has been selected. Specifically, the control unit 21 operates the table when any of the plurality of table selection keys K22 to K28 displayed in the usage status area A25 on the second seat allocation support page P22 is operated. It is determined that the table corresponding to the selection key has been selected. However, in the present embodiment, the operation for the table selection key corresponding to the "unassignable table" is not accepted, and only the operation for the table selection key corresponding to the "empty table" or the "recommended reservation table" is accepted. .. Then, when it is determined that any of the tables has been selected (S71: Yes), the process proceeds to step S72. On the other hand, if it is determined that none of the tables has been selected (S71: No), the process of step S71 is repeated until it is determined that any of the tables has been selected.

<Step S72>
In step S72, the control unit 21 (derivation processing unit 212) derives the prediction information regarding the selected table. For example, the control unit 21 derives the predicted order number, the average order number, the predicted table unit price, and the average table unit price of the selected table. As for the forecast table unit price and the average table unit price, the forecast table unit price and the average table unit price derived in step S55 and step S56 may be diverted.

<Step S73>
In step S73, the control unit 21 (presentation processing unit 213) displays the allocation confirmation page P32 corresponding to the selected table (here, table D) on the operation display unit 33 of the store terminal 3, as shown in FIG. To display. On the allocation confirmation page P32, the capacity and seat type of the selected table are displayed based on the table information D2 stored in the storage unit 22. Further, on the allocation confirmation page P32, the prediction information derived in step S72 is displayed.

The allocation confirmation page P32 includes an allocation key K33 and a cancel key K34. The allocation key K33 is an operation key for assigning a user group related to the user group information to the selected table. The cancel key K34 is an operation key for closing the allocation confirmation page P32.

The restaurant manager appropriately determines to which table the user group should be assigned by referring to the information displayed on the allocation confirmation page P32, the information displayed in the prediction information area A26, and the like. Is possible.

In this embodiment, even when the table selection key corresponding to the table set in the “recommended reservation table” (here, the table selection key K28 corresponding to the private room table F) is operated, the allocation confirmation page P32. Is displayed. Therefore, in the present embodiment, the restaurant manager can also assign the user group indicated by the user group information to the table set in the "securing recommended table", if necessary. However, in other embodiments, the allocation confirmation page P32 may be displayed only when the table selection key corresponding to the table set in the "allocation recommended table" or the "empty table" is operated. As a result, it is possible to prevent the user group indicated by the user group information from being erroneously assigned to the table set in the "recommended reservation table".

<Step S74>
In step S74, the control unit 21 determines whether or not the allocation operation has been performed. Specifically, the control unit 21 determines that the allocation operation has been performed when the allocation key K33 included in the allocation confirmation page P32 is operated. Then, when it is determined that the allocation operation has been performed (S74: Yes), the process proceeds to step S77. On the other hand, if it is determined that the allocation operation has not been performed (S74: No), the process proceeds to step S75.

<Step S75>
In step S75, the control unit 21 determines whether or not the cancel operation has been performed. Specifically, the control unit 21 determines that the cancel operation has been performed when the cancel key K34 included in the allocation confirmation page P32 is operated. Then, when it is determined that the cancel operation has been performed (S75: Yes), the process proceeds to step S76. On the other hand, if it is determined that the cancel operation has not been performed (S75: No), the process returns to the step S74.

<Step S76>
In step S76, the control unit 21 closes the allocation confirmation page P32. Then, the process returns to the step S71.

<Step S77>
In step S77, the control unit 21 executes the allocation process. In the allocation process, the user group information and information about the selected table are registered in the table usage status information (not shown).

<Step S78>
In step S78, the control unit 21 (advice processing unit 215) causes the operation display unit 33 of the store terminal 3 to display the advice page P4 as shown in FIG. On the advice page P4, for example, the maximum value of the predicted number of orders when the user group indicated by the user group information is assigned to a table different from the actually assigned table (here, table D) is displayed. Displayed as the target number of orders. While comparing the target number of orders with the current number of orders, the restaurant employee cleans up the empty dishes and places an additional order to the user group so that the number of orders close to the target number of orders can be obtained. Can be prompted. Then, the walk-in process is completed.

As described above, in the seat allocation support device 2 according to the present embodiment, profitability or profitability when a specific type of user group uses a specific table or a specific type of table based on the history information D4. An index indicating is derived. For example, for each table or table type, the estimated number of orders and the estimated table unit price when a user group who wants to use the restaurant is assigned to the table are derived. Therefore, according to the seat allocation support device 2 according to the present embodiment, it is possible to support the determination of which table the user group of a specific type should be assigned to.

[Modification example]
In the present embodiment, a new reservation is accepted when the reservation registration key K31 (FIG. 13) is operated by the restaurant manager, but the present invention is not limited to this. In another embodiment, when a new reservation is applied to the seat allocation support device 2 from the user terminal 4, the control unit 21 (reservation processing unit 216) automatically determines whether or not to accept the new reservation. The new reservation may be automatically accepted or rejected. For example, the control unit 21 may automatically accept a new reservation from the user group when there is a "vacant table" or an "allocation recommended table" whose capacity is equal to or greater than the number of users in the user group. .. At this time, the control unit 21 may automatically allocate the user group to the optimum table (for example, the table having the highest predicted group unit price) among the "vacant table" or the "allocation recommended table". Good. Further, the control unit 21 does not have a "vacant table" or an "allocation recommended table" whose capacity is equal to or greater than the number of users in the user group, and only has a "reserved recommended table" having a capacity equal to or greater than the number of users in the user group. If it does not exist, new reservations from the user group may be automatically rejected. As a result, it is possible to save the user the trouble of accepting and rejecting new reservations. Further, as a result, the restaurant manager does not need to operate the store terminal 3 in order to accept and reject new reservations, so that the communication traffic between the store terminal 3 and the seat allocation support device 2 is reduced. And the computer resources of the store terminal 3 can be effectively used.

Further, in another embodiment, the value of the threshold value A used in step S27 of FIG. 7 or step S57 of FIG. 9 depends on the busyness of the store visit date and time (current date and time in the case of walk-in) indicated by the user group information. May be changed automatically. For example, when the store visit date and time is a busy time (for example, the time zone from 17:00 to 21:00 on Friday), the control unit 21 sets the value of the threshold value A higher than usual, and the store visit date and time is quiet. When the time is (for example, the time zone from 14:00 to 17:00 from Monday to Thursday), the value of the threshold value A may be lower than usual. Similarly, the value of the threshold value B used in step S28 of FIG. 7 or step S58 of FIG. 9 is automatically changed according to the busyness of the store visit date and time (current date and time in the case of walk-in) indicated by the user group information. May be done. For example, when the store visit date and time is a busy time (for example, the time zone from 17:00 to 21:00 on Friday), the control unit 21 sets the value of the threshold value B higher than usual, and the store visit date and time is quiet. When the time is (for example, the time zone from 14:00 to 17:00 from Monday to Thursday), the value of the threshold value B may be lower than usual. As a result, the more users are expected to visit the store, the easier it is for more tables to be set as "recommended secure tables". Therefore, further improvement in restaurant profits or profits can be expected.

1 Seat allocation support system 2 Seat allocation support device 21 Control unit 211 Acquisition processing unit 212 Derivation processing unit 213 Presentation processing unit 214 Selection processing unit 215 Advice processing unit 216 Reservation processing unit 22 Storage unit 23 Operation display unit 24 Communication I / F
3 Store terminal 4 User terminal

Claims (13)

An acquisition processing unit that acquires history information including information on each type of user group that has used restaurants in the past, information on tables used, and information on food and drink ordered.
Information on at least the number of people, information on the food and drink, and information on the price, cost, or profit of the food and drink included in the history information about the specific table or the user group of the specific type using the table of the specific type. Based on the above, each table to which the index indicating profitability or profitability when the specific type of user group uses the specific table or the specific type of table can be assigned to the specific type of user group. Derivation processing unit to derive about
A presentation processing unit that presents the index derived by the derivation processing unit for each table, and a presentation processing unit.
Seat allocation support device equipped with. An acquisition processing unit that acquires history information including information on each type of user group that has used restaurants in the past, information on tables used, and information on food and drink ordered.
Information on at least the number of people, information on the food and drink, and information on the price, cost, or profit of the food and drink included in the history information about the specific table or the user group of the specific type using the table of the specific type. Based on the above, each table to which the index indicating profitability or profitability when the specific type of user group uses the specific table or the specific type of table can be assigned to the specific type of user group. Derivation processing unit to derive about
A selection processing unit that selects a table to be assigned to the specific type of user group based on the index for each table.
Seat allocation support device equipped with. The selection processing unit selects a table to be assigned to the specific type of user group based on the predicted group unit price for each table and the ratio of the number of people in the user group to the capacity of the table.
The seat allocation support device according to claim 2 . The history information includes information on the date of use or the date and time of use.
The derivation processing unit uses the specific table or the specific type table on the usage date or the usage date and time in which at least one of the month, the date, the day of the week, and the time zone is common to the specific date or the specific date and time. Based on the history information about the user group, the index when the user group of the specific type uses the specific table or the table of the specific type on the specific day or the specific date and time is derived.
The seat allocation support device according to any one of claims 1 to 3 . An advice processing unit that presents advice information according to the index derived by the derivation processing unit is further provided.
The seat allocation support device according to any one of claims 1 to 4 . Whether or not to accept new reservations from the specific type of user group who wishes to use the restaurant on a specific date or a specific date and time based on the index derived by the derivation processing unit. Further provided with a reservation processing unit for determining
The seat allocation support device according to any one of claims 1 to 5 . The indicators include forecast group unit prices
The reservation processing unit has the predicted group unit price for each table and the past average group unit price for each table for all the tables available to the user group of the specific type on the specific day or the specific date and time. If a specific condition is met, it is determined that new reservations from the user group should not be accepted.
The seat allocation support device according to claim 6 . The reservation processing unit presents advice information according to the determination result.
The seat allocation support device according to claim 6 or 7 . The reservation processing unit accepts a new reservation from the user group when the determination result is positive, and makes a new reservation from the user group when the determination result is negative. Not accepted
The seat allocation support device according to claim 7 or 8 . For one or more processors
To acquire history information including information on each type of user group who used the restaurant in the past, information on the table used, and information on the food and drink ordered.
Information on at least the number of people, information on the food and drink, and information on the price, cost, or profit of the food and drink included in the history information about the specific table or the user group of the specific type using the table of the specific type. Based on the above, each table to which the index indicating profitability or profitability when the specific type of user group uses the specific table or the specific type of table can be assigned to the specific type of user group. It is derived for,
The index is presented for each table.
Seat allocation support program. For one or more processors
To acquire history information including information on each type of user group who used the restaurant in the past, information on the table used, and information on the food and drink ordered.
Information on at least the number of people, information on the food and drink, and information on the price, cost, or profit of the food and drink included in the history information about the specific table or the user group of the specific type using the table of the specific type. Based on the above, each table to which the index indicating profitability or profitability when the specific type of user group uses the specific table or the specific type of table can be assigned to the specific type of user group. To derive about
Based on the index for each table, the table to be assigned to the specific type of user group is selected.
Seat allocation support program. By one or more processors
Obtain history information including information on each type of user group that used restaurants in the past, information on tables used, and information on food and drink ordered.
Information on at least the number of people, information on the food and drink, and information on the price, cost, or profit of the food and drink included in the history information about the specific table or the user group of the specific type using the table of the specific type. Based on the above, each table to which the index indicating profitability or profitability when the specific type of user group uses the specific table or the specific type of table can be assigned to the specific type of user group. derived for,
The index is presented for each table.
Seating support method. By one or more processors
Obtain history information including information on each type of user group that used restaurants in the past, information on tables used, and information on food and drink ordered.
Information on at least the number of people, information on the food and drink, and information on the price, cost, or profit of the food and drink included in the history information about the specific table or the user group of the specific type using the table of the specific type. Based on the above, each table to which the index indicating profitability or profitability when the specific type of user group uses the specific table or the specific type of table can be assigned to the specific type of user group. Derived about
A table to be assigned to the specific type of user group is selected based on the index for each table.
Seating support method.

Images