JP2003242302A - Device and program for preparing menu - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a menu preparing device and menu preparation program capable of easily preparing a menu with a budget taken into consideration. <P>SOLUTION: This menu preparing device is provided with a food master file 13 recorded with data about each food, a food merchandise master file 14 recorded with data about each food merchandise, an association master file 15 recorded with data for associating each food recorded in the food master file 13 with each food merchandise recorded in the food merchandise master file 14, a menu data preparing means 16 for preparing a menu based on data about each food recorded in the food master file 13, a food merchandise specifying means 17 for referring to the association master file 15 to specify food merchandise corresponding to food necessary for the menu from data about the menu prepared by the menu data preparing means 16, a price calculating means 18 for calculating the price of the menu based on the food merchandise specified by the food merchandise specifying means 17, and an outputting means 19 for outputting the price of the menu calculating by the price calculating means 18. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a menu preparation device and a menu preparation program for preparing a menu.

[0002]

2. Description of the Related Art The meals provided at schools, factories, dormitories, hospitals, elderly and welfare facilities, etc. are usually managed and managed by dietitians who work there. The dietitian prepares a menu for meals in consideration of the daily nutritional balance, and procures the necessary ingredients according to this. However, in addition to creating a menu table considering nutritional balance,
Procuring the required ingredients in consideration of the budget is a very difficult task.

[0003] Conventionally, menu preparation software is known which performs nutrition calculation and menu preparation. With the menu preparation software, it is possible to prepare a menu while automatically performing nutritional calculation, and it is possible to output a menu table and a list of required ingredients as shown in FIGS. 11 (a) and 11 (b).
Then, the dietician makes an inquiry to a neighboring supplier based on the list of required ingredients shown in FIG. 11B, and arranges an actual product close to the required ingredients within the budget.

For example, "milk" is a required ingredient 460
Although it is 0 g, there are various brands of commodities corresponding to the ingredient "milk", and their contents and prices are also various.
Therefore, the dietitian needs to order three actual products that can be purchased within the budget frame, for example, "M company milk 1.5L" as the products equivalent to 4600g of "milk".

[0005]

As described above, even if the conventional menu preparation software is used, what is output is the name and the total amount of the general required ingredients, and the nutritionist can use the output based on this output. It is necessary to find an actual product that is close to the required food material within the budget, and determine the order quantity of the product according to the content amount of the found actual product.

Particularly in hospitals where menus are different for each patient, there are many kinds of ingredients required for each meal, and the products corresponding to each ingredient are purchased one by one within the budget limit. The work to place an order to the company requires considerable labor and time.

Therefore, it is an object of the present invention to provide a menu preparation device and a menu preparation program capable of easily preparing a menu in consideration of a budget frame.

[0008]

According to the menu preparation apparatus of the present invention, a food material master file recording data on each food material, a food product master file recording data on each food product, and a food material master file are recorded. A linking master file that records data that associates each ingredient with each ingredient product recorded in the ingredient product master file, and menu data creation means that creates a menu based on the data about each ingredient recorded in the ingredient master file. ,
Ingredient product identification means for identifying an ingredient product corresponding to an ingredient required for the menu from the data relating to the menu created by the menu data creation means with reference to the linking master file, and the ingredient specified by the ingredient product specification means It is provided with a price calculation means for calculating the menu price based on the product and an output means for outputting the menu price calculated by the price calculation means.

[0009] Here, the data on each foodstuff is the code assigned to each foodstuff, the name of each foodstuff, the amount of heat per unit quantity of each foodstuff, moisture, protein, lipid, carbohydrate, ash, calcium, phosphorus, iron, It is data on the intake of sodium, potassium, retinol, carotene, vitamin A, vitamin B1, vitamin B2, niacin, vitamin C, saturated fatty acids, unsaturated fatty acids (monovalent), unsaturated fatty acids (polyvalent), etc. The data regarding each food product is data such as a code assigned to each food product, a name or type of each food product, a standard, a supplier, and a capacity.

The data recorded in the linking master file includes the code of each foodstuff, the code of each foodstuff product associated with the code of each foodstuff, the order unit price, the reference amount,
It is data such as a reference unit, a unit price per 100 g, a packing amount, and a packing unit.

According to the menu preparation apparatus of the present invention, menu data is created, and the linking master file is searched based on the created menu data, so that this menu can be selected from the data relating to the ingredients included in the menu. Each ingredient product corresponding to each ingredient required for is automatically specified, and the required amount of each ingredient product for each ingredient product is automatically calculated, and the price of each identified ingredient product The menu price will be calculated and output automatically.

Further, the menu preparation program of the present invention includes a food material master file in which data on each food material is recorded,
You can refer to the ingredient product master file that records data about each ingredient product and the linking master file that records the data that associates each ingredient recorded in the ingredient master file with each ingredient product recorded in the ingredient product master file. A computer, refer to the menu data creation means for creating a menu based on the data related to each ingredient recorded in the ingredient master file, and the linking master file,
The menu price is calculated based on the data about the menu created by the menu data creating means, based on the food product specifying means for specifying the food products corresponding to the ingredients necessary for the menu and the food products specified by the food product specifying means. The price calculation unit and the output unit output the menu price calculated by the price calculation unit.

The menu preparation program of the present invention is supplied to a computer via the Internet, a communication line such as a private line or a public line, or a computer-readable recording medium such as a hard disk, a CD-ROM, a flexible disk or a magneto-optical disk. Or
By recording it in the memory in the computer in advance and executing it by the computer, it is possible to obtain the same operation as the menu preparation device of the present invention.

[0014]

1 is a schematic diagram showing the configuration of a menu preparation device according to an embodiment of the present invention, and FIG. 2 is a block diagram showing the functional configuration of the menu preparation device of FIG.

In FIG. 1, a computer 1 as a menu preparation device according to an embodiment of the present invention includes a main body 2 having a central processing unit, a storage device, a communication device, etc., a keyboard 3 as an input device, and a pointing device 4, A display 5 as a display device, a printer 6 as a print output device, and the like are provided.

As shown in FIG. 2, the computer 1 stores a menu master file 11 recording menu data, which is the basis of menu preparation, a menu detail master file 12 recording detailed menu data, and data on each ingredient. The recorded food material master file 13, the food material product master file 14 in which data on each food product is recorded, and the linking master file 15 in which data that associates each food product with each food product are recorded are held in the storage device.

FIG. 3 is a diagram showing an example of menu data recorded in the menu master file 11. The menu data is data about menus registered in advance, and is data such as menu codes assigned to each menu, names of each menu (menu name), and cooking codes indicating cooking classification of each menu.

FIG. 4 is a diagram showing an example of detailed menu data recorded in the detailed menu file 12 for menu. The detailed menu data is data on the details of the menu registered in the menu master file 11, and includes the menu code of each menu, the code assigned to each ingredient composing each menu (food code), and actually ingestible. It is data such as the amount (edible amount) and the amount (usage amount) that can actually be used for cooking.

FIG. 5 is a diagram showing an example of food material data recorded in the food material master file 13. Ingredient data is data on each ingredient, and is the ingredient code of each ingredient, the name of each ingredient (name of ingredient), the amount of heat per unit amount of ingredient, water, protein, lipid, carbohydrate, ash, calcium, etc.
Phosphorus, iron, sodium, potassium, retinol, carotene, vitamin A, vitamin B1, vitamin B2, niacin, vitamin C, saturated fatty acid, unsaturated fatty acid (monovalent)
・ Data such as the intake of unsaturated fatty acids (polyvalent).

FIG. 6 is a diagram showing an example of the ingredient product data recorded in the ingredient product master file 14. The food product data is the code (product code) assigned to each food product, the name or type (product name) of each food product, the standard,
Data such as supplier and capacity. Here, the foodstuff product is a form of foodstuff that is actually commercially traded with respect to the foodstuff as a general material constituting the menu. For example, the food product “frozen green peas 1K” shown in FIG. 6 is traded in standard “bag” units, and the content capacity per bag is 100.
It is 0 g.

FIG. 7 is a diagram showing an example of linking data recorded in the linking master file 15. The linking data includes the ingredient code of each ingredient, each item code associated with each ingredient code, the order unit price, the reference amount, the reference unit,
It is data such as a unit price per 100 g, a packing amount, and a packing unit. This linking data associates the foodstuff registered in the foodstuff master file 13 shown in FIG. 5 with the foodstuff product registered in the foodstuff product master file 14 shown in FIG.

Returning to FIG. 2, the computer 1
Menu master file 11 and menu details master file 12
And the menu data creating means 16 for creating menu data by referring to the ingredient master file 13 and the menu creating means 16 by referring to the linking master file 15, the ingredient master file 13 and the ingredient product master file 14. Ingredient product identification means 17 for identifying an ingredient product corresponding to an ingredient required for the menu from the menu data, price calculation means 18 for calculating a menu price based on the ingredient product identified by the ingredient product identification means 17, and price calculation It functions as an output unit 19 that outputs the data regarding the price calculated by the unit 18.

The menu data creating means 16 includes menu data registered in the menu master file 11 of FIG. 3, menu detailed data registered in the menu detail master file 12 of FIG.
Also, the menu data is created by referring to the food material data registered in the food material master file 13 of FIG. The menu data created here is data relating to the menu that constitutes each meal content such as breakfast, lunch, and dinner.
FIG. 8 shows an example of the menu creation screen displayed on the display 5.

The operator of the computer 1 selects the menus that compose the meal contents of breakfast, lunch and dinner from the menu data registered in advance in the menu master file 11 on the menu preparation screen of FIG. It is possible to create it. Alternatively, when creating a new menu item that is not registered in the menu item master file 11, the menu item detail data registered in the menu item detail master file 12 in FIG. 4 and the ingredient data item registered in the ingredient master file 13 in FIG. Can be newly created by referring to.

FIG. 9 shows an example of the menu content change screen displayed when each menu is specified on the menu creation screen of FIG. The content of each menu can be changed on the menu content change screen shown in FIG. Also, when a new menu is created, the menu content change screen shown in FIG. 9 is used.

When one menu is specified on the menu creation screen of FIG. 8, the menu data creating means 16 searches the menu detail master file 12 of FIG. 4 based on the menu code of the specified menu, and the corresponding menu is selected. Detailed menu data such as the food code, edible amount, and usage amount associated with the code is acquired and displayed as a food constituting the menu in the menu content change screen shown in FIG.

Further, the menu content change screen of FIG. 9 displays each component value of the component unit ingested by the menu. For this component value, the food material master file 13 of FIG. 5 is searched based on the code of the food material forming the menu,
It is calculated based on each component value per unit amount of each food material associated with the corresponding food material code. Similarly, the menu content change screen of FIG. 9 displays each component value of each meal and each day.

Returning to FIG. 2, the food product identification means 17 is
Referring to the linking data registered in the linking master file 15 of FIG. 7, the ingredients of each menu created by the menu data creating means 16, that is, the food products corresponding to the ingredients necessary for the menu It identifies the product code.

The price calculating means 18 is the food product specifying means 1
Based on the product code of the food product product specified in 7,
The ordering unit price / reference amount / reference unit price / 100g unit price of each food product is acquired from the connection data of the connection master file 15 in FIG. 7, and the menu price when each food product is used is calculated. Further, the price calculation means 18 displays the calculated menu price on the menu creation screen of FIG. 8 and the menu content change screen of FIG. 9 by the output means 19.

The processing by the menu preparation device having the above configuration will be described below with reference to the flowchart of FIG.

First, in step S101 of FIG. 10, menu creation is performed by operating the computer 1. The operator of the computer 1 uses the menu data creating means 16 to display the menu creation screen of FIG. 8 and the menu content change screen of FIG. To create.

In step S102, the ingredient product specifying means 17 refers to the linking data registered in the linking master file 15 in FIG. 7 to configure each menu created by the menu data creating means 16 in step S101. The product code of the food product corresponding to the food product to be specified is specified.

