Question
A problem at a brewery has been algebraically modeled as follows: X1 = the number of litres of lager made each day X2 = the
A problem at a brewery has been algebraically modeled as follows: X1 = the number of litres of lager made each day X2 = the number of litres of ale made each day maximize. 1.2X1 +. 0.9X2 subject to production of lager X1 2000 production of ale X2 3000 total production X1 + X2 8000 process 1 4X1 + 2X2 22000 process 2 2X1 +. 6X2. 38000 process 3 3X1 + 8X2 50000 proportion X1 . 0.7X2 0 non-negativity X1 , X2 0
In both parts (a) and (b) include your name and student number in the model (for LINGO, begin a line or set of comment lines with an exclamation mark). Also, everything in the algebraic model must appear in the computer models. Do this also for all computer models in future assignments. (a) Solve the model using LINGO. Submit files for both the model and the solution re- port. (b) Solve this model using the Excel Solver. Make one Excel worksheet with two tabs, one for the model, and one for the answer report. (c) Write the solution in words as would be given to the manager of the brewery. If management doesn't have the time to monitor all things at the brewery, on which of the three processes should they concentrate their efforts?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started