Explore BrainMass
Share

# Solving a Linear Programming Problem by Using M S Excel

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

1. The Adams family owns a total of 400 acres of farmland in North Carolina on which they grow corn and tobacco. Each acre of corn costs \$125 to plant, cultivate, and harvest; each acre of tobacco costs \$235. The Adams family has a budget of \$80,000 for next year. The government rules limit the number of acres of tobacco that can be planted to 150. The profit from each acre of corn is \$240; the profit from each acre of tobacco is \$450. The Adams family wants to know how many acres of each crop to plant in order to maximize their profit.

Formulate a linear programming model for this problem by determining
(a) The decision variables.
x1 = tobacco
x2 = corn
(b) The objective function.
Maximize Z = \$450x1 + \$240x2
(c) All the constraints.
\$235x1 + \$125x2 <= 80,000
x1<=150
x1+x2<=400
x1,x2>=0