Helen Keplinger must choose the amount of two wine types she will produce. Each liter of...

Helen Keplinger must choose the amount of two wine types she will produce. Each liter of Red wine returns $7 profit, while each liter of White wine returns $2 profit. The labor hours and bottling time used for each type of wine are given in the table below. Resources available include 169 labor hours and 74.25 hours of bottling process time. Assume the Helen Keplinger has more than enough grapes available to supply any feasible production plan.

	Red	White
Labor (Hours)	0.15	0.50
Bottling Time (Hours)	0.20	0.05

a) Formulate a linear programming model that will enable Helen Keplinger to determine the number of liters of each type of wine to produce in order to maximize her profit. (15 pts)

b) Suppose Helen Keplinger labor hours varies from 150 to 250 with 10-unit increments. Use SolverTable to determine her expected profit? Would her bottling plan change? Explain your answer. (5 pts)

Solutions

Expert Solution

1. Set up the LP in excel as shown

2. Use the solver and input the values as shown.

3. final solution.

4 Impact of increase the labour in units of 10

milcah answered 1 year ago

Next > < Previous

Related Solutions

A consumer has an income R. She can choose between two goods: wine and beer. Lets...

A consumer has an income R. She can choose between two goods: wine and beer. Lets assume the price of a glass of wine (Pw) is three and the price of a glass of beer (Pb) is two. We denote the consumption of wine as Xw and the consumption of beer Xb Write the budget constraint of the consumer. Compute the slope of the budget line and represent it on a graph. The following tables give the different bundles of...

The countries of Utopia and Dystopia can each produce two goods: wine and cars. If Utopia...

The countries of Utopia and Dystopia can each produce two goods: wine and cars. If Utopia produces only wine, it can produce 80 barrels per year; if it produces only cars, it can produce 40 cars per year. If Dystopia produces only wine, it can produce 60 barrels per year; if it produces only cars, it can produce 90 cars per year. Indicate the opportunity cost of producing cars and wine in Utopia and Dystopia by reproducing the table below...

Helen wants to buy a used $10,000 car in 4 years. How much must she save...

Helen wants to buy a used $10,000 car in 4 years. How much must she save per week, earning 7.5% annual interest to have the $10,000?

A company blends nitrogen and phosphorous to produce two types of fertilizers. Fertilizer 1 must be...

A company blends nitrogen and phosphorous to produce two types of fertilizers. Fertilizer 1 must be at least 50% nitrogen and sells for $55 per pound. Fertilizer 2 must be at least 55% phosphorous and sells for $45 per pound. The company can purchase up to 9000 pounds of nitrogen at $20 per pound and up to 12,000 pounds of phosphorous at $12 per pound. Assuming that all fertilizer produced can be sold, determine the optimal blending plan for the...

eanette uses the serial payment approach to calculate the amount she must save each year to...

eanette uses the serial payment approach to calculate the amount she must save each year to accumulate her desired retirement income fund. She assumes an annual inflation rate of 4%, and an annual investment rate of return of 7%. If she determines that she must save $10,000 in the first year, how much must she save in the second year to meet her goal? $10,000 B) $10,288 C) $10,700 D) $10,400

Two countries, Spain and Portugal, use two inputs, capital and labor, to produce two goods, wine...

Two countries, Spain and Portugal, use two inputs, capital and labor, to produce two goods, wine and cheese. Wine is relatively capital intensive in production and Spain is the relatively capital abundant country. 5) According to the Rybczynski Theorem, if Portugal were a small country with a free trade policy, growth of the labor force would cause: Question 5 options: wages to fall, and the reward to capital to increase in Portugal. expansion of the cheese industry and contraction of...

Two countries, Spain and Portugal, use two inputs, capital and labor, to produce two goods, wine...

Two countries, Spain and Portugal, use two inputs, capital and labor, to produce two goods, wine and cheese. Wine is relatively capital intensive in production and Spain is the relatively capital abundant country. 4) According to the Factor Price Equalization Theorem wages (earnings from labor) and rent (earnings from capital) between Spain and Portugal will equalize: Question 4 options: with migration of labor and free international movement of capital. solely due to labor migration. solely due to the free international...

Two generals are preparing for a battle. Each must choose how many units to bring or...

Two generals are preparing for a battle. Each must choose how many units to bring or whether they should just pass on the battle and not fight. The generals must make their decisions simultaneously. Each general can bring any number of units between 1 and 5, or he can pass. If either general passes or if they both bring the same number of units, then each general has a payoff of zero. If one general brings more units than the...

Suppose that in order to produce any positive amount of output, a firm must build an...

Suppose that in order to produce any positive amount of output, a firm must build an operating facility which costs $40. The Variable Cost of production is equal to 6q, where q is the quantity of output. Therefore the Marginal Cost of production is constant at MC = $6. If the firm decides not to produce, it does not build the operating facility, and so it incurs 0 costs. The demand facing the firm is given by P = 20...

A particular production process requires two types of raw materials to produce the end product. Each...

A particular production process requires two types of raw materials to produce the end product. Each unit of finished product requires three units of raw material A and 2 units of raw material B, plus processing costs of $35. For the purpose of valuing inventory, raw material A and B are recorded together in one account and should be considered together when determining cost and net realizable value. The following provides information on inventories at fiscal 2019 year-end: Inventory item...

Subjects