Purchase Solution

Sensitivity report analysis

Not what you're looking for?

Ask Custom Question

A farmer has a 40-acre farm in Georgia. The farmer is using linear programming to determine how many acres of corn, peanuts, and cotton to plant. Each crop requires labor, fertilizer, and insecticide, and the farmer has formulated the linear programming model below, and solved it in excel solver, with the results and sensitivity report given below. Note that the model is a profit maximization problem. The farmer has estimates of revenue per acre for the three crops, and has estimated the cost per acre for each crop, where the costs included are, among other things, the labor, fertilizer, and insecticide costs. Using the revenue and cost estimates, he or she has calculated the profit per acre for each crop. The farmer owns the land and considers that a fixed cost, not a variable cost, so that the cost of land is not included in the profit calculations, but the costs of labor, fertilizer, and insecticide are included.

Please refer to the attachment for complete question.

Attachments
Purchase this Solution

Solution Summary

Sensitivity report analysis is integrated.

Purchase this Solution


Free BrainMass Quizzes
Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Probability Quiz

Some questions on probability

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts