Find the optimal solution using solver

Assignment Help Mathematics
Reference no: EM132430242

Question 1 - Linear Programming I

All parts of question 1 relate to the following example. A profit maximizing farmer, Mary, has 100 ha of crop land, 200 days of labour and a requirement to deliver at least 20 tonnes of barley to a local brewery. The profitability of barley is 1.1 thousand dollars per ha planted and the profitability of wheat is 1.3 thousand dollars. Resource use per ha is given in the following table

Resource

Barley

Wheat

Profit per ha $ thousands

1.1

1.3

Land

1

1

Labour

1.5

2.5

Barley contract

4 (barley yield tonnes per ha)

 

Question 1a:

State the problem as a mathematical programming problem (objective function, constraints and non-negativity). Find the optimal solution using Solver and give the optimal solution in a table.

Question 1b:
Represent the graphical solution to the problem in a diagram. Include all constraints and the isoprofit line for the optimal solution. The diagram should identify the feasible set, possible optimal solutions and the optimal solution. The diagram should be fully labelled and discussed in a comment.

Question 1c:
Give the Lagrangean multipliers (shadow prices) for all three constraints and interpret each intuitively. The farmer can rent land at $0.7 (thousand per ha). Would you advise Mary to rent more land or not. How much should she rent if her other resources and constraints are fixed? (Hint: How do the Lagrange multipliers change as the land area is increased.)

Question 1d:
Over what range of wheat profit does the optimal solution (in terms of the area of wheat and barley) remain constant (Hint find out about LP sensitivity analysis). Linear programming generates sensitivity analysis solutions automatically, explain the property of LP that makes this possible.

Question 2 - Dynamics

Locusts are a pest on Rottgut Island because they eat sheep fodder. A control scheme proposed which involves spraying locusts measured by control effort. The details of the problem are as follows.

The locust population grows according to the difference equation:

x(t+1) =xt + γ(x_t-θxtht)

Where xt the population in month t is, γ is the growth rate ht is locust control effort and a catchability parameter θ.

The cost of locust control effort is the quadratic function:
ch (ht) =c0 ht2

The damage caused by locusts is a linear function:

cd(xt) = c1 xt

If there are any locusts left after the end of the planning period they have a terminal cost of, cT.

The objective function is to minimize the cost of the incursion over time (we are ignoring discounting):

Minimize∑t=1T(ch(ht) + cd (xt)) +cTxT

Parameters

Parameter

Value

Description

x0

1000

Initial locust population

γ

0.2

Growth parameter

θ

0.06

Catchability coefficient

c0

200

Effort cost parameter

c1

5

Damage cost parameter to the sheep fodder

cT

500

Terminal  cost parameter for any remaining population

Question 2a:

Find the optimal dynamic solution to this problem over a 24 month planning horizon using Solver. Give the answer as a fully labelled table and a graph.

Question 2b:
How does the solution change if the cost of effort varies over a range from 100 to 300? Present your solutions as a fully labelled graph and discuss your results in full.

Download the attached assessment description. It contains all the details about the assessment: how to submit, deadline for submission, and assessment questions.

You will need to complete all questions and explain your answers clearly to receive full marks. You need to submit your assessment sheet and an Excel file that shows all your workings via the Blackboard submission link.

Type your results into this assignment sheet (don't forget to type your name above).

Save your completed assignment sheet as a PDF with your name and student number in the document title. Also name your Excel workbook with your name and student number! (Files submitted without a name in the document title will not be marked because it costs me too much time to chase up which student submitted which ‘assignment')

Attachment:- Module optimization assignment.rar

Reference no: EM132430242

Questions Cloud

Distinguish between a joint tenancy and a tenancy in common : What are the differences in the owners' rights and obligations between the types of ownership?
Describe security issues of BCBST in regard to integrity : Describe security issues of BCBST in regard to integrity. Describe the HIPPA security requirement that could have prevented each security issue identified
Preparing regulations regarding healthcare : Identify an area where the Agency is preparing regulations regarding healthcare, and what the proposed regulations are.
The strategic sourcing plan : The strategic sourcing plan is a plan for how you will do business going forward. how you will purchase raw materials or new IT systems.
Find the optimal solution using solver : Find the optimal solution using Solver and give the optimal solution in a table - Over what range of wheat profit does the optimal solution
Calculate the net income allocation and record journal entry : Bennett, Woods and Romanov earn annual salaries of $60 000, $70 000, and $80 000 respectively. Calculate the net income allocation and record journal entry
What are the economic factors of divorce : What are the economic factors of divorce? That is who tends to be more hurt, economically, following a divorce?
How much of this game and he excluded from income : Andrew moved out in May of year 2 and they divorced in July of year 3. How much of this game and he excluded from his income
Describe consent addresses confidentiality in group setting : How does confidentiality in a group differ from confidentiality in individual counseling?Describe consent addresses confidentiality in group setting

Reviews

Write a Review

Mathematics Questions & Answers

  Questions on ferris wheel

Prepare a Flexible Budget Gator Divers is a company that provides diving services such as underwater ship repairs to clients in the Tampa Bay area.

  Logistic map

This assignment has two question related to maths. Questions are related to bifurcation cascade and logistic map.

  Finding the probability of cards

This assignment has questions related to probabiltiy.

  Systems of ode

Find all the xed points, and study their stability and Draw the phase portrait of the system, as well as the graphs of the solutions in all relevant cases.

  Derive the boolean expression

Derive the Boolean Expression and construct the switching circuit for the truth table stated

  System of equations

Evaluate which equations are under-identified, just-identified, and over-identified.

  Linear programming problem

Linear programming problem consisting of only two constraints with one objective function.

  Find the natural domain

Find the natural domain of the given functions.

  Introduction to numerical methods

Compute the coecients of the polynomials using the term recurrence relation.

  Chart of the topological manifold

De?nition of smoothness of functions on a smooth manifold is chart independent and hence geometric.

  Mathematics in computing

Questions related on mathematics in computing.

  Complex problems

Complex problems

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd