學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Landhills Winery: Developing an Optimal Blending Plan
內容大綱
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.
學習目標
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:<ul><li>To appreciate how blended wines are produced.</li><li>To understand how linear programming can be used to develop an optimal blending mix.</li><li>To use Excel for developing a linear programming case solution.</li><li>To conduct sensitivity analysis on key model variables.</ul></li>