Lean man-hour management method and device and storage medium

Abstract

The invention discloses a lean man-hour management method. The method comprises the following steps: acquiring man-hour original data; performing ETL processing on the original man-hour data to obtain man-hour data; storing the man-hour data into a rear-end database; wherein the back-end database is a one-master multi-standby database; and performing multi-dimensional analysis processing on the man-hour data to output a data result. In addition, the invention also provides a lean man-hour management device and a storage medium. According to the lean man-hour management method and device and the storage medium provided by the invention, the acquisition of the original man-hour data is realized by breaking through each data island, the ETL data processing is carried out to obtain the man-hour data, and the man-hour data is subjected to one-master multi-standby distributed database storage and multi-dimensional analysis processing, so that the real-time display efficiency of the man-hour is improved; man-hour errors are adjusted in time to improve man-hour processing efficiency, abnormal cost accounting errors are reduced, manual statistics time consumption is reduced, large statistics errors are avoided, real-time presentation of dynamic efficiency of a production line is achieved, and production efficiency is improved.

Description

technical field [0001] The present invention relates to the technical field of lean man-hour management, in particular to a lean man-hour management method, device and storage medium. Background technique [0002] In manufacturing enterprises, because the financial department uses financial software, the business department uses ERP software, and the production department uses the Andon system, the systems of each department are different and independent of each other, making it impossible for the data of each system to be connected, resulting in data islands, so that based on The cost of data communication is high, relying on text and manual reports, and the cost of labor management is high. Especially in the aspect of working hours management, the statistics of working hours are inaccurate and opaque, making it difficult for enterprises to manage working hours and resulting in high management costs. Therefore, there are at least the following problems in the existing work...

AI Technical Summary

Problems solved by technology

[0003] 1. There are many manual work orders, which are miscellaneous, error-prone, and difficult to proofread;

[0004] 2. Manual statistics take a long time, the statistical difference error is large, and the statistical results are inaccurate;

[0005] 3. If the work order is abnormal, the manual report is not timely, and repeated checks are inefficient, so it can only be corrected by making up the number;

[0006] 4. The dynamic efficiency of the production line cannot be displayed in real time, resulting in loss of efficiency

Images