Part 3 of our series on ERP for Maltese businesses, by sector.

You quoted the job in February. The customer took eight weeks to decide, then another three to confirm the details. You started in May.

The steel now costs 14% more than it did when you priced it. One of the components you assumed you had in stock turned out to be the last one, and the replacement has a six-week lead time from Italy. And because the original quote was built in a spreadsheet by whoever was free that week, nobody can now say exactly what material allowance was in it.

The job will get done. It usually does. But whether it made money is a question you'll answer in about nine months, roughly, by looking at the year's accounts and forming an impression.

That's the reality in most small manufacturing businesses in Malta — joinery, metal fabrication, food production, plastics, marine and boat work, signage, engineering workshops. Skilled people producing good work, with almost no visibility into which jobs are actually profitable.

Why small manufacturing is a harder problem than it looks

Big manufacturers run the same product thousands of times. That repetition makes costing straightforward, measure it once, and you know it forever.

Small Maltese manufacturers rarely have that luxury. The typical picture is short runs, custom work, frequent one-offs, and a mix of make-to-order and make-to-stock in the same workshop. Which means:

Every job is slightly different, so every job needs costing separately. There's no standard cost to fall back on.

Your materials come from abroad, with long lead times and moving prices. Malta imports nearly all raw material. A quote priced on last quarter's costs is a quote priced on the wrong numbers.

Your capacity is a small number of skilled people and a small number of machines. Lose either, someone leaves, a machine breaks and the whole schedule moves. There's no depth to absorb it.

And the work happens on a shop floor, not at a desk. Any system that requires people to walk to an office and type things into a computer will be ignored, and rightly so.

The five things that quietly cost you money

1. Quoting from prices that have moved

Most workshops quote from a mixture of experience, an old spreadsheet and a phone call to a supplier if the job is big enough to warrant it. That works when material prices are stable. Over the past few years they haven't been.

The specific failure is that the quote is a snapshot, and nothing connects it back to what the materials actually cost when you eventually bought them. So a job priced at a 25% margin can deliver 8%, and nothing in the business flags it. You find out at the end of the year, in aggregate, when it's far too late to do anything about that customer or that product line.

2. The bill of materials lives in someone's head

Ask what goes into a given product and the honest answer in many workshops is "ask Joe." Joe knows. Joe has always known. Joe has been doing it for eleven years.

That's fine until Joe is on leave, or ill, or retires. Then the same product gets made slightly differently, or with an expensive substitute material because nobody knew the cheaper one was specified, or with a mistake that isn't caught until the customer finds it.

Undocumented process is the single biggest risk in a small workshop, and it's invisible right up until the day it isn't.

3. Estimated versus actual is never compared

You estimated 12 hours of fabrication. It took 19. Does anyone know?

In most small manufacturers, no, because the hours aren't recorded against the job in any way that can be compared to the estimate. So the same product gets quoted at 12 hours again next time, and again the time after that, and the business systematically underprices its own work without ever discovering it.

This is the single most valuable comparison in manufacturing, and it's the one most commonly missing.

4. Material shortages are discovered mid-job

The job starts. Halfway through, someone goes to the rack and the material isn't there or there's less than expected because a previous job took some and nobody adjusted anything.

Now the job stalls. The customer gets a call. The team gets moved onto something else, which itself gets interrupted later. One shortage cascades into a week of disrupted scheduling.

The underlying cause is almost always the same: stock levels that reflect what was bought, not what's been consumed.

5. Scrap, rework and breakdowns are invisible

Every workshop has waste. Material that gets cut wrong, parts that fail inspection, work that has to be redone. In a well-run business, that's measured, so you can see whether it's getting better or worse and which products or processes generate it.

In most small manufacturers, rework is simply absorbed into the day. So is machine downtime. Both are real costs that appear nowhere except in the general sense that things take longer than they should.

What good looks like

Forget software for a moment. In a workshop that's running well:

• Every product has a documented bill of materials and a rough routing, so it can be made consistently by anyone competent
• Quotes are built from current material costs plus realistic labour, not from memory
• Before a job starts, the system has checked whether the materials exist and flagged what needs ordering
• Time and materials are recorded against the job as it happens, on the floor, with minimal effort
• At the end of the job you can compare what you estimated to what it actually took
• Scrap and rework are recorded, so you can see patterns rather than impressions
• Machine maintenance is scheduled rather than reactive
• Traceability exists where you need it, which batch of material went into which finished item

Notice how much of that is documentation rather than technology. The software matters, but the discipline matters more.

Where Odoo fits

The reason Odoo suits small manufacturers is that manufacturing, purchasing, stock and sales sit in the same system. In a workshop, the whole problem is that a customer order, a material shortage and a machine's availability are all connected  and in separate systems, they aren't.

Bills of materials. Products get a proper BoM, including multi-level structures where a sub-assembly feeds a finished item. The knowledge comes out of Joe's head and into something the business owns. BoMs also roll up costs, so you can see what a product costs to make from its components.

Manufacturing orders and work orders. A job becomes a manufacturing order with defined stages. Work orders can be assigned to specific work centres, so you can see what's queued where.

Shop floor recording. Odoo has a tablet-friendly shop floor interface designed for use at the machine — start a work order, record time, log quantities produced, flag a problem. This is the part that determines whether the whole thing works. If recording requires walking to an office, it won't happen.

Estimated versus actual. Because time and material consumption are recorded against the manufacturing order, you can compare what you planned against what it took. This is the number that changes how you quote.

Component availability checked before you start. Odoo checks whether the components for a manufacturing order are available, and reserves them. Shortages surface before the job begins rather than halfway through.

Replenishment and lead times. Reordering rules with supplier lead times recorded per vendor mean the system proposes purchases before you run out, which matters enormously when your steel comes from Italy on a six-week lead.

Scrap and unbuild. Waste gets recorded as scrap rather than quietly disappearing from stock, so you can actually measure it. Finished items can be unbuilt back into components when something needs reworking.

Quality control points. Checks can be attached to specific steps in the process, a measurement, a visual inspection, a sign-off, with failures recorded rather than handled informally.

Preventive maintenance. Maintenance can be scheduled against work centres on a time or usage basis, and breakdowns logged. Reactive maintenance is one of the most expensive habits in a small workshop, because a machine failing mid-job costs far more than the repair.

Subcontracting. If you send work out, plating, powder coating, specialist machining, Odoo handles subcontracted operations as part of the BoM rather than as an untracked gap in the middle of your process.

Traceability. Lot and serial tracking links raw material batches through to finished goods, which matters for food production, marine work, and anything where a customer may come back with a question in two years.

One honest note. Manufacturing is the most demanding module to implement well, because it depends entirely on the quality of your BoMs and routings. If those are wrong, everything downstream is wrong. Expect the first phase of any manufacturing project to be largely about documenting how you actually make things and expect that to be more work, and more valuable, than the software configuration itself.

Where to start

Three things worth doing before any software decision:

Document the BoM for your three highest-volume products. Properly - every component, every quantity, including the ones people forget. If this is hard, you've found your real risk, and it isn't software.

Take one recently completed job and work out what it actually cost. Materials at what you actually paid, hours at a realistic rate, plus anything scrapped or redone. Compare it to what you quoted. Most workshops find at least one uncomfortable surprise.

Count how many times in the last month a job stopped because material wasn't there. Even roughly. That's the cost of stock figures nobody trusts.

If those exercises are difficult to complete, that difficulty is the business case.

Centric Malta is an Odoo implementation partner based in Birkirkara, working with Maltese manufacturers, workshops and fabricators. If you'd like to talk through how your quoting, materials and production currently connect  and what it would take to see the real cost of a job — get in touch.

Mob +356 7746 9333 | Tel +356 2746 3333 | info@centricmt.com

Previously in this series: ERP for professional services firms - where the time goes.