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.