Insert a test box into the worksheet

Assignment Help Operation Management

Reference no: EM13222614

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.

Insert a text box into the worksheet containing your model formulation and provide a two sentence, layman's explanation of your results, i.e., the answer you would provide to MI6's Q Branch regarding this specific scenario.
Insert a test box into the worksheet containing your sensitivity report and explain a) the shadow prices (include the allowable increases and decreases in your discussion) and b) the allowable increase and decrease for any one of your objective function coefficients.
When you have all this done, upload your Excel workbook as your response to this question.

Reference no: EM13222614

Questions Cloud

Explain what is the maximum quantity of nac2h3o2 : What is the maximum quantity of NaC2H3O2 that can be added to 200.0 mL of this solution before precipitation of begins?

Compare an organizational structure and an organizational : Compare an organizational structure and an organizational process.

State volume of the solution is not changed significantly : how many moles of calcium chloride, cacl2, can be added to 1.5 liters of .020 M potassium sulfate, k2so4, before a precipitate is expected? assume that the volume of the solution is not changed significantly by the addition of magnesium sulfate.

Flow of information differs for inpatient versus outpatient : Develop additional charts to show how the flow of information differs for an inpatient versus an outpatient and various third party payers (e.g., Medicare versus Blue Cross)

Insert a test box into the worksheet : When you have all this done, upload your Excel workbook as your response to this question.

Writing a hypothesis about federal government : Looking for help writing a hypothesis about federal government versus contracting. Also some research information that help test the hypothesis. Please be specific as possible.

State the professional members of the courtroom workgroup : State the professional members of the courtroom workgroup and explain their roles.

Different perspectives related to the problem : Business Communication Course: Write a report in which you put forward the results of your research and your recommendations to your company or organization.

What steps should you take to do a similar survey : We looked at surveys as a means of developing data using linear programming. In the Management Sciences Association example, we looked a survey requiring significant preparation. What steps should you take to do a similar survey?

User Account

All Pages