College of Business {College of Business}

Image: Photos of SF State students

A Novel Problem for a Vintage Technique: Matching Wineries and Distributors with Mixed Integer Programming

Directory : Faculty : Intellectual Contributions

Intellectual Contribution by Susan Cholette

Contribution Title

A Novel Problem for a Vintage Technique: Matching Wineries and Distributors with Mixed Integer Programming

Publication

Interfaces

Co-author

Year

2007

Description

Wineries must find distributors to represent their wines, and distributors seek interesting wines to sell to clients. Wineries and distributors often form partnerships at trade shows. I created a system to qualify potential partnerships for one such trade show, the World Wine Market, by formulating a mixed-integer program that is an embellished transportation model. I based its parameters on answers to a questionnaire I obtained from a subset of trade-show attendees who were seeking partners. Of 675 possible matches between wineries and distributors, the program recommended 31 as the optimal set of matches. This resulted in an allocation of just over 50,000 cases of wine. Participants provided positive feedback. In addition, the program introduced at least one winery and a corresponding distributor who have formed a profitable, long-term partnership.

Complete Citation

This article resulted from work down for the 2005-7 BIE grant awarded to several SF State CoB professors, myself included.

Website

See Faculty: Susan Cholette

SF State Home