What happens to the optimal profit if the farm cuts down

Assignment Help Operation Management

Reference no: EM131745433

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)

Formulate appropriately as an LP to maximize profit. Provide the algebraic model

Input and solve the formulation using Excel. After running Solver, generate both the answer report and the sensitivity report.

Answer the following questions in the Answer and Sensitivity Report worksheet. There is no use of SolverTable Add-In with this problem. Just use the standard Solver output. If you feel that it is not possible to answer the question with the single output, please explain why this is the case.

1. What happens to the optimal profit if the farm cuts down 600 tons of fertilizer? Please explain how you arrived to your answer based on the given output.

2. What happens to the optimal profit if the farm acquires another 30 acres of land? Please explain how you arrived to your answer based on the given output.

Reference no: EM131745433

Questions Cloud

Research and collect data and information regarding an rfid : Research and collect data and information regarding an RFID system that can be integrated into a specific business process.

Write a concise manuscript draft using all the information : You are required to write a concise "manuscript" draft using all the information you have. To evaluate short-term efficacy of new drug in comparison with drug

Compute the percents of male and female applicants : An example of Simpson's paradox. Mountain View University has professional schools in business and law. Here is a three-way table of applicants.

Discuss informative sketch what pyroclastic flows : Explain with the use of a neat, labeled, informative sketch what pyroclastic flows are, what is in them, what type of volcano they are most

What happens to the optimal profit if the farm cuts down : What happens to the optimal profit if the farm cuts down 600 tons of fertilizer? What happens to the optimal profit if farm acquires another 30 acres of land?

Type of approach does raleigh use to select target market : What type of approach does Raleigh use to select target market?

Compute the number of radioactive particles : The number of radioactive particles that escape from special containers during a one-hour period. The time it takes to compile computer programs.

Discuss the underlying assumptions : Discuss the scope of the resource. Discuss any evident limitations and opportunities for further inquiry.

Find the area of selected dorm rooms : Numerical Observations A set of numerical observations is obtained as described below. Classify each resulting data set as discrete or continuous.

User Account

All Pages