JP2540922B2 - Inventory management device - Google Patents

Description

The present invention relates to an inventory management device, and more particularly to an inventory management device capable of inventory management of materials in a restaurant. More specifically, the present invention relates to an inventory management device with a bargain menu automatic selection function that identifies and displays a menu that minimizes the residual value of materials.

[Prior Art] In a conventional electronic cash register for restaurants (hereinafter abbreviated as ECR), data to be input and managed are a unit price of a menu, a menu item, a customer segment, and the number of visitors.

[Problems to be Solved by the Invention] However, such conventional ECR for restaurants
In the above, since the item of management data did not list the item related to inventory management of materials, it is not immediately possible to immediately know which material and how much is left.
There was a problem that a certain material was left in excess or conversely lacked due to the bias of the daily customer base and the bias of the order menu. In addition, there is a problem in that a large amount of surplus material is easily perishable or expensive, and unavoidable material disposal causes great damage.

Therefore, the main object of the present invention is not to reduce the customer service due to the lack of stock of the material during the sale processing, and to avoid serious damage due to the unavoidable disposal of the residual material, so that the remaining amount of the material is not damaged. An object of the present invention is to provide an inventory management device capable of automatically selecting a menu that minimizes value.

[Means for Solving the Problem] The present invention is an inventory management device used in a restaurant or the like, and displays all menus to be sold in the restaurant, etc., and at least information on materials used and quantity and value of each menu. Storage means for storing, means for updating the corresponding menu stored in the storage means by subtracting the amount of the used material for each menu sales processing, and at least a menu stored in the storage means Means for calculating an evaluation value relating to the remaining amount of the used material of the menu based on the remaining amount of the used material and value information, and specified from the menu stored in the storage means based on the evaluation value calculated by the calculating means And a display unit for displaying the menu selected by the selection unit.

[Operation] In the present invention, main data regarding all menus and all materials is registered in advance in the storage means, and the remaining amount of the used materials registered in the storage means is subtracted and updated for each menu sales, and the storage is performed. The evaluation value relating to the remaining amount of the menu use material is calculated by the calculating means based on the remaining amount of the menu use material and the value information stored in the means, and stored in the storage means based on the evaluation value calculated by the calculating means. The menu is specified from all the menus that are specified, and the specified menu is displayed on the display means.

[Embodiment] FIG. 2 shows an outline of a system configuration of an embodiment of the present invention. In FIG. 2, the system configuration has an ECR1 installed in a restaurant and having only a sales processing function, a database 3 for managing material inventory management and data related to sales, a sales processing function and a set value registration processing function of the database 3. It includes a database interface 4 for controlling data input / output between the master ECR2, the database 3 and ECR1 and the master ECR2, and a communication line 5 for connecting all the members. The database 3 is constructed and managed in an external storage device such as a magnetic disk, and the master ECR 2 and all ECR 1 share the database 3 via the database interface 4.

FIG. 3 is a schematic block diagram showing an electrical configuration of an ECR (including a master ECR) according to an embodiment of the present invention. ECR
Is a central processing unit (hereinafter CPU) that controls and manages the ECR itself.
10), a memory ROM 20 for storing a program group including the processing of the present invention, a memory RAM for storing input / output data
30, a database interface 40 for controlling data input / output to / from the database 3, a display unit 50 used in sales processing and also displaying a service menu determined by the processing of the present invention, a printer 60 for printing out receipts, data A keyboard 70 for entering, a timer 80 for notifying the service menu set time, and each other
A transmission control unit 90 that controls data transmission / reception with the ECR is included.

FIG. 4 is a key layout diagram of the keyboard 70 shown in FIG. FIG. 4 (a) is a key layout diagram of ECR1, and FIG. 4 (b) is a key layout diagram of master ECR2. The keyboard is the department code key 71, the numeric keypad 72 and the adjustment key
Including 73. Further, the processing mode changeover switch 74 is installed only in the master ECR2, and it can be selectively set by switching between a daily sales processing mode 74a with a customer and a set value registration mode 74b for registering data in a database. Further, the registration data in the set value registration mode is input by the ten keys 72.

FIG. 5 shows an operational outline of the database 3 shown in FIG. The database 3 is a coefficient database 31 for registering weights to be added when determining the service menu of FIG. 5A, and a menu database 32 for registering detailed data of each menu of FIG. 5B.
And a purchased material database 33 for registering detailed data on each purchased material in FIG. 5 (c). Next, the detailed structure of each of the databases will be described.

