QSO510_HW5_Solution

# Print media advertising variable weekdays sundays

• Notes
• MoMofish
• 6
• 100% (13) 13 out of 13 people found this document helpful

This preview shows page 3 - 6 out of 6 pages.

Print Media Advertising Variable Weekdays Sundays Days 2 2 Objective Weekdays Sundays Total Circulation Circulation per day 30,000 80,000 220,000 Constraints Weekdays Sundays Total Limits Budget \$2,000 \$8,000 \$20,000 <= \$40,000 Weekday Min 2 >= 8 Weekday Max 2 <= 26 Sunday Min 2 >= 2 Sunday Max 2 <= 5 And the answer report is as follows. From the answer report, we know that the optimal decisions are to buy 12 weekdays and 2 Sundays. The corresponding circulation is 520,000.

Subscribe to view the full document.

QSO 510 Quantitative Analysis Linear Programming HW Set 5 Solution 4 Objective Cell (Max) Cell Name Original Value Final Value \$D\$7 Circulation per day Total Circulation 220,000 520,000 Variable Cells Cell Name Original Value Final Value Integer \$B\$4 Days Weekdays 2 12 Contin \$C\$4 Days Sundays 2 2 Contin Constraints Cell Name Cell Value Formula Status Slack \$D\$10 Budget Total \$40,000 \$D\$10<=\$F\$10 Binding 0 \$D\$11 Weekday Min Total 12 \$D\$11>=\$F\$11 Not Binding 4 \$D\$12 Weekday Max Total 12 \$D\$12<=\$F\$12 Not Binding 14 \$D\$13 Sunday Min Total 2 \$D\$13>=\$F\$13 Binding 0 \$D\$14 Sunday Max Total 2 \$D\$14<=\$F\$14 Not Binding 3
QSO 510 Quantitative Analysis Linear Programming HW Set 5 Solution 5 Assignment Problem 2 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: LIQUOR QUANTITY Bourbon 128 oz Brandy 128 oz Vodka 128 oz Dry Vermouth 32 oz Sweet Vermouth 32 oz 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?