From: JTP PR on
(CRN Magazine) Logistics is getting smarter thanks to data warehousing
and business intelligence.
When logistics systems run well they re like the umpire at a cricket
match. We all know that they re around but we don t really notice
them. But if they make a mistake then the spotlight shines brightly on
their every move.

Today s supply chain is far less forgiving and demands greater
efficiency and bang for buck than it ever has. A number of
technologies allow businesses to wring out every dollar of value from
the supply chain.

And it s two older technologies that we re seeing as the main enablers
of this change: RFID and business intelligence.

With many years of experience in warehousing and logistics Stuart
Jones national transport manager of McKey Distribution says that the
last few years have been about data convergence.

Distribution companies can pull data from several sources and combine
it into a single system that can predict or explain problems.

"It s the meeting of different types of source data such as
telematics route management into a visible and usable system that can
enhance operations especially in day to day activities. That would be
the key thing."

McKey Distribution delivers food products to over 800 hundred delivery
points right across the country. It boasts two of the longest delivery
routes in the world running 2800 and 3200 kilometres. The distributor
delivers food that needs temperature control and can have a short
shelf life. When the supply chain is working at its optimal McKey
knows food can arrive to its customers on time and in good condition.

McKey Distribution uses software from Infor. Route Pro is used to
manage the complexity of a supply chain that is time-critical. It
manages stock picking from the warehouse based on expiration dates and
takes into account delivery times so that the customer gets a product
that is fit for consumption.

David Fenner manager of the industry development group at Motorola
Enterprise Mobility Solutions agrees that the assimilation of more
data sources has been the most important trend of recent years. His
group is tasked with bringing solutions to the global market.

"The point of activity has been a movement from data capture within
the four walls to data capture outside the four walls. There are more
solutions using a wide variety of remote communications " he says.

Despite the trend to collect data throughout the supply chain the
technology that was meant to deliver data from manufacture to disposal
- radio frequency identification (RFID) - hasn t been universally
taken up.

Chris Stephenson Australian managing director for Manhattan
Associates says there hasn t been a significant uptake of this
technology.

"Things like the Walmart initiative which received a lot of play a
few years ago now is not being actively pursued. Although that s not
been publicly announced there s not a lot of pressure [from Walmart]
on suppliers." Manhattan Associates sells supply chain software and it
has hundreds of customers in Australia; not one is using RFID even
though the software supports it. RFID is "a nascent technology purely
because it s a technology trying to find a solution. It s turned into
a closed solution benefit " says Fenner.

RFID has been around for quite some time. Modern systems were patented
about 40 years ago and are found all over the place. One of the most
common applications is in the e-tags used by toll road operators to
collect revenue and track traffic movements.

Active RFID tags contain a battery and transmit data to a receiver
without any external stimulus. Passive tags don t have a battery and
react to an external signal to provide data. However there are
battery assisted passive tags that lay dormant until they receive an
external signal.

As well as providing a tracking mechanism RFID tags can store data as
product information. For example beef exporters provide information
about the source of a cut of meat as the path it has taken through the
supply chain. The RFID tag can be on the actual product on the
packaging or on the pallet.

Australian RFID provider Ramp delivers tracking solutions to many
different industries. In one project the company assisted Optus with
asset tracking. While many companies use barcodes to label equipment
the codes can only be read when you can see the asset. With an RFID
tag the reader can read the tag without it being in line of sight.

Ramp deployed its OnRamp Asset Tracker program at Optus to track the
movement not just of tagged items but which member of staff (who
carried their own tags) had moved them.

Similar systems can be used for document tracking as well. RFID
document trays can be used to find lost documents but they also offer
huge security benefits. Where a document can only be viewed by a
limited group of people or can t be removed from the office an RFID
system can be used to track possession and set off an alarm if someone
tries to take a document past a secure perimeter.

RFID was touted as an open solution that would deliver a whole of
supply chain view. However it s ended up being used within specific
parts of the supply chain. "If you look at a container trucking
solution RFID could be ideal because you re in control of every asset
and know all the bits of information you re providing " says Fenner.

"When you take this to an open system you re not able to define all of
the information that could be collected or the quality of it. That s
why RFID has struggled in the mainstream."

"RFID will deliver an explosion of data" that will lead to "telco
styles level of data" predicts Glen Rabie CEO of Yellowfin a
business Intelligence solution provider. Whereas in the past the
measurement of the supply chain was quite coarse RFID will allow
collection of highly detailed nearly real-time data every fifteen
minutes.

