Forecasting Raw Material Pricing

jjramirez85

New Member
Joined
May 21, 2014
Messages
17
With recent economic and market conditions (eg. tariffs), raw material and commodity prices have fluctuated. Some, such as steel (purchased scrap), have fluctuated significantly.

If I want to use a formula for raw material pricing, does anyone suggested a specific "forecast" formula. I am using data from 2016-2018 and forecasting for Q4 2018 though Q4 2019. Currently, I am using =Forecast( , but I notice there are other options. Which is best for the scenario of raw materials and commodities?

Thanks.
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,102,435
Messages
5,486,866
Members
407,567
Latest member
spinitback

This Week's Hot Topics

Top