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?
更多代写:会计online quiz代考 gmat线上考试作弊 环境艺术类网课代修 英文改写网站 英文論文寫作 量化运营管理代写