Microbrewers Incorporated makes four beers: Light, Dark, Ale, and Premium. The products require: water, malt, hops, and yeast. Assume the supply of water is free, so that it is the amount of other resources that restricts capacity. The following table gives the pound of each resource required in the production of 1 gallon of each product, the pounds of each resource available, and the revenue received for 1 gallon of each product. can you please solve this in excel solver and provide the excel file? Also can you please answer this a. Define the decision variables using complete sentences b. Write down the objective function in words using complete sentences c. Write down the constraints in words using complete sentences d. Express the objective function mathematically using the decision variables defined in part a. e. Express the constraints mathematically using the decision variables defined in part a; see slides for an example.
Microbrewers Incorporated makes four beers: Light, Dark, Ale, and Premium. The products require: water, malt, hops, and yeast. Assume the supply of water is free, so that it is the amount of other resources that restricts capacity. The following table gives the pound of each resource required in the production of 1 gallon of each product, the pounds of each resource available, and the revenue received for 1 gallon of each product.
can you please solve this in excel solver and provide the excel file?
Also can you please answer this
a. Define the decision variables using complete sentences
b. Write down the objective function in words using complete sentences
c. Write down the constraints in words using complete sentences
d. Express the objective function mathematically using the decision variables defined in part a.
e. Express the constraints mathematically using the decision variables defined in part a; see slides for an example.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
