Ivey Publishing

Product Details

Landhills Winery: Developing an Optimal Blending Plan
Product Number:
9B14E006
Publication Date:
05/21/2014
Revised Date:
05/12/2014
Length:
3 pages (2 pages of text)
Product Type:
Case (Gen Exp)
Source:
Ivey
A senior vintner at Landhills Winery (Landhills) has been put in charge of developing an optimal blending plan for the upcoming season. This assignment is the result of a recent Landhills board meeting where the chief executive officer presented her ideas regarding the use of analytics for enhancing profits while at the same time not affecting quality. Specifically, the use of resource optimization could significantly improve Landhills’s profitability. Industry reports have indicated that a growing number of major wineries are using analytics to assist in the wine-blending process. The board meeting concluded with the CEO tasking the senior vintner with developing an analysis and reporting back his findings to the board at next month’s meeting.
Learning Objective:
This case can be used in a core decision sciences or operations management graduate-level course. It focuses on the use of linear programming to develop an optimal production plan. Students are to develop a linear model in Microsoft Excel and solve the model to determine the optimal production. Furthermore, sensitivity analysis needs to be performed to answer various production questions. The case learning objectives include the following:
  • To appreciate how blended wines are produced.
  • To understand how linear programming can be used to develop an optimal blending mix.
  • To use Excel for developing a linear programming case solution.
  • To conduct sensitivity analysis on key model variables.
Issues:
Disciplines:
Management Science,  Operations Management
Industries:
Accommodation & Food Services
Setting:
United States, Medium, 2013
Intended Audience:
Undergraduate/MBA
Price:
$5.30 CAD / $5.00 USD Printed Copy
$4.50 CAD / $4.25 USD Permissions
$4.50 CAD / $4.25 USD Digital Download
You Might Also Like...

Save In: