Question
Exhibit3.3 Jack'sdistilleryblendsscotchesforlocalbarsandsaloons.Oneofhiscustomershasrequestedaspecialblendofscotchtargetedasabarscotch.Thecustomerwantstheblendtoinvolvetwoscotchproducts,callthemAandB.ProductAisahigherqualityscotchwhileproductBisacheaperbrand.Thecustomerwantstomaketheclaimtheblendisclosertohighqualitythanthealternative.Thecustomerwants501500mlbottlesoftheblend.Eachbottlemustcontainatleast48%ofProductAandatleast500mlofB.Thecustomeralsospecifiedthattheblendhaveanalcoholcontentofatleast85%.ProductAcontains95%alcoholwhileproductBcontains78%.Theblendissoldfor$12.50perbottle.ProductAcosts$7perliterandproductBcosts$3perliter.Thecompanywantstodeterminetheblendthatwillmeetthecustomer'srequirementsandmaximizeprofit. Let X1=NumberoflitersofproductAintotalblenddeliveredX2=NumberoflitersofproductBintotalblenddelivered MIN: 7X1+3X2 Subjectto: X1+X2=1.5*50(Totallitersofmix) X10.48*1.5*50(X1minimum) X20.5*50(X2minimum) .0.95X1+0.78X20.85*1.5*50(85%alcoholminimum)X1,X20 A B C D E 1 Jacks'Distillery 2 3 A B 4 Literstouse TotalCost:
Exhibit3.3
Jack'sdistilleryblendsscotchesforlocalbarsandsaloons.Oneofhiscustomershasrequestedaspecialblendofscotchtargetedasabarscotch.Thecustomerwantstheblendtoinvolvetwoscotchproducts,callthemAandB.ProductAisahigherqualityscotchwhileproductBisacheaperbrand.Thecustomerwantstomaketheclaimtheblendisclosertohighqualitythanthealternative.Thecustomerwants501500mlbottlesoftheblend.Eachbottlemustcontainatleast48%ofProductAandatleast500mlofB.Thecustomeralsospecifiedthattheblendhaveanalcoholcontentofatleast85%.ProductAcontains95%alcoholwhileproductBcontains78%.Theblendissoldfor$12.50perbottle.ProductAcosts$7perliterandproductBcosts$3perliter.Thecompanywantstodeterminetheblendthatwillmeetthecustomer'srequirementsandmaximizeprofit.
Let X1=NumberoflitersofproductAintotalblenddeliveredX2=NumberoflitersofproductBintotalblenddelivered
MIN: 7X1+3X2
Subjectto: X1+X2=1.5*50(Totallitersofmix)
X10.48*1.5*50(X1minimum)
X20.5*50(X2minimum)
.0.95X1+0.78X20.85*1.5*50(85%alcoholminimum)X1,X20
A | B | C | D | E | |
1 | Jacks'Distillery | ||||
2 | |||||
3 | A | B | |||
4 | Literstouse | TotalCost: | |||
5 | Unitcost: | 10.5 | 4.5 | ||
6 | |||||
7 | Constraints: | Supplied | Requirement | ||
8 | TotalLiters | 1 | 1 | 75 | |
9 | Arequired | 1 | 36 | ||
10 | Brequired | 1 | 25 | ||
11 | 85%alcohol | 0.95 | 0.78 | 63.75 |
RefertoExhibit3.3.WhatformulashouldbeenteredincellD11intheaccompanyingExcelspreadsheettocomputethetotallitersofalcoholsupplied?
| A. | =B4*B5+C4*C5 | |
| B. | =SUMPRODUCT(B11:C11,$B$4:$C$4) | |
| C. | =SUM(B5:C5) | |
| D. | =SUM(E8:E10) |
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
Fundamentals of Management
Authors: Robbins, DeCenzo, Coulter
7th Edition
ISBN: 132996855, 0-13-610982-9 , 9780132996853, 978-0-13-61098, 978-0136109822
