Linear programming questions using excel & analyze sensitivity
Not what you're looking for?
Bradley Family
(a) Let X1 = # of acres of corn and X2 = # of acres of tobacco
Corn Tobacco Resources Available
300 520
Land 1 1 <= 410
Budget 105 210 <= 52500
Govt. Restriction 0 1 <= 100 Government Restriction
X1 X2
Decision Variables
Objective function
(b) How many acres of farm land will not be cultivated at the optimal solution?
Do the Bradleys use the entire 100 acre tobacco allotment?
('c) Should the Bradleys' lease extral land from their neighbor at $110 per acre?
What is the maximum price the Bradleys' should pay their neighbor? And how much land shoud they lease?
maximum price
# of acres of land
(d) For each dollar they borrow , how much additional profit will they make?
If they borrowed a additional $1000, would the number of acres of corn and tobacco they plant change?
Purchase this Solution
Solution Summary
The solution gives detailed steps on solving 4 linear programming questions using excel data analysis pack and then analyzing sensitivity report for each question.
Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Probability Quiz
Some questions on probability