quantitative operations management代写

## Fisher Vineyards Winery

quantitative operations management代写 The winery needs to determine the production and shipping plan that allows it to maximize its profits on this wine.

 A winery has the following capacity to produce an exclusive dinner wine at either of its two vineyards at the indicated costs:

 Four Italian restaurants around the country are interested in purchasing this wine. Because the wine is exclusive, they all want to buy as much as they need but will take whatever they can get.The maximum amounts required by the restaurants and the prices they are willing to pay are summarized below:

### Winery: Continued

 The cost of shipping a bottle from the vineyard to the restaurant are summarized below:

 The winery needs to determine the production and shipping plan that allows it to maximize its profits on this wine.

 Formulate a model for this problem, create a spreadsheet model and solve it.

 Create the sensitivity report and use it to answer the following questions

### Winery: Questions  quantitative operations management代写

Part 1: Optimization questions

 What is the optimal delivery schedule and what is the associated profit for Fisher Vineyards?

Part 2: Insight-generating questions

 How much would winery’s profit change if the bottling capacity at vineyard 1 was increased from 3500 to 3900 bottles?

 Would Fisher Vineyards benefit from increasing the capacity at either of the vineyards? Why or why not? If they are, then is increasing capacity at vineyard 1 is better than at vineyard 2 or the other way around? Why?

 Should the winery negotiate higher maximum amount of wine required by restaurant 4? Why or why not?

 If the winery were to negotiate a 100 bottles increase in maximum amount required by one restaurant, which restaurant should they negotiate with?

 What is the profit that winery makes on 1 bottle delivered from vineyard 1 to restaurant 1?

### Winery: English to Math  quantitative operations management代写

 Objective? Decision variables?Constraints?

 How is profit calculated? Write the expression as a function of decision variables (step by step: revenue, cost…)

 Write the constraints “in math”

 Now translate that into Excel: model

 Use Solver to optimizeWinery: Questions

### Part 1: Optimization questions

 What is the optimal delivery schedule and what is the associated profit for Fisher Vineyards?

### Part 2: Insight-generating questions

 How much would winery’s profit change if the bottling capacity at vineyard 1 was increased from 3500 to 3900 bottles?

 Would Fisher Vineyards benefit from increasing the capacity at either of the vineyards? Why or why not? If they are, then is increasing capacity at vineyard 1 is better than at vineyard 2 or the other way around? Why?  quantitative operations management代写

 Should the winery negotiate higher maximum amount of wine required by restaurant 4? Why or why not?

 If the winery were to negotiate a 100 bottles increase in maximum amount required by one restaurant, which restaurant should they negotiate with?

 What is the profit that winery makes on 1 bottle delivered from vineyard 1 to restaurant 1?