Formulate and solve an integer programming model

Assignment Help Basic Statistics
Reference no: EM132855976

The Otter Creek Winery produces three kinds of table wine-a blush, a white, and a red. The winery has 30,000 pounds of grapes available to produce wine this season. A cask of blush requires 360 pounds of grapes, a cask of white requires 375 pounds, and a cask of red requires 410 pounds. The winery has enough storage space in its aging room to store 67 casks of wine. The winery has 2,200 hours of production capacity, and it requires 14 hours to produce a cask of blush, 10 hours to produce a cask of white, and 18 hours to produce a cask of red. From records of previous years' sales, the winery knows it will sell at least twice as much blush as red and at least 1.5 times as much white as blush. The profit for a cask of blush is $12,100, the profit for a cask of white is $8,700, and the profit for a cask of red is $10,500. The winery wants to know the number of casks of each table wine to produce.

Formulate and solve an integer programming model for this problem in excel Solver.

Reference no: EM132855976

Questions Cloud

Find the mean and standard deviation of the data set : The data listed here are the weights (in pounds) of 27 packages of ground beef in a supermarket meat display:
Construct a frequency distribution of companies : Construct a frequency distribution of companies based on per unit sales for the pizza companies.
What is the probability it was reviewed by a lazy rater : If a movie is rated Good, what is the probability it was reviewed by a lazy rater?
Construct anova having sources and df only in integers : In an experiment two factors will be investigated Spray for insecticides having 4 types and 6 types of fertilizers. The researcher wish to carry the experiment
Formulate and solve an integer programming model : Formulate and solve an integer programming model for this problem in excel Solver.
Separate the components of soil sample : Which is likely the best speed to separate the components of this soil sample? Why?
Shareholder and stakeholder models of corporate governance : Which one seems to predominant today? What implications does this have for business in today's complex environment?
Find the probability that a randomly hit fly ball travels : Suppose that the distance of fly balls hit to the outfield (in baseball) is normally distributed with a mean of 257 feet and a standard deviation of 35 feet. Le
Find the absolute value of the critical values : a) Find the absolute value of the critical values in terms of the standard normal scale, Z. Enter your answer to at least three decimal places.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Construct a confidence interval for difference in proportion

Assuming that among the 1048 respondents, there were an equal number of men and women, construct a 95% confidence interval for the difference in these proportions.

  Disgruntled executive of an exporting firm stated

Free Trade There has been considerable momentum to reduce or remove trade barriers in an effort to achieve "free trade." Yet, one disgruntled executive of an exporting firm stated, "

  Relationship in sale price of a home and number of bedrooms

Areal tor in Arlington, Massachusetts, is analyzing the relationship between the sale price of a home (Price), its square footage (Sqft).

  Calculate the most appropriate central tendency measure

There are 20 red ornaments, 32 green ornaments, 18 gold ornaments, 24 silver ornaments and 19 blue ornaments. Calculate the most appropriate central tendency

  Contrast the culture of either modern britain

Compare and contrast the culture of either modern Britain, the USA or Australia with that of your own country at the present time.

  Criticize the given definitions - normal

Criticize the following definitions in light of the eight rules for lexical definitions:- "Normal" means an attribute possessed by people who are able to get on in the world.

  Accident and incident reporting procedures

List four reasons for having accident and incident reporting procedures that are understood by all employees?

  Rejection region approach and p-value approach

The data is given below. At 0.05 significance level, test the research hypothesis that μ, the average ratio, is greater than 675. Test the hypothesis using two approaches: the rejection region approach, and the p-value approach.

  A researcher hypothesizes that people who listen to

a researcher hypothesizes that people who listen to classical music have higher concentration skills than those in the

  Calculate the value of R squared from the data

Investigation into linear regression. Calculate the value of R squared from the data and show that it agrees with the Excel value in the regression output

  Determine probability that adult owns college education

Assume 41% of all American adults have some college education. American adult is randomly selected. Determine the probability that adult owns stock or has some college education?

  Confidence interval to estimate sample size

General Motors pays for employee education. The HR director would like to conduct a study on the average GPA of employees who have used this benefit to complete their degrees using a sample of education records over the past 10 years.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd