JP6929205B2 - Management system - Google Patents

Description

The present application relates to a management system for calculating the required amount of material.

In various fields, systems for managing materials necessary for providing products are known (see, for example, Patent Documents 1 and 2). Patent Document 1 discloses, for example, an inventory management system for managing foodstuffs in a restaurant. In this system, the standard inventory amount is predetermined for each ingredient. Then, the order of the food material is made by the method of replenishing the amount reduced from the standard inventory amount.

Patent Document 2 describes in order to manage the inventory of materials in an on-demand sales form store, in which production of a product for sale is started after receiving an order from a customer and the produced product is delivered to the customer. The system is disclosed. In this system, the maximum number of stocks, which is the maximum number that can be stored in the refrigerator of a store, is input for each material. The maximum number of stocks can be changed large or small depending on the amount of ingredients used in each season. Further, in this system, a reference value is input for each material. Then, when the remaining inventory quantity becomes smaller than the reference value, the material is ordered by the method of replenishing the inventory up to the maximum inventory quantity.

Japanese Patent No. 6074536 Japanese Unexamined Patent Publication No. 2014-13532

In the present technical field, it is desired to develop a system capable of predicting the required amount of material more accurately.

One aspect of the present disclosure is a management system for calculating the required amount of materials for a plurality of products, for the first storage unit for storing the selling unit price of each product and for providing each product once. A second storage unit that stores the amount of one or more materials used, a third storage unit that stores the number of sales of each product for each predetermined period in the past, a controller, and the like. With respect to the past period associated with the controller based on the unit selling price of each product stored in the first storage unit and the number of sales of each product stored in the third storage unit. Based on calculating the average value of the total sales of a plurality of products, the selling unit price of each product stored in the first storage unit, and the number of sales of each product stored in the third storage unit. , Calculate the sales ratio of each product to the total sales of multiple products for the associated past period, and for a period in the future, the average value of the total sales of the corresponding past period, the corresponding past Calculate the estimated sales of each product by multiplying the sales ratio of each product in the period, and divide the calculated estimated sales of each product by the selling unit price of each product stored in the first storage unit. By doing so, the estimated number of sales of each product in a certain period in the future is calculated, and the calculated estimated number of sales of each product is multiplied by the amount of material used for each product stored in the second storage unit. It is a system that is configured to calculate and execute the required amount of material for each commodity in a certain period of the future.

According to one aspect of the present disclosure, the sales ratio of each product to the total sales of a plurality of products is calculated for the associated past period (for example, the same day of the week in the past). For example, in a certain industry, if the days of the week are the same, the sales ratio of each product to the total sales of all products may be constant to some extent. Therefore, the sales ratio of each product calculated for the same day of the week in the past can be used as the sales ratio of the same day of the week in the future. In one aspect of the disclosure, for a period of the future, the average value of total sales for the corresponding past period is multiplied by the sales ratio of each product for the corresponding past period to make the projected sales of each product more accurate. Therefore, it is possible to predict the required amount of the material more accurately.

The plurality of products may be foods and drinks provided at a restaurant, and the plurality of products may include one or more all-you-can-eat products included in the all-you-can-eat menu. The first storage unit may include, as the sales unit price, a first unit price indicating an actual sales unit price and a second unit price indicating a virtual sales unit price. The first unit price may include zero as the selling unit price of the all-you-can-eat product, and the second unit price may include a value larger than zero as the selling unit price of the all-you-can-eat product. The controller may be configured to calculate the required amount of each ingredient, including the ingredients of the all-you-can-eat product, for a period of the future by using the second unit price as the unit selling price. According to this aspect, the required amount of each ingredient including the ingredient of the all-you-can-eat product can be automatically calculated.

The system may further include a fourth storage unit that stores the inventory amount of each material in a unit corresponding to the packing style of the inventory. The controller multiplies the amount of material used for each product stored in the second storage by the number of products sold for the desired period stored in the third storage, thereby multiplying each material in the desired period. The stock amount of each material is updated by calculating the payout amount of each material and reducing the payout amount of each material in the desired period from the stock amount of each material in the desired period stored in the fourth storage unit. And may be configured to do more. According to this aspect, the inventory amount of each material can be automatically updated.

The plurality of products may include one or more prepared products that can be prepared in advance in an amount used for a plurality of servings. When the controller reduces the stock of each material of the stocked product due to something other than sales, the inventory of each material of the stocked product is reduced by reducing the amount of reduction of each material of the stocked product from the stock amount of each material stored in the fourth storage unit. It may be configured to update the quantity. In this case, the inventory amount of each material of the stocked product is updated when the stocked product is actually sold and when the stocked product is reduced due to non-sales. Therefore, the inventory amount of each material of the prepared product can be updated based on the current situation.

The controller now calculates the order quantity of each material based on the inventory quantity of each material stored in the fourth storage unit and the required quantity of the material of each product in the calculated future period. It may be configured. According to this aspect, the order quantity of each material can be automatically calculated.

The system may further include a fifth storage unit that stores the unit according to the packing style of the inventory of each material and the unit according to the packing style at the time of purchasing each material in association with each other. The controller may be configured to calculate the order quantity of each material in a unit corresponding to the packing style at the time of purchase stored in the fifth storage unit. According to this aspect, since the ordered quantity of each material is calculated in a unit corresponding to the packing style at the time of purchase, it is possible to prevent erroneous delivery of a larger quantity or a smaller quantity of the material.

The system may further include a sixth storage unit that stores ordering categories indicating how to order each material. The ordering category may include fixed point automatic ordering, in which the material is ordered when the inventory of the material is expected to be below the fixed point. An order is required when the value obtained by subtracting the calculated required amount for a certain period in the future from the inventory amount stored in the fourth storage unit for the material corresponding to the fixed point automatic ordering is less than the fixed point. It may be configured to judge that. For example, it is desirable to order seasonings or beverages provided in small amounts (for example, shochu, etc.) when the inventory amount is expected to fall below a predetermined fixed point.

The system may further include a seventh storage unit that stores information about one or more suppliers of each material. The controller may be configured to calculate the order quantity of each material for each supplier stored in the seventh storage unit. According to this aspect, since the order quantity of each material is calculated for each supplier, it is not necessary for the operator, the employee, or the like to allocate the order quantity of each material to each supplier.

