Question
A contestant on the hit reality television show Top Bartender was asked to mix a variety of drinks, each consisting of 4 fluid ounces. No
A contestant on the hit reality television show Top Bartender was asked to mix a variety of drinks, each consisting of 4 fluid ounces. No other ingredients were permitted. She was given the following quantities of liquor:
LiquorQty (ounces)
Bourbon128
Brandy128
Vodka128
Dry Vermouth32
Sweet Vermouth32
The contestant is considering making the following four drinks:
The New Yorker: 25% each of bourbon, brandy, vodka, and sweet vermouth
The Garaboldi: 25% each of brandy and dry vermouth; 50% sweet vermouth
The Kentuckian: 100% bourbon
The Russian: 75% vodka and 25% dry vermouth
The contestant's objective is to make the largest number of drinks with the available liquor. What is the combination of drinks to meet her objective?
how i do solve this problem using Excel? solver function?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started