Find an optimal solution to the model

Assignment Help Operation Management

Reference no: EM131900242

Question: A winemaker in California's Napa Valley must decide how much of two types of wine she will produce from a particular variety of grapes. Each liter of table wine yields $8 profit, whereas each liter of dessert wine produces $3 profit. The labor hours and bottling process time used for type of wine are given in the table below. Resources available include 200 labor hours and 80 hours of bottling process time. Assume the winemaker has more than enough grapes available to supply any feasible production plan.

	Table	Desert
Labor (Hours)	0.20	0.60
Process Time (Hours)	0.30	0.10

Formulate a linear programming model that will enable the winemaker to determine the number of liters of each type of wine to produce in order to maximize her profit.

Refer to the scenario. Find an optimal solution to the model in 6 and determine the maximum profit.?

Refer to the scenario. Implement the model of 6 in Excel Solver and obtain an answer report. Which constraint(s) are binding on the optimal solution?

Refer to the scenario. Obtain a sensitivity report for the model in 6. How much should the winemaker be willing to pay for an additional labor hour?

Reference no: EM131900242

Questions Cloud

What quality information do you think management needs : What quality information do you think management needs to effectively manage customer service?

Describe ancient greece : Describe Ancient Greece, from the Delian League to Alexanders conquest from Macedonia 10+ pages

Identifying the most persuasive part of that interpretation : Explain whether you agree with the interpretation of either Sayre or Koster of Van Eyck's Arnolfini double portrait, identifying the most persuasive part

What are some key events in this countrys history : What are some key events in this country's history? How has the country's history affected its current population and culture?

Find an optimal solution to the model : A winemaker in California's Napa Valley must decide how much of two types of wine she will produce from a particular variety of grapes.

Roman imperialism and historical context : What is the relationship between Roman imperialism and historical context?

Calculate the amount of gross profit : The cost of goods sold was $ 38,000. On March 18, High Quality received payment from the customer. Calculate the amount of gross profit

How to achieve multifactor productivity improvement : To achieve a 12 percent multifactor productivity improvement by reducing materials costs only, one needs to reduce the materials cost by nothing percent.

How did the hellenistic greeks come to define greek : With both local citizenship and city of origin reduced in political importance, how did the Hellenistic Greeks come to define Greek?

User Account

All Pages