Exhibit 3.3 Jack's distillery blends scotches for local bars and saloons. One of his customers has requested a special b
Posted: Wed May 04, 2022 8:25 am
Exhibit 3.3 Jack's distillery blends scotches for local bars and
saloons. One of his customers has requested a special blend of
scotchtargeted as a bar scotch. The customer wants the blend to
involve two scotch products, call them A and B. Product A is a
higherquality scotch while product B is a cheaper brand. The
customer wants to make the claim the blend is closer to high
quality thanthe alternative. The customer wants 50 1500 ml bottles
of the blend. Each bottle must contain at least 48% of Product A
and atleast 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. Let X1 =
Number of liters of product A in total blend delivered X2 = Number
of liters of product B in total blend delivered MIN: 7 X1 + 3 X2
Subject to: X1 + X2 = 1.5 * 50 (Total liters of mix) X1 ≥ 0.48 *
1.5 * 50 (X1 minimum) X2 ≥ 0.5 * 50 (X2 minimum) .0.95 X1 + 0.78 X2
≥ 0.85 * 1.5 * 50 (85% alcohol minimum) X1, X2 ≥ 0 A B C D E 1
Jacks' Distillery 2 3 A B 4 Liters to use Total Cost: 5 Unit cost:
10.5 4.5 6 7 Constraints: Supplied Requirement 8 Total Liters 1 1
75 9 A required 1 36 10 B required 1 25 11 85% alcohol 0.95 0.78
63.75 Refer to Exhibit 3.3. What formula should be entered in cell
E5 in the accompanying Excel spreadsheet to compute total cost? A.
=B4*C4+B5*C5 B. =SUMPRODUCT(B4:C4,B5:C5) C. =SUM(B5:C5) D.
=SUM(E8:E10)
saloons. One of his customers has requested a special blend of
scotchtargeted as a bar scotch. The customer wants the blend to
involve two scotch products, call them A and B. Product A is a
higherquality scotch while product B is a cheaper brand. The
customer wants to make the claim the blend is closer to high
quality thanthe alternative. The customer wants 50 1500 ml bottles
of the blend. Each bottle must contain at least 48% of Product A
and atleast 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. Let X1 =
Number of liters of product A in total blend delivered X2 = Number
of liters of product B in total blend delivered MIN: 7 X1 + 3 X2
Subject to: X1 + X2 = 1.5 * 50 (Total liters of mix) X1 ≥ 0.48 *
1.5 * 50 (X1 minimum) X2 ≥ 0.5 * 50 (X2 minimum) .0.95 X1 + 0.78 X2
≥ 0.85 * 1.5 * 50 (85% alcohol minimum) X1, X2 ≥ 0 A B C D E 1
Jacks' Distillery 2 3 A B 4 Liters to use Total Cost: 5 Unit cost:
10.5 4.5 6 7 Constraints: Supplied Requirement 8 Total Liters 1 1
75 9 A required 1 36 10 B required 1 25 11 85% alcohol 0.95 0.78
63.75 Refer to Exhibit 3.3. What formula should be entered in cell
E5 in the accompanying Excel spreadsheet to compute total cost? A.
=B4*C4+B5*C5 B. =SUMPRODUCT(B4:C4,B5:C5) C. =SUM(B5:C5) D.
=SUM(E8:E10)