Purchase Solution

Linear Program - Margaret Black's family

Not what you're looking for?

Ask Custom Question

Margaret Black's family owns five parcels of farmland broken into a southeast sector, north sector, northwest sector, west sector, and southwest sector. Margaret is involved primarily in growing wheat, alfalfa, and barley crops and in currently preparing her production plan for next year. The Pennsylvania Water Authority has just announced its yearly water allotment, with the Black farm receiving 7,400 acre-feet. Each parcel can only tolerate a specified amount of irrigation per growing season, as specified in the following table:

Parcel Area(Acres) Water Irrigation Limit(Acre Feet)
Southeast 2000 3200
North 2300 3400
Northwest 600 800
West 1100 500
Southwest 500 600

Each of Margarets crops needs a minimum amount of water per acre and there is a projected limit on sales of each crop. Crop data follow:

Crop Maximum Sales Water Needed per Acre(Acre Feet)
Wheat 110,000 bushels 1.6
Alfalfa 1,800 tons 2.9
Barley 2,200 tons 3.5

Margaret's best estimate is that she can sell wheat at a net profit of $2 per bushel, alfalfa at $40 per ton, and barley at $50 per ton. One acre of land yields an average of 1.5 tons of alfalfa and 2.2 tons of barley. The wheat yield is approximately 50 bushels per acre.
A. Formulate Margaret's production plan
B. What should the crop plan be, and what profit will it yield?
C. The Water Authority informs Margaret that for a special fee of $6,000 this year, her farm will qualify for an additional allotment of 600 acre-feet of water. How should she respond?
Create an Excel spreadsheet for this problem

Purchase this Solution
Solution Preview

A. Formulate Margaret's production plan

Please see the attached excel file - blue cells are given data, red cells are decision variables, constraints and objective function is ...

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

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.

Solving quadratic inequalities

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

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

View More Free Quizzes
Related BrainMass Solutions

  • Production Planning & Scheduling Problem (Agriculture)

    32341 Production Planning & Scheduling Problem (Agriculture) *Problem and Answers Below* *PLEASE TELL ME HOW THESE ANSWERS WERE DERIVED AT* (Agriculture production planning problem) Margaret Black's family owns five parcels of farmland borken into

  • Functionalist Perspective: Black American & the Media

    Oprah seems to have risen above the stereotype of Black's, and experienced as a real person. However, other films, especially of the past, Black's carry the stigma's etc. but this is a mere representation of the way things used to be.

  • Tax Issues for Incorporation: some ownership to daughter

    There are other options to accomplish the transfer of ownership including corporate life insurance, transfer as of the date of death included in a will, or even a family limited partnership which holds the stock of the corporation.

  • Required probability

    In Chapter 2 we wrote a system of linear equations using matrix notation. We can do the same thing for the system of linear inequalities in this chapter. a.

  • Erikson's Theory of Personality

    109044 Erikson's Theory of Personality Your group has been hired by an advertising firm that is developing a series of commercials for family-oriented products geared toward the entire family.

  • Advantages of the different forms of ADR

    Black's Law Dictionary defines ADR as: "A procedure for settling a dispute by means other than litigation, such as arbitration, mediation, or minitrial." Black's Law Dictionary, Deluxe Seventh Edition, Bryan A. Garner, Editor in Chief, 2001.

  • Death Penalty Sentencing

    Black's Law Dictionary defines arbitrary as "...in an unreasonable manner, as fixed or done capriciously or at pleasure" (Black et al., 1991).

  • Discuss: Tort Education

    conduct (Black's Law, 2009).

  • Expansion of Services and Capabilities

    For this Margaret Harrison will have to enter into an agreement with these practice groups so that they can run services for Margaret Harrison.

View More Related Solutions