Inventory management system, inventory management method, and program
The inventory management system addresses the volatility of fuels by receiving and analyzing sales and inventory data to issue timely warnings, ensuring accurate inventory management and detection of abnormalities.
Patent Information
- Application Number
- JP2021109327
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2021-06-30
- Publication Date
- 2025-08-19
- Estimated Expiration
- 2041-06-30
AI Technical Summary
Existing inventory management systems fail to accurately account for the volatility of fuels like gasoline, leading to discrepancies between received and sold quantities, and do not provide timely warnings for inventory abnormalities.
An inventory management system that includes a receiving module for inputting sales and inventory data, a determination module to identify discrepancies, and an output module to issue warnings when predefined conditions are met, specifically focusing on volatile fluids such as gasoline.
Enables accurate inventory management and timely warnings for volatile fluids, addressing the discrepancies and abnormalities in fuel inventory.
Smart Images

Figure 0007725264000001 
Figure 0007725264000002 
Figure 0007725264000003
Abstract
Description
[Technical Field]
[0001] The present invention relates to techniques for managing inventories of volatile fluids. [Background technology]
[0002] Systems relating to inventory management are known. For example, Patent Document 1 discloses a technology in which an oil seller (a wholesaler or a retailer) manages oil inventory at a buyer (a retailer or a consumer). Furthermore, as a system relating to a fueling facility, for example, Patent Document 2 discloses a system in which a liquid level gauge detects the liquid level, or corrosion or oil leaks in a tank or pipe, and automatically transmits the detected liquid level to a management server via a network such as the Internet. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2015-209241 [Patent Document 2] Japanese Patent Application Publication No. 2018-151728 Summary of the Invention [Problem to be solved by the invention]
[0004] Gas stations sell volatile fluids such as gasoline. Unlike non-volatile products, volatile products often have a discrepancy between the quantity received and the quantity sold that does not match the quantity in stock. However, Patent Documents 1 and 2 do not fully consider the characteristics of volatile fluids.
[0005] The present disclosure provides a technology for more accurate inventory management of volatile fluids and for outputting a warning in response to the results of the inventory management. [Means for solving the problem]
[0006] One aspect of the present disclosure provides an inventory management system that has a receiving means for receiving input of the sales quantity and actual inventory amount of fuel at the retailer that sells volatile fluids from a terminal of the retailer at the end of a specified unit period, and an output means for outputting a warning to a first destination set for the retailer when a first condition is met regarding the difference between the calculated inventory amount obtained from the sales quantity during a target unit period at the retailer and the actual inventory amount at the end of the unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, the first condition indicating that the difference is greater than a standard.
[0007] Another aspect of the present disclosure provides an inventory management method comprising the steps of: receiving input of the sales quantity and actual inventory amount of fuel at a retail store that sells volatile fluids from a terminal of the retail store at the end of a specified unit period; and outputting a warning to a first destination set for the retail store when a condition is met regarding the difference between the calculated inventory amount obtained from the sales quantity during a target unit period at the retail store and the actual inventory amount at the end of the unit period immediately preceding the target unit period, the condition indicating that the difference is greater than a standard.
[0008] Yet another aspect of the present disclosure provides a program for causing a computer to execute the steps of accepting input of the sales quantity and actual inventory amount of fuel at the retailer that sells volatile fluids from a terminal of the retailer at the end of a specified unit period, and outputting a warning to a first destination set for the retailer when a condition is met regarding the difference between the calculated inventory amount obtained from the sales quantity during a target unit period at the retailer and the actual inventory amount at the end of the unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, the condition indicating that the difference is greater than a standard. [Effects of the Invention]
[0009] According to the present disclosure, it is possible to perform inventory management that takes into account the characteristics of volatile fluids and to issue warnings according to the results of the inventory management. [Brief explanation of the drawings]
[0010] [Figure 1] FIG. 1 is a diagram showing an overview of an inventory management system according to an embodiment. [Figure 2] FIG. 1 is a diagram illustrating an example of the functional configuration of an inventory management system. [Figure 3] FIG. 2 is a diagram illustrating an example of a hardware configuration of a server. [Figure 4] 4 is a sequence chart showing the operation of the inventory management system. [Figure 5] FIG. 10 is a diagram illustrating a top screen. [Figure 6] A diagram illustrating the input screen for daily and weekly inspections. [Figure 7] FIG. 10 is a diagram illustrating an example of a UI object for inputting inspection results. [Figure 8] FIG. 10 is a diagram illustrating an example of a monthly inspection input screen. [Figure 9] FIG. 10 is a diagram illustrating an example of an input screen for a six-month inspection. [Figure 10] FIG. 10 is a diagram illustrating an example of an inventory management screen. [Figure 11] FIG. 10 is a diagram illustrating an example of a UI object for inputting inventory information. [Figure 12] FIG. 10 is a diagram illustrating a menu screen for registering attribute information. [Figure 13] FIG. 10 is a diagram illustrating an example of a tank master setting screen. [Figure 14] FIG. 10 is a diagram illustrating an example of a setting screen for mail destination master data. [Figure 15] FIG. 10 is a diagram illustrating an example of an alert / remind notification master setting screen. DETAILED DESCRIPTION OF THE INVENTION
[0011] 1. Configuration FIG. 1 is a diagram showing an overview of an inventory management system 1 according to one embodiment. The inventory management system 1 is a system for managing the inventory of volatile fluids at a retail store SS that sells volatile fluids. In this disclosure, a volatile fluid refers to a fluid that is more volatile than water, and examples include fuels such as gasoline, diesel, and kerosene. In the following, an example will be used in which the volatile fluid is fuel. The retail store SS is a service station or a gas station. In the following, when multiple retail stores SS are to be distinguished from one another, they will be referred to as retail store SS[i]. When multiple retail stores SS are not to be distinguished from one another, they will be simply referred to as retail store SS.
[0012] The inventory management system 1 has a server 10, a dealer terminal 20, and a user terminal 30. These devices are connected via a network such as the Internet. The inventory management system 1 manages fuel inventory at multiple dealers SS. At least one dealer terminal 20 is used at each dealer SS. The dealer terminal 20 is a computer device installed at the dealer SS, such as a personal computer or tablet terminal. The user terminal 30 is a computer device used by a user corresponding to the dealer SS, such as a personal computer or smartphone. The term "user" of the inventory management system 1 is a concept that encompasses employees and store managers of dealer SSs, and employees of the management company of the dealer.
[0013] A retail store SS has a storage facility (or tank) T for storing fuel. If a retail store SS sells multiple types of fuel, the retail store SS has a storage facility Tk corresponding to each fuel. For example, a retail store SS[1] that sells three types of fuel, gasoline, diesel, and kerosene, has three storage facilities Tk[1,1], Tk[1,2], and Tk[1,3].
[0014] At the end of a specified unit period, an employee of the dealer SS[i] inputs at least the sales quantity and actual stock amount of fuel at the dealer SS[i] into the inventory management system 1. The inventory management system 1 records the input information in a database. The inventory management system 1 refers to this database to determine whether there is an abnormality such as a fuel leak. If an abnormality is determined to exist, the inventory management system 1 outputs a warning to the corresponding user.
[0015] 2 is a diagram illustrating an example of the functional configuration of inventory management system 1. Inventory management system 1 includes storage means 11, receiving means 12, writing means 13, determination means 14, judgment means 15, setting means 16, output means 17, control means 19, storage means 21, receiving means 22, display means 23, transmission means 24, receiving means 25, control means 29, storage means 31, receiving means 32, display means 33, transmission means 34, and control means 39. In this example, storage means 11, receiving means 12, writing means 13, determination means 14, judgment means 15, setting means 16, output means 17, and control means 19 are implemented in server 10, storage means 21, receiving means 22, display means 23, transmission means 24, receiving means 25, and control means 29 are implemented in store terminal 20, and storage means 31, receiving means 32, display means 33, transmission means 34, and control means 39 are implemented in user terminal 30.
[0016] In the server 10, the storage means 11 stores various data and programs. In this example, the storage means 11 stores a database 111 and a database 112. The database 111 is a database in which the attributes of the retailers are recorded. The database 112 is a database in which data on sales quantities and actual inventory amounts entered by the retailers is recorded. In this example, the database 112 also records warnings issued to the retailers and the results of inspections carried out by the retailers in response to those warnings.
[0017] The receiving means 12 receives input of periodic inspection results from the dealer terminal 20. Periodic inspection refers to an inspection of fuel storage facilities and related equipment conducted by a dealer at the end of a unit period (e.g., business hours). The results of the periodic inspection include, for example, data on the amount of fuel sold and the actual inventory amount. The writing means 13 writes the received data on the results of the periodic inspection into the database 112. The determining means 14 determines the conditions for outputting a warning based on the received results of the periodic inspection.
[0018] The determination means 15 determines whether the conditions for issuing a warning are met for the target retailer. These conditions include a first condition regarding the difference between the calculated inventory amount, obtained from the sales volume in the target unit period and the actual inventory amount at the end of the unit period immediately preceding the unit period, and the actual inventory amount at the end of the target unit period, and indicating that the difference is greater than a standard. If the determination means 15 determines that this condition is met, the setting means 16 sets a destination to which the warning will be issued. The destination to which the warning will be issued is defined, for example, in the database 111. The output means 17 outputs the warning to the set destination. This warning, for example, prompts the retailer to inspect its storage facility and related equipment. The control means 19 performs other control.
[0019] In the dealer terminal 20, storage means 21 stores various data and programs. Acceptance means 22 accepts input of regular inspection results from the user. Display means 23 displays various UI (User Interface) screens. The UI screens displayed by the display means 23 include, for example, an input screen for inputting the results of regular inspections. Transmission means 24 transmits the results of regular inspections to the server 10. Reception means 25 receives various data from other devices such as the server 10. Control means 29 performs other controls.
[0020] In the user terminal 30, the storage means 31 stores various data and programs. The receiving means 32 receives warnings from the server 10. The display means 33 displays a UI screen for inputting the results of an inspection in response to a warning received from the server 10 (hereinafter, an inspection conducted to deal with a warning will be referred to as an "abnormality inspection"). The user inputs the results of the abnormality inspection via this UI screen. The transmitting means 34 transmits the results of the abnormality inspection to the server 10. The control means 39 performs other controls.
[0021] In the server 10, the receiving means 12 receives input of the results of the abnormality inspection. The writing means 13 writes the results of the abnormality inspection into the database 112.
[0022] 3 is a diagram illustrating an example of the hardware configuration of the server 10. The server 10 is a computer device having a CPU (Central Processing Unit) 101, a memory 102, a storage 103, and a communication IF (Interface) 104. The CPU 101 is a control device that executes programs to perform various calculations and controls other hardware elements of the server 10. The memory 102 is a main storage device that functions as a work area when the CPU 101 executes a program. The storage 103 is a non-volatile auxiliary storage device that stores various programs and data. The communication IF 104 is a communication device that communicates with other devices according to a predetermined communication standard (e.g., Ethernet (registered trademark)).
[0023] In this example, the programs stored in storage 103 include a program (hereinafter referred to as the "server program") for causing the computer device to function as server 10 in inventory management system 1. When CPU 101 executes the server program, the computer device is implemented with the functions shown in Figure 2. When CPU 101 is executing the server program, at least one of memory 102 and storage 103 is an example of storage means 11, CPU 101 is an example of writing means 13, decision means 14, judgment means 15, setting means 16, and control means 19, and communication IF 104 is an example of receiving means 12 and output means 17.
[0024] Although detailed explanations will be omitted, the store terminal 20 and the user terminal 30 are each a computer device including a processor, memory, storage, a display, an input device, and a communication IF. In this example, the programs stored in the storage include programs (hereinafter referred to as the "client program (for store terminal)" and the "client program (for user terminal)") that cause the computer device to function as the store terminal 20 or the user terminal 30 in the inventory management system 1. The client program (for store terminal) and the client program (for user terminal) are, respectively, a general-purpose web browser program or a dedicated application program.
[0025] In a state where the processor is executing the client program (for the dealer terminal), at least one of the memory and the storage is an example of storage means 21. In addition, in the above state, the input device is an example of reception means 22, the display is an example of display means 23, the communication IF is an example of transmission means 24 and reception means 25, and the processor is an example of control means 29.
[0026] When the processor is executing a client program (for a user terminal), at least one of the memory and the storage is an example of a memory means 31, the communication IF is an example of a receiving means 32 and a transmitting means 34, the display is an example of a display means 33, and the processor is an example of a control means 39.
[0027] 2.Operation 2-1. Example of operation 1 Figure 4 is a sequence chart showing an example of the operation of the inventory management system 1. Before the start of the sequence in Figure 4, a server program, a client program (for the store terminal), and a client program (for the user terminal) are installed in the server 10, the store terminal 20, and the user terminal 30, respectively.
[0028] In step S101, a user at a dealer inputs the results of a regular inspection at the dealer terminal 20. In one example, when the dealer terminal 20 accesses the server 10, the server 10 transmits data for displaying a top screen to the dealer terminal 20.
[0029] FIG. 5 is a diagram illustrating an example of the top screen. The top screen includes areas 901 and 902. Area 901 is an area that displays a menu of services provided by the inventory management system 1. In this example, four menus are provided: "Daily / Weekly Inspection," "Monthly Inspection," "6-Month Inspection," and "Inventory Management." "Daily / Weekly Inspection" is a link to a screen for inputting the results of regular inspections that should be performed daily and weekly. "Monthly Inspection" is a link to a screen for inputting the results of regular inspections that should be performed monthly. "6-Month Inspection" is a link to a screen for inputting the results of regular inspections that should be performed every 6 months. "Inventory Management" is a link to a screen that displays the fuel inventory status at the dealership.
[0030] Thus, in this example, multiple types of periodic inspections are defined (three types in the example of Figure 5: daily / weekly inspections, monthly inspections, and six-monthly inspections). Each type has a different unit period for inspection. For daily / weekly inspections, the unit period is one business day and seven calendar days, for monthly inspections, the unit period is one calendar month, and for six-monthly inspections, it is six calendar months. For daily / weekly inspections, for example, an employee of dealer SS[i] enters the inspection results into inventory management system 1 at a set time during business hours (for example, 10:00 p.m. every day after closing).
[0031] Area 902 is an area for displaying notifications from the inventory management system 1. These notifications include alerts (i.e., warnings) regarding regular inspections. For example, in the example of FIG. 5, the top row of area 902 displays a warning that "This week's inspection of the oil-water separator has not been entered," indicating that the results of the regular inspection have not been entered.
[0032] FIG. 6 is a diagram illustrating an example of an input screen for daily and weekly inspections. This input screen includes areas 911, 912, and 913. Area 911 displays a UI object (e.g., a pull-down menu) for specifying the target dealer and the target period. In the example of FIG. 6, April 2021 is specified as the target period. Area 912 displays a UI object (e.g., a button) for inputting an instruction to output the input data in a predetermined format (e.g., a PDF file). Area 913 displays the results of the routine inspections (daily and weekly inspections) for the target period. Because the target period includes multiple unit periods, in this example, the inspection results are displayed in a table format with dates listed vertically and inspection items and whether or not they were checked horizontally. When the user selects a date on this screen (e.g., by clicking a row), a UI object (e.g., a pop-up window) for entering the inspection results is displayed.
[0033] FIG. 7 is a diagram illustrating an example of a UI object (pop-up window) for inputting inspection results. This pop-up window displays inspection items and includes UI objects for inputting the inspection results. The inspection results are selected from predefined options. In this example, the UI object for inputting the inspection results is a radio button. Furthermore, the UI object for inputting the inspection results includes a text input field for inputting a character string to be written as a remark. A user (e.g., a store employee) inputs the inspection results on this screen.
[0034] FIG. 8 is a diagram illustrating an example of an input screen for monthly inspections. This input screen includes area 923 in addition to area 911 and area 912. Area 923 is an area that displays the results of daily inspections (monthly inspections) for the target period. Unlike daily and weekly inspections, the target period includes only a single unit period, so area 923 displays the inspection items and inspection details, as well as UI objects for inputting the inspection results (radio buttons for selecting options and a text input field for inputting remarks). The inspection items differ from those for daily and weekly inspections. A confirmation field is included at the bottom of area 923. The confirmation field includes UI objects for selecting the person who performed the inspection (check boxes in the example of FIG. 8). Although not shown in FIG. 7, the pop-up window for inputting the results of daily and weekly inspections also includes a confirmation field for selecting the person who performed the inspection.
[0035] FIG. 9 is a diagram showing an example of the input screen for a six-month inspection. This input screen includes area 933 in addition to area 911 and area 912. Area 933 is an area that displays the results of the daily inspection (six-month inspection) for the target period. The inspection items are different for the daily / weekly inspection and the monthly inspection. Although the inspection items are different, the method for inputting the inspection results is the same as for the monthly inspection.
[0036] Referring again to Figure 4, for the monthly inspection and the six-month inspection, when the user completes inputting the inspection results (for example, when the "Update" button in area 923 in Figure 8 is pressed), the dealer terminal 20 transmits the inspection results to the server 10 (step S102). When the server 10 receives the input of the inspection results from the dealer terminal 20, it writes the received data to the database 112 (step S103). The server 10 generates data for area 923 or area 933 including the newly input inspection results and transmits it to the dealer terminal 20. The dealer terminal 20 displays a screen (Figure 8 or Figure 9) including area 923 or area 933 including the newly input inspection results.
[0037] FIG. 10 is a diagram illustrating an example of an inventory management screen. In addition to areas 911 and 912, the inventory management screen includes areas 943 and 944. Area 944 includes a UI object for selecting a fuel storage tank and a display of the attributes of the selected storage tank. Storage tank attributes include, for example, an identification number ("Tank No." in the illustrated example), fuel type ("Oil Type" in the illustrated example), storage tank capacity ("Tank Capacity" in the illustrated example), and inspection manager. This information is recorded in database 111, and server 10 retrieves this information from database 111. A single dealer may have multiple storage tanks, and inventory is checked for each storage tank. Note that FIGS. 6, 8, and 9 illustrate examples in which daily, weekly, monthly, and six-month inspections are performed collectively for multiple storage tanks (regular inspections are not performed for each storage tank and its associated equipment). However, these regular inspections may also be performed and recorded for each storage tank and its associated equipment.
[0038] When the user selects a date on this screen (for example, by clicking on a row), a UI object (for example, a pop-up window) is displayed for entering information about inventory.
[0039] Figure 11 illustrates an example of a UI object (pop-up window) for entering inventory information. This pop-up window includes UI objects for displaying inspection items and entering the inspection results. Just to be clear, entering inventory information is also an example of a periodic inspection. The inspection results entered here primarily consist of fuel inventory figures. In the example in Figure 11, the inspection results entered for the target business day (April 3, 2021 in the example) are the "actual inventory amount after business hours the previous day," "quantity received from the tanker truck," "quantity sold from the scale," and "actual inventory amount after business hours." The "actual inventory amount after business hours the previous day" is not entered by the user, as the data for the previous day is automatically acquired and displayed on this screen except during initial input. The "quantity received from the tanker truck" indicates the amount of fuel newly added to the storage facility on the target business day, if any. The "quantity sold from the scale" indicates the amount of fuel recorded as sold on that business day on the retailer's scale (e.g., a POS device). "Actual inventory after business hours" indicates the inventory amount in the warehouse after business hours on that business day, as measured by the warehouse's meters.
[0040] Because fuel is highly volatile, there is a high probability that a difference D between the calculated inventory and the actual inventory will clearly occur. The calculated inventory is the result of subtracting the sales quantity recorded on the scale from the actual inventory after business hours the previous day. For example, if the actual inventory after business hours the previous day is 4000L and the sales quantity for that business day is 1000L, the calculated inventory is 4000-1000=3000L. However, due to factors such as fuel volatilization during refueling, the remaining amount shown on the storage meter may be less than this, for example, 2900L. The difference between the two (more specifically, the result of subtracting the calculated inventory from the actual inventory) is D (in this example, D=2900-3000=-100).
[0041] The pop-up window in Figure 11 includes, in addition to the fuel inventory values, radio buttons for inputting the results of the "leak inspection pipe inspection," and a text input field for inputting the details of any deficiencies in the leak inspection pipe. The user (e.g., a dealer employee) enters these inspection results on this screen.
[0042] Referring again to FIG. 4, when the user has completed inputting the inspection results (for example, when the "Register" button is pressed in the pop-up window of FIG. 7 or the pop-up window of FIG. 11), the dealer terminal 20 transmits the inspection results to the server 10 (step S102). When the server 10 receives the inspection results from the dealer terminal 20 (i.e., when it receives the inspection results), it writes the received data to the database 112 (step S103). The server 10 generates screen data including the newly input inspection results and transmits it to the dealer terminal 20. The dealer terminal 20 displays the screen including the newly input inspection results (i.e., the screen is updated). For example, when new daily or weekly inspection results are input, the screen of FIG. 6 is updated, and when new inventory information is input, the screen of FIG. 10 is displayed.
[0043] In step S104, the server 10 determines the conditions for issuing a warning to the user. The inventory management system 1 can issue multiple types of warnings to the user, but the warning determined here is a warning related to inventory information. In one example, the conditions are common to all retailers and all seasons, and information defining these conditions is stored in the server 10 (in its storage means 11). In one example, the conditions are related to the ratio of the difference D between the calculated inventory amount and the actual inventory amount to the sales amount (an example of a condition related to the difference D). Specifically, the condition is that the cumulative increase / decrease rate RΣ (=ΣD / ΣS) of the cumulative difference value ΣD over a predetermined period T to the cumulative sales amount ΣS over this predetermined period is equal to or greater than a threshold value Th[1]. In one example, T is 3 days, and Th[1] is 10%. Th[1] is obtained based on the cumulative increase / decrease rate criterion recorded in the database 111 (for example, by multiplying the cumulative increase / decrease rate criterion by a predetermined coefficient). If this condition is common to all stores and all seasons (that is, if this condition is fixed), the processing of step S104 may be omitted.
[0044] In step S105, the server 10 determines whether the target inspection result satisfies the conditions for issuing a warning. The target inspection result is the inspection result whose input was accepted in step S102. That is, the server 10 determines whether the newly input inspection result satisfies the conditions for issuing a warning. If this condition is met, the server 10 writes information indicating that this condition has been met into the database 112 in association with the target retailer.
[0045] If it is determined that the newly input inspection result satisfies the conditions for issuing a warning, the server 10 outputs a warning (step S106). In one example, the output destination of the warning is predetermined, for example, the dealer terminal 20 that has accessed the server 10 to display an inventory management screen. In one example, the warning is displayed on the inventory management screen.
[0046] Referring again to FIG. 10, in this example, the cumulative increase / decrease rate R for the last three days, April 1st, 2nd, and 3rd, is -10.00%, which satisfies the conditions for issuing a warning. In this case, the server 10 generates a screen containing a warning in response to an access request from the dealer terminal 20. In this example, cells corresponding to items for which the conditions for issuing a warning are met are displayed in a color different from the other cells. For example, the cell for the cumulative increase / decrease rate for April 3rd is displayed in red.
[0047] Furthermore, when the conditions for issuing a warning are met, the server 10 sends a warning message to a predefined destination. The warning message is sent, for example, via email, SMS, a messaging service, or a chat service. This destination is registered in the database 111. The destination of the warning message is, for example, at least one of an employee of the dealership, the store manager, and a management representative of the management company that oversees the dealership. That is, the server 10 sends a warning to the user terminal 30 (FIG. 4: step S107). According to this example, the user can easily know that an abnormality has occurred during daily inspection.
[0048] 2-2. Supplement (Registering retailer attribute information) When using the inventory management system 1, it is necessary to register attribute information of each sales outlet in the inventory management system 1. In one example, the attribute information of a sales point is registered by an employee of the sales point.
[0049] 12 is a diagram illustrating a menu screen (master management screen) for registering attribute information. For example, a link to this master management screen is included in the top screen that is displayed when the dealer terminal 20 accesses the server 10, and when the user selects this link, the master management screen is displayed on the dealer terminal 20.
[0050] In this example, on the master management screen, it is possible to register or set three types of attribute information: information about the storage facility (tank master), settings for the destination to send alerts (email destination master), and settings for the conditions for issuing alerts (alert / remind notification master).
[0051] FIG. 13 is a diagram illustrating an example of a tank master setting screen. The tank master setting screen includes areas 951, 952, and 953. Area 951 displays a UI object (a pull-down menu in the illustrated example) for specifying a target dealer. Area 952 displays a UI object (a "New Registration" button in the illustrated example) for instructing new registration of a storage facility. Area 953 displays attributes of registered storage facilities. In this example, the storage facility attributes include an identification number ("Tank No." in the illustrated example), a type of fuel ("Oil Type" in the illustrated example), a storage facility capacity ("Tank Capacity" in the illustrated example), an inspection manager, and information regarding warning conditions ("Cumulative Increase / Decrease Rate Judgment Criteria" in the illustrated example). When the user presses the "New Registration" button, an input screen (not illustrated) for inputting this information is displayed. The server 10 writes the attribute information input via this input screen to the database 111.
[0052] FIG. 14 is a diagram illustrating an example of a setting screen for the email destination master. The setting screen for the email destination master includes, in addition to area 951, areas 962 and 963. Area 962 is an area that displays a UI object (in the illustrated example, a "New Registration" button) for instructing the user to register a new email destination. Area 963 is an area that displays the attributes of registered email destinations. In this example, the attributes of the email destination include identification information (in the illustrated example, "Destination"), the email address of the destination, and information specifying the type of alert to be sent (in the illustrated example, "Alert Notification (for SS)," "Alert Notification (for Manager)," and "Reminder Notification"). An alert notification (for SS) is an alert intended for an employee or manager of a dealership. An alert notification (for Manager) is an alert intended for the administrator of the management company that has jurisdiction over the dealership. In this example, the alerts are classified into an alert notification (for SS), an alert notification (for Manager), and a reminder notification. The conditions for issuing a warning for the alert notification (for the responsible person) and the "remind notification" may be defined separately, or the same conditions may be used. If the same conditions are used for both, the email text of the alert notification for the SS and the alert notification for the responsible person will be different. The server 10 writes the attribute information entered via this input screen into the database 111.
[0053] FIG. 15 is a diagram illustrating an example of the alert / remind notification master setting screen. The alert / remind notification master setting screen includes area 973 in addition to area 951. Area 973 displays a UI object for setting the timing of alert / remind notifications. The inventory management system 1 issues multiple types of alerts to users. FIG. 15 shows an example in which a no-entry alert is set. A no-entry alert is a warning issued when the results of a regular inspection are not entered. A no-entry alert is set for each of multiple types of regular inspections. The setting items for the no-entry alert include the no-entry period and the email sending time. When the set "email sending time" arrives after the closing time of the business day on which the regular inspection is to be performed has passed the number of days set in the "no-entry period," the server 10 sends a warning email to the set destination. The server 10 writes the attribute information entered via this input screen to the database 111.
[0054] 3. Variations The present invention is not limited to the above-described embodiment, and various modifications are possible. Some modifications will be described below. Two or more of the features described in the following modifications may be used in combination.
[0055] 3-1. Conditions for issuing a warning The conditions for issuing a warning to the user are not limited to those exemplified in the embodiment. For example, instead of or in addition to the conditions exemplified in the embodiment, a condition that the ratio R (=D / S) of the difference D between the calculated inventory amount and the actual inventory amount to the sales quantity S has continued for a unit period of time equal to or greater than a threshold value Th[2] may be used. In one example, Th[2] is obtained based on the cumulative increase / decrease rate criterion recorded in the database 111 (for example, by multiplying the cumulative increase / decrease rate criterion by a predetermined coefficient). The threshold value Th[2] is, for example, 10%. The threshold value Th[3] is, for example, 3 days.
[0056] The conditions for issuing a warning to the user may be defined in multiple stages, ranging from lenient to strict. For example, a stricter second condition may be defined in relation to a first condition that the number of consecutive unit periods during which the ratio R (= D / S) is equal to or greater than the threshold value Th[2] is the same or greater than the threshold value Th[3]. The second condition may be, for example, that the number of consecutive unit periods during which the ratio R is equal to or greater than the threshold value Th[4] is the same or greater than the threshold value Th[3] (Th[4]>Th[2]). Alternatively, the second condition may be that the number of consecutive unit periods during which the ratio R is equal to or greater than the threshold value Th[2] is the same or greater than the threshold value Th[5] (Th[5]>Th[3]). Alternatively, the second condition may be that the number of consecutive unit periods during which the ratio R is equal to or greater than the threshold value Th[4] is the same or greater than the threshold value Th[5]. When multiple stages of conditions for issuing a warning are defined, at least one of the content of the warning and the destination of the warning may be changed depending on the strictness of the condition. For example, when stricter conditions are met, the server 10 outputs a warning to more users or to users with higher priority than when looser conditions are met. Alternatively, when stricter conditions are met without changing the destination to which the warning is to be output, the server 10 outputs a warning with more urgency or stricter text than when looser conditions are met.
[0057] Alternatively, the condition for issuing a warning to the user may not be related to the ratio R of the difference D between the calculated inventory amount and the actual inventory amount to the sales quantity S, but may be related to the difference D itself. For example, the condition for issuing a warning to the user may be that the difference D is equal to or greater than the threshold value Th[6] for a continuous period of time equal to or greater than the threshold value Th[7].
[0058] 3-2. How to determine the conditions for issuing a warning In the embodiment, an example has been described in which the condition for issuing a warning is fixed. However, the condition for issuing a warning may be adaptively determined according to various attributes or environments. For example, in step S104, the determination means 14 determines the condition based on at least one of the attributes of the retailer and the season to which the target business day belongs. The attribute information of the retailer used here is, for example, the region to which the retailer belongs. Each region is grouped according to meteorological data such as average temperature or average solar radiation. For example, a large threshold value Th related to the magnitude of the ratio R is set for a retailer located in a region that belongs to a group with a higher average temperature, and a small threshold value Th related to the magnitude of the ratio R is set for a retailer located in a region that belongs to a group with a lower average temperature. Alternatively, at least one of the size and number of storage facilities may be used as an attribute of the retailer. Alternatively, the determination means 14 may determine the condition for issuing a warning (more specifically, the value of the threshold value used in the condition) according to meteorological data (i.e., the weather near the retailer) such as the maximum temperature or solar radiation of the region to which the retailer belongs on that business day. For example, even for the same store, the threshold value Th for the magnitude of the ratio R is determined to be large on business days when the weather is fine, and to be small on business days when the weather is rainy.
[0059] Alternatively, the determination means 14 may determine the conditions for issuing a warning by referring to data recorded in the database 112. The database 112 stores information indicating that the conditions for issuing a warning have been met. This information is associated with the identification information of the dealer and time information indicating the time when it was determined that the conditions were met. The determination means 14 references the inspection results in the database 112 before and after the time when it was determined that the conditions for issuing a warning were met, based on the identification information and time information of the dealer. If the percentage of inspections in which a warning was issued but no abnormalities were found exceeds a threshold value during a certain period in the past, the determination means 14 changes the conditions for issuing a warning for that dealer to be more lenient. Specifically, the determination means 14 increases the value of the threshold value Th[1], for example.
[0060] Alternatively, the determination means 14 may determine the conditions for issuing a warning through machine learning using data recorded in the database 112 as training data. The determination means 14 performs machine learning by providing, for example, the attribute information of the dealer recorded in the database 112, weather data for the region to which the dealer belongs, and the conditions for issuing a warning (e.g., threshold values) to an input layer of the machine learning model, and the results of regular inspections and abnormality inspections to an output layer as training data. Using this trained machine learning model, when the conditions (e.g., threshold values) for issuing a warning to a certain dealer (whose attributes and region are known) are varied in multiple patterns and input to the input layer, predicted values of the results of the regular inspections and abnormality inspections (i.e., whether or not an abnormality exists) are output from the output layer. For example, the determination means 14 maximizes the threshold value within a range in which the probability of an abnormality does not exceed the threshold value.
[0061] 3-3. How to output warnings The method of outputting the warning is not limited to the example given in the embodiment, but may be output by voice communication, for example.
[0062] 3-4.Warning Address The destination of the warning is not limited to the example given in the embodiment. For example, the setting unit 16 sets the user who is closest to the store at that time among users who have been registered in advance as candidates for the destination of the warning as the destination of the warning.
[0063] 3-5. Warning details The content of the warning is not limited to the example shown in the embodiment. The warning message may include a character string instructing an inspection corresponding to the cause of the abnormality predicted from the inspection results, or a link to an input screen for the inspection results. In this case, for example, the control unit 19 estimates the cause of the abnormality corresponding to the warning. The estimation of the cause of the abnormality is performed, for example, using the attributes of the retailer recorded in the database 111 and the results of regular inspections and abnormal inspections recorded in the database 112. In one example, as described above, the difference D obtained by subtracting the calculated inventory amount from the actual inventory amount should be negative. However, if the difference D is more positive than expected, there is a possibility that other liquids, such as water, have been mixed into the storage facility. Conversely, if the difference D is more negative than expected, there is a possibility that a liquid leak has occurred in the storage facility or related equipment. Alternatively, a more detailed cause may be estimated based on inspection results other than numerical data, or by combining numerical data with other inspection results.
[0064] If the warning message includes an instruction to inspect or a link to an input screen for the inspection results, the output means 17 may output an inspection reminder until the inspection results are input. If the inspection results are not input even after the reminder is output, the setting means 16 may output a reminder to another user (for example, a user with a higher position among users registered in advance as candidates for the destination).
[0065] 3-6. Other embodiments The correspondence between the functional elements and the hardware elements in the inventory management system 1 is not limited to that exemplified in the embodiment. For example, some of the functions described as the server 10 in the embodiment may be implemented in the dealer terminal 20 or the user terminal 30. Alternatively, some of the functions described as the server 10 in the embodiment may be implemented in another device on the network. For example, the databases 111 and 112 may be stored in a device other than the server 10.
[0066] The hardware components of the inventory management system 1 are not limited to those exemplified in the embodiments. The inventory management system 1 may have any hardware configuration as long as it can implement the required functions. For example, the server 10 may be a physical server or a virtual server (e.g., a so-called cloud).
[0067] The UI screens described in the embodiments are merely examples, and the UI screens provided by the inventory management system 1 are not limited to these. Any UI screen may be used as long as it is capable of inputting or outputting the required information. Furthermore, the information input and recorded in the inventory management system 1 is not limited to the examples given in the embodiments. Information not given as an example in the embodiments, such as inventory information, may also be input and recorded.
[0068] The various programs exemplified in the embodiments may be provided by downloading via a network such as the Internet, or may be provided in a state recorded on a recording medium such as a CD-ROM (Compact Disc Read Only Memory). [Explanation of symbols]
[0069] 1... inventory management system, 10... server, 11... storage means, 12... receiving means, 13... writing means, 14... determining means, 15... judging means, 16... setting means, 17... output means, 19... control means, 20... dealer terminal, 21... storage means, 22... receiving means, 23... display means, 24... transmitting means, 25... receiving means, 29... control means, 30... user terminal, 31... storage means, 32... receiving means, 33... display means, 34... transmitting means, 39... control means, 101... CPU, 102... memory, 103... storage, 104... communication IF
Claims
1. a receiving means for receiving input of the sales quantity and actual stock amount of fuel at a retail store that sells volatile fluids at the end of a predetermined unit period from a terminal of the retail store; an output means for outputting a warning to a first destination set for the retail store when a first condition is satisfied, the first condition being a condition relating to a difference between a calculated inventory amount obtained from the sales quantity in a target unit period at the retail store and the actual inventory amount at the end of the unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, the condition indicating that the difference is greater than a reference value; and The first condition is (1) The condition is that the rate of increase or decrease of the cumulative value of the difference over a predetermined period with respect to the cumulative value of the sales volume over the predetermined period is equal to or greater than a threshold value; or (2) The condition is that the ratio of the difference to the sales volume is equal to or greater than a threshold value for a unit period of time that is equal to or greater than the threshold value. Inventory management system.
2. a receiving means for receiving input of the sales quantity and actual stock amount of fuel at a retail store that sells volatile fluids at the end of a predetermined unit period from a terminal of the retail store; an output means for outputting a warning to a first destination set for the retailer when a first condition is satisfied, which condition relates to the difference between the calculated inventory amount obtained from the sales quantity in the target unit period at the retailer and the actual inventory amount at the end of the unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, and indicates that the difference is greater than a standard; a determination means for determining the first condition by one of the following methods (1) and (2); (1) The first condition is determined based on at least one of the attributes of the retailer and the season to which the target unit period belongs, and the first condition is determined to be relaxed when the attributes of the retailer are the region in which the retailer is located and at least one of the attributes of the retailer and the season to which the target unit period belongs indicates that the temperature or the amount of solar radiation at the retailer is relatively high. (2) The first condition is determined using information recorded in a database that records the warning and the results of the inspection for the warning, and when the information indicates that the percentage of cases in which the warning was output but no abnormality was found as a result of the inspection during a predetermined period in the past exceeds a threshold, the first condition is determined to be relaxed. An inventory control system having:
3. a receiving means for receiving input of the sales quantity and actual stock amount of fuel at a retail store that sells volatile fluids at the end of a predetermined unit period from a terminal of the retail store; an output means for outputting a warning to a first destination set for the retailer when a first condition is satisfied, which condition relates to the difference between the calculated inventory amount obtained from the sales quantity in the target unit period at the retailer and the actual inventory amount at the end of the unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, and indicates that the difference is greater than a standard; a setting means for setting the destination of the warning to a second destination different from the first destination when a second condition related to the difference, which is stricter than the first condition, is satisfied; An inventory control system having:
4. the receiving means receives an input of the result of an inspection carried out at the dealer in response to the warning, a writing means for writing the received results into a database for recording the warning and the results of the inspection for the warning; The inventory management system according to claim 1 or 3.
5. the receiving means receives an input of the result of an inspection carried out at the dealer in response to the warning, a writing means for writing the received results into a database for recording the warning and the results of the inspection for the warning; The inventory management system of claim 2 .
6. a determining means for determining the first condition using information recorded in the database, and determining to relax the first condition when the information indicates that the percentage of cases in which the warning was output but no abnormality was found as a result of the inspection during a predetermined past period exceeds a threshold value; The inventory control system according to claim 4, further comprising:
7. A computer comprising: receiving an input of the sales quantity and actual inventory amount of fuel at the store selling the volatile fluid at the end of a predetermined unit period from a terminal of the store; a step of outputting a warning to a first destination set for the retailer when a first condition is satisfied, the first condition being a condition relating to a difference between a calculated inventory amount obtained from the sales quantity in a target unit period at the retailer and the actual inventory amount at the end of a unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, the difference being greater than a reference value; and The first condition is (1) The condition is that the rate of increase or decrease of the cumulative value of the difference over a predetermined period with respect to the cumulative value of the sales volume over the predetermined period is equal to or greater than a threshold value; or (2) The condition is that the ratio of the difference to the sales volume is equal to or greater than a threshold value for a unit period of time that is equal to or greater than the threshold value. Inventory management methods.
8. A computer comprising: receiving an input of the sales quantity and actual inventory amount of fuel at the store selling the volatile fluid at the end of a predetermined unit period from a terminal of the store; a step of outputting a warning to a first destination set for the retailer when a first condition is satisfied, the first condition being a condition regarding the difference between the calculated inventory amount obtained from the sales quantity in the target unit period at the retailer and the actual inventory amount at the end of the unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, the difference being greater than a standard; determining the first condition by one of the following methods (1) and (2); (1) The first condition is determined based on at least one of the attributes of the retailer and the season to which the target unit period belongs, and the first condition is determined to be relaxed when the attributes of the retailer are the region in which the retailer is located and at least one of the attributes of the retailer and the season to which the target unit period belongs indicates that the temperature or the amount of solar radiation at the retailer is relatively high. (2) The first condition is determined using information recorded in a database that records the warning and the results of the inspection for the warning, and when the information indicates that the percentage of cases in which the warning was output but no abnormality was found as a result of the inspection during a predetermined period in the past exceeds a threshold, the first condition is determined to be relaxed. An inventory control method having the following.
9. A computer comprising: receiving an input of the sales quantity and actual inventory amount of fuel at the store selling the volatile fluid at the end of a predetermined unit period from a terminal of the store; a step of outputting a warning to a first destination set for the retailer when a first condition is satisfied, the first condition being a condition regarding the difference between the calculated inventory amount obtained from the sales quantity in the target unit period at the retailer and the actual inventory amount at the end of the unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, the difference being greater than a standard; setting the destination of the warning to a second destination different from the first destination when a second condition related to the difference, which is stricter than the first condition, is satisfied; An inventory control method having the following.
10. On the computer, receiving an input of the sales quantity and actual inventory amount of fuel at the store selling the volatile fluid at the end of a predetermined unit period from a terminal of the store; a step of outputting a warning to a first destination set for the retailer when a first condition is satisfied, the first condition being a condition relating to a difference between a calculated inventory amount obtained from the sales quantity in a target unit period at the retailer and the actual inventory amount at the end of a unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, the difference being greater than a reference value; A program for executing The first condition is (1) The condition is that the rate of increase or decrease of the cumulative value of the difference over a predetermined period with respect to the cumulative value of the sales volume over the predetermined period is equal to or greater than a threshold value; or (2) The condition is that the ratio of the difference to the sales volume is equal to or greater than a threshold value for a unit period of time that is equal to or greater than the threshold value. program.
11. On the computer, receiving an input of the sales quantity and actual inventory amount of fuel at the store selling the volatile fluid at the end of a predetermined unit period from a terminal of the store; a step of outputting a warning to a first destination set for the retailer when a first condition is satisfied, the first condition being a condition regarding the difference between the calculated inventory amount obtained from the sales quantity in the target unit period at the retailer and the actual inventory amount at the end of the unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, the difference being greater than a standard; determining the first condition by one of the following methods (1) and (2); (1) The first condition is determined based on at least one of the attributes of the retailer and the season to which the target unit period belongs, and the first condition is determined to be relaxed when the attributes of the retailer are the region in which the retailer is located and at least one of the attributes of the retailer and the season to which the target unit period belongs indicates that the temperature or the amount of solar radiation at the retailer is relatively high. (2) The first condition is determined using information recorded in a database that records the warning and the results of the inspection for the warning, and when the information indicates that the percentage of cases in which the warning was output but no abnormality was found as a result of the inspection during a predetermined period in the past exceeds a threshold, the first condition is determined to be relaxed. A program to execute.
12. On the computer, receiving an input of the sales quantity and actual inventory amount of fuel at the store selling the volatile fluid at the end of a predetermined unit period from a terminal of the store; a step of outputting a warning to a first destination set for the retailer when a first condition is satisfied, the first condition being a condition regarding the difference between the calculated inventory amount obtained from the sales quantity in the target unit period at the retailer and the actual inventory amount at the end of the unit period immediately preceding the target unit period, and the actual inventory amount at the end of the target unit period, the difference being greater than a standard; setting the destination of the warning to a second destination different from the first destination when a second condition related to the difference, which is stricter than the first condition, is satisfied; A program to execute.
Citation Information
Patent Citations
Device and method for detecting hydraulic oil leakage
CN105570234A
Oil product gain and loss monitoring method and system
CN111003680A
Oil stealing alarm device for truck external oil tank
CN111347873A
System and device for managing maintenance
JP2005162212A
Leakage monitoring system, and server and method therefor
JP2006209439A