Ask Operation Management Expert

Use complete sentences to fully answer the questions.

An agribusiness manager is evaluating plans for the use of the acreage in Farm #39.     There are three crops that could be planted, canola, alfalfa and wheat on the 1000 acre farm.

The market prices that are acceptable for planning purposes indicate that each acre in canola will yield revenue of $600, alfalfa will yield $500 per acre, and wheat will yield $450 per acre.  Seed and fertilizer costs are $40 per acre for canola; $80 for alfalfa and $80 for wheat.  Labor costs $10 per hour, regardless of crop.  However, each acre of canola requires 5 hours of labor, alfalfa requires 3.5 hours and wheat requires 4.5 hours.  

Water is a scarce resource at Farm #39.  Each acre of canola requires 0.6 acre-feet of water; alfalfa requires 0.3 acre-feet per acre; and wheat requires 0.2 acre-feet per acre.  For planning purposes, water costs $150 per acre-foot and the best estimate of total water availability is 450 acre-feet.

Recent changes in immigration law suggest that there will not be more than 3800 hours of labor available.  

The management of the agribusiness is interested in getting as much cash flow as possible; for their purposes, this is considered to be revenue from the crop minus the costs of seed, water and labor.

Set up and solve the problem in Excel using Excel Solver.

Use Solver Sensitivity Report to answer the questions below.

Each question is independent.  

Use only the sensitivity report given to answer the question, do not re-solve the problem.

C = NUMBER OF ACRES OF CANOLA TO PLANT

A = NUMBER OF ACRES OF ALFALFA TO PLANT

W = NUMBER OF ACRES OF WHEAT TO PLANT

MAXIMIZE CASH FLOW = 420C + 340A + 295W

ST

C + A + W <= 1000

0.6C + 0.3A +0.2W <= 450

5C + 3.5A + 4.5W <= 3800

Use the Solver Sensitivity Report to answer the questions below.   

1.  What is the optimal solution?

2.  What is the optimal cash flow result?

3.  What change in cash flow for wheat is necessary in order to change the recommended plantings to include wheat?

4.  If 100 additional acre-feet of water could be obtained, what would be the value to the firm?

5.  If 50 additional acres could be obtained at a cost of $135 per acre, should the firm acquire the additional acreage?  Why or why not?

6.  Within what limits could the cash flow per acre for canola range before the optimal solution changes?

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M91984530

Have any Question?


Related Questions in Operation Management

Conflictdefine functional versus dysfunctional conflict in

Conflict Define functional versus dysfunctional conflict in a work group and explain how you can increase functional conflict and decrease dysfunctional conflict. Develop a response that includes examples and evidence to ...

For this assignment you will need to find 2 articles in

For this assignment, you will need to find 2 articles in business that can help describe what are IT strategic initiative being undertaken by an organization are like. Choose a different organization for each of the arti ...

Coping with problems joe is a little nervous he has just

Coping With Problems Joe is a little nervous. He has just been transferred from another plant to take over a production line. Production is down and there is a serious problem with absenteeism. To make matters worse, the ...

Over 30 years ago michael porter identified a holistic

Over 30 years ago Michael Porter identified a holistic approach to understanding how competitive forces shape strategy. He posited that the only way to truly insulate an organization from underlying economic volatility i ...

You are the contracting officer for an air-to-ground

You are the contracting officer for an air-to-ground missile development program. A contract for pre-production models of the missile was awarded by your predecessor and the contractor is behind schedule. In a program me ...

The ikea case provides an excellent opportunity to apply

The IKEA case provides an excellent opportunity to apply strategic management concepts to a large privately-held company that is expanding into India. IKEA is a Netherlands-based Swedish company with a presence in 44 cou ...

Can you answer for me the following questions about social

Can you answer for me the following questions about social loafing and the three main causes of free-riding. 1. Give a description of the phenomenon of social loafing. 2. Give a description of the phenomenon of free-ridi ...

1 analyzing the bridgestonefirestone and ford motor company

1. Analyzing the Bridgestone/Firestone and Ford motor company, is it sufficient to use the ISO/QS 9000 standards as the main basis of vendor/product selection? 2. What position to these cars company ( 1. Volkswagen, 2. F ...

Research the effect of primary and secondary seat belt laws

Research the effect of primary and secondary seat belt laws on the occurrence of motor-vehicle injuries and fatalities. Explain how epidemiologic studies influenced the development of current seat belt laws. Describe how ...

Please provide a brief paragrap of the key takaways from

Please provide a brief paragrap of the key takaways from each of the following topics: Designing Clear Visuals in business reports Designing Successful Documents and Websites Writing Winning Proposals

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As