Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Eternity Valley Vineyards produces three kinds of wine: Blanc, Red, and Blush. The company has 17 tons of grapes available to produce wine this season.

image text in transcribedimage text in transcribed

Eternity Valley Vineyards produces three kinds of wine: Blanc, Red, and Blush. The company has 17 tons of grapes available to produce wine this season. A cask of Blanc requires 0.21 tons of grapes, a cask of Red requires 0.24 tons, and a cask of Blush requires 0.18 tons. The vineyard has enough storage in its aging room to store 80 casks of wine. The vineyard has 2,500 hours of production capacity, and it requires 12 hours to produce a cask of Blanc, 14.5 hours to produce a cask of Red, and 16 hours to produce a cask of Blush. From past sales, the company knows that demand for the Blush will be no more than half of the sales of the other two wines combined. The profit for a cask of Blanc is $7,500, the profit for a cask of Red is $8,200, and the profit for a cask of Blush is $10,500. Using the attached computer solution for this problem, answer the following questions: a- What is the optimal solution? b- What are the optimal values of the solution? c- Identify and explain the shadow prices for the resource constraints. d- Identify any unused resources. e- Identify and explain the sensitivity ranges for the objective function coefficients. f- Identify and explain the sensitivity ranges for the constraint quantities. g- What would happen to the solution if the company were to decrease the profit of Red to $7,600 ? What if this profit were decreased to $7,400 ? h- Among all the resources, which one is the most valuable to the company? i- If the vineyard could obtain 0.5 more tons of grapes, 500 more hours of production capacity, or enough storage capacity to store 4 more casks of wine, which should it choose? j- All three wines are produced in the current solution. How little would the profit for Blanc have to be for the current optimal values to change? D. Linear Programming Results Solution \begin{tabular}{|l|l|l|l|l|l|l|} \hline & X1 & X2 & X3 & & RHS & Dual \\ \hline Maximize & 7,500 & 8,200 & 10,500 & & & \\ \hline Tons of grapes available & 21 & 24 & .18 &

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Small Business Management Launching & Growing Entrepreneurial Ventures

Authors: Justin Longenecker, William Petty, Leslie Palich, Frank Hoy

17th edition

9781285972565, 1133947751, 1285972562, 978-1133947752

More Books

Students also viewed these General Management questions