Trend Forecasting

CleverQ calculates monthly totals for you when extracting data. Seasonal trends can then be calculated using the desired number of years of history and weighted averages as you see fit. CleverQ then has powerful built in Trend forecasting tools combining Regression Analysis, "Best Fit" analysis, Seasonal trends analysis to calculate nearly any forecasted metrics adjusted for seasonal trends. Trend Forecasting can be calculated on any data, Seasonal trend analysis can only be calculated on monthly data. See the Formula and information about using forecasts in nested formulas below.

CleverQ allows unlimited multiple nesting of formulas. Shown in the sample above is the desired inventory levels for a company that has a 30 day buying cycle for their product and a 60 day lead time to order. The desired inventory formula is the future quarterly moving average calculated upon the forecasted inventory calculated upon seasonally adjusted forecasted Cost of Goods and desired annual turnover. This is all calculated within CleverQ. Raw data extracted was the Cost of Goods.