Purchase Solution

Linear Programming: Maximize Planting

Not what you're looking for?

Ask Custom Question

A farmer in Lowa owns 45 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $200 profit, requires 3 workers, and requires 2 tons of fertilizer; each with corn yields a $300 profit, requires 2 workers, and requires 4 tons of fertilizer. One hundred workers and 120 tons of fertilizer are available. Use solver to help the farmer maximize the profit from his land.

Purchase this Solution

Solution Summary

This solution uses Excel to solve this maximization problem and the Excel document is attached to this posting. By clicking directly onto the cells of the spreadsheet, it clearly indicates how the derived value has been reached.

Solution Preview

See the Excel file attached for proper formatting.

Let W= Acres land planted with Wheat
C= ...

Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Motivation

This tests some key elements of major motivation theories.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Basics of corporate finance

These questions will test you on your knowledge of finance.