III. Optimizing Performance For the Lodi Winery, you have been asked by management to examine the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
III. Optimizing Performance For the Lodi Winery, you have been asked by management to examine the data collected and analyzed in the previous modules. The mobjective is for you to help management decide on the right mix of wine bottles to sell based on newly derived profit information while considering the limitations of the particular types of grapes available for production. tic While doing more research on wine production, you realize that it takes 3.5 pounds of grapes to make a bottle of wine. In addition, you already were provided the price per bottle that the distributors are paying for each variety of wine: Price for Red Wine Price for White Wine Price for Organic Wine ($) 7.5 ($) ($) 8 12 white axim After discussing wine production with the operations manager, you also learn that the wineries that supply the grapes to produce the above types of wine can produce up to a total of 200,000 pounds of grapes for a six-month supply of wine bottles for the three markets, with the following expected distribution constraints based on types of grapes. Note that current market demand will not support more than the below constraints for each type: Red wine ceiling 22,000 bottles White wine ceiling 24,000 bottles Organic wine ceiling 12,000 bottles Note that the production cost per bottle remains the same as before, that is, 32% of sales or revenue for red wine, 42.5% of sales for white wine, and 52.5% for organic wine. With additional information you have gathered, you are now ready to determine the optimum production mix to maximize profit. Solver Parameters Set Objective: To: Max By Changing Variable Cells: $B$3:$D$3 Subject to the Constraints: $B$3:$D$3 >= 0 $I$2 1 2 Profit A B Red C White 0 D Organic 0 0.00 3 Bottles 4 Production Cost Per Bottle 2.40 3.40 6.30 5 Wholesale Price Per Bottle 7.5 8 12 6 Profit Per Bottle 5.10 4.60 5.70 7 Pounds of Grapes 8 9 Total E 0.00 F G H Red Constraints J K 22,000 22,000 White 24,000 24,000 Organic 12,000 12,000 LBS of grapes 200000 200000 III. Optimizing Performance For the Lodi Winery, you have been asked by management to examine the data collected and analyzed in the previous modules. The mobjective is for you to help management decide on the right mix of wine bottles to sell based on newly derived profit information while considering the limitations of the particular types of grapes available for production. tic While doing more research on wine production, you realize that it takes 3.5 pounds of grapes to make a bottle of wine. In addition, you already were provided the price per bottle that the distributors are paying for each variety of wine: Price for Red Wine Price for White Wine Price for Organic Wine ($) 7.5 ($) ($) 8 12 white axim After discussing wine production with the operations manager, you also learn that the wineries that supply the grapes to produce the above types of wine can produce up to a total of 200,000 pounds of grapes for a six-month supply of wine bottles for the three markets, with the following expected distribution constraints based on types of grapes. Note that current market demand will not support more than the below constraints for each type: Red wine ceiling 22,000 bottles White wine ceiling 24,000 bottles Organic wine ceiling 12,000 bottles Note that the production cost per bottle remains the same as before, that is, 32% of sales or revenue for red wine, 42.5% of sales for white wine, and 52.5% for organic wine. With additional information you have gathered, you are now ready to determine the optimum production mix to maximize profit. Solver Parameters Set Objective: To: Max By Changing Variable Cells: $B$3:$D$3 Subject to the Constraints: $B$3:$D$3 >= 0 $I$2 1 2 Profit A B Red C White 0 D Organic 0 0.00 3 Bottles 4 Production Cost Per Bottle 2.40 3.40 6.30 5 Wholesale Price Per Bottle 7.5 8 12 6 Profit Per Bottle 5.10 4.60 5.70 7 Pounds of Grapes 8 9 Total E 0.00 F G H Red Constraints J K 22,000 22,000 White 24,000 24,000 Organic 12,000 12,000 LBS of grapes 200000 200000
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
The following two equations have a common solution of (1, 2, 3). Which equation would complete a system of three linear equations in three variables having solution set {(1, 2, 3)}? x+y+z=6 2x = y +...
-
Market Values and Book Values Klingon Cruisers, Inc., purchased new cloaking machinery three years ago for $9.5 million. The machinery can be sold to the Romulans today for $6.5 million. Klingons...
-
Rugged Sports Enterprises LP is organized as a limited partnership consisting of two individual partners: Hockey LP and Football LP. Both partners separately operate a minor league hockey team and a...
-
How is a trend analysis useful in quality improvement?
-
Figure a, shows a uniform beam subject to a linearly increasing distributed load. The equation for the resulting elastic curve is (see Figure b) Use bisection to determine the point of maximum...
-
1. The stem-and-leaf plot of weights in pounds of carry-on luggage on a plane is shown below. 104 Key: 110=10 2 1488 3 78 4 355 5 07 6 5 7 8 9 10 Determine the following a) Mean b) Median c) Mode d)...
-
I'm A B C 3 m P=(100+K) kN m 2m m A rigid AD bar is suspended by two wires as shown in the figure. Since the extension stiffness (EA) of the wires are equal, find the tensions in the wires. (K=20)
-
1.36 A homeowner plans to cut down a dead pine tree. Be- cause of neighboring houses, the tree must fall to- ward the man's own residence, which is 85 ft from the base of the tree. Although it...
-
2. The inner and outer surfaces of a 0.5m thick and 5m x 9m north wall of an electrically heated home are maintained at temperatures of 50C and 20C, respectively. The rate of heat transfer through...
-
Natasha derives utility from attending rock concerts (r) and from colas (c) as follows: U(c,r) cr-1. The marginal utility of cola (MUC) and the marginal utility of rock concerts (MUr) are: MUC = 9c1...
-
Dime a Dozen Diamonds makes synthetic diamonds by treating carbon. Each diamond can be sold for $130. The material cost of a standard diamond is $80. The fixed costs incurred each year for factory...
-
If the water from the exhaust of the pump in Problem 3 are used to supply water to an apartment complex, how high the water can be pumped before its pressure reaches 100 kPa, with the same velocity?...
-
With reference to relevant legislation and case law, determine if the following scenarios give rise to income for tax purposes: (a) John is a pensioner and swapping his surplus free range eggs valued...
-
Draw the appropriate control flow graph of the given pseudocode.Make sure to only use one number for blocks of code which are all sequential and when the first line is executed, all of those lines...
Study smarter with the SolutionInn App