CN115034523B - Enterprise ERP (enterprise resource planning) comprehensive management system and method based on big data - Google Patents
Enterprise ERP (enterprise resource planning) comprehensive management system and method based on big data Download PDFInfo
- Publication number
- CN115034523B CN115034523B CN202210956971.8A CN202210956971A CN115034523B CN 115034523 B CN115034523 B CN 115034523B CN 202210956971 A CN202210956971 A CN 202210956971A CN 115034523 B CN115034523 B CN 115034523B
- Authority
- CN
- China
- Prior art keywords
- warehouse
- data
- commodity
- transfer station
- year
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000007726 management method Methods 0.000 title claims abstract description 75
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000013439 planning Methods 0.000 title description 3
- 238000012546 transfer Methods 0.000 claims abstract description 151
- 238000012384 transportation and delivery Methods 0.000 claims abstract description 15
- 238000007405 data analysis Methods 0.000 claims abstract description 11
- 238000013523 data management Methods 0.000 claims abstract description 11
- 230000002159 abnormal effect Effects 0.000 claims description 28
- 238000009499 grossing Methods 0.000 claims description 27
- 238000012216 screening Methods 0.000 claims description 25
- 238000004364 calculation method Methods 0.000 claims description 14
- 230000008569 process Effects 0.000 claims description 12
- 230000005540 biological transmission Effects 0.000 claims description 11
- 238000004458 analytical method Methods 0.000 claims description 6
- 238000003860 storage Methods 0.000 claims description 4
- 230000001360 synchronised effect Effects 0.000 abstract description 5
- 230000008859 change Effects 0.000 abstract description 2
- 230000035945 sensitivity Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- FFBHFFJDDLITSX-UHFFFAOYSA-N benzyl N-[2-hydroxy-4-(3-oxomorpholin-4-yl)phenyl]carbamate Chemical compound OC1=C(NC(=O)OCC2=CC=CC=C2)C=CC(=C1)N1CCOCC1=O FFBHFFJDDLITSX-UHFFFAOYSA-N 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000002349 favourable effect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 239000002994 raw material Substances 0.000 description 1
- 230000001932 seasonal effect Effects 0.000 description 1
- 238000013068 supply chain management Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/04—Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"
- G06Q10/047—Optimisation of routes or paths, e.g. travelling salesman problem
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06315—Needs-based resource requirements planning or analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/083—Shipping
- G06Q10/0835—Relationships between shipper or supplier and carriers
- G06Q10/08355—Routing methods
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- Development Economics (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an enterprise ERP integrated management system and method based on big data, comprising the following steps: the system comprises a data acquisition module, a data management center, a data analysis module, a warehouse management module and a transportation data management module, wherein historical data of commodity orders, warehouse inventory corresponding to a merchant, warehouse position data and user receiving position data are acquired through the data acquisition module, all the acquired data are stored and managed through the data management center, the order quantity change data of commodities are analyzed through the data analysis module, the time for uploading the data to a commodity transportation transfer station is predicted, when more than one warehouse which meets the commodity supply requirement and is closest to the user receiving position is screened out through the warehouse management module, the best warehouse is selected for shipment, the best transportation transfer station is selected for uploading the data when the data are uploaded abnormally through the transportation data management module, the current and future warehouse delivery and supply capacity is synchronously improved, and the synchronous management of ERP information is guaranteed.
Description
Technical Field
The invention relates to the technical field of ERP management, in particular to an enterprise ERP comprehensive management system and method based on big data.
Background
ERP refers to enterprise resource planning, and represents an enterprise information management system mainly oriented to the manufacturing industry for integrated management of material resources, capital resources and information resources, electronic commerce is a mainstream business mode for optimizing enterprise operation, the ERP system in the era of electronic commerce fully utilizes networks and information integration technologies, comprehensively integrates and optimizes functions such as supply chain management, customer relationship management, enterprise office automation and the like, and reasonably performs ERP management to meet the requirements of resource optimization and inter-enterprise collaborative development in the era of electronic commerce;
however, the conventional management method has the following problems: first, in terms of management of the enterprise supply chain, that is, management of market, demand, order, raw material procurement, production, inventory, supply, distribution and shipment, a merchant often faces a problem of how to select a suitable warehouse for shipment after receiving an order, and in terms of warehouse selection, a supply demand and a shipment cost are often considered in priority, as in the prior art, for example, chinese patent CN114240302a: the publication time is as follows: 2022.03.25 discloses forwarding an order to a warehouse meeting supply requirements and selecting a warehouse with the lowest cost for placing the order, only considering the supply requirements and delivery cost of the current warehouse, but not considering whether the warehouse can meet the order requirements of users in the future to make long-term delivery plans, and cannot improve the delivery and supply capacities of the current and future warehouses at the same time; secondly, in the process of transporting the goods, data needs to be uploaded to an ERP integrated management system to ensure the information management synchronization, an abnormal data uploading phenomenon exists, the existing management mode cannot find and process the abnormal uploading problem in time, and the synchronous management of ERP information is not facilitated.
Therefore, a system and a method for enterprise ERP integrated management based on big data are needed to solve the above problems.
Disclosure of Invention
The invention aims to provide an enterprise ERP integrated management system and method based on big data, so as to solve the problems in the background technology.
In order to solve the technical problems, the invention provides the following technical scheme: an enterprise ERP integrated management system based on big data, the system comprises: the system comprises a data acquisition module, a data management center, a data analysis module, a warehouse management module and a transportation data management module;
the data acquisition module is used for acquiring commodity order historical data, warehouse inventory data and warehouse position data corresponding to merchants and user receiving position data;
storing and managing all the collected data through the data management center;
the data analysis module is used for analyzing the order quantity of the commodity in different time periods every year in the past, predicting the order quantity of the commodity in different time periods this year according to the order quantity of the commodity in different time periods every year in the past, and predicting the time of the commodity transportation transfer station needing to upload data;
comparing the commodity order quantity with the commodity quantity stored in the warehouse through the warehouse management module, screening out the warehouse of which the stored commodity quantity is greater than or equal to the commodity order quantity, and in the screened warehouse: comparing the linear distances from the warehouse positions to the goods receiving positions, screening out the warehouse corresponding to the shortest linear distance, and selecting the warehouse corresponding to the shortest linear distance for goods delivery if only one warehouse is screened out; if more than one screened warehouse is available, selecting the best warehouse from the screened warehouses for shipment;
and when the commodity transportation transfer station uploads data at the predicted time, the transportation data management module selects the best transportation transfer station to upload data from the remaining transportation transfer stations which store the data to be uploaded by the corresponding transportation transfer stations.
Further, the data acquisition module comprises an order data acquisition unit, a warehouse data acquisition unit and a user information acquisition unit, wherein the order data acquisition unit is used for averagely dividing one year into n sections and acquiring historical data of commodity orders: the order quantity of the same commodity in different time periods; the warehouse data acquisition unit is used for acquiring different warehouse data corresponding to merchants: the number of goods stored in the warehouse and the position data of the warehouse are stored; the user information acquisition unit is used for acquiring user order information received by a merchant, confirming a receiving position according to logistics information remarked on an order, and transmitting all acquired data to the data management center.
Further, the data analysis module comprises an order quantity prediction unit and a data updating prediction unit, wherein the order quantity prediction unit is used for analyzing the order quantity of the commodity in different time periods every year in the past according to the historical data of the commodity order and predicting the order quantity of the commodity in different time periods in the present year; the data updating prediction unit is used for predicting the time for the commodity transportation transfer station to transmit data to the ERP integrated management system.
Further, the warehouse management module comprises a shipment analysis unit and a warehouse ERP screening unit, wherein the shipment analysis unit is used for acquiring the current order quantity of the commodities and the quantity of the commodities stored in the warehouse, and comparing the current order quantity of the commodities with the quantity of the commodities stored in the warehouse: if the quantity of the stored commodities is larger than or equal to the commodity order quantity, judging that the corresponding warehouse meets the commodity supply requirement; if the number of the stored commodities is less than the commodity order quantity, judging that the corresponding warehouse does not meet the commodity supply requirement, screening the warehouse of which the number of the stored commodities is more than or equal to the commodity order quantity, comparing the linear distance from the position of the screened warehouse to the receiving position of the user, and screening the warehouse corresponding to the shortest linear distance; the warehouse ERP screening unit is used for counting the number of screened warehouses: if only one screened warehouse is available, selecting the warehouse corresponding to the shortest straight-line distance for shipment; when more than one warehouse which meets the goods supply requirement and is closest to the receiving position of the user is screened out: and after a random warehouse is selected to deliver the commodities, the number of warehouses meeting the supply requirements of the commodities in different remaining time periods in the current year is counted, the adaptability of the commodity delivered by the random warehouse is analyzed and selected, and the warehouse with the highest adaptability is selected as the best warehouse for delivery.
Further, the transportation data management module comprises an update abnormity early warning unit and a data transmission management unit, wherein the update abnormity early warning unit is used for sending a data update abnormity warning signal to the data transmission management unit when the transportation transfer station does not upload data to the ERP integrated management system at the predicted time; and the data transmission management unit is used for selecting the optimal transportation transfer station from the transportation transfer stations which store the abnormal transportation transfer stations and need to upload data, and uploading the data to the ERP comprehensive management system through the optimal transportation transfer station.
An enterprise ERP integrated management method based on big data comprises the following steps:
s01: equally dividing the annual time into n sections, and collecting the order number of the same commodity in different time periods, warehouse data corresponding to merchants and receiving position data when a user purchases the corresponding commodity;
s02: predicting the order quantity of commodities in different time periods in the year;
s03: analyzing the quantity of orders, the quantity of commodities stored in the warehouse and the distance data from the warehouse position to the receiving position, screening out the warehouse which meets the commodity supply requirement and is closest to the receiving position of the user, and when screening out more than one warehouse which meets the commodity supply requirement and is closest to the receiving position of the user: selecting the best warehouse from the screened warehouses for shipment;
s04: analyzing the commodity transportation route, and predicting the time of the commodity transportation transfer station needing to upload data;
s05: and selecting the best transportation transfer station which stores the data to be uploaded by the abnormal transportation transfer station to upload the data when the data is not uploaded at the forecast time at the commodity transportation transfer station.
Further, in steps S01-S02: the annual time is divided into n sections on average: the order quantity collection of the same commodity in the same time period of the past m years is collected to be A = { A = { A }1，A2，…，AmSet a smoothing initial value to
：
Wherein A isiRepresenting the order quantity of the corresponding commodity in the corresponding time period of the ith year, and setting a smoothing parameter as
，
Predicting the order quantity B of the corresponding commodity in the corresponding time period of the year according to the following formulaj：
Wherein,
expressing the first exponential smooth predicted value of the order quantity of the corresponding commodity in the corresponding time period of the mth year according to a formula
Obtaining a first exponential smoothing predicted value of the order quantity in the time period corresponding to the first year, and sequentially obtaining the first exponential smoothing predicted values of the order quantity in the time periods corresponding to the second year to the m-1 th year according to the same calculation mode, wherein the first exponential smoothing predicted value of the order quantity in the time period corresponding to the m-1 th year is
According to the formula
Obtaining a first exponential smoothing predicted value of the order quantity in the corresponding time period of the mth year
Predicting the order quantity set of the commodity in different time periods of the year by the same calculation mode to be B = { B = { (B)1，B2，…，Bj，…，BnAnd predicting the order quantity of the commodity in the year by acquiring and analyzing the historical order quantity of the same commodity, aiming at synchronously analyzing the order quantity of the commodity and the commodity quantity stored in the warehouse to select the best warehouse to deliver the current commodity, and predicting the future order quantity by using an index smoothing method, so that all historical data are compatible, the prediction error is reduced, and the self-defining of smooth parameters is favorable for improving the prediction sensitivity.
Further, in step S03: acquiring that the user order quantity currently received by a merchant is M, and acquiring that the number set of corresponding commodities stored in a warehouse corresponding to the merchant is N = { N1, N2, …, nk }, wherein k represents the number of the warehouses, and comparing Ni with M: if Ni<M, the corresponding warehouse does not meet the goods supply requirement; if Ni is larger than or equal to M, the corresponding warehouse meets the commodity supply requirement, wherein Ni represents the quantity of the corresponding commodities stored in one warehouse at random, and the warehouse meeting the commodity supply requirement is screened out: sending the user order to the screened warehouse, acquiring the receiving position of the user according to logistics remark information in the user order, and counting the receiving position of the screened warehouseD = { d1, d2, …, dp }, where p represents the number of warehouses meeting the commodity supply requirement, and the linear distances are compared: obtaining the shortest comprehensive distance dmin, and if only one warehouse meeting the shortest linear distance is available, selecting the warehouse corresponding to dmin for shipment; if more than one warehouse meeting the shortest straight-line distance is available, selecting the best warehouse from the warehouses meeting the shortest straight-line distance for shipment: the total number of the obtained warehouses meeting the shortest straight line distance is q, and the number of the commodities collected to be currently stored in the warehouses is N’={N1’，N2’，…，Nq’Collecting the quantity of orders sold in the corresponding commodities in the current year as B’={ B1’， B2’，…， Bv’And (4) selecting a random warehouse for shipment when the current time belongs to the (v + 1) th time period of the year: the number of the commodities which are obtained from the residual storage of the warehouse is N’={N1’，N2’，…，Ni’-M，…，Nq’Predicting to obtain an order quantity set of the commodity from the v +2 th time period to the n-th time period as B’’={Bv+2，Bv+3，…，Bn-means for, among other things,
comparing the order amount of the commodities in the v +2 th to the n-th time periods with the quantity of the commodities stored in the warehouse: the number of the warehouses which meet the supply demand of the commodities in each remaining time period in the year is counted as E = { E = }v+2，Ev+3，…，EnCalculating and selecting a random warehouse for shipment according to the following formula:
wherein E isjRepresenting the quantity of warehouses meeting the supply requirement of the commodity in a random time period left in the year, obtaining a fitness set of selecting q warehouses for shipment in the same calculation mode, wherein the fitness set is W = { W1, W2, …, wi, … and Wq }, comparing the fitness, and selecting the warehouse with the highest fitnessIn the prior art, when a warehouse is selected for shipment, whether the warehouse meets the supply demand of goods and the cost of delivery are generally considered preferentially, after the warehouse is currently selected for shipment, whether the warehouse can meet the supply demand of goods is considered in the future, the future order demand of a user cannot be guaranteed to the greatest extent on the premise of saving cost, when more than one warehouse which meets the supply demand of goods and is closest to the receiving position of the user is screened out, the best warehouse is further selected for delivery, whether the remaining warehouse of the warehouse meets the supply demand of goods in the future after the warehouse is currently selected for shipment is considered in the selection process, and the purpose of calculating and selecting the adaptability of delivery of different warehouses in a mode of meeting the sum of the number of warehouses required for goods in the future time period after the current goods are randomly selected for shipment is achieved by calculation: the warehouse delivery system has the advantages that the current warehouse and the future warehouse have certain capacity for delivery before replenishment, the delivery and supply capacity of the current warehouse and the future warehouse can be synchronously improved, and the probability that the warehouse cannot meet the supply demand in the future is reduced.
Further, in step S04: analyzing the commodity transportation route: the number of the transfer stations needed to pass through in the current transportation process of the commodity is u, and the distance set between the adjacent transfer stations according to the transportation sequence is D = { D =1，D2，…，Du-1And acquiring a time interval set of the data uploaded to the ERP integrated management system by the adjacent transfer stations in the previous random commodity transportation process as t = { t = }1，t2，…，tu-1Using least square method to data points { (D)1，t1），（D2，t2），…，（Du-1，tu-1) Performing straight line fitting, and setting a fitting function as follows: y = ax + b, wherein a and b represent fitting coefficients, the transfer station which acquires the current data to be uploaded is the ith transfer station, and the distance between the (i-1) th transfer station and the ith transfer station is Di-1I is not less than 2, andi-1substituting the fitting function, and predicting the interval duration t after the data is uploaded by the ith transfer station at the (i-1) th transfer stationi-1When data is required to be uploaded, ti-1=a* Di-1And + b, predicting the normal time of the data uploaded by the transfer station by using a least square method, so that the transfer station with abnormal data uploading can be found in time and an alarm signal can be sent.
Further, in step S05: when the interval duration exceeds t after the ith transfer station uploads the data at the (i-1) th transfer stationi-1When data is not uploaded later, sending a data updating abnormal alarm signal to acquire the number f of transfer stations storing the data to be uploaded of the ith transfer station, wherein f is the number of the transfer stations<And u, acquiring the data uploading speed of f transfer stations, selecting the transfer station with the highest speed as the optimal transportation transfer station, uploading the data to be uploaded by the ith transfer station stored in the optimal transportation transfer station to the ERP integrated management system, and selecting the transfer station with the highest data transmission speed to upload the data to be uploaded by the abnormal transfer station to the ERP integrated management system after finding the abnormal transfer station due to data sharing among the transfer stations, so that the abnormal problem of updating the transportation data is solved quickly, and the synchronous management of the ERP information is ensured.
Compared with the prior art, the invention has the following beneficial effects:
the invention predicts the order quantity of the commodity in the present year by collecting and analyzing the historical order quantity of the same commodity, considers the seasonal change problem of the order quantity of the commodity, the predicted order quantity is the order quantity in different time periods in the year, improves the accuracy of the prediction result, in addition, predicts the future order quantity by using an index smoothing method, is compatible with all historical data, reduces the prediction error and improves the prediction sensitivity, and when more than one warehouse which meets the commodity supply requirement and is nearest to the receiving position of a user is screened out, the best warehouse is further selected for delivery: the predicted order quantity is compared with the inventory, the adaptability of the shipment of different warehouses is calculated in a mode that the sum of the warehouse quantity of the commodity supply requirements can be met in a future time period after the current commodity is shipped from one selected warehouse randomly, and the warehouse with the highest adaptability is selected for shipment, so that the shipment and supply capabilities of the current and future warehouses are synchronously improved, the probability that the warehouse cannot meet the supply requirements in the future is reduced, and the future order requirements of the user are guaranteed to the maximum extent on the premise of saving cost;
the method has the advantages that the normal time of data uploading of the commodity transportation transfer station is predicted, the transfer station with abnormal data uploading is found in time and sends an alarm signal, and the transfer station which stores the data to be uploaded by the abnormal transfer station and has the highest data transmission speed is selected to upload the data to the ERP comprehensive management system after the abnormality is found, so that the abnormal problem is rapidly processed, and the synchronous management of the ERP information is guaranteed.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:
FIG. 1 is a block diagram of an enterprise ERP integrated management system based on big data according to the present invention;
FIG. 2 is a flowchart of an enterprise ERP integrated management method based on big data according to the present invention.
Detailed Description
The preferred embodiments of the present invention will be described in conjunction with the accompanying drawings, and it will be understood that they are described herein for the purpose of illustration and explanation and not limitation.
Referring to fig. 1-2, the present invention provides a technical solution: an enterprise ERP integrated management system based on big data comprises: the system comprises a data acquisition module, a data management center, a data analysis module, a warehouse management module and a transportation data management module;
the method comprises the steps that commodity order historical data, warehouse inventory data and warehouse position data corresponding to merchants and user receiving position data are collected through a data collection module;
storing and managing all the acquired data through a data management center;
the order quantity of the commodities in different time periods every year in the past is analyzed through a data analysis module, the order quantity of the commodities in different time periods this year in the past is predicted according to the order quantity of the commodities in different time periods every year, and the time of uploading data of the commodity transportation transfer station is predicted;
comparing the commodity order quantity with the commodity quantity stored in the warehouse through a warehouse management module, screening out the warehouse of which the stored commodity quantity is more than or equal to the commodity order quantity, and in the screened warehouse: comparing the linear distances from the warehouse positions to the receiving positions, screening out the warehouse corresponding to the shortest linear distance, and selecting the warehouse corresponding to the shortest linear distance for shipment if only one warehouse is screened out; if more than one screened warehouse is available, selecting the best warehouse from the screened warehouses for shipment;
and when the data are not uploaded at the forecast time by the commodity transportation transfer station through the transportation data management module, selecting the best transportation transfer station to upload the data from the transportation transfer stations which are stored with the data to be uploaded by the corresponding transportation transfer stations.
The data acquisition module comprises an order data acquisition unit, a warehouse data acquisition unit and a user information acquisition unit, wherein the order data acquisition unit is used for averagely dividing one year into n sections and acquiring commodity order historical data: the order quantity of the same commodity in different time periods; the warehouse data acquisition unit is used for acquiring different warehouse data corresponding to merchants: the number of commodities stored in the warehouse and the position data of the warehouse are stored; the user information acquisition unit is used for acquiring user order information received by a merchant, confirming a receiving position according to logistics information remarked on an order, and transmitting all acquired data to the data management center.
The data analysis module comprises an order quantity prediction unit and a data updating prediction unit, wherein the order quantity prediction unit is used for analyzing the order quantity of the commodity in different time periods every year in the past according to the historical data of the commodity order and predicting the order quantity of the commodity in different time periods in the present year; the data updating prediction unit is used for predicting the time for the commodity transportation transfer station to transmit data to the ERP integrated management system.
The warehouse management module comprises a shipment analysis unit and a warehouse ERP screening unit, wherein the shipment analysis unit is used for acquiring the current order quantity of the commodities and the quantity of the commodities stored in the warehouse and comparing the current order quantity of the commodities with the quantity of the commodities stored in the warehouse: if the quantity of the stored commodities is more than or equal to the commodity order quantity, judging that the corresponding warehouse meets the commodity supply requirement; if the number of the stored commodities is less than the commodity order quantity, judging that the corresponding warehouse does not meet the commodity supply requirement, screening the warehouse of which the number of the stored commodities is more than or equal to the commodity order quantity, comparing the linear distance from the position of the screened warehouse to the receiving position of the user, and screening the warehouse corresponding to the shortest linear distance; the warehouse ERP screening unit is used for counting the screened warehouse quantity: if only one screened warehouse is available, selecting the warehouse corresponding to the shortest straight-line distance for shipment; if more than one warehouse which meets the goods supply requirement and is closest to the receiving position of the user is screened out: after a random warehouse is selected to deliver the commodities, the number of warehouses meeting the supply requirements of the commodities in different remaining time periods in the year is counted, the adaptability of the random warehouse to deliver the commodities is analyzed and selected, and the warehouse with the highest adaptability is selected as the best warehouse to deliver the commodities.
The transportation data management module comprises an abnormal updating early warning unit and a data transmission management unit, wherein the abnormal updating early warning unit is used for sending a data updating abnormal alarm signal to the data transmission management unit when the transportation transfer station does not upload data to the ERP comprehensive management system at the predicted time; and the data transmission management unit is used for selecting the optimal transportation transfer station from the transportation transfer stations which store the abnormal transportation transfer stations and need to upload data, and uploading the data to the ERP comprehensive management system through the optimal transportation transfer station.
An enterprise ERP integrated management method based on big data comprises the following steps:
s01: equally dividing the annual time into n sections, and collecting the order number of the same commodity in different time periods, warehouse data corresponding to merchants and receiving position data when a user purchases the corresponding commodity;
s02: predicting the order quantity of commodities in different time periods in the year;
s03: analyzing commodity order quantity, commodity quantity stored in the warehouse and distance data from the warehouse position to the receiving position, screening out the warehouse which meets commodity supply requirements and is closest to the receiving position of the user, and when screening out more than one warehouse which meets the commodity supply requirements and is closest to the receiving position of the user: selecting the best warehouse from the screened warehouses for shipment;
s04: analyzing the commodity transportation route, and predicting the time of the commodity transportation transfer station needing to upload data;
s05: and selecting the best data uploaded by the transportation transfer station, which stores the data to be uploaded by the abnormal transportation transfer station, when the data are not uploaded at the predicted time at the commodity transportation transfer station.
In steps S01-S02: the annual time is divided into n sections on average: the order quantity collection of the same commodity in the same time period of the past m years is collected to be A = { A = { A }1，A2，…，Am}, setting the smoothing initial value to
：
Wherein A isiRepresenting the order quantity of the corresponding commodity in the corresponding time period of the ith year, and setting a smoothing parameter as
，
Predicting the order quantity B of the corresponding commodity in the corresponding time period of the year according to the following formulaj：
Wherein,
expressing the first exponential smooth predicted value of the order quantity of the corresponding commodity in the corresponding time period of the mth year according to a formula
Obtaining a first exponential smoothing predicted value of the order quantity in the time period corresponding to the first year, and sequentially obtaining the first exponential smoothing predicted value of the order quantity in the time period corresponding to the second to m-1 years according to the same calculation mode, wherein the first exponential smoothing predicted value of the order quantity in the time period corresponding to the m-1 year is
According to the formula
Obtaining a first exponential smoothing predicted value of the order quantity in the corresponding time period of the mth year
Predicting the order quantity set of the commodity in different time periods of the year by the same calculation mode to be B = { B = { (B)1，B2，…，Bj，…，BnAnd predicting the future order quantity by using an index smoothing method, so that all historical data are compatible, the prediction sensitivity is improved, and the prediction error is reduced.
In step S03: acquiring that the user order quantity currently received by a merchant is M, and acquiring that the number set of corresponding commodities stored in a warehouse corresponding to the merchant is N = { N1, N2, …, nk }, wherein k represents the number of the warehouses, and comparing Ni with M: if Ni<M, the corresponding warehouse does not meet the goods supply requirement; if Ni is larger than or equal to M, the corresponding warehouse meets the commodity supply requirement, wherein Ni represents the quantity of the corresponding commodities stored in one warehouse at random, and the warehouse meeting the commodity supply requirement is screened out: sending the user order to the screened warehouse, acquiring a receiving position of the user according to logistics remark information in the user order, and counting the linear distance set from the screened warehouse position to the receiving position as d = { d1, d2, …, dp }, wherein p represents the number of warehouses meeting goods supply requirements, and comparing the linear distances: obtaining the shortest straight line distance dmin, and if only one warehouse meeting the shortest straight line distance is available, selecting the warehouse corresponding to dmin for shipment; if the warehouse meeting the shortest straight-line distance does notAnd one, selecting the best warehouse from the warehouses meeting the shortest straight-line distance for shipment: the total number of the obtained warehouses meeting the shortest straight line distance is q, and the number of the commodities collected to be currently stored in the warehouses is N’={N1’，N2’，…，Nq’Collecting the quantity of orders sold in the corresponding commodities in the current year as B’={ B1’， B2’，…， Bv’And (4) selecting a random warehouse for shipment when the current time belongs to the (v + 1) th time period of the year: the number of the commodities which are obtained from the residual storage of the warehouse is N’={N1’，N2’，…，Ni’-M，…，Nq’And predicting that the order quantity set of the commodity in the time periods from v +2 th to nth is B’’={Bv+2，Bv+3，…，BnAnd (c) the step of (c) in which,
comparing the order amount of the commodities in the v +2 th to the n-th time periods with the quantity of the commodities stored in the warehouse: the number of the warehouses which meet the supply demand of the commodities in each remaining time period in the year is counted as E = { E = }v+2，Ev+3，…，EnCalculating and selecting a random warehouse for shipment fitness Wi according to the following formula:
wherein E isjThe quantity of the warehouses meeting the supply requirement of the commodity in a random time period left in the year is represented, the fitness set of selecting q warehouses for shipment is obtained in the same calculation mode, the fitness set is W = { W1, W2, …, wi, … and Wq }, the fitness is compared, the warehouse with the highest fitness is selected for shipment, and the delivery capacity of the current warehouse and the future warehouse is synchronously improved.
In step S04: analyzing the commodity transportation route: the number of transfer stations needed to pass through in the current transportation process of the commodity is u, and the distance between the adjacent transfer stations is D = &accordingto the collection of the distances between the adjacent transfer stations in the transportation sequenceD1，D2，…，Du-1And acquiring a set of interval time from data uploaded by adjacent transfer stations to an ERP comprehensive management system in the previous random commodity transportation process as t = { t = }1，t2，…，tu-1Using least square method to data points { (D)1，t1），（D2，t2），…，（Du-1，tu-1) Performing straight line fitting, and setting a fitting function as follows: y = ax + b, wherein a and b represent fitting coefficients, the transfer station which acquires the current data to be uploaded is the ith transfer station, and the distance between the (i-1) th transfer station and the ith transfer station is Di-1I is not less than 2, andi-1substituting the fitting function, and predicting the interval duration t after the data is uploaded by the ith transfer station at the (i-1) th transfer stationi-1When data is required to be uploaded, ti-1=a* Di-1And + b, the transfer station with abnormal data uploading can be found in time conveniently and an alarm signal can be sent.
In step S05: when the interval duration exceeds t after the ith transfer station uploads the data at the (i-1) th transfer stationi-1When data is not uploaded later, sending a data updating abnormal alarm signal, and acquiring that the number of the transfer stations storing the data to be uploaded of the ith transfer station is f, f<And u, acquiring the data uploading speed of the f transfer stations, selecting the transfer station with the highest speed as the optimal transportation transfer station, and uploading the data to be uploaded by the ith transfer station stored in the optimal transportation transfer station to an ERP comprehensive management system, so that the abnormal problem can be quickly processed, and the synchronous management of the ERP information is ensured.
The first embodiment is as follows: divide the annual time equally into n =4 segments: the order quantity collection of the same commodity in the first time period of previous m =5 years is collected as A = { A = { (A)1，A2，A3，A4，A5} = {200, 100, 300, 260, 180}, and the smoothing initial value is set to be
：
Setting a smoothing parameter to
According to the formula
Predicting the order quantity B of the corresponding commodity in the first time period of the year1=202, the order quantity set of the commodity in different time periods of this year is predicted to be B = { B } by the same calculation method1，B2，B3，B4The user order quantity currently received by the merchant is M =110, the collected corresponding commodity quantity set stored in the warehouse corresponding to the merchant is N = { N1, N2, N3, N4, N5} = {50, 600, 180, 350, 200}, and Ni and M are compared: screening p =4 warehouses meeting goods supply requirements, sending a user order to the screened warehouses, acquiring a receiving position of the user according to logistics remark information in the user order, and counting the linear distance set from the screened warehouse position to the receiving position as d = { d1, d2, d3, d4} = {10, 50, 30, 10}, wherein the unit is: km, comparison of linear distances: the shortest comprehensive distance dmin =10 is obtained, more than one warehouse meeting the shortest straight-line distance is obtained, and the best warehouse is selected from the warehouses meeting the shortest straight-line distance for shipment: the total number of the obtained warehouses meeting the shortest straight line distance is q =2, and the number set of the commodities collected and currently stored in the warehouse is N’={N1’，N2’} = {600, 200}, and the collection of the sold order quantity of the corresponding commodity in this year is collected as B’={ B1’， B2’} = {200, 280}, the current time belongs to the v +1=3 time slots of this year, when the 2 nd warehouse is selected for shipment: obtaining the quantity set of the commodities stored in the warehouse as N’={N1’-M，N2’} = {490, 200}, and the collection of the order quantity of the commodity in the v +2=4 time slots is predicted to be B’’={B4-a counter balance of =500, the collection of the warehouse quantity counted to meet the supply demand of each remaining time period of the commodity this year is E = { E = { (E)4=0, according to the formula
Calculating the fitness W1=0 of the 2 nd warehouse for shipment; when the 5 th warehouse is selected for shipment: the number of the commodities which are obtained from the residual storage of the warehouse is N’={N1’，N2’-M } = {600, 90}, and the number of warehouses meeting the supply demand of the commodity in each remaining time slot of this year is counted as E = { E }4=1, according to the formula
Calculating and selecting 5 th warehouse for shipment fitness W2=1>W1, selecting a 5 th warehouse for shipment;
the second embodiment: the number of the transfer stations required to pass through in the current transportation process of the commodity is u =3, and the distance set between the adjacent transfer stations according to the transportation sequence is D = { D = { (D)1，D2And the time interval set of uploading data of adjacent transfer stations to the ERP integrated management system is acquired as t = {9,8} in the previous random one-time commodity transportation process1，t2} = {0.6,0.5}, with the unit: day, data points { (D) using least squares1，t1），（D2，t2) Performing straight line fitting, and setting a fitting function as follows: y = ax + b, according to the formula
And
calculating fitting coefficients a and b respectively: a =0.1, b = -0.3, the transfer station which acquires the current data needing to be uploaded is the i =2 transfer stations, and the distance between the 1 st transfer station and the 2 nd transfer station is D1=9, will D1Substituting the fitting function, and predicting the interval duration t after the 2 nd transfer station uploads the data at the 1 st transfer stationi-1When data is required to be uploaded, ti-1=a* Di-1+ b =0.6, and the interval duration exceeds t after the 2 nd transfer station uploads the data at the 1 st transfer stationi-1If the data is not uploaded after the time of =0.6, sending a data updating abnormal alarm signal to acquire the storageThe number of transfer stations which have the 2 nd transfer station and need to upload data is 1: and taking the 3 rd transfer station as the optimal transportation transfer station for the 3 rd transfer station, and uploading data to be uploaded by the 2 nd transfer station stored in the optimal transportation transfer station to the ERP integrated management system.
Finally, it should be noted that: although the present invention has been described in detail with reference to the foregoing embodiments, it will be apparent to those skilled in the art that changes may be made in the embodiments and/or equivalents thereof without departing from the spirit and scope of the invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (6)
1. An enterprise ERP integrated management system based on big data is characterized in that: the system comprises: the system comprises a data acquisition module, a data management center, a data analysis module, a warehouse management module and a transportation data management module;
the data acquisition module is used for acquiring commodity order historical data, warehouse inventory data and warehouse position data corresponding to merchants and user receiving position data;
storing and managing all the collected data through the data management center;
the data analysis module is used for analyzing the order quantity of the commodity in different time periods every year in the past, predicting the order quantity of the commodity in different time periods this year according to the order quantity of the commodity in different time periods every year in the past, and predicting the time of the commodity transportation transfer station needing to upload data;
comparing the commodity order quantity with the commodity quantity stored in the warehouse through the warehouse management module, screening out the warehouse of which the stored commodity quantity is greater than or equal to the commodity order quantity, and in the screened warehouse: comparing the linear distances from the warehouse positions to the receiving positions, screening out the warehouse corresponding to the shortest linear distance, and selecting the warehouse corresponding to the shortest linear distance for shipment if only one warehouse is screened out; if more than one screened warehouse is available, selecting the best warehouse from the screened warehouses for shipment;
when the commodity transportation transfer station uploads data at the predicted time, the transportation data management module selects the best transportation transfer station to upload data from the remaining transportation transfer stations which store the data to be uploaded by the corresponding transportation transfer stations;
equally dividing the annual time into n segments: collecting the same commodity in the past m years orders within a time period the amount set is A = { A = { [ A ]1，A2，…，AmSet a smoothing initial value to
：
Wherein A isiRepresenting the order quantity of the corresponding commodity in the corresponding time period of the ith year, and setting a smoothing parameter as
，
Predicting the order quantity B of the corresponding commodity in the corresponding time period of the year according to the following formulaj：
Wherein,
expressing the first exponential smooth predicted value of the order quantity of the corresponding commodity in the corresponding time period of the mth year according to a formula
Obtaining the first-time index average of the order quantity in the corresponding time period of the first yearAnd (4) obtaining a smooth predicted value according to the same calculation mode, and sequentially obtaining a first exponential smooth predicted value of the order quantity in the time period corresponding to the second year to the m-1 th year, wherein the first exponential smooth predicted value of the order quantity in the time period corresponding to the m-1 th year is
According to the formula
Obtaining a first exponential smoothing predicted value of the order quantity in the corresponding time period of the mth year
Predicting the order quantity set of the commodity in different time periods of the year by the same calculation mode to be B = { B = { (B)1，B2，…，Bj，…，Bn}；
Acquiring that the user order quantity currently received by a merchant is M, and acquiring that the number set of corresponding commodities stored in a warehouse corresponding to the merchant is N = { N1, N2, …, nk }, wherein k represents the number of the warehouses, and comparing Ni with M: if Ni<M, showing that the corresponding warehouse does not meet the goods supply requirement; if Ni is larger than or equal to M, the corresponding warehouse meets the commodity supply requirement, wherein Ni represents the quantity of the corresponding commodities stored in one warehouse at random, and the warehouse meeting the commodity supply requirement is screened out: sending the user order to the screened warehouse, acquiring a receiving position of the user according to logistics remark information in the user order, and counting the linear distance set from the screened warehouse position to the receiving position as d = { d1, d2, …, dp }, wherein p represents the number of warehouses meeting goods supply requirements, and comparing the linear distances: if only one warehouse meeting the shortest straight line distance is available, selecting the warehouse corresponding to the dmin for shipment; if more than one warehouse meeting the shortest straight-line distance is available, selecting the best warehouse from the warehouses meeting the shortest straight-line distance for shipment: the total number of the obtained warehouses meeting the shortest straight line distance is q, and the number of the commodities collected to be currently stored in the warehouses is N’={N1’，N2’，…，Nq’Collecting the quantity of orders sold in the corresponding commodities in the current year as B’={ B1’， B2’，…， Bv’And (4) selecting a random warehouse for shipment when the current time belongs to the (v + 1) th time period of the year: obtaining the quantity set of the commodities stored in the warehouse as N’={N1’，N2’，…，Ni’-M，…，Nq’Predicting to obtain an order quantity set of the commodity from the v +2 th time period to the n-th time period as B’’={Bv+2，Bv+3，…，BnAnd (c) the step of (c) in which,
comparing the order amount of the commodities in the v +2 th to the n-th time periods with the quantity of the commodities stored in the warehouse: the number of the warehouses which meet the supply demand of the commodities in each remaining time period in the year is counted as E = { E = }v+2，Ev+3，…，EnCalculating and selecting a random warehouse for shipment fitness Wi according to the following formula:
wherein E isjRepresenting the number of warehouses meeting the supply requirement of a commodity in a random time period left in the year, obtaining a fitness set W = { W1, W2, …, wi, … and Wq } by selecting q warehouses for shipment in the same calculation mode, comparing the fitness, and selecting the warehouse with the highest fitness for shipment;
analyzing the commodity transportation route: the number of the transfer stations needed to pass through in the current transportation process of the commodity is u, and the distance set between the adjacent transfer stations according to the transportation sequence is D = { D =1，D2，…，Du-1And acquiring a set of interval time from data uploaded by adjacent transfer stations to an ERP comprehensive management system in the previous random commodity transportation process as t = { t = }1，t2，…，tu-1Using least square method to data points { (D)1，t1），（D2，t2），…，（Du-1，tu-1) Performing straight line fitting, and setting a fitting function as follows: y = ax + b, wherein a and b represent fitting coefficients, the transfer station which acquires the current data to be uploaded is the ith transfer station, and the distance between the ith-1 transfer station and the ith transfer station is Di-1I is not less than 2, andi-1substituting the fitting function, and predicting the interval duration t after the data is uploaded by the ith transfer station at the (i-1) th transfer stationi-1When data is required to be uploaded, ti-1=a* Di-1+b；
When the interval duration exceeds t after the ith transfer station uploads the data in the (i-1) th transfer stationi-1When data is not uploaded later, sending a data updating abnormal alarm signal, and acquiring that the number of the transfer stations storing the data to be uploaded of the ith transfer station is f, f<And u, acquiring the data uploading speed of the f transfer stations, selecting the transfer station with the highest speed as the optimal transportation transfer station, and uploading the data to be uploaded at the ith transfer station stored in the optimal transportation transfer station to the ERP integrated management system.
2. The enterprise ERP integrated management system based on big data as claimed in claim 1, wherein: the data acquisition module comprises an order data acquisition unit, a warehouse data acquisition unit and a user information acquisition unit, wherein the order data acquisition unit is used for averagely dividing one year into n sections and acquiring historical data of commodity orders: the order quantity of the same commodity in different time periods; the warehouse data acquisition unit is used for acquiring different warehouse data corresponding to merchants: the number of commodities stored in the warehouse and the position data of the warehouse are stored; the user information acquisition unit is used for acquiring user order information received by a merchant, confirming a receiving position according to logistics information remarked on an order, and transmitting all acquired data to the data management center.
3. The enterprise ERP integrated management system based on big data as claimed in claim 1, wherein: the data analysis module comprises an order quantity prediction unit and a data updating prediction unit, wherein the order quantity prediction unit is used for analyzing the order quantity of the commodity in different time periods every year in the past according to the historical data of the commodity order and predicting the order quantity of the commodity in different time periods in the present year; the data updating prediction unit is used for predicting the time for the commodity transportation transfer station to transmit data to the ERP integrated management system.
4. The enterprise ERP integrated management system based on big data as claimed in claim 1, wherein: the warehouse management module comprises a shipment analysis unit and a warehouse ERP screening unit, wherein the shipment analysis unit is used for acquiring the current order quantity of the commodities and the quantity of the commodities stored in the warehouse, and comparing the current order quantity of the commodities with the quantity of the commodities stored in the warehouse: if the quantity of the stored commodities is larger than or equal to the commodity order quantity, judging that the corresponding warehouse meets the commodity supply requirement; if the number of the stored commodities is less than the commodity order quantity, judging that the corresponding warehouse does not meet the commodity supply requirement, screening the warehouse of which the number of the stored commodities is more than or equal to the commodity order quantity, comparing the linear distance from the position of the screened warehouse to the receiving position of the user, and screening the warehouse corresponding to the shortest linear distance; the warehouse ERP screening unit is used for counting the number of screened warehouses: if only one screened warehouse is available, selecting the warehouse corresponding to the shortest straight-line distance for shipment; if more than one warehouse which meets the goods supply requirement and is closest to the receiving position of the user is screened out: and after a random warehouse is selected to deliver the commodities, the number of warehouses meeting the supply requirements of the commodities in different remaining time periods in the current year is counted, the adaptability of the commodity delivered by the random warehouse is analyzed and selected, and the warehouse with the highest adaptability is selected as the best warehouse for delivery.
5. The enterprise ERP integrated management system based on big data as claimed in claim 1, wherein: the transportation data management module comprises an abnormal updating early warning unit and a data transmission management unit, wherein the abnormal updating early warning unit is used for sending a data updating abnormal alarm signal to the data transmission management unit when the transportation transfer station does not upload data to the ERP integrated management system at the predicted time; and the data transmission management unit is used for selecting the optimal transportation transfer station from the transportation transfer stations which store the abnormal transportation transfer stations and need to upload data, and uploading the data to the ERP comprehensive management system through the optimal transportation transfer station.
6. An enterprise ERP integrated management method based on big data is characterized in that: the method comprises the following steps:
s01: equally dividing the annual time into n sections, and collecting the order number of the same commodity in different time periods, warehouse data corresponding to merchants and receiving position data when a user purchases the corresponding commodity;
s02: predicting the order quantity of commodities in different time periods in the year;
s03: analyzing commodity order quantity, commodity quantity stored in the warehouse and distance data from the warehouse position to the receiving position, screening out the warehouse which meets commodity supply requirements and is closest to the receiving position of the user, and when screening out more than one warehouse which meets the commodity supply requirements and is closest to the receiving position of the user: selecting the best warehouse from the screened warehouses for shipment;
s04: analyzing the commodity transportation route, and predicting the time of the commodity transportation transfer station needing to upload data;
s05: data are not uploaded at the forecast time at the commodity transportation transfer station, and the data uploaded by the optimal transportation transfer station storing the data needing to be uploaded by the abnormal transportation transfer station are selected;
in steps S01-S02: equally dividing the annual time into n segments: the order quantity collection of the same commodity in the same time period of the past m years is collected to be A = { A = { A }1，A2，…，AmSet a smoothing initial value to
：
Wherein A isiRepresenting the order quantity of the corresponding commodity in the corresponding time period of the ith year, and setting a smoothing parameter as
，
Predicting the order quantity B of the corresponding commodity in the corresponding time period of the year according to the following formulaj：
Wherein,
expressing the first exponential smoothing predicted value of the order quantity of the corresponding commodity in the corresponding time period of the mth year according to the formula
Obtaining a first exponential smoothing predicted value of the order quantity in the time period corresponding to the first year, and sequentially obtaining the first exponential smoothing predicted values of the order quantity in the time periods corresponding to the second year to the m-1 th year according to the same calculation mode, wherein the first exponential smoothing predicted value of the order quantity in the time period corresponding to the m-1 th year is
According to the formula
Obtaining a first exponential smoothing predicted value of the order quantity in the corresponding time period of the mth year
Predicting the order quantity set of the commodity in different time periods of the year by the same calculation mode to be B = { B = { (B)1，B2，…，Bj，…，Bn}；
In step S03: acquiring that the user order quantity currently received by a merchant is M, and acquiring that the number set of corresponding commodities stored in a warehouse corresponding to the merchant is N = { N1, N2, …, nk }, wherein k represents the number of the warehouses, and comparing Ni with M: if Ni<M, the corresponding warehouse does not meet the goods supply requirement; if Ni is larger than or equal to M, the corresponding warehouse meets the commodity supply requirement, wherein Ni represents the quantity of the corresponding commodities stored in one warehouse at random, and the warehouse meeting the commodity supply requirement is screened out: sending the user order to the screened warehouse, acquiring a receiving position of the user according to logistics remark information in the user order, and counting the linear distance set from the screened warehouse position to the receiving position as d = { d1, d2, …, dp }, wherein p represents the number of warehouses meeting goods supply requirements, and comparing the linear distances: if only one warehouse meeting the shortest straight line distance is available, selecting the warehouse corresponding to the dmin for shipment; if more than one warehouse meeting the shortest straight-line distance is available, selecting the best warehouse from the warehouses meeting the shortest straight-line distance for shipment: the total number of the obtained warehouses meeting the shortest straight line distance is q, and the number of the commodities collected to be currently stored in the warehouses is N’={N1’，N2’，…，Nq’Collecting the quantity of orders sold in the corresponding commodities in the current year as B’={ B1’， B2’，…， Bv’And (5) selecting a random warehouse for shipment when the current time belongs to the v +1 th time period in the year: the number of the commodities which are obtained from the residual storage of the warehouse is N’={N1’，N2’，…，Ni’-M，…，Nq’Predicting to obtain an order quantity set of the commodity from the v +2 th time period to the n-th time period as B’’={Bv+2，Bv+3，…，BnAnd (c) the step of (c) in which,
comparing the order amount of the commodities in the v +2 th to the n-th time periods with the quantity of the commodities stored in the warehouse: count up to satisfy the current commodityThe warehouse quantity set of supply demand in each time slot remained in the year is E = { E = { (E)v+2，Ev+3，…，EnCalculating and selecting a random warehouse for shipment according to the following formula:
wherein E isjRepresenting the number of warehouses meeting the supply requirement of a commodity in a random time period left in the year, obtaining a fitness set W = { W1, W2, …, wi, … and Wq } by selecting q warehouses for shipment in the same calculation mode, comparing the fitness, and selecting the warehouse with the highest fitness for shipment;
in step S04: analyzing the commodity transportation route: the number of the transfer stations needed to pass through in the current transportation process of the commodity is u, and the distance set between the adjacent transfer stations according to the transportation sequence is D = { D =1，D2，…，Du-1And acquiring a set of interval time from data uploaded by adjacent transfer stations to an ERP comprehensive management system in the previous random commodity transportation process as t = { t = }1，t2，…，tu-1Using least square method to data points { (D)1，t1），（D2，t2），…，（Du-1，tu-1) Performing straight line fitting, and setting a fitting function as follows: y = ax + b, wherein a and b represent fitting coefficients, the transfer station which acquires the current data to be uploaded is the ith transfer station, and the distance between the (i-1) th transfer station and the ith transfer station is Di-1I is not less than 2, andi-1substituting the fitting function, and predicting the interval duration t after the data is uploaded by the ith transfer station at the (i-1) th transfer stationi-1When data is required to be uploaded, ti-1=a* Di-1+b；
In step S05: when the interval duration exceeds t after the ith transfer station uploads the data in the (i-1) th transfer stationi-1When data is not uploaded later, sending a data updating abnormal alarm signal to acquire the number f of transfer stations storing the data to be uploaded of the ith transfer station, wherein f is the number of the transfer stations<u, collectionAnd f, uploading the data speed of the f transfer stations, selecting the transfer station with the highest speed as the optimal transportation transfer station, and uploading the data to be uploaded by the ith transfer station stored in the optimal transportation transfer station to the ERP comprehensive management system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210956971.8A CN115034523B (en) | 2022-08-10 | 2022-08-10 | Enterprise ERP (enterprise resource planning) comprehensive management system and method based on big data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210956971.8A CN115034523B (en) | 2022-08-10 | 2022-08-10 | Enterprise ERP (enterprise resource planning) comprehensive management system and method based on big data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115034523A CN115034523A (en) | 2022-09-09 |
| CN115034523B true CN115034523B (en) | 2022-11-01 |
Family
ID=83130555
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210956971.8A Active CN115034523B (en) | 2022-08-10 | 2022-08-10 | Enterprise ERP (enterprise resource planning) comprehensive management system and method based on big data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115034523B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115619451B (en) * | 2022-12-05 | 2023-03-10 | 中汽研汽车工业工程(天津)有限公司 | Order prediction method and system for production and manufacturing |
| CN116091175B (en) * | 2023-04-10 | 2023-08-22 | 南京航空航天大学 | Transaction information data management system and method based on big data |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1741053A (en) * | 2005-09-22 | 2006-03-01 | 上海交通大学 | Logistic warehousing and storaging decision supporting system |
| CN102385724A (en) * | 2010-08-27 | 2012-03-21 | 上海财经大学 | Spare part assembling demand forecasting information processing method applied to inventory management |
| WO2018072556A1 (en) * | 2016-10-18 | 2018-04-26 | 无锡知谷网络科技有限公司 | Logistics control method for goods, and electronic device |
| CN109829758A (en) * | 2019-01-25 | 2019-05-31 | 北京每日优鲜电子商务有限公司 | Sales Volume of Commodity prediction technique and system towards more duration of insurances |
| CN112396365A (en) * | 2019-08-14 | 2021-02-23 | 顺丰科技有限公司 | Inventory item prediction method and device, computer equipment and storage medium |
| KR102255754B1 (en) * | 2020-10-20 | 2021-05-26 | 우송대학교 산학협력단 | BIM-based railway infrastructure business information management system and method |
| CN114240302A (en) * | 2021-12-21 | 2022-03-25 | 昆山梦起达网络科技有限公司 | ERP management control method for electronic commerce enterprises |
| CN114462915A (en) * | 2021-12-24 | 2022-05-10 | 杭州拼便宜网络科技有限公司 | Multi-terminal warehouse e-commerce management method and system based on Internet of things |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106886874A (en) * | 2017-01-24 | 2017-06-23 | 武汉奇米网络科技有限公司 | A kind of order splits delivery system and splits delivery method |
-
2022
- 2022-08-10 CN CN202210956971.8A patent/CN115034523B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1741053A (en) * | 2005-09-22 | 2006-03-01 | 上海交通大学 | Logistic warehousing and storaging decision supporting system |
| CN102385724A (en) * | 2010-08-27 | 2012-03-21 | 上海财经大学 | Spare part assembling demand forecasting information processing method applied to inventory management |
| WO2018072556A1 (en) * | 2016-10-18 | 2018-04-26 | 无锡知谷网络科技有限公司 | Logistics control method for goods, and electronic device |
| CN109829758A (en) * | 2019-01-25 | 2019-05-31 | 北京每日优鲜电子商务有限公司 | Sales Volume of Commodity prediction technique and system towards more duration of insurances |
| CN112396365A (en) * | 2019-08-14 | 2021-02-23 | 顺丰科技有限公司 | Inventory item prediction method and device, computer equipment and storage medium |
| KR102255754B1 (en) * | 2020-10-20 | 2021-05-26 | 우송대학교 산학협력단 | BIM-based railway infrastructure business information management system and method |
| CN114240302A (en) * | 2021-12-21 | 2022-03-25 | 昆山梦起达网络科技有限公司 | ERP management control method for electronic commerce enterprises |
| CN114462915A (en) * | 2021-12-24 | 2022-05-10 | 杭州拼便宜网络科技有限公司 | Multi-terminal warehouse e-commerce management method and system based on Internet of things |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115034523A (en) | 2022-09-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN115034523B (en) | Enterprise ERP (enterprise resource planning) comprehensive management system and method based on big data | |
| US20210035250A1 (en) | Method and system for adaptive inventory replenishment | |
| US7668761B2 (en) | System and method for ensuring order fulfillment | |
| US20170357940A1 (en) | Method and system for dynamic inventory control | |
| CN101595498B (en) | The method and system placed for the stock according to expected item picking rates | |
| Behzadi et al. | Allocation flexibility for agribusiness supply chains under market demand disruption | |
| CN108154323B (en) | Dynamic management method and system for inventory | |
| US20150379449A1 (en) | Using consumption data and an inventory model to generate a replenishment plan | |
| TWI486885B (en) | Efficient inventory management for providing distinct service qualities for multiple demand groups | |
| US8700443B1 (en) | Supply risk detection | |
| US20150254589A1 (en) | System and Method to Provide Inventory Optimization in a Multi-Echelon Supply Chain Network | |
| US20080086392A1 (en) | Managing distribution of constrained product inventory from a warehouse | |
| US20200134545A1 (en) | Supply chain forecasting system | |
| JP2002519265A (en) | Method and system for maximizing the range of cover profiles during inventory management | |
| CN110163669B (en) | Demand prediction method based on characteristic coefficient likelihood estimation and retail business rule | |
| US20240152858A1 (en) | Method and system for tracking inventory including inventory level reconciliation across inventory tracking system | |
| CN116433158A (en) | Dynamic commodity inventory management system and method based on cloud computing | |
| CN115375024A (en) | Method and system for predicting and reminding purchasing based on bom material loss | |
| KR20210014432A (en) | Method for accurate estimating demand of Raw Materials Using System for estimating demand of Raw Materials | |
| Hansen et al. | Replenishment strategies for lost sales inventory systems of perishables under demand and lead time uncertainty | |
| CN115049332A (en) | Network inventory information determining method of warehousing network and electronic equipment | |
| US20100023363A1 (en) | Logistics plannning in a business environment | |
| CN115689442A (en) | Commodity cross-regional supply chain management method, commodity cross-regional supply chain management device and commodity cross-regional supply chain management medium based on big data | |
| CN116307433A (en) | Material guarantee supply method and electronic equipment | |
| WO2022182403A1 (en) | Fulfillment guidance devices, systems, and methods |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |