Oregon State University
Washington State University
University of Idaho
 
Direct Seed Conferences
 
 
  2002 Table of Contents

Integrating Financial and Production Information Systems - Why & How Do We Get There?

PNW Direct Seed Conference, Spokane, WA January 16-18, 2001
By Dick Wittman, Lapwai, Idaho farmer/agribusiness consultant

One of the fundamental tenets of Direct Seeding is that it will "improve economic and environmental sustainability." Looking at the economic side, farmers who have successfully transitioned to this practice claim:

  • Lower operating costs and increased operating margins
  • Increased capital asset use efficiency

The combined impact of these two benefits ultimately should be reflected in increased Return on Equity (ROE). Is this a claim we can objectively measure? If so, what kind of information do we need to track our progress?

The goals of this presentation are as follows: (1.) Discuss the concepts that need to be thought through in building a Management Information System, and (2.) Set the stage for the other two panel speakers to share with you their experiences on: how these concepts can be implemented; obstacles and successes they have encountered along the way, and finally, the benefits of going through the labor pains.

Twenty Years Ago…Life Was Simple. Our farm had the following characteristics:

  • six families owning, operating and being supported by the farm
  • Three crops + hay
  • Calves sold after weaning
  • No timber "management"
  • Lots of "recreational farming"
  • Home storage - seed only
  • High margins - little concern about enterprising
  • Lots of Vacation breaks between seasons

"…after 20 years of Transition and Change" we have substantially changed the face of the business to preserve a sustainable operation for the future. The farm now encompasses:

  • 16 different crops
  • Tripled in size over 20 years
  • Four partners plus two hired employees
  • Calves are fed through retained ownership
  • We are now "managing" timber - harvesting, replanting
  • Several rental houses and land development with building lots
  • Numerous strategic alliances, joint ventures
  • Self-service fertilizing and no-till seeding
  • Expanded home storage
  • Long haul trucking
  • Sell in local, regional, & foreign markets
  • Numerous "value added" crops
  • Equipment rental business

We are constantly asking the following questions:

  • Which activities are keeping us successful?
  • What strategic changes should we implement?
  • What information do we need to make good decisions?

As farm managers, we all might be asking ourselves, "Are We Flying by the Seat of Our Pants?"

  • Are we marketing grain with no idea of cost/bushel?
  • Are we buying crop insurance with no clear idea of dollars at risk?
  • Are we negotiating leases/land purchases without clear understanding of production margins?
  • Are we tampering with tillage strategies without knowing our cost per acre, per hour, or per bushel IMPACT?

