Exhibit 3.3
The following questions are based on this problem and accompanying Excel windows.
Jack's distillery blends scotches for local bars and saloons. One of his customers has requested a special blend of scotch targeted as a bar scotch. The customer wants the blend to involve two scotch products, call them A and B. Product A is a higher quality scotch while product B is a cheaper brand. The customer wants to make the claim the blend is closer to high quality than the alternative. The customer wants 50 1500 ml bottles of the blend. Each bottle must contain at least 48% of Product A and at least 500 ml of B. The customer also specified that the blend have an alcohol content of at least 85%. Product A contains 95% alcohol while product B contains 78%. The blend is sold for $12.50 per bottle. Product A costs $7 per liter and product B costs $3 per liter. The company wants to determine the blend that will meet the customer's requirements and maximize profit.
-Refer to Exhibit 3.3. Which cells should be changing cells in this problem?
A) B4:C4
B) E5
C) D8:D10
D) E8:E10
Correct Answer:
Verified
Q50: A financial planner wants to design a
Q51: You have been given the following linear
Q52: Exhibit 3.2
The following questions are based on
Q53: Exhibit 3.2
The following questions are based on
Q54: Exhibit 3.1
The following questions are based on
Q56: The constraints X1 ≥ 0 and X2
Q57: Exhibit 3.5
The following questions are based on
Q58: The hospital administrators at New Hope, County
Q59: Data Envelopment Analysis (DEA) is an LP-based
Q60: Microsoft Excel contains a built-in optimizer called
A)
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents