Optimization / LP Word Problem
Not what you're looking for?
A poet has inherited 90 ha (or acres) of woods from her late grandmother. The poet finds that talks in the woods makes her happy, although she has to rely on income from the woods to support her during times of writers' block. In all she has 90 ha, 40 ha of which are covered in red pine forest, the other 50 ha are covered in mixed hardwood forest. The poet wants to figure out how much land to manage under each forest type in order to maximize her revenue. She has calculated that she needs to spend 2 days/ha/year to manage the red pine and 3d/ha/year to manage the mixed hardwood. She makes $90/ha/year on the red pine and $120/ha/year on the hardwoods. In order to have enough time for her writing she wants to spend no more than 180/year working on the land.
A. Formulate this problem using algebraic notation
B. Graph the feasible region and find the optimal solution
C. User Solver in Excel to solve the problem and provide a printout of your spreadsheet. Does the optimal solution match your graphical solution?
D. Write out the dual to this problem, solve it in Excel and provide your spreadsheet.
E. What are the shadow prices on the constraints (of the primal)?
F. Say there is some uncertainty with respect to returns on hardwood management and instead of expecting $120/ha/year, the poet could expect up to $150/ha/year. How does this change the objective function value and optimal solution? Is this what you would expect? Why?
G. Assume instead that the poet is considering working 182 days in the woods instead of 180. How does this change the objective function? Explain this change in relation the shadow prices.
Purchase this Solution
Solution Summary
The spreadsheet contains primal problem formulation and solution, Dual problem formulation and solution and senstivitiy analysis report.
Solution Preview
Hi,
Please find attached word document and excel file for detailed ...
Purchase this Solution
Free BrainMass Quizzes
Basics of Economics
Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.
Economics, Basic Concepts, Demand-Supply-Equilibrium
The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.
Pricing Strategies
Discussion about various pricing techniques of profit-seeking firms.
Economic Issues and Concepts
This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.
Elementary Microeconomics
This quiz reviews the basic concept of supply and demand analysis.