- Moges
- 2026-11-22
How to choose a workshop production progress tracking system? Comparison of three tiers: Excel, lightweight reporting, and MES.
Mold factory owners dread the phone calls on Friday afternoons. Customers are calling to inquire about the delivery status of the parts ordered the previous week, and after searching through WeChat groups and Excel work reports, it takes half a day to get a rough estimate – the first process ran on the CNC machine for 8 hours, heat treatment is still pending, and the polishing workshop has 12 orders backlogged. "Please give me a firm delivery date by Wednesday next week," the customer hangs up, leaving the workshop supervisor to worry over the whiteboard. This is the typical daily state of most discrete manufacturing workshops: fragmented information, slow feedback, and production scheduling that feels like walking a tightrope.
The workshop production progress tracking system addresses this very pain point. It brings the real-time status of each machine, each operation, and each work order onto a single dashboard, transforming the question "What's the status of that order?" from individually calling to seeing it in 3 seconds on a mobile phone. While this sounds simple, the actual implementation involves far more than just purchasing a software package. Below are some key data and conclusions observed by over 200 Jiangsu manufacturing clients during implementation.
![]()
- The shop floor production progress tracking system is a real-time status collection and visualization tool for discrete manufacturing shops.
- According to data from over 200 manufacturing clients in Jiangsu, after implementation, the average on-time production rate increased by 23%.
- The initial deployment cycle for the lightweight reporting version is approximately 2–3 days, while the core MES version takes approximately 2–4 weeks.
- After replacing paper-based work reports with mobile PDA, the error rate in labor time recording decreased from an average of 17% to within 3%.
Many companies want to review a clear comparison table before selecting a solution. The following table, compiled based on real-world scenarios encountered during Moges implementations, covers three typical approaches, ranging from pure manual processes to professional MES, to help readers quickly identify their current stage and the appropriate upgrade direction.
| Solution Type | Suitable for | Deployment Costs and Cycle Time | Key Features |
|---|---|---|---|
| Excel + WeChat Group | Suitable for workshops with fewer than 20 people. | 0 Yuan / 0 Days | Handcrafted, no automation. |
| Lightweight Work Order System | 20–80 people, small workshops | Mobile PDA job reporting + Gantt chart dashboard | |
| Professional MES Core Version | Suitable for medium-sized factories with 80–300 employees | Process flow + quality inspection + tool cost linkage | |
| End-to-end ERP + MES | Serving over 300 large factories | Seamlessly connect from quotation to delivery. |
Several numbers in this table are worth noting. The lightweight reporting version, which can be implemented in 2–3 days, does not mean it lacks functionality. It addresses the core needs of small workshops: inaccurate reporting, lack of visibility into progress, and difficulty for managers to access data. Many customers were initially surprised to learn that, after just 15 minutes of training, team leaders could easily use the system. The core MES version, starting at 150,000, is typically chosen by factories that have already experienced problems with manual reporting for at least six months or that are starting to accept automotive parts orders (where full traceability is required by the customer).
1. What specific aspects of workshop progress should be tracked?
Many people mistakenly believe that "progress tracking" simply means observing the status of a work order on a Gantt chart to see if it has reached its final stage. However, in a typical mold workshop, a single work order typically goes through at least 6 stages: material cutting, CNC rough machining, heat treatment, finishing, quality inspection, and warehousing. The start and end times of each stage directly impact the scheduling of subsequent processes. For example, if CNC machining is delayed due to a broken tool, the heat treatment schedule will need to be adjusted accordingly.
This is why relying solely on Excel is difficult – Excel is a static spreadsheet, while a manufacturing shop is a dynamic system. Unexpected events like a sudden tool break, an operator calling in sick, a temporary rush order, or a customer requesting expedited delivery occur hourly. A progress dashboard that accurately reflects real-time status requires data to be captured at each stage as it happens, rather than waiting for the shift supervisor to compile and input the information after their shift.
Regarding the level of tracking, different workshop sizes have different needs. A workshop with 20 people may only need to track whether a job is being processed on a CNC machine or in heat treatment, while a medium-sized factory with 150 people requires tracking down to the specific 3rd operation of a job, which is being processed on machine number 5 for 2 hours and 17 minutes. The finer the granularity, the more data collection is required, and the higher the system's flexibility requirements become.
II. Suitable scenarios for each of the two-tier and three-tier solutions.
The table above provides a general overview, but the actual selection depends on the specific conditions of the factory. Below, we will discuss the advantages and disadvantages of each of the three schemes.
Excel + WeChat Group--This is the starting point for most workshops. The team leader sends a handwritten report photo to the group every day before leaving work, and the clerk enters the data into Excel at night. The boss sees the data from the previous day in the morning. The advantage is zero cost and zero learning curve. The disadvantage is that the information is significantly delayed. If the workshop is experiencing rapid expansion (for example, from 10 machines to 30 machines), this method usually collapses completely after 3 months of expansion.
Lightweight Work Order System--This is currently the most cost-effective option. The core logic involves providing each team leader with a smartphone (or installing an app on their existing phone), where they simply tap to mark the start and end of each task, with data synchronizing in real-time to the cloud. The owner can then view the Gantt chart on their computer. The key to this solution is "lightweight": it does not require changes to existing shift schedules, it does not require operators to learn complex scanning operations, and it can even be completed with just a few buttons. Of Moges' 200+ customers, 60% ultimately chose this option or expanded upon it.
Professional MES Core Version- This level of functionality is only needed when workshops begin to focus on "traceability." For example, when receiving an order for automotive components, the customer requires traceability of the processing equipment, operator, tool model, and quality control data for each part. Or, when a factory wants to link tool costs, labor costs, and order profits, this moves beyond simple progress tracking and involves building an entire production execution system. Implementing this solution takes a longer period and requires a dedicated project manager, as well as a greater investment.
Three key details often overlooked during selection:
One often overlooked detail is "who will actually use it." Many managers focus solely on the features and pricing when selecting a system, without considering the actual users – typically middle-aged workers in the shop floor who may not be familiar with smartphones. If the system has more than 3 levels of nested menus, or requires filling in more than 5 fields each time, it is likely to be met with resistance: the supervisors will verbally agree, but will continue to use paper and pen to record their work, and then input everything at the end of the day.
The second key detail is "the ability to integrate with existing equipment." Many workshops already have CNC machines, and some equipment has built-in data interfaces. If the new system can directly read the operating status of the machine (such as spindle speed and machining time) without manual button pressing, the accuracy of the data will be significantly improved. However, not all equipment has open interfaces, so this needs to be verified before selecting a system. It is important not to simply rely on the vendor's statement that "we support it."
The third key detail is "Who to contact when problems arise." The factory operates 24/7, and when a machine malfunctions on a Saturday night, the work order recording gets stuck. In this urgent situation, the ability of the system vendor to respond promptly is more important than anything else. Moges has focused on the manufacturing industry for 14 years, serving over 200 customers. The 7×24-hour industry consultant support is one of the reasons why many customers choose Moges after comparing multiple vendors.
4. Changes after implementation often exceed expectations.
I have a particularly memorable customer story. It was a 45-person precision parts manufacturing company, where the owner was previously managing production using Excel and WeChat groups. He would spend a fixed 2 hours every Friday afternoon calling individual employees to inquire about progress. After implementing a lightweight work order system, he told me, "Now I have those two hours back, and I'm using that time to work with sales to finalize the orders for the following week." This transformation wasn't a dramatic digital transformation; it was simply freeing the owner from inefficient information gathering.
Similar feedback includes: "Before, I didn't know how long a specific card had been in the furnace, but now the dashboard clearly shows this, preventing me from over-heating the furnace." A quality control inspector stated: "Previously, it took me half a month to find the historical record for a specific order by searching through paper files. Now, I can see the complete flow record by simply entering order number 10. These small changes, when accumulated, result in a real increase in workshop efficiency.
Of course, not all projects are smooth sailing. One customer reported, "The system is good, but the supervisors still prefer using paper-based records," two weeks after going live. Upon on-site investigation, we found that this was due to a particularly busy period with a large number of orders. The supervisors felt that "it took too long to tap on their phones," especially when they were already busy. We then added a "batch reporting" feature, allowing supervisors to select all the completed tasks for the day in one go, which could be submitted in just 10 seconds. This resolved the issue. This experience taught us that a good system should not force the workshop to adapt to the software, but rather, the software should adapt to the existing processes already in place in the workshop.
Tracking production progress in the workshop is often described as a "management tool," but when implemented, it becomes clear that it fundamentally changes the way the entire workshop collaborates. From the CEO to supervisors and team leaders, everyone benefits from transparent information – no more guesswork, no more waiting, and no more anxiety about where a specific order is in the process. This is perhaps why over 200 customers have chosen to entrust us with the most critical aspect of their production: because we understand the real, granular, and often unspoken challenges that exist within workshops.




