PDAs Budding in the Wine Industry
By Zillah Bahar
June 15th, 2002

Just six years ago, data collection in the vineyard was an unwieldy, paper and pencil affair for Eric Wylie, an agricultural engineer with Stimson Lane, a wine producer with 4,500 acres of vineyards throughout Washington State.

Whenever Wylie and his colleagues--four viticulturists and four technicians--went into the field to collect information about such matters as the number of buds per vine, crop damage following a hailstorm, or the distribution of beneficial insects, they had to record by hand every number and field note onto a form attached to a clipboard. The team then reentered the data into the company database stored in a central computer back at the home office.

The system gave rise to troubling inefficiencies.

The team had to return to the office just to type in data, a trip that could take as long as an hour-and-a-half. And everyone had to compete for time at a limited number of desktop computers there. Worst of all, staffers were inadvertently corrupting their own data. They made typographical errors and were prone to abbreviate detailed field notes. "If you have to touch data twice, the cost of the data starts skyrocketing," says Wylie.

As Wylie saw it, stemming such inefficiencies was a matter of eliminating the extra step. By 1997, the solution was, quite literally, at hand.

Wylie equipped his team with PalmPilots ranging in price from $150 to $350 and loaded with applications called Satellite Forms that he customized for data collection in the vineyard. Dispensing entirely with pencil and paper, team members now enter data directly into the handheld forms. When they return to their office, they need only a few minutes at a desktop computer to download the newly harvested information into the company database with the HotSync data transfer application.

"You can collect field notes without having to type in anything. The efficiencies that we gain are incredible," says Wylie, adding that the savings measured in terms of labor and equipment costs start to kick in after only 10 weeks.

The word has gotten out in the vineyards.

Renowned in his field for his facility with handheld devices, Wylie now receives calls almost weekly from colleagues at other winemaking companies eager to make the transition from clipboard to handheld computer, aka, personal digital assistant (PDA).

ScanControl, Inc., of Pleasanton, California, is a company that offers vineyard data collection tools for PalmŪ hand-held devices. This system is now used at Keefer Ranch in Sebastopol, California, and by Chateau Morrisett, in Virginia. The software allows users to collect data about activities performed on each vineyard row from pre-pruning to harvest. One can collect canopy management data, or record brix readings to understand more about the quality profile of a particular block or clone, and so forth.

"There's a lot of cause and effect analysis that is possible using these tools," ScanControl president Robin Wood says. "Vineyard managers can decide for themselves, which practices had the best outcomes in their operations and which of their clonal selections are performing best. This is even more useful in areas where a single vineyard manager has to manage multiple properties. You can track individual activities separately, which will allow you to assess your operating costs for each property. (ScanControl also has a package under development that tracks the production cycle within a winery.)

Vineyard specialists aren't the only ones in the wine business who are starting to recognize the timesaving potential of handheld computers. Like Stimson Lane's Wylie, professionals in other segments of the industry are doing much more with their PDAs than simply collecting email and updating their calendars and expense logs. While PDA technology does not yet play a major role in industry-specific business, it may be just a matter of time. There are compelling examples of wine companies and distributors getting in on the handheld act with applications that enable them to make rapid in-store audits of their products, obtain real-time inventory reports, even place orders automatically. And again, the value of the handheld computer in each one of these cases is as a tool that eliminates the need to fill out paper forms and reenter the data.

Brown-Forman Corp. has become an old hand at automating in-store audits using handheld technology.

It has been three years since the company hired Product and Acceptance Research (PAR) in Evansville, Ind., to develop proprietary software that would let 100 company sales reps scan or punch into a Palm-style Symbol SPT 1500s information such as the amount of product available in-store, the prices of competing products, and shelf locations. Before then, a rep had to fill out by hand a two-page, legal-size form for every store and, later on, type the information into a database. These days, data is transmitted directly from the handheld via phone modem.

"Data processing is where you save all the time," notes Mimi Zinniel, Brown-Forman's director of consumer research. While the company has not yet tracked the savings in terms of employee hours, Zinniel says the benefit is evident from the rapid turnaround.

PDAs Are Quicker

Gathering data with PDAs "gives the information we need so much quicker," she says. "Before it took two to three weeks. Now it's overnight."

The cost of developing this type of automation system is currently about $75,000, according to Skip Seaman, president of PAR.

A more recent adopter of PDA technology is the distributor Southern Wines and Spirits of California, which uses Windows CE handhelds as part of a newly automated sales process.

Up until 2001, SWS's sales reps were handwriting their orders and generating 500,000 sheets of paperwork per week. They could place the orders electronically over phone lines using a slow-moving data transfer system known as a Brick. But the system led to errors and fulfillment delays of up to seven days, and it couldn't provide sales reps with access to up-to-date information about inventories, prices, or a client's available credit.

SWS tackled the problem by hiring Advanced BusinessLink, a Kirkland Washington-based developer of a suite of Web-based Java applications for handheld computers called pocket Strategi®. The applications allow sales reps to use browser-like functions on the Windows CE device that links to an IBM iSeries server. The handheld, with up to 64 megabites of memory, can store most of the information sales reps need on clients and product availability. When the device is connected to the server, pocket Strategi® also allows the sales reps to automatically send orders and updates data that is stored on their handhelds.

SWS sales reps transfer data between the server and their handhelds via modem. But pocket Strategi® can also transmit data on a wireless network so that orders could be made in real time and other information could be updated continuously (unless, of course, the wireless connection is interrupted briefly because the sales rep has to conduct business in a basement.)

According to Steven Burrows, SWS vice president of sales and marketing, spirits, the combined costs of Advanced BusinessLink consulting fees, server usage and handheld equipment comes to about $3,000 per sales rep. But with just 700 reps using the device, SWS has started realizing significant cost savings, along with gains in employee productivity.

Adding to Sales Calls

Burrows says sales reps who use the handheld now make one to three additional sales calls per day. While he declines to site exact sales figures for privately held SWS, Burrows says that the new ordering system has already paid for itself by generating an annual sales increase of more than 5 percent. Additionally, thanks to greater order accuracy, customer returns have declined by 12 percent.

Given these efficiencies, SWS plans to have at least 2,000 sales reps equipped with the high-powered handheld by the end of 2003. Burrows says the next employees to be using PDAs on the job are sales merchandisers and delivery drivers. They will be using similar Web-based applications to facilitate what he terms "Web-based documentation" such as paperless signature capture.

Although the advantages of PDA use to the wine industry are significant, not even its most ardent champions claim the technology provides a perfect solution for all data entry and transfer needs.

Stimson Lane's Wylie notes that his handheld system cannot send data directly to a central database via a wireless connection, due to hilly geography and the remoteness of Stimson Lane's vineyards.

And despite the successes SWS has experienced with automating its sales process using handheld technology, the Advanced BusinessLink system is by no means one-size-fits-all solution. "A mom-and-pop winery could not take advantage of this," acknowledges.

Scott McBurney, vice president of business development for Advanced BusinessLink. McBurney notes that a company engaged in sales and distribution needs to have at least 50 users placing orders on PDAs to realize benefits like those enjoyed by SWS. (For smaller concerns there is Edward N. Eskind and Associates, a Nashville, Tennessee-based subsidiary of eSkyeSolutions, which offers an automated ordering system incorporating Windows CE devices that is suitable for as few as five users at a minimum cost of $12,000.)

Yet, the possibilities for handheld use continue to expand.

Wylie is beginning to make even greater use of existing handheld technology by introducing Palms with global positioning systems (GPS) capability that allow his team to match precisely vineyard locations with their corresponding data. Data mapped in this fashion helps the team discern variations in vineyard conditions and productivity over blocks as large as 100 acres.

Advanced BusinessLink's McBurney envisions leveraging existing PDA applications to store plan-o-grams (detailed maps for displaying products in retail stores) and marketing materials such editorial reviews, which could be distributed by sales reps equipped with small, mobile printers. In the same vein, PAR's Seaman urges using handhelds equipped with digital cameras to photograph displays that would become part of the in-store audit record and could be accessed on a PDA using a keyword search.

So far as SWS's Burrows is concerned, these applications are just the tip of the iceberg for PDA use in the wine industry. "I don't think we have figured out all the good things we can do with this," he says.

Zillah Bahar is a freelance writer based in Berkeley CA.

[ Top of Article | Press Release Index ]
[ BusinessLink in the News ]