In step S103, the price calculation means 19
However, based on the product code of the food product specified by the food product specifying means 17, the ordering unit price / reference amount / reference unit price / 100g unit price of each food product is calculated from the connection data of the connection master file 15 of FIG. Obtain and calculate the menu price when using each ingredient.

In step S104, step S103
The menu price calculated by the price calculation means 19 in
Along with the menu created by the menu data creating means 16, the output means 19 outputs and displays the menu creation screen of FIG. 8 and the menu content change screen of FIG.

In step S105, the operator of the computer 1 confirms the menu content and menu price displayed and displayed on the menu creation screen of FIG. 8 and the menu content change screen of FIG. It is possible to return to the process of step S101 and redo the menu creation. When the menu contents are confirmed, the process ends.

As described above, according to the menu preparation device of the present embodiment, the menu price calculated by the price calculation means 18 based on the menu data created by the menu data creation means 16 is displayed by the output means 19. Since it is output to the 5th grade, the dietitian or the like can easily confirm the output menu price and easily prepare the menu while considering the budget.

[0037]

According to the present invention, the menu data creating means for creating a menu based on the data relating to each food material recorded in the food material master file and the menu data creating means are created by referring to the linking master file. Ingredient product identification means for identifying an ingredient product corresponding to an ingredient required for the menu from data about the menu, price calculation means for calculating a menu price based on the ingredient product specified by the ingredient product identification means, and price calculation means With the configuration having the output means for outputting the menu price calculated by, the dietitian or the like can easily confirm the outputted menu price and easily prepare the menu while considering the budget.

[Brief description of drawings]

FIG. 1 is a schematic diagram showing a configuration of a menu preparation device according to an embodiment of the present invention.

FIG. 2 is a block diagram showing a functional configuration of the menu creation device in FIG.

FIG. 3 is a diagram showing an example of menu data recorded in a menu master file.

FIG. 4 is a diagram showing an example of menu detail data recorded in a menu detail master file.

FIG. 5 is a diagram showing an example of food material data recorded in a food material master file.

FIG. 6 is a diagram showing an example of food product data recorded in a food product master file.

FIG. 7 is a diagram showing an example of linking data recorded in a linking master file.

FIG. 8 is a diagram showing an example of a menu creation screen.

FIG. 9 is a diagram showing an example of a menu content change screen.

FIG. 10 is a flow chart of processing by the menu preparation device of FIG. 1.

FIG. 11A is a diagram showing an example of a conventional menu table;
(B) is a figure which shows the example of the conventional required foodstuff list.

[Explanation of symbols]

1 computer 2 body 3 keyboard 4 pointing device 5 display 6 printer 11 Menu Master File 12 Menu detail master file 13 Food ingredients master file 14 Ingredient product master file 15 Linking master file 16 Menu data creation means 17 Food product identification means 18 Price calculation means 19 Output means

Claims (2)

[Claims] 1. A foodstuff master file recording data on each foodstuff, a foodstuff product master file recording data on each foodstuff product, each foodstuff recorded on the foodstuff master file, and a foodstuff master file recorded on the foodstuff product master file. A linking master file in which data for associating each ingredient product is recorded, a menu data creating means for creating a menu based on the data relating to each ingredient recorded in the ingredient master file, and the linking master file is referred to. Then, based on the menu-related data created by the menu data creating means, a food product product specifying means for specifying food product products corresponding to the food materials necessary for the menu, and a menu based on the food product products specified by the food product product specifying means Outputs the price calculation means that calculates the price and the menu price calculated by the price calculation means A menu preparation device equipped with output means. 2. A food material master file in which data on each food material is recorded, a food product master file in which data on each food product is recorded, each food material recorded in the food material master file, and recorded in the food product master file. A menu data creation means for creating a menu based on the data relating to each ingredient recorded in the ingredient master file, and a computer capable of referring to a tying master file in which data associating each ingredient product is recorded; By referring to the attachment master file, from the data relating to the menu created by the menu data creating means, the food product specifying means for specifying the food product corresponding to the food necessary for the menu and the food product specifying means are specified. By the price calculation means that calculates the menu price based on the food products and the price calculation means A menu creation program that functions as an output device that outputs the calculated menu price.