Linear programming

Becky has just started bartender training and has learned to mix just two drinks(A & B) with similar formula. these two drinks usr varying amounts of gin, sugar, and mix according to Fig and only a limited amount is available. Becky needs to determine how many of each drink she should make to maximize the profit.
A B Available
Gin 2(oz) 6(oz) 3600(oz)
Sugar 2(tsp) 1(tsp) 1200(teaspoon)
Mix 1(bottle) 1(bottle) 800(bottles)

Profit $1.50 $1.00

use spreadsheet solver to solve this problem.

如果用 linear equation, 點樣求 A & B ?
many thanks for the response....