Case Study: Graniterock integrates tracking, BI reporting to mine new efficiencies.
Suppliers for Wal-Mart Stores Inc. may have balked at having to deploy radio-frequency identification, but at Graniterock, in Watsonville, Calif., customers cant deploy the technology fast enough.
Since the construction company deployed RFID at all its locations, customers have benefited from a wealth of information based on the arrivals and departures of trucks through Graniterocks asphalt and quarry operations.
With more than 3 million pounds of granite, sand and other construction materials being loaded onto 600 trucks per day at the A.R. Wilson Quarry, Graniterocks largest, customers are happy to get as much information as possible.
During an on-site evaluation, eWEEK Labs was impressed by the efficiencies Graniterock has been able to attain by using its business intelligence reporting system in combination with RFID tagging. In fact, the company has been able to reduce by half the amount of time it takes to load customer trucks at its quarries.
The RFID project at Graniterock began in 2000. Steve Snodgrass, CIO of Graniterock, had already integrated Business Objects S.A.s Crystal Reports with PeopleSoft Inc.s Enterprise One enterprise resource planning and World change management applications. He decided to take Graniterocks BI a step further by using RFID tagging to collect data and then to track, manage, analyze and report on that operational data using Crystal Enterprise.
Working with Magenic Technologies Inc., a consulting firm in Minneapolis, Snodgrass deployed an RFID application called GraniteXpress 2, which was written using Microsoft Corp.s Visual Basic 6 and SQL Server 2000 and runs on Windows Server 2003. GraniteXpress 2, integrated with the Crystal Enterprise BI and reporting application suite, allows Graniterock to run reports that determine everything from supply chain efficiency to customer satisfaction.
Click here to read about a new Eclipse plug-in for Crystal Reports that will let developers add query and reporting capabilities to their open-source applications.
Graniterocks IT managers decided to take a page from the railroad industrys technology playbook and use RFID tagsthe same kind used to identify rail carson the companys trucks. The TC IP Ltd. passive tags (which transmit information but dont collect it) are mounted on the driver side of the trucks cab and collect data on inventory and supply movement. The RFID system processes the arrival and departure of trucks through the companys asphalt and quarry loading locations.
The night before a customers truck is scheduled to make a pickup, the customer calls Graniterock to provide information on the truck, including its RFID tag information, the load thats scheduled for pickup and the job for which the load will be used.
As a truck passes through a loading gate, the RFID tag is scanned, and the GraniteXpress 2 application determines which vehicle has entered the quarry and which company owns that truck. Electronic signs then automatically direct the truck driver to the loading station that has the materials the truck is scheduled to pick up. After the truck pulls into the loading station, the RFID system verifies the correct truck is in place, and then the construction materials are loaded. A checkout station then reads the RFID tag again, weighs the truck and prints a receipt.
The data is also used by Graniterock to generate billing invoices.
At the end of each day, Crystal Reports queries the companys Microsoft SQL Server database for information on the pickups that occurred that day and e-mails a report on each truck and its load to the trucks owner.
Customers use the reports to determine how quickly a particular construction job is progressing and how efficient their supply chains are.
"We now have statistics we can provide to our customers on how well each truck is doing," Snodgrass said. "Crystal Reports enables us to provide a customer with complete visibility of whats going on in their organization so that they can compare the performance of different trucks and ask certain drivers why they were late."