1. IMPLAN - Support
  2. Community
  3. Analysis Questions

Contribution Analysis- Beef Industry

Avatar
akerna
I am conducting a contribution analysis of the [u]beef industry[/u] in Arizona using 2011 data. The analysis should include both (11) Cattle Ranching and Farming as well as (59) Animal (except poultry) slaughtering, rendering, and processing; thus leading me to conduct a multi-industry contribution analysis. I am concerned that the current results are not accurate- particularly that they may include the dairy industry. According to IMPLAN, the (12) Dairy Cattle and milk production sector does not exist in the state of Arizona. Experts in the field have told me that this is certainly not true and BLS QCEW data support this (2,600 employed in Dairy as compared to 600 employed in beef cattle farming and ranching, including feedlots). I was thinking that dairy could have been classified in (11) cattle ranching and farming due to the fact that most of the feedlots in the state support a large majority of dairy cattle, but the output numbers don't seem to add up. The $800 million seems low if it's including BOTH industries. (1) In this model, where is dairy cattle classified? (2) If classified within cattle ranching and farming, how would I parse out only the beef industry's contribution? (3) Additionally, is there a way to only include the beef animal processing in sector 59? It looks like a majority is cattle, but accounting only for cattle is preferable. Thanks in advance! Ashley
Was this post helpful?
0 out of 0 found this helpful

Comments

9 comments

Sort by Date Votes
  • Avatar
    IMPLAN Support
    Hello Ashley, We apologize. We see the problem that you are seeing and are working on a resolution for you. We will post it as soon as it's ready. Thank you for you patience, Please let us know if you have any additional questions. IMPLAN Support Team
    0
  • Avatar
    IMPLAN Support

    Hi Ashley, We do not use CEW for the agricultural sectors, as it is very incomplete. Instead, we turn to ERS and the BEA. Unfortunately, the ERS data do not come in a consistent format across states and our data program missed Arizona’s Dairy sector. Here are the missing values, which you can put into IMPLAN by customizing the Study Area Data. We apologize for the inconvenience and appreciate you pointing this out to us.

    0
  • Avatar
    akerna
    Thank you for providing that information. We will also likely be performing a beef industry contribution analysis for individual counties within Arizona. Could you provide the data for individuals counties as well? What about congressional districts? Is there a way that we can check to ensure that this hasn't happened for other sectors? I assume that prior to performing any analysis on future projects I will need to customize the model to include this sector, correct? Thank you for your help! Ashley
    0
  • Avatar
    IMPLAN Support

    Hello Ashley, It looks like Oilseeds and Poultry were missed too. In regards to the other data. Have you already purchased county level and Congressional District level data for AZ for 2011? Again we apologize for this problem.

    0
  • Avatar
    akerna
    Yes, we have purchased the AZ 2011 State Plus Package (US, AZ, counties, congressional districts, and zip codes). Ashley
    0
  • Avatar
    IMPLAN Support

    Hi Ashley, Thanks for getting back to us. We are going to rerun the data for AZ and replace your files for you. Unfortunately this may take about a week to fully accomplish, but this will make it so that you don't have to do any manual Customizations for any of your models once we get the new data to you. If you need any county of Congressional District level data between then, please let us know and we will work to get you the numbers so that you can customize that region until we are to provide you the model. If you could please send us your contact information to support@implan.com, that would be great, and that way we contact you and get the data onto your system as soon as it's ready. Thanks!

    0
  • Avatar
    akerna
    Thank you for replacing the AZ and trade flow data. As I have begun to work with the updated data I've found some discrepancies between the previous data set and the one I was just sent and I was wondering if I could have those clarified and/or corrected. First and foremost, I noticed that the new data set has a higher GRP for the entire state or Arizona (on the order of $2 billion). I just wanted to make sure that that's the new data is an accurate representation for 2011. Additionally the outputs for a cope of the sectors included in my analysis (Sector 59 and 92) have decreased slightly. Finally, and I believe this is the biggest concern, the RPC for some of the critical inputs has decreased dramatically. For example, looking at Social Accounts>Balance Sheets> Commodity Demand for Sector 11 the original data set stated the following demand for commodity 3010 (all other crop farming): Gross Absorption= 12.41% Gross Inputs= $101,265,691 RPC= 66.593% Regional Absorption= 8.263% Regional Inputs= $67,436,366 The newest data (which I downloaded yesterday) states: Gross Absorption= 12.41% Gross Inputs= $101,289,866 RPC= 6.026% Regional Absorption= 0.748% Regional Inputs= $6,103,366 This jumped out at me in particular because ranchers stated that a large majority (upwards of 85%) of hay and alfalfa come from within the state. Any assistance is appreciated! Ashley
    0
  • Avatar
    IMPLAN Support
    Hello Ashley, We apologize that this post was not addressed. We had an internal communication issues where we thought it had been resolved over the phone. We will have an answer for you on Monday, and we apologize again for this. We would get you an answer this evening, but all our data staff is out for the weekend.
    0
  • Avatar
    IMPLAN Support
    Hey Ashley, I was actually able to track down an answer for you! Again we are so sorry. The previously high RPC was an artifact of the mistake in the outputs of various agricultural and forestry sectors in the first release of 2011 data - the mistake occurred in all states, which affects trade amongst the states (and thus, RPC). AZ's RPC for commodity 3010 was just 4.035% in 2010 and 6.446% in 2012, so the new 2011 RPC looks great! Hopefully this will answer your question, but if not please let us know.
    0

Please sign in to leave a comment.