Manufacturing: managing orders, production and jobs beyond the spreadsheet

In Italian manufacturing SMEs, technical and production expertise is almost always solid. What fails to keep up is the coordination around production: orders coming in, progress across departments, customer deadlines. That coordination often lives in a shared spreadsheet, a few phone calls and a walk through the shop floor. It works, until it breaks: the person who owns the file goes on holiday, an urgent order jumps the queue, and suddenly nobody knows for sure where anything stands.

This is not about replacing your ERP or your machinery. It is about the coordination layer around them, and the hidden cost of running it without a system.

Where control gets lost

• Orders arrive through different channels, between email, phone and the sales team, and are copied into the spreadsheet by hand, with delays and errors.
• Production progress is not visible in real time: to know where an order stands you have to ask the shop floor.
• Dependencies between stages and departments stay implicit: when one stage slips, the knock-on impact is discovered late.
• Customer deadlines live separately from actual progress, so sales commitments and production capacity never talk to each other.

What does not need to change

Your management system or ERP stays where it is for master data, inventory and invoicing. Machinery and shop-floor systems stay where they are. What needs to be added is a coordination layer: one place where jobs, stages, dependencies and progress live, not as a replacement for existing tools but as the nervous system of production.

How to structure job coordination

• Every job becomes a project with its standard stages, duplicated from a template with each new order.
• A clear status for every stage and department, updated by the people doing the work, not by the office at the end of the day.
• Explicit dependencies between stages, so the effect of a delay on downstream activities is visible immediately.
• A portfolio dashboard for management, showing the status of every active job at a glance.

The sign that it is working

It is not the number of screens configured. It is when the production manager stops receiving, and making, phone calls to find out where an order stands, because the status is already there, up to date and readable by everyone. From that moment production meetings get shorter, because everyone starts from the same data instead of reconstructing it every time.