A Farmer in Egypt Owns 50 Acres of Land

question 64

Essay

A farmer in Egypt owns 50 acres of land. He is going to plant each acre with cotton or corn. Each acre planted with cotton yields $400 profit; each with corn yields $200 profit. The labor and fertilizer used for each acre are given in the table below. Resources available include 150 workers and 200 tons of fertilizer.
-(A) Formulate a linear programming model that will enable the farmer to determine the number of acres that should be planted cotton and/or corn in order to maximize his profit.
​
(B) Find an optimal solution to the model in (A) and determine the maximum profit.
​
(C) Implement the model in (A) in Excel Solver and obtain an answer report. Which constraints are binding on the optimal solution?
​
(D) Obtain a sensitivity report for the model in (A). How much should the farmer be willing to pay for an additional worker?
​
(E) Suppose the farmer hires 10 additional workers. Can you use the sensitivity analysis obtained for (D) to determine his expected profit? Would his planting plan change? Explain your answer.
​
(F) Suppose the farmer now wants to hire 20 additional workers, instead of just 10. Can you use the sensitivity analysis obtained for (D) to determine his expected profit? Explain your answer.

---

Definitions:

Behavioral

Pertaining to the actions or reactions of a person or animal in response to external or internal stimuli.

Humanistic

A psychological approach that emphasizes individual potential for growth and the importance of human values, freedom, and self-actualization.

Structuralistic

An approach in psychology that analyzes mental structures by breaking down experiences into their smallest definable parts.

Gestalt Psychology

A psychological approach that emphasizes holistic processing and argues that the whole is more than the sum of its parts.