21
Sat, Dec
3 New Articles

Crush Me, Squeeze Me, Make Me Wine

Commentary
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

Grapevines tended with multigenerational devotion cover the hillsides in arching rows. They dominate an idyllic landscape of placid symmetry, as neat and orderly as a Disney attraction. The harmonized uniformity of the land is occasionally interrupted by grand buildings that sit like gaudy jewels on the knuckles of landscaped knolls. The conspicuous wineries of the Napa Valley are both a statement and an invitation: a statement of stunning attainment and an invitation to partake in the product that defines the region. Welcome to Wine World.

On the eastern side of the Napa Valley, just off the Silverado Trail, nestled in a secluded, park-like setting, sits Stag's Leap Wine Cellars. In 1974, Stag's Leap was a modest, family-owned operation with no employees and just enough temerity to enter a Paris wine tasting. Its submission was a cabernet unpromisingly dubbed "Cask 23" for reasons of anonymity and as a deterrent to judging bias. To the surprise of the French, who can be bellicose in matters of wine, the vintage won. Since then, Stag's Leap has enjoyed growing popularity, and the Winiarski family now employs 40 full-time workers and an additional 30 seasonal pickers, whose combined efforts produce 75,000 cases of wine each year.

"With growth came the need for automation," said Linda Forrette, Stag's Leap's MIS manager. In 1988, the winery purchased an AS/400 B10 to replace a cumbersome DEC system. It has since been upgraded to an F10. Forrette came aboard in 1989 to head the migration and to satisfy the demanding reporting requirements of the Bureau of Alcohol, Tobacco, and Firearms (ATF). The astute reader will recall that ignoring the ATF may turn into a matter of some gravity. When a regulatory agency has access to tanks, the prudent company will choose to send in those government reports on a timely and accurate basis.

Modern wine-making is a complex trade that includes elements of agribusiness, process manufacturing, marketing, and distribution. It is complicated further by draconian federal regulation. To support all of these business components, Stag's Leap chose a package affably christened WIMS: Wine Information Management System. It is the product of a Sonoma-based software and services firm, Gulson & Associates. The package, now installed in 35 wineries, was originally developed in the late '70s and has had a symbiotic relationship with IBM's midrange systems dating back to the S/34. It was designed to support medium to large wineries that do their own distribution. Modules include case goods inventory, government compliance, order processing, invoicing, sales analysis, and standard financials: accounts payable, accounts receivable, and general ledger.

The challenge for Stag's Leap was to establish order and inventory links between its cellar and its five warehouses, two of which are equipped with their own AS/400s. At some point in the future, those links may be extended to a rather large cave, but more on that later. Additionally, the winery has a retail/tasting room where point-of-sale transactions must be captured and uploaded to the host system.

Rejecting a full network implementation, Stag's Leap linked its computerized warehouses by modem to the host AS/400. "It's a low-cost, low-maintenance solution," said Forrette. The host system transmits orders and the warehouse system generates a bill of lading, from which workers pick cases of wine for shipment. Inventory levels are automatically adjusted. The noncomputerized warehouses receive faxes from the host AS/400. "Anything you can spool for printing, you can fax without paper," noted Forrette. "It saves us a lot of time and assures absolute accuracy." The winery's retail activity is captured on a PC and uploaded nightly to the AS/400.

Government reporting requirements are arcane and must be submitted on forms that appear to have been created during prohibition. The ATF has a pit bull fixation on the manufacture, sale, movement, and storage of things alcoholic. Not that it is the guardian of national sobriety; rather, that the government is intent on profiting from pleasure. Between 3-4 percent of the cost of each bottle of wine goes directly to federal taxes; that's over $1.00 per gallon. For good measure, the state tacks on another $.20 per gallon.

By federal fiat, the owner of the storage facility, not necessarily the owner of the wine, must report the movement of product and the remaining balance in bonded inventory. Wineries, in turn, are required to report how much product they bottle, how much bulk wine they purchase from outside vintners, how many cases have been transferred to bonded inventory (stored wine is not taxed until it is actually sold), and how much juice is left after the production process. The amount of excise tax varies with the alcohol content of the wine.

With multiple storage facilities and different varieties of wine, the manual calculations required to assess the company's tax liability were a nightmare, according to Forrette. "Now, the AS/400 automatically calculates sales and inventory by type, and twice each month it generates the required report. All it needs is a signature."

Wine-making is primarily a process, not a project. Years pass before many wines reach maturity, which makes the ancient art of wine-making dependent on modern storage technologies. At any given time, Stag's Leap may store up to 100,000 cases of wine that must be kept at precise and constant temperatures. A superior vintage can easily spoil if it is aging in substandard storage facilities.

The five warehouses Stag's Leap employs are carefully regulated to maintain ideal temperature and humidity. But power costs are high, and brownouts during hot California summers are not uncommon. To avoid the vicissitudes of public utilities, Stag's Leap is digging itself an innovative and time-honored solution. It is gouging a 30,000 square foot maze of caverns beneath Napa's rolling landscape. Underground, the temperature is a uniform 55 degrees year-round, and power to support an artificial environment is not an issue.

The symmetry of it is appealing. Ten thousand years after emerging from the cave, humankind returns, but this time armed with a selection of fine wines and an AS/400. Add a phone line and a modem, and I know more than one self-proclaimed computer nerd who could be quite happy there.

Currently, five PCs, eight terminals, three AS/400s, and three printers constitute the winery's hardware complement. "We want to move toward a client/server implementation," said Forrette. Stag's Leap, she said, will soon upgrade to a client/server version of WIMS. "We will install Windows on our PCs and give our users the ability to download information from applications like Excel and Lotus." The winery expects to continue growing and anticipates that the increased flexibility of a client/server environment will support its growth into the next century.

Since its heady win at the Parisian competition, Stag's Leap Wine Cellars has received a number of accolades but none, perhaps, more notable than a recent endorsement. "The White House called and ordered some chardonnay," recalled Forrette.

It was reassuring to know that, whatever government's failings, good taste wasn't among them. But given the recent budget squabbles and partial government shutdowns, I couldn't help but wonder, "Did they pay for it?"

"It took awhile," she said, "but eventually they did."

My faith in governance restored, I pondered the implications of having the White House in your accounts receivable system: It sure must be nice to send the government a bill for a change.

Victor Rozek has 17 years of experience in the data processing industry, including seven years with IBM in Operations Management and Systems Engineering.

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: