Hi, What is the best way to model a change in commodity price across all industries. I'm using the distribution of commodity use (gross) from the commodity balance sheets to get the use by industry. At that point it seems like I should be able to import those values into events in an industry change activity and specify the value either from the level or specifying it before hand on the excel sheet. I may be missing something basic that I should include or do differently (please advise if so). But if not, the one thing that is concerning me is the comment on the import template about budget items. Because it is a commodity purchase it sort of is a budget item and therefore the template says something about zeroing out employment. If that is the case can you explain? If it isn't the case, how are the ratios calculated in the model to match employment compensation with the employment/output. This seems like it should be obvious but I'm getting off in the 3rd or 4th decimal when I try using StudyAreaIndustryData and controlling for deflation industry and gdp. ?? (for calculating other variables in industry change event) (Ok never mind on the calculations of emp comp and other VA items. I think I got what will work. The differences between what I'm getting and what I see in the db are not significant.) If commodity matters on this analysis it is related to energy pricing. Thanks, Dale
Please sign in to leave a comment.