Loss overflow analysis system and method for gas station
By designing a loss and overflow analysis system, loss and overflow analysis is carried out on the purchase, storage and sales of gas stations, which solves the loss and overflow problems in gas station operations, and achieves rapid and accurate loss and overflow identification and improvement of operational efficiency.
Patent Information
- Application Number
- CN202411798381.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-09
- Publication Date
- 2025-03-18
AI Technical Summary
The gas station has problems of loss and overflow in the purchase acceptance, oil storage and oil sales, resulting in economic losses and operating benefits.
Design a loss and overflow analysis system, and through the loss and overflow classification module, data acquisition module and loss and overflow analysis module, it can quickly and accurately analyze the purchase, storage and sales links of gas stations. The system compares the actual data with the theoretical data to determine whether there is loss and overflow, and uses curve construction and threshold comparison methods to identify loss and overflow problems.
It has achieved rapid identification and accurate assessment of losses and overflow problems during the operation of gas stations, helping gas stations to promptly discover and solve problems, improve operational efficiency, and protect legitimate rights and interests.
Smart Images

Figure CN119647781A_ABST
Abstract
Description
Technical Field
[0001] The present invention belongs to the technical field of gas station safety management and control, and in particular relates to a loss and surplus analysis system and method for gas stations. Background Art
[0002] The finished oil business of gas stations mainly covers three key links: incoming goods acceptance, oil storage and oil sales. In the incoming goods acceptance link, gas stations and carriers, as the main responsible entities, need to jointly ensure the smooth progress of the incoming goods acceptance process. This link involves the implementation of compensation for over-consumption of oil products and the completeness of the loading and unloading of incoming oil products. These factors are directly related to the profit and loss situation of gas stations, and thus have an important impact on the company's creation of benefits. If any errors occur in the incoming goods acceptance link, it may cause economic losses to the gas station, thereby affecting the overall economic benefits of the company. At the same time, access to external gas station pick-up data such as electronic waybill data, compare the pick-up data with the actual incoming goods data of the gas station, realize risk supervision in the incoming goods link, and at the same time realize risk supervision on the quality of electronic waybill data, improve the data quality of the electronic waybill system, and help government regulatory departments to supervise hazardous chemicals.
[0003] In the oil storage process, gas stations need to ensure the safe storage of oil and prevent any situation that may cause fuel leakage. Once oil leakage occurs, it will not only increase the loss of the gas station, but also cause serious risks such as fire and environmental pollution. In addition, gas station employees may steal oil for personal gain, which will further increase the loss of the gas station. Therefore, the safety management of the oil storage process is crucial to the operation of gas stations.
[0004] The oil product sales link is the link where gas stations directly face consumers, and its key risk lies in the risk of measurement accuracy. As the core equipment of gas stations, the stability of the gas station equipment is crucial. If there is a stability problem with the gas station, it may cause measurement deviation, thus affecting the accuracy of measurement. In addition, criminals may use high-tech cheating methods to affect the accuracy of the gas station, which not only damages the rights and interests of consumers, but also damages the interests of gas stations. Therefore, gas stations need to strictly supervise the gas station to ensure its measurement accuracy.
[0005] With the promotion and application of liquid level meters at gas stations, the metering operation of gas stations has achieved automatic metering, greatly improving the accuracy and efficiency of metering. At the same time, with the promotion and application of station-level management and control systems, the sales flow of gas pumps can be transmitted in real time, so that the gas station's purchase acceptance loss calculation and daily (shift) inventory loss and surplus can be automatically calculated by the system. This progress has reduced the labor intensity of gas station employees while also reducing the impact of human intervention on loss and surplus data to a certain extent. However, despite the support of these technical means, the aforementioned personnel operation standardization, abnormal loss and surplus risks, and gas pump risk supervision still rely more on gas station employees to implement in accordance with system requirements. Therefore, these risks still have uncontrollable factors, which require gas stations to continue to pay attention to and improve. Summary of the invention
[0006] In order to solve the technical problems existing in the known technology, the present invention provides a loss and surplus analysis system and method for gas stations, which can quickly and accurately analyze the loss and surplus of three links in the oil tasting business and protect the legitimate rights and interests of gas stations and consumers.
[0007] The first object of the present invention is to provide a loss and surplus analysis system for a gas station, comprising:
[0008] The loss and gain classification module divides the loss and gain into purchase loss and gain, storage loss and gain, and sales volume loss and gain according to the occurrence link of loss and gain in the refined oil business;
[0009] The data acquisition module continuously acquires the actual data of the purchase link, the actual data of the storage link, and the actual data of the sales link;
[0010] The loss / gain analysis module analyzes the actual data of the purchasing link with the theoretical data of the purchasing link to determine whether there is any purchase loss / gain; analyzes the actual data of the storage link with the theoretical data of the storage link to determine whether there is any storage loss / gain; and analyzes the actual data of the sales link with the theoretical data of the sales link to determine whether there is any sales volume loss / gain.
[0011] Preferably, the loss / expenditure analysis module comprises:
[0012] The curve construction unit constructs the actual change curve of the purchase link, the actual change curve of the storage link, and the actual change curve of the sales link according to the corresponding relationship between the actual data of the purchase link, the actual data of the storage link, and the actual data of the sales link and time; and constructs the theoretical change curve of the purchase link, the theoretical change curve of the storage link, and the theoretical change curve of the sales link according to the corresponding relationship between the theoretical data of the purchase link, the theoretical data of the storage link, and the theoretical data of the sales link and time;
[0013] The threshold comparison unit compares the actual change curve of the purchase link within the same time period with the theoretical change curve of the purchase link to obtain the purchase difference at different times, and compares the purchase difference with the purchase threshold. If the purchase difference is within the purchase threshold range, there is no purchase loss or surplus, otherwise, there is a purchase loss or surplus; compares the actual change curve of the storage link within the same time period with the theoretical change curve of the storage link to obtain the storage difference at different times, and compares the storage difference with the storage threshold. If the storage difference is within the storage threshold range, there is no storage loss or surplus, otherwise, there is a storage loss or surplus; compares the actual change curve of the sales link within the same time period with the theoretical change curve of the sales link to obtain the sales difference at different times, and compares the sales difference with the sales threshold. If the sales difference is within the sales threshold range, there is no sales loss or surplus, otherwise, there is a sales loss or surplus.
[0014] Preferably: the actual data of the purchase link includes the actual inventory of each oil product in each gas station; the theoretical data of the purchase link = inventory before purchase + purchase volume of the oil depot;
[0015] The actual data of the storage link includes the gas station sales volume of each oil product in each gas station and the inventory at the end of the storage period; the theoretical data of the storage link = the inventory at the beginning of the period + the amount of oil depot input during the storage period;
[0016] The actual data of the sales link include the gas station sales volume and ending inventory of each oil product in each gas station; the theoretical data of the sales link = beginning inventory + oil depot intake during the sales period.
[0017] Preferably, the actual change curve of the purchasing link includes the daily average purchase actual change curve, the weekly average purchase actual change curve and the monthly average purchase actual change curve, the actual change curve of the storage link includes the daily average storage actual change curve, the weekly average storage actual change curve and the monthly average storage actual change curve, and the actual change curve of the sales link includes the daily average sales actual change curve, the weekly average sales actual change curve and the monthly average sales actual change curve.
[0018] Preferably: Purchase loss or surplus = inventory before purchase + purchase quantity of oil depot - actual inventory;
[0019] Storage loss / gain = beginning inventory + oil depot purchase during storage period - oil station sales - ending inventory during storage period;
[0020] Sales volume loss / gain = beginning inventory + oil depot purchases during sales period - gas station sales - ending inventory.
[0021] A second object of the present invention is to provide a method for analyzing loss and gain for a gas station, comprising the following steps:
[0022] Loss and gain classification: according to the stage where losses and gains occur in the refined oil business, losses and gains are divided into purchase losses and gains, storage losses and gains, and sales volume losses and gains;
[0023] Data acquisition: continuously acquire actual data from the purchase, storage and sales stages;
[0024] Loss and gain analysis: analyze the actual data of the purchasing link with the theoretical data of the purchasing link to determine whether there is a purchase loss or gain; analyze the actual data of the storage link with the theoretical data of the storage link to determine whether there is a storage loss or gain; analyze the actual data of the sales link with the theoretical data of the sales link to determine whether there is a sales volume loss or gain.
[0025] Preferably, the loss / gain analysis includes:
[0026] Curve construction: According to the corresponding relationship between the actual data of the purchase link, the actual data of the storage link, the actual data of the sales link and time, the actual change curve of the purchase link, the actual change curve of the storage link, and the actual change curve of the sales link are constructed respectively; according to the corresponding relationship between the theoretical data of the purchase link, the theoretical data of the storage link, the theoretical data of the sales link and time, the theoretical change curve of the purchase link, the theoretical change curve of the storage link, and the theoretical change curve of the sales link are constructed respectively;
[0027] Threshold comparison, compare the actual change curve of the purchasing link within the same time period with the theoretical change curve of the purchasing link to obtain the purchase difference at different times, compare the purchase difference with the purchase threshold, if the purchase difference is within the purchase threshold range, there is no purchase loss or surplus, otherwise, there is a purchase loss or surplus; compare the actual change curve of the storage link within the same time period with the theoretical change curve of the storage link to obtain the storage difference at different times, compare the storage difference with the storage threshold, if the storage difference is within the storage threshold range, there is no storage loss or surplus, otherwise, there is a storage loss or surplus; compare the actual change curve of the sales link within the same time period with the theoretical change curve of the sales link to obtain the sales difference at different times, compare the sales difference with the sales threshold, if the sales difference is within the sales threshold range, there is no sales loss or surplus, otherwise, there is a sales loss or surplus.
[0028] Preferably: the actual data of the purchase link includes the actual inventory of each oil product in each gas station; the theoretical data of the purchase link = inventory before purchase + purchase volume of the oil depot;
[0029] The actual data of the storage link includes the gas station sales volume of each oil product in each gas station and the inventory at the end of the storage period; the theoretical data of the storage link = the inventory at the beginning of the period + the amount of oil depot input during the storage period;
[0030] The actual data of the sales link include the gas station sales volume and ending inventory of each oil product in each gas station; the theoretical data of the sales link = beginning inventory + oil depot intake during the sales period.
[0031] Preferably, the actual change curve of the purchasing link includes the daily average purchase actual change curve, the weekly average purchase actual change curve and the monthly average purchase actual change curve, the actual change curve of the storage link includes the daily average storage actual change curve, the weekly average storage actual change curve and the monthly average storage actual change curve, and the actual change curve of the sales link includes the daily average sales actual change curve, the weekly average sales actual change curve and the monthly average sales actual change curve.
[0032] Preferably: Purchase loss or surplus = inventory before purchase + purchase quantity of oil depot - actual inventory;
[0033] Storage loss / gain = beginning inventory + oil depot purchase during storage period - oil station sales - ending inventory during storage period;
[0034] Sales volume loss / gain = beginning inventory + oil depot purchases during sales period - gas station sales - ending inventory.
[0035] The advantages and positive effects of the present invention are:
[0036] The present invention is used to analyze and identify the loss and surplus problems that may occur during the operation of a gas station. First, the present invention subdivides the loss and surplus problems of a gas station into three main links: purchase loss and surplus, storage loss and surplus, and sales volume loss and surplus. By conducting in-depth analysis of these three links, the specific problems can be effectively identified, thereby achieving a rapid and accurate assessment of the loss and surplus situation of a gas station.
[0037] Specifically, the present invention compares and analyzes the actual purchase data with the theoretical purchase data in the purchase link. Through this analysis, it can be quickly and accurately determined whether there is a loss or surplus problem in the purchase link. For example, if there is a significant difference between the actual purchase volume and the theoretical purchase volume, then it can be determined that there is some form of loss or surplus in the purchase link.
[0038] In the storage link, the present invention also compares and analyzes the actual storage data with the theoretical storage data. Through this analysis, it is possible to quickly and accurately determine whether there is a loss or surplus problem in the storage link. For example, if there is a difference between the actual inventory and the theoretical inventory, it can be determined that there is some form of loss or surplus in the storage link.
[0039] Finally, in the sales process, the present invention compares and analyzes the actual sales data with the theoretical sales data. Through this analysis, it is possible to quickly and accurately determine whether there is a sales volume loss or surplus problem. For example, if there is a difference between the actual sales volume and the theoretical sales volume, it can be determined that there is some form of loss or surplus in the sales process.
[0040] In summary, the present invention can effectively identify specific problems by subdividing the loss and surplus problems of gas stations into three links: purchasing, storage and sales, and conducting detailed analysis of the actual and theoretical data of each link, thereby providing strong support for the operation and management of gas stations. BRIEF DESCRIPTION OF THE DRAWINGS
[0041] Figure 1 is a structural block diagram of a preferred embodiment of the present invention;
[0042] Figure 2 The types of risks that may occur in different links of a gas station;
[0043] Figure 3 It is an inventory curve chart in a preferred embodiment of the present invention;
[0044] Figure 4 A data association diagram involved in the process of identifying the risk of illegal oil inflow in the present invention;
[0045] Figure 5 This is a data association diagram involved in the process of identifying cheating at a fuel dispenser according to the present invention;
[0046] Figure 6 A data association diagram involved in the process of identifying tampered sales data in the present invention;
[0047] Figure 7 A specific example diagram of the present invention in use;
[0048] Figure 8 Another specific example of the present invention in use is shown in FIG. DETAILED DESCRIPTION
[0049] In order to further understand the content, features and effects of the present invention, the following embodiments are listed and described in detail with reference to the accompanying drawings:
[0050] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the technical solutions in the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0051] First embodiment:
[0052] See also Figure 1 , a loss and surplus analysis system for a gas station, comprising:
[0053] In the operation process of refined oil business, the loss and surplus classification module plays a vital role. This module mainly covers three key links: purchasing link, storage link and sales link. In order to quickly locate and solve related problems, this embodiment adopts an effective classification method, that is, to divide the losses and surpluses according to the links where they occur. Specifically, losses and surpluses are divided into three categories: purchase losses and surpluses, storage losses and surpluses, and sales volume losses and surpluses. Purchase losses and surpluses usually occur in the purchase stage, which refers to the difference between the actual data and the theoretical data in the purchase link; storage losses and surpluses occur in the storage stage, involving the inconsistency between the actual data and the theoretical data in the storage link; and sales volume losses and surpluses are the differences between the actual data and the theoretical data in the sales link during the sales stage.
[0054] In order to achieve real-time monitoring and analysis of data in these links, the data acquisition module plays an indispensable role. This module is responsible for continuously collecting actual data from the purchase, storage and sales links. Specifically, the actual data of the purchase link covers the actual inventory of each oil product in each gas station; the theoretical data of the purchase link is calculated by adding the inventory before purchase to the oil depot purchase. The actual data of the storage link includes the gas station sales volume of each oil product in each gas station and the inventory at the end of the storage period; the theoretical data of the storage link is calculated based on the initial inventory plus the oil depot purchase during the storage period. The actual data of the sales link also includes the gas station sales volume of each oil product in each gas station and the inventory at the end of the period; the theoretical data of the sales link is obtained by adding the initial inventory to the oil depot purchase during the sales period.
[0055] The loss / gain analysis module is the core part of the whole system. It conducts in-depth analysis on the actual data and theoretical data of the purchase, storage and sales links to determine whether there are corresponding losses / gains. This module includes several key sub-modules. The first is the curve construction unit. This unit constructs the actual change curve of the purchase link, the actual change curve of the storage link and the actual change curve of the sales link according to the corresponding relationship between the actual data and time of the purchase, storage and sales links. At the same time, it also constructs the theoretical change curve of the purchase link, the theoretical change curve of the storage link and the theoretical change curve of the sales link according to the corresponding relationship between the theoretical data and time.
[0056] Next is the threshold comparison unit, which is responsible for comparing the actual change curve with the theoretical change curve in the same time period. In this way, the purchase difference, storage difference and sales difference at different times can be obtained. Then, these differences are compared with their respective thresholds. If the purchase difference is within the purchase threshold range, it can be determined that there is no purchase loss or surplus; otherwise, there is a purchase loss or surplus. The same method is also applicable to the storage link and the sales link. By comparing the storage difference with the storage threshold, and the sales difference with the sales threshold, it can be determined whether there is a storage loss or surplus and a sales loss or surplus.
[0057] In addition, in order to analyze the loss and gain situation more carefully, the actual change curve of the purchasing link includes the daily average purchase actual change curve, the weekly average purchase actual change curve and the monthly average purchase actual change curve; the actual change curve of the storage link includes the daily average storage actual change curve, the weekly average storage actual change curve and the monthly average storage actual change curve; the actual change curve of the sales link includes the daily average sales actual change curve, the weekly average sales actual change curve and the monthly average sales actual change curve.
[0058] Finally, in order to quantify the specific value of the loss / spill, this embodiment defines the following formula:
[0059] Purchase loss / gain = pre-purchase inventory + purchase quantity of oil depot - actual inventory;
[0060] Storage loss / gain = beginning inventory + oil depot purchase during storage period - oil station sales - ending inventory during storage period;
[0061] Sales volume loss / gain = beginning inventory + oil depot purchases during sales period - gas station sales - ending inventory.
[0062] Through these detailed analyses and calculations, loss and surplus problems in the refined oil business can be effectively identified and resolved, thus ensuring the smoothness and efficiency of the entire business process.
[0063] In order to more deeply understand the technical solution of the present invention, the following non-limiting examples are given:
[0064] The loss / gain analysis module covers the analysis model of abnormal balance between account and actual and purchase and sales, and its purpose is to identify and effectively prevent potential risks such as "illegal oil purchase behavior, fuel dispenser fraud and sales data tampering behavior". In the daily operation and management of gas stations, it is necessary to ensure the consistency between the physical quantity of oil products and the accounting records. At the same time, a balance must be maintained between the oil purchase data, inventory data, sales data and tax reporting data. Figure 2As shown: the purchasing data is subdivided into theoretical data and actual data of the purchasing link; the inventory data includes theoretical inventory data and actual inventory data; the sales data is composed of actual data and theoretical data of the sales link; the tax reporting data includes theoretical tax reporting data and actual tax reporting data.
[0065] (1) Identification of risks of illegal oil purchases: Potential risks are identified by conducting a comprehensive comparison and analysis of purchase data with inventory data, sales data and tax return data (if applicable). Specific situations include: the electronic waybill is missing but the system pushes the oil purchase information, indicating the risk of "illegal oil purchase"; the number of goods received exceeds the order quantity and the vehicle carrying capacity, indicating the risk of "overload"; the electronic waybill has a purchase record but the gas station has not actually received the oil, or the number of electronic waybills is less than the actual purchase quantity, reflecting data quality issues, etc.
[0066] like Figure 4 As shown: Identification of illegal oil import risk is carried out by comparing and analyzing the purchase data with inventory data, sales data, and tax declaration data (when applicable): If there is no purchase on the electronic waybill, there is a risk of "illegal oil import"; if the number of goods received exceeds the order quantity and the vehicle load, there is a risk of "overloading"; if there is a purchase document on the electronic waybill, the gas station actually does not import oil, the number of electronic waybill is less than the actual purchase quantity, and other data quality issues;
[0067] (2) Risk identification of fuel dispenser fraud is to monitor the operation of fuel dispensers by comparing inventory data with sales data. If the tank output is continuously lower than the sales volume displayed on the fuel dispenser, resulting in an aggravated imbalance between purchase and sales, there is a risk of fuel dispenser fraud and withholding fuel from customers; conversely, if the tank output is continuously higher than the sales volume displayed on the fuel dispenser, there may be a risk of concealing sales data, which is achieved through fuel dispenser fraud or external fuel dispensers.
[0068] like Figure 5 As shown: The risk identification of gas station cheating is through the comparison and analysis of inventory data and sales data: if the tank output is continuously lower than the sales volume displayed by the oil machine, the imbalance between purchase and sales is aggravated, and there is a risk of gas station cheating, withholding oil products from customers; if the tank output is continuously higher than the sales volume displayed by the oil machine, there is a risk of concealing sales data, which is achieved through gas station cheating or external gas station
[0069] (3) Sales data tampering risk identification is carried out through comprehensive comparison and analysis of tax reporting data with sales data, inventory data, and purchase data. If the comparison between tax reporting data (provided by the Golden Tax System) and sales data exceeds the risk threshold (set by the management department), a tax evasion risk reminder will be issued; in the absence of tax reporting data, the actual sales data (taxable data) will be calculated based on the basic data for use by the tax department in tax evasion risk verification.
[0070] like Figure 6As shown: The risk identification of sales data tampering is carried out by comparing and analyzing the tax return data with the sales data, inventory data, and purchase data: If the tax return data is available, the tax return data (provided by the Golden Tax System) is compared and reviewed with the sales data, and a tax evasion risk reminder is issued if the risk threshold (set by the management department) is exceeded; when the tax return data is missing, the actual sales data (taxable data) is calculated based on the basic data and provided to the tax department for tax evasion risk verification.
[0071] The present invention can also verify the basic data, specifically including:
[0072] a. Historical liquid level curve analysis
[0073] The gas station metering risk prevention and control model based on the verification of gas station purchase, sales and inventory data is implemented based on the unified time of the gas station. Once the difference between the inventory time and the sales time exceeds the threshold, it will affect the hierarchical screening results. In addition to the method of on-site time verification, the risk can be matched by the incoming inventory time point data and the Beijing time at 0 o'clock and 24 o'clock. Risk reminders and rectification are carried out for gas stations that exceed the time threshold; and with the upgrade of the algorithm, the inventory data restoration calculation is promoted to eliminate the impact of inconsistent time.
[0074] Analyze the data integrity of historical liquid level curves, conduct data statistics and characteristic risk screening on the frequency and time of liquid level interruptions, and conduct key risk screening on oil tank storage losses and spills where the data interruption time exceeds the threshold.
[0075] b. Sales flow analysis
[0076] The sales flow is analyzed based on the gas pump. The cumulative pump code number is generated based on the cumulative pump code number of the previous sales flow of the gas pump and the current sales volume. Based on this logic, the pump code number jump or sales flow loss is actively pushed and risk checked.
[0077] c. Parameter adjustment risk supervision
[0078] The adjustment of the oil level and water level parameters of the level meter will have a significant impact on the change of the oil storage volume in the oil tank, which will be manifested as a periodic abnormal surplus (loss). If there is a level meter comparison out of tolerance, parameter adjustment, there are clear approval procedures, and a parameter adjustment record will be formed in the system. By identifying the carbon rod parameter results and adjusting the system parameters accordingly, the risk of parameter adjustment is supervised.
[0079] d. Abnormal temperature
[0080] Based on the correspondence between the temperature data fed back by the temperature sensors at different heights of the carbon rods and the storage temperature in the tank, an early warning of potential temperature sensor failure risks is pushed.
[0081] like Figure 3 As shown: the second curve 2 is the actual change curve; the first curve 1 is the simulated liquid level curve, that is, the theoretical change curve; the third curve 3 is the difference curve, which represents the difference between the actual change curve and the theoretical change curve. The rise of the difference curve represents a decrease in oil tank loss and an increase in oil product surplus; the fall of the difference curve represents an increase in oil tank loss and a decrease in oil product surplus.
[0082] Second embodiment:
[0083] A loss / gain analysis method for a gas station comprises the following steps:
[0084] In the refined oil business, the classification of losses and gains is carried out according to the specific links in which they occur. These links mainly include purchase, storage and sales. According to these links, losses and gains can be further subdivided into purchase losses and gains, storage losses and gains, and sales losses and gains. In order to better understand and manage these losses and gains, this embodiment needs to continuously obtain the actual data of the relevant links. Specifically, the actual data of the purchase link covers the actual inventory of each oil product in each gas station. The theoretical data of the purchase link is obtained by adding the inventory before purchase to the purchase volume of the oil depot. In the storage link, the actual data includes the gas station sales volume of each oil product in each gas station and the inventory volume at the end of the storage period. The theoretical data of the storage link is the sum of the initial inventory and the purchase volume of the oil depot during the storage period. As for the sales link, the actual data also includes the gas station sales volume and the end inventory volume of each oil product in each gas station. The theoretical data of the sales link is the sum of the initial inventory and the purchase volume of the oil depot during the sales period.
[0085] Loss and gain analysis is achieved by comparing the actual data of the purchase link with the theoretical data to determine whether there is a purchase loss and gain. The same method is also applicable to the storage link and sales link. By comparing and analyzing the actual data with the theoretical data, it can be determined whether there is a storage loss and gain and a sales loss and gain. The process of loss and gain analysis includes the following steps:
[0086] First, this embodiment needs to construct a curve. Specifically, this embodiment will construct the actual change curve of the purchase link, the actual change curve of the storage link, and the actual change curve of the sales link according to the corresponding relationship between the actual data of the purchase link, the storage link, and the sales link and time. Similarly, this embodiment will also construct the theoretical change curve of the purchase link, the theoretical change curve of the storage link, and the theoretical change curve of the sales link according to the corresponding relationship between the theoretical data and time.
[0087] Next, threshold comparison is performed. This embodiment compares the actual change curve within the same time period with the theoretical change curve to obtain the difference at different times. For example, in the purchase link, this embodiment will obtain the purchase difference and compare it with the purchase threshold. If the purchase difference is within the purchase threshold range, it can be considered that there is no purchase loss or surplus; otherwise, there is a purchase loss or surplus. The same method is also applicable to the storage link and the sales link. By comparing the storage difference with the storage threshold, and the sales difference with the sales threshold, this embodiment can determine whether there is a storage loss or surplus and a sales volume loss or surplus.
[0088] In order to analyze the loss and gain in more detail, the actual change curve of the purchase link can be further subdivided into the daily average purchase actual change curve, the weekly average purchase actual change curve and the monthly average purchase actual change curve. The actual change curve of the storage link can also be subdivided into the daily average storage actual change curve, the weekly average storage actual change curve and the monthly average storage actual change curve. The actual change curve of the sales link can also be subdivided into the daily average sales actual change curve, the weekly average sales actual change curve and the monthly average sales actual change curve.
[0089] Finally, in this embodiment, the specific loss / surplus value can be calculated by the following formula:
[0090] Purchase loss / gain = pre-purchase inventory + purchase quantity of oil depot - actual inventory;
[0091] Storage loss / gain = beginning inventory + oil depot purchase during storage period - oil station sales - ending inventory during storage period;
[0092] Sales volume loss / gain = beginning inventory + oil depot purchases during sales period - gas station sales - ending inventory.
[0093] Through these detailed steps and calculation methods, this embodiment can effectively identify and manage loss and surplus problems in the refined oil business.
[0094] Application Cases
[0095] Checking the No. 1 tank of a gas station, it was found that the phased tank output-sales loss on June 5 was abnormal. There was no change in the oil stock in the tank, sales were made in the tank, and a large amount of sales volume did not match the tank output.
[0096]
[0097] Further checking of the inventory level curve revealed that the station's inventory curve corresponds to 13:17 in the station at 24:00 Beijing time, and there is a synchronization problem with the level meter clock.
[0098] like Figure 7As shown, the scenario simulation of this case is intended to test the integrity of the system function. The actual sales data is "reduced" by artificial means to simulate the specific scenario of "concealing sales volume". In this scenario, the actual inventory volume has repeatedly been lower than the theoretical inventory volume. In particular, when refueling operations are performed, the actual inventory decreases significantly faster than the theoretical inventory decreases. The full-day inventory difference reached -3,500 liters, which has exceeded the preset risk push threshold (the threshold is initially set to -200 liters). In response to the above situation, the system issued a risk reminder of "concealing sales volume".
[0099] like Figure 8 As shown, the second curve 2 is the actual change curve; the first curve 1 is the simulated liquid level curve, that is, the theoretical change curve; this case simulates that the actual inventory quantity exceeds the theoretical inventory quantity, and the cumulative volume difference on that day reaches more than 4,000 liters; there is a risk of cheating by the oil machine and deducting the weight of the user, and there may be incomplete sales data on that day, which requires further analysis. When this difference exceeds the preset threshold (initial setting is 200 liters), the system triggers the risk warning of "abnormal sales (high)". After subsequent verification and confirmation, the cause of this phenomenon is that the configuration of the oil gun of the liquid level meter of the gas station is wrong, resulting in the sales of other oil tanks being mistakenly counted into the sales of this oil tank, thus causing abnormal sales (high).
[0100] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When the use is implemented in whole or in part in the form of a computer program product, the computer program product includes one or more computer instructions. When the computer program instructions are loaded or executed on a computer, the process or function described in the embodiment of the present invention is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions may be transmitted from one website site, computer, server or data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL) or wireless (e.g., infrared, wireless, microwave, etc.) mode) to another website site, computer, server or data center. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server or data center that includes one or more available media integrated. The available medium may be a magnetic medium (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state hard disk SolidState Disk (SSD)), etc.
[0101] The above description is only a preferred embodiment of the present invention and does not limit the present invention in any form. Any simple modification, equivalent changes and modifications made to the above embodiments based on the technical essence of the present invention are within the scope of the technical solution of the present invention.
Claims
1. A loss and surplus analysis system for a gas station, characterized in that: include: The loss and gain classification module divides the loss and gain into purchase loss and gain, storage loss and gain, and sales volume loss and gain according to the occurrence link of loss and gain in the refined oil business; The data acquisition module continuously acquires the actual data of the purchase link, the actual data of the storage link, and the actual data of the sales link; The loss / gain analysis module analyzes the actual data of the purchasing link with the theoretical data of the purchasing link to determine whether there is any purchase loss / gain; analyzes the actual data of the storage link with the theoretical data of the storage link to determine whether there is any storage loss / gain; and analyzes the actual data of the sales link with the theoretical data of the sales link to determine whether there is any sales volume loss / gain.
2. The loss and surplus analysis system for a gas station according to claim 1, characterized in that: The loss / gain analysis module comprises: The curve construction unit constructs the actual change curve of the purchase link, the actual change curve of the storage link, and the actual change curve of the sales link according to the corresponding relationship between the actual data of the purchase link, the actual data of the storage link, and the actual data of the sales link and time; and constructs the theoretical change curve of the purchase link, the theoretical change curve of the storage link, and the theoretical change curve of the sales link according to the corresponding relationship between the theoretical data of the purchase link, the theoretical data of the storage link, and the theoretical data of the sales link and time; The threshold comparison unit compares the actual change curve of the purchase link within the same time period with the theoretical change curve of the purchase link to obtain the purchase difference at different times, and compares the purchase difference with the purchase threshold. If the purchase difference is within the purchase threshold range, there is no purchase loss or surplus, otherwise, there is a purchase loss or surplus; compares the actual change curve of the storage link within the same time period with the theoretical change curve of the storage link to obtain the storage difference at different times, and compares the storage difference with the storage threshold. If the storage difference is within the storage threshold range, there is no storage loss or surplus, otherwise, there is a storage loss or surplus; compares the actual change curve of the sales link within the same time period with the theoretical change curve of the sales link to obtain the sales difference at different times, and compares the sales difference with the sales threshold. If the sales difference is within the sales threshold range, there is no sales loss or surplus, otherwise, there is a sales loss or surplus.
3. The loss and surplus analysis system for a gas station according to claim 1, characterized in that: The actual data of the purchase link includes the actual inventory of each oil product in each gas station; the theoretical data of the purchase link = inventory before purchase + purchase volume of the oil depot; The actual data of the storage link includes the gas station sales volume of each oil product in each gas station and the inventory at the end of the storage period; Theoretical data of storage link = opening inventory + oil depot intake during storage period; The actual sales data include the gas station sales volume and ending inventory of each oil product in each gas station; Theoretical data of sales link = beginning inventory + oil depot intake during sales period.
4. The loss and surplus analysis system for a gas station according to claim 2, characterized in that: The actual change curves in the purchasing link include the daily average purchase actual change curve, the weekly average purchase actual change curve and the monthly average purchase actual change curve; the actual change curves in the storage link include the daily average storage actual change curve, the weekly average storage actual change curve and the monthly average storage actual change curve; the actual change curves in the sales link include the daily average sales actual change curve, the weekly average sales actual change curve and the monthly average sales actual change curve.
5. The loss and surplus analysis system for a gas station according to claim 3, characterized in that: Purchase loss / gain = pre-purchase inventory + purchase quantity of oil depot - actual inventory; Storage loss / gain = beginning inventory + oil depot purchase during storage period - oil station sales - ending inventory during storage period; Sales volume loss / gain = beginning inventory + oil depot purchases during sales period - gas station sales - ending inventory.
6. A method for analyzing loss and surplus for a gas station, characterized in that: The steps include: Loss and gain classification: according to the stage where losses and gains occur in the refined oil business, losses and gains are divided into purchase losses and gains, storage losses and gains, and sales volume losses and gains; Data acquisition: continuously acquire actual data from the purchase, storage and sales stages; Loss and gain analysis: analyze the actual data of the purchasing link with the theoretical data of the purchasing link to determine whether there is a purchase loss or gain; analyze the actual data of the storage link with the theoretical data of the storage link to determine whether there is a storage loss or gain; analyze the actual data of the sales link with the theoretical data of the sales link to determine whether there is a sales volume loss or gain.
7. The method for analyzing loss and gain for a gas station according to claim 6, characterized in that: The loss / gain analysis includes: Curve construction: According to the corresponding relationship between the actual data of the purchase link, the actual data of the storage link, the actual data of the sales link and time, the actual change curve of the purchase link, the actual change curve of the storage link, and the actual change curve of the sales link are constructed respectively; according to the corresponding relationship between the theoretical data of the purchase link, the theoretical data of the storage link, the theoretical data of the sales link and time, the theoretical change curve of the purchase link, the theoretical change curve of the storage link, and the theoretical change curve of the sales link are constructed respectively; Threshold comparison, compare the actual change curve of the purchasing link within the same time period with the theoretical change curve of the purchasing link to obtain the purchase difference at different times, compare the purchase difference with the purchase threshold, if the purchase difference is within the purchase threshold range, there is no purchase loss or surplus, otherwise, there is a purchase loss or surplus; compare the actual change curve of the storage link within the same time period with the theoretical change curve of the storage link to obtain the storage difference at different times, compare the storage difference with the storage threshold, if the storage difference is within the storage threshold range, there is no storage loss or surplus, otherwise, there is a storage loss or surplus; compare the actual change curve of the sales link within the same time period with the theoretical change curve of the sales link to obtain the sales difference at different times, compare the sales difference with the sales threshold, if the sales difference is within the sales threshold range, there is no sales loss or surplus, otherwise, there is a sales loss or surplus.
8. The method for analyzing loss and gain for a gas station according to claim 6, characterized in that: The actual data of the purchase link includes the actual inventory of each oil product in each gas station; the theoretical data of the purchase link = inventory before purchase + purchase volume of the oil depot; The actual data of the storage link includes the gas station sales volume of each oil product in each gas station and the inventory at the end of the storage period; Theoretical data of storage link = opening inventory + oil depot intake during storage period; The actual sales data include the gas station sales volume and ending inventory of each oil product in each gas station; Theoretical data of sales link = beginning inventory + oil depot intake during sales period.
9. The method for analyzing loss and gain for a gas station according to claim 7, characterized in that: The actual change curves in the purchasing link include the daily average purchase actual change curve, the weekly average purchase actual change curve and the monthly average purchase actual change curve; the actual change curves in the storage link include the daily average storage actual change curve, the weekly average storage actual change curve and the monthly average storage actual change curve; the actual change curves in the sales link include the daily average sales actual change curve, the weekly average sales actual change curve and the monthly average sales actual change curve.
10. The method for analyzing loss and gain for a gas station according to claim 8, characterized in that: Purchase loss / gain = pre-purchase inventory + purchase quantity of oil depot - actual inventory; Storage loss / gain = beginning inventory + oil depot purchase during storage period - oil station sales - ending inventory during storage period; Sales volume loss / gain = beginning inventory + oil depot purchases during sales period - gas station sales - ending inventory.
Citation Information
Patent Citations
Liquid level instrument abnormal data monitoring method and device, computer equipment and storage medium
CN112284486A
Oil loss and overflow analysis method and system for gas station, electronic equipment and storage medium
CN116305910A
Method for finely analyzing retail loss of gas station
CN118521031A
Loss overflow management method and system based on standard volume and dynamic mass accounting
CN118898443A
