A Study on the Man-Hour Prediction in Structural Steel Fabrication

1. Introduction

The production planning and scheduling of steel structure manufacturing enterprises is an important task, and the processing time of components is an important reference for enterprises to arrange overall production plans and determine production nodes for components. The accuracy of man-hour prediction greatly affects production planning and full process scheduling of enterprises.Taking the longitudinal cutting steel coil processing of steel structure manufacturing enterprises as an example, the man-hour of processing generally includes dozens of process times,such as loading time, tailing time, unloading time, separation plate replacement time, material return time, slitting tailing time, etc. The current workshop scheduling mainly revolves around processing time, and is based on the premise of determined processing time. That is, the same components and processing procedures are processed using the same model of machine, and the processing time remains unchanged.However, in the actual production process, due to the influence of worker proficiency, workshop environment, lighting, and physical parameters of steel in the process flow, the cutting process of steel coils is greatly affected by factors such as raw material specifications,width, and thickness of the workpieces, resulting in an uncontrollable fluctuation in production hours, which leads to a certain deviation between the used processing hours and the actual processing hours. With the continuous progress of production and the accumulation of man-hour deviations, the production plan executed on the production line deviates from the pre-arranged production plan. This estimation of production tasks and operation time based on inaccurate man-hours parameters can lead to significant deviations between plan and actual production, which can easily lead to implementation gaps[1,2].Even through rescheduling and resource rearrangement, it is difficult to compensate for the impact of man-hour deviations. Moreover, rescheduling and resource rearrangement consume a lot of manpower and time, thereby reducing the feasibility of the entire production plan, which makes it difficult for production plans to effectively guide the actual production operations of enterprises.

At present, the prediction of the man-hours is carried out by an expert based on the historical production data in most structural steel fabrication enterprises. The expert uses various factors to predict the man-hours, but such process carries the some problems:

• First of all, and most importantly, the prediction is not objective. A human ultimately carries out the expert prediction, and therefore there is no guarantee of a consistent prediction. Further, there is the concern that factors that are difficult to objectify may lower the accuracy of predictions[3].
• There is a complex relationship between man-hour and these subjective factors, where significant amount of effort and time are required to make predictions.
• It is difficult to share the implicit know-hows of experts over prediction, and these know-hows are also difficult to quantify. Therefore any person other than the applicable expert needs to assign significant prior experience.

Such problems could be overcome by using the man-hour prediction model.In manufacturing production, the man-hour parameter is an important basis for production planning and scheduling[4],and is used to determine the amount of work tasks and the time interval for each task,which is a key parameter in planned production.Some related studies in recent years, such as data-based scheduling models[5] and data-based methods for predicting key parameters[6] have proved that mining relevant information and knowledge from underlying data and applying it to production decisions can reduce uncertainty in decision-making, enable rapid analysis, and reduce the number of erroneous decisions[7]. If the factors that affect man-hours are identified and quantified, and a prediction model is established based on these factors, then a low-cost, objective and efficient prediction can be performed.

The remainder of the article is organized as follows: In section “Related works”, theoretical background related to predict man-hours and applications of Random Forest(RF) in different industries are analyzed.The data used in this study are discussed in “Data descriptions and preprocessing” section,and the method of data preprocessing such as data normalization ,one hot encoding and variable selection is also discussed.The man-hour prediction system suggested in this study is described in section “Models”. Section “Results and discussion” discusses the prediction model and its performance. Finally, in section “Conclusion” provides the significance and the limitations of this study.

2. Related Works

In recent years, thanks to widespread adoption such as big data, artificial intelligence, the Internet of Things,and general information technology infrastructure in manufacturing, scholars have conducted extensive research on the application of these technologies to man-hour prediction.Hur et al.[3] constructed a man-hour prediction system based on multiple linear regression and classification regression tree for the shipbuilding industry, and the results showed that the prediction system has strong reliability. Based on this study, three types of plans have been established in man-hour prediction, they are quarter plan, month plan and day plan respectively.YU et al.[8] conducted a study on the ML-based quantitative prediction of the process’ man-hour during aircraft’s assembly.The study proposed a forecasting model based on Support Vector Machine(SVM), which was optimized by particle swarm optimization.The authors showed that the improved model could effectively predict man-hour of assembly work in a short time while maintaining sufficient accuracy.Mohsenijam et al.[9] proposed a framework for labour-hour prediction in structural steel fabrication.The research explored a data-driven approach which used Multiple Linear Regression (MLR) and available historical data from Building Information Models (BIM) to associate project labour-hours and project design features.IşıkS et al.[10] explored the use of machine-learning techniques such as Support Vector Regression(SVR),Gaussian Process Regression(GPR) and Adaptive Neuro-Fuzzy Inference System(ANFIS) for predicting man-hours in Power Transformer manufacturing. The authors reported that these techniques,especially GPR are useful in the prediction of man-hours in Power Transformer production industry. The results showed that the predictive model based on GPR attained good performance in terms of effectiveness and usability and could be effectively used in an acceptable error range, especially when compared to pure expert forecast.Aiming at a kind of key equipment in the metal machining and weld machining, namely the multi-station and multi-fixture machining center.DONG et al.[11] designed a man-hour calculation system for a motorcar manufacturing company, which was based on .the practical production situation, manual time and parallel time between man and machine.Hu[12] proposed a man-hour prediction model based on optimizing back propagation neural network with genetic algorithm (AG_BP) for the management process of chemical equipment design.The results showed that the model could be a good solution for predicting man-hours required for chemical equipment design and improve the prediction accuracy.

In recent years, there has been a growing interest in using ML algorithms to solve both linear and non linear problem in regression analysis.The RF algorithm,as an ensemble learning algorithm based on CART decision trees, is widely used in classification or regression problems[13,14].Fraiwan et al.[15] proposed an automated sleep stage identification system based on time-frequency analysis of a single EEG channel and a RF classifier. The results demonstrate that the system achieves an accuracy of 83% in classifying the five sleep stages.Yanni Dong[16] proposed an efficient metric learning detector based on RF, which was applied to the classification of HSI data. Experimental results demonstrated that the proposed method outperformed state-of-the-art target detection algorithms and other classical metric learning methods.Berecibar et al.[17] presented a novel machine learning approach for online battery capacity estimation. By establishing a RFR model to approximate the relationships between features, it accurately estimated the capacity of aged batteries under various cycling conditions.Liu et al.[18] proposed a classification framework utilizing RF, integrating Out-of-Bag(OOB) prediction,Gini variation,and Predictive Measure of Association (PMOA).The approach aimed to accurately evaluate the significance and correlation of battery manufacturing features and their influence on the classification of electrode properties.Tarchoune et al.[19] proposed a hybrid model named 3FS-CBR-IRF (Three feature selection - Case based reasoning - Improved random forest) to apply for the evaluation of medical databases. The model was evaluated on 13 medical databases, and the results indicated an improvement in the performance of the CBR system. Li et al.[20] utilized a GIS platform to assess the sensitivity of slope-type geological hazards in the study area using the information value model and the RF weighted information value model. The approach addressed the issue of negative impacts caused by sensitivity zoning results. The results indicated that the proposed models exhibited high ROC accuracy.Moin Uddin et al.[21] presented a novel hybrid framework combining feature selection, oversampling,and hybrid RF classifier to predict the adoption of vehicle insurance.The framework could benefit insurance companies by reducing their financial risk and helping them reach out to potential customers who are likely to take vehicle insurance.

With this backdrop,the above studies show that ML algorithms and data-mining techniques have been wildly used in the man-hours prediction and a variety of industries.However different ML algorithms have different advantages and disadvantages, the algorithms suitable for different specific fields are also different.Different specific requirements require different algorithms or the integration of multiple technologies to improve the accuracy and stability of the model.

On the basis of extensive study of man-hour prediction methods and the present project-based production environments, we listed various related variables. Then we utilized Pearson correlation coefficient to perform variable selection to identify the essential features for enhancing accuracy. A prediction system based on RFR model was developed in this study for the prediction of the man-hour. More over, the predictive performance was also compared with three other machine learning models.

3. Data Descriptions and Preprocessing

3.1. Data Descriptions

To build the man-hour prediction system,we collected processing data from the production lines of a steel structure enterprise for a total of two years, including 2022, and 2023.There are over 5000 rows of data in this dataset, each with 11 attributes. Two of these attributes (production schedule number and production bundle number) are attributes that uniquely represent the data and the other one is a textual description of the data.These three attributes are not relevant to the man-hour prediction,so we directly removed them prior to data preprocessing.One of the remaining nine attributes is the man-hour, which is the dependent variable to be predicted, and the remaining 7 attributes are independent variables.Attributes are mostly of numeric and character types.Table 1 shows further specific descriptions for the dataset.

3.2. Data Preprocessing

Data preprocessing is important to improve usability and accuracy for the model. For a given dataset, certain missing, unusual and redundant values were found after exploring all the data by analyzing and visualizing the distribution of each variable.This type of data cannot be directly used for model training, or the training results are unsatisfactory. In order to improve the accuracy of model predictions, data preprocessing techniques have emerged. There are various methods for data preprocessing: data cleaning, data integration, data transformation, data normalization, etc. These data processing techniques used before machine learning can greatly improve the quality of model predictions and reduce the time required to train the model.

In the steel structure manufacturing enterprise we cooperate with, each steel plate to be processed would be labeled with a QR code, which would be scanned to record the starting time of steel plate processing when the workers fed the plate into the machine for processing, and then scanned again to record the end time of processing after the end of processing, so that the actual processing time could be calculated through the processing starting time and the end time.However, in the actual operation process, workers might forget to scan the code at the beginning or end of processing, and instead scaned and recorded the time after a certain period of processing, thus resulting in a significant error between the actual processing time and the processing time recorded by the scan.This kind of data that deviates significantly from the actual real data is called noise. Noise can cause deviations in the prediction model, which seriously affects the accuracy of the model, so it is necessary to remove the noisy data before modeling.After analysis, it was found that workers forgetting to scan the code would result in either a very small or very large recorded processing time values.In response to this situation, this paper adopts an outlier detection based on box graph method to remove nearly 2000 noisy data.Finally,3000 pieces of data were left to form the dataset, which was divided in an 8-2 ratio,2400 pieces of data were placed in the training set, and 600 pieces of data were placed in the testing set.

For discrete data , such as business type (X4) is divided into two types: incoming material processing and delivery, this article uses one-hot encoding for conversion. One-hot encoding is a common method for converting character data into discrete integer encoding.After using one-hot encoding, 1 represents incoming processing and 0 represents incoming delivery. This can convert character features into numerical features that can be recognized by machine learning models.

The units of X1,X2....,X8 are different and the magnitude of them differs tremendously.For example, the unit of raw material weight is kilogram, while the unit of allocated length is meter, and data from different units cannot be compared. If the original data is directly used for model training, it will enhance the impact of features with larger numerical scales on the model, weaken or even ignore the effect of features with smaller numerical scales.Therefore, in order to significantly reduce the interference of features in terms of different value scales and ensure the effectiveness of the model training and fitting process, it is necessary to standardize the feature variables of the original sample data, so that the features of each dimension have the same weight impact on the model objective function.In this paper, equation(1) is used to min-max normalize the sample by scaling the range of values of each variable to between [0,1]. In equation (1), x* represents the normalized new value, x_min represents the minimum value of the sample, and x_max represents the maximum value of the sample.

$$x^{*}=\frac{x-x_{\min }}{x_{\max }-x_{\min }}$$

(1)

3.3. Input Variable Selection

Minimizing the number of input variables significantly reduces the likelihood of over-fitting, collinearity (high correlation between input variables), and transferring noise from data to the calibrated model (Ivanescu et al. 2016)[22].Having too many input variables, the regression model tends to fit itself to the noise hidden in the training set instead of generalizing underlying patterns and hidden relationships. A proper method for variable selection removes those insignificant or redundant input variables from the regression model (Akinwande et al. 2015)[23].

In the field of natural sciences, the Pearson correlation coefficient is widely used to measure the degree of correlation between two variables. The Pearson correlation coefficient between two variables is defined as the quotient of the covariance and standard deviation between the two variables, as shown in equation (2),where cov(X,Y) represents the covariance between X and Y, δ_X represents the standard deviation of X, and E[X] represents the expected value of X.

$${\rho }_{X,Y}=\frac{\mathrm{cov}(X,Y)}{{\delta }_X{\delta }_Y}=\frac{E[(X-\mu X)(Y-\mu Y)]}{{\delta }_X{\delta }_Y}$$

(2)

For discrete random variables, the Pearson correlation coefficient is calculated as shown in equation (3).

$$r_{xy}=\frac{n{\displaystyle \sum x_i{y}_i-{\displaystyle \sum x_i{\displaystyle \sum y_i}}}}{\sqrt{n{\displaystyle \sum x_i^2-{({\displaystyle \sum x_i})}^2}}\sqrt{n{\displaystyle \sum y_i^2-{({\displaystyle \sum y_i})}^2}}}$$

(3)

Pearson correlation coefficient varies from -1 to 1. The value of the coefficient is 1, which means that X and Y can be well described by the linear equation, and all data points fall well on the same line, and Y increases with the increase of X.-1 means that all data points fall on a straight line, and Y decreases as X increases. 0 means that there is no linear relationship between the two variables.

This paper analyzed the Pearson correlation coefficients between man-hours(Y) and variables X1~X11 respectively, the results are demonstrated in Table 2. Pearson correlation coefficients bigger than 0.4 mean good correlation, bigger than 0.5 mean strong correlation and bigger than 0.6 represent very strong correlation.We selected variables with a correlation greater than 0.4 with man-hours (Y), which are raw material width(X2), allocated length (X5), allocated weight (X6), and finished product width (X8).

Table 3 shows some samples which were randomly collected after variable selection.Table 4 shows the product characteristics and man-hours of some samples, which were randomly collected after variable selection and min-max normalization.

4. Models

4.1. Man-Hour Prediction System

In this study, a man-hour prediction system which consists of data preprocessing, input variable selection and model prediction was established. Data preprocessing and input variable selection have been discussed in detail above. After data preprocessing and input variable selection, a ML model is applied to forecast the target outputs. After training the ML model, separate predictions are conducted on test data to check the progress of the ML model.Figure 1 shows the overall work flow of the man-hour prediction system which includes data prepocessing and prediction.

Historical data is a comprehensive reflection of the internal mechanism of a system’s changes.The number of historical data shows the mechanism of the changes in an extent(Bing,2014)[24].We obtained historical processing data from the partner companies, and then used data cleaning methods to remove the noisy data;used one-hot coding to convert the text data into discrete data, and then normalized the data using min-max normalization;used Pearson correlation coefficient for variable selection, and then used machine learning regression models for man-hour prediction.

Machine learning is now widely used in man-hour prediction and workshop production, such as SVM[25],Back Propagation Neural Network(BPNN)[26],Decision Tree(DT)[27],etc.In order to obtain the optimal prediction results,this paper selected four models:SVM, BPNN, RF and Logistic Regression (LR)[28] for experiments.In order to obtain optimal model prediction performance,appropriate model parameters need to be used.For the above 4 models, we used network search methods to optimize the parameters of the four models and selected the best model parameters for model prediction.

4.2. Random Forest Regression

RF is a combination of decision tree classifiers such that each tree depends on the values of an independently sampled vector with the same distribution for all trees in the forest[29].

A RF consists of a set of decision trees h(X, θ_k) where X is an input vector, θ_k is an independent and identically distributed random vector. θ_k is generated for the k-th tree independently of the previous random vectors θ₁ ,...,θ_k-1, but with the same distribution. The reason for introducing θ_k is to control the growth of each tree. After many decision trees have been generated, the most popular class is voted. The k-th tree which is grown by a training set and θ_k , is equivalent to generating a classifier h(X, θ_k). In this sense, given a set of classifiers h(X, θ₁), h(X, θ₂),..., h(X, θ_k), and with the training set randomly presented from the distribution of the random vector Y, X where X is the sample vector and Y is the correctly classified classification label vector, the margin function is defined by Equation (4).

$$m_g(X,Y)=a{v}_{k}I(h_k(X)=Y)-{\max }_{j\ne Y}a{v}_{k}I(h_k(X)=j)$$

(4)

where I(x) is the indicator function.The margin function measures the extent to which the number of votes X, Y for the right class exceeds the maximum vote for any other error class-the larger the value, the higher the confidence of the classification. The generalization error is given by Equation (5)[30]:

$$P{E}^{*}=P_{X,Y}(m_g(X,Y)<0)$$

(5)

where X and Y represent the definition space of probability.

According to the law of large numbers[31], as the number of decision trees increases, all sequences θ_k and PE will converge to Equation (6), corresponding to the frequency converging to probability in the law of large numbers.It explains why random forests do not overfit with the increase of decision trees and have a limited generalization error value.

$$P_{X,Y}(P_{\theta }(h(X,\theta )=Y)-{\max }_{j\ne Y}{P}_{\theta }(h(X,\theta )=j)<0)$$

(6)

The working flow of the random forest algorithm is as follows(also illustrated in Figure 2):

Step1—The n sub-data sets D1,D2,…,Dn are randomly selected from the whole data set D.

Step2—A decision is generated for each sub-data, i.e. n decision trees are generated according to n sub-data sets, and a prediction result is obtained for every single decision tree.

Step3—The third step votes for each decision tree based on their prediction results, and then summarize the voting results.

Step4—Based on the summarized voting results, the algorithm selects the predicted result with the most votes as the final algorithm's prediction result.

5. Results and Discussion

5.1. Performance Evaluation Metrics

To assess models, we employed the root mean square error (RMSE), mean absolute percentage error(MAPE), population stability index(PSI) which were very widely used for assessment in prediction. The formula are as follows:

$$RMSE=\sqrt{\frac{1}{n}\times {{\displaystyle {\sum }_{i=1}^n(y_i-{\widehat{y}}_i)}}^2}$$

(7)

$$MAPE=\frac{100\%}{n}{\displaystyle {\sum }_{i=1}^n\left|\frac{{\widehat{y}}_i-y_i}{y_i}\right|}$$

(8)

$$R^2=1-\frac{{{\displaystyle {\sum }_{i=1}^n(y_i-{\widehat{y}}_i)}}^2}{{{\displaystyle {\sum }_{i=1}^n(y_i-\overline{y})}}^2}$$

(9)

$$PSI={\displaystyle {\sum }_{i=1}^n((P_a^i-P_e^i)\times \ln (\frac{P_a^i}{P_e^i}))}$$

(10)

In formulas (7) and (8), n represents the number of evaluated samples, y_i represents the true value of the samples, i.e. actual man-hour, and ŷ_i represents the predicted value of the samples, i.e. estimated man-hour. The closer RMSE and MAPE are to 0, the better the predictive performance of the model. In formula (9),$\overline{\mathrm{y}}$represents the mean of the sample, the meanings of n and y_i are the same as those in formula (7) and (8). The closer R² is to 1, the better the model performance; the closer it is to 0, the worse the model performance. In formula (10),${\mathrm{P}}_{\mathrm{a}}^{\mathrm{i}}$is the actual proportion of the sample within the partition boundaries, and ${\mathrm{P}}_{\mathrm{e}}^{\mathrm{i}}$ is the predicted proportion of each partition sample in the test dataset. PSI is used to measure the difference in data distribution between test samples and modeling samples, and is a common indicator of model stability. It is generally believed that model stability is high when PSI is less than 0.1, average when PSI is between 0.1 and 0.25, and poor when PSI is greater than 0.25.

5.2. Comparative Analyses

In this paper, the steel cutting hours were predicted using four models, (SVR), BPNN, LR, RFR, respectively.A total of 600 datas were used in the test set for prediction, and the parameters of each model were optimized using network search.Finally, experimental comparisons are conducted on the four prediction schemes,and the four man-hours prediction schemes are shown in Table 5.

Figure 3 shows histograms comparing the performance of four models, where Figure (a) shows the histograms of RMSE, MAPE, and R².Due to the significant difference in magnitude between PSI and the other three metrics, in order to better demonstrate the comparative relationship of PSI, a separate comparison is made in Figure (b).Table 5 and Figure 3 show that the RMSE, MAPE, R², and PSI of the RFR model are superior to the other three models. The RMSE of RFR is 0.69 lower than SVR, 0.98 lower than BPNN, and 1.18 lower than LR; The R² of RFR is 0.03 higher than SVR, 0.04 higher than BPNN, and 0.05 higher than LR, indicating that the predicted man-hours of the RFR model are closer to the actual man-hours and have the smallest error.For MAPE , RFR is 1.52% lower than SVR, 2.18% lower than BPNN, and 2.61% lower than LR, which indicates that the RFR model has the highest prediction accuracy.The PSI value of all four models are less than 0.1, indicating that the stability of all four models is high, among which the PSI value of the RFR model is significantly lower than that of the other three models by one order of magnitude, indicating that the RFR model has the highest stability.

Because PSI is a metric of model stability, in order to better analyze the stability of the RFR model, we divided the samples into 10 intervals. Table 6 shows the detailed data for each interval of the RFR model, where actual represents the number of real samples in the interval, predict represents the number of predicted samples in the interval, actual_rate represents the percentage of actual samples in the interval to the total sample, and predict_rate represents the percentage of predicted samples in the interval to the total sample.As can be seen from Table 6,except for the difference of 11 between the number of predicted samples and the actual number of samples in the 3rd interval, there is not much difference between the number of predicted samples and the actual number of samples in the other 9 intervals, such as interval 8 and interval 10, where the difference is only 2 samples. This indicates that the RFR model has high stability in the prediction of man-hours.

The prediction result of test set by RFR is shown in Figure 4.The RFR model exhibited outstanding performance on the test set, achieving a coefficient of determination (R²) as high as 0.9447. This metric signifies the model's capability to elucidate the variability in the target variable. The R² value of the RFR model underscores its considerable advantage in capturing the intricate relationship among steel processing hours. Furthermore, there exists a robust linear correlation between the model predictions and the actual observations, underscoring the RFR model's high level of accuracy and reliability in predicting steel longitudinal cutting processing time.

In order to further validate the performance of the model, we also presented SVR,BPNN and LR to make predict experiment. The forecasting results are shown in Figure 5, Figure 6 and Figure 7. Figure 5 shows the prediction result by SVR.The R² value of the SVR model stands at 0.9125, slightly lower than that of the RFR model but still within an acceptable range, indicating the effectiveness of SVR in addressing nonlinear problems. SVR efficiently captures the nonlinear features of the data by identifying the optimal hyperplane in the high-dimensional space. Despite its slightly inferior prediction accuracy compared to RFR, SVR's robustness in handling small samples or high-dimensional data suggests its potential applicability in specific contexts.

The forecasting result of BPNN can be seen in Figure 6.The R² value of the BPNN model stands at 0.9043, indicating a certain degree of accuracy in modeling the nonlinear relationship between the steel processing time. BPNN, as a deep learning model, can learn complex data mapping relationships through training with the back-propagation algorithm. Despite the potential requirement for more tuning parameters and computational resources, the BPNN's robust capability in handling large-scale datasets should not be overlooked, particularly in scenarios where data features are rich and model complexity requirements are high.

Figure 7 shows the prediction result of LR.The LR model yields R² value of 0.8914, representing the weakest performance among the four models. However, this does not diminish LR's practical value. As a linear model, LR remains effective in handling simple linear relationships or serving as a benchmark model. Its simplicity and interpretability render it a reliable choice in certain scenarios, particularly in studies with limited datasets or stringent requirements for model interpretability.

The relative error of the RFR model is depicted in Figure 8, showcasing an average relative error of -1.7956%. This indicates that the model's predicted values on the test set generally tend to be lower than the actual values, exhibiting a slight negative bias. This bias could stem from the model's inadequate comprehension or overfitting of specific data features during the training process. However, given the high R² value of the RFR model, the influence of this bias on the overall prediction results may be constrained.

Table 7 assesses the comparison of the prediction results by RFR,SVR,BPNN and LR.After comparison, it is obvious that the prediction result of RFR is much better than the other three models. It proves that RFR can be effectively applied to the prediction problem of man-hours while maintaining sufficient accuracy.

In summary, the findings of this study reveal that the RFR model exhibits the most effective performance in predicting steel longitudinal cutting processing time, followed by the SVR, BPNN, and LR models. These results offer a valuable tool for enhancing production optimization within the steel processing industry, with potential benefits including increased productivity and cost reduction. Future research endeavors could delve into optimizing model strategies, such as employing feature selection and dimensionality reduction techniques to enhance prediction accuracy. Additionally, integrating learning methods could combine the strengths of various models, thereby further improving prediction accuracy and robustness.

6. Conclusions

In the field of steel structure manufacturing, man-hour prediction has always been an indispensable part of production planning and scheduling. Accurate man-hour prediction is not only related to the production efficiency of enterprises, but also a key factor affecting the overall production process arrangement and cost control. This article proposes a man-hour prediction system based on historical data, focusing on this core issue, and elaborates on the key technologies of the system in data processing, feature selection, and prediction model construction.

In response to the issue of data inconsistency in the manufacturing process, this article adopted one-hot coding and data normalization techniques. These technologies not only solved the problem of diversity in data formats, but also improved the comparability of data and the stability of models. Through this step, we successfully transformed the raw data into effective inputs that the model can recognize.Pearson correlation coefficient was used to filter out features highly correlated with man-hours. This step not only reduced the complexity of the model and improved computational efficiency, but also identified the factors that have a decisive impact on man-hour prediction.After comparing multiple machine learning algorithms, the random forest regression algorithm was chosen as the main prediction model.Through training and optimization, the model showed superior performance in predicting man-hours.

The man-hour prediction system proposed in this article has higher prediction accuracy and stronger practicality compared to traditional expert estimation methods. The introduction of this system not only improves the accuracy of production planning and scheduling for enterprises, but also provides strong support for production cost control and efficiency improvement. The system has good scalability and flexibility. With the continuous accumulation of data in the manufacturing process and the emergence of new technologies, the system can be continuously optimized and upgraded to further improve the accuracy and efficiency of prediction. Meanwhile, the system can also be easily applied to other similar manufacturing fields, providing a solution for predicting man-hours for a wider range of production scenarios.

However, we must also recognize that any predictive model has its limitations and uncertainties. Although the system proposed in this article has greatly improved the accuracy of man-hour prediction, it may still be affected by some uncontrollable factors in practical applications, such as equipment failures, human operation errors, etc. Therefore, when using this system, we need to consider the actual situation comprehensively and make timely adjustments and optimizations.In the future, we will consider more factors, such as the proficiency of workers, the failure rate of machines, etc., in order to provide more efficient and accurate man-hour prediction services for enterprises.