Business and technology consulting · Azores, Portugal
Request the full report

Operations and stock in an island territory · Full Diagnostic

Less idle stock, higher service levels

How Navegante Distribuição can grow with higher margins and less tied-up capital, on an island where everything arrives by ship.

  • Praia da Vitória, Terceira
  • 85 employees
  • 4,200 products
  • Full Diagnostic · 5 weeks
  • Around €2.5m in stock, 62 days of sales, and still 6 in every 100 order lines are not fulfilled.
  • Three recommendations: buy with data in step with the ships, release idle stock and digitise orders from hotels and restaurants.
  • In 12 months: around €650k of capital released and an estimated gain of €200k per year.
  1. 01What we recommend
  2. 02Starting point
  3. 03Where the stock is
  4. 04What we found
  5. 05What changes in 12 months
  6. 06Where to focus effort
  7. 07The recommendations in detail
  8. 08What it is worth
  9. 09Roadmap
  10. 10Next step

Prepared for the board of Navegante Distribuição · November 2026 · Illustrative example: fictitious company and data

In summary

Three recommendations, three decisions

What we propose to do, why, and the decision we need from the board to move ahead before the next high season.

1

Buy with data, in step with the ships

Today, orders to suppliers depend on the experience of two buyers. A demand forecast by product and replenishment calculated for each ship reduce stock and stockouts at the same time.

DecisionApprove the purchasing planning project, starting in January.

See detail →
2

Release idle stock

Around €450k sits in products that have not sold for more than six months. A clearance plan and clear rules for listing new products release capital and warehouse space.

DecisionAppoint a range manager and approve the list of products to delist.

See detail →
3

Digital ordering for hotels and restaurants

Seven in ten orders arrive by phone, WhatsApp or email and are keyed in by hand. An ordering portal with each customer's catalogue and prices reduces errors and frees the sales team to sell.

DecisionChoose 30 pilot customers for the first quarter.

See detail →

What we do not recommend for now: opening a warehouse on São Miguel or launching a private label. They make sense later, once planning and margins are under control.

Starting point

A solid distributor, held back by 20-year-old processes

A second-generation family business supplying hotels and restaurants, independent retailers and institutions on Terceira, Graciosa and São Jorge. Everything it sells arrives from the mainland by container, with one ship a week.

  1. The question: how can it grow with higher margins and less idle capital, without losing the service level customers expect?
  2. What we did in 5 weeks: 18 interviews (board, purchasing, warehouse, sales and 8 customers), analysis of 3 years of sales, purchasing and stock by product, and benchmarking against distributors in other island regions.
  3. Scope: purchasing and stock, product range, ordering channels and margins by customer.
€18min sales per year
62days of stock, at cost
94%service level: 6 in every 100 lines are not fulfilled
70%of orders by phone, WhatsApp or email

Where the stock is

Almost 1 in every 5 euros of stock has not sold for more than six months

Stock value by type of product. A products are the 20% that make up 80% of sales. Choose the scenario.

—of stock unsold for more than 6 months
  • A products · fast-moving—
  • B products · medium turnover—
  • C products · slow-moving—
  • Unsold for more than 6 months—

Illustrative figures for a fictitious company.

What we found

Loyal customers and a good team, but decisions made by gut feel

Strengths

  • Loyal customers: 20% of customers account for 75% of sales, many for over 15 years.
  • An experienced team and reliable deliveries on three islands.
  • A 22% gross margin in hotels and restaurants, above the sector average.

Weaknesses

  • Purchasing without forecasts: two buyers decide quantities from experience, without demand data.
  • Stockouts concentrated in summer (June to September), when hotel demand rises by around 45%.
  • Manual orders: 70% arrive by phone, WhatsApp or email, with errors and rework.

Opportunities

  • The weekly ship is predictable: it makes it possible to calculate the right replenishment for each sailing.
  • Forecasting and replenishment tools are now affordable for companies of this size.
  • Margins by customer: retail comes in at 13%, and some customers are loss-making after transport.

Risks

  • Ship delays or cancellations: safety stock has to allow for them.
  • Dependence on two people for all purchasing.
  • Competition from larger groups with central buying on the mainland.

What changes in 12 months

Less stock and, at the same time, better service

The indicators we propose to track, today and the 12-month target.

Days of stock

-27%
Today
62 days
In 12 months
45 days

Capital in stock

-26%
Today
€2.5m
In 12 months
€1.85m

Service level

+4%
Today
94%
In 12 months
98%

Stock unsold for more than 6 months

-71%
Today
€450k
In 12 months
€130k

Orders keyed in by hand

-50%
Today
70%
In 12 months
35%

Hours per week on purchasing

-42%
Today
60 h
In 12 months
35 h

Illustrative targets, in line with what distributors of a similar size achieve in the first year with demand forecasting and planned replenishment.

Where to focus effort

Six possible paths, three to start now

Each path assessed by impact on results and effort for the organisation.

Impact ↑ Effort →
Quick winsStrategic projectsSmall improvementsNot now

Start now

1. Buy with data, in step with the ships

The biggest impact: it cuts stock and stockouts at the same time. It requires clean data, a tool and a new purchasing routine.

See the recommendation →

Click a point to see the detail.

The recommendations in detail

What to do, and why

High priorityMedium priority
1 Buy with data, in step with the shipsDemand forecasting and replenishment by ship High

Why

  • Stock is high and yet products run out in summer: a sign that the company buys what it does not need and lacks what it does.
  • With one ship a week, each order has to cover 10 to 14 days of demand plus a safety margin.

What we propose

  • Classify the 4,200 products by turnover and importance (ABC) and set the safety stock for each class.
  • A weekly demand forecast by product, with summer and festival seasonality.
  • An order proposal calculated for each ship, validated by the buyers.
  • A forecasting and replenishment tool integrated with the current management system.
2 Release idle stockClearance and range rules High

Why

  • Around €450k of capital and warehouse space taken up by products that do not sell.

What we propose

  • A list of products unsold for more than six months, with a decision for each: return, promote or delist.
  • Rules for listing new products: they only come in with a defined customer, volume and margin.
  • A range manager and a quarterly review.
3 Digital ordering for hotels and restaurantsOrdering portal with catalogue and prices by customer High

Why

  • Manual orders create errors, rework and unreliable demand data.
  • Sales staff spend the day keying in orders instead of selling.

What we propose

  • An ordering portal and app with each customer's catalogue, prices and history.
  • A pilot with 30 hotel and restaurant customers in the first quarter.
  • Target: half of these customers' orders through the portal within six months.
4 Review prices and margins by customerSecond phase Medium

Why

  • Some retail customers and customers on other islands are loss-making after transport costs.

What we propose

  • Margin by customer after delivery cost.
  • Minimum order and different terms by island and by type of customer.

What it is worth

Simulate the value of the recommendations

Move the values to test scenarios. The starting values are those of this diagnostic.

Capital released from stock

Result —

Lower stock holding cost

Result —

Margin on recovered sales

Result —

Team time

Result —

With the starting values: around €650k of capital released and €200k of gain per year (stock holding cost, recovered margin and team time). Holding cost includes financing, warehousing, insurance, shrinkage and obsolescence.

12-month roadmap

Everything ready before the high season

What we do

Product and supplier data clean-up, ABC classification, list of idle stock and clearance plan.

Targets

ABC completed · clearance plan approved · range manager appointed

Indicators

The dashboard the board will see every month

Days of stock

How much capital is sitting in the warehouse.

Measured byStock value ÷ cost of sales per day

Service level

How many order lines are fulfilled first time.

Measured byLines fulfilled ÷ lines ordered

Idle stock

Products that have stopped selling.

Measured byValue of products unsold for more than 6 months

Digital orders

Customer adoption of the portal.

Measured byOrders through the portal ÷ total orders

Margin by customer

Real profitability, after transport.

Measured byGross margin − delivery cost, by customer

Forecast accuracy

Confidence in the order proposals.

Measured byAverage forecast error per A product

Next step

Proposal: put the three recommendations into practice

01

What it includes

ABC classification and clearance plan, selection and set-up of the forecasting and replenishment tool, a new purchasing routine by ship, a pilot of the ordering portal and support through to the summer.

02

Duration and fees

A 5-month project, with fixed fees agreed before starting. Part of the diagnostic fee is credited if the project goes ahead within the following 60 days. Tool licences not included.

03

After the project

Active monthly support for six months, to see the high season through and prepare the review of margins by customer.

On the assumptions in this example, the project pays for itself in under two months from the estimated annual gain, without counting the capital released. Illustrative example: Navegante Distribuição is a fictitious company, created to show the format of a Sparkinnov Advisory Full strategic diagnostic; all data is illustrative. Part of the investment in a project of this kind may be eligible for regional support, to be confirmed case by case.

Full report

The document the board receives at the end of the diagnostic

This page summarises what is presented to the board. The full report adds the letter to the board, the methodology, a detailed analysis of each recommendation, the risks and how to mitigate them, the definition of the indicators and the assumptions behind every calculation.

It is the deliverable of the «Recommend and decide» phase of our method, after framing, diagnosing and designing options.

How we work
Navegante Distribuição: less idle stock, higher service levels Sent by email, once the request has been reviewed. Request the full report

Would you like a diagnostic like this for your organisation?

In a first meeting we define the scope, timeline and indicators with you.

Book a meeting