What is the optimal cash flow result

Assignment Help Operation Management
Reference no: EM131228624

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?

Reference no: EM131228624

Questions Cloud

Based on the current age of the head of the household : Long-Life Insurance has developed a linear model that it uses to determine the amount of term life insurance a family of four should have, based on the current age of the head of the household.
Innovation strategy compared to cost leadership strategy : In preparation for this discussion, read Align Pay With Business Priorities to Reap Rewards. Compensation is an important element of a high-performance workplace. It is critical to ensure that the compensation philosophy is aligned with the overall o..
What demands should she predict : A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. What demands should she predict?
Six sigma business strategy vs. six sigma program : You are hired as a Six Sigma Black Belt of a Biotech company. Your company just went through a product recall after critical defects were reported in several product complaints.  Indicate your process current sigma level (current baseline) and short ..
What is the optimal cash flow result : 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. What is the optimal cash flow result? What change in cash flow for wheat..
Leadership theory and behavioral organizational theories : Contingency Theory – Leadership Theory - Behavioral Organizational Theories - Organizational Motivation Theories –
About the plans on selling : Professor Himes announces that she plans on selling the answers to Exam 1 at a very reasonable price of $500.00. Kate gives Professor Himes a check for the stated amount. Professor Himes
Agreement to arbitrate : Agreement to arbitrate In the event of a dispute between you and us arising under or relating to this Account, either may choose to resolve the dispute by binding arbitration, as described below, instead of in court.
Test marketing to increase chances of success of product : If you were marketing for General Mills, explain what examples of when you would use a survey, experiment, and test marketing in research for the company. For example, if General Mills is launching a new cereal, how would the company use surveys, exp..

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd