|Ray Rouleau of VIP (photos by Bob McClenahan)
Daily transactional data for three-tier wine sales will soon be widely available to wineries, a breakthrough that stands to transform the way wineries track and manage an estimated $1.8 billion in annual depletion allowances.*
The sweeping change is underway at Vermont Information Processing (VIP), an industry software and information provider that has long supplied daily depletion data to the beer industry.
VIP purchased Beverage Data Network (BDN), a supplier of wholesaler depletion data to the wines and spirits industry, in July 2015. Then in January 2017, VIP quietly purchased TradePulse, a depletions data provider focused largely on California wineries.
BDN and TradePulse customers receive month-end retail and depletions summary reports but VIP has the ability to provide invoice-based data via wholesalers that’s downloaded daily, taking it to the next step. The company plans to shift all TradePulse and BDN customers to its daily Supplier Reporting Services (SRS) system within the next twenty-four months.
“Wine is on the journey to a new source of truth,” Ray Rouleau from VIP said.
Rouleau was speaking at the Wine Industry Technology Symposium in Sonoma and his presentation was followed by two sessions where winery executives delved into the details of managing data for three-tier sales.
Rouleau said daily transactional data is already available through 2200 distributors and that a significant number already provide data to TradePulse and BDN. During 2018, VIP will continue using BDN file formats while the TradePulse file formats wholesalers generate will be retired.
Depletions reporting is used by wineries to set sales targets, distribution targets, and to measure performance for depletion allowances. The data is sourced from accounts receivable and warehouse management system data.
Depletion data tells wineries how distributors, retailers, and restaurants are selling their products. Once wholesalers have wine in hand, the sale of the wine to retail accounts and to consumers – depletions – are outside the view of the winery. This was a source of frustration for years, but most wholesalers now share this data with wineries and third-parties that can help wineries manage depletion data.
Third-party services typically provide what the distributors received, i.e., winery shipments, depletions, i.e., what they sold to the trade, and remaining inventory. Then taking it down another level, depending on what one pays for, they can provide retail account data – depletions by account. Account-level data can be critical for determining where sales personnel need to focus. Account level data can then be analyzed further, giving a winery a leg up in promoting their wines or with pricing them. This data comes in in different formats and there are a number of companies that sit in the middle to digest that information and deliver it in a usable, monthly report.
Having access to account level data on a daily basis, however, is a game changer. Wineries will be able to react almost immediately to sales, pricing, and inventory trends while theoretically they’ll be on the same page as their distributors when they’re setting goals.
While a distributor typically handles sales costs, wineries need to account for depletion allowances - promotional expenses offered to the distributors. They provide an incentive for the distributor to deplete inventory and those costs can be huge (the estimated at $1.8 billion a year).
Currently, there's no direct data connection between chargebacks and depletions; supplier pricing deals are entered into distributor systmes manually, if at all; chargebacks are generated by the distributor manually; chargebacks are reconciled to depletions manually by the supplier, and only the "tip of the iceberg" are ever actually reconciled.
“Once you have invoice-level data, its fact based. It’s exactly what’s happening and it’s going to affect your price planning,” Rouleau said.
Rouleau noted that once wineries get used to invoice level data on a daily basis and to the visibility it provides, they’ll need to align the data with planning; and will want to look at bill-backs to see if they’re close to what was forecasted. A next step, though it’s a ways away, would be to arrange for automatic reimbursement for billbacks, a practice that’s already common in the beer industry.
“The wholesalers are very excited to deal with one company, one process, and to have one source of truth to talk to their suppliers about,” Rouleau said.
WITS Expands in 2017
In its second year being produced by Wine Business Monthly, winery attendance at WITS rose 50 percent. There were more than 300 attendees including nearly two-dozen distributors. The event included a new technology tent where more than a dozen technology companies provided hands-on demos in a lab setting. The “Demo Stage” featured larger group presentations throughout the day. The symposium included three session tracks – a data track, an IT track, and a direct sales (DTC) track – as well as roundtable sessions with informal discussions on 12 topics.
Note: The June '17 Wine Business Monthly includes a technology survey – the first comprehensive survey of IT practices for wineries, focused on what software wineries are currently using, what their IT priorities are, i.e. where they’re spending their money.
• $1.8 billion based on bw166 and Wines & Vines Analytics (Gross industry revenue for 2016 of $59.9 billion) and VIP estimates
|Keynote Speaker Matthew Glickman, VP Product, Snowflake (former Managing Director & Chief Data Officer, Goldman Sachs) speaks about the future of the Cloud
|WBM Publisher Eric Jorgensen|
|Panel, Using Technology to Captivate Your Distributor
|Best Practices in Utilizing Depletions and RAD data
|Capturing consumer touch point data for a 360-degree view of the customer|