Prepare the linear programming model for problem

Assignment Help Basic Statistics
Reference no: EM13111754

Mountain Laurel Vineyards manufactures three types of wine -Mountain Blanc, Mountain Red, and Mountain Blush. Company has 17 tons of grapes available to make wine this season. Cask of Blanc needs 0.21 ton of grapes, a cask of Red requires 0.24 ton, and cask of Blush requires 0.18 ton. Vineyard has sufficient storage space in its aging room to store 80 casks of wine.

Vineyard has 2,500 hours of production capacity, and it needs 12 hours to make cask of Blanc, 14.5 hours to make cask of Red, and 16 hours to make cask of Blush. From past sales vineyard knows that demand for Blush will be no more than half of sales of other two wines combined. Profit for cask of Blanc is $7,500, profit for cask of Red is $8,200, and profit for a cask of Blush is $10,500.

Management wishes to know how many casks of each wine to make to maximize total. profit.

Prepare the linear programming model for this problem.

Solve linear programming model using Excel Solver.

Define your suggested decision in one paragraph.

Reference no: EM13111754

Questions Cloud

Explain how adjusting the ph of your reaction flask : Explain how adjusting the pH of your reaction flask can be used to artificially bypass the effects of the inhibitors used in your experiments. What would you add to your flask if you were actually going to perform this experiment?
Hypothesis article analysis : Prepare an analysis of your selected article. Start by identifying and summarizing the hypothesis described in the article. Then explain whether the hypothesis was rejected or accepted, and what the implications of this finding are for the study.
Provide an example of a reduction reaction : Reduction often is referred to as the addition of hydrogens to a compound. It is more chemically correct to refer to reduction as the addition of electrons. Provide an example of a reduction reaction performed by cells in which hydrogen is not add..
Discussion on mass : What is the mass, in milligrams, of mercury in 1.00 kg lake trout that just meets the Northern American standard of 0.50 ppm Hg?
Prepare the linear programming model for problem : Management wishes to know how many casks of each wine to make to maximize total. profit. Prepare the linear programming model for this problem.
What is an example of energy coupling starting with glucose : What is an example of energy coupling starting with Glucose as the reactant? And what is an example of energy coupling starting with ATP as well?
Sampling and hypothesis testing : Why is sampling strategy important? Please provide one or two examples from your work or past experience?
Determine the concentration of fe in waste stream : The determination of iron in industrial waste stream is often carried out by reacting the water sample with o-phenanthroline to form a red-orange complex that absorbs at 510 nm.
Deposit of dust from unpolluted air : Typical rate of deposit of dust (dustfall) from unpolluted air was reported as 10 tons per square mile per month. Express this dustfall in milligrams per square meter per hour.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Computing z-score and percentile

The weight for a group of 18 month-0ld girls are normally distributed with a mean of 24.4 pounds and a standard deviation of 2.6 pounds. Use the table to find the percentage of 18 month-old girls who weigh more than 27.8 pounds.

  Qualitative and quantitative variables

The Acme School of Locksmithing has been accredited for the past 15 years. Discuss how this information might be interpreted as a

  Relationship between age group using level of significance

At 0.05 level of significance, is there evidence of significant relationship between age group and where people mainly get their news? If so, describe the relationship.

  Positive correlation between the number of fire engines

Explain why one would expect to find a positive correlation between the number of fire engines that respond to a fire and the amount of damage done in the fire. Does this mean that the damage would be less extensive if fewer fire engines were disp..

  Details regarding hypothesis testing of mean

The U.S. Fish and Wildlife Service's report on the bass population in the North American lakes indicated average weight of the fish to be 3.0 lb.

  Variation in the independent variable

Multiple choices based on regression analysis - the percentage of variation in the dependent variable explained by the variation in the independent variable

  Explanation of a chi-square test

Provide an explanation of a chi-square test. Why would you use the chi-square statistic? What type of data is used with chi square analysis?

  Binomial random probability

Consider the following two binomial experiments. In a binomial experiment consisting of six trials, how many outcomes have exactly one success and what are these outcomes?

  Mean and standard deviation

Mean and standard deviation are 584.6 and 34.28

  Binomial approximation to normal probability

Suppose you toss a die 100 times in a row. What is the probability that you see 4 spots between 10 and 20 times?

  Highest and lowest scores and calculate range

Determine the highest and lowest scores and calculate the range. Determine an appropriate interval size (i) for grouping data. Draw a frequency polygon from the data. Are the data normal or skewed?

  Normal distribution of body temperatures

Suppose we have a set of body temperatures with a mean of 98.6 degrees, and a sample standard deviation of 0.5 degrees. Assuming a normal distribution of body temperatures in the larger population, between what two values should 95% of all tempera..

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