Digitalization in Metal and Sheet Processing: From Excel to a Smart Workshop
The True Cost of Scrap and Downtime: Let’s Talk Numbers
A fiber laser machine consumes 80-150 TL of electricity per hour – every minute of downtime is money lost
Most workshop owners claim, “Our scrap rate is normal.” I ask: “What does ‘normal’ mean? Have you measured it?” The answer is usually, “We feel it’s around 10-12%.” Then we weigh it: it turns out to be between 17-22%.
Let’s do a concrete calculation:
Representative Scenario: A workshop processing 2×1 meter, 2mm cold-rolled steel sheets
- Daily consumption: 25 sheets
- Manual nesting scrap rate: 18%
- Automated nesting scrap rate: 9%
- Difference: 9 percentage points = Approximately 50% savings on daily consumption
To put it in perspective: In a workshop using 25 sheets a day, a 9% drop in scrap means saving 50+ sheets per month. On an annual basis, this figure turns into a significant cost advantage. An investment in nesting software usually pays for itself in 2-4 months.
Now let’s look at the cost of downtime:
Fiber laser downtime impact (representative)
- Target OEE: 65-75%
- Actual OEE in unmeasured workshops: 40-50%
- Loss in a 10-hour daily shift: 1.5-2.5 hours
- This loss = operator cost + electricity + opportunity cost
Total of scrap + downtime: An invisible loss of 8-15% of monthly revenue (varies by workshop size). Where is this money going? Nobody knows because it isn’t measured.
6 Critical Digitalization Points in the Workshop
Every machine is a data source – those who collect it win
Workshops that start by saying “we will digitalize everything” usually end up digitalizing nothing. The order of priority is critical. Here are the 6 critical points for a metal-sheet workshop, in order of importance:
1. Work Order Entry and Tracking
Current situation: Written in a notebook, sent via WhatsApp, the operator says “I forgot.”
Goal: Every work order is opened in the system. Status is visible: pending / cutting / bending / welding / quality control / ready for shipment.
Gain: The question “Where is this job?” is answered in 30 seconds. No more dealing with phone calls.
2. Laser/Punch Cutting Tracking
Current situation: The operator finishes the job, writes it in a notebook (maybe). No distinction between setup, cutting, and waiting.
Goal: “Start” button at the beginning of the job, “finish” button at the end. Selection of downtime reason (waiting for material, breakdown, break, setup).
Gain: OEE becomes measurable. Bottlenecks become visible.
3. Nesting and Scrap Tracking
Current situation: The operator places parts by eye. Scrap rate is “felt” at the end of the month.
Goal: Nesting software + scrap recording per cut.
Gain: Scrap drops from 18% to 9%. 400,000+ TL annual savings.
4. Press Brake/Bending Workflow
Current situation: Cut parts pile up, the press brake master doesn’t know the priority. Bending angle/sequence is checked from the technical drawing (if available).
Goal: In the digital work order: part code, material, thickness, bending sequence, angles, tooling information.
Gain: Setup time decreases by 40%. “Wrongly bent” scrap drops by 70%.
5. Raw Material and Scrap Stock
Current situation: In Excel (updated monthly). Half-sheets are scattered around the workshop.
Goal: Real-time stock. Half-sheet rack + labeling. Scrap/waste weighing.
Gain: The question “Is there any sheet left?” is answered by the system. Half-sheets are used, scrap decreases.
6. Subcontracting Tracking
Current situation: Parts sent out can get lost. Subcontractor delays cause delivery delays.
Goal: Outbound record (date, quantity, subcontractor name), inbound record (quality status), aging report.
Gain: Subcontracting jobs exceeding 7 days trigger an alarm. Lost parts become a thing of the past.
Nesting Optimization: How to Drop from 18% to 9%?
Automated nesting places parts on the sheet using an algorithm
In manual nesting, the operator places parts by “eye estimation.” An experienced operator produces 15-16% scrap, an inexperienced one 20-25%. Automated nesting software performs mathematical optimization: it rotates, shifts, and nests parts.
Things to Consider When Choosing Nesting Software:
- CAD integration: Must be able to import DXF/DWG files directly
- Machine integration: Compatible output format for laser/punch/plasma
- Half-sheet management: Must be able to use remaining parts in the next job
- Common cut: Single cutting line between two parts
- Reporting: Scrap rate per cut, sheet utilization percentage
Common Nesting Mistakes:
- Leaving too much space between parts: 2-3mm is enough for laser, 10mm gap means scrap
- Not using half-sheets: The remainder of the cut sheet should be labeled and shelved, then used in subsequent jobs
- Not mixing different thicknesses: 2mm and 3mm parts cannot be cut from the same sheet, but different customer jobs of the same thickness can be combined
- Ignoring heat distribution: Consecutive cuts in laser heat the sheet, causing parts to warp. Good nesting calculates this.
You can visit our industry page for detailed information about the metal and sheet processing industry.
Work Order Flow: Moving from Paper to Tablet
Step-by-step approach to setting up a digital work order system:
Step 1: Work Order Template Design
What should be in every work order:
- Work order number (auto-incrementing)
- Customer name and order reference
- Part code and description
- Material type and thickness (Cold-rolled 2mm, Stainless 304 1.5mm, etc.)
- Quantity
- Planned start and end date
- Operation sequence: Cutting → Bending → Welding → Surface treatment → Shipment
- Estimated time for each operation
- Technical drawing link or attachment
Step 2: Status Tracking
Status change at each operation:
- Pending: Work order opened, not yet started
- In Production: Operator pressed the “start” button
- Paused: Waiting for material, breakdown, etc. (reason must be selected)
- Completed: Operation finished, ready for the next one
- Quality Control: In final inspection stage
- Ready for Shipment: Can be sent to the customer
Step 3: Data Collection Points
Tablet/terminal placement in the workshop:
- At the laser machine: 1 tablet (start/finish job, view nesting report)
- At the press brake: 1 tablet (start/finish job, view bending instructions)
- At the welding station: 1 tablet (start/finish job)
- At the quality control table: 1 tablet (OK/NOK record, scrap reason)
Devices should be in the workshop, within 3 steps of the operator. If it stays in the office, nobody will use it.
Field Example: Transformation of a 12-Person Laser Workshop
Company Profile (Representative)
A sheet processing workshop operating in an organized industrial zone in Anatolia. Equipment: fiber laser, press brake, punch press. Team: 12 people (laser operators, press brake operators, welding/assembly, shipment, quality control). Customer profile: Sub-industry, agricultural machinery, metal furniture.
Initial Situation
- Work orders: Written on A4 paper and distributed
- Nesting: Operator does it manually, based on experience
- Scrap rate: “Estimated 14%” (not measured)
- OEE: Never calculated
- Customer complaint: “Where is my order?” 15+ calls per day
- Subcontracting tracking: Excel (updated every 2 weeks)
Steps Taken
- Week 1-2: Current situation analysis. All scrap was weighed for 1 week. Result: Actual scrap 21% (50% more than estimated). Laser downtime reasons recorded: 35% waiting for material, 25% waiting for DXF, 20% breakdown, 20% other.
- Week 3-4: Nesting software installation. 2 days of training for operators. In the first week, manual and automatic were run in parallel, and a comparison was made.
- Week 5-8: Digital work order pilot application. Tablet installed only for laser operation. “Start/finish” button and downtime reason selection at the laser.
- Week 9-12: Press brake and punch were also added to the system. All operations became trackable.
- Month 4-6: Stock module activated. Subcontracting tracking added. Reporting dashboards set up.
6th Month Results (Representative Values)
- Scrap rate: 21% → 11%
- Laser OEE: 42% → 61%
- “Where is my order” calls: 15+/day → 2-3/day
- Delivery delay rate: 38% → 11%
- Subcontracting lost parts: 3-5/month → 0
- Work order opening time: 25 min → 4 min
Investment and Return
Total investment items: Nesting software, workshop tablets, work order software license, training. For a workshop of this scale, the return on investment period is usually between 4-8 months (varies depending on scrap savings and productivity increase).
7 Deadly Digitalization Mistakes in Workshops
1. “Let’s Buy Expensive ERP, It Will Handle It”
A 500,000 TL ERP system is purchased, but there are no tablets in the workshop. The system is used for the accounting module, while the production module sits on the shelf. Money goes down the drain. Start simple, let the system grow as needs grow.
2. Bypassing the Senior Master
The system is installed at the owner’s request, but the 20-year master is in “there was no such thing in my day” mode. When the master undermines the system, the apprentices won’t use it either. Solution: Make the master a “super user,” highlight them in training.
3. Buying Nesting Software Without Measuring Scrap
The current scrap rate is unknown. After buying the software, there is no answer to the question “how much did we reduce it?” ROI cannot be calculated. Measure manually for 2 weeks first, then buy.
4. Keeping the Tablet in the Office
The operator has to walk to the office for data entry. 50-meter walk = 2 minutes loss × 20 entries/day = 40 minutes/day × 22 days = 14.5 hours/month. The tablet must be at the machine.
5. Launching Everything at Once
Work order, stock, quality, subcontracting, accounting integration… They want to go live with everything in 1 month. Chaos is inevitable. Start with one module, wait for it to settle for 1 month, then expand.
6. Not Detailing Downtime Reasons
“Machine stopped” record is insufficient. Why did it stop? Waiting for material, breakdown, or setup? Improvement cannot be made without detail. Define downtime categories, let the operator select.
7. Collecting Data But Not Analyzing It
The system has been collecting data for 6 months, nobody looks at it. A 30-minute weekly “KPI meeting” should be held. Trend graphs should be drawn. A data → information → action cycle must be established.
Those who collect data win, those who analyze grow
Workshop KPI Table: What and How Will You Measure?
The table below contains critical KPIs for a metal-sheet workshop, industry averages, and target values:
| Metric | Industry Average | Good Level | Measurement Method |
|---|---|---|---|
| Laser OEE (Overall Equipment Effectiveness) | 45-55% | 65-75% | Digital work order + downtime record |
| Raw material scrap rate | 15-20% | 8-12% | Nesting report + weighing |
| Press brake setup time (per job) | 25-40 min | 10-15 min | Digital work order timestamp |
| On-time delivery completion | 65-75% | 90%+ | Planned vs actual date |
| First-time right production rate | 85-90% | 96%+ | Quality control OK/NOK record |
| Subcontracting return time (average) | 7-12 days | 3-5 days | Outbound-inbound date difference |
| Work order opening time | 15-25 min | 3-5 min | System timestamp |
| Daily parts per operator | Variable | Trend increase | Completed work order / operator |
Measure these metrics weekly, report monthly. What matters is not the instantaneous value, but the trend. Are we improving compared to last month?
Weekly Workshop Checklist
Review this list with your team every Monday morning:
Scrap and Material
- Has the previous week’s scrap rate been calculated?
- Has the half-sheet stock been updated?
- Has scrap weighing been performed?
- Has critical material stock been checked?
Machine and Operation
- How many hours of total downtime last week?
- Have downtime reasons been analyzed?
- Has laser OEE been calculated?
- Has the maintenance schedule been checked?
Delivery and Customer
- How many deliveries this week, which one is risky?
- Are there any delayed deliveries from last week? Why?
- Are there any customer complaints/feedback?
Subcontracting and Supply
- Has the open subcontracting jobs list been generated?
- Are there any subcontracting jobs exceeding 7 days?
- Are expected subcontracting returns for this week being tracked?
Frequently Asked Questions
OEE is calculated with the formula: Availability × Performance × Quality.
- Availability: (Total operating time – Unplanned downtime) / Total operating time
- Performance: Actual cutting time / Theoretical cutting time (according to the machine’s nominal speed)
- Quality: (Total parts cut – Scrap parts) / Total parts cut
Example: 1.5 hours of downtime in a 10-hour shift, 90% speed performance, 98% quality rate.
OEE = (8.5/10) × 0.90 × 0.98 = 0.85 × 0.90 × 0.98 = 75%
The industry average is 45-55%, well-managed workshops are in the 65-75% range.
In manual placement, the scrap rate ranges between 15-25% depending on operator experience. Automated nesting software can reduce this rate to the 8-12% level.
In a medium-sized workshop (consumption of 20-30 sheets per day), an 8-10 percentage point drop in scrap provides a significant cost advantage on an annual basis. Software investment usually pays for itself in 2-6 months.
Critical point: Buying the software is not enough; the operator must use it and half-sheet management must be active.
Three basic approaches:
- Tooling layout standardization: Define a fixed position for every punch/die combination. The operator shouldn’t have to think “where will I mount this” every time.
- Instructions in the digital work order: Bending sequence, angles, tooling information should be visible in the system. The operator shouldn’t waste time looking for technical drawings.
- Job grouping: Plan jobs using the same tool set consecutively. Minimize the number of tool changes.
With these three steps, setup time can be reduced by 40-60%. A 30-minute setup drops to 12-15 minutes.
Typical investment items for a 5-15 person metal-sheet workshop:
- Tablet/terminal (2-3 industrial units)
- Work order tracking software (monthly or annual license)
- Nesting software (optional but recommended for scrap reduction)
- Installation and training
The cost varies depending on the workshop scale, selected software, and existing infrastructure. Critical point: Thanks to scrap savings and productivity increases, the investment usually pays for itself in 6-12 months. The healthiest approach is to keep it small and simple at the beginning and expand as needs grow.
Resistance is normal and can be broken with a three-step approach:
- Make the senior master a “super user”: Highlight them in training, give them the responsibility of teaching the system. Create the perception of “Master Ali will show us” instead of “the boss wants this.”
- Position the system as a facilitator: Give the message “not to track you, but to reduce phone traffic.” Concrete benefit: “You won’t have to answer when the customer calls, the system will show it.”
- Allow a margin for error: Don’t criticize for the first 2 weeks, allow them to make corrections. Don’t use it as a disciplinary tool.
Resistance usually breaks in 3-4 weeks. If it doesn’t, have a one-on-one meeting, understand the real problem (fear, insecurity, change fatigue).
Four critical recording points in subcontracting tracking:
- Outbound record: Date, part code, quantity, subcontractor name, waybill no, estimated return date
- Inbound record: Return date, quantity received, quality status (OK/NOK/partial), missing/damage note if any
- Aging report: A weekly “open subcontracting list” should be pulled. Automatic warning for subcontracting jobs exceeding 7 days
- Invoicing connection: Returned parts should not be closed without being invoiced
Even if it’s a simple Excel, these four points must be recorded. The ideal is a subcontracting module integrated into the work order system.
Get Support for Your Project
I can help guide your digital transformation initiative. Book a free preliminary call to discuss your priorities.