First, the coefficient database 31 of FIG. 5 (a) registers weighting coefficients for selecting items that each store emphasizes, and includes a profit coefficient 31a, a popularity coefficient 31b, and a remaining amount coefficient.
Including 31c. Next, the menu database 32 shown in FIG. 5 (b) has a menu number 32 attached to each menu.
a, materials used by the menu (material number 33a, quantity
32f) 32b, menu price 32c, menu profit margin 32d which is the profit margin due to the sale of the menu, and menu popularity 32e to customers. Finally, in the purchased material database 33 of FIG. 5 (c), the material number 33a attached to each material, the current remaining quantity 33b of the material, the amount 33c per unit weight when purchasing the material, and the perishability of the material It includes a use priority coefficient 33d indicating the degree. The menu database 32 is data 32a to 32c for all menus.
Are registered, and the purchased material database 33 registers data 33a to 33d for all purchased materials. Next, how to operate each data in each database in one embodiment of the present invention will be described.

First, the menu sales process 35a (sales process) will be described. The menu sales process 35a is a process performed by both ECR1 and master ECR2. If the menu is sold during the sales process, the corresponding menu data 32a to 32c is obtained from the database with the menu number 32a of the sold menu (34a). For example, the menu number 32a and the menu amount 32c are used for settlement. However, regarding the data of the materials used (material number 33a, quantity 32f) 32b,
Search the purchased material database 33 for each material number 33a of the used material, subtract the usage amount 32f of the corresponding material in the sold menu from the remaining quantity 33b of the corresponding material number 33a, and update the remaining quantity 33b. (34b). Update the remaining amount of the material 34b
For all materials used in the sales menu. Next, the inside of the service menu setting process 35b will be described. The service menu setting process 35b is the master ECR.
The process is performed only for the above, and various kinds of data are obtained from the coefficient database 31, the menu database 32, and the purchased material database 33 to be comprehensively determined. An example will be described. First, in order to calculate the [residual value V] that represents the value of the remaining material, the data 33b to 33d are used for various materials and are calculated by the following formula.

V = (remaining amount of material 33b) × {(amount of money per unit weight 33c) × (use priority coefficient 33d)} Remaining amount of three types of materials with large V values for the [remaining amount value V] determined above Using the data of 33b and 33c per unit weight, the following [Evaluation C] for various menus
Is calculated. Now, let us say that the three types of materials having large [residual value V] obtained above are X, Y, and Z, respectively.

C = {(profit coefficient 31a) x (menu price 32c) x (menu profit rate 32d)} + {(popularity coefficient 31b) x (menu popularity 32e)} + [(remaining amount coefficient 31c) x {( Amount 33c per unit weight of X) × (Amount 32f of X used) + (Amount 33c per unit weight of Y) × (Amount 32f of Y used) + (Amount 33c per unit weight of Z) × (Amount used of Z 32f)}] As described above, the [evaluation scale C] of various menus calculated using the [remaining value V] is provided so that the menu having the largest [evaluation scale C] can be set in the service menu. Data from each database is operated comprehensively.

FIG. 1 is a flow chart showing a process for database management and service menu setting according to an embodiment of the present invention. FIG. 1 (a) is a processing flow on the master ECR side, and FIG. 1 (b) is a processing flow on the ECR side parallel to the processing of the master ECR. As described above, the master ECR performs sales processing and database setting value registration processing, and the ECR performs only sales processing.
First, the processing on the master ECR side will be described with reference to FIG. Step S1 before the daily sales process starts
(In the figure, abbreviated as S1) to step S3, initial values are set for various data in the database 3. The processing mode selector switch 74 of the keyboard 70 is switched to the set value registration mode 74b in advance, and the processing is started. Although the data of each menu is input to the menu database 32 in step S1, the update processing may be performed only for the changed data. Next, after updating the purchased material database 33 for materials purchased today in step S2, if there is a change in today's weighting coefficients 31a to 31c determined by the store side in step S3, update processing is performed. Next, the process of sales will be described in steps S4 to S6. During the sales processing, the processing mode changeover switch 74 is switched to the sales processing mode 74a, and it is first determined in step S4 whether or not there is menu sales. If there is no menu sales, step S4 is repeated, but if there is menu sales, the process proceeds to step S5. In step S5, the menu number 32a of the sold menu is obtained, the processing of each menu data acquisition 34a in the explanation of FIG. 5 described above and the remaining material amount update 34b are performed, and the remaining amount 33b of the purchased material is subtracted. And then update
Proceed to step S6. In step S6, it is determined whether or not the measurement time (current time) of the timer 80 inside the ECR is the service menu setting time preset by the store. If the service menu set time has not come, the processing returns to step S4, and the menu sales processing is performed.
35a is repeated, but if it is determined that it is the service menu setting time, the process proceeds to the service menu setting process 35b in steps S7 to S10. In the service menu setting process 35b, first, in step S7, the [residual value V] of the various materials described in FIG. 5 is obtained.
Next, in step S8, the amount of money 33c per unit weight is calculated for the three materials X, Y, and Z for which the obtained [residual value V] is large, and in the next step S9, the above-mentioned FIG. [Evaluation C] in the description is obtained for each menu. In the next step S10, the menu having the largest [evaluation scale C] obtained in steps S7 to S9 is determined as the service menu. When the service menu is determined in steps S7 to S10, the next step S
At 11, the determined service menu is transmitted as service menu transmission 5a to each ECR via the communication line 5. Then, in step S12, the determined service menu is displayed on the display 50 to notify the operator. The operator confirms the displayed service menu, and in step S13, while performing the sales activity of recommending the service menu to the customer, the process returns to step S4, and the menu sales process 35a is repeated.

On the other hand, the processing on the ECR side parallel to the processing on the master ECR side will be described. In the processing on the ECR side, steps S4 to S6 correspond to steps S4 to S6 of the processing on the master ECR side described above. Step S4
Or in step S6, after the menu sales processing 35a,
When the timer 80 determines that it is the service menu set time, the process proceeds to step S14. In step S14, the service menu transmission 5a transmitted in step S11 on the master ECR side is received via the transmission control unit 90, and
Confirmed that the signal was received in S15. If not received, the process returns to step S14 to repeat the receiving process, but if received, the process proceeds to the next step S12 and step S13, performs the process corresponding to the above-mentioned master ECR process step S12 and step S13, and repeats the step. Return to S4 and repeat the menu sales process 35a.

As described above, the service menu that performs the database data update process in parallel with the sales process and immediately operates the data in the database comprehensively at the preset time to minimize the residual value of the material Is automatically identified and all ECRs display this identified service menu so that the operator can quickly process the service menu for sales.

In the above embodiment, the fact that the service menu setting time has come is not notified to the outside, but if necessary, an audio device may be added to notify by sound or by lighting a lamp. If desired, the current remaining amount of material may be displayed on a display or printed out from a printer so that it can be seen at a glance.

Further, in the above-mentioned embodiment, the database 3 is constructed and managed in the external storage device, but when the installed ECR is extremely small or the data input / output time to the database 3 becomes short. When a system is required, this database may be built and managed in the internal storage device in each ECR.

[Effects of the Invention] As described above, according to the present invention, the inventory management device stores, in advance, all menus to be sold at a restaurant or the like, and at least information on materials used for each menu and the amount and value thereof in the storage means. Storing and subtracting the amount of the used material related to the corresponding menu stored in the storage means for each sales process of the menu, the calculation means is stored in the storage means and the remaining amount and value of the menu used material are stored. Based on the information, an evaluation value regarding the remaining amount of the material used for the menu is calculated, and the menu selection means selects a specific menu from the menu stored in the storage means based on the calculated evaluation value, and the display means selects the selected menu. Since the displayed menu can be displayed, the menu to be serviced is selected and displayed by the menu selection means using the calculated evaluation value. The service menu can be displayed to the customer via the indicating means. Therefore, it is possible to improve service to customers, improve store sales, and prevent damage due to waste of waste materials. In addition, since the current remaining material and quantity can be immediately known, it is possible to purchase an appropriate material.

[Brief description of drawings]

FIG. 1 is a flow chart of database management and service menu setting processing according to an embodiment of the present invention. FIG. 2 is a schematic diagram of the system configuration of an embodiment of the present invention. FIG. 3 is a schematic block diagram showing an electrical configuration of an ECR (including a master ECR) according to an embodiment of the present invention. FIG. 4 is a key layout diagram of the ECR and master ECR keyboards of one embodiment of the present invention. FIG. 5 is a diagram showing an outline of operation of the database according to the embodiment of the present invention. In the figure, 1 is ECR, 2 is master ECR, 3 is database,
31 is a coefficient database, 32 is a menu database, 33
Is a purchased material database, 5a is a service menu transmission,
74 is a processing mode changeover switch, 74a is a sales processing mode, and 74b is a set value registration mode. In each drawing, the same reference numerals indicate the same or corresponding parts.

Claims (1)

(57) [Claims] 1. An inventory management device used in a restaurant or the like, and a storage means for storing all menus to be sold in a restaurant or the like, and at least information on materials used and the amount and value of each menu once. Means for subtracting and updating the amount of the used materials related to the corresponding menu stored in the storage means for each sales processing of the menu, and at least the remaining amount and value of the menu used materials stored in the storage means Means for calculating an evaluation value related to the remaining amount of the material used for the menu based on the information, based on the evaluation value calculated by the calculating means, means for selecting a specific menu from the menu stored in the storage means, An inventory management device, comprising: a display unit that displays the menu selected by the selection unit.