Answer :
Answer:
The blend should be made with 720 ml of Product A and 780 ml of Product B
Explanation:
We create excel solve to get the cheapest blend with the requirement givens by the customer:
A B C D E F
1 ml type $ alcohol $mix alcohol mix
2 720 Product A 7 0.95 5.04 0.456
3 780 Product B 3 0.78 2.34 0.4056
4 Total 7.38 0.8616
5 Sales Price 12.50
6 Gross Profit 5.12
Constrains:
A2 = integer
A2 > 1500 x 48/100
A3 > 500
F4 > 0.85