C&A; has breweries in Lexington, Louisville, and Cincinnati. Each brewery is cap

Question

C&A; has breweries in Lexington, Louisville, and Cincinnati. Each brewery is capable of producing 600 cases of wine per week. These wines have to be shipped to two liquor stores: L1 and L2 that require, respectively, 800 and 700 cases of wine each week. The unit profit from Lexington is $5 to L1 and $4 to L2. The unit profit from Louisville is $6 to L1 and $3 to L2. The unit profit from Cincinnati is $3 to L1 and $5 to L2. C&A; set up the tables as shown below so that Solver can be used to find a maximum profit shipping schedule. Lexington Louisville Cincinnati Demand 2 L1 5 3 L2 4 4 Supply 600 600 600 Lexington Louisville Cincinnati Demand 7 L1 B7:D7 8 L2 88:D8) 10 Lexington Louisville Cincinnati 12 L1 B7 B2 C7C2 13 L2-88"?? D7'D2 D8 D3 -CB C3 Proft B12:D13 What should be entered in the By Cha Varlable Cells and Subject to the Constraints parameters? Changing cells: B7:D8 Constraints: B9:D9B4:D4 Changing cells: B7:Di8 Changing cells: B2:D3 Constraints: B9:D9 >= B4:D4 Changing cells: B7:D8 Changing cells: B2:D3

Explanation / Answer

Question:-

C&A has breweries in Lexington, Louisville, and Cincinnati. Each brewery is capable of producing 600 cases of wine per week. These wines have to be shipped to two liquor stores: L1 and L2 that require, respectively, 800 and 700 cases of wine each week. The unit profit from Lexington is $5 to L1 and $4 to L2. The unit profit from Louisville is $6 to L1 and $3 to L2. The unit profit from Cincinnati is $3 to L1 and $5 to L2. C&A set up the tables as shown below so that Solver can be used to find a maximum profit shipping schedule.
What should be entered in the By Changing Variable Cells and Subject to the Constraints parameters?

Answer:- Charging Cells B7:D8;

Constraints :- B9:D9 <= B4:D4

E7:E8 = E2:E3

Reason:= Charging cells B7 and D8 will provide the demand

Constraints B9:D9 <= B4:D4 indicates that supply should be less than the stated supply which is 600 units

E7:E8 = E2:E3 indicates that demand should be equal

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.