Fundamental Premises of Management Accounting--Management Accounting is designed to provide the business manager with critical information useful for making better decisions. The importance of a good managerial accounting process is reflected in the following premises:

  • Long term survival is a function of success in key financial areas (KPA's): liquidity, solvency, profitability, debt service capacity, and financial efficiency
  • KPA results are a function of the quality of decisions made
  • Quality information helps optimize decisions
  • Managerial information must go beyond financial reporting to answer key questions about business performance

The following schematic summarizes the Dupont Financial Model. The Dupont Model illustrates the interdependence of several key financial ratios. This model can be used to see how all operating, financing and capital investment decisions and performance ultimately impact Return on Farm Equity. This model is helpful in identifying what performance areas are good and bad. But it does not reveal anything about why performance is bad or good, nor does it shed any information on who is responsible for good or bad performance. The answers to these questions lie in a more comprehensive Management Information System.

Table 1
Select Image to view data information.

M. I. S. Hierarchy - The following schematic illustrates the relationships between tax reporting, external financial reporting and managerial reporting. Traditionally, farmers have concentrated on the first level-tax reporting. Increasing emphasis has been given to the second level over the last 20 years. Farmers with encouragement from lenders and farm management educators are seeing increasing importance of looking at accrual vs cash income, cost versus market valuation of balance sheets, and the capacity of our operations to service debt and capital asset replacement requirements.

Our challenge in the future will be to add the third layer to our information systems, if we are going to really achieve good information for decision-making.

Table 2

The third level allows us to drill down deeper into the financial and operating aspects of our business to answer some of the following key managerial questions:

  • What is my margin in each profit center?
  • What is my cost of production & how do I compare to my peers versus my own historical trends?
  • How are my cost and margin trends impacted by: changes in tillage strategies; growth in the business; price & yield variability; key input cost trends (fertilizer, fuel, interest rates)
  • How much capital am I employing and how is my capital use efficiency impacting my bottom line?

Farmers en masse tend to be frustrated when it comes to building a good Management Information System

  • We find ourselves spending too much time doing repetitious data handling for lenders, regulators, and landlords. Many farmers complain, "I'd rather be farming!"
  • Software often doesn't accommodate PNW crops and topography
  • "Gadget Fever" has lead many farmers down an inefficient path. Farmers often put the cart before horse by buying the toys to see what they can do versus defining information needs, then buying/building integrated information systems
  • Gadgets often don't "communicate" - accounting, field records, GPS, etc.
  • We find it hard to cost justify fancy gadgets and software

Decisions that require good information can generally be placed in two categories:

  • Operating Decisions: production, marketing, capital, financing
  • Strategic Decisions: enterprise mix, tillage strategies/systems, in-sourcing vs. outsourcing, capital replacement, business growth, landlord leasing terms, value-added ventures, succession, tax management

The following discussion illustrates common farm management decisions we are forced to make and highlights the information we need to make an informed decision:

Production Decision: Which crops to plant; what rotation to follow; and what tillage strategy should we follow?
Information Needed:

  • Fixed & variable income and expense components by profit or cost center
  • Consolidation of "pieces" into a systems analysis to determine whole farm plan/budget feasibility & compliance with other parameters (conservation goals, farm program compliance)

Marketing Decision: What and when to market?
Information Needed:

  • Yield and Price Projection -History Based
  • Cost of production*
  • Price target or Breakeven Point (BEP) to cover: fixed and variable costs of production, family living, and a targeted return on investment
    * Studies show only 10-15% of producers know their cost of production!

Strategic Decision #1: In-Source or Out-Source a Key Farming Activity?
Examples of Decision Areas:

  • Seed treating, feed processing
  • Input application (spraying, fertilizing, seeding, baling, harvesting, trucking)
    Information Needed:
  • Direct and indirect costs of doing "in-house"
  • Industry standard rates or custom charges

Strategic Decision #2: Direct Seed or Conventional?: Is Direct Seeding (NT) or conventional tillage more optimal?
Information Needed:

  • Revenue projections under alternative systems
  • Cost of production under alternative systems
  • Detailed costs of performing select tillage functions (plowing, cultivating, seeding, etc.)

Strategic Decision #3: Farm Succession & Growth

  • How many families can the farm support?
  • What growth strategy should we pursue?

Information Needed:

  • Revenues generated per full time family unit
  • Equipment & Other Overhead Costs per acre & per bushel
  • Value of compensation & benefits to support each family unit - total $, per acre, per bushel

Strategic Decision #4 Contingency Planning - Government Pmts: What will we do different if farm subsidies are cut or re-directed?
Information Requirements:

  • $ per acre, per bushel
  • Breakdown of payments: True commodity revenue - LDPs, disaster payments, cost recovery revenue - conservation payments, non-commodity revenue - AMTA, MLA, etc

National Debate Over Which Analysis Method Is Best? Academicians, economists, farm consultants and farmers have struggled for decades on the ideal way to analyze financial information. Each of the following methods serve unique purposes, but each also has its own source of data integrity. A common problem in managerial reporting is users mix up the analysis systems below without a clear idea of how these analysis systems are different.

  • Cash Based Analysis - This analysis is focused on what is required to meet cash commitments
  • Accrual Based Financial Analysis - This looks at what is required to cover accrued cost of production
  • Economic Analysis - This analysis considers both accounting and opportunity costs and returns. It is best done by first developing a foundation analysis based on true accounting transaction-based costs, then supplemented with opportunity cost comparisons (i.e. opportunity charge for land, equipment or other resources owned)

Farm Financial Standards Council (FFSC) - Managerial Accounting Project -This is a project producers should be monitoring closely. For the past two years a special Task Force on the FFSC has been working on developing national guidelines for managerial accounting and analysis. A key focus of this project has been to develop a consistent approach for calculating Total Cost of Production. This analysis is essential for:

  • Assessing performance of manageable segments of the business
  • Making marketing and peer comparisons
  • Performing alternative investment analyses

Through developing these guidelines we hope producers can also reap some of the following benefits:

  • Identify profitability by enterprise
  • Focus on opportunities for cost reduction, enterprise shifting, re-allocation of resources, and other strategic changes
  • Develop critical data for lease negotiations re: production costs & revenue sharing
  • Be more proactive in marketing after knowing true costs and breakevens

1The Council is a volunteer organization with a 40-member board of directors composed of agricultural producers, consultants, accountants, lenders, supply and Ag Service companies, and university/extension staff. The Council provides education and a national forum to facilitate the development, review, communication, and promotion of uniformity and integrity in both financial reporting and the analytic techniques useful for effective measurement of the financial position and performance of agricultural producers.

A number of producer accounting issues were tackled in this project:

  • Sorting out Accounting and Economic Analyses
  • Identifying manageable segments
  • Profit/Cost center report formats
  • Handling unusual transactions - govt pmts, internal transfer pricing
  • Developing Standard Definitions: Direct vs indirect; variable vs. fixed
  • Developing alternatives for allocating indirect costs (I.e. overhead)
  • Integrating financial and physical quantities ($, bu, acres, employees)
  • Clarifying numerous technical issues -- inventory valuations, equipment gains/losses
  • Case Studies - Sample Farms

Ideal Format for a Profit Center Analysis -One of the biggest issues debated in this project is "What format should the Profit Center Analysis take on?" The following template represents the latest Task Force consensus on a model Profit Center Report. If all producers in a given commodity field could track and subtotal performance data consistent with such a format, it could be invaluable for analysis of historical trends and peer comparisons. Our next panelist, Nate Riggers, will illustrate how these concepts are actually applied in his operation.

Table 3

Producers interested in further information can access the councils efforts on the following website: www: ffsc.org

Information Tools Used To Improve Farm Management Decisions …(or, Complicate Our Lives!) Commercial vendors have developed and marketed a diverse mix of tools we can use to accumulate and access information. These tools could be grouped in the following categories:

  • Accounting Systems
  • Field Record Systems
  • Yield Monitoring Systems
  • Mapping Systems

Accounting software vendor options continue to consolidate. There only a handful of specialized agricultural accounting software developers left, where once upon a time, there was a mob pushing their own products. The following are common products used widely across U. S. farms and still actively supported:

  • Quicken
  • Quickbooks and Quickbooks Pro
  • Horizon/FMS and Perception Acctg*
  • Red Wing Systems*
  • FBS Systems - Norm Brown
  • Ag Base - Allen Lash
  • Homegrown Systems
    *Bought out by Active IQ October, 2001

Field Record System Options have struggled to provide a user friendly, practical software package that works in the northwest. The need for better management information as well as increasing reporting requirements from a myriad of regulators has many producers looking for a more automated record system. The following software systems have been used with limited success:

  • Field Manager (Harvest Horizon)
  • Farm Works
  • Easi Crops
  • Settler

Yield Monitors are seeing increasing use by farmers. But they are perceived as expensive and many don't know what to do with the data once they get it. Popular systems include:

  • John Deere Green Star
  • Case/IH Ag Leader
  • Fieldstar - AGCO/Massey Ferguson

Guidance/Variable Rate Application (VRA) Systems have been used increasingly by farmers for two decades. Some of the following brand names may be familiar to you:

  • MicroTrak
  • Trimble
  • Outback
  • Mid-Tech
  • Raven
  • Dickey-John

The following mapping software options are being investigated by more and more farms:

  • Farm Works
  • Agris
  • Easi-Map

Technical Gadgets Required to Play "Farmer Star War Games" - Farmers love toys. When the "farming game" shifts to information management, we find ourselves looking at having to buy or borrow some of the following hardware items:

  • Desktop and Laptop Computers
  • Handheld computers (ipaq, Jornada, Palm)
  • VRA computers (Dickey John, Raven, Micro Trak, Mid-Tech)
  • Yield Monitors
  • GPS units
  • Guidance Systems - track bars, automatic controllers

Summary -We could summarize the key issues surrounding building a quality Management Information System by answering the following:

  • What information do I need?
  • What software and hardware gadgets do I need to allow me to efficiently gather and retrieve the information?
  • What outside expertise is required?
  • What is the cost/benefit of information gathered?

What incentive do we have to build a good MIS? It helps to look at proven "Profits" that have resulted from good decisions. The following are areas where significant profits or cost savings have resulted from accessing and analyzing good information:

  • PIK program crop conversion (partial budget analysis software showed how a good wheat crop into hay for PIK increased farming profit by $60,000)
  • Buy vs. Lease decision (farmer kept meticulous records on maintenance costs and hours of use for each power unit - combines, trucks, tractors. This information helped him to determine the optimal way to acquire a new combine and tractor. The analysis showed a $7,000 gain from leasing the combine and a $8,000 benefit from owning the tractor based on projected hours of use.)
  • Sale of equipment for premium price (Farmer had excellent service records that persuaded a buyer to pay a $3,000 premium for a piece of equipment.)
  • Cut unprofitable enterprise (a detailed profit center analysis looking at each commodity raised and persuaded a grower to eliminate one enterprise that was hurting the business, increasing profit by $60,000)
  • Switching to Direct Seeding (accurate historical tillage cost data enabled producer to compare cost of production in conventional vs. direct seed systems and demonstrated $.45/bushel drop in total operating costs per bushel and a $15 per acre increase in net income to shift to this strategy)
  • Convert from fallow to continuous crop (whole farm cropping systems simulation tools enabled a producer to simulate several cropping and lease arrangements based on good historical cost data)
  • Successful bidder on land expansion - farm planning system clearly defined variable and fixed costs and showed optimum level of rent that would enable profitable lease arrangement for landlord and operator.

The definition of a "Farmer" is changing. Historically, we have defined a farmer as a "…tiller of the soil." More and more, successful farmers are being defined as "…managers of people, resources, information and technology."

This presentation was designed to set the stage for the next speakers. I have focused on the concepts and importance of building an effective management information system. The next speakers will:

  • Describe experiences in integrating financial and production information
  • Identify challenges and obstacles
  • Demonstrate value of information accumulated
  • Identify strategies you might pursue in designing your M. I. S.

Time for Questions will be allowed at the conclusion of our final panel speakers presentation.

     
 

Contact us: Hans Kok, (208)885-5971 | Accessibility | Copyright | Policies | WebStats | STEEP Acknowledgement
Hans Kok, WSU/UI Extension Conservation Tillage Specialist, UI Ag Science 231, PO Box 442339, Moscow, ID 83844 USA
Redesigned by Leila Styer, CAHE Computer Resource Unit; Maintained by Debbie Marsh, Dept. of Crop & Soil Sciences, WSU