Rabie says RFID was a technology ahead of its time. "The use will be
customer rather than supplier driven when customers want to know the
entire life of a product. It s currently a non-event but when large
logistics companies start to use it it will become expected " he
says.

"There was an awful amount of hype more than was justifiable but the
technology will mature. It was held back by the ability to manage the
data volume that was being created [and analysed]. We ended up
collecting all this data but couldn t process it so it was useless."

The technologies around RFID have caught up and have really matured
over the last three or four years especially with the invention of
Google Maps which companies can use to plot information collected by
RFID tags.

"Now we re able to deal with the billions of rows of data and we can
use GIS [geographic information systems] to map data. We used to have
GIS gurus in the backrooms but we can now expose it to management "
says Rabie.

The issue of dealing with all that data might be OK for a large
company with a big IT department and a generous budget but what about
SMEs? Rabie s view is that the providers of RFID gear will offer a
full service where they supply the hardware collect the data and
process it for you as part of a subscription service.

So when should SMEs look at dedicated logistics solutions? "Typically
we see there are three reasons why businesses start to look at a
dedicated solution " says Stephenson. "They ve used their accounting
system or spreadsheets or a combination to run their warehousing and
transportation. Eventually they either want to improve their customer
service improve their inventory accuracy or improve their own
efficiency."

Many companies on a growth trajectory need systems that can scale.
They want to know that their systems will work when they add staff and
move into a larger distribution centre. They re also looking for
flexibility so that can be more reactive to their customer s demands
and more nimble with their product offerings.

All of this has driven another significant change in modern logistics
technology. It s all getting a lot more user-friendly. Customisation
and configuration is now more available to staff on the floor rather
than needing the IT department if they have one to make system
changes.

Web-based programs becoming popular let customers access systems to
find out what inventory is available and determine the status of their
order.

One of the challenges many companies face is the seasonality of their
work. For example in the fruit picking industry more staff are
required during certain times of year. Manhattan s solutions for SMEs
have an interesting take on this.

Rather than making the customer invest in bar code scanners or RFID
readers for a work force that might only be in place for a few weeks
of each year they use a paper-based system that can be scaled up as
needed without significant capital investment.

The role of business intelligence tools has come to the fore. Jones
from McKey Distribution houses all information in a data warehouse
and uses business intelligence for "total visibility".

"I have a dashboard running that tells me what my loaders are doing. I
can see what my assets are doing and how we are in lead times and
other customer satisfaction measures " says Jones.

There are many BI tools to choose from. One of the challenges is to
find a tool that integrates with your ERP or logistics platform.

In the SME space Yellowfin has worked with Australian company
Translogix to develop solutions to optimise warehouse fleet and
routes. Yellowfin deploys services to customers who need logistics
systems but don t want to live with the hassle of installation and
maintenance.

Translogix now uses a reporting system that lets it monitor key
performance indicators so customers can identify and track issues as
they arise. It helps the company make better strategic decisions for
the long term improvement of the supply chain. This solution is
delivered to Translogix clients who require the reporting.

Supply chain reporting includes alerts when problems arise
longitudinal reporting to uncover trends and comparative and
operational reporting.

However Rabie thinks that we re on the cusp of a change.

"I recently downloaded a book on reporting from 1939 and not much has
changed other than the volumes of data. But one big difference with
today is real-time predictive analytics. That s what Yellowfin will be
changing to - the ability to mine the data on the fly and start
churning out models.

"We ll be able to see in the middle of the day that a truck won t be
able to complete its run by 3:00 pm so we can get another truck onto
the route to do the next run. This will make logistics more like
financial markets in the way they manage and react to incoming data
more rapidly."

It s likely that other data sources outside the direct control of the
supply chain manager will become part of the equation. For example
real time traffic and weather forecasts factors that can have
significant impact on supply chain efficiency can be pulled in to
provide a fuller picture and to make more accurate predictions.

The great challenge for SMEs is to remove inefficiency so less time is
wasted and fewer tasks need repeating. The most expensive problem to
rectify is a missed delivery that has to be done again. When those
issues are solved not only are costs optimised but service to the
client is improved.

To avoid those issues businesses need to move beyond home-grown
spreadsheets and inflexible accounting software with a logistics "bolt
on" and find a solution that offers flexibility and reliability.

Businesses without their own IT department don t need to miss out as
third party service providers might start selling not just the
hardware but the ability to collect and package the data on the
businesses behalf.