- 130
- 10
- Joined
- Jun 27, 2004
anyone with linear programming prowess, i need some help on this hw problem:
Forthe following problem, all work must be shown and if hand-written must belarge, clear, and legible. Below is the problem and the data table to supportworking the problem is attached.
Problem:
Awinery has the following capacity to produce an exclusive dinner wine at eitherof its two vineyards at the indicated costs (see attached table 1). Four Italian restaurants around thecountry 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 willingto pay are summarized in the following table (see table 2 attached).
Thecosts of shipping a bottle from the vineyards to the restaurants are summarizedin the following table (see table 3 attached). The winery needs to determine the production and shippingplan that allows it to maximize its profits on this wine. Provide the followingand show ALL WORK:
a)Formulate LP problem (prefer typing, but if written must be very clear andcomplete)
b)Create spreadsheet model (show screen shot from computer, using Excel/Solver)
c)What is optimal solution? Must show all work and can write versus type, butMUST BE CLEAR and LEGIBLE. See attachment that contains 3 tables referenced inproblem.
Table1
[table][tr][td]
Vineyard
[/td] [td]
Capacity
[/td] [td]
Cost per Bottle
[/td] [/tr][tr][td] [h2]1[/h2] [/td] [td]
3,500 bottles
[/td] [td]
$23
[/td] [/tr][tr][td] [h2]2[/h2] [/td] [td]
3,100 bottles
[/td] [td]
$25
[/td] [/tr][/table]
Table2
[table][tr][td]
Restaurant
[/td] [td]
Maximum Demand
[/td] [td]
Price
[/td] [/tr][tr][td] [h2]1[/h2] [/td] [td]
1,800 bottles
[/td] [td]
$69
[/td] [/tr][tr][td] [h2]2[/h2] [/td] [td]
2,300 bottles
[/td] [td]
$67
[/td] [/tr][tr][td] [h2]3[/h2] [/td] [td]
1,250 bottles
[/td] [td]
$70
[/td] [/tr][tr][td] [h2]4[/h2] [/td] [td]
1,750 bottles
[/td] [td]
$66
[/td] [/tr][/table]
Table3 (cost of shipping a bottle from the vineyards to the restaurants aresummarized in the table below)
[table][tr][td]
Vineyard
[/td] [td]
1
[/td] [td]
2
[/td] [td]
3
[/td] [td]
4
[/td] [/tr][tr][td] [h2]1[/h2] [/td] [td]
$7
[/td] [td]
$8
[/td] [td]
$13
[/td] [td]
$9
[/td] [/tr][tr][td] [h2]2[/h2] [/td] [td]
$12
[/td] [td]
$6
[/td] [td]
$8
[/td] [td]
$7
[/td] [/tr][/table]
Forthe following problem, all work must be shown and if hand-written must belarge, clear, and legible. Below is the problem and the data table to supportworking the problem is attached.
Problem:
Awinery has the following capacity to produce an exclusive dinner wine at eitherof its two vineyards at the indicated costs (see attached table 1). Four Italian restaurants around thecountry 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 willingto pay are summarized in the following table (see table 2 attached).
Thecosts of shipping a bottle from the vineyards to the restaurants are summarizedin the following table (see table 3 attached). The winery needs to determine the production and shippingplan that allows it to maximize its profits on this wine. Provide the followingand show ALL WORK:
a)Formulate LP problem (prefer typing, but if written must be very clear andcomplete)
b)Create spreadsheet model (show screen shot from computer, using Excel/Solver)
c)What is optimal solution? Must show all work and can write versus type, butMUST BE CLEAR and LEGIBLE. See attachment that contains 3 tables referenced inproblem.
Table1
[table][tr][td]
Vineyard
[/td] [td]
Capacity
[/td] [td]
Cost per Bottle
[/td] [/tr][tr][td] [h2]1[/h2] [/td] [td]
3,500 bottles
[/td] [td]
$23
[/td] [/tr][tr][td] [h2]2[/h2] [/td] [td]
3,100 bottles
[/td] [td]
$25
[/td] [/tr][/table]
Table2
[table][tr][td]
Restaurant
[/td] [td]
Maximum Demand
[/td] [td]
Price
[/td] [/tr][tr][td] [h2]1[/h2] [/td] [td]
1,800 bottles
[/td] [td]
$69
[/td] [/tr][tr][td] [h2]2[/h2] [/td] [td]
2,300 bottles
[/td] [td]
$67
[/td] [/tr][tr][td] [h2]3[/h2] [/td] [td]
1,250 bottles
[/td] [td]
$70
[/td] [/tr][tr][td] [h2]4[/h2] [/td] [td]
1,750 bottles
[/td] [td]
$66
[/td] [/tr][/table]
Table3 (cost of shipping a bottle from the vineyards to the restaurants aresummarized in the table below)
[table][tr][td]
Vineyard
[/td] [td]
1
[/td] [td]
2
[/td] [td]
3
[/td] [td]
4
[/td] [/tr][tr][td] [h2]1[/h2] [/td] [td]
$7
[/td] [td]
$8
[/td] [td]
$13
[/td] [td]
$9
[/td] [/tr][tr][td] [h2]2[/h2] [/td] [td]
$12
[/td] [td]
$6
[/td] [td]
$8
[/td] [td]
$7
[/td] [/tr][/table]
