October 2012 // Volume 50 // Number 5 // Tools of the Trade // v50-5tt11
A Feasibility Template for Small, Multi-Species Meat Processing Plants
This article describes a spreadsheet-based template designed to help livestock producers and others examine the feasibility of operating a small, multi-species meat processing plant. The template allows users to define plant size and capacity, including the breakdown of processing activities by species and additional revenue opportunities. The spreadsheet utilizes user-defined information on capital and operating costs to develop depreciation schedules, loan amortization schedules, 10-year profit/loss projections, cash flow projections, and various measure of return on investment. An imbedded user's guide and a companion "how to use" video helps template users examine the financial feasibility of a meat plant venture.
Extension specialists have often shared tips and tools for helping producers and entrepreneurs examine the feasibility of value-added ventures (e.g., Holcomb & Muske, 2000; Marshall, Bush & Hayes, 2005; Holcomb & Johnson, 2006; Hostetler, 2007). In recent years, these efforts have included assessments of opportunities associated with the local food movement (e.g., Raison, 2010; Sharp, Clark, & Davis, 2011). The local food movement, combined with USDA's Know Your Farmer, Know Your Food program (USDA, 2011) and increased demand for organic/natural meats (FMI & AMI, 2011), has resulted in a surging demand for meat processing services. But after two decades of decline, the few existing meat processing plants have become back-logged with business. Producers trying to niche market their livestock have found themselves without timely and consistent access to slaughter facilities.
The Robert M. Kerr Food & Agricultural Products Center (FAPC) at Oklahoma State University has seen an increase in requests for assistance related to meat processing plant evaluations. Oklahoma in particular has experienced a decline in the number of small inspected plants to handle the increased demand for niche meat marketing services (Holcomb & Ward, 2002). To handle the multiple requests for assistance, the FAPC recently developed a feasibility assessment tool for small, multi-species meat processing plants.
The spreadsheet template is designed to assist livestock producers and food business entrepreneurs who may be interested in owning or operating a meat processing plant. Most do not understand the factors that impact plant operations and ownership, nor do they have the skills or experience to make sound financial decisions for a plant. Plant owners must consider the impacts of balancing a variety of potential business activities under one roof: custom packing for multiple species (cattle, hogs, sheep, goats, bison, etc.), handling wild game (e.g., deer, elk and wild hogs), and possibly operating a retail shop.
Two extremely valuable sources of information for small meat plants are the Guide to Designing a Small Red Meat Plant published by Iowa State University (Iowa State University, 2009) and the Small Meat Processors Business Planning Guidebook developed for the Niche Meat Processor Assistance Network (Gwin, Thiboumery, Garrison, & McCann, 2011). While both publications provide significant details for plant design and operations, they are also both limited by their focus on specific plant case scenarios. Neither provides a reader with tools for examining a customized operating scenario or performing a "what if" analysis. The small plant feasibility template allows users to incorporate aspects of these published guides, or information from other sources, as a starting point for a detailed financial assessment.
The spreadsheet-based model, complete with an imbedded user's guide and a companion "how to use" video, help entrepreneurs develop a financial model for a customized small meat processing plant. Information and insights provided by FAPC meat processing specialists and existing Oklahoma small meat processing plants were used to create an example (or "base") scenario, which users of the template get to see and modify to fit their specific needs.
Template users provide the appropriate information in the green-shaded cells of the following template sections:
- Operating/Production Assumptions
- Plant, Property, & Equipment (PP&E)
- Personnel Expenses
- Expense Projection
This information is used for calculations and tables in the remaining template sections:
- Market Projection
- Loan Amortization
- Operations Summary
- Return on Investment
Hyperlinks allow users to easily jump from one section to another. Many of the input cells also include pop-up comments to help users better understand the information to be provided in those cells. Password protection prevents users from inadvertently altering cell formulas or jeopardizing the integrity of the various calculations.
Figure 1 shows the "Operating/Production Assumptions" portion of the template, which contains the most designated user input cells. Users identify the slaughter capacity of the facility, the breakdown of slaughter activities for three species, any additional business generated by wild game processing or "other" revenues, and estimated monthly utility rates. This section also allows users to input information on working capital (short-term borrowing), property and income tax rates, maintenance and insurance costs (as a percent of PP&E), inflation rates for both expenses and goods/services prices, and a discount rate for use in net present value calculations. Warning messages appear if the combined slaughter capacities by species exceed the stated plant capacity.
Operating/Production Assumptions sheet for the Small Meat Plant Template
Figure 2 shows the "Plant, Property, & Equipment" (PP&E) section of the template. This section provides users the ability to input cost information on building, equipment, land, and even company vehicles. Users then identify the percent of the total PP&E costs to be debt financed and the terms for the loan, with principal and interest calculations derived on the "Loan Amortization" portion of the template. Depreciation is also estimated in the PP&E section, using straight-line depreciation for the facilities and MACRS depreciation schedules for equipment, special purpose buildings, and vehicles.
Plant, Property, & Equipment sheet for the Small Meat Plant Template
Additional information for employees ("Personnel Expenses") and supplies/miscellaneous expenses ("Expense Projection") complete the user-provided information for the template. "Market Projections" estimates the annual sales and direct production expenses for each business activity, and all income and expenses projections for a 10-year timeframe are presented in the "Operations Summary" portion of the template (Figure 3).
Operations Summary sheet for the Small Meat Plant Template
The "Return on Investment" section of the template provides a variety of return measures based on these 10-year projections: net present value (NPV), internal rate of return (IRR), present value cost/benefit ratio, return on assets (ROA), return on beginning owners' equity, and payback period. The profit/loss, cash flow, and return on investment measures automatically update with a change in any user-defined cell, allowing users to easily observe the sensitivity of results to changes in a given revenue or expense factor.
The Small Multi-Species Meat Plant template can help Extension educators, agricultural producers, and entrepreneurs decide if building and operating a USDA-inspected meat processing facility is financially viable under a variety of operating scenarios. Links to the template and the companion video are available at www.fapc.biz. The template can be downloaded from http://www.fapc.biz/files/smallmeatplant_feasability.xls. The YouTube link for the companion video is http://www.youtube.com/watch?v=hJcnL0KY864&feature=related.
Food Marketing Institute (FMI) & American Meat Institute (AMI). (2011). The power of meat: an in-depth look at meat through the shoppers' eyes—2011. Arlington, VA: Food Marketing Institute, and Washington, DC: American Meat Institute.
Gwin, L., Thiboumery, A., Garrison, D., & McCann, N. (2011). Small meat processors business planning guidebook. Corvallis, OR: Niche Meat Processor Assistance Network publication NMPAN1. Retrieved from: http://www.extension.org/sites/default/files/w/9/91/NMPAN1_Business_Planning_Guide_May_2011.pdf
Holcomb, R.B., & Johnson, A. (2006). Launch rules for small businesses. Journal of Extension [On-line], 38(1) Article 2IAW3. Available at: https://www.joe.org/joe/2006april/iw3.php.
Holcomb, R. B., & Muske, G. (2000). The role of Extension specialists in helping entrepreneurs develop successful food-based businesses. Journal of Extension [On-line], 38(1) Article 1FEA2. Available at: https://www.joe.org/joe/2000february/a2.php
Holcomb, R. B., & Ward, C. (2002). Current and changed operating characteristics of Oklahoma meat processors. Stillwater, OK: Oklahoma Cooperative Extension Service Fact Sheet F-578.
Hostetler, K. M. (2007). Answering the producers' question: Is it feasible? Journal of Extension [On-line], 45(6) Article 6FEA5. Available at: https://www.joe.org/joe/2007december/a5.php
Iowa State University. (2009). Guide to designing a small red meat plant. Ames, Iowa: Iowa State University Extension Publication PM 2077, A. Thibourmey (ed.). Retrieved from: http://www.extension.iastate.edu/Publications/PM2077.pdf.
Marshall, M. I., Bush, D., & Hayes, K. (2005). Extension programming for food entrepreneurs: an Indiana needs assessment. Journal of Extension [On-line], 43(5) Article 5RIB9. Available at: https://www.joe.org/joe/2005october/rb9.php
Raison, B. (2010). Educators or facilitators? Clarifying Extension's role in the emerging local food systems movement. Journal of Extension [On-line], 48(3) Article 3COM1. Available at: https://www.joe.org/joe/2010june/comm1.php
Sharp, J. S., Clark, J. K., & Davis, G. A. (2011). Adapting community and economic development tools to the study of local foods: The case of Knox County, Ohio. Journal of Extension [On-line], 49(2) Article 2FEA4. Available at: https://www.joe.org/joe/2011april/a4.php
US Department of Agriculture. (2011). Know your farmer, know your food (KYF2). Retrieved from: http://www.usda.gov/wps/portal/usda/knowyourfarmer?navid=KNOWYOURFARMER