Question: 5. (25 marks) A problem at a brewery has been algebraically modeled as follows: Xi = the number of litres of lager made each day

5. (25 marks) A problem at a brewery has been algebraically modeled as follows: Xi = the number of litres of lager made each day X2 = the number of litres of ale made each day maximize 1.2X + 0.9X2 subject to production of lager X1 2000 production of ale X > 3000 total production 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 report. (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? In Assignment 2 and later assignments, you will be asked only to use either the Excel Solver or LINGO. Based on doing (a) and (b) above, do whichever you find easier

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

5. (25 marks) A problem at a brewery has been algebraically modeled as follows: X1 X2= the number of litres of lager made each day the number of litres of ale made each day maximize 1.2X1 + 0.9X2...

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...

please do this question the second photo( table) is just an example 5. (25 marks) A car assembly plant produces both sedans and SUV's. The operations at the plant have been algebraically modeled as...

5. (25 marks) A car assembly plant produces both sedans and SUV's. The operations at the plant have been algebraically modeled as follows: X1 = the number of sedans made each week X2 = the number of...

Probability and Statistics - Problem Set c Keith M. Chugg October 2, 2015 1 Preliminaries, Combinatorics, Set Probability 1.1. A number of bats are in a cave. 2 bats can see out of their left eye. 3...

W0 = N &= WM A B C D E F G H I A factory makes shirts and pants. Each shirt yields a profit of $2, while each pant gives a profit of $3. They can sell at most 190 pants. Each garment spends time on...

7. (12 marks) A microbrewery is located in a town which has become isolated after a powerful storm. Until the bridge on the highway into town can be repaired, there is a limited supply of hops,...

ttth Suppose that the sequence of bags {Bn | n N} is recursively enumerated by the computable function e(n, x) = fn(x), [7 marks] Hence prove that the set of all recursive bags cannot be recursively...

tts Richard Cote holds a job, operates a small farm, and makes numerous investments. A description of his financial activities for 2021 is given below. 1. Richard is a lawyer and is employed in the...

eco009 Show, by means of a labelled diagram, the market demand and supply curves for games consoles e.g. Xbox, PlayStation, Nintendo DS. Identify and explain the market equilibrium position. (ii)...

Bankers who are processing loan applications from companies seeking large loans will probably ask for financial statements audited by an independent CPA because a. Financial statements are too...

Facts: You estimate annual earned income from your employer at $60,000 plus a $3,000 bonus. In addition, you project $150 in interest and $300 in ordinary dividends. The maximum your employer will...

What kind of goals will CRM help organizations meet? Long-term Short-term Community Profitability

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...