The mix or blend of the three ingredients is critical

Assignment Help Project Management

Reference no: EM1381190

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: EM1381190

Questions Cloud

Compute the takt time for a system where the total time : Compute the takt time for a system where the total time per shift is 400 minutes, there is one shift, and workers are given two 20-minute breaks and 30 minutes for lunch

What is the average number of patients waiting in line : What is the average number of patients waiting in line for each team? What is the average waiting time in line?

Ideas for energizing a project team : Assume you are introduced to a assignment manager, who does not have authority to give a pay raise or promote a project team member.

Academic method to project management : Sunnyville Corporation is in the business of selling home appliances. Sunnyville Corporation has over 50 sales agents across the country. The management at Sunnyville Corporation has decided to implement an online sales program.

The mix or blend of the three ingredients is critical : 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

Creating a switchboard design with control buttons : Construct a detail report that will display all courses in alphabetical order, with course name and instructor name in a group header; the Social Security number, name, and telephone number

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

What is the average number of customers that are in service : Since the deregulation of the airline industry, fierce competition has forced Global Airlines to reexamine their operations for efficiency and economy. What is the average number of customers that are in service? (Do not round intermediate calcula..

Implementation phase of a project : Assume you are in implementation phase of a assignment and your customer indicates they require a specific change to the project that changes the scope of the deliverables.

User Account

All Pages