IDEAS home Printed from https://ideas.repec.org/a/eme/afrpps/v70y2010i1p97-125.html
   My bibliography  Save this article

Stochastic simulation using @Risk for dairy business investment decisions

Author

Listed:
  • J.M. Bewley
  • Boehlje
  • A.W. Gray
  • H. Hogeveen
  • S.J. Kenyon
  • S.D. Eicher
  • M.M. Schutz

Abstract

Purpose - The purpose of this paper is to develop a dynamic, stochastic, mechanistic simulation model of a dairy business to evaluate the cost and benefit streams coinciding with technology investments. The model was constructed to embody the biological and economical complexities of a dairy farm system within a partial budgeting framework. A primary objective was to establish a flexible, user‐friendly, farm‐specific, decision‐making tool for dairy producers or their advisers and technology manufacturers. Design/methodology/approach - The basic deterministic model was created in Microsoft Excel (Microsoft, Seattle, Washington). The @Risk add‐in (Palisade Corporation, Ithaca, New York) for Excel was employed to account for the stochastic nature of key variables within a Monte Carlo simulation. Net present value was the primary metric used to assess the economic profitability of investments. The model was composed of a series of modules, which synergistically provide the necessary inputs for profitability analysis. Estimates of biological relationships within the model were obtained from the literature in an attempt to represent an average or typical US dairy. Technology benefits were appraised from the resulting impact on disease incidence, disease impact, and reproductive performance. In this paper, the model structure and methodology were described in detail. Findings - Examples of the utility of examining the influence of stochastic input and output prices on the costs of culling, days open, and disease were examined. Each of these parameters was highly sensitive to stochastic prices and deterministic inputs. Originality/value - Decision support tools, such as this one, that are designed to investigate dairy business decisions may benefit dairy producers.

Suggested Citation

  • J.M. Bewley & Boehlje & A.W. Gray & H. Hogeveen & S.J. Kenyon & S.D. Eicher & M.M. Schutz, 2010. "Stochastic simulation using @Risk for dairy business investment decisions," Agricultural Finance Review, Emerald Group Publishing Limited, vol. 70(1), pages 97-125, May.
  • Handle: RePEc:eme:afrpps:v:70:y:2010:i:1:p:97-125
    DOI: 10.1108/00021461011042666
    as

    Download full text from publisher

    File URL: https://www.emerald.com/insight/content/doi/10.1108/00021461011042666/full/html?utm_source=repec&utm_medium=feed&utm_campaign=repec
    Download Restriction: Access to full text is restricted to subscribers

    File URL: https://www.emerald.com/insight/content/doi/10.1108/00021461011042666/full/pdf?utm_source=repec&utm_medium=feed&utm_campaign=repec
    Download Restriction: Access to full text is restricted to subscribers

    File URL: https://libkey.io/10.1108/00021461011042666?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Martin Odening & Oliver Mußhoff & Alfons Balmann, 2005. "Investment decisions in hog finishing: an application of the real options approach," Agricultural Economics, International Association of Agricultural Economists, vol. 32(1), pages 47-60, January.
    2. Huirne, Ruud, 1990. "Basic Concepts of Computerised Support for Farm Management Decisions," European Review of Agricultural Economics, Oxford University Press and the European Agricultural and Applied Economics Publications Foundation, vol. 17(1), pages 69-84.
    3. Dijkhuizen, A. A. & Renkema, J. A. & Stelwagen, J., 1991. "Modelling to support animal health control," Agricultural Economics, Blackwell, vol. 5(3), pages 263-277, July.
    4. Boehlje, Michael D. & Hofing, Steven L. & Schroeder, R. Christopher, 1999. "Farming in the 21st Century," Staff Papers 200408, Purdue University, Department of Agricultural Economics.
    5. Richard Bennett, 2003. "The ‘Direct Costs’of Livestock Disease: The Development of a System of Models for the Analysis of 30 Endemic Livestock Diseases in Great Britain," Journal of Agricultural Economics, Wiley Blackwell, vol. 54(1), pages 55-71, March.
    6. Clark Seavert & Herbert Hinman & Karen Klonsky, 2006. "A crop profitability analysis for long-term crop investments," Agricultural Finance Review, Emerald Group Publishing, vol. 66(1), pages 125-135, May.
    7. Sorensen, Jan Tind & Kristensen, Erik Steen & Thysen, Iver, 1992. "A stochastic model simulating the dairy herd on a PC," Agricultural Systems, Elsevier, vol. 39(2), pages 177-200.
    8. John Mclnerney, 1996. "Old Economics For New Problems ‐Livestock Disease: Presidential Address," Journal of Agricultural Economics, Wiley Blackwell, vol. 47(1‐4), pages 295-314, January.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Twine, Edgar E. & Omore, Amos & Githinji, Julius, 2018. "Uncertainty in milk production by smallholders in Tanzania and its implications for investment," International Food and Agribusiness Management Review, International Food and Agribusiness Management Association, vol. 21(01).
    2. J.M. Bewley & Boehlje & A.W. Gray & H. Hogeveen & S.J. Kenyon & S.D. Eicher & M.M. Schutz, 2010. "Assessing the potential value for an automated dairy cattle body condition scoring system through stochastic simulation," Agricultural Finance Review, Emerald Group Publishing Limited, vol. 70(1), pages 126-150, May.
    3. Subić, Jonel & Nastić, Lana & Nikolić, Svetlana Roljević, 2020. "Economic Effects of Investment in Dairy Farming," Western Balkan Journal of Agricultural Economics and Rural Development (WBJAERD), Institute of Agricultural Economics, vol. 2(2), December.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Stéphanie Truchet & Nicolas Mauhe & Marie Herve, 2017. "Veterinarian shortage areas: what determines the location of new graduates?," Review of Agricultural, Food and Environmental Studies, Springer, vol. 98(4), pages 255-282, December.
    2. Stott, Alistair W., 2006. "Optimisation methods for assisting policy decisions on endemic diseases," Working Papers 46000, Scotland's Rural College (formerly Scottish Agricultural College), Land Economy & Environment Research Group.
    3. Helen H. Jensen, 2005. "Infectious Disease, Productivity, and Scale in Open and Closed Animal Production Systems," American Journal of Agricultural Economics, Agricultural and Applied Economics Association, vol. 87(4), pages 900-917.
    4. Stott, Alistair W. & Milne, Catherine E. & Gunn, George J., 2009. "Evaluation of approaches to control of Maedi-Visna disease of sheep using a Markov chain simulation model for a range of typical British Flocks," Working Papers 61102, Scotland's Rural College (formerly Scottish Agricultural College), Land Economy & Environment Research Group.
    5. Li, Jian & Chavas, Jean-Paul, 2020. "The Impacts of African Swine Fever on Vertical and Spatial Hog Pricing and Market Integration in China," 2020 Annual Meeting, July 26-28, Kansas City, Missouri 304516, Agricultural and Applied Economics Association.
    6. David A. Hennessy, 2007. "Behavioral Incentives, Equilibrium Endemic Disease, and Health Management Policy for Farmed Animals," American Journal of Agricultural Economics, Agricultural and Applied Economics Association, vol. 89(3), pages 698-711.
    7. Feil, Jan-Henning & Musshoff, Oliver, 2013. "Investment, disinvestment and policy impact analysis in the dairy sector: a real options approach," Structural Change in Agriculture/Strukturwandel im Agrarsektor (SiAg) Working Papers 159229, Humboldt University Berlin, Department of Agricultural Economics.
    8. Mullen, John D. & Helyar, K.R. & Pagan, Phil, 2000. "Economic and Biological Perspectives on Off-site Effects Associated with Soil Acidification," 2000 Conference (44th), January 23-25, 2000, Sydney, Australia 123709, Australian Agricultural and Resource Economics Society.
    9. Niemi, Jarkko K. & Liu, Xing & Pietola, Kyosti, 2011. "Price volatility and return on pig fattening under different price- quantity contract regimes," 2011 International Congress, August 30-September 2, 2011, Zurich, Switzerland 114614, European Association of Agricultural Economists.
    10. Wynn, Katherine & Spangenberg, German & Smith, Kevin & Wilson, William, 2017. "Valuing Genetically Modified Traits in Canola Using Real Options," Journal of Agricultural and Resource Economics, Western Agricultural Economics Association, vol. 42(2), May.
    11. Gramig, Benjamin M. & Horan, Richard D., 2011. "Jointly determined livestock disease dynamics and decentralised economic behavior," Australian Journal of Agricultural and Resource Economics, Australian Agricultural and Resource Economics Society, vol. 55(3), pages 1-18, September.
    12. Viet, A.-F. & Jacob, C., 2008. "Illustration of some limits of the Markov assumption for transition between groups in models of spread of an infectious pathogen in a structured herd," Theoretical Population Biology, Elsevier, vol. 74(1), pages 93-103.
    13. Sandri, Serena & Schade, Christian & Mußhoff, Oliver & Odening, Martin, 2010. "Holding on for too long? An experimental study on inertia in entrepreneurs' and non-entrepreneurs' disinvestment choices," Journal of Economic Behavior & Organization, Elsevier, vol. 76(1), pages 30-44, October.
    14. Majewski, Edward & Malak-Rawlikowska, Agata, 2018. "Scenarios of the Common Agricultural Policy after 2020," Problems of Agricultural Economics / Zagadnienia Ekonomiki Rolnej 276368, Institute of Agricultural and Food Economics - National Research Institute (IAFE-NRI).
    15. Richard J. Volpe & Timothy A. Park & Fengxia Dong & Helen H. Jensen, 2016. "Somatic cell counts in dairy marketing: quantile regression for count data," European Review of Agricultural Economics, Oxford University Press and the European Agricultural and Applied Economics Publications Foundation, vol. 43(2), pages 331-358.
    16. Weldegebriel, Habtu T. & Gunn, George J. & Stott, Alistair W., 2008. "Winners and losers from Johne’s disease eradication from the Scottish dairy herd: a Markov-Chain simulation," 82nd Annual Conference, March 31 - April 2, 2008, Royal Agricultural College, Cirencester, UK 36872, Agricultural Economics Society.
    17. Lotte Yanore & Jaap Sok & Alfons Oude Lansink, 2023. "Anticipate, wait or don't invest? The strategic net present value approach to study expansion decisions under policy uncertainty," Agribusiness, John Wiley & Sons, Ltd., vol. 39(2), pages 535-548, March.
    18. Claire Heffernan & Lena Azbel-Jackson & Joe Brownlie & George Gunn, 2016. "Farmer Attitudes and Livestock Disease: Exploring Citizenship Behaviour and Peer Monitoring across Two BVD Control Schemes in the UK," PLOS ONE, Public Library of Science, vol. 11(3), pages 1-14, March.
    19. Maart, Syster Christin & Musshoff, Oliver & Odening, Martin & Schade, Christian, 2010. "Zum Desinvestitionsverhalten Landwirtschaftlicher Unternehmer: Ergebnisse Einer Experimentellen Untersuchung," 50th Annual Conference, Braunschweig, Germany, September 29-October 1, 2010 93943, German Association of Agricultural Economists (GEWISOLA).
    20. Maart, Syster Christin & Musshoff, Oliver & Odening, Martin & Schade, Christian, 2011. "Closing down the Farm: An Experimental Analysis of Disinvestment Timing," 2011 International Congress, August 30-September 2, 2011, Zurich, Switzerland 114375, European Association of Agricultural Economists.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eme:afrpps:v:70:y:2010:i:1:p:97-125. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Emerald Support (email available below). General contact details of provider: .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.