Explain why a linear programming model would be suitable

Reference no: EM133079236

SIT718 Real world Analytics - Deakin University

Assessment Task

Question 1: a) Explain why a Linear Programming (LP) model would be suitable for this case study.

b) Formulate a LP model to help the brewery management to maximise the revenue while satisfying all constraints.

c) Use the graphical method to find the optimal solution. Show the feasible region and the optimal solution(s) on the graph. Annotate all lines on your graph. What is the optimal daily profit for the factory?

Note 1: it is possible to have multiple optimal points.

Note 2: you can use graphical solvers available online but make sure that your graph is clear, all variables involved are clearly represented and annotated, and each line is clearly marked and related to the corresponding equation.

d) Find the range for the profit ($), of a barrel of beer (if any), that can be changed without affecting an optimal point of part (c)?

Question 2. Vin Rouge owns two wineries: Winery A can produce up to 300 bottles per day and Winery B can produce up to 200 bottles a day. It supplies wine to three bottle shops: Fig, Bear and Sky. Assume that every 10 bottles are packed into a box. Fig needs at most 20 boxes a day; Bear needs at least 18 boxes a day; and Sky needs only 5 boxes a day. The costs, associated with the delivery of each box of wine from the wineries to the bottle shops, are shown in the table below. All costs are given in dollars.

Vin Rouge	Fig	Bear	Sky
Winery A	35	62	65
Winery B	28	36	32

(a) Why the scenario above can be modelled with a Linear Programming (LP) model?

(b) Formulate a linear programming (LP) model to determine a minimum cost delivery scheme that satisfies the need of the bottle shops and that does not exceed the production capacity of the wineries.

(d) Solve the model in R/R Studio. Find the optimal cost and optimal values of the decision variables.

Question 3. Two mining companies, Red and Blue, bid for the right to drill a field. The possible bids are $ 15 Million, $ 25 Million, $ 35 Million, $ 45 Million and $ 50 Million. The winner is the company with the higher bid.

The two companies decide that in the case of a tie (equal bids), Red is the winner and will get the field.

Company Red has ordered a geological survey and, based on the report from the survey, concludes that getting the field for more than $ 45 Million is as bad as not getting it (assume loss), except in case of a tie (assume win).

(a) State reasons why/how this game can be described as a two-players-zero-sum game
(b) Considering all possible combinations of bids, formulate the payoff matrix for the game.
(c) Explain what is a saddle point. Verify: does the game have a saddle point?
(d) Construct a linear programming model for Company Red in this game.
(e) Produce an appropriate code to solve the linear programming model in part (d).
(f) Solve the game for Red using the linear programming model and the code you con- structed in parts (d) and (e). Interpret your solution.

Question 4. Consider two companies, Company A and Company B, producing the same model of iPhones. The demand for the iPhones produced by Company A is DA, and the demand for the iPhones produced by Company B is DB. The demands are described by the following functions:

D_A = 200 - P_A - (P_A - P¯) (1)
D_B = 200 - P_B - (P_B - P¯) (2)

where P_A and P_B are the prices of iPhones for Factory A and Factory B respectively, and P¯ is the average price over the prices PA and PB. For each company, the cost for producing one iPhone is C = 20. Suppose that each company can only choose one of the three prices {60, 70, 80} for a sale.

(a) Compute the profits of each company under all sale price combinations and produce the payoff matrix for each company.

[Hint: the profit = the demand for the iPhones × the profit of one iPhone after sale.]

(b) Find the Nash equilibrium of this game. What are the profits at this equilibrium? Explain your reason clearly.

Attachment:- Real world Analytics.rar

Reference no: EM133079236

Questions Cloud

Changes in the rate of interest : Changes in the rate of interest are detectable in the changes in the structure of relative prices of various types of goods. With that in mind, answer the follo

Developing nervous system most vulnerable : When is the developing nervous system most vulnerable to teratogens after conception?

Determine the equivalent cash price of the mixer : A one-bagger mixer can be purchased with a down payment of P2,000 and equal payment of P600 each paid at the end of every month for 12 months. If money is worth

What is the optimal mixed bundling strategy : You produce Internet Explorer (IE) and Edge. You have two customers, Customer A and Customer B. The willingness to pay for each item for each customer appears b

Explain why a linear programming model would be suitable : Explain why a Linear Programming model would be suitable for this case study and Formulate a LP model to help the brewery management to maximise the revenue

Outline of the responsibilities of the fire inspector : Many people do not understand the diversity of the fire inspector position and the training requirements needed to be successful. interview an active fire inspe

What will be the total loan amount : What will be the total loan amount at the end of year three if the loan proceeds take place at the beginning of each year? and middle of each year?

Describe the three key ways in which economists think : Describe the three key ways in which economists think. Give a practical example of each.

Public opinion on the lgbtq community : Public opinion on the LGBTQ community has rapidly and drastically changed in America. Though individuals in this broad and heterogeneous community still face a

User Account

All Pages