Support devices, support programs, support methods

Abstract

This invention provides a support device, support program, and support method for optimizing the order quantity of materials. [Solution] In a support system in which a server terminal, a store terminal, and a store terminal are each connected via a network, the server device, which is a support device, includes an inventory information acquisition unit that acquires inventory information including information on the trend of inventory quantities of the target item, a demand quantity forecasting unit that predicts the demand quantity at a predetermined future point in time based on the inventory information, and an inventory standard quantity calculation unit that calculates the inventory standard quantity based on the inventory information and the demand quantity.

Description

Technical Field

[0001] The present invention relates to a support device, a support program, and a support method.

Background Art

[0002] Techniques for supporting the ordering of business materials and the like have been disclosed.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] Patent Document 1 discloses a food ordering support technique capable of efficiently ordering foods having a plurality of parts. In this technique, the prediction of the number of servings of a dish is calculated from the reservation information of the user in order to calculate the required quantity of materials. However, in reality, the characteristics of each material are different, such as the difference in the expiration date of the materials, and it is difficult to predict the required quantity of each material.

[0005] The present invention has been made in view of such a background, and an object thereof is to support the optimization of the ordering quantity of materials.

Means for Solving the Problems

[0006] In order to solve the above problems, a support device for supporting ordering, comprising: an inventory information acquisition unit that acquires inventory information including information on the transition of the inventory quantity of an object; a required quantity prediction unit that predicts the required quantity at a predetermined future time point based at least on the inventory information; and an inventory standard quantity calculation unit that calculates an inventory standard quantity based at least on the inventory information and the required quantity.

[0007] Further issues and solutions disclosed in this application will be made clear in the section on embodiments of the invention and in the drawings. [Effects of the Invention]

[0008] According to the present invention, it is possible to support the optimization of the order quantity of materials. [Brief explanation of the drawing]

[0009] [Figure 1] This figure shows an example of the overall configuration of a support system according to one embodiment of the present invention. [Figure 2] This figure shows an example of the hardware configuration of the server device 1 according to the same embodiment. [Figure 3] This figure shows an example of the functional configuration of the server device 1 according to the same embodiment. [Figure 4] This figure shows an example of consumption history information stored in the inventory information storage unit 131 according to the same embodiment. [Figure 5] This figure shows an example of inventory trend information stored in the advertising rule information storage unit 132 according to the same embodiment. [Figure 6] This figure shows an example of the modified material information stored in the modified material information storage unit 133 according to the same embodiment. [Figure 7] This figure shows the calculated demand forecast value and reference value for the server device 1 according to the same embodiment. [Figure 8] This figure shows an example of processing by the server device 1 according to the same embodiment. [Figure 9] This table explains the consumption forecast values ​​used in the demand forecast according to the same embodiment. [Figure 10] This table illustrates the safety stock values ​​used in demand forecasting according to the same embodiment. [Figure 11] This table explains the adjustment values ​​used in the demand forecast according to the same embodiment. [Modes for carrying out the invention]

[0010] <Summary of the Invention> The contents of the embodiments of the present invention will be listed and described. The present invention has, for example, the following configuration. [Item 1] An assistance device for assisting ordering, An inventory information acquisition unit that acquires inventory information including information on the change in the inventory quantity of an object, A demand quantity prediction unit that predicts the demand quantity at a predetermined future time point based on at least the inventory information, An inventory standard quantity calculation unit that calculates an inventory standard quantity based on at least the inventory information and the demand quantity, An assistance device comprising the above. [Item 2] The demand quantity prediction unit calculates a consumption prediction value by adding a preset addition value to the maximum consumption quantity of the object during a predetermined measurement period, and calculates a safety stock value using the average error value of the consumption quantity during the measurement period, the safety factor, and the predicted deviation value of the error between the predicted and actual consumption quantities. The demand quantity is predicted by multiplying the sum of the consumption prediction value and the safety stock value by a predetermined coefficient. The assistance device according to Item 1. [Item 3] When the reference value of the current day is greater than the minimum value of the reference values for a predetermined number of past days, the demand quantity prediction unit raises the prediction level. When the reference value of the current day is less than the minimum value of the reference values for a predetermined number of past days, the demand quantity prediction unit lowers the prediction level, and adjusts the consumption prediction value according to the prediction level. The assistance device according to Item 1 or 2. [Item 4] The assistance device further comprises an ordering unit that compares the inventory standard quantity with the current inventory quantity, and executes an ordering process when the inventory quantity is less than the inventory standard quantity. The assistance device according to Item 1. [Item 5] The inventory information acquisition unit acquires order history information from a mobile order system or a POS system provided in a store terminal, estimates the number of objects consumed from the order history information, and obtains the current inventory quantity by subtracting the estimated consumption quantity from the inventory quantity before consumption. The assistance device according to Claim 1. [Item 6] An assistance program for supporting ordering, comprising: causing a processor to: an inventory information acquisition step of acquiring inventory information including information on the change in the inventory quantity of an object; a demand quantity prediction step of predicting the demand quantity at a predetermined future time point based on at least the inventory information; an inventory standard quantity calculation step of calculating an inventory standard quantity based on at least the inventory information and the demand quantity; and executing the above, an assistance program. [Item 7] An assistance method for supporting ordering, comprising: a processor performing: an inventory information acquisition step of acquiring inventory information including information on the change in the inventory quantity of an object; a demand quantity prediction step of predicting the demand quantity at a predetermined future time point based on at least the inventory information; an inventory standard quantity calculation step of calculating an inventory standard quantity based on at least the inventory information and the demand quantity; and executing the above, an assistance method.