The system may further include an eighth storage unit that stores a first adjustment value for adjusting the average value of total sales for each predetermined period in the future. For a certain period in the future, the average value of the total sales of the corresponding past period, the first adjustment value of the corresponding past period stored in the eighth storage unit, and each of the corresponding past periods. It may be configured to calculate the forecast sales of each product by multiplying the sales ratio of the products. For example, total sales on a particular day (eg, a holiday, or the day a particular event takes place) are expected to be higher than total sales on other same days. Therefore, by using the first adjustment value, the total sales can be predicted more accurately.

The system may further include a ninth storage unit that stores the minimum sellable amount for each product over a predetermined period of time. The controller is configured to replace the estimated sales volume with the minimum sales volume when the estimated sales volume of a certain product in a certain future period is less than the minimum sales volume stored in the ninth storage unit. It may have been done. If the calculated estimated number of sales of a certain product is not feasible, it is assumed that this product cannot be offered. Therefore, it is possible to ensure that this product is offered by replacing the estimated number of sales of this product with the minimum sellable quantity.

If there is no payout data for the desired period, the controller will respond to the average of the total sales for the corresponding past period for the desired period for which there is no payout data. By multiplying the sales ratio of each product in the period to calculate the alternative sales of each product, and by dividing the alternative sales of each product by the sales unit price of each product stored in the first storage unit, By calculating the number of alternative sales of each product and multiplying the amount of material used for each product stored in the second storage unit by the number of alternative sales of each product, the alternative payout amount of each material is calculated. It is configured to further execute that, and update the stock amount of each material by reducing the substitute payout amount of each material from the stock amount of each material stored in the fourth storage unit. You may. In this case, for example, the inventory amount of each material can be updated even when the cash register is not closed the day before at the target store.

According to one aspect of the present disclosure, it is possible to provide a system capable of more accurately predicting the required amount of material.

It is a schematic block diagram of the management system which concerns on embodiment. An example of POS data is shown. An example of the menu unit price master is shown. An example of the recipe composition master is shown. An example of a sales table is shown. An example of the inventory table is shown. An example of a sales index table is shown. An example of the sales ratio table is shown. An example of the menu number table is shown. An example of the operation for creating the sales table is shown. An example of the operation for creating the menu output table is shown. An example of the operation for inventory update is shown. An example of the operation for outputting the order data of the automatic order is shown. An example of the operation for outputting the order data of the fixed point automatic order is shown.

Hereinafter, the management system according to the embodiment will be described with reference to the attached drawings.

FIG. 1 is a schematic block diagram of a management system according to an embodiment. With reference to FIG. 1, the management system 100 according to the present disclosure is applied to, for example, a restaurant. The management system 100 is configured to manage sales at a restaurant, inventory of materials, ordering of materials, and the like. The management system 100 may be applied to industries other than restaurants (for example, take-out / delivery restaurant service industry or retail industry).

The management system 100 may include a POS server (first device) 10, a management server (second device) 20, and a management client (third device) 30. The system 100 may further include other components. The POS server 10, the management server 20, and the management client 30 are connected to each other via the network 40. The network 40 can be, for example, the Internet, WiFi®, Bluetooth®, or any other communication method, or any combination thereof, and can be wired or wireless.

The POS server 10 can be, for example, a server that manages data of a plurality of stores when the restaurant is a chain store. In this case, the POS server 10 can be installed at an arbitrary location such as the head office, and can communicate with the terminal device (not shown) of each store. The POS server 10 can also be applied to restaurants other than chain stores.

The POS server 10 includes, for example, a storage device 11, a controller 12, and an interface device 13, and these components are connected to each other via a bus (not shown) or the like. The POS server 10 may include other components (not shown) such as a display device and an input device, for example.

The storage device 11 may be, for example, one or more hard disk drives. The storage device 11 stores the POS data 11a. For example, when the POS server 10 manages the data of a plurality of chain stores, the storage device 11 can store the POS data 11a of the plurality of stores. The storage device 11 may store data other than the POS data 11a.

The controller 12 is configured to control each component of the POS server 10. The controller 12 can be, for example, a CPU (Central Processing unit) or the like. A ROM (read only memory) (not shown), a RAM (random access memory) (not shown), or the like may be connected to the controller 12. The controller 12 may be composed of, for example, one CPU, or may be composed of a plurality of CPUs. The interface device 13 is configured to connect to the network 40.

The management server 20 can be installed at any location, such as the management company of the management system 100. The management server 20 may be controlled by, for example, the management client 30. The management server 20 includes, for example, a storage device 21, a controller 22, and an interface device 23, and these components are connected to each other via a bus (not shown) or the like. The management server 20 may include other components (not shown) such as a display device and an input device, for example.

The storage device 21 may be, for example, one or more hard disk drives. The storage device 21 stores various tables and masters (master data).

The POS table 21a stores the POS data 11a of each store received from the POS server 10, for example, on a daily basis. If necessary, the POS data 11a received from the POS server 10 may be converted into a usable format by the management server 20 and then stored in the POS table 21a. The storage device 21 may store a master (not shown) required for format conversion.

FIG. 2 shows an example of POS data. The POS data 11a contains items such as a store code for identifying each store, a sales date, a product code for identifying each product, a product name, a unit price (actual sales unit price), and the number of sales. include. The POS data shown in FIG. 2 is only an example, and the POS data may not have one or more of the items shown in FIG. 2 and / or one not shown in FIG. Alternatively, it may have a plurality of other items.

As shown in FIG. 2, in the present embodiment, the provided products include all-you-can-eat products included in the all-you-can-eat menu. The POS data includes, for example, an all-you-can-eat unit price (for example, 3000 yen). The POS data includes 0 yen as the unit price of each all-you-can-eat product. The all-you-can-eat menu may be provided, for example, in a table order format, so that the POS data can include the number of sales of each all-you-can-eat product.

In addition, the provided product may include a prepared product (for example, soup or simmered dish) in which an amount used for a plurality of servings can be prepared (cooked) in advance. For example, one or more of the pickles 1 to 3 may be prepared products. In addition, the provided product may include one or more beverages.

With reference to FIG. 1, the menu unit price master (first storage unit) 21b stores the sales unit price of each product.

FIG. 3 shows an example of the menu unit price master. The menu unit price master 21b includes, for example, a store code and a product code. Further, the menu unit price master 21b includes a first unit price P1 and a second unit price P2 as sales unit prices. It is understood that the first unit price P1 indicates the actual sales unit price, and therefore, the first unit price P1 shown in FIG. 3 and the unit price included in the POS data 11a shown in FIG. 2 match. Will be done. With reference to FIG. 3, the second unit price P2 indicates a virtual unit price (unit price for calculation). As shown in FIG. 3, the second unit price P2 of each all-you-can-eat product is set to a value larger than zero.

The second unit price P2 of each all-you-can-eat product may be set to, for example, the first unit price P1 of the same product provided as a normal product, or may be set to another value. For example, the second unit price P2 of "pickles 1 (all-you-can-eat)" may be set to the first unit price P1 "520 yen" of the same product "pickles 1" provided as a normal product. The second unit price P2 of each all-you-can-eat product is when there is no same product offered as a regular product (for example, when the quality is different between the all-you-can-eat product and the regular product, or the same food and drink as the all-you-can-eat product is usually used. If not as a product, etc.), it can be set to any value greater than zero.

The second unit price P2 of each normal product may be set to, for example, the first unit price P1 of the same product, or may be set to another value. For example, the second unit price P2 of the regular product "pickles 1" may be set to "520 yen", which is the same as the first unit price P1.

With reference to FIG. 1, the recipe configuration master (second storage unit) 21c stores the amount of one or more ingredients used for one serving of each product.

FIG. 4 shows an example of the recipe composition master. As shown in FIG. 4, the recipe configuration master 21c is, for example, a product code, a material code for identifying a material, a usage amount of each material, and a usage unit for identifying a unit of the usage amount of each material. Includes items such as code. In FIG. 4, as an example, the amount of the material used for providing the product of the product code 300 is shown. The product of product code 300 contains, for example, 10 kinds of ingredients, and the amount of each ingredient used is stored in the recipe composition master 21c. The storage device 21 may include a unit master (not shown) that stores the unit indicated by each used unit code. In the recipe composition master 21c, only one material may be stored as a material used for providing each product. For example, if a particular vegetable is offered as a commodity, the material for this vegetable can be the vegetable itself. In this case, only one ingredient can be stored in the recipe composition master 21c as the ingredient of this vegetable. Further, for example, when a beverage is provided as a product, the material of the beverage may be the beverage itself. In this case, only one ingredient can be stored in the recipe composition master 21c as a beverage ingredient.

With reference to FIG. 1, the sales table (third storage unit) 21d stores the number of sales of each product for each predetermined period (for example, every day). The sales table 21d includes data extracted from the POS data of the POS table 21a.

FIG. 5 shows an example of a sales table. As shown in FIG. 5, the sales table 21d includes items such as a sales date, a store code, a product code, a sales unit price (for example, a second unit price P2), and the number of sales. Here, the all-you-can-eat product can be considered by storing the second unit price P2 as the sales unit price in the sales table 21d.

With reference to FIG. 1, the inventory table (fourth storage unit) 21e stores the inventory amount of each material in a unit corresponding to the packing style of the inventory.

FIG. 6 shows an example of an inventory table. As shown in FIG. 6, the inventory table 21e has, for example, a store code, a material code for identifying each material, a quantity (inventory quantity), a final purchase date of each material, a final payout date of each material, and , The last inventory adjustment date of each material (eg, the date the inventory was taken), and so on. The unit used in the inventory table 21e is stored in, for example, the product expansion master 21f.

With reference to FIG. 1, the product expansion master (fifth storage unit) 21f associates a unit according to the packing style of the inventory of each material with a unit corresponding to the packing style at the time of purchasing each material. Remember.

The ordering classification master (sixth storage unit) 21g stores an ordering classification indicating an ordering method for each material. The ordering category may include, for example, automatic ordering and fixed point automatic ordering. The automatic ordering indicates a method of automatically ordering the calculated amount of materials by the management system 100.

The fixed point automatic ordering refers to a method of automatically ordering materials by the management system 100 when the inventory amount of materials is predicted to be lower than a predetermined fixed point. For example, when one bottle of a certain seasoning (material) contains 1 liter, the fixed point can be set to, for example, 0.3 liter. In this case, when the stock of the seasoning is 0.7 liters and the calculated required amount of the seasoning is 0.2 liters, the predicted stock amount of the material is 0.7-0.2 = 0. Since 5.5 liters is not expected to fall below the fixed point of 0.3 liters, the seasoning will not be ordered. On the other hand, when the stock of the seasoning is 0.7 liters and the calculated required amount of the seasoning is 0.5 liter, the predicted stock amount of the material is 0.7-0.5 = 0. Since 2 liters is expected to be below the fixed point of 0.3 liters, the seasoning is ordered. In addition, the material corresponding to the fixed point automatic ordering is not limited to the seasoning, and the above numerical values are merely examples. The order classification master 21g may store yet another order classification (for example, manual ordering). Manual ordering refers to a method in which a restaurant employee, an operator, or the like manually places an order for a calculated order quantity or an arbitrary order quantity.

The business partner master (seventh storage unit) 21h stores information on one or more suppliers of each material. The supplier information includes, for example, the supplier name, the supplier code for identifying the supplier, the supplier's orderable date (and / or the supplier's holiday), and the supplier's order deadline. Etc. may be included.

The store payout table 21i stores the payout amount of each material for a predetermined period (for example, one day). The payout amount of each material is based on, for example, the usage amount of each material of each product stored in the recipe composition master 21c and the number of sales of each product for each predetermined period stored in the sales table 21d. Can be calculated.

The store purchase table 21j stores the delivery amount of each material delivered to each store during a predetermined period (for example, the previous day or the period from the morning of the previous day to the morning of the current day). The delivery quantity of each material may be automatically entered by the management system 100 based on, for example, the corresponding ordering data when the delivery quantity is ordered, or by the employee or based on the actual delivery quantity. It may be manually input by an operator or the like via a terminal device (not shown) of each store.

