Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Product Marketing Management

Authors: Suat Ozsoy

1st Edition

9798481471693

More Books

Students also viewed these General Management questions

Question

List t he t hree c omponents of ident ity. (p. 3 0)

Answered: 1 week ago