[0011] FIG. 1 is a block configuration diagram showing an assistance system according to a first embodiment of the present invention. The assistance system includes, for example, a server device 1, a user terminal 3 managed by a store user, and a store terminal 4. For the sake of convenience of explanation, each terminal is described as being single or a specific number, but the number of each is not limited.

[0012] The server terminal Ⅰ, the store terminal 3, and the store terminal 4 are each connected via a network 2. The network 2 is composed of, for example, the Internet, an intranet, a wireless LAN (Local Area Network), a WAN (Wide Area Network), or the like.

[0013] ==Server device 1== The server device 1 may be a general-purpose computer such as a workstation or a personal computer, or may be logically realized by cloud computing.

[0014] ==User Terminal 3== User terminal 3 is a computer used by the user managing inventory. User terminal 3 can be, for example, a smartphone, tablet computer, personal computer, or PDA. The user can access server device 1 through applications or a web browser running on user terminal 3.

[0015] ==Store Terminal 4== Store terminal 4 is a computer installed in the store used for order management and accounting. Store terminal 4 is an information processing device such as a personal computer or tablet terminal, but may also be composed of a smartphone, mobile phone, PDA, etc. Users of store terminal 4 can access server device 1 and user terminal 3, for example, through applications or a web browser running on store terminal 4. Attached terminal 4 may have, for example, a mobile ordering system for taking orders or a POS system for recording and summarizing what was sold and in what quantities installed, but is not limited to these systems.

[0016] In this embodiment, the store is described as a restaurant, but it may be a store of any other type.

[0017] The items subject to inventory management in this embodiment may include, but are not limited to, food products such as ingredients, beverages, and seasonings, as well as consumables such as detergents, tableware, and tissues.

[0018] In this embodiment, the support system is described as comprising a server device 1, user terminals 3 and register terminals 4, with each user operating the server device 1 using their respective terminal. However, the server device 1 may be configured as a standalone system, and the server device 1 itself may have functions that allow each user to operate it directly.

[0019] Figure 2 shows an example of the hardware configuration of server device 1. Note that the illustrated configuration is just one example, and other configurations are also possible. Server device 1 includes a CPU 101, memory 102, storage device 103, communication interface 104, input device 105, and output device 106. The storage device 103 stores various data and programs, such as a hard disk drive, solid-state drive, or flash memory. The communication interface 104 is an interface for connecting to the communication network 2, such as an adapter for connecting to Ethernet®, a modem for connecting to a public telephone network, a wireless communication device for wireless communication, or a USB (Universal Serial Bus) connector or RS232C connector for serial communication. The input device 105 is for inputting data, such as a keyboard, mouse, touch panel, button, or microphone. The output device 106 is for outputting data, such as a display, printer, or speaker. Furthermore, each functional unit of the server device 1, described later, is realized by the CPU 101 reading a program stored in the storage device 103 into the memory 102 and executing it, while each storage unit of the server device 10 is realized as part of the storage area provided by the memory 102 and the storage device 103.

[0020] Figure 3 also shows the functional configuration of the server device 1. As shown in Figure 1, the server device 1 includes storage units: an inventory information storage unit 131, a calculation table storage unit 132, and an order information storage unit 133, as well as processing units: an inventory information acquisition unit 111, a demand quantity forecasting unit 112, a standard value calculation unit 113, a presentation unit 114, and an order unit 115.

[0021] The following describes each of the storage units: the inventory information storage unit 131, the calculation table storage unit 132, and the order information storage unit 133.

[0022] The inventory information storage unit 131 stores the inventory information acquired by the inventory information acquisition unit 111 in Figure 4. As shown in Figure 4, the inventory information includes, as an example, the name of the item, the item code, the product name, lot number, serial number, purchase price, supplier, order date, order quantity, delivery date, delivery quantity, quantity used, inventory quantity, inventory location, best before date / use-by date, etc., and information such as the item's condition.

[0023] The calculation table storage unit 132 stores information from the table used for demand calculation. As shown in Figure 5, the calculation table includes information such as forecast values, safety stock levels, step unit rules, and order levels.

[0024] The order method information storage unit 133 stores the information necessary for the order unit 115 to place an order. The order method information may include the target product, supplier, ordering method, etc.

[0025] The following describes the processing units for the inventory information acquisition unit 111, the demand quantity forecasting unit 112, the standard value calculation unit 113, the presentation unit 114, and the order unit 115.

[0026] The inventory information acquisition unit 111 acquires inventory information regarding the inventory of items subject to inventory management, as an example. The inventory information acquisition unit 111, for example, presents an input form for inventory information to the user terminal 3 via the network 2, accepts user input, and acquires inventory information. The communication in this transmission and reception can be wired or wireless, and any communication protocol can be used as long as communication between the two parties is possible. The inventory information acquisition unit 111 may also acquire order history information from, for example, the mobile ordering system or POS system provided by the store terminal 4, estimate the number of items consumed from the number of orders, and obtain information on the current inventory quantity by subtracting the number consumed from the inventory quantity before consumption. The inventory information acquisition unit 111 stores the acquired inventory information in the inventory information storage unit 131.

[0027] The demand forecasting unit 112 predicts, for example, the demand for the quantity of an item subject to inventory management to be consumed from a predetermined point in time to a predetermined point in the future. The consumption quantity forecasting unit 112 predicts demand based on inventory information, for example. In this case, the demand forecasting unit 112 can predict the consumption quantity as the quantity of the item consumed during a predetermined period, the quantity of the item consumed during the same period in the past, the quantity of the item consumed during a predetermined period, or the average or median of the quantity of the item consumed during the same period in the past over multiple years.

[0028] The demand forecasting unit 112 may, for example, forecast demand using a demand forecasting formula. The demand forecasting formula may consist of, for example, a consumption forecast value, a safety stock value, and an adjustment value.

[0029] The consumption forecast value is calculated based on the relationship values, an example of which is shown in Figure 9. For the forecast period in which demand is predicted (the maximum consumption measurement period in Table 1, which may be any period such as one day or three days after a specified date), the forecast value is calculated by adding an additional value (LT addition) set for each item to the maximum consumption quantity of the item being forecasted during the same period in the past. Furthermore, as shown in Figure 9, the consumption forecast value may be set to a Level by linking the maximum consumption measurement period and the LT addition value, and the demand forecasting unit 112 can select which Level value to use for calculation.

[0030] The demand forecasting unit 112, for example, as shown in Figure 7, uses the reference value of the set level (the line connecting the dots with a thick solid line) as the reference value calculated at Level 3 (the consumption forecast value, and the same applies hereafter). If the reference value for a given date (the current day) is greater than the minimum value of the reference value for the past x days on the horizontal axis (for Level 3, "x = 3 days") or the reference value for the current day, the level is raised (to Level 4). If the reference value for a given date (the current day) is less than the minimum value of the reference value for the past X days (for Level 3, "x = 3 days") or the reference value for the current day, the level is lowered (to Level 2), and the consumption forecast value is calculated.

[0031] As shown in Figure 10, the safety stock value is the sum of the average error in consumption quantity during the maximum consumption measurement period and the predicted fluctuation value during the maximum consumption measurement period. The predicted fluctuation value is calculated by multiplying the safety factor by the standard deviation of the error between predicted and actual consumption during the prediction period × √Order LT (number of days: set for each ingredient) + consumption amount that becomes the safety quantity (x days) + consumption amount after delivery LT (number of days: set for each ingredient).

[0032] Furthermore, a safety margin may be established by multiplying the sum of the predicted consumption value and the safety stock value by a predetermined coefficient. The predetermined coefficient only needs to be a value greater than 1; the closer the value is to 1, the less waste will occur, but the more likely stockouts will occur if actual consumption exceeds the predicted consumption value. The predetermined coefficient may be arbitrarily selected by the user.

[0033] As shown in Figure 11, the adjustment value is a value that can be varied according to the user's judgment regarding how much inventory they want to hold. It is a value that adjusts the predicted quantity by raising or lowering the order level based on past reference values ​​and the reference value for the day, depending on the order level.

[0034] The reference value calculation unit 113 calculates a reference value, for example, which is the inventory quantity of the item in question and indicates the inventory quantity to be ordered if it falls below that quantity. The reference value calculation unit 113 calculates the reference value based on the demand forecast value calculated by the demand forecast unit 112.

[0035] As an example, the display unit 114 displays the reference value calculated by the reference value calculation unit 113 to the user terminal 3.

[0036] The order unit 115 processes an order for a target item when its inventory quantity reaches a certain threshold. For example, when the inventory quantity of rice reaches a certain threshold, the order unit 115 can process the order using information stored in the server device 1 regarding how to order rice (e.g., methods such as email, telephone, or fax, contact information such as email address and telephone number, items that need to be notified, etc.).

[0037] Using Figure 8, a typical processing flow of the server device 1 of this embodiment will be explained. The inventory information acquisition unit 111 acquires inventory information (1001). The demand quantity forecasting unit 112 forecasts the demand quantity (1002). The standard value calculation unit 113 calculates the standard value (1003). The presentation unit 114 presents the standard value information to the user terminal 3 (1004). The order unit 115 executes order processing based on the inventory information and standard value information (1005).

[0038] While preferred embodiments of the present disclosure have been described in detail above with reference to the attached drawings, the technical scope of the present disclosure is not limited to such examples. It is clear to any person with ordinary skill in the art of the present disclosure that various modifications or alterations may be conceived within the scope of the technical idea set forth in the claims, and these will naturally also fall within the technical scope of the present disclosure.

[0039] The apparatus described herein may be implemented as a single device, or it may be implemented by multiple devices (e.g., cloud servers) that are partially or entirely connected by a network. For example, the CPU and storage device of the management server 20 may be implemented by different servers that are connected to each other by a network.

[0040] The series of processes performed by the apparatus described herein may be implemented using software, hardware, or a combination of software and hardware. Computer programs for implementing each function of the management server 20 according to this embodiment can be created and implemented on a PC or the like. Furthermore, a computer-readable recording medium containing such a computer program can also be provided. Examples of recording media include magnetic disks, optical disks, magneto-optical disks, and flash memory. Alternatively, the computer program may be distributed without using a recording medium, for example, via a network.

[0041] Furthermore, the processes described herein do not necessarily have to be performed in the order described. Some processing steps may be performed in parallel. Additional processing steps may be employed, and some processing steps may be omitted.

[0042] Furthermore, the effects described herein are merely descriptive or illustrative and not limiting. In other words, the technology relating to this disclosure may produce other effects that will be apparent to those skilled in the art from the description herein, in addition to or in lieu of the effects described herein. [Explanation of Symbols]

[0043] 1 Server device 2 Network 3. User terminals 101 CPU 102 memory 103 Storage device 104 Communication Interface 105 Input device 106 Output device 111 Inventory Information Acquisition Department 112 Demand Quantity Forecasting Department 113 Reference Value Calculation Department 114 Presentation section 115 Order Department 131 Inventory Information Storage Unit 132 Calculation Table Storage Unit 133 Order Method Memory Unit

Claims

1. A support device for assisting in ordering, An inventory information acquisition unit that acquires inventory information related to the target item, A demand quantity forecasting unit that predicts the demand quantity of the target object at a future point in time, The system includes at least one inventory standard quantity calculation unit that calculates an inventory standard quantity (hereinafter referred to as the standard value) used for ordering decisions based on the aforementioned demand quantity, The demand quantity forecasting unit calculates a consumption forecast value by adding an LT addition value corresponding to the level set for each item to the maximum consumption quantity in the past for the same period corresponding to the forecast period. By comparing the baseline value B(t) for the day with the minimum value of the baseline value group for the past x days, the prediction level is raised or lowered by one level, and the consumption prediction value is adjusted by the LT addition value corresponding to that level. The safety stock value is calculated as the sum of the average error in consumption quantity during the maximum consumption measurement period and the predicted fluctuation range. The quantity demanded is predicted as follows: Demand quantity = α × (Forecasted consumption value + Safety stock value) (α is a coefficient of 1 or more). The aforementioned inventory standard quantity calculation unit is a support device that calculates a standard value based on at least the demand quantity.

2. The support device according to claim 1, further comprising an ordering unit that compares the reference value with the current inventory quantity and processes an order for the item when the inventory quantity reaches the reference value.

3. In the support device according to Claim 1, the predicted value of the vibration range is: A support device that calculates consumption using the following formula: (Safety Factor) × (Standard Deviation of Error Between Prediction and Actual Results) × √(Order Lead Time [Days]) + (Safety Quantity [Consumption for x Days]) + (Consumption after Delivery Lead Time [Days]).

4. The support device according to Claim 1, wherein the level is raised when the reference value B(t) for the day is greater than the minimum value of the reference value group for the past x days or the reference value for the day, and the level is lowered when it is less than the reference value, and the consumption forecast value is calculated or adjusted by the LT added value corresponding to the level.

5. The support device according to Claim 1, wherein the inventory information acquisition unit acquires order history information from a mobile order or POS system of a store terminal, estimates the number of items consumed from the order history information, and calculates the current inventory quantity.

6. A support program that enables a computer to implement the functions of the support device described in Claim 1.

7. A support method in which a processor performs each process corresponding to the support device described in Claim 1.

Images