CN113885447B - Real-time process cost accounting equipment suitable for ceramic building industry - Google Patents
Real-time process cost accounting equipment suitable for ceramic building industry Download PDFInfo
- Publication number
- CN113885447B CN113885447B CN202111026304.1A CN202111026304A CN113885447B CN 113885447 B CN113885447 B CN 113885447B CN 202111026304 A CN202111026304 A CN 202111026304A CN 113885447 B CN113885447 B CN 113885447B
- Authority
- CN
- China
- Prior art keywords
- data
- unit
- accounting
- real
- cost
- 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
- 238000000034 method Methods 0.000 title claims abstract description 65
- 239000000919 ceramic Substances 0.000 title claims abstract description 31
- 238000004519 manufacturing process Methods 0.000 claims abstract description 73
- 238000012423 maintenance Methods 0.000 claims abstract description 34
- 238000012545 processing Methods 0.000 claims abstract description 22
- 238000012544 monitoring process Methods 0.000 claims abstract description 19
- 238000013479 data entry Methods 0.000 claims description 8
- 230000005611 electricity Effects 0.000 description 41
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 32
- 239000002002 slurry Substances 0.000 description 27
- 239000000843 powder Substances 0.000 description 20
- 239000000463 material Substances 0.000 description 19
- 239000003245 coal Substances 0.000 description 18
- 239000000126 substance Substances 0.000 description 17
- 239000011449 brick Substances 0.000 description 12
- VNWKTOKETHGBQD-UHFFFAOYSA-N methane Chemical compound C VNWKTOKETHGBQD-UHFFFAOYSA-N 0.000 description 10
- 235000015895 biscuits Nutrition 0.000 description 9
- 239000002994 raw material Substances 0.000 description 6
- 238000011144 upstream manufacturing Methods 0.000 description 6
- 239000008186 active pharmaceutical agent Substances 0.000 description 5
- 239000003345 natural gas Substances 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000000227 grinding Methods 0.000 description 3
- 206010063385 Intellectualisation Diseases 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 2
- -1 ball milling Substances 0.000 description 2
- 239000003250 coal slurry Substances 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000001035 drying Methods 0.000 description 2
- 238000010304 firing Methods 0.000 description 2
- 238000004806 packaging method and process Methods 0.000 description 2
- 238000005498 polishing Methods 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000000498 ball milling Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000009960 carding Methods 0.000 description 1
- 239000002817 coal dust Substances 0.000 description 1
- 238000000748 compression moulding Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000007599 discharging Methods 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 239000012770 industrial material Substances 0.000 description 1
- 238000007641 inkjet printing Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000007781 pre-processing Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000005245 sintering Methods 0.000 description 1
- 238000005507 spraying Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- 238000005303 weighing Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/418—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM]
- G05B19/41875—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM] characterised by quality surveillance of production
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B2219/00—Program-control systems
- G05B2219/30—Nc systems
- G05B2219/32—Operator till task planning
- G05B2219/32368—Quality control
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Manufacturing & Machinery (AREA)
- Quality & Reliability (AREA)
- Automation & Control Theory (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a real-time process cost accounting device suitable for the ceramic building industry, which comprises: the system comprises an acquisition module, a collector and a data acquisition unit, wherein the acquisition module and/or the collector and the data acquisition unit are used for storing production amount data of each working procedure on site; the data input maintenance unit acquires a maintenance table and stores labor cost data; the data processing unit is connected with the data input maintenance unit and the data acquisition unit, screens data and generates a data temporary table; the data accounting unit is connected with the data processing unit and is used for carrying out real-time operation based on the model, the data temporary table and the maintenance table to obtain an accounting result; and the data display unit is connected with the data accounting unit and displays the accounting result for the user. Therefore, the method is suitable for real-time process cost accounting equipment in the ceramic building industry, and real-time monitoring and accounting of the cost required by each process are realized.
Description
Technical Field
The invention relates to the field of ceramic building, in particular to real-time process cost accounting equipment suitable for the ceramic building industry.
Background
The existing cost accounting method in the ceramic building industry in China mainly takes the actual cost of a product as a center, namely the actual cost of the product is calculated by firstly collecting the occurrence amount of materials, labor and fees according to a certain period, then distributing the occurrence amount according to a certain standard. The method is used for checking whether the cost accords with the plan or not, and cannot control the cost in real time, and cannot provide various cost data required by enterprises for making business decisions.
In addition, the cost calculation involves all the procedures, raw materials, equipment and other contents, the calculation amount is quite complex, and more time and manpower resources are occupied. Therefore, the ceramic building industry has an urgent need for a device capable of realizing real-time accounting and monitoring of costs.
Disclosure of Invention
Problems to be solved by the invention:
Aiming at the problem that the current ceramic building industry is difficult to control the cost, the invention provides the real-time process cost accounting equipment suitable for the ceramic building industry, which can realize real-time monitoring and accounting of the cost required by each process, can feed back the cost service condition of a user at a glance, and can automatically prompt the problem in the cost service condition of the user, thereby combining the production links of gradual automation, intellectualization and data due to transformation and upgrading to intelligent manufacturing in the ceramic building industry in recent years, playing the production management advantage brought by the equipment, and standardizing, specializing and intellectualization of production management.
Technical means for solving the problems:
The invention provides real-time process cost accounting equipment suitable for the ceramic building industry, which is characterized by comprising the following components:
A collection module provided in a control system of each process and/or a collector mounted in an automation device of each process;
The data acquisition unit is connected with the acquisition module and/or the acquisition device and stores the production amount data of each process in the field acquired by the acquisition module and/or the acquisition device into an original database;
the data input maintenance unit is used for acquiring a manually input maintenance table recorded with the corresponding price of the unit consumption data on one hand and storing the manually input labor cost data into the original database on the other hand;
The data processing unit is connected with the data input maintenance unit and the data acquisition unit, screens out production amount data and labor cost data related to the cost from the original database, and generates a data temporary table based on the screened data;
the data accounting unit is connected with the data processing unit, establishes a model, and performs real-time operation on the basis of the data in the model, the data temporary table and the maintenance table to obtain a real-time required accounting result; and
And the data display unit is connected with the data accounting unit and displays the accounting result to the user.
According to the invention, the data processing unit screens and preprocesses the production amount data of each procedure acquired by the data acquisition unit and the labor cost data acquired by the data input maintenance unit, and the data calculation unit calculates the cost calculation result in real time based on the model and the screened and preprocessed data and displays the cost calculation result by the data display unit, so that the real-time calculation of the cost required by each procedure can be realized, and the cost control is convenient.
The system also comprises a data early warning unit which is connected with the data processing unit and judges whether the data temporary table has cost related data of acquisition failure or not, if yes, early warning is sent to a user, and if no, early warning is not sent.
The system also comprises a monitoring alarm unit which is connected with the data accounting unit and the data display unit, monitors the real-time accounting result, compares the accounting result with a corresponding standard result range in real time, and alarms when the accounting result does not fall into the corresponding standard result range.
Therefore, the invention also monitors the collected and acquired data and the accounting result in real time through the data early warning unit and the monitoring alarm unit, ensures the correctness of the accounting result, carries out preliminary judgment on the correct accounting result on the basis, prompts the accounting result which does not fall into the corresponding standard result range to the user, and is convenient for the user to carry out cost control in time according to the real-time cost accounting condition.
The monitoring alarm unit may also be connected to the data display unit to highlight the accounting results that do not fall within the standard result range. Therefore, the user can directly observe which accounting result does not fall into the corresponding standard result range, and can transversely compare the accounting result with the accounting results of other procedures.
The cost accounting device also comprises a cost display platform connected with the data display unit through an interface, wherein the cost display platform comprises a webpage end, a mobile phone end and/or a central control large screen. Therefore, the user can acquire the accounting result more conveniently, and the accounting result can be displayed at a plurality of places at the same time, namely, the real-time accounting result can be shared by a plurality of people, so that the coordination among departments in the ceramic building industry is facilitated.
The data input maintenance unit may be connected to a production process execution management system for managing each process, and store the labor cost data manually input to the production process execution management system into the original database. Thus, the user does not have to repeatedly enter data in order to account for costs.
Drawings
FIG. 1 is a schematic diagram of a real-time process cost accounting apparatus suitable for use in the ceramic building industry;
FIG. 2 is a block diagram of a real-time process cost accounting apparatus suitable for use in the ceramic building industry of the present invention;
FIG. 3 is a cost-effective schematic of the ceramic building industry according to a process;
Reference numerals illustrate:
100-cost accounting equipment; 11-a data acquisition unit; 111-a data acquisition device; 12-a data entry maintenance unit; 121-MES system; 21-a data processing unit; 22-a data early warning unit; 31-a data accounting unit; 32-a monitoring alarm unit; 41-a data presentation unit; 42-cost display platform.
Detailed Description
The invention will be further described with reference to the accompanying drawings and the following embodiments, it being understood that the drawings and the following embodiments are only for illustrating the invention, not for limiting the invention.
In the ceramic building industry, the ceramic tile production process flow is as follows: weighing raw materials, QC (detection) of raw materials, crushing raw materials, ball milling, powder preparation, compression molding, drying in a drying kiln, glaze spraying, ink-jet printing, kiln firing, polishing, quality inspection and classification, packaging, warehousing and discharging. The process cost accounting device according to the present invention is based on this, but it should be noted that the process flow may be increased or decreased or changed correspondingly without departing from the scope of the present invention.
Fig. 3 is a schematic diagram of cost generation in the ceramic building industry according to the process, and referring to fig. 3, as can be seen from the above production process, the production plant involved is: crushing workshop, raw material workshop, coal water slurry workshop, powder making workshop, glaze workshop, forming workshop, sintering workshop and polishing workshop. Classified by the production process of each plant, the total costs involved include: crushing cost, slurry cost, coal water slurry cost, powder cost, glaze cost, biscuit cost, green brick cost and finished product cost. Wherein, the cost of each link is looped, and the material cost of the previous link is collected into the next link.
Fig. 1 is a schematic view of a real-time process cost accounting apparatus 100 suitable for use in the ceramic building industry of the present invention, and fig. 2 is a block diagram of the cost accounting apparatus 100. The structure of the cost accounting apparatus of the present invention will be described below.
As shown in fig. 1, the cost accounting apparatus 100 of the present invention includes: for example, the data acquisition device 111 provided in an acquisition module of a control system of each process and/or an acquisition device mounted on an automation apparatus of each process, the data acquisition device 11 connected to the data acquisition device 111 through an interface, the data entry maintenance unit 12 connected to an MES system 121 (i.e., a production process execution management system) managing each process, the data processing unit 21 connected to the data entry maintenance unit 12 and the data acquisition unit 11, the data early warning unit 22 connected to the data processing unit 21, the data accounting unit 31 connected to the data processing unit 21, the data display unit 41 connected to the data accounting unit 31, the cost display platform 42 connected to the data display unit 41 through an API interface, and the monitoring alarm unit 32 connected to both the data accounting unit 31 and the data display unit 41. The "connection" in the present invention may be a connection via a data communication cable or a wireless communication connection, as long as the connection is capable of data transmission.
As shown in fig. 2, the structure of the cost accounting apparatus 100 is further described below by way of a specific example. The data collection device 111 employs a data collector, and a plurality of different kinds of data collectors are electrically connected to the automation equipment of each process through the com port, that is, to the production line of each process, and collect production data of each workshop. All the data collectors are electrically connected with a data pushing controller, access data in real time through an upper computer and a lower computer, and transmit the data to a designated controller, and the data pushing controller is electrically connected with a data warehouse cluster for storing the data, so that production data of workshops where the data collectors are located are pushed to the data warehouse cluster and stored. The data processing unit 21 includes a data processor and an SSIS (Microsoft SQL SERVER Integration Services) platform electrically connected to the data processor, and the SSIS platform is electrically connected to the aforementioned data warehouse cluster storing production data of each plant, so as to extract data from the data warehouse cluster at regular intervals and transmit the data to the data processor for processing. The data processor is in turn electrically connected to a data pre-warning device, which is an example of the data pre-warning unit 22 described above. The data calculation unit 31 includes a data calculation operator electrically connected to the data processor, and a formula memory electrically connected to the data calculation operator, and obtains data necessary for calculation from the data processor, obtains a formula from the formula memory, and performs calculation. The data display unit 41 includes a real-time data chart generation operator connected to the data calculation operator, and performs calculation based on data obtained by the calculation performed by the data calculation operator, thereby obtaining data necessary for generating a chart. The real-time data chart generation operator is also electrically connected to a data anomaly alarm device, which is an example of the aforementioned monitoring alarm unit 32.
As another specific example, the data acquisition device 111 employs a control system of an automation device, and the control system may be directly electrically connected to the SSIS platform, so that data in the database is periodically extracted through the SSIS platform.
The upstream port of the data acquisition unit is connected with the acquisition module of the control system arranged in each process and/or the data output end of the acquisition unit arranged in the automation equipment of each process through a com interface, so that the production amount data of each process on site acquired by the acquisition module and/or the acquisition unit is acquired, and is stored into an original database, and the input end of the original database is connected with the downstream port of the data acquisition unit. When an automated control system is used to control the implementation of a process, production volume data for the process can be obtained directly by the control system. In addition, for example, in the case where the process is controlled without using a control system, various types of sensors may be used as collectors mounted to the automation equipment of each process to acquire the production amount data of the process. In the ceramic building industry, the production amount data which can be obtained by the data acquisition unit comprises: crushing data (raw blank amount, etc.), slurry data (blank amount, slurry yield, etc.), coal water slurry data (coal powder amount, coal water slurry yield, etc.), powder data (slurry amount, coal water slurry yield, etc.), glaze data (glaze yield, etc.), biscuit data (powder amount, biscuit yield, etc.), tile data (biscuit amount, glaze amount, tile yield, etc.), product data (tile amount, product yield, etc.).
The upstream port of the data entry maintenance unit is connected to an MES system for performing management of a production process, the labor cost data is manually entered into the MES system in the process of performing management of the production process, the data entry maintenance unit obtains the labor cost data from the MES system through the port of the data entry maintenance unit, the labor cost data are stored in an original database, and the input end of the original database is connected with the downstream port of the data entry maintenance unit. The data input maintenance unit is connected with the data acquisition unit, so that the data input maintenance unit and the data acquisition unit form a parallel structure. The labor cost data includes: water usage, electricity usage, labor wages, fixed asset depreciation, hardware usage, office supplies usage, other costs, and the like. In addition, the data input maintenance unit is also used for acquiring manually input maintenance tables, including an energy price maintenance table, a powder and slurry corresponding table, a mechanical equipment association table, a prediction maintenance table, a ball glaze time maintenance table and a firing unit maintenance table, wherein price costs corresponding to unit usage of various items are recorded in the tables.
The upstream port of the data processing unit is connected to the output end of the original database through the SSIS platform, and is connected with the data acquisition unit and the data input maintenance unit through the original database. The data processing unit acquires all data in an original database, screens out production amount data and labor cost data related to cost, and generates a data temporary table after preprocessing based on the screened data. The pretreatment refers to the process of integrating and/or carding the screened data. Since the data obtained directly from the control system and the MES system of each process generally contains a large amount of data related to cost in addition to the above-described required production amount data and labor cost data, it is necessary to screen out the above-described production amount data and labor cost data related to cost according to the cost accounting requirement by the data processing unit.
The data early warning unit is connected to the output end of the data temporary table in the data processing unit through a standard API interface, acquires the data in the data temporary table, judges whether the data temporary table has cost related data with acquisition failure, if so, sends early warning to a user, and if not, does not send early warning. Because the cost data of each node on the site is obtained by carrying out real-time data acquisition on the site equipment, when the data acquisition fails, the abnormal condition of a certain production equipment can be caused, and thus, a user can be informed of the abnormality of the equipment in time. In addition, when the collector is used, the production amount data of each process on site is collected in real time by various sensors installed on the automation equipment of each process, and when the collector fails and the data acquisition fails, the final cost accounting result is far away from the actual cost, and the grasping of the cost by a user is seriously influenced. Therefore, the data early warning unit can monitor whether the current production equipment has abnormal conditions in real time on one hand, and can ensure that the acquired data is true and correct on the other hand.
The upstream port of the data accounting unit is connected to the downstream port of the data processing unit through a standard API interface, and the generated data temporary table is obtained. The data accounting unit builds a model, and makes the data accounting unit perform real-time operation based on the built model, the data temporary table and the data in the maintenance table to obtain a real-time required accounting result. The monitoring alarm unit is used for monitoring the real-time accounting result obtained by the data accounting unit, comparing the accounting result with the preset corresponding standard result range in real time, and alarming when the accounting result does not fall into the corresponding standard result range. In the ceramic building industry, cost models according to each process can be established, and each model corresponds to a plurality of project amounts. With reference to fig. 2, a real-time cost model in hours for each process will be described.
(1) Crushing cost = original stock spent + electricity spent + wage spent + depreciated spent + other spent;
wherein ① raw blank consumption = raw blank usage of each type x raw blank weighted average price;
② Electricity consumption amount = electricity consumption amount x unit electricity price;
③ Payroll amount = payroll amount per hour x real-time production hours;
④ Depreciated amount = depreciated amount per hour x real-time production hours;
⑤ Other drain = other apportionments per hour x real-time production hours;
(2) Slurry cost = stock spent amount + chemical material spent amount + electricity spent amount + water spent amount + wage spent amount + depreciated spent amount + other spent amounts;
Wherein ① blank consumption = blank usage of various types x blank weighted average price;
② Chemical material consumption amount = unit chemical formula amount x real-time slurry yield;
③ Electricity consumption amount = raw material workshop electricity consumption amount x unit electricity price;
④ Water usage amount = predicted unit water amount x unit water price;
⑤ Payroll amount = payroll amount per hour x real-time production hour
⑥ Depreciated amount = depreciated amount per hour x real-time production hours;
⑦ Other drain = other apportionments per hour x real-time production hours;
(3) Coal water slurry cost = coal dust consumption amount + chemical material consumption amount + electricity consumption amount + water consumption amount + wage consumption amount + depreciation consumption amount + other consumption amounts;
Wherein ① coal powder consumption amount = coal powder consumption amount x coal powder weighted average price;
② Chemical material consumption amount = unit chemical formula amount x real-time coal water slurry yield;
③ Electricity consumption amount = electricity consumption amount x unit electricity price;
④ Water consumption amount = prediction unit water consumption x real-time water coal slurry yield;
⑤ Payroll amount = payroll amount per hour x real-time production hours;
⑥ Depreciated amount = depreciated amount per hour x real-time production hours;
⑦ Other drain = other apportionments per hour x real-time production hours;
(4) Powder cost = slurry consumption + water coal consumption + electricity consumption + wage consumption + depreciation consumption + hardware consumption + office supplies consumption + other consumption;
Wherein ① slurry consumption = slurry usage x slurry real-time unit consumption;
② Coal water slurry consumption amount = coal water slurry consumption amount x real-time unit consumption of coal water slurry;
③ Electricity consumption amount = electricity consumption amount x unit electricity price;
④ Payroll amount = payroll amount per hour x real-time production hours;
⑤ Depreciated amount = depreciated amount per hour x real-time production hours;
⑥ Hardware consumption amount = hardware split per hour x real-time production hours;
⑦ Office supplies spent amount = office supplies split per hour x real-time production hours;
⑧ Other drain = other apportionments per hour x real-time production hours;
(5) Glaze cost = chemical material consumption amount + electricity consumption amount + water consumption amount + wage consumption amount + depreciated consumption amount + hardware consumption amount + office supplies consumption amount + other consumption amounts;
Wherein ① chemical consumption = unit glaze formulation amount x real-time glaze yield x (1-moisture content);
② Electricity consumption amount = electricity consumption amount x unit electricity price;
③ Water consumption amount = unit water consumption x real-time glaze yield;
④ Payroll amount = payroll amount per hour x real-time production hours;
⑤ Depreciated amount = depreciated amount per hour x real-time production hours;
⑥ Hardware consumption amount = hardware split per hour x real-time production hours;
⑦ Office supplies spent amount = office supplies split per hour x real-time production hours;
⑧ Other drain = other apportionments per hour x real-time production hours;
(6) Biscuit cost = powder consumption amount + chemical consumption amount + electricity consumption amount + wage consumption amount + depreciated consumption amount + hardware consumption amount + mould consumption amount + office supplies consumption amount + other consumption amounts;
Wherein ① powder consumption amount = powder consumption amount x real-time unit consumption of powder;
② Chemical material consumption amount = unit chemical formula amount x powder consumption amount;
③ Electricity consumption amount = electricity consumption amount x unit electricity price;
④ Payroll amount = payroll amount per hour x real-time production hours;
⑤ Depreciated amount = depreciated amount per hour x real-time production hours;
⑥ Hardware consumption amount = hardware split per hour x real-time production hours;
⑦ Die consumption = prediction unit die consumption x real-time green brick yield;
⑧ Office supplies spent amount = office supplies split per hour x real-time production hours;
⑨ Other drain = other apportionments per hour x real-time production hours;
(7) Green brick cost = biscuit, chemical, glaze, natural gas, power, wage, depreciation, hardware, die, office, and other costs;
Wherein ① green brick consumption amount = real-time green brick consumption amount x green brick real-time unit consumption;
② Chemical consumption amount = chemical consumption amount x one-time weighted average price;
③ Glaze consumption amount = glaze consumption amount x real-time unit consumption of glaze;
④ Natural gas consumption = natural gas usage x natural gas price per unit;
⑤ Electricity consumption amount = electricity consumption amount x unit electricity price;
⑥ Payroll amount = payroll amount per hour x real-time production hours;
⑦ Depreciated amount = depreciated amount per hour x real-time production hours;
⑧ Hardware consumption amount = hardware split per hour x real-time production hours;
⑨ Die consumption = prediction unit die consumption x real-time green brick usage;
⑩ Office supplies spent amount = office supplies split per hour x real-time production hours;
⑪ Other drain = other apportionments per hour x real-time production hours;
(8) Product cost = green brick consumption + package consumption + electricity consumption + water consumption + wage consumption + depreciated consumption + hardware consumption + grinding tool consumption + office supplies consumption + other consumption;
wherein ① green brick consumption = finished product consumption x green brick unit consumption;
② Package consumption amount = unit package material amount x finished product amount x (1-defective rate-popular rate);
③ Electricity consumption amount = electricity consumption amount x unit electricity price;
④ Water consumption amount = predicted unit water consumption x finished product usage;
⑤ Payroll amount = payroll amount per hour x real-time production hours;
⑥ Depreciated amount = depreciated amount per hour x real-time production hours;
⑦ Hardware consumption amount = hardware split per hour x real-time production hours;
⑧ Grinding tool consumption amount = BOM table of unit price x finished product consumption;
⑨ Office supplies spent amount = office supplies split per hour x real-time production hours;
⑩ Other drain = other apportionments per hour x real-time production hours.
In addition, the data accounting unit can further establish a cost month knot model taking month as a unit, so that the cost accounting situation is summarized integrally for a user to grasp. A description will be given below of a cost month knot model in month for each process in the ceramic building industry with reference to fig. 2.
(1) Crushing accounting month knot= (original blank consumption amount of the month, electricity consumption amount of the month, wage consumption amount of the month, depreciation consumption amount of the month, other consumption amount of the month)/crushing blank yield of the month;
(2) Slurry accounting month knot= (this month blank consumption amount + this month chemical material consumption amount + this month electricity consumption amount + this month water consumption amount + this month wage consumption amount + this month depreciation consumption amount + this month other consumption amount)/this month slurry yield;
(3) Accounting month knot of coal water slurry= (coal powder consumption amount of the month + industrial material consumption amount of the month + electricity consumption amount of the month + water consumption amount of the month + payroll consumption amount of the month + depreciated consumption amount of the month + other consumption amount of the month)/month yield;
(4) Powder accounting month knot= (current month slurry consumption amount, current month water-coal slurry consumption amount, current month electricity consumption amount, current month payroll consumption amount, current month depreciation consumption amount, current month hardware consumption amount, current month office supplies consumption amount, current month other consumption amount)/current month yield;
(5) Glaze accounting month knot= (current month chemical material consumption amount, current month electricity consumption amount, current month water consumption amount, current month wage consumption amount, current month depreciation consumption amount, current month hardware consumption amount, current month office supplies consumption amount, current month other consumption amount)/current month yield;
(6) Accounting month knot = (powder consumption amount + power consumption amount + wage consumption amount + depreciation consumption amount + hardware consumption amount + mould consumption amount + office supplies consumption amount + other consumption amount)/month biscuit yield;
(7) Green brick accounting month knot= (the current month biscuit consumption amount, the current month chemical material consumption amount, the current month glaze consumption amount, the current month natural gas consumption amount, the current month electricity consumption amount, the current month payroll consumption amount, the current month depreciation consumption amount, the current month hardware consumption amount, the current month die consumption amount, the current month office material consumption amount, the current month other consumption amount)/the current month yield;
(8) Accounting month knot of finished products= (the green brick consumption amount of the present month, the packaging consumption amount of the present month, the electricity consumption amount of the present month, the water consumption amount of the present month, the payroll consumption amount of the present month, the depreciated consumption amount of the present month, the hardware consumption amount of the present month, the grinding tool consumption amount of the present month, the office supplies consumption amount of the present month, the other consumption amount of the present month)/the yield of the present month.
In addition, the data accounting unit can also model according to different materials, and each process material comprises: blank, slurry, coal water slurry, powder, glaze, biscuit, adobe and finished product. In this embodiment, the different materials may be distinguished by numbering, and the numbering may be set and recorded by itself, or may be directly obtained from the control system of the corresponding process. The electricity consumption amount, the wage consumption amount, the depreciated consumption amount and other consumption amounts are distributed to the cost of different materials in real time through time. Taking blanks as an example, setting blank codes for the crushed blanks according to a crushing formula list according to a report form of entering and exiting from a crushing workshop. The time-apportioned consumption categories, if a production outage occurs, apportion the current time consumption into the current lot/formula as long as the production change has not passed. The month model according to different materials is based on a real-time model, the actual occurrence quantity and the amount of the month are substituted for the original prediction model, and the allocation proportion can be referred to the real-time model. The model according to the other materials is similar to the model according to the process described above, and thus will not be described in detail.
The upstream port of the data display unit is connected to the downstream port of the data calculation unit through a standard API interface, and the calculation result is obtained in real time and sent to the cost display platform for displaying to the user, and the cost display platform is connected to the downstream port of the data display unit through the standard API interface. The cost display platform comprises, but is not limited to, a webpage end, a mobile phone end, a central control large screen and the like, and the accounting results can be displayed on one of the cost display platforms and can be displayed on a plurality of cost display platforms at the same time, namely, the real-time accounting results can be shared by a plurality of people, and the coordination among departments in the ceramic building industry is facilitated.
It should be noted that the connection relation or connection manner described in the "detailed description" of the present specification is merely provided as an example, and the present invention is not limited to such connection relation or connection manner.
The monitoring alarm unit for monitoring real-time accounting results is connected with the downstream port of the data accounting unit and the upstream port of the data display unit. Taking the crushing cost of the real-time calculation as an example, comparing the real-time calculation result of the crushing cost with the corresponding standard result range set in advance, when the calculation result does not fall into the corresponding standard result range, the monitoring alarm unit generates alarm information, and the data display unit for acquiring the alarm information alarms in a form of highlighting the calculation result of the crushing cost displayed by the cost display platform, for example, the calculation result of the crushing cost can be marked as red, a user can conveniently observe which calculation result does not fall into the corresponding standard result range directly, and the calculation result can be compared with the calculation result among other procedures in a transverse mode conveniently. In addition, the monitoring and alarming unit also compares the original blank consumption amount, the electricity consumption amount, the wage consumption amount, the depreciated consumption amount and other consumption amounts related to the crushing cost with corresponding project amounts respectively when the past meets the cost plan (namely, the consumption amounts fall into the corresponding standard result range), calculates the variation condition of each project amount, and displays the variation condition by the data display unit and the cost display platform, thereby facilitating the user to quickly find out the problem.
According to the invention, the data processing unit screens the production amount data of each process acquired by the data acquisition unit and the labor cost data acquired by the data input maintenance unit, and the data calculation unit calculates the cost calculation result in real time based on the model and the screened data and displays the cost calculation result by the data display unit, so that the real-time calculation of the cost required by each process can be realized, and the cost control is convenient to carry out. And the invention also monitors the collected and acquired data and the accounting results in real time through the data early warning unit and the monitoring alarm unit, ensures the correctness of the accounting results, and on the basis, carries out preliminary judgment on the correct accounting results, prompts the accounting results which do not fall into the corresponding standard result range to the user, and is convenient for the user to timely control the cost according to the real-time cost accounting condition.
The present invention may be embodied in several forms without departing from the spirit of the essential characteristics thereof, and the embodiments of the invention are therefore intended to be illustrative and not restrictive, since the scope of the invention is defined by the claims rather than by the description, and all changes that come within the meaning and range of equivalency of the claims, or range of equivalents thereof, are therefore intended to be embraced therein.
Claims (6)
1. Real-time process cost accounting equipment suitable for building ceramic trade, characterized by that includes:
A collection module provided in a control system of each process and/or a collector mounted in an automation device of each process;
The data acquisition unit is connected with the acquisition module and/or the acquisition device and stores the production amount data of each process in the field acquired by the acquisition module and/or the acquisition device into an original database;
the data input maintenance unit is used for acquiring a manually input maintenance table recorded with the corresponding price of the unit consumption data on one hand and storing the manually input labor cost data into the original database on the other hand;
The data processing unit is connected with the data input maintenance unit and the data acquisition unit, screens out production amount data and labor cost data related to the cost from the original database, and generates a data temporary table based on the screened data;
The data accounting unit is connected with the data processing unit, builds a model, carries out real-time operation on the basis of the data in the model, the data temporary table and the maintenance table to obtain real-time required accounting results, wherein the model is built for each link of ceramic production according to accounting requirements, and the data processing unit screens the data in the data input maintenance unit and the data acquisition unit on the basis of the requirements of the model, so that the data temporary table is generated; and
And the data display unit is connected with the data accounting unit and displays the accounting result to the user.
2. The real-time process cost accounting device suitable for the ceramic building industry according to claim 1, further comprising a data early warning unit connected with the data processing unit and judging whether the data temporary table has cost related data of acquisition failure, if so, early warning is sent to a user, and if not, early warning is not sent.
3. The real-time process cost accounting device suitable for the ceramic building industry according to claim 1, further comprising a monitoring alarm unit connected with the data accounting unit and the data display unit, monitoring the real-time accounting result, comparing the accounting result with a corresponding standard result range in real time, and alarming when the accounting result does not fall within the corresponding standard result range.
4. A real time process cost accounting device adapted for use in the ceramic building industry as claimed in claim 3, wherein the monitoring alarm unit is further connected to the data presentation unit to alarm in the form of highlighting the accounting results which do not fall within the corresponding standard result range.
5. The real-time process cost accounting device suitable for the ceramic building industry according to claim 1, further comprising a cost display platform connected with the data display unit through an interface, wherein the cost display platform comprises a webpage end, a mobile phone end and/or a central control large screen.
6. The real-time process cost accounting device suitable for ceramic building industry according to claim 1, wherein the data entry maintenance unit is connected with a production process execution management system for managing each process, and stores labor cost data manually entered in the production process execution management system into the original database.
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2021200019412 | 2021-01-04 | ||
| CN202120001941 | 2021-01-04 |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113885447A CN113885447A (en) | 2022-01-04 |
| CN113885447B true CN113885447B (en) | 2024-05-17 |
Family
ID=79012127
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111026304.1A Active CN113885447B (en) | 2021-01-04 | 2021-09-02 | Real-time process cost accounting equipment suitable for ceramic building industry |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113885447B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116578547A (en) * | 2023-05-16 | 2023-08-11 | 佛山众陶联供应链服务有限公司 | Several-bin modeling method and system for ceramic production line |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103942652A (en) * | 2014-04-28 | 2014-07-23 | 漳州片仔癀药业股份有限公司 | Medicine product production cost self-learning smart checking system |
| CN106920068A (en) * | 2017-01-19 | 2017-07-04 | 国家电网公司 | Electricity power engineering pricing management of the one kind based on big data and " internet+" |
| CN107480890A (en) * | 2017-08-17 | 2017-12-15 | 上海精智实业股份有限公司 | A kind of Cost accounting method, device, equipment and storage medium |
| CN109087150A (en) * | 2018-08-18 | 2018-12-25 | 深圳市江益达科技股份有限公司 | Cost intelligent analysis method and device |
| CN109961216A (en) * | 2019-02-26 | 2019-07-02 | 浙江大学 | A kind of total factor Cost Accounting System and method towards intelligence manufacture |
-
2021
- 2021-09-02 CN CN202111026304.1A patent/CN113885447B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103942652A (en) * | 2014-04-28 | 2014-07-23 | 漳州片仔癀药业股份有限公司 | Medicine product production cost self-learning smart checking system |
| CN106920068A (en) * | 2017-01-19 | 2017-07-04 | 国家电网公司 | Electricity power engineering pricing management of the one kind based on big data and " internet+" |
| CN107480890A (en) * | 2017-08-17 | 2017-12-15 | 上海精智实业股份有限公司 | A kind of Cost accounting method, device, equipment and storage medium |
| CN109087150A (en) * | 2018-08-18 | 2018-12-25 | 深圳市江益达科技股份有限公司 | Cost intelligent analysis method and device |
| CN109961216A (en) * | 2019-02-26 | 2019-07-02 | 浙江大学 | A kind of total factor Cost Accounting System and method towards intelligence manufacture |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113885447A (en) | 2022-01-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108320069B (en) | Production and manufacturing execution system | |
| CN111722603A (en) | Management and control system and management and control method for production workshop | |
| CN102867237A (en) | Intelligent production management method | |
| CN105867337B (en) | A kind of management system and its method of backlight module automatic production line | |
| CN111813057A (en) | Energy management system of cement production plant | |
| CN111650901A (en) | Intelligent unattended factory system for cement production line | |
| CN212083982U (en) | Management and control system for production workshop | |
| CN108627520A (en) | A kind of on-line detecting system and method for heterogeneous solid material presentation quality | |
| CN111582839A (en) | Intelligent cement factory management and control system and management and control method | |
| CN113885447B (en) | Real-time process cost accounting equipment suitable for ceramic building industry | |
| CN108319638B (en) | Dangerous goods production and manufacturing execution system applying handheld inspection equipment | |
| CN103017873A (en) | Unattended automatic steel metering system and method | |
| CN115049326A (en) | Production management system and management method | |
| CN105022373A (en) | Port equipment maintenance system based on zigbee technology | |
| CN112446608A (en) | OEE and Andon safety lamp management system and working method thereof | |
| CN110633916A (en) | Energy efficiency control system for coal mine enterprise | |
| CN112598339A (en) | Coal digital detection and inspection system | |
| CN117151624A (en) | Workshop digital integrated management platform based on SCADA system | |
| CN107862485B (en) | Comprehensive management platform of crushing equipment | |
| CN112232843B (en) | Drug supervision system and method based on big data technology | |
| CN111766842A (en) | Tire mixes gluey production energy management system | |
| CN105652847A (en) | Control system for automatically counting quantity and production data of zipper packages | |
| CN112446562A (en) | Commercial intelligent unit management system | |
| CN114433834B (en) | Integrative intelligent control system of sand mixing molding pouring | |
| CN115796436A (en) | Production test data management system based on big data |
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 |