Estimating office support staff

Comments

3 comments

  • Avatar
    IMPLAN Support
    Hi Daniel, Thank you for your post. To be sure that we respond correctly to your question, we have a few questions we would like some additional clarification on. 1. Would you be able to provide us with a Sector? 2. It sounds like you are saying that there is no production function for your Industry. Are you suggested that nothing is needed to create the product or service that is being sold? Presumably an Industry involving a production line would need to purchase a variety of goods and services to create their product. Or are you saying that you know the labor component, but you don't know how to estimate the goods and services for determining an appropriate Industry Sales value, since you believe that the Output per Worker is less than that of the average for your area? 3. Workforce estimates are only useful in IMPLAN if you have corresponding payroll information. Do you have that information? 4. Could you provide some additional clarification on your last statement/question, please? Are you saying that you want the IMPLAN Employment estimate because you intend to use the difference between that estimate the known Employment in order to determine what the 'rest of staff' count might be? We apologize for asking so many questions in return, but we want to ensure that we provide you the best possible guidance, and to do so requires that we understand the problem. Thanks! IMPLAN Support Team
    0
    Comment actions Permalink
  • Avatar
    Daniel Underwood
    I am working with sector 274, composite products. Our products diverge significantly from industry averages as they appear in IMPLAN. I have done some preliminary analysis, and observed sales values attributed by IMPLAN to our workforce are many magnitudes higher. I think the reason for this is we use recycled inputs at zero cost. Thus, the production functions are different. Our engineers have provided me with staffing for the production process, but not office staff. Here is an example. It will take 12 people making a product -- technicians, jr. engineer, supervisor, shipping -- that will produce $2 million in annual sales. But this company will also have a president, office assistant, someone in payroll, and sales, the composition of which I need to estimate. When I use IMPLAN, it tells me it takes 5 people to support that sales volume. Is there a way to tease this support staff out of IMPLAN? I've been in discussion with a friend who also works with the system, and we think the answer is no. But maybe you know of a way? And if IMPLAN won't get there, an alternative suggestion is welcome. Thanks!
    0
    Comment actions Permalink
  • Avatar
    IMPLAN Support
    Hi Daniel, Do you have enough information to edit the spending pattern as well? If so it may be wise to to preform the ABP methodology . By setting your analysis up this way, it allows you to customize the spending pattern of sector 274. Which will allow you to reflect that most of your inputs are recycled, although presumably you still have other typical input cost such as electricity, waste water management, toiletries, waste management etc. This method will also allow you to adjust you Value Added to Intermediate Expenditures ratios to better reflect your specific firm. As regards Employment, it is not an economic driver, so if you can obtain payroll, that is actually the ideal figure to have and the one you will need for Analysis-by-Parts. In terms of estimating those workers, you are correct there is not way to do this within IMPLAN. However you can use the following table (http://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?pid=ASM_2011_31GS101&prodType=table) to develop a ratio of :Production Workers" : "Number of Employees" for estimating your support staff Employment. Please note this table is NAICS based and the NAICS associated to this Sector is 33318. Also it is a single table, so the R/L arrows will move you through columns of data (and both columns of interest are in the opening view, so you don't need this) The Up/Down arrows on the left-hand side will move you down through different NAICS codes. Please let me know if this addresses your concern or if you have any additional questions. IMPLAN Support Team
    0
    Comment actions Permalink

Please sign in to leave a comment.