What happens to optimal solution if profit of wheat doubles

Assignment Help Operation Management

Reference no: EM132220850

A farmer owns 450 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $2000 profit, requires three workers, and requires two tons of fertilizer. Each acre planted with corn yields $3000 profit, requires two workers, and requires four tons of fertilizer. There are currently 1000 workers and 1200 tons of fertilizer available.

Define the decision variables necessary for the LP formulation as follows:

X = land planted with wheat (acres)

Y = land planted with corn (acres)

a) Formulate appropriately as an LP to maximize profit. Provide the model formulation in your submission. Must be neatly presented.

b) Input and solve the formulation using Excel. After running Solver, generate sensitivity report. You should provide printed copies of your model worksheet and the sensitivity report.

c) Report the slack/surplus for each constraints. Which constraints are binding constraints? This is important !

d) Answer the following questions (i.e., i-viii) based on the Sensitivity Report worksheet. DO NOT modify or rerun the model. You must explain all the steps on how you answered the question based on the Excel’s sensitivity report. If you feel that it is not possible to answer the question with the single output, explain why this is the case.

i) How much land is planted with wheat? 2

ii) How much land is planted with corn?

iii) How much profit will the farm receive from the optimal operation?

iv) What happens to the optimal solution if the profit of wheat doubles? Must explain how you arrived to your answer based on the given output. Do not reformulate the LP to find out the implication.

v) What happens to the optimal solution if the profit of corn decreases by 50%? Must explain how you arrived to your answer based on the given output. Do not reformulate the LP to find out the implication.

vi) What happens to the optimal profit if the farm hires another 100 workers? Must explain how you arrived to your answer based on the given output. Do not reformulate the LP to find out the implication.

vii) What happens to the optimal profit if the farm cuts down 600 tons of fertilizer? Must explain how you arrived to your answer based on the given output. Do not reformulate the LP to find out the implication.

viii) What happens to the optimal profit if the farm acquires another 30 acres of land? Must explain how you arrived to your answer based on the given output. Do not reformulate the LP to find out the implication.

Reference no: EM132220850

Questions Cloud

Summary of the article - Four Economic Questions on Brexit : Read Foreign Policy article - Four Economic Questions on Brexit BY PHIL LEVY and Summary of the article - what the article is about and what major points

How are disability and exceptionality defined in schools : How are disability and exceptionality defined in schools? How does that differ from how society, in general, defines the terms?

How can health care delivery systems work collaboratively : How can health care delivery systems work collaboratively to address global health concerns?Who are some of the stakeholders that may work on these issues?

Examine the importance of health insurance : Examine the importance of health insurance with respect to the cost of the uninsured on the healthcare system. Interpret the function of the Affordable Care.

What happens to optimal solution if profit of wheat doubles : How much profit will the farm receive from the optimal operation? What happens to the optimal solution if the profit of wheat doubles?

What factors have led to perpetual reading deficiency : How have teacher preparation programs failed teacher candidates in incorporating research into reading programs?

Usually inappropriate for marketing research questionnaires : All of which are usually inappropriate for marketing research questionnaires. Indicate why each is inappropriate.

Think about why you made the choice you made : A mother comes angrily into your office one morning very early before any of the busses arrive, dragging her fourth-grade son with her.

Policies such as vacations-travel or expense reimbursement : What do you think about the absence of policies such as vacations, travel, or expense reimbursement?

User Account

All Pages