CN112488612A - Visualization-based full inventory resource monitoring and displaying method - Google Patents
Visualization-based full inventory resource monitoring and displaying method Download PDFInfo
- Publication number
- CN112488612A CN112488612A CN202011351149.6A CN202011351149A CN112488612A CN 112488612 A CN112488612 A CN 112488612A CN 202011351149 A CN202011351149 A CN 202011351149A CN 112488612 A CN112488612 A CN 112488612A
- Authority
- CN
- China
- Prior art keywords
- inventory
- warehouse
- amount
- resources
- visualization
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000012544 monitoring process Methods 0.000 title claims abstract description 33
- 238000012800 visualization Methods 0.000 title claims description 81
- 239000000463 material Substances 0.000 claims abstract description 269
- 230000000007 visual effect Effects 0.000 claims abstract description 12
- 238000007405 data analysis Methods 0.000 claims abstract description 7
- 230000007246 mechanism Effects 0.000 claims abstract description 4
- 238000007726 management method Methods 0.000 claims description 73
- 238000004458 analytical method Methods 0.000 claims description 55
- 230000007306 turnover Effects 0.000 claims description 36
- 238000003860 storage Methods 0.000 claims description 26
- 238000013461 design Methods 0.000 claims description 20
- 230000008859 change Effects 0.000 claims description 19
- 238000011161 development Methods 0.000 claims description 16
- 230000010354 integration Effects 0.000 claims description 14
- 238000012384 transportation and delivery Methods 0.000 claims description 9
- 238000012546 transfer Methods 0.000 claims description 5
- 238000013500 data storage Methods 0.000 claims description 4
- 238000007619 statistical method Methods 0.000 claims description 4
- RWSOTUBLDIXVET-UHFFFAOYSA-N Dihydrogen sulfide Chemical compound S RWSOTUBLDIXVET-UHFFFAOYSA-N 0.000 claims description 3
- 230000002159 abnormal effect Effects 0.000 claims description 3
- 238000004364 calculation method Methods 0.000 claims description 3
- 238000011065 in-situ storage Methods 0.000 claims description 3
- 238000007689 inspection Methods 0.000 claims description 3
- 238000011835 investigation Methods 0.000 claims description 3
- 230000007774 longterm Effects 0.000 claims description 3
- 238000012423 maintenance Methods 0.000 claims description 3
- 239000013589 supplement Substances 0.000 claims description 3
- 230000009466 transformation Effects 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000013439 planning Methods 0.000 description 3
- 230000004044 response Effects 0.000 description 3
- 230000003993 interaction Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000012938 design process Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000011535 turnover analysis 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/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
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Fuzzy Systems (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Mathematical Physics (AREA)
- Entrepreneurship & Innovation (AREA)
- Software Systems (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a visual-based monitoring and displaying method for total inventory resources, which comprises the steps of combing and integrating internal and external inventory resource data, establishing a total inventory resource pool, acquiring inventory scale and warehouse distribution information of materials through a related information system, combing and integrating internal resources and external resource data of various inventories, and realizing visual display of the inventory materials of each level unit; monitoring and analyzing the utilization efficiency of the full inventory resources; the method comprises the steps of identifying inventory resource management problems by comprehensively integrating and monitoring inventory resource data in real time and relying on a data analysis method, establishing an early warning information pushing mechanism, performing full inventory resource management risk early warning, and performing accurate or fuzzy query on an inventory resource pool through material codes, material descriptions and material types to realize the comprehensive query of full inventory resource information. The invention is visual and intelligent, realizes effective application of data assets, and supports operation decision.
Description
Technical Field
The invention relates to the technical field of inventory resource planning difficulty and material allocation, in particular to a full-scale inventory resource monitoring and displaying method based on visualization.
Background
At present, resource information such as physical inventory resources, virtual inventory resources, contract management and the like is deployed in different systems, data is dispersed, centralized control is not realized, and inventory resources are difficult to arrange integrally and material allocation is difficult. The inventory resources are usually counted manually, which often results in incomplete counting and low result accuracy, and affects the overall control and management decision of the material department on the inventory resources.
Meanwhile, in the inventory resource management process, the problems of inventory backlog, no contract execution in an overdue period and the like are not monitored and early warned in real time, so that certain risks exist in inventory resource management.
In addition, during emergency rescue and emergency projects, due to the fact that material inventory information is not mastered, when materials need to be allocated, external overall resources are verified and collected manually and offline, high concentration and controllable availability of the resources cannot be guaranteed, and the requirement for quick response cannot be met.
Disclosure of Invention
The invention aims to provide a visualization-based full-quantity inventory resource monitoring and displaying method which is visualized and intelligentized, enables managers to comprehensively know the overall situation of a material supply chain through comprehensive integration and real-time monitoring of inventory resource data, realizes effective application of data assets, supports operation decision and improves the material supply guarantee level.
The technical scheme of the invention is as follows:
a method for monitoring and displaying total inventory resources based on visualization comprises the steps of combing and integrating internal and external inventory resource data, establishing a total inventory resource pool, acquiring inventory scale and warehouse distribution information of materials through a related information system, combing and integrating internal resources and external resource data of various inventories, and realizing visualized display of the material resources of unit inventories of all levels; monitoring and analyzing the utilization efficiency of the full inventory resources; the method comprises the steps of identifying inventory resource management problems by comprehensively integrating and monitoring inventory resource data in real time and relying on a data analysis method, establishing an early warning information pushing mechanism, performing full inventory resource management risk early warning, and performing accurate or fuzzy query on an inventory resource pool through material codes, material descriptions and material types to realize the comprehensive query of full inventory resource information.
Preferably, the visualized display of the stock and material resources of each level of unit is specifically to establish a full stock resource pool, count and display basic information of registered warehouses, physical stock, virtual stock, supplier agreement reserve and contract resource conditions of each unit of headquarter, province, city and county, and realize the multidimensional comprehensive display and analysis of information such as the quantity, amount, stock age and the like of the full stock resources of a company; the method comprises the visualization of physical inventory resources, the visualization of virtual inventory resources, the visualization of supplier agreement reserve inventory resources and the visualization of contract resources.
Preferably, the visualization of the physical inventory resources comprises visualization of basic information of a warehouse, visualization of total material amount and money of a physical inventory resource pool, visualization of physical inventory resources, visualization of supplier deposit resources and visualization of inventory resources in a team station;
the warehouse basic information is subjected to visual statistics to display the quantity of each unit warehouse, the occupied area of the warehouse, the using area of the warehouse and the geographic position information of each warehouse, and classified statistics and display are carried out according to the dimension of a warehouse level, wherein the warehouse level comprises a national network storage warehouse, a central warehouse, a turnover warehouse, a storage point and a professional storage point;
the total material amount and the total amount of the materials in the physical inventory resource pool are displayed in a visual statistics mode, and classified statistics and display are carried out according to the warehouse level and the warehouse age dimension, wherein the warehouse level comprises a national grid emergency warehouse, a central warehouse, a turnover warehouse, a professional storage point and a storage point;
the physical inventory resource visualization respectively analyzes the quantity, the amount and the proportion of inventory materials according to the dimensions of material categories, item types, city units, factories, inventory ages and the like; and supports the fuzzy query of inventory information in key fields of material category, material code, material description, factory and the like;
the supplier deposit resource visualization respectively analyzes the quantity of the supplier deposit materials, the deposit amount and the proportion condition thereof according to the dimensions of the material category, the supplier name, the library age and the like, and supports the fuzzy query of the inventory information according to key fields of the material category, the material code, the material description, the supplier name and the like;
the method comprises the following steps that a cross-professional physical inventory platform with dispersed storage and information concentration is established in a visualized manner for inventory resources of a team station, an existing inventory management system is extended, and inventory data information of the team station is accessed; the method comprises the steps of displaying the inventory quantity of the team stations according to material category statistics, mastering the management status of team inventory resources in a company work area, and inquiring the inventory quantity and amount information of the team stations according to key fields such as names, material types, material codes, material descriptions and the like of the team stations.
Preferably, the visualization of the virtual inventory resources comprises a project straightening site, a non-project straightening site, emergency materials and borrowed materials; the data information is from an ERP system, the material category, the material code, the material description, the material quantity and the amount information of the entity inventory are obtained from a corresponding data storage table and are transmitted to a data center, the detailed data are integrated through the data center to form data required by index analysis, functional design and development implementation are carried out after an index statistics and analysis display interface is designed, and the inquiry of the quantity and the amount information of the inventory resources of the virtual inventory is supported according to the unit name, the material type, the material code and the key field of the material description;
the supplier agreement reserve inventory resource visualization: the method comprises the following steps of carrying out statistical display on the quantity and the amount of deposited materials of a supplier according to the material category and the name dimension of the supplier, and supporting fuzzy query of relevant information according to key fields such as material codes, material description and the name of the supplier; data recording is not carried out on the supplier agreement reserve inventory resources in an ERP system at present, relevant data are obtained by means of inputting ERP under an online mode according to indexes such as the supplier agreement reserve inventory quantity and the like, and data integration and classification are carried out after the relevant data are introduced into a data center.
Preferably, the contract resource visualization comprises contract resource material total amount and money visualization, unexecuted batch contract resource visualization, unallocated agreement inventory resource visualization and unexecuted agreement allocation order resource visualization;
the total amount and the amount of contract resource materials are visualized: counting and displaying the total amount and the total amount of various materials in various contract resources;
the unexecuted batch contract resource visualization: counting and displaying the total amount and the amount of materials related to the unexecuted contract; and carrying out classification statistics according to dimensions such as material category, whether the contract is out of date and the like; mastering the current situation that the company does not execute bidding contract management; and supporting to inquire the quantity of unexecuted batch contract resources and the amount information according to the material type, the material code and the material description key field;
unallocated protocol inventory resource visualization: counting the unallocated money and allocation proportion general conditions of the protocol inventory; and carrying out classified statistics according to the class dimension of the materials; mastering the current management situation of the company agreement inventory resources; and supporting to inquire the amount of the unallocated protocol inventory resources and the amount information according to the material type, the material code and the material description key field;
resource visualization of unexecuted protocol allocation orders: counting and displaying the total amount of materials and the total amount related to the unexecuted agreement allocation order; and carrying out classification statistics according to the material category and the dimension of whether the order is overdue or not; mastering the current management situation of an unexecuted protocol distribution order of a company; and supporting to inquire the resource quantity and the amount information of the order distributed by the unexecuted protocol according to the material type, the material code and the material description key field.
Preferably, the monitoring and analysis of the utilization efficiency of the full inventory resources comprises the following steps: on the basis of visualization of the current situation of the total inventory resources, the utilization efficiency of the total inventory is further analyzed, and key indexes such as the amount of money in and out of the warehouse, the unit area inventory amount of the warehouse, the inventory turnover rate, the execution rate of the balance interest bank, the execution timeliness rate of the balance interest bank and the like are subjected to statistical analysis;
the method specifically comprises the following steps: the method comprises the steps of analyzing the sum of money in and out of a warehouse, analyzing the inventory sum of unit area, analyzing the deposit turnover rate, analyzing the execution condition of a balance interest warehouse and analyzing the inventory resources of distribution network materials.
Preferably, the warehousing sum analysis comprises: analyzing the sum of the input and output of the materials, and analyzing the trend change and the difference condition of each warehouse according to the frequency of the month, the day and the like; firstly, providing a reference basis for protocol inventory allocation, secondly, identifying a warehouse with a low warehousing sum for a long time, and considering resource integration for the warehouse with actual conditions by combining in-situ investigation of the warehouse; supervising the warehouse which does not transact the warehouse-in and warehouse-out business to correct the problems; carrying out business inspection on warehouses with rapidly increased daily warehouse-in and warehouse-out amounts, and verifying whether the problem of false warehouse-in and warehouse-out is existed; and (3) analysis indexes: warehousing-out amount is equal to warehousing-in amount plus monthly warehousing-out amount;
analyzing the inventory amount per unit area: the method comprises the steps of analyzing unit area inventory amount of each warehouse by taking the utilization efficiency of the warehouse as a target, analyzing trend change of the unit area inventory amount of each warehouse, knowing utilization efficiency change level of each unit warehouse, and then carrying out transverse comparison by unit dimension to know utilization efficiency and difference level of the warehouses among units; and (3) analysis indexes: the unit area inventory sum is the entity inventory sum/the using area of the warehouse;
and (3) analyzing the deposit turnover rate: aiming at mastering the stock turnover efficiency of each warehouse, analyzing the stock turnover rate of each warehouse, analyzing the trend change of the stock turnover rate, and knowing the utilization efficiency change and the unit difference level of each unit warehouse; as a basis for allocating annual storage operation and maintenance cost, the method considers resource integration for a warehouse with low turnover rate, and considers increasing storage transformation and equipment retail project investment for a warehouse with high turnover rate; and (3) analysis indexes: the inventory turnover rate is the effective ex-warehouse amount/average inventory amount;
balance pool performance analysis: analyzing the execution condition and trend change of each unit balance interest bank, and knowing the execution condition and difference level of each unit balance interest bank; identifying the conditions of low execution rate and untimely execution; positioning management problems; the balance interest bank execution result information such as a factory calling, a stock calling place, a material code, the number of interest banks and the like is inquired, the execution condition of the balance interest bank is mastered, and the condition of untimely execution is analyzed in detail; and (3) analysis indexes: the balance interest bank execution rate is 100% of the allocated amount/matched amount; balance pool execution time rate ═ timely transfer amount/transferred amount × 100%: executing the transfer amount/the transferred amount within three days, and flexibly configuring the balance interest bank execution in-time condition judgment rule according to the business requirement;
analyzing distribution network material inventory resources: carrying out visual analysis on distribution network inventory resources by combining company service management concern points, acquiring distribution network material inventory data information of units in province, city and county, and displaying distribution network inventory total amount, inventory amount and average inventory age by material category statistics; and carrying out classified statistics according to material sources, warehouse levels and warehouse age dimensions; then, longitudinal comparison and transverse comparison are carried out according to the time dimension and the unit dimension; mastering the current management situation of the distribution network material inventory resources of a company; the warehouse level comprises a warehouse point, a national network emergency warehouse, a central warehouse, a turnover warehouse and a professional warehouse point.
Preferably, the risk early warning of the total inventory resource management refers to setting a relevant abnormal action standard aiming at mastering the problem of non-compliance in inventory management, identifying the problems of over-age of the inventory, insufficient inventory quota and non-compliance in service execution, pushing early warning information to relevant service personnel and preventing the risk of inventory management;
the method specifically comprises the following steps: risk early warning of inventory resource management, risk early warning of contract execution and problem early warning of business operation non-compliance.
Preferably, the risk early warning of inventory resource management: the method comprises the steps of inputting and outputting the amount of money to be put in a warehouse, the average amount of money to be put in the warehouse, the length of time for goods and materials to be put in the warehouse, the borrowing length of goods and materials, the actual amount of goods and materials reserved by a supplier agreement, the actual amount of goods and materials deposited by the supplier, the turnover rate of inventory, the proportion of goods and materials left in the warehouse after the balance of engineering and the like, wherein all index data are from an ERP system, relevant data information is obtained through the ERP system and is transmitted to a data center, detail data are integrated through the data center to form data required by index analysis, and a design index counting and analysis display interface is formed according to the material;
and (3) risk early warning is executed according to the contract: analyzing two indexes of contract money amount execution proportion and contract delivery date so as to judge the problems that the contract distribution proportion is not in compliance and the contract is not executed in overdue; the specific implementation scheme of each index is as follows: contract amount execution proportion: the index is the ratio of the executed contract amount and the supplement agreement amount, index calculation related data can be directly obtained in an ERP system, and a related data table is transmitted to a data center, and then index analysis, display design and development implementation are carried out; contract delivery date: the index data is from an ERP system, is transmitted to a data center after being acquired by the ERP system, and then is subjected to index analysis, display design and development implementation;
service operation non-compliance problem early warning: analyzing two indexes of the material acceptance time and the voucher cancellation rate, thereby judging the problems of long-term non-acceptance of material delivery, overhigh voucher cancellation rate and the like; the specific implementation scheme of each index is as follows: the material acceptance time is as follows: the index is calculated by subtracting the material handover date from the current date, wherein the handover time of each material can be directly obtained in an ERP system, and a relevant data table is transmitted to a data center, and then index analysis, display design and development implementation are carried out; voucher cancellation rate: the index is the ratio of the reimbursement amount to the total amount, wherein the detail data calculated by the reimbursement amount and the total amount are obtained in an ERP system, and the index-related data sheet is transmitted to a data center and then subjected to index analysis, display, design, development and implementation.
Preferably, the comprehensive query of the full inventory resource information refers to the realization of the comprehensive query of the full inventory resource information by taking mass data acquired by a related business system related to the full inventory resource as a data source; by fuzzy query of key fields such as material codes, material description, material types and the like, key information such as stock quantity, material sources (physical stock, virtual stock, contract orders and the like), belonged warehouses, geographic positions of the warehouses, allocated estimated time and the like of the materials in unit warehouses of province, city and county is displayed, so that material and project management personnel can know stock information of the unit conveniently, and required materials are assisted to be positioned quickly and allocated on time; the material sources include physical inventory, virtual inventory, and contract orders.
The invention has the beneficial effects that:
visualization: the method comprises the steps of establishing a supply chain resource pool, realizing effective integration and dynamic update data integration of resources through an ERP (enterprise resource planning), a Warehouse Management System (WMS) and an open supplier internet port, obtaining information such as historical inventory ledgers, in-out-of-warehouse certificates and inventory distribution of the ERP system, combing and integrating various inventory resource data, early warning of profitable warehouse resources of each unit, realizing visualization of warehouse resources and improving inventory resource control capacity.
Intelligentization: under emergency rescue, measures such as collecting distribution distance information of each unit, making resource priority arrangement capable of being called and the like are adopted, material supply strategies of 'first-interest storehouse, later-purchase' and 'first-near-later-far' are solidified into system logic, intelligent resource matching of emergency material demands is realized, and emergency supply decision is assisted; the on-line monitoring of each link of emergency response is realized, and the response capability of emergency materials is guaranteed.
And (3) data analysis: by means of comprehensive integration and real-time monitoring of inventory resource data, the inventory resource is transparent and visualized by means of a big data analysis model and cloud computing processing capacity. The management personnel can comprehensively know the overall situation of the material supply chain, the effective application of data assets is realized, the operation decision is supported, and the material supply guarantee level is improved.
Drawings
FIG. 1 is a diagram of a business architecture of the present invention;
FIG. 2 is a diagram of an application architecture of the present invention;
FIG. 3 is a diagram of the data architecture of the present invention;
fig. 4 is a technical architecture diagram of the present invention.
Detailed Description
As shown in fig. 1-4, the internal and external inventory resource data are sorted and integrated, a full inventory resource pool is established, information such as material inventory scale and warehouse distribution is acquired through a related information system, the internal resource data and the external resource data of various inventories are sorted and integrated, and the visual display of the material resources of each level of unit inventory is realized. And the inventory resource pool is accurately or fuzzily inquired through material coding, material description and material category, so that the balance interest bank of materials and overall allocation business are supported, and the inventory resource control capacity is improved.
The inventory resource management problem is identified and an early warning information pushing mechanism is established by comprehensively integrating and monitoring inventory resource data in real time and depending on a data analysis method. The management personnel can comprehensively know the current situation and problems of inventory management, realize the efficient and standard application of inventory resources, strengthen the assistant decision and improve the guarantee level of material supply.
1.1. Full inventory resource visualization
And establishing a full inventory resource pool, counting and displaying basic information of registered warehouses, physical inventory, virtual inventory, supplier agreement reserve and contract resource conditions of headquarters, provinces, cities and counties, and realizing multi-dimensional comprehensive display and analysis of information such as the quantity, the amount, the storage age and the like of the full inventory resources of the company.
1.1.1. Physical inventory resource visualization
The visualization of the physical inventory resources comprises basic information of a registered warehouse, the total material amount of a physical inventory resource pool and the total amount; and the entity inventory resources, the supplier deposit resources, the material type of the inventory resources in the team station, the inventory quantity, the inventory amount, the inventory age and other contents are visually displayed. And supports the fuzzy query of key business information such as unit-by-unit, factory-by-factory, warehouse-by-warehouse, material category, material coding, material description and the like.
(1) Visualization of basic information of a warehouse
And counting and displaying information such as the quantity of each unit warehouse, the occupied area of the warehouse, the use area of the warehouse, the geographic position of each warehouse and the like, and carrying out classified statistics and display according to dimensions such as warehouse levels (national network storage, central warehouse, turnover warehouse, storage point and professional storage point).
(2) Visualization of total material amount and sum of material in material object inventory resource pool
And counting and displaying the total amount and the total amount of various materials in the physical inventory, and carrying out classified statistics and display according to dimensions such as warehouse levels (national network emergency warehouse, central warehouse, turnover warehouse, professional storage points and storage points), warehouse ages and the like.
(3) Physical inventory resource visualization
The physical inventory resources can analyze the quantity, the amount and the proportion of inventory materials according to the dimensions of material categories, item types, city units, factories, inventory ages and the like. And supports the fuzzy query of the inventory information with key fields of material category, material code, material description, factory and the like.
(4) Vendor hosted resource visualization
The physical inventory resource can analyze the quantity of deposited materials, the deposit amount and the proportion of the deposited materials according to the dimensions such as material category, supplier name, inventory age and the like. And supports the fuzzy query of inventory information according to key fields such as material category, material code, material description, supplier name and the like.
(5) Team station inventory resource visualization
And a cross-professional physical inventory platform with 'dispersed storage and information concentration' is established, the existing inventory management system is extended, and inventory data information of the team station is accessed. And (4) displaying the stock quantity of the group station according to the material category statistics. And mastering the current management situation of the stock resources of the teams in the company work area. And the inquiry of the quantity and the amount information of the stored resources of the team station is supported according to key fields such as the name, the material type, the material code, the material description and the like of the team station.
1.1.2. Virtual inventory resource visualization
The virtual inventory resources comprise four types of project direct-emitting sites, non-project direct-emitting sites, emergency supplies and borrowing supplies. The data information is from an ERP system, the information of material category, material code, material description, material quantity, amount and the like of the entity inventory is obtained from a corresponding data storage table and is transmitted to a data center, the detailed data is integrated through the data center to form data required by index analysis, functional design and development implementation are carried out after an index statistics and analysis display interface is designed, and inquiry of the information of the quantity of inventory resources and the amount of the virtual inventory is supported according to key fields of unit name, material type, material code, material description and the like.
1.1.3. Supplier agreement reserve inventory resource visualization
And the quantity and the amount of the deposited materials of the supplier are statistically displayed according to the material category and the name dimension of the supplier, and the fuzzy query of relevant information is supported according to key fields such as material codes, material description and the name of the supplier.
Data recording is not carried out on the supplier agreement reserve inventory resources in an ERP system at present, relevant data are obtained by means of inputting ERP under an online mode according to indexes such as the supplier agreement reserve inventory quantity and the like, and data integration and classification are carried out after the relevant data are introduced into a data center.
1.1.4. Contract resource visualization
(1) Contract resource material total amount and amount visualization
And counting and displaying the total amount and the total amount of various materials in various contract resources.
(2) Unexecuted batch contract resource visualization
And counting and displaying the total amount and the amount of the materials involved in the unexecuted contract. And carrying out classification statistics according to dimensions such as material types, whether contracts exceed time and the like. And the status quo that the company does not execute bidding contract management is mastered. And supporting to inquire the quantity and the amount information of the unexecuted batch contract resources according to key fields such as material types, material codes, material descriptions and the like.
(3) Unallocated protocol inventory resource visualization
And counting the overall conditions of unallocated money, allocation proportion and the like of the protocol inventory. And carrying out classification statistics according to the material class dimension. And mastering the current management situation of the stock resources of the company agreement. And supporting to inquire the amount and the amount information of the unallocated protocol inventory resources according to key fields such as material types, material codes, material descriptions and the like.
(4) Allocation of order resources by unexecuted protocols
And counting and displaying the total amount of materials and the total amount involved by the unexecuted agreement allocation order. And carrying out classification statistics according to dimensions such as material types, whether orders exceed the time and the like. And (4) mastering the current management situation of the non-executed agreement distribution orders of the company. And supporting to inquire the resource quantity and the amount information of the order distributed by the unexecuted protocol according to key fields such as material type, material code, material description and the like.
1.2. Monitoring and analyzing utilization efficiency of full stock resources
On the basis of the visualization of the current situation of the total inventory resources, the utilization efficiency of the total inventory is further analyzed, and the statistical analysis is performed on key indexes such as the amount of money in and out of the warehouse, the unit area inventory amount of the warehouse, the inventory turnover rate, the execution rate of the balance interest bank, the execution timeliness rate of the balance interest bank and the like. The system is convenient for material management personnel to master the utilization efficiency of the stored materials in time, and identify the service management problems of low utilization efficiency, untimely execution and the like. Monitoring and analyzing utilization efficiency of full stock resources
1.2.1. Analysis of out-of-warehouse money
Analyzing the sum of the input and output of the materials, and analyzing the trend change and the difference condition of each warehouse according to the frequency of the month, the day and the like. Firstly, providing a reference basis for protocol inventory allocation, secondly, identifying a warehouse with a low warehousing sum for a long time, and considering resource integration for the warehouse with actual conditions by combining in-situ investigation of the warehouse; supervising the warehouse which does not transact the warehouse-in and warehouse-out business to correct the problems; and (4) carrying out business inspection on warehouses with rapidly increased daily warehouse-in and warehouse-out amounts, and verifying whether the problem of false warehouse-in and warehouse-out is existed.
And (3) analysis indexes: the warehousing-out amount is the warehousing amount plus the monthly warehousing-out amount
1.2.2. Analysis of unit area inventory
The method is characterized in that the method aims at mastering the use efficiency of the warehouse, analyzes the unit area inventory amount of each warehouse, analyzes the trend change of the unit area inventory amount of each warehouse, knows the utilization efficiency change level of each unit warehouse, and then carries out transverse comparison by unit dimension to know the utilization efficiency and difference level of the warehouse among units.
And (3) analysis indexes: the unit area inventory sum is the physical inventory sum/the area of the warehouse
1.2.3. Inventory turnover analysis
The turnover efficiency of each warehouse is mastered as a target, the turnover rate of each warehouse is analyzed, the trend change of each warehouse is analyzed, and the utilization efficiency change of each unit warehouse and the difference level of each unit are known. As a basis for allocating annual storage operation and maintenance cost, the method considers resource integration for a warehouse with low turnover rate and increases storage transformation and equipment retail project investment for a warehouse with high turnover rate.
And (3) analysis indexes: the inventory turnover rate is the effective out-of-stock amount/average inventory amount.
1.2.4. Balanced liberty execution analysis
And analyzing the execution condition and trend change of each unit balance interest library to know the execution condition and difference level of each unit balance interest library. Situations with low execution rate and untimely execution are identified. And (5) positioning management.
The balance interest library execution result information such as a factory calling, a stock calling place, a material code, the number of interest libraries and the like is inquired, the execution condition of the balance interest libraries is mastered, and the condition of untimely execution is analyzed in detail.
And (3) analysis indexes: balance interest bank execution rate is the allocated amount/matched amount 100%
The balance library executes the timely rate (timely transfer amount/transfer amount) 100% (within three days, the balance library executes the timely condition judgment rule which can be flexibly configured according to the business requirement)
1.2.5. Distribution network material inventory resource analysis
And carrying out visual analysis on the distribution network inventory resources by combining with company service management concerns, acquiring distribution network material inventory data information of units in province, city and county, and displaying the distribution network inventory total amount, the inventory amount and the average inventory age by material category statistics. And carrying out classification statistics according to dimensions such as material sources, warehouse levels (warehouse points, national network emergency warehouses, central warehouses, turnover warehouses and professional warehouse points), warehouse ages and the like. And then carrying out longitudinal comparison and transverse comparison according to the time dimension and the unit dimension. And mastering the current management situation of the distribution network material inventory resources of the company.
1.3. Full inventory resource management risk early warning
The method aims at mastering the problem of non-compliance in inventory management, sets a relevant abnormal action standard, identifies the problems of over-age of the inventory, insufficient inventory quota, non-compliance in service execution and the like, pushes early warning information to relevant service personnel and prevents inventory management risks. Full inventory resource management risk early warning
1.3.1. Inventory resource management risk early warning
The system comprises indexes such as the amount of money going out of a warehouse and the amount of money going in the warehouse, the time length of materials in the warehouse, the time length of borrowing the materials, the actual amount of materials reserved by a supplier agreement, the actual amount of materials deposited by the supplier, the turnover rate of the inventory, the proportion of the materials left in the warehouse by engineering, and the like, wherein all index data are from an ERP system, relevant data information is obtained through the ERP system and is transmitted to a data center, then detail data are integrated through the data center to form data required by index analysis, and design index statistics and analysis display interfaces are designed according to the dimensions such as material types, units, warehouses to which the materials belong. The rules are as follows:
1.3.2. contract execution risk early warning
The part mainly analyzes two indexes of contract money execution proportion and contract delivery date, thereby judging the problems that the contract distribution proportion is not in compliance and the contract is not executed in overdue. The specific implementation scheme of each index is as follows:
contract amount execution proportion: the index is the ratio of the executed contract amount and the supplement agreement amount, and the index calculation related data can be directly obtained in an ERP system, and the related data table is transmitted to a data center, and then index analysis, display design and development implementation are carried out.
Contract delivery date: the index data is from an ERP system, is acquired by the ERP system and then is transmitted to a data center, and then index analysis, display design and development implementation are carried out.
The rules are as follows:
1.3.3. business operation non-compliance problem early warning
The part mainly analyzes two indexes of the material acceptance time and the voucher cancellation rate, thereby judging the problems of long-term non-acceptance of material delivery, overhigh voucher cancellation rate and the like. The specific implementation scheme of each index is as follows:
the material acceptance time is as follows: the index is calculated by subtracting the material handover date from the current date, wherein the handover time of each material can be directly obtained in an ERP system, and a relevant data table is transmitted to a data center, and then index analysis, display design and development implementation are carried out.
Voucher cancellation rate: the index is the ratio of the reimbursement amount to the total amount, wherein the detail data calculated by the reimbursement amount and the total amount can be obtained in an ERP system, and the index-related data sheet is transmitted to a data center and then subjected to index analysis, display, design, development and implementation.
The rules are as follows:
1.4. comprehensive query of full inventory resource information
And mass data acquired by a related service system related to the full inventory resources are taken as a data source, so that the information of the full inventory resources is comprehensively inquired. By fuzzy query of key fields such as material codes, material description, material types and the like, key information such as stock quantity, material sources (physical stock, virtual stock, contract orders and the like), belonged warehouses, geographic positions of the warehouses, allocated estimated time and the like of the materials in unit warehouses of province, city and county is displayed, so that material and project management personnel can know stock information of the unit conveniently, and required materials can be rapidly positioned and allocated on time in an auxiliary mode.
The general design principle of the invention is as follows:
the system adheres to a standardized construction mode in the design process, carries out related business, management and technical specification standards of the state and the power industry, actively sets up related standard specifications of projects, and adopts standard design and advanced technology to ensure the practicability, openness, safety, stability, maintainability and manageability of software. The specific principle is as follows:
(1) according to the principle of 'four unifications': unified leader, unified planning, unified standard, unified organization and implementation.
(2) According to the principle of national grid company resource management plan (SG-ERP) overall scheme and framework design.
(3) According to the principle of information classification and coding system.
(4) The method is based on the principles of first-level deployment, multi-level application, unified development, unified popularization, complete system functions and configurable system modules.
Table 1 shows the general technical route of the invention
TABLE 1 general technical route
FIG. 1: the full inventory resource visualization scene is divided into three parts, namely full inventory resource visualization, full inventory resource utilization efficiency monitoring analysis and full inventory resource management problem early warning. The full inventory resource visualization part aims at performing dimension-based statistical analysis and visual display on the quantity and the amount of materials such as physical inventory resources, virtual inventory resources, supplier deposit, inventory resources of team stations, contract resources and the like so as to know the inventory level and the management status of company materials; the full-inventory resource utilization efficiency monitoring and analyzing part aims at monitoring and analyzing the utilization efficiency of the materials in each warehouse so as to master the utilization and management level of each warehouse and various materials, specially analyze the material inventory condition of the distribution network project and master the mode management condition of 'material object storage and on-demand utilization'; the full inventory resource management problem early warning part aims to identify the problem of non-compliance in material and inventory management through data analysis, assist in rectifying business problems, improve the work level of material management, and prevent business management risks such as inventory overstock, contract overdue and the like.
FIG. 2: the full inventory resource visualization service scene comprises the functions of basic information management, inventory resource thematic analysis, key index signboards, early warning information push management, inventory resource query, authority management, interface management and the like. The required data mainly comes from an ERP system and is accessed to a data center, and the main implementation mode of each analysis content is as follows: and data acquisition, integration and classification are carried out in a data center platform, and service data information is visually displayed in a supply chain cloud platform system.
FIG. 3: the data architecture of the supply chain cloud platform system is used, and the data are divided into structured data, semi-structured data and unstructured data according to the data characteristics of material services. And deploying an oracle rac cluster to store and manage structured and semi-structured data, wherein unstructured data of the system is stored and managed by adopting a file system, and all data are stored on a disk array.
FIG. 4: constructing micro services based on an intranet cloud platform foundation, and using basic components such as cloud platform service monitoring, service management, middleware service, load balancing and the like; the data transmission of the client and the server adopts a mainstream mature Restful interface mode; and a security access gateway is adopted during data interaction between the client and the server to support the access security from the client to the server. The method mainly comprises the following steps:
(1) and the infrastructure layer shields the difference of the infrastructure at the bottom layer and is directly deployed on the virtual machine of the power intranet cloud platform system.
(2) And the data layer provides data storage services for the application, and comprises a database, a cache, a file system and the like, wherein the database stores structured data generated by the system, the cache stores data with high access frequency and low change frequency, and the file system stores unstructured document data.
(3) The service application layer comprises a service logic layer and a data access layer; the Service logic is realized in Service, and the platform logic component comprises: and the API calls and packages of micro-services such as full inventory resource display, full inventory resource query, early warning information, push management, system parameters, standard codes, menu components, messages and the like.
(4) The display layer is mainly used for realizing interface display and user interaction at the front end, calling the rear-end logic layer in a dubbo RPC mode through functions of HTML, HTML5, CSS, Javascript, jQuery and the like, and providing services to the outside through various service protocols such as SpringMVC, Controller, Rest API, Webservice and the like and corresponding data protocols.
Claims (10)
1. A full inventory resource monitoring and display method based on visualization is characterized by comprising the steps of combing and integrating internal and external inventory resource data, establishing a full inventory resource pool, acquiring inventory scale and warehouse distribution information of materials through a related information system, combing and integrating internal resources and external resource data of various inventories, and realizing visualized display of the materials of each level unit inventory; monitoring and analyzing the utilization efficiency of the full inventory resources; the method comprises the steps of identifying inventory resource management problems by comprehensively integrating and monitoring inventory resource data in real time and relying on a data analysis method, establishing an early warning information pushing mechanism, performing full inventory resource management risk early warning, and performing accurate or fuzzy query on an inventory resource pool through material codes, material descriptions and material types to realize the comprehensive query of full inventory resource information.
2. The method for monitoring and displaying the total inventory resources based on visualization as claimed in claim 1, wherein the visualization display of the inventory material resources of each level of units is specifically to establish a total inventory resource pool, count and display basic information of registered warehouses, physical inventories, virtual inventories, supplier agreement reserves and contract resource conditions of each unit of headquarter, province, city and county, and realize the multidimensional comprehensive display and analysis of the quantity, amount and inventory age information of the total inventory resources of a company; the method comprises the visualization of physical inventory resources, the visualization of virtual inventory resources, the visualization of supplier agreement reserve inventory resources and the visualization of contract resources.
3. The method for monitoring and displaying the total inventory resources based on the visualization as recited in claim 2, wherein the visualization of the physical inventory resources includes visualization of basic information of a warehouse, visualization of total amount of materials and amount in a physical inventory resource pool, visualization of physical inventory resources, visualization of supplier deposit resources, and visualization of inventory resources in a team station;
the warehouse basic information is subjected to visual statistics to display the quantity of each unit warehouse, the occupied area of the warehouse, the using area of the warehouse and the geographic position information of each warehouse, and classified statistics and display are carried out according to the dimension of a warehouse level, wherein the warehouse level comprises a national network storage warehouse, a central warehouse, a turnover warehouse, a storage point and a professional storage point;
the total material amount and the total amount of the materials in the physical inventory resource pool are displayed in a visual statistics mode, and classified statistics and display are carried out according to the warehouse level and the warehouse age dimension, wherein the warehouse level comprises a national grid emergency warehouse, a central warehouse, a turnover warehouse, a professional storage point and a storage point;
the physical inventory resource visualization respectively analyzes the quantity, the amount and the proportion of inventory materials according to the material category, the item type, the city unit, the factory and the inventory age dimension; and supports the fuzzy query of inventory information by material category, material code, material description and factory key fields;
the supplier deposit resource visualization analyzes the quantity of the supplier deposit materials, the deposit amount and the proportion thereof according to the material category, the supplier name and the library age dimension, and supports the fuzzy query of the inventory information according to the material category, the material code, the material description and the supplier name key field;
the method comprises the following steps that a cross-professional physical inventory platform with dispersed storage and information concentration is established in a visualized manner for inventory resources of a team station, an existing inventory management system is extended, and inventory data information of the team station is accessed; the method comprises the steps of displaying the inventory quantity of team stations according to material category statistics, mastering the management status of team inventory resources in a company work area, and inquiring the inventory quantity and amount information of the team stations according to the names of the team stations, the material types, the material codes and the material description key fields.
4. The visualization-based full-amount inventory resource monitoring and displaying method as claimed in claim 2, wherein the visualization of virtual inventory resources includes four types of project-oriented sites, non-project-oriented sites, emergency supplies and borrowed supplies; the data information is from an ERP system, the material category, the material code, the material description, the material quantity and the amount information of the entity inventory are obtained from a corresponding data storage table and are transmitted to a data center, the detailed data are integrated through the data center to form data required by index analysis, functional design and development implementation are carried out after an index statistics and analysis display interface is designed, and the inquiry of the quantity and the amount information of the inventory resources of the virtual inventory is supported according to the unit name, the material type, the material code and the key field of the material description;
the supplier agreement reserve inventory resource visualization: the method comprises the following steps of carrying out statistical display on the quantity and the amount of deposited materials of a supplier according to the material category and the name dimension of the supplier, and supporting fuzzy query of relevant information according to material codes, material description and name key fields of the supplier; the supplier agreement reserve inventory resources do not record data in an ERP system at present, and supplier agreement reserve inventory quantity indexes acquire relevant data by means of recording the ERP offline, and then are imported into a data center to perform data integration and classification.
5. The method for monitoring and displaying the total inventory resources based on the visualization as claimed in claim 2, wherein the visualization of the contract resources comprises visualization of the total material amount and the amount of the contract resources, visualization of the unexecuted batch contract resources, visualization of the unallocated agreed inventory resources and allocation of the order resources for the unexecuted agreement;
the total amount and the amount of contract resource materials are visualized: counting and displaying the total amount and the total amount of various materials in various contract resources;
the unexecuted batch contract resource visualization: counting and displaying the total amount and the amount of materials related to the unexecuted contract; and carrying out classification statistics according to the material category and the dimension of whether the contract exceeds the period; mastering the current situation that the company does not execute bidding contract management; and supporting to inquire the quantity of unexecuted batch contract resources and the amount information according to the material type, the material code and the material description key field;
unallocated protocol inventory resource visualization: counting the unallocated money and allocation proportion general conditions of the protocol inventory; and carrying out classified statistics according to the class dimension of the materials; mastering the current management situation of the company agreement inventory resources; and supporting to inquire the amount of the unallocated protocol inventory resources and the amount information according to the material type, the material code and the material description key field;
resource visualization of unexecuted protocol allocation orders: counting and displaying the total amount of materials and the total amount related to the unexecuted agreement allocation order; and carrying out classification statistics according to the material category and the dimension of whether the order is overdue or not; mastering the current management situation of an unexecuted protocol distribution order of a company; and supporting to inquire the resource quantity and the amount information of the order distributed by the unexecuted protocol according to the material type, the material code and the material description key field.
6. The full-amount inventory resource monitoring and displaying method based on visualization as claimed in claim 1, wherein the full-amount inventory resource utilization efficiency monitoring analysis comprises: on the basis of visualization of the current situation of the total inventory resources, the utilization efficiency of the total inventory is further analyzed, and the key indexes of the in-out amount of the inventory, the inventory amount of the unit area of the warehouse, the inventory turnover rate, the execution rate of the balance interest bank and the execution timeliness rate of the balance interest bank are subjected to statistical analysis;
the method specifically comprises the following steps: the method comprises the steps of analyzing the sum of money in and out of a warehouse, analyzing the inventory sum of unit area, analyzing the deposit turnover rate, analyzing the execution condition of a balance interest warehouse and analyzing the inventory resources of distribution network materials.
7. The method as claimed in claim 6, wherein the analysis of the total amount of inventory in and out warehouse is as follows: analyzing the sum of the input and output of the material, and analyzing the trend change and the difference condition of each warehouse according to the monthly and daily frequency; firstly, providing a reference basis for protocol inventory allocation, secondly, identifying a warehouse with a low warehousing sum for a long time, and considering resource integration for the warehouse with actual conditions by combining in-situ investigation of the warehouse; supervising the warehouse which does not transact the warehouse-in and warehouse-out business to correct the problems; carrying out business inspection on warehouses with rapidly increased daily warehouse-in and warehouse-out amounts, and verifying whether the problem of false warehouse-in and warehouse-out is existed; and (3) analysis indexes: warehousing-in amount = warehousing amount + monthly warehousing-out amount;
analyzing the inventory amount per unit area: the method comprises the steps of analyzing unit area inventory amount of each warehouse by taking the utilization efficiency of the warehouse as a target, analyzing trend change of the unit area inventory amount of each warehouse, knowing utilization efficiency change level of each unit warehouse, and then carrying out transverse comparison by unit dimension to know utilization efficiency and difference level of the warehouses among units; and (3) analysis indexes: the unit area stock sum = entity stock sum/warehouse use area;
and (3) analyzing the deposit turnover rate: aiming at mastering the stock turnover efficiency of each warehouse, analyzing the stock turnover rate of each warehouse, analyzing the trend change of the stock turnover rate, and knowing the utilization efficiency change and the unit difference level of each unit warehouse; as a basis for allocating annual storage operation and maintenance cost, the method considers resource integration for a warehouse with low turnover rate, and considers increasing storage transformation and equipment retail project investment for a warehouse with high turnover rate; and (3) analysis indexes: inventory turnover = effective ex-warehouse amount/average inventory amount;
balance pool performance analysis: analyzing the execution condition and trend change of each unit balance interest bank, and knowing the execution condition and difference level of each unit balance interest bank; identifying the conditions of low execution rate and untimely time; positioning management problems; supporting the inquiry of the information of the execution results of the balance interest library of the calling-out factory, the calling-in factory, the calling-out stock location, the calling-in stock location, the material coding and the interest library quantity, mastering the execution condition of the balance interest library and carrying out detailed analysis on the condition of untimely execution; and (3) analysis indexes: balanced library execution rate = dialed amount/matched amount 100%; balance pool implementation timely = timely dialed amount/dialed amount 100%: executing the transfer amount/the transferred amount within three days, and executing the timely condition judgment rule by the balance interest bank to be flexibly configured according to the service requirement;
analyzing distribution network material inventory resources: carrying out visual analysis on distribution network inventory resources by combining company service management concern points, acquiring distribution network material inventory data information of units in province, city and county, and displaying distribution network inventory total amount, inventory amount and average inventory age by material category statistics; and carrying out classified statistics according to material sources, warehouse levels and warehouse age dimensions; then, longitudinal comparison and transverse comparison are carried out according to the time dimension and the unit dimension; mastering the current management situation of the distribution network material inventory resources of a company; the warehouse level comprises a warehouse point, a national network emergency warehouse, a central warehouse, a turnover warehouse and a professional warehouse point.
8. The method for monitoring and displaying the total inventory resources based on visualization as claimed in claim 1, wherein the total inventory resource management risk early warning is to set a relevant abnormal action standard aiming at mastering the problem of non-compliance in inventory management, identify the problems of over-age of the inventory, insufficient inventory quota and non-compliance in service execution, push early warning information to relevant service personnel and prevent the risk of inventory management;
the method specifically comprises the following steps: risk early warning of inventory resource management, risk early warning of contract execution and problem early warning of business operation non-compliance.
9. The visualization-based monitoring and displaying method for the total inventory resources as claimed in claim 8, wherein the risk pre-warning for inventory resource management is: the method comprises the steps of inputting and outputting the amount of money to be put in a warehouse, the average amount of money to be put in the warehouse, the length of time for the goods and materials to be put in the warehouse, the borrowing length of the goods and materials, the actual amount of the goods and materials which are reserved by a supplier agreement, the actual amount of the goods and materials which are deposited by the supplier, the turnover rate of the inventory and the proportion index of the goods and materials which are returned from the warehouse after the balance of the project, wherein all index data are from an ERP system, relevant data information is obtained through the ERP system and is transmitted to a data center, detail data are integrated through the data center to form data required by index analysis, and a;
and (3) risk early warning is executed according to the contract: analyzing two indexes of contract money amount execution proportion and contract delivery date so as to judge the problems that the contract distribution proportion is not in compliance and the contract is not executed in overdue; the specific implementation scheme of each index is as follows: contract amount execution proportion: the index is the ratio of the executed contract amount and the supplement agreement amount, index calculation related data can be directly obtained in an ERP system, and a related data table is transmitted to a data center, and then index analysis, display design and development implementation are carried out; contract delivery date: the index data is from an ERP system, is transmitted to a data center after being acquired by the ERP system, and then is subjected to index analysis, display design and development implementation;
service operation non-compliance problem early warning: analyzing two indexes of the material acceptance time and the voucher cancellation rate, thereby judging the problems of long-term non-acceptance of material delivery and overhigh voucher cancellation rate; the specific implementation scheme of each index is as follows: the material acceptance time is as follows: the index is calculated by subtracting the material handover date from the current date, wherein the handover time of each material can be directly obtained in an ERP system, and a relevant data table is transmitted to a data center, and then index analysis, display design and development implementation are carried out; voucher cancellation rate: the index is the ratio of the reimbursement amount to the total amount, wherein the detail data calculated by the reimbursement amount and the total amount are obtained in an ERP system, and the index-related data sheet is transmitted to a data center and then subjected to index analysis, display, design, development and implementation.
10. The method for monitoring and displaying the total inventory resource based on visualization as claimed in claim 1, wherein the comprehensive query of the total inventory resource information is to use mass data acquired by a related business system related to the total inventory resource as a data source to realize the comprehensive query of the total inventory resource information; through fuzzy query of material codes, material description and key fields of material types, the inventory quantity, material sources, the belonged warehouse and the geographic position of the warehouse and the key information of the predicted time length of allocation of the material in each unit warehouse of province, city and county are displayed, so that material and project management personnel can know the inventory information of the unit conveniently, and the needed material is assisted to be positioned quickly and allocated on time; the material sources include physical inventory, virtual inventory, and contract orders.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011351149.6A CN112488612A (en) | 2020-11-26 | 2020-11-26 | Visualization-based full inventory resource monitoring and displaying method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011351149.6A CN112488612A (en) | 2020-11-26 | 2020-11-26 | Visualization-based full inventory resource monitoring and displaying method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112488612A true CN112488612A (en) | 2021-03-12 |
Family
ID=74935249
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011351149.6A Pending CN112488612A (en) | 2020-11-26 | 2020-11-26 | Visualization-based full inventory resource monitoring and displaying method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112488612A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113011819A (en) * | 2021-03-22 | 2021-06-22 | 北京金山云网络技术有限公司 | Bare metal server management method and device and management server |
| CN113254546A (en) * | 2021-05-24 | 2021-08-13 | 北京无线电测量研究所 | Supply chain management and control system and method and electronic equipment |
| CN113592309A (en) * | 2021-08-02 | 2021-11-02 | 上海华能电子商务有限公司 | Multi-level inventory quota making method based on data driving |
| CN113762891A (en) * | 2021-08-26 | 2021-12-07 | 大汉电子商务有限公司 | Steel storage management method and system based on region space |
| CN114202140A (en) * | 2021-06-16 | 2022-03-18 | 中国电建集团华东勘测设计研究院有限公司 | Map display-based informatization flood prevention material management method |
| CN116029671A (en) * | 2023-01-04 | 2023-04-28 | 国家电网有限公司华东分部 | Power grid project material early warning method and device, storage medium and electronic equipment |
| CN116757606A (en) * | 2023-07-05 | 2023-09-15 | 国网黑龙江省电力有限公司营销服务中心 | Inventory metering asset lean management system based on intelligent Internet of things |
| CN117974013A (en) * | 2024-04-01 | 2024-05-03 | 深圳市崇晸实业有限公司 | Monitoring method and system for e-commerce warehouse inventory management |
| CN117993738A (en) * | 2024-04-03 | 2024-05-07 | 深圳美云集网络科技有限责任公司 | E-business operation early warning method and system for multiple scenes |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103413210A (en) * | 2013-08-15 | 2013-11-27 | 上海云翎物联网科技有限公司 | Emergency material management system based on internet of things technology |
| CN105447660A (en) * | 2014-09-01 | 2016-03-30 | 国网浙江省电力公司温州供电公司 | Auxiliary material management system |
| CN105701617A (en) * | 2016-01-14 | 2016-06-22 | 国网山东省电力公司物资公司 | Overall process information management and control visualization method based on electric power material supply chain and system thereof |
| CN106529869A (en) * | 2016-10-27 | 2017-03-22 | 国网天津市电力公司 | Material inventory item dynamic characteristic analysis platform and analysis method thereof |
| CN106940842A (en) * | 2017-03-23 | 2017-07-11 | 云南电网有限责任公司昆明供电局 | A kind of electric power enterprise material supply monitoring method and system |
| CN109884965A (en) * | 2019-03-06 | 2019-06-14 | 扬州大学 | Physiological driver's parameter monitoring and safe early warning cloud control system based on Internet of Things |
| CN111612425A (en) * | 2020-05-22 | 2020-09-01 | 国网福建省电力有限公司 | Material distribution system |
-
2020
- 2020-11-26 CN CN202011351149.6A patent/CN112488612A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103413210A (en) * | 2013-08-15 | 2013-11-27 | 上海云翎物联网科技有限公司 | Emergency material management system based on internet of things technology |
| CN105447660A (en) * | 2014-09-01 | 2016-03-30 | 国网浙江省电力公司温州供电公司 | Auxiliary material management system |
| CN105701617A (en) * | 2016-01-14 | 2016-06-22 | 国网山东省电力公司物资公司 | Overall process information management and control visualization method based on electric power material supply chain and system thereof |
| CN106529869A (en) * | 2016-10-27 | 2017-03-22 | 国网天津市电力公司 | Material inventory item dynamic characteristic analysis platform and analysis method thereof |
| CN106940842A (en) * | 2017-03-23 | 2017-07-11 | 云南电网有限责任公司昆明供电局 | A kind of electric power enterprise material supply monitoring method and system |
| CN109884965A (en) * | 2019-03-06 | 2019-06-14 | 扬州大学 | Physiological driver's parameter monitoring and safe early warning cloud control system based on Internet of Things |
| CN111612425A (en) * | 2020-05-22 | 2020-09-01 | 国网福建省电力有限公司 | Material distribution system |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113011819A (en) * | 2021-03-22 | 2021-06-22 | 北京金山云网络技术有限公司 | Bare metal server management method and device and management server |
| CN113011819B (en) * | 2021-03-22 | 2024-05-03 | 北京金山云网络技术有限公司 | Management method and device of bare metal server and management server |
| CN113254546A (en) * | 2021-05-24 | 2021-08-13 | 北京无线电测量研究所 | Supply chain management and control system and method and electronic equipment |
| CN114202140A (en) * | 2021-06-16 | 2022-03-18 | 中国电建集团华东勘测设计研究院有限公司 | Map display-based informatization flood prevention material management method |
| CN113592309A (en) * | 2021-08-02 | 2021-11-02 | 上海华能电子商务有限公司 | Multi-level inventory quota making method based on data driving |
| CN113592309B (en) * | 2021-08-02 | 2024-04-30 | 上海华能电子商务有限公司 | Multilevel inventory quota formulation method based on data driving |
| CN113762891A (en) * | 2021-08-26 | 2021-12-07 | 大汉电子商务有限公司 | Steel storage management method and system based on region space |
| CN116029671A (en) * | 2023-01-04 | 2023-04-28 | 国家电网有限公司华东分部 | Power grid project material early warning method and device, storage medium and electronic equipment |
| CN116757606A (en) * | 2023-07-05 | 2023-09-15 | 国网黑龙江省电力有限公司营销服务中心 | Inventory metering asset lean management system based on intelligent Internet of things |
| CN117974013A (en) * | 2024-04-01 | 2024-05-03 | 深圳市崇晸实业有限公司 | Monitoring method and system for e-commerce warehouse inventory management |
| CN117993738A (en) * | 2024-04-03 | 2024-05-07 | 深圳美云集网络科技有限责任公司 | E-business operation early warning method and system for multiple scenes |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112488612A (en) | Visualization-based full inventory resource monitoring and displaying method | |
| CN107831750B (en) | IMES intelligent manufacturing execution system | |
| Tang et al. | Consumer perceptions to support IoT based smart parcel locker logistics in China | |
| CN110766528A (en) | Client credit self-evaluation factory real-time intelligent analysis management system | |
| CN109636135B (en) | Sharing-based digital supply chain management system | |
| CN111210108B (en) | Performance management and control model of electric power material supply chain | |
| CN110334950B (en) | Iron tower intelligent production and group management and control system | |
| CN101256647A (en) | Item management system being suitable for garden engineering | |
| CN103679322A (en) | Production data processing method, device thereof, and system thereof | |
| CN108549565A (en) | A kind of visualization sale management system and method | |
| CN111081361A (en) | Intelligent logistics platform management system | |
| CN112732823B (en) | Method for realizing enterprise material supply whole-process monitoring system | |
| CN103390218A (en) | Three-chain coupling integrated emergency security system and method for emergencies | |
| CN109840737A (en) | A kind of mine materials management system | |
| Avvaru et al. | Integration of PLM, MES and ERP systems to optimize the engineering, production and business | |
| CN115170090A (en) | Project management method and device, electronic equipment and readable storage medium | |
| CN112990886B (en) | Aviation industry data management display system based on mobile phone terminal | |
| CN111080262A (en) | Intelligent logistics platform management method | |
| CN110827172A (en) | Wisdom water affairs cloud service platform | |
| CN116739208A (en) | Unified management system for power supply service | |
| CN115660546A (en) | Electric power measurement asset warehousing management method and system | |
| CN115660567A (en) | GIS-based intelligent engineering management system and method | |
| CN112396349A (en) | Data quality monitoring method based on business entity | |
| CN112650508A (en) | Intelligent MES platform software operation method | |
| CN111582777A (en) | Material purchasing and warehousing informatization management system |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210312 |
|
| RJ01 | Rejection of invention patent application after publication |