Creating lp model to deliver optimal ultra dry martini mix

Assignment Help Operation Management
Reference no: EM13103873

MI6's Q Branch is developing a new ultra dry martini. The martini is a mixture of vodka plus three liquid ingredients: A, B, and C. To ensure proper performance, the total amount of additive (amount of A plus amount of B plus amount of C) must be at least 10 ounces per gallon of vodka. For safety reasons, however, the amount of additive must not exceed 15 ounces per gallon of vodka. The mix or blend of the three ingredients is critical. At least one ounce of ingredient A must be used for every ounce of ingredient B. The amount of ingredient C must be greater than one-half the amount of ingredient A. The mixture must contain at least one ounce each of A, B, and C. The cost per ounce for ingredients A, B, and C is $10, $3, and $9 respectively. The martini must be shaken, not stirred.
Using Excel develop an LP model to deliver an optimal ultra dry martini mix. Format the cell with your objective function in sunburst yellow

Reference no: EM13103873

Previous Q& A

  What percentage of the alpha particles penetrated completely

A physicist has developed a device that generates a beam of alpha particles (each of which is a helium nucleus, consisting of two protons, two neutrons, and no electrons).

  Skateworld company-probability

The Skateworld Company operates ice rinks in several major cities throughout the United States. During each session of open skating, one customer is selected at random to receive a free pass for a future open skating session.

  Crm system

Development of a simple sales and invoice component where a customer fills out a form on a web page to request a truck delivery and then receives an online invoice in PDF format.

  How many electrons are also emitted

The nucleus of an atom consists of protons and neutrons (no electrons). A nucleus of a carbon-12 isotope contains six protons and six neutrons.

  Pros and cons of great lakes coating

What are the pros and cons of great lakes coating's not having formalized policies regarding employees behavior?

  What is the approximate temperature at this altitude

Scientists plan to release a space probe that will enter the atmosphere of a gaseous planet. The temperature of the gaseous planet varies linearly with the height of the atmosphere.

  How far from q1 should the third charge be placed

Two charges q1 = 7 µC, q2 = -33 µC, are L = 14 cm apart. A third charge is to be placed on the line between the two charges. How far from q1 should the third charge be placed so that the net electric force on the third charge is minimized?

  What are the volume and linear charge densities

A charge of 0.43 C is spread uniformly throughout a 36 cm rod of radius 7 mm. What are the volume and linear charge densities?

  Find the magnitude and direction of the electric field

Two spherical shells have a common center. A -2.1 10-6 C charge is spread uniformly over the inner shell, which has a radius of 0.050 m. A +5.0 10-6 C charge is spread uniformly over the outer shell.

  Calculating number of agents

Since the deregulation of the airline industry, fierce competition has forced Global Airlines to reexamine their operations for efficiency and economy.

Reviews

Write a Review

 

Similar Q& A

  High order needs become less impotrant as indivdual move up

high order needs become less impotrant as indivdual move up the corporate ladder/5. higher-order needs become more imporant as indivuals move up the crporat ladder/which of these answer is correct/joedumb77

  Illustrate what impact do utilize stage-gate

Illustrate what impact do you think utilizing Stage-Gate processes would have on development cycle time also development costs.

  Discuss the probable impact of society as a whole

Discuss the probable impact of society as a whole if the 10 facts about money and banking were clearly understood by everyone in the country.

  Determine an optimal assignment of cases to lawyers

Determine an optimal assignment of cases to lawyers such which each junior partner receives a different case also total hours expended by firm is minimise.

  Define common law

As a new manager in your department, you are tasked with the job of providing employee training for members of your department who have interactions with the legal department.

  Coordination through formal hierarchy relies on

Coordination through formal hierarchy relies on. Communication flows in all directions with little concern for the formal hierarchy in

  Elucidate what is observed time for this job

The performance rating for a particular welder was established at ninety-2 % (92% ). Additionally, every welder is granted a twelve % (12%) allowance for personal needs, fatigue also routine delays.Elucidate what is observed time (OT) for this job.

  Is temperature a suitable level differentiator

The researcher select four different detergents based on several properties also conducted a series of experiments at 3 different water temperatures. Cleanliness was quantified using a construct measure. The code data is shown in the subsequent ta..

  Analyze the five determinants of an investor''s decisions

Analyze the five determinants of an investor's decisions and discuss which single determinant you believe is most important in the financial

  Illustrate what is the total of the annual ordering price

Given the present policy of ordering 50 units at a time, illustrate what is the total of the annual ordering price also the annual holding price.

  What are the resulting efficiencies and outputs

What are the resulting efficiencies and outputs of the two lines? Is it always best to equally share extra machines between the two lines?

  Descriple the most likely impediments to health care

Descriple the most likely impediments to health care information access in 2030 and make at least two recommendations to avert those impediment that can be implemented now.

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