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

  Null and alternative hypothesis for a problem

Determine what analysis would you do on each problem (ie, one-sample z-test, one-sample t-test, proportion test, two-sample independent t-test, or paired test)?

  Distribution table-histogram-stem-and-leaf plot

A researcher has been measuring the time for pairs of 8 year olds who have just met each other to work together to solve a problem. Construct a distribution table for these data. include the colums and values for proportion and percentage.

  The p-value for a test of no association

We are interested in comparing the proportions of males and females who think earning a large salary is very important to them. I surveyed 200 of each gender and recorded their answers to the question as yes or no.

  Probability depend on binomial distribution

Find the probability that exactly 15 flights arrive on time.

  Confidence interval for the population average

Find out 90% confidence interval for the population average µ of the percentage of hospitals providing at least some charity care.

  Normal distribution of baseball

In baseball, a "no-hitter" is a regulation 9-inning game in which the pitcher yields no hits to the opposing batters. Chance (Summer, 1994) reported on a study of no-hitters in Major League Baseball (MLB).

  Develop a linear regression model

Carpet City wants to develops a means to forecast it carpet sale. The store manager believes that the store's sale are directly related to the number of new housing starts in town.

  Probability of winning a prize in the ring-toss game

At the Statsville County Fair, the probability of winning a prize in the ring-toss game is 0.1. Show the probability distribution for the number of prizes won in 8 games.

  Confidence interval numbers mean

Calculate a 95% confidence interval on the average weight of packaged mustard seed. Explain very carefully to the packaging workers what the 95% confidence interval numbers mean. Include your Excel output. Is there anything you would want to note ..

  Variables which are roughly normally distributed

Which of the variables below do you think will be roughly normally distributed? Please select all that apply.

  Independent samples t test or related samples t test

Should Martha use an independent-samples t-test or a related samples t-test? Explain your answer.

  Describing design life in days of a light bulb

A particular bulb is turned on once each evening for an average of 10 hr. If it is desired to have a reliability of 90 percent, what is its design life in days?

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