The store inventory adjustment table 21k can be used to adjust the inventory amount of each material. For example, when inventory is carried out, it can be obtained by manually inputting the obtained actual inventory amount or the adjustment value based on the obtained actual inventory amount into the store inventory adjustment table 21k. The actual inventory amount can be reflected in the inventory table 21e. In addition, for example, when the stocked product decreases due to something other than sales (for example, when it is consumed by an employee as a meal, and / or when it is discarded without being sold, etc.), each material of the stocked product By manually inputting the reduction amount into the store inventory adjustment table 21k, the reduction amount of each material of the purchased product can be reflected in the inventory table 21e. Also, when material is moved between multiple stores (for example, when material is moved from another store due to material shortage), the amount of moved material is manually transferred to the store inventory adjustment table 21k. By inputting, the increase / decrease amount of the material due to the movement can be reflected in the inventory table 21e.

The sales index table (eighth storage unit) 21m stores the first adjustment value. The first adjustment value is the average value of the total sales of all products calculated for the associated past period (for example, the same day of the week), and the total of all products for a certain period in the future (for example, one day). It is a value to be adjusted as a forecast value of sales.

FIG. 7 shows an example of a sales index table. With reference to FIG. 7, the sales index table 21m includes, for example, a (future) sales date, a store code, and an index (first adjustment). For example, as shown in FIG. 7, January 1, 2018 is a Monday, which is a Japanese holiday. Therefore, it can be expected that sales will increase (eg, sales will increase to 150% of total sales on regular Mondays) compared to regular Mondays. In this case, by setting the index for January 1, 2018 to 150%, the forecast value for total sales for that day can be set to 150% of the average value of total sales calculated for past Mondays. can. The index may be manually entered by, for example, an employee, an operator, or the like via a terminal device (not shown) of each store. In addition, if there is no input, 100% may be used as the index (that is, the average value of the total sales calculated for the same day of the week in the past is directly used as the predicted value of the total sales of a certain day in the future. May be).

With reference to FIG. 1, the sales budget table 21n is shown in FIG. 7 with the forecast value of the above future total sales (ie, the average value of the total sales of all commodities calculated for the associated past period). The exponent and the value obtained by multiplying it) are memorized.

The sales ratio table 21o stores the sales ratio (sales composition) of each product to the total sales of the associated past period (for example, the same day of the week in the past).

FIG. 8 shows an example of a sales ratio table. With reference to FIG. 8, the sales ratio table shows, for example, the (future) sales date, the store code, the product code, the sales t1 of each product on the same day of the past for multiple times (for example, 7 times), and. Includes the total sales t2 of all products on the same day of the past for multiple times (for example, 7 times). If the past data of a certain day of the week exists for only one day, the sales t1 and the total sales t2 may include the data for one day of the day. By dividing the sales t1 of each product by the total sales t2, the sales ratio of each product to the total sales can be calculated. Here, a virtual second unit price P2 is used for calculating the sales t1 and the total sales t2, and therefore, the sales ratio of each product including the all-you-can-eat product is calculated.

The menu buffer master (9th storage unit) 21q stores the number of buffers and the minimum sellable amount in a predetermined period (for example, one day) for each product. The number of buffers is added to the calculated estimated number of sales of each product to prevent shortages. The minimum sellable amount is a value (for example, 1 or more) for correcting the estimated sales number of a product to a feasible number when the calculated estimated sales number of a certain product is not feasible (for example, less than 1). Is.

The menu number table 21r stores the estimated number of sales of each product in a certain future period (for example, one day) finally determined.

FIG. 9 shows an example of the menu number table. As shown in FIG. 9, the menu appearance number table 21r is, for example, a (future) sales date, a store code, a product code, a forecast sales number n2 (final value), and a forecast sales number n1 (calculated value). , Number of buffers, and minimum sellable quantity, etc. The predicted sales number n1 is a calculated value calculated based on the average value of the total sales of all products, the sales ratio of each product, and the second unit price P2 of each product, and further includes the number of buffers. Further, when the predicted sales number n1 is less than the minimum sellable amount, the predicted sales number n1 is replaced with the minimum sellable amount. The estimated sales number n2 is the final value used for calculating the order quantity. If it is desired to individually adjust the calculated estimated sales number n1 of each product for a certain period in the future (for example, one day), an arbitrary value can be input to the estimated sales number n2. For example, sales of a particular product (eg, liquor) on a particular day (eg, a holiday, or the day a particular event takes place) are expected to be higher than sales on other same days of the week. Therefore, when it is desired to individually adjust the calculated predicted sales number n1 of each product, it is possible to adjust the predicted sales number of each product by inputting a desired value in the predicted sales number n2. For example, as shown in FIG. 9, since it is predicted that the product of the product code 402 will sell a lot, the predicted sales number n2 of the product of the product code 402 is changed from 14 to 20 of the predicted sales number n1. has been changed. The value to the predicted sales number n2 may be manually input by, for example, an employee, an operator, or the like via a terminal device (not shown) of each store. When there is no manual input to the forecast sales number n2, the calculated value of the forecast sales number n1 is automatically input to the forecast sales number n2 as it is, as shown in FIG.

With reference to FIG. 1, the ordering category detail master 21s stores a fixed point for each product having a fixed point automatic ordering as an ordering category. The ordering category detail master 21s may store fixed points of each product for each day of the week, for example.

The storage device 21 may include any other data, including other tables and / or masters other than the above tables and masters. Further, the tables and masters shown in FIGS. 3 to 9 are merely examples, and each table and master may not have, for example, one or more of the items shown in FIGS. 3 to 9. And / or may have one or more other items not shown in FIGS. 3-9.

The controller 22 is configured to control each component of the management server 20. The controller 22 can be, for example, a CPU or the like. A ROM (not shown), a RAM (not shown), or the like may be connected to the controller 22. The controller 22 is configured to execute a plurality of processes shown below, and a program for executing each process is stored in the above ROM or the like. The controller 22 may be composed of one CPU, or may be composed of a plurality of CPUs. The interface device 23 is configured to connect to the network 40.

The management client 30 includes, for example, a storage device 31, a controller 32, an interface device 33, an input device 34, and a display device 35, and these components include a bus (not shown) or the like. They are connected to each other via. The management client 30 may include, for example, other components (not shown).

The storage device 31 may be, for example, one or more hard disk drives. The controller 32 is configured to control each component of the management client 30. The controller 32 can be, for example, a CPU or the like. A ROM (not shown), a RAM (not shown), or the like may be connected to the controller 32. The controller 32 may be composed of, for example, one CPU, or may be composed of a plurality of CPUs. The interface device 33 is configured to connect to the network 40. The input device 34 may be, for example, a keyboard, a mouse, and / or a touch panel. The display device 35 may be, for example, a liquid crystal display or the like.

Next, the operation of the management system 100 will be described. First, the creation of the sales table will be described.

FIG. 10 shows an example of the operation for creating the sales table. With reference to FIG. 10, first, the controller 22 of the management server 20 accesses the POS server 10 and acquires the POS data 11a stored in the storage device 11 (step S100). The controller 22 may access the POS server 10 at a predetermined date and time (for example, a predetermined time every day). In step S100, the controller 22 acquires the POS data 11a for each store.

Subsequently, the controller 22 converts the acquired POS data 11a into a format that can be used by the management server 20 (step S102). In step S102, the controller 22 stores the converted POS data in the POS table 21a at predetermined periods (for example, every day) for each store.

Subsequently, the controller 22 creates the sales table 21d based on the POS data stored in the POS table 21a and the menu unit price master 21b (step S104). The sales table 21d stores, for example, the number of sales of each product for each predetermined period (for example, every day) and the second unit price P2 as the sales unit price. Then, the controller 22 ends a series of operations.

Next, the creation of the menu number table will be described.

FIG. 11 shows an example of the operation for creating the menu output number table. The controller 22 may create a menu number table at a predetermined date and time (for example, a predetermined time every day). With reference to FIG. 11, the controller 22 first creates a sales budget table 21n for a future period (eg, 6 days later) (step S200).

Specifically, the controller 22 describes the corresponding past period (for example, the same day of the week) based on the data (second unit price P2 of each product and the number of sales) stored in the sales table 21d. Calculate the average value of the total sales of all products. The average value of total sales is, for example, multiplied by the second unit price P2 of each product and the number of sales for a plurality of corresponding past periods, sum all the obtained values, and correspond to the total value. It can be calculated by dividing by the number of times in the past period. When data for only one day is stored in the sales table 21d for a certain day of the week, the total sales for that day may be directly used as the average value of the total sales for a certain day of the week.

The controller 22 multiplies the calculated average value of the total sales of all products by the index (first adjustment value) (see FIG. 7) stored in the sales index table 21m, thereby performing a certain period in the future. The forecast value of the total sales in the above is calculated, and the sales budget table 21n is created.

Next, the controller 22 creates the sales ratio table 21o (step S202). Specifically, the controller 22 describes the associated past period (for example, the same day of the week) based on the data (second unit price P2 of each product and the number of sales) stored in the sales table 21d. , Calculate the sales ratio (sales composition) of each product to the total sales of all products. The sales ratio of each product can be obtained, for example, by dividing the sales t1 of each product by the total sales t2 of all products for one or a plurality of corresponding past periods (see FIG. 8).

Next, the controller 22 creates the menu output number table 21r (step S204). Specifically, the controller 22 multiplies the predicted value of the total sales in a certain future period stored in the sales budget table 21n by the sales ratio of each product calculated based on the sales ratio table 21o. Calculate the forecast sales for each product. Then, the controller 22 divides the calculated estimated sales of each product by the second unit price P2 of each product stored in the menu unit price master 21b, and stores the obtained value in the menu buffer master 21q. By adding the number of buffers of each product, the estimated sales number n1 (calculated value) of each product in a certain future period is calculated. When the estimated sales number n1 is less than the minimum sellable amount stored in the menu buffer master 21q, the controller 22 replaces the predicted sales number n1 with the minimum sellable amount. The controller 22 inputs the value of the forecast sales number n1 into the forecast sales number n2. Then, the controller 22 ends a series of operations. In the management system 100, after the menu number table 21r is created, the predicted sales number n2 of the menu number table 21r can be manually rewritten to an arbitrary value by an employee, an operator, or the like. The management system 100 may have a master (not shown) that stores a rewritable deadline date and time.

Next, inventory update will be described.

FIG. 12 shows an example of the operation for inventory update. The controller 22 may update the inventory at a predetermined date and time (for example, a predetermined time every day). With reference to FIG. 12, the controller 22 first creates the store payout table 21i (step S300). Specifically, the controller 22 uses the ingredients of each product stored in the recipe configuration master 21c for a desired period (for example, the previous day or one day in the past) stored in the sales table 21d. By multiplying the number of sales of each product, the payout amount of each material in a desired period is calculated, and the store payout table 21i is created. For example, if the previous day is a holiday of the target store, the amount of each material paid out the day before yesterday may be calculated using the number of products sold the day before yesterday.

Subsequently, the controller 22 determines whether or not recovery of the payout amount is necessary (step S302). Specifically, the controller 22 determines, for example, whether or not one or more data of the payout amount for a desired period exists in the store payout table 21i. When it is determined that there is no payout amount data, the controller 22 further determines whether or not the desired period is a holiday of the target store. At the time of this determination, the controller 22 may refer to, for example, a holiday master (not shown) in which the holidays of the store are stored. If it is determined that the desired period is not a holiday of the target store, the controller 22 determines that the payout amount needs to be recovered, and proceeds to step S304. The case where it is determined that the payout amount needs to be recovered includes, for example, the case where the cash register is not closed the day before at the target store. If it is determined that the payout amount recovery is unnecessary, the controller 22 proceeds to step S306.

In step S304, the controller 22 performs payout amount recovery. Specifically, the controller 22 is the average value of the total sales of all products in the corresponding past period (for example, the same day of the past) for a desired period (for example, the previous day) in which no payout amount data exists. Is multiplied by the sales ratio of each product in the corresponding past period to calculate the alternative sales of each product. The average value of the total sales of all products in the corresponding past period can be calculated in the same manner as in step S200 (see FIG. 11) described above. Further, the sales ratio of each product in the corresponding past period can be calculated in the same manner as in step S202 (FIG. 11) described above.

The controller 22 calculates the number of alternative sales of each product by dividing the calculated alternative sales of each product by the second unit price P2 of each product stored in the menu unit price master 21b. The controller 22 calculates the substitute payout amount of each material by multiplying the calculated substitute sales number of each product by the usage amount of the material of each product stored in the recipe configuration master 21c. The controller 22 stores the alternative payout amount of each material in the store payout table 21i. Then, the controller 22 proceeds to step S306.

Subsequently, the controller 22 creates the store purchase table 21j in step S306. Specifically, the controller 22 automatically acquires the delivery amount of each material based on, for example, the corresponding order data when the delivery is ordered, and creates the store purchase table 21j.

Subsequently, the controller 22 updates the inventory (step S308). Specifically, the controller 22 subtracts the payout amount (or alternative payout amount) of each material stored in the store payout table 21i from the inventory amount of each material stored in the inventory table 21e, and also stores. The inventory of each material is updated by adding the delivery amount of each material stored in the purchase table 21j. Further, in step S308, the controller 22 refers to the store inventory adjustment table 21k to perform inventory, transfer of materials between a plurality of stores, and / or a decrease due to other than the sale of each material of the prepared product. , Can be reflected in the inventory of each material. Then, the controller 22 ends a series of operations. For example, when materials are moved between a plurality of stores, if an employee or operator forgets to enter the increase / decrease amount of the moved materials in the store inventory adjustment table 21k, a negative value is inventories. It can be stored in the table 21e. In this case, in the following output of the order data for automatic ordering and the output of order data for fixed point automatic ordering, the controller 22 can use zero instead of a negative value.

Next, the output of order data for automatic ordering will be described.

FIG. 13 shows an example of an operation for outputting order data for automatic ordering. The controller 22 may execute the automatic ordering at a predetermined date and time (for example, a predetermined time every day). The controller 22 refers to the order classification master 21g and executes the process shown in FIG. 13 for the material whose order classification is automatic ordering.

With reference to FIG. 13, the controller 22 first outputs order data for automatic ordering (step S400). Specifically, the controller 22 refers to the recipe configuration master 21c and identifies one or more products including the target material. The controller 22 multiplies the predicted sales number n2 stored in the menu number table 21r and the usage amount of the target material stored in the recipe composition master 21c for the specified one or more products. , Calculate the required amount of material for each product in a certain period in the future. The controller 22 takes into consideration, for example, a supplier's orderable date (and / or a supplier's holiday) and an order deadline time stored in the supplier master 21h, for one day in the future (for example, for example. You may calculate the required amount of material for the next day or a few days later) or for multiple days in the future. The controller 22 calculates the order data for each material based on the calculated total required amount of each material and the inventory of each material stored in the inventory table 21e. At this time, the controller 22 refers to the product expansion master 21f and calculates the order quantity of each material in a unit corresponding to the packing style at the time of purchase stored in the product expansion master 21f.

Subsequently, the controller 22 creates an import file for each store (step S402). Specifically, the controller 22 stores the calculated order quantity of each material in the file for each supplier stored in the business partner master 21h. Then, the controller 22 ends a series of operations.

Next, the output of order data for fixed-point automatic ordering will be described.

FIG. 14 shows an example of an operation for outputting order data for fixed-point automatic ordering. The controller 22 may execute fixed-point automatic ordering at a predetermined date and time (for example, a predetermined time every day). The controller 22 refers to the order classification master 21g and executes the process shown in FIG. 14 for the material whose order classification is fixed point automatic ordering.

With reference to FIG. 14, the controller 22 first determines whether or not the inventory amount of the target material is below the fixed point (step S500). Specifically, the controller 22 refers to the recipe configuration master 21c and identifies one or more products including the target material. The controller 22 multiplies the predicted sales number n2 stored in the menu number table 21r and the usage amount of the target material stored in the recipe composition master 21c for the specified one or more products. , Calculate the required amount of material for each product in a certain period in the future. The controller 22 takes into consideration, for example, a supplier's orderable date (and / or a supplier's holiday) and an order deadline time stored in the supplier master 21h, for one day in the future (for example, for example. You may calculate the required amount of material for the next day or a few days later) or for multiple days in the future. In the controller 22, the value obtained by subtracting the calculated total required amount of each material from the inventory amount of each material stored in the inventory table 21e corresponds to each material stored in the order category detail master 21s. Determine if it is below the fixed point on the day of the week. When it is determined that the inventory amount of the target material is below the fixed point, the controller 22 proceeds to step S502. When it is determined that the inventory amount of the target material does not fall below the fixed point, the controller 22 ends the operation.

In step S502, the controller 22 outputs order data for fixed point automatic ordering. At this time, the controller 22 refers to the product expansion master 21f and calculates the order quantity of each material in a unit corresponding to the packing style at the time of purchase stored in the product expansion master 21f.

Subsequently, the controller 22 creates an import file for each store (step S504). Specifically, the controller 22 stores the calculated order quantity of each material in the file for each supplier stored in the business partner master 21h. Then, the controller 22 ends a series of operations.

With respect to the above processing executed by the controller 22, the capture file for automatic ordering and the capture file for fixed-point automatic ordering may be imported into another system for ordering, for example. In addition, either one of the creation of the menu number table and the update of the inventory may be performed first, or these processes may be performed in parallel. Further, while the controller 22 is executing the steps shown in FIGS. 10 to 14, it is determined so that the employee, the operator, or the like does not update the data stored in the POS server 10 and / or the management server 20. Access to the components of may be restricted.

In the management system 100 of the above embodiment, the sales ratio of each product to the total sales of a plurality of products is calculated for the associated past period (for example, the same day of the week in the past). For example, in a certain industry (for example, a specific restaurant), if the days of the week are the same, the sales ratio of each product to the total sales may be constant to some extent. Therefore, the sales ratio of each product calculated for the same day of the week in the past can be used as the sales ratio of the same day of the week in the future. In the management system 100, for a certain future period, the forecast sales of each product can be calculated more accurately by multiplying the average value of the total sales of the corresponding past period by the sales ratio of each product. Therefore, it is possible to predict the required amount of the material more accurately.

Further, in the management system 100, the required amount of each material is automatically predicted based on the number of sales of each product in the corresponding past period, so that the burden on the operator can be reduced. In contrast, for example, in the system of Patent Document 1 described above, the ordering of foodstuffs is performed by a method of replenishing the amount reduced from the standard inventory amount. In order to reflect the daily changing sales trend, it is necessary to periodically reset an appropriate standard inventory amount, and therefore, the system of Patent Document 1 may cause a burden on the operator.

Further, in the management system 100, as described above, for example, when the past data of a certain day of the week exists only for one day, it is possible to calculate the required amount of each material using the data for one day of the day. Therefore, it may be suitable for reflecting short-term (for example, by day of the week) sales trends. In contrast, for example, in the system of Patent Document 2 described above, when the remaining stock quantity becomes smaller than the reference value, the stock is replenished up to the maximum stock quantity, and the maximum stock quantity is set. , It can be changed large or small depending on the amount of ingredients used in each season. However, it is necessary to acquire annual inventory fluctuations in order to obtain seasonal sales trends, and therefore the period for acquiring data is long. Therefore, the system of Patent Document 2 may not be useful for reflecting short-term (for example, day of the week) sales trends.

Further, in the management system 100, the product is a food or drink provided at a restaurant and includes one or more all-you-can-eat products included in the all-you-can-eat menu. The menu unit price master 21b includes, as the sales unit price, a first unit price P1 indicating an actual sales unit price and a second unit price P2 indicating a virtual sales unit price. The first unit price P1 includes zero as the selling unit price of the all-you-can-eat product, and the second unit price P2 includes any value larger than zero as the selling unit price of the all-you-can-eat product. The controller 22 is configured to calculate the required amount of each material including the material of the all-you-can-eat product in a certain period in the future by using the second unit price P2 as the selling unit price. Therefore, the management system 100 can automatically calculate the required amount of each material including the material of the all-you-can-eat product.

Further, the management system 100 includes an inventory table 21e that stores the inventory amount of each material in a unit corresponding to the packing style of the inventory. The controller 22 pays out each material in a desired period by multiplying the usage amount of the material of each product stored in the recipe configuration master 21c by the number of sales of each product in the desired period stored in the sales table 21d. To update the inventory amount of each material by calculating the amount and subtracting the payout amount of each material in the desired period from the inventory amount of each material in the desired period stored in the inventory table 21e. Is configured to run. Therefore, in the management system 100, the inventory amount of each material can be automatically updated.

Further, in the management system 100, the product may include one or more prepared products that can be prepared in advance in an amount used for a plurality of provisions. The controller 22 reduces the amount of decrease in each material of the charged product from the amount of stock of each material stored in the inventory table 21e when the stocked product decreases due to something other than sales, thereby reducing the amount of stock of each material of the charged product. Is configured to update. Therefore, in the management system 100, when the inventory amount of each material of the prepared product is reduced by other than the sale (for example, it is consumed by the employee as a meal) in addition to the time when the charged product is actually sold. And / or if it is discarded without being sold, etc.). Therefore, in the management system 100, the inventory amount of each material of the charged product can be updated based on the current situation.

Further, in the management system 100, the controller 22 orders each material based on the inventory amount of each material stored in the inventory table 21e and the calculated material requirement amount of each product in a certain period in the future. It is configured to calculate the quantity. Therefore, the management system 100 can automatically calculate the order quantity of each material.

Further, the management system 100 includes a product expansion master 21f that stores a unit according to the packing style of the inventory of each material and a unit according to the packing style at the time of purchasing each material in association with each other. The controller 22 is configured to calculate the order quantity of each material in a unit corresponding to the packing style at the time of purchase stored in the product expansion master 21f. Therefore, in the management system 100, since the order quantity of each material is calculated in a unit corresponding to the packing style at the time of purchase, it is possible to prevent a larger quantity or a smaller quantity of materials from being delivered by mistake. ..

Further, the management system 100 includes an ordering division master 21g that stores an ordering division indicating an ordering method for each material. The ordering category includes fixed point automatic ordering, in which the material is ordered when the inventory of the material is expected to be below the fixed point. The controller 22 needs to place an order when the value obtained by subtracting the calculated required amount in a certain future period from the inventory amount stored in the inventory table 21e for the material corresponding to the fixed point automatic ordering is less than the fixed point. It is configured to judge. Therefore, in the management system 100, for example, seasonings or beverages provided in small amounts can be ordered when the inventory amount is expected to fall below a predetermined fixed point.

Further, the management system 100 includes a business partner master 21h that stores information on one or more suppliers of each material. The controller 22 is configured to calculate the order quantity of each material for each supplier stored in the business partner master 21h. Therefore, in the management system 100, since the order quantity of each material is calculated for each supplier, it is not necessary for the operator, the employee, or the like to allocate the order quantity of each material to each supplier.

In addition, the management system 100 includes a sales index table 21m that stores a first adjustment value for adjusting the average value of total sales for each predetermined period in the future. The controller 22 sets the average value of the total sales of the corresponding past period, the first adjustment value of the future period stored in the sales index table 21m, and each of the corresponding past periods for a certain period in the future. It is configured to calculate the forecast sales of each product by multiplying it by the sales ratio of the products. For example, total sales on a particular day (eg, a holiday, or the day a particular event takes place) are expected to be higher than total sales on other same days. Therefore, by using the first adjustment value, the total sales can be predicted more accurately.

Further, the management system 100 includes a menu buffer master 21q that stores the minimum sellable amount in a predetermined period for each product. The controller 22 is configured to replace the predicted sales quantity with the minimum sellable quantity when the calculated estimated sales quantity of a certain product in a certain future period is lower than the minimum sellable quantity stored in the menu buffer master 21q. Has been done. If the calculated estimated number of sales of a certain product is not feasible (for example, if the estimated number of sales is less than 1), it is assumed that this product cannot be provided. Therefore, in the management system 100, it is possible to ensure that the product is provided by replacing the predicted sales quantity of the product with the minimum sellable amount.

Further, in the management system 100, when there is no data of the payout amount in the desired period, the controller 22 determines the total sales of the corresponding past period for the desired period in which there is no data of the payout amount. By multiplying the average value by the sales ratio of each product in the corresponding past period, the alternative sales of each product are calculated, and the alternative sales of each product are the sales of each product stored in the menu unit price master 21b. By dividing by the unit price, the number of alternative sales of each product is calculated, and by multiplying the amount of material used for each product stored in the recipe composition master 21c by the number of alternative sales of each product, the number of alternative sales of each product is calculated. To calculate the alternative payout amount and to update the inventory amount of each material by subtracting the alternative payout amount of each material from the inventory amount of each material stored in the inventory table 21e. It is configured. Therefore, in the management system 100, the inventory amount of each material can be updated even when the cash register is not closed on the previous day at the target store, for example.

Although the embodiment of the automatic ordering system has been described, the present invention is not limited to the above embodiment. Those skilled in the art will appreciate that various variations of the above embodiments are possible. Further, those skilled in the art can incorporate the features contained in one embodiment into other embodiments or exchange them with features contained in other embodiments as long as there is no contradiction. Will understand.

For example, in the above embodiment, the provided product includes an all-you-can-eat product, and a virtual second unit price P2 is used in some calculations. However, in other embodiments, the management system 100 may be applied to stores that do not offer all-you-can-eat products. In this case, the menu unit price master 21b may store only the first unit price P1, and the first unit price P1 may be used in each calculation.

Further, the processes executed by the controller 22 do not necessarily have to be executed in the above order, and may be executed in a different order as long as there is no contradiction.

21b Menu unit price master (first storage unit)
21c Recipe composition master (second storage unit)
21d Sales table (third storage unit)
21e Inventory table (4th storage unit)
21f Product expansion master (fifth storage unit)
21g Order classification master (sixth storage unit)
21h Business partner master (7th storage unit)
21m sales index table (8th storage unit)
21q Menu buffer master (9th storage unit)
22 Controller 100 Management system P1 First unit price P2 Second unit price

Claims (11)

A management system for calculating the required amount of materials for multiple products.
The first storage unit that stores the sales unit price of each product,
A second storage unit that stores the amount of one or more materials used for one provision of each product, and
A third storage unit that stores the number of sales of each product for each predetermined period in the past,
With the controller
With
The controller
The plurality of past periods associated with each other based on the sales unit price of each product stored in the first storage unit and the number of sales of each product stored in the third storage unit. To calculate the average value of the total sales of the products of
The plurality of past periods associated with each other based on the sales unit price of each product stored in the first storage unit and the number of sales of each product stored in the third storage unit. To calculate the sales ratio of each product to the total sales of the products of
For a certain period in the future, the forecast sales of each product can be calculated by multiplying the average value of the total sales of the corresponding past period by the sales ratio of each product in the corresponding past period.
By dividing the calculated estimated sales of each product by the sales unit price of each product stored in the first storage unit, the estimated sales number of each product in a certain period in the future is calculated. ,
By multiplying the calculated estimated number of sales of each product by the amount of the material used for each product stored in the second storage unit, the required amount of the material for each product in a certain future period is calculated. To do and
A management system that is configured to run. The plurality of products are foods and drinks provided at restaurants, and are
The plurality of products include one or more all-you-can-eat products included in the all-you-can-eat menu.
The first storage unit includes, as the sales unit price, a first unit price indicating an actual sales unit price and a second unit price indicating a virtual sales unit price.
The first unit price includes zero as the sales unit price of the all-you-can-eat product.
The second unit price includes a value larger than zero as the sales unit price of the all-you-can-eat product.
The controller is configured to use the second unit price as the sales unit price to calculate the required amount of each material including the material of the all-you-can-eat product in a certain period in the future. Item 1. The management system according to item 1. It is further equipped with a fourth storage unit that stores the inventory amount of each material in units that match the packaging of the inventory.
The controller
By multiplying the usage amount of the material of each product stored in the second storage unit by the number of sales of each product in the desired period stored in the third storage unit, in the desired period. Calculating the amount of each material to be paid out and
The inventory amount of each material is updated by subtracting the payout amount of each material in the desired period from the inventory amount of each material in the desired period stored in the fourth storage unit. ,
The management system according to claim 1 or 2, which is configured to further execute. The plurality of products include one or more prepared products that can be prepared in advance in an amount used for a plurality of servings.
When the charged product is reduced due to something other than sales, the controller reduces the reduced amount of each material of the charged product from the inventory amount of each material stored in the fourth storage unit, thereby reducing the stocked product of the charged product. The management system according to claim 3, which is configured to update the inventory amount of each material of the above. The controller orders the amount of each material based on the inventory amount of each material stored in the fourth storage unit and the calculated required amount of the material of each product in a certain period in the future. The management system according to claim 3 or 4, which is configured to calculate. Further provided with a fifth storage unit that stores the unit according to the packing style of the inventory of each material and the unit corresponding to the packing style at the time of purchasing each material in association with each other.
The management system according to claim 5, wherein the controller is configured to calculate the order quantity of each material in a unit corresponding to the packing style at the time of purchase stored in the fifth storage unit. .. Further provided with a sixth storage unit for storing an ordering category indicating an ordering method for each material.
The ordering category includes a fixed point automatic ordering, in which the material is ordered when the inventory of the material is expected to be below the fixed point.
The value obtained by subtracting the required amount in the future certain period calculated from the inventory amount stored in the fourth storage unit for the material corresponding to the fixed point automatic ordering by the controller determines the fixed point. The management system according to any one of claims 3 to 6, which is configured to determine that an order is required if the amount falls below the limit. Further provided with a seventh storage unit for storing information on one or more suppliers of each material.
The management system according to claim 5, wherein the controller is configured to calculate the ordered quantity of each material for each of the suppliers stored in the seventh storage unit. Further provided with an eighth storage unit for storing the first adjustment value for adjusting the average value of the total sales for each predetermined period in the future.
The controller corresponds to the average value of the total sales of the corresponding past period for the future period with the first adjustment value of the future period stored in the eighth storage unit. The management system according to any one of claims 1 to 8, which is configured to calculate the forecast sales of each product by multiplying the sales ratio of each product in the past period. For each product, a ninth storage unit for storing the minimum sellable amount in the predetermined period is further provided.
When the estimated sales number of each product in the future certain period calculated by the controller is less than the minimum sales possible amount stored in the ninth storage unit, the predicted sales number is set to the minimum sales amount. The management system according to any one of claims 1 to 9, which is configured to replace with a possible amount. When there is no data of the payout amount in the desired period, the controller determines.
For the desired period in which no data on the payout amount exists, the average value of the total sales in the corresponding past period is multiplied by the sales ratio of each product in the corresponding past period to obtain each product. Calculating alternative sales and
By dividing the alternative sales of each product by the sales unit price of each product stored in the first storage unit, the number of alternative sales of each product can be calculated.
By multiplying the usage amount of the material of each product stored in the second storage unit by the substitute sales number of each product, the alternative payout amount of each material is calculated.
The inventory amount of each material is updated by subtracting the alternative payout amount of each material from the inventory amount of each material stored in the fourth storage unit.
3. The management system according to claim 3, which is configured to further execute.

Images