• 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.

How to choose a workshop production progress tracking system? Comparison of three tiers: Excel, lightweight reporting, and MES.

  • 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.

Professional mold, automation parts manufacturing industry management software
Small and Medium-sized Enterprise ERP, MES, and MRP Solutions
Trade Inventory SaaS Management System, Linux Email Server Solution

Tel: 18625220688

Solutions

Mold Manufacturing Digitalization
Focused on mold shop production management, significantly shortening delivery cycles
ERP Systems for the Sheet Metal Industry
End-to-end management of laser cutting, bending, and welding
Custom Automation Equipment Management
Integrated quotes, production progress, and cost accounting
Tooling & Fixture Management Systems
Fully digital control of the inspection fixture production process

Resource Downloads

MES Whitepaper

In-depth Guide to Mold Manufacturing Execution Systems

Product Documentation

Moges PMS System Feature Guide

FAQ

Answers to all your questions

Contact Us

Now
Talk to Us

14 years of industry experience, focused on the digital transformation of mold, sheet metal, and custom automation equipment manufacturing

186 2522 0688

Headquartered in Kunshan, with on-site service within a 2-hour radius

Contact
Product & Service Inquiry

Free Online Consultation on Products & Solutions

Get a Quote

FAQ

Q: What is the relationship between a workshop production progress tracking system and MES?
A: MES is a more comprehensive production execution system, with progress tracking as one of its core modules. A lightweight progress tracking system only addresses "work order + dashboard," while MES builds upon this foundation to cover the entire process, including process flow, quality inspection, tool management, and cost accounting.

Q: Is it necessary to implement ERP and MES for a workshop with 20 employees?

Q: Does the system require integration with the machines?
A: Not necessarily. The Lite version, with manual input via a mobile PDA, is sufficient. The accuracy can be reduced from an initial 17% error to within 3%. If you want to take it a step further, you can choose a machine with an OPC UA interface, allowing the system to directly read the main shaft running data.

Q: What if the operators are all experienced, 40-50 year old veterans who are not familiar with the new system?
A: This is the most common mistake people make when choosing a solution. You absolutely need to choose a solution with a very simple interface – the only buttons required are "Start," "End," and "Pause," without the need to fill out complex forms. The Moges PMS5 is specifically designed for this scenario, and 95% of the workshop supervisors in over 200 customer sites can independently use it after training for less than 15 minutes.

Q: How to choose between SaaS and on-premise deployment?

Q: After going live, can we still use the original Excel spreadsheets and paper documents?
A: It is possible to implement it in parallel for a period of time. We recommend a "dual-track" approach for the first two weeks – continue using both paper-based recording and the system, and then gradually phase out the paper-based system once everyone is comfortable. Moges' implementation consultants will assist with this transition to avoid any issues arising from a sudden switch.

Latest News

Online Subscription