Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

USING EXCEL PLEASE !!!! Question: A farmer owns 450 acres of land. He is going to plant each acre with wheat or corn. Each acre

USING EXCEL PLEASE !!!!

Question:A farmer owns 450 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $4000 profit, requires three workers, and requires two tons of fertilizer. Each acre planted with corn yields $2000 profit, requires two workers, and requires four tons of fertilizer. There are currently 1000 workers and 1200 tons of fertilizer available. To hedge against risk, the farmer wants to sure that the acres of wheat do not exceed the acres of corn by 150 acres; similarly, the farmer wants to sure that the acres of corn do not exceed the acres of wheat by 150 acres.

Let's define the decision variables as follows:

W: acres of wheat; C: acres of corn

  1. Please formulate the objective function of this farmer.
  2. Please write down all the constraints of this LP problem.
  3. Please create a coordinate plane, putting W on the horizontal axis and C on the vertical axis.
  4. Plot all boundary lines.
  5. Identify feasible region.
  6. Compute the coordinates and the objective value for each corner of the feasible region.
  7. Clearly state your optimal solution and optimal objective value.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Multinational Finance

Authors: Michael H. Moffett, Arthur I. Stonehill, David K. Eiteman

5th edition

205989756, 978-0205989751

More Books

Students also viewed these Finance questions

Question

Where do your students find employment?

Answered: 1 week ago