Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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) The objective is to maximize the total profit, i.e., 2000X + 3000Y. Constraint on available labor: 3X + 2Y <= 1000 Constraint on available fertilizer: 2X + 4Y <= 1200 Constraint on land (acres): X + Y <= 450 Non-negativity Constraint: X, Y >= 0 Therefore, the algebraic formulation of the LP is: MAX 2000X + 3000Y S.T. 3X + 2Y <= 1000 2X + 4Y <= 1200 X + Y <= 450 X, Y >= 0 a) Input and solve the formulation using Excel. After running Solver, generate and save both the answer report and the sensitivity report. b) Answer the following questions in the Answer and Sensitivity Report worksheet. i) How much land is planted with wheat? ii) How much land is planted with corn? iii) How much profit will the farm receive from the optimal operation?

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

OM operations management

Authors: David Alan Collier, James R. Evans

5th edition

1285451376, 978-1285451374

More Books

Students also viewed these General Management questions

Question

3. If possible, break the presentation into clear steps or stages.

Answered: 1 week ago

Question

Define a traverse in Surveying?

Answered: 1 week ago