Question: THERE IS NO EXCEL SHEET OR ATTACHMENT PROVIDED FOR THIS QUESTION ALL OF THE INFORMATION IS GIVEN IS INCLUDED IN THE SCREENSHOT BELOW Question 1

THERE IS NO EXCEL SHEET OR ATTACHMENT PROVIDED FOR THIS QUESTION

ALL OF THE INFORMATION IS GIVEN IS INCLUDED IN THE SCREENSHOT BELOW

THERE IS NO EXCEL SHEET OR ATTACHMENT PROVIDEDTHERE IS NO EXCEL SHEET OR ATTACHMENT PROVIDED

Question 1 3 points Save Answer 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. Let X1 = Number of liters of product A in total blend delivered X2 = Number of liters of product B in total blend delivered MIN: Subject to: 7 X1 + 3 X2 X1 + X2 = 1.5 * 50 (Total liters of mix) X1 2 0.48 * 1.5 * 50 (X1 minimum) X2 2 0.5 * 50 (X2 minimum) .0.95 X1 +0.78 X2 2 0.85 * 1.5 * 50 (85% alcohol minimum) X1, X220 A D E B C Jacks' Distillery 1 2 3 A B 4 Total Cost: Liters to use Unit cost: 5 10.5 4.5 6 7 Supplied 8 1 1 9 Constraints: Total Liters A required B required 85% alcohol 1 Requirement 75 36 25 63.75 10 1 11 0.95 0.78 2 3 A B 4 Total Cost: Liters to use Unit cost: 5 10.5 4.5 6 7 Supplied 8 1 1 9 Constraints: Total Liters A required B required 85% alcohol 1 Requirement 75 36 25 63.75 10 11 0.95 0.78 Refer to Exhibit 3.3. What formula should be entered in cell D11 in the accompanying Excel spreadsheet to compute the total liters of alcohol supplied? O a. =B4*B5+C4*C5 O b. =SUM(B5:C5) O c. =SUMPRODUCT(B11:C11,$B$4:$C$4) o d. =SUM(E8:E10)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!