JP2019082796A - Seating allocation support device and seating allocation support program and seating allocation support method - Google Patents

Abstract

To provide a seating allocation support device, a seating allocation support program, and a seating allocation support method that are capable of assisting determination which table should be allocated to a specific kind of user groups.SOLUTION: A seating allocation support device comprises an acquisition processing unit acquiring history information containing kind information for each user group that has used a restaurant in the past, information regarding a table that each user group used, and information on drink and food that each user group ordered and a derivation processing unit deriving an index indicating a profit or profitability when a specific kind of user groups uses a specific table or a specific kind of tables on the basis of the history information.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a placement assistance device, placement assistance program, and placement assistance method for supporting placement operations.

  Generally, when allocating group customers to a restaurant table, it is considered that allocating group customers as many as possible to the capacity set for each table leads to improvement in restaurant earnings. Therefore, the minimum number of persons may be set for each table, for example, at least three persons are allocated to the four-person table (see, for example, Patent Document 1).

JP, 2006-313472, A

  By the way, in the case where one table is allocated to a two-person group in a state in which the two-person table and the four-person table are open, the table utilization efficiency is higher if the two-person table is allocated. However, it is more comfortable for the two-man group to eat at the large four-person table, and the table does not overflow even when ordering a large number of food items at once. Therefore, it is possible for sales to be higher if a four-person table is assigned.

  An object of the present invention is to provide a placement support device, a placement support program, and a placement support method capable of supporting determination of which table a user group of a specific type should be assigned to.

  The placement support apparatus according to the present invention includes an acquisition processing unit that acquires history information including information on the type of each user group using a restaurant in the past, information on a table used, and information on ordered food and drink And a derivation processing unit that derives an index indicating profitability or profitability when a user group of a specific type uses a specific table or a specific type of table based on the history information.

  The placement support program according to the present invention includes history information including, in one or more processors, information on the type of each user group who has used the restaurant in the past, information on the table used, and information on the ordered food And an index indicating the 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.

  According to the present invention and the arrangement support method, history information including information on the type of each user group who 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 indicating the 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 are provided a placement support device, a placement support program, and a placement support method capable of supporting determination of which table a user group of a specific type should be allocated to.

FIG. 1 is a block diagram showing a configuration of a seating assistance system according to an embodiment of the present invention. FIG. 2 is a diagram showing an example of user information used in the seating assistance system according to the embodiment of the present invention. FIG. 3 is a diagram showing an example of table information used in the seating assistance system according to the embodiment of the present invention. FIG. 4 is a diagram showing an example of reservation information used in the seating assistance system according to the embodiment of the present invention. FIG. 5 is a diagram showing an example of history information used in the seating assistance system according to the embodiment of the present invention. FIG. 6 is a flowchart showing an example of the procedure of the seating assistance process performed by the seating assistance device in the seating assistance system according to the embodiment of the present invention. FIG. 7 is a flow chart showing an example of the procedure of a new reservation process executed by the seating arrangement support apparatus in the seating arrangement support system according to the embodiment of the present invention. FIG. 8 is a flow chart showing an example of the procedure of a new reservation process executed by the seating arrangement support apparatus in the seating arrangement support system according to the embodiment of the present invention. FIG. 9 is a flowchart showing an example of the procedure of the walk-in process performed by the seating arrangement support apparatus in the seating arrangement support system according to the embodiment of the present invention. FIG. 10 is a flowchart showing an example of the procedure of the walk-in process performed by the seating arrangement support apparatus in the seating arrangement support system according to the embodiment of the present invention. FIG. 11 is a view showing an example of a user group information input page displayed on the shop terminal in the seating assistance system according to the embodiment of the present invention. FIG. 12 is a diagram showing an example of a first placement assistance page displayed on the shop terminal in the placement assistance system according to the embodiment of the present invention. FIG. 13 is a view showing an example of a reservation registration confirmation page displayed on the shop terminal in the seating assistance system according to the embodiment of the present invention. FIG. 14 is a diagram showing an example of a second placement assistance page displayed on the shop terminal in the placement assistance system according to the embodiment of the present invention. FIG. 15 is a view showing an example of an allocation confirmation page displayed on the shop terminal in the seating assistance system according to the embodiment of the present invention. FIG. 16 is a diagram showing an example of an advice page displayed on the shop terminal in the seating assistance 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 understanding of the present invention. The following embodiments are merely specific examples of the present invention, and do not limit the technical scope of the present invention.

[Allocation Support System 1]
As shown in FIG. 1, the seating assistance system 1 according to the embodiment of the present invention includes a seating assistance device 2, one or more shop terminals 3, and one or more user terminals 4. The seating assistance device 2 and the shop terminal 3 can communicate via the communication network N1 such as the Internet, a LAN, a WAN, or a public telephone line. The same applies to the seating assistance device 2 and the user terminal 4.

  The seating arrangement support device 2 is a device for supporting a seating arrangement task of allocating a table to a user group using a restaurant. The store terminal 3 is an information processing device operated by a restaurant manager. The user terminal 4 is an information processing device operated by the user of the restaurant.

[Allocation Support Device 2]
As illustrated in FIG. 1, the placement assistance 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 placement assistance device 2 is not limited to one computer, and may be a computer system in which a plurality of computers operate in cooperation. In addition, various processes executed by the seating assistance device 2 may be distributed and executed by one or more processors.

  The communication I / F 24 connects the placement support device 2 to the communication network N1 by wire or wirelessly, and makes a predetermined communication protocol with external devices such as the shop terminal 3 and the user terminal 4 via the communication network N1. It is a communication interface for executing the compliant 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 types of information, and an operation unit such as a mouse, a keyboard, or a touch panel that receives an operation.

  The storage unit 22 is a non-volatile storage unit such as a hard disk drive (HDD) or a solid state drive (SSD) that stores various types of information. Specifically, the storage unit 22 stores data such as user information D1, table information D2, reservation information D3, and history information D4. Here, FIG. 2 is a view showing an example of the user information D1. FIG. 3 is a view showing an example of the table information D2. FIG. 4 is a diagram showing an example of the reservation information D3. FIG. 5 is a diagram showing an example of the history information D4.

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

  Table information D2, reservation information D3, and history information D4 are stored for each store. Below, table information D2 about store A, reservation information D3, and history information D4 are explained.

  As shown in FIG. 3, the table information D2 includes information such as 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 the type of seat of the table (chair, seat, etc.).

  As shown in FIG. 4, the reservation information D3 includes a visit date, visit time, number of persons, a table, a reservation date, member configuration, corresponding to each user group who has reserved a restaurant (here, store A). It includes information such as usage purpose. The utilization date is a date when the user group comes to the restaurant. The visit time is the time when the user group visits the restaurant. The number of people is the number of people of the user group. The table is a table assigned to the user group. The reservation date is a date when a reservation of the user group is accepted. The member configuration is information on a member configuration of the user group (a user group including elderly people, a user group including infants, couples, children, etc.). The use purpose indicates the purpose (entertainment, banquet, anniversary, etc.) for the user group to use the restaurant. The member configuration and the information on the purpose of use may be input by a representative of the user group at the time of application for reservation of the user group, or management of the restaurant when the reservation of the user group is accepted It may be input by the person or the employee. The reservation information D3 additionally 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 courses of food and drink to be provided to the user group. It may be

  In the reservation information D3, whenever a new reservation is accepted, information on the reservation is registered as needed. In addition, the reservation information D3 is updated as needed each time a change in the content of the registered reservation (for example, visit date, visit time, number of people, etc.) is accepted.

  As shown in FIG. 5, in the history information D4, the usage date, usage time, number of people, table, member configuration, usage purpose, number of orders corresponding to each user group using the restaurant (here, store A) And information such as table prices. The use date is a date when the user group uses the restaurant. The use time is a time (use start time) when the user group uses the restaurant. The number of people is the number of people of the user group. The table is a table assigned to the user group. The member configuration is information on a member configuration of the user group (a user group including elderly people, a user group including infants, couples, children, etc.). The use purpose indicates the purpose (entertainment, banquet, anniversary, etc.) for the user group to use the restaurant. The order number is the number of food and drink ordered by the user group at the restaurant. The order number may be the number of orders excluding the drink (ie, the number of order food). The table unit price is a charge paid to the restaurant by the user group. 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 the information such as the user information D1, the table information D2, the reservation information D3, and the history information D4 is stored in a server that can be accessed from the seating support device 2. Is also conceivable. And the control part 21 of the arrangement | positioning assistance apparatus 2 may acquire various information from the said server, and may perform each process of the arrangement | positioning assistance process (refer FIGS. 6-10) of below-mentioned.

  The storage unit 22 further includes a user group information input page P1 (see FIG. 11), a first placement support page P21 (see FIG. 12), a reservation registration confirmation page P31 (see FIG. 13), and a second distribution. Data such as the seat support page P22 (see FIG. 14), the assignment confirmation page P32 (see FIG. 15), and the advice page P4 (see FIG. 16) are also stored.

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

  The control unit 21 includes 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 kinds of arithmetic processing 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 (work area) of various types of processing executed by the CPU. The control unit 21 controls the placement support device 2 by the CPU executing various control programs stored in advance in the ROM or the storage unit 22.

  By the way, in a restaurant, in the case where one table is allocated to a two-person group in a state in which the two-person table and the four-person table are open, the table utilization efficiency is higher if the two-person table is allocated. However, it is more comfortable for the two-man group to eat at the large four-person table, and the table does not overflow even when ordering a large number of food items at once. Therefore, it is possible for sales to be higher if a four-person table is assigned. With the arrangement support system 1 according to the present embodiment, it is possible to support the determination of which table the user group of the 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 units 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 a processing unit. The control unit 21 functions as the processing unit by the CPU executing various processing according to the seating assistance program. In addition, part or all of the processing units may be configured by an electronic circuit. The placement assistance program may be a program for causing a plurality of processors to function as the processing unit.

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

  The derivation processing unit 212 is, based on the history information D4 acquired by the acquisition processing unit 211, an index indicating profitability or profitability when the user group of the specific type uses the specific table or the specific type of table. To derive. In addition, indicators indicating profitability are, for example, predicted profit and average profit. Further, the index indicating the profitability is, for example, the number of predicted orders, the prediction table unit price (predicted 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 number of predicted orders or the prediction table unit price when a specific type of user group (for example, a two-person group) uses a specific table (for example, a private room table E). Good (see Figure 13). Further, the derivation processing unit 212 determines the number of predicted orders or the prediction table unit price when the user group of a specific type (for example, a two-person group) uses a table of a specific type (for example, a four-person table of chair types). An indicator may be derived (see FIG. 12).

  The information of the type of the user group may be input through the operation display unit 33 of the shop 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 of the type of the user group may be input through the operation display unit 43 of the user terminal 4. That is, the information of 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, based on the history information D4, the profitability or profitability when the user group of a specific type uses the specific table or the specific type table on a specific date or a specific date and time. An indicator may be derived. For example, the derivation processing unit 212 may use the specific table or the specific type table as a use date or use date and time in which at least one of a month, a date, a day of the week, and a time zone share a specific date or a specific date and time. The index may be derived based on the history information D4 on the type of user group. In a typical restaurant, the number of orders and the table price largely change depending on the time zone and the day of the week. For example, the dinner time may have more orders and table prices than the lunch time. Also, the number of orders and table prices may increase over Friday's dinner time zones over Wednesday's dinner time zones. In such a case, the derivation processing unit 212 uses the specific type using the specific table or the specific type table as the use date or use date and time when the day of the week and the time zone share the same as the specific date or the specific date and time. The index may be derived based on the history information D4 on the group of persons. Thus, the derivation processing unit 212 can derive an index with higher accuracy.

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

  The derivation processing unit 212 may derive the index for each of the tables 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 of the tables (see FIG. 13 or 15).

  The selection processing unit 214 selects a table to be allocated 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 allocated to the user group of the specific type based on the predicted group unit price for each table and the ratio of the number of the user group to the capacity of the table. For example, the selection processing unit 214 selects the table with the highest prediction unit price among the tables excluding the “reserved table”, the “not allocatable table”, and the “recommended recommended table” to be described later. It may be selected as a table to be assigned to a group (ie, an “allocation recommendation table” described later). In addition, it is predicted that more sales or profit can be expected if the “recommendation recommendation table” is reserved for another user group without allocating the specific type of user group. It is. The “recommended recommendation table” is, for example, a unit price ratio (that is, the ratio of the forecast table unit price to the average table unit price of the table) is a predetermined threshold A or more, and the number ratio (that is, The ratio of the number of people) is a table having a predetermined threshold B or more.

  The advice processing unit 215 presents advice information corresponding to the index derived by the derivation processing unit 212. For example, the advice processing unit 215 transmits advice information corresponding to the index to the shop terminal 3 through the communication I / F 24, and displays the advice information (for example, the target order number etc.) on the operation display unit 33 of the shop terminal 3. (See FIG. 16). Further, the advice processing unit 215 may provide advice information according to the difference of the index between the tables (for example, “when allocating a two-person table, the number of predicted order hoods is one compared to when allocating a four-person table. Because it will be reduced, we will present a message such as "Let's do our best to order one extra item."

  The reservation processing unit 216, based on the index derived by the derivation processing unit 212, makes a new reservation from the user group of the specific type who desires to use the restaurant on a specific date or a specific date and time. It is determined whether or not it should be accepted. For example, the reservation processing unit 216 specifies the predicted group unit price for each of the tables and the past average group unit price for each of the tables for all the tables available to the user group on the specific date or the specific date and time. When the condition is satisfied, it may be determined that the new reservation 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 prediction 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. When it is less than the threshold B, it may be determined that a new reservation from the user group should not be accepted. Alternatively, when the average table unit price is higher by a predetermined value or more than the prediction table unit price for all the tables available to the user group on the specific date or the specific date and time, the reservation processing unit 216 may use the user It may be determined that a new reservation from a 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 to accept a new reservation from the user group to the shop terminal 3 through the communication I / F 24, and the message is displayed on the operation display unit 33 of the shop 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 illustrated 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 "secured recommended tables", and two user groups are displayed as the private room table F and It indicates that it should not be allocated to the private room table G. When the display mode of all the table selection keys is a display mode indicating the "reserved table" or the "recommended recommended table", the display means that the new reservation from the user group should not be accepted.

  Further, when the determination result is affirmative, the reservation processing unit 216 accepts a new reservation from the user group, and when the determination result is negative, a new process from the user group is performed. The reservation may not be accepted (ie, rejected). As a result, since acceptance and rejection of a new reservation are automatically performed by the reservation processing unit 216, it is possible to save time and effort of the user associated with acceptance and rejection of a new reservation.

[Store terminal 3]
As shown in FIG. 1, the shop 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 apparatus such as a mobile phone, a smartphone, a tablet terminal, or a personal computer, for example.

  Specifically, the manager of the restaurant logs in to the arrangement support device 2 by inputting the user ID and the password on the predetermined login page displayed on the shop terminal 3, and the management page of the restaurant of the restaurant is displayed. 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 user group information. The user group information is information on a user group who desires to use the restaurant. For example, when the administrator receives an application for a new reservation from a user by telephone, the administrator can call up the user group information input page P1 and input the user group information. In addition, when the user group visits the store (so-called walk-in) without making a reservation, the administrator can call up the user group information input page P1 and input the user group information. Data of the user group information input page P1 (for example, a web page described in HTML) is transmitted from the placement support device 2 to the shop terminal 3.

  The communication I / F 34 connects the shop terminal 3 to the communication network N1 by wire or wireless, and performs data communication according to a predetermined communication protocol with an external device such as the seating arrangement support apparatus 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, a keyboard, or a touch panel that receives an operation.

  The storage unit 32 is a non-volatile storage unit such as a hard disk drive (HDD), a solid state drive (SSD), or a flash memory that stores various types of information. For example, the storage unit 32 stores a control program such as a browser program. 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 in accordance with a communication protocol such as HTTP (Hypertext Transfer Protocol).

  The control unit 31 includes 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 a control program such as a BIOS and an OS for causing the CPU to execute various processes is 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 (work area) of various types of processing executed by the CPU. Then, the control unit 31 controls the shop terminal 3 by executing various control programs stored in advance in the ROM or the storage unit 32 by the CPU.

  Specifically, the control unit 31 functions as a browser processing unit 311 by executing various processes according to the browser program stored in the storage unit 32. The browser processing unit 311 causes the operation display unit 33 to display a web page provided from the placement support device 2 via the communication network N1, and performs browser processing for inputting an operation on the operation display unit 33 into the placement support device 2. It is possible to carry out. A part or all of the processing units included in the control unit 31 may be configured by an electronic circuit.

[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 apparatus such as a mobile phone, a smartphone, a tablet terminal, or a personal computer, for example.

  Specifically, the user of the restaurant acquires the data of the search page (not shown) from the seating arrangement support device 2 by inputting a predetermined URL at the user terminal 4 and the operation display unit 33 Display the search page. Then, the user searches for restaurants meeting the desired conditions (for example, restaurants available to a group of a desired number of people at a desired date and time), and desired among the restaurants presented as a search result The following restaurants can be selected to apply for a new reservation for the restaurant. When the user applies for a new reservation for a specific restaurant, information such as visit date, visit time, number of visitors, etc. is notified as the user group information to the manager of the restaurant. Alternatively, the user group information may be recorded in the storage unit 22 of the seating arrangement support device 2 and may be referred to from the shop terminal 3 as appropriate.

  The communication I / F 44 connects the user terminal 4 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 seating assistance 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, a keyboard, or a touch panel that receives an operation.

  The storage unit 42 is a non-volatile storage unit such as a hard disk drive (HDD), a solid state drive (SSD), or a flash memory that stores various types of information. For example, the storage unit 42 stores a control program such as a browser program. 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 in accordance with a communication protocol such as HTTP (Hypertext Transfer Protocol).

  The control unit 41 includes 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 a control program such as a BIOS and an OS for causing the CPU to execute various processes is 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 (work area) of various types of processing executed by the CPU. Then, the control unit 41 controls the user terminal 4 by the CPU executing various control programs stored in advance in the ROM or the storage unit 42.

  Specifically, the control unit 41 functions as a browser processing unit 411 by executing various processes according to the browser program stored in the storage unit 42. The browser processing unit 411 causes the operation display unit 43 to display a web page provided from the placement assistance device 2 via the communication network N1, and performs browser processing for inputting an operation on the operation display unit 43 to the placement assistance device 2 It is possible to carry out. A part or all of the processing units included in the control unit 41 may be configured by an electronic circuit.

[Allocation support processing]
Hereinafter, the seating arrangement support processing executed by the control unit 21 of the seating arrangement support apparatus 2 will be described with reference to FIGS. 6 to 10.

  The present invention can be understood as an invention of a method of arranging placement assistance that executes one or more steps included in the arrangement placement assistance processing, and one or more included in the arrangement placement assistance processing described here. The steps may be omitted as appropriate. Note that the execution order of the steps in the placement support process may be different as long as the same effects are obtained. Furthermore, although the case where each step in the arrangement support process is executed by the control unit 21 will be described as an example here, distribution of each step in the arrangement support process is performed by a plurality of processors in a distributed manner. A seat support method is also conceivable as another embodiment.

  The seating assistance process may be terminated at an arbitrary timing in accordance with a specific operation (for example, an operation of an end button (not shown)) by the user.

<Step S11>
First, in step S11, the control unit 21 causes the operation display unit 33 of the shop terminal 3 to display a 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 shop terminal 3 in accordance with the user operation on the operation display unit 33 of the shop terminal 3. As a result, the user group information input page P1 is displayed on the operation display unit 33 of the shop 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 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. It is an operation key for selecting it. 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 entry field B11 is an entry field for entering the visit date of the user group applying for a new reservation, and the entry field B12 is an entry field for entering the visit time of the user group.

  The input field B13 is an input field for inputting the number of the user group. The input field B14 is an input field for inputting the member configuration (for example, couple, infants, children with children, elderly people, etc.) of the user group. The input field B14 is an input field for inputting the purpose of use of the user group (for example, an anniversary, a banquet, a business reception, etc.). The input field B14 and the input field B15 may be omitted.

<Step S12>
In step S12, the control unit 21 acquires 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 selection state of the radio buttons R11 and R12 at that time, and the input fields B11 to B15. Acquire the contents input to the user group information.

  In another embodiment, instead of acquiring the user group information through the user group information input page P1, the control unit 21 applies for a new reservation from the user terminal 4 to the placement support device 2 The user group information recorded in the storage unit 22 of the seating support device 2 when it is performed may be acquired from the storage unit 22.

<Step S13>
In step S13, the control unit 21 determines whether the user group information acquired in step S12 is user group information corresponding to a 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 user group information corresponding to a new reservation. Then, when it is determined that the user group information is user group information corresponding to a new reservation (S13: Yes), the process goes 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. Details of the new reservation process will be described later. When the new reservation process ends, the placement assistance process ends.

<Step S15>
In step S15, the control unit 21 executes a walk-in process. Details of the walk-in process will be described later. When the walk-in process ends, the placement support process ends.

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

<Step S21>
In step S21, the control unit 21 causes the operation display unit 33 of the shop terminal 3 to display a first placement assistance page P21 as shown in FIG. Specifically, the control unit 21 transmits data of the first placement assistance page P21 to the shop terminal 3. As a result, the first placement assistance page P21 is displayed on the operation display unit 33 of the shop terminal 3. In addition, although the user group information area A21, the reservation status area A22, and the prediction information area A23 are included in the first placement support page P21, in the state immediately after being displayed in the step S21, the user is 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 area A21 displays the user group information. 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 placement assistance page P21 is closed, and the user group information input page P1 is displayed again.

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

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

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

<Step S23>
In step S23, the control unit 21 determines whether or not the attention table has been reserved at the visit date and time indicated by the user group information. Specifically, based on the reservation information D3 stored in the storage unit 22, the control unit 21 determines whether the attention table is reserved. Then, when it is determined that the attention table is reserved (S23: Yes), the process proceeds to step S24. On the other hand, when 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 a prediction table unit price when the user group indicated by the user group information is assigned to the attention table. Hereinafter, an example of a method of deriving the prediction table unit price 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 (the derivation processing unit 212) extracts a record that satisfies all of the following first to third conditions from among the plurality of records included in the history information D4.

(First condition)
A record in which a use date and a use time satisfy a predetermined relationship with a visit date and a 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 use date and the use time coincide with the visit day indicated by the user group information and the day and time zone corresponding to the visit time. The visit date indicated by the user group information is an example of the “specific date” in the present invention. Further, the visit date and the visit time indicated by the user group information are examples of the “specified date and time” in the present invention.

(Second condition)
A record related 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 “specific type of user group” in the present invention.

(Third condition)
Records related to the same table as the noted table. The same table as the attention table is an example of the “specific table” in the present invention.

  The control unit 21 derives a prediction 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, as the prediction table unit price, an average value of the table unit prices in the records extracted based on the first condition to the third condition. That is, the user group of the same type as the user group indicated by the user group information indicates the attention table in the past on the same day and time zone as the visit date and time indicated by the user group information. It shows the average value of table prices when used.

<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 the records satisfying the following fourth and fifth conditions from among the plurality of records included in the history information D4.

(The 4th condition)
A record in which a use date and a use time satisfy a predetermined relationship with a visit date and a 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 use date and the use time coincide with the visit day indicated by the user group information and the day and time zone corresponding to the visit time.

(Fifth condition)
Records related to the same table as the noted table.

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

<Step S27>
In step S27, the control unit 21 (reservation processing unit 216) calculates the ratio of the prediction 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 the unit price ratio is smaller than a predetermined threshold A (for example, 70%). For example, when the average table unit price is 10000 yen and the prediction table unit price is 8000 yen, the unit price ratio is 80%. When the average table unit price is 6,000 yen and the prediction table unit price is 4,000 yen, the unit price ratio is 67%. When it is determined that the unit price ratio is smaller than the threshold A (S27: Yes), the process proceeds to step S29. On the other hand, when it is determined that the workforce ratio is equal to or more than the threshold 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 users of the user group indicated by the user group information to the capacity of the attention table (hereinafter referred to as the ratio of the number of people). Is determined to be smaller than a predetermined threshold B (for example, 50%). For example, when the number of people in the table of interest is four and the number of users in the user group is two, the ratio of the number of people is 50%. When the number of people in the table of interest is eight and the number of users in the user group is two, the ratio of the number of people is 25%. Thus, the ratio of the number of people indicates the utilization efficiency of the table. When it is determined that the workforce ratio is smaller than the threshold B (S28: Yes), the process proceeds to step S29. On the other hand, when it is determined that the workforce ratio is equal to or more than the threshold 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 a "recommendation recommendation table". Then, the process proceeds to step S30. Among the unreserved tables, the “recommendation recommendation table” is more sales if it is reserved for another user group without assigning the user group corresponding to the user group information. Or it is a table predicted to be profitable.

<Step S30>
In step S30, the control unit 21 selects one of the plurality of tables installed in the restaurant (here, seven tables of the table A to the private room table G as shown in FIG. 3) as the table of interest It is determined whether there is a table that has not been set. Then, when it is determined that there is a table not selected as the attention table (S30: Yes), the process returns to the step S22. On the other hand, when it is determined that there is no table not selected as the attention table (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 allocated to the user group corresponding to the user group information as an “allocation recommendation table”. For example, the control unit 21 selects a table with the highest prediction table unit price among the tables not set in the “reserved table” or the “recommended recommended table” as the “allocation recommended table”. Then, the control unit 21 sets a table other than the “reserved table”, the “recommendation recommendation table”, and the “allocation recommendation table” as the “vacant table”.

<Step S32>
In step S32, the control unit 21 (reservation processing unit 216) sets 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 arrangement support page P21. Display Then, control unit 21 changes the display mode of each of table selection keys K22 to K28 according to the reservation status of the corresponding table. For example, the control unit 21 sets a table selection key (here, the table selection key K22 to K25) corresponding to the table set in the "vacant table" in step S31 to the first display mode (for example, white background color) Display with. In addition, the control unit 21 controls the table selection keys (here, the table selection keys K26 and K28) corresponding to the table set in the "recommendation recommendation 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, dark gray background color). Further, the control unit 21 causes the fourth display mode (for example, light red background color) of the table selection key (here, the table selection key K27) corresponding to the table set in the “allocation recommendation table” in step S31. Display with.

  Each of the table selection keys may be displayed in a different display mode according to the prediction table unit price of the corresponding table. For example, the higher the prediction table unit price of the corresponding table, the darker the background color (for example, dark red) is displayed, and the lower the prediction table unit price of the corresponding table, the lighter the background color (for example, light red) May be displayed. As a result, the manager of the restaurant can easily distinguish between a table with a high and a low forecasted 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 another embodiment, the reservation status of each table may be displayed in the form of a table.

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

  For example, the predicted number of orders for the table type of “four-person table (chair)” (ie, four-person table of chair type) 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 (the derivation processing unit 212) extracts a record that satisfies all of the following sixth to eighth conditions from among the plurality of records included in the history information D4.

(Sixth condition)
A record in which a use date and a use time satisfy a predetermined relationship with a visit date and a 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 use date and the use time coincide with the visit day indicated by the user group information and the day and time zone corresponding to the visit time.

(The seventh condition)
A record related to a user group of the same type as the user group indicated by the user group information.

(Eighth condition)
A record related 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” in 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. Deduce the number of predicted orders when assigning a table. Specifically, the control unit 21 derives, as the predicted order number, an average value of the order number in the records extracted based on the sixth condition to the eighth condition.

  Further, the average number of orders of the table type of “four-person table (chair)” is derived as follows.

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

(The 9th condition)
A record in which a use date and a use time satisfy a predetermined relationship with a visit date and a 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 use date and the use time coincide with the visit day indicated by the user group information and the day and time zone corresponding to the visit time.

(The tenth condition)
A record related 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 of the 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 record 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 result of the derivation in step S33 in the prediction information area A23 of the first placement support page P21 as the prediction information. Then, the process proceeds to step S41 in FIG.

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

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

<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 shop terminal 3 Display on section 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. In addition, 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 cancel key K32. The reservation registration key K31 is an operation key for receiving a new reservation regarding 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 manager of the restaurant may appropriately determine whether the new reservation should be accepted or not by referring to the information displayed on the reservation registration confirmation page P31, the information displayed on the prediction information area A23, and the like. It becomes possible.

  In the present embodiment, a table selection key corresponding to the table set in the “recommendation recommendation 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 The reservation registration confirmation page P31 is displayed also when the) is operated. Therefore, in the present embodiment, the manager of the restaurant can also allocate the user group indicated by the user group information to the table set in the “secured recommendation table”, as 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 “allocation recommendation table” or the “vacant 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 “secured recommendation table”.

<Step S44>
In step S44, the control unit 21 determines whether a reservation registration operation has been performed. Specifically, when the reservation registration key K31 included in the reservation registration confirmation page P31 is operated, the control unit 21 determines that the reservation registration operation has been performed. Then, if it is determined that the reservation registration operation has been performed (S44: Yes), the process proceeds to step S47. On the other hand, when 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 a cancel operation has been performed. Specifically, when the cancel key K32 included in the reservation registration confirmation page P31 is operated, the control unit 21 determines that the cancel operation has been performed. Then, when it is determined that the cancel operation has been performed (S45: Yes), the process proceeds to step S46. On the other hand, when 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 reservation registration processing. In the reservation registration process, the user group information and information on the selected table are registered in the reservation information D3 stored in the storage unit 22. Then, the new reservation process is ended.

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

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

  The user group information area A24 displays the user group information. In the user group information area A24 of the second placement support page P22, the current date and time is displayed as the 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 placement assistance page P22 is closed, and the user group information input page P1 is displayed again.

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

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

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

<Step S53>
In step S53, the control unit 21 determines whether the attention table is in use or reserved. Specifically, the control unit 21 determines whether the attention table is in use or reserved based on table usage status information (not shown) stored in the storage unit 22. The table use status information is updated in real time according to a change in the use status of each table, for example, in response to a user operation on the operation display unit 33 of the shop terminal 3. Then, if 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 used nor reserved (S53: No), the process proceeds to step S55.

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

<Step S55>
In step S55, the control unit 21 (derivation processing unit 212) derives a prediction table unit price when the user group indicated by the user group information is assigned to the attention table. The method of deriving the prediction table unit price is the same as that of step S25 (FIG. 7), and thus the description thereof is 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. The method of deriving the average table unit price is the same as in step S26 (FIG. 7), and thus the description thereof is 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 prediction table unit price derived in step S55, and the unit price ratio is the threshold A. It is determined whether it is smaller than (for example, 70%). When it is determined that the unit price ratio is smaller than the threshold A (S57: Yes), the process proceeds to step S59. On the other hand, when it is determined that the workforce ratio is equal to or more than the threshold A (S57: No), the process proceeds to step S58. The control unit 21 may change the value of the threshold A at the step S27 (FIG. 7) and the step S57. For example, the control unit 21 may set the value of the threshold A used in the step S57 to be lower than the value of the threshold A used in the step S27. This is because it is likely that a table which is not used at present is left empty, and even if the unit price ratio is low, it is more likely to assign user groups corresponding to the user group information. It is highly likely that you can expect sales or profits of

<Step S58>
In step S58, the control unit 21 calculates the number of people for the table of interest, and determines whether the number of people is smaller than the threshold B (for example, 50%). When it is determined that the workforce ratio is smaller than the threshold B (S58: Yes), the process proceeds to step S59. On the other hand, when it is determined that the workforce ratio is equal to or more than the threshold B (S58: No), the process proceeds to step S60. The control unit 21 may change the value of the threshold B in step S28 (FIG. 7) and step S58. For example, the control unit 21 may set the value of the threshold B used in the step S58 to be lower than the value of the threshold B used in the step S28. This is because it is highly possible that tables not currently used are left empty, so even if the number ratio is low, it is more likely to assign user groups corresponding to the user group information. It is highly likely that you can expect sales or profits of

<Step S59>
In step S59, the control unit 21 sets the attention table as a "secured recommendation table". Then, the process proceeds to step S60. Among the tables that can be allocated to the user group corresponding to the user group information, the “recommendation recommendation table” is one that is reserved for another user group without allocating the user group, It is a table predicted that more sales or profits can be expected.

<Step S60>
In step S60, the control unit 21 selects one of the plurality of tables installed in the restaurant (here, seven tables of the table A to the private room table G as shown in FIG. 3) as the table of interest It is determined whether there is a table that has not been set. Then, if it is determined that there is a table not selected as the attention table (S60: Yes), the process returns to the step S52. On the other hand, when it is determined that there is no table not selected as the attention table (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 allocated to the user group corresponding to the user group information as an “allocation recommendation table”. For example, the control unit 21 selects a table having the highest prediction table unit price as an “allocation recommendation table” among the tables not set in the “non-allocation table” or the “recommendation recommendation table”. Then, the control unit 21 sets a table other than the “non-allocation table”, the “recommendation recommendation table”, and the “allocation recommendation table” as the “vacant 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 on the use status area A25 of the second placement support page P22. Then, the control unit 21 changes the display mode of each of the table selection keys K22 to K28 according to the use status of the corresponding table. For example, the control unit 21 sets a table selection key (here, the table selection key K23 or K24) corresponding to the table set in the "vacant table" in step S61 to the first display mode (for example, white background color) Display with. In addition, the control unit 21 displays the table selection key (here, the table selection key K28) corresponding to the table set in the “recommendation recommendation table” in the step S59 in the second display mode (for example, light gray background color) Display with. Further, the control unit 21 causes the table display keys (here, the table selection keys K22, K26, and K27) corresponding to the table set in the "non-allocation table" in step S54 to be displayed in the third display mode (for example, dark gray) Background color). In addition, the control unit 21 causes the fourth display mode (for example, light red background color) of the table selection key (here, the table selection key K25) corresponding to the table set in the “allocation recommendation table” in step S61. Display with.

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

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

<Step S71>
In step S71, the control unit 21 determines whether any one of the plurality of tables installed in the restaurant has been selected. Specifically, the control unit 21 operates the table when one of the plurality of table selection keys K22 to K28 displayed in the use status area A25 of the second placement support page P22 is operated. It is determined that the table corresponding to the selection key is selected. However, in the present embodiment, the operation on the table selection key corresponding to the “non-allocation impossible table” is not accepted, and only the operation on the table selection key corresponding to the “vacant table” or the “recommendation recommendation table” is accepted. . Then, if it is determined that any table is selected (S71: Yes), the process proceeds to step S72. On the other hand, when it is determined that no table is selected (S71: No), the process of step S71 is repeated until it is determined that any table is selected.

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

<Step S73>
In step S73, as shown in FIG. 15, the control unit 21 (presentation processing unit 213) displays the assignment confirmation page P32 corresponding to the selected table (here, the table D) in the operation display unit 33 of the shop terminal 3. Display on. On the assignment 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, the prediction information derived in step S72 is displayed on the allocation confirmation page P32.

  The assignment confirmation page P32 includes an assignment key K33 and a cancel key K34. The assignment 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 assignment confirmation page P32.

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

  In the present embodiment, the allocation confirmation page P32 is also displayed when the table selection key corresponding to the table set in the “recommendation recommendation table” (here, the table selection key K28 corresponding to the private room table F) is operated. Is displayed. Therefore, in the present embodiment, the manager of the restaurant can also allocate the user group indicated by the user group information to the table set in the “secured recommendation table”, as necessary. However, in another embodiment, the allocation confirmation page P32 may be displayed only when the table selection key corresponding to the table set in the “allocation recommendation table” or the “vacant 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 “secured recommendation table”.

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

<Step S75>
In step S75, the control unit 21 determines whether a cancel operation has been performed. Specifically, when the cancel key K34 included in the assignment confirmation page P32 is operated, the control unit 21 determines that the cancel operation has been performed. If it is determined that the cancel operation has been performed (S75: Yes), the process proceeds to step S76. On the other hand, when 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 assignment confirmation page P32. Then, the process returns to the step S71.

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

<Step S78>
In step S78, the control unit 21 (the advice processing unit 215) causes the operation display unit 33 of the shop terminal 3 to display an advice page P4 as shown in FIG. In 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 allocated to a table different from the table actually allocated (here, the table D), Displayed as the target number of orders. The restaurant employee cleans up empty dishes and adds additional orders to the user group so that the number of orders close to the target number of orders can be obtained while comparing the target number of orders and the number of current orders. It can prompt you. Then, the walk-in process is ended.

  As described above, in the seating assistance device 2 according to the present embodiment, the profitability or profitability when the user group of the specific type uses the specific table or the specific type table based on the history information D4. An indicator that indicates is derived. For example, for each table or table type, the number of predicted orders and the predicted table unit price are derived in the case where a user group who desires to use a restaurant is assigned to the table. Therefore, according to the seating arrangement support apparatus 2 according to the present embodiment, it is possible to support the determination of which table the user group of the specific type should be allocated.

[Modification]
In the present embodiment, a new reservation is accepted when the reservation registration key K31 (FIG. 13) is operated by the manager of the restaurant, but the present invention is not limited to this. In another embodiment, when an application for a new reservation is made from the user terminal 4 to the placement support device 2, the control unit 21 (reservation processing unit 216) automatically determines whether to accept the new reservation. The new reservation may be automatically accepted or rejected. For example, the control unit 21 may automatically receive a new reservation from the user group, when there is an “empty table” or an “allocation recommendation table” whose capacity is equal to or more than the number of users of the user group. . At this time, even if the control unit 21 automatically assigns the user group to an optimal table (for example, a table with the highest predicted group unit price) among the “vacant table” or the “allocation recommendation table”. Good. In addition, the control unit 21 does not have an "empty table" or an "allocation recommendation table" having a capacity equal to or more than the number of the user group, and only the "secured recommendation table" having a capacity equal to or more than the number of the user group. If not present, new reservations from the user group may be automatically rejected. As a result, it is possible to save time and effort for the user regarding acceptance and rejection of a new reservation. Moreover, as a result, the manager of the restaurant does not need to operate the shop terminal 3 to accept and reject a new reservation, so that the communication traffic between the shop terminal 3 and the arrangement support device 2 can be reduced. And the effective use of the computer resource of the shop terminal 3 becomes possible.

  In another embodiment, the value of threshold A used in step S27 of FIG. 7 or step S57 of FIG. 9 corresponds to the busy degree of the visit date (the current date and time in the case of walk-in) indicated by the user group information. May be changed automatically. For example, when the visit date and time is a busy time (for example, a time zone from 17 o'clock to 21 o'clock on Friday, etc.), the control unit 21 makes the value of the threshold A higher than usual and the visit date and time is not In the case of a time (for example, a time zone of 14 o'clock to 17 o'clock on Monday to Thursday, etc.), the value of the threshold A may be set lower than usual. Similarly, the value of threshold B used in step S28 of FIG. 7 or step S58 of FIG. 9 is automatically changed according to the busyness of the visit date (the current date and time in the case of walk-in) indicated by the user group information. It may be done. For example, when the visit date and time is a busy time (for example, a time zone from 17 o'clock to 21 o'clock on Friday), the control unit 21 makes the value of the threshold B higher than usual and the visit date and time is off In the case of a time (for example, a time zone of 14 o'clock to 17 o'clock on Monday to Thursday, etc.), the value of the threshold B may be set lower than usual. As a result, it is easier to set more tables in the “recommended recommended table” as the time when more user groups are expected to come to the store. Therefore, further improvement of the profit or profit of the restaurant can be expected.

DESCRIPTION OF SYMBOLS 1 placement support system 2 placement 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 terminals 4 user terminals

Claims (13)

An acquisition processing unit that acquires history information including information on the type of each user group who used a restaurant in the past, information on a table used, and information on the ordered food and drink;
A derivation processing unit that derives an index indicating 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;
Disposition support device provided with The history information includes use date or use date and time information,
The derivation processing unit uses the specific table or the specific type table as a use date or use date and time in which at least one of a month, a date, a day of the week, and a time zone share a specific date or a specific date and time. Based on the history information about the user group, the index is derived when the user group of the specific type uses the specific table or the table of the specific type on the specific date or the specific date and time.
The placement assistance device according to claim 1. The information processing apparatus further includes a presentation processing unit that presents the index derived by the derivation processing unit.
The placement assistance device according to claim 1 or 2. The derivation processing unit derives the index for each of the tables that can be assigned to the user group of the specific type;
The presentation processing unit presents the index for each of the tables.
The placement assistance device according to claim 3. The derivation processing unit derives the index for each of the tables that can be assigned to the user group of the specific type;
The system further includes a selection processing unit that selects a table to be allocated to the user group of the specific type based on the index for each table.
The seating assistance device according to any one of claims 1 to 3. The selection processing unit selects a table to be allocated to the user group of the specific type based on a predicted group unit price for each of the tables and a ratio of the number of the user groups to the capacity of the table.
The placement assistance device according to claim 5. The system further includes an advice processing unit that presents advice information according to the index derived by the derivation processing unit.
The placement assistance device according to any one of claims 1 to 6. Based on the index derived by the derivation processing unit, whether or not a new reservation from the user group of the specific type who wants to use the restaurant on a specific date or a specific date and time should be accepted It further comprises a reservation processing unit to determine
The seating assistance device according to any one of claims 1 to 7. The indicator includes the forecasted group price,
The reservation processing unit is configured to calculate the predicted group unit price for each of the tables and the average average group unit price for each of the tables for all the tables that can be used by the user group of the specific type on the specific date or the specific date and time. It is determined that the new reservation from the user group should not be accepted when the specific condition is satisfied,
The placement assistance device according to claim 8. The reservation processing unit presents advice information according to the determination result.
The placement assistance device according to claim 8 or 9. The reservation processing unit accepts a new reservation from the user group if the determination result is affirmative, and if the determination result is negative, a new reservation from the user group Do not accept,
The placement assistance device according to claim 8 or 9. On one or more processors,
Have history information including information on the type of each user group who used the restaurant in the past, information on the table used, and information on the ordered food and drink,
Based on the history information, it is possible to derive an index indicating profitability or profitability when a specific type of user group uses a specific table or a specific type of table.
Placement support program. Acquire history information including information on the type of each user group who used the restaurant in the past, information on the table used, and information on the ordered food and drink,
Based on the history information, an index indicating profitability or profitability when a specific type of user group uses a specific table or a specific type of table is derived.
Placement support method.

Images