Reference no: EM133047398

A brewery produces three types of beer: lite, regular and dark, and would like to use Solver (in excel) to determine the number of vats to produce of each type in order to maximize profit. The lite beer requires 6 bags of Barley per vat, 1 bag of sugar per vat, and 1 bag of hops. The lite beer has a profit of $10 per vat. The regular beer requires 4 bags of Barley per vat, 3 bag of sugar per vat, and 1 bag of hops. The regular beer has a profit of $20 per vat. The dark beer requires 2 bags of Barley per vat, 2 bags of sugar per vat, and 4 bag of hops. The dark beer has a profit of $30 per vat. The brewery is limited to using the following ingredients (they cannot exceed these units): 800 bags of barley, 600 bags of sugar and 300 bags of hops. Vats can only be brewed in whole units (cannot brew ½ a vat). In the answer please list all formulas and attach a picture of the table and a picture of the constraints listed in solver. You are looking for the number of vats and the maximum profit.