How to aggregate the resultd?
I am analyzing the economic impact of a public university. I have analyzed separately the impact of payroll, student spending, construction and business office purchases. How do I aggregate all these impacts?
Was this post helpful?
-
IMPLAN SupportHi Inder. According to your Forum Post, you have separated the impact of a public university into its appropriate categories. You could report them in those categories and that would be fine. With that said, you could combined the results into two categories: temporary and permanent impacts. Temporary impacts would include the construction results. Whereas, the permanent impacts would include business office purchases, payroll, and student spending. We strongly caution against rolling all of the impacts up into a University-wide category. Construction impacts will end when the projects are completed. However, permanent types of impacts, which are mainly operational, will last long after the construction ends. Combining these impacts will inflate the overall impact of the University long after the construction projects have ended. We would also like to comment on employment and employee compensation (EC) impacts associated with the University. As you know, the jobs in IMPLAN are just that jobs, consisting of both full-time and part-time employment. To calculate Employment from your FTE data, you need to divide your FTE estimates by the ratio. To estimate EC from Income, you need to multiply your income figures by the ratios. We have included a link below to an Excel Spreadsheet that contains a template for each of these impact variables for your use. https://implan.com/index.php?option=com_docman&task=cat_view&gid=137&Itemid=60 Finally, in your report, you should clearly state how and why you arrived at the two categories of “Temporary” and “Permanent” impacts and what is included in each category. This will help others to replicate your results and validate their accurancy. We hope this answers your question. Please contact us if we can be of further help.0 -
Thanks. As always, you are so helpful.0
-
We ran $16,700,190 construction spending (sector 34) through the model and obtained the following total impact. Employment Labor income Value added output Total effect 153.7 $6,967,826 $9,365,722 $21,437,219 My questions are; 1 Why is value added amount so much less than the value of output? 2 You state in your response that We would also like to comment on employment and employee compensation (EC) impacts associated with the University. As you know, the jobs in IMPLAN are just that jobs, consisting of both full-time and part-time employment. To calculate Employment from your FTE data, you need to divide your FTE estimates by the ratio. To estimate EC from Income, you need to multiply your income figures by the ratios. We have included a link below to an Excel Spreadsheet that contains a template for each of these impact variables for your use. implan.com/index.php?option=com_docman&a...id=137&Itemid=60 I am not sure what you mean by your statement "that jobs in IMPLAN are just that jobs, consisting both full-time and part-time jobs". 3 per your instructions, should I divide the 153.7 employment by the ratio 1.204 (for the sector 34) to obtain to employment and multiply labor income by the same ratio to get EC. 4. How do we estimate and report the operating expenses of buildings constructed with the funds spent on construction? May I thank you in anticipation0
-
IMPLAN SupportHi Inder. We apologize. We did not see the initial part of your Forum Post. The reply below relates to the bottom portion of your post. We will take a look at your Spreadsheet and provide a complete reply. For now, the reply below is for the lower half of your Post. What we mean by the statement “IMPLAN Jobs” is that IMPLAN employment figures includes full-time jobs, part-time jobs, and proprietors. To convert your initial FTE employment to IMPLAN employment for each sector, you would divide each of your sectors’ employment by its corresponding FTE-to-Employment ratio and then enter these figures in the model for each sector you are dealing with. After you have run your model and have employment impacts, to convert these IMPLAN employment estimates to FTE employment/jobs, you would multiply your IMPLAN employments by the FTE-to-Employment ratio for each sector. These numbers would be the employment estimates that you would include a report or presentation of some kind. Likewise, when it comes to employment compensation (EC), you would take your estimate of your original estimate of EC and multiply it by the EC-to-Income ratios for your particular sectors. This converts your EC to IMPLAN EC, which includes Income plus benefits and employer-paid payroll taxes. You would then use this figure as your estimate of EC to run in your model. As far as reporting the operating impacts associated with the building construction, we would suggest that you model them separately from the construction phase and report them separately. This is because construction impacts are non-reoccurring or short-term, while operating impacts are reoccurring or longer-term impacts. Examples of operational activities could include operating expenditures for the building, employment, output or sales, employee compensation/ payroll. In other words, whatever information you might have related to the operational aspects of the building or project is what you should model and not co-mingle with construction impacts. So bridge your operating expenses to the appropriate IMPLAN Sectors and run your model. When finished, you could develop summary tables for the construction phase and summary tables for the operation phase. Again, not knowing a lot about what information you have or what you are wanting to do, the above recommendations and feedback represent our best reply to your Forum Posts. We hope that this helps. Hi Inder. Here is the answer to your question about “Why is value added so much less than the value of output”? The reason is Output is the sum of Intermediate Expenditures plus Value Added. Simply stated, Output consist of all of the input purchases needed for Sector 34 to produce its output plus the value of the products made using those intermediate inputs. In terms of determining operating costs associated with the building construction project, we assume that you have those and simply need to model those impacts as well. If you do not have any information on the operational aspects of the building, then we suggest that you ask responsible persons for information on the building usage, how much each unit sales or output will be, employment needed to operate and manage the building, and other pertinent information. This is really the best way of determining what the intermediate to long-term impacts of the building will be in your study region. After you receive this information, if you need help in setting up your model, we can help. We hope this help to answer your question.0 -
Thank you very much.0
Please sign in to leave a comment.
Comments
5 comments