Decision support system for Wamakersvallei Winery

Abstract

The goal of the study is to lend decision support to management a a wine cellar in three areas of expertise, with Wamakersvallei Winery serving as a special case study. This decision support system is to be delivered in the form of Excel spreadsheet models. The three features of the decision support system are first to assist in the scheduling process of assigning grapes from the different suppliers to the different tipping bins by suggesting rapidly and in an automated fashion a possible schedule based on the information currently considered when making such decisions. The second is to assist the viticulturist in the sometimes difficult rescheduling decisions when the agreed upon amount of grapes cannot be delivered to the cellar due to unforeseen technical or operational problems. The third and last feature of the decision support system is to assist in solving a layout problem concerning the floor plan and pipelines for a cellar. This feature should be able to evaluate current renovation of current facilities.