Forecast sales using weighted average variance

Forecasting your sales using a Weighted Average Variance is similar to calculating with Weighted Averages, except this formula actually lets you eliminate random outliers from being included in the calculations. TimeForge offers a very customizable Sales feature, and this lesson is designed to help you navigate through setting up a weighted average variance forecasting configuration painlessly. After configuring Sales Categories, you’ll likely want to consider setting up ShiftBuilder Rules so you can start generating schedules with the ShiftBuilder based on your Sales Projections.

Of course, if you need any further assistance, please don’t hesitate to contact us.

Understanding weighted average variance.

Forecasting your sales using a Weighted Average Variance can help to eliminate random outliers from being included in the calculations. It’s what happens when you’re calculating a grade for a class, but the teacher lets you drop your lowest grade, but only if it’s 30 points lower than the average of your other grades.

The following is an explanation of each setting under the “Weighted Average Variance” category.

Understanding weighted average variance.

1. Look at last year, month, or week? By day or by date?

Should the algorithm pay attention to a day from last week, from last month, or from last year? Select whichever option is the best indicator for sales.

Should the algorithm search by date or by day? For example, If it’s forecasting for June 2, 2013, should it look at June 2, 2012 (date) or the first Sunday in June in 2012 (day).

2. Look for how many days? By day or by week?

Enter into this field the number of days that the alogorithm should consider. Additionally, select whether the algorithm should look for these days by day or by week. In the example above, we’re considering 8 weeks in the future and 8 weeks prior to today to find the forecasted number. (It would be 8 days if “day” was selected)

3. Use forecasts if actuals aren’t available? Or skip?

This option indicates what TimeForge should  do if there are no Actual Sales for the algorithm to calculate from. Choose to either use the forecasted sales for that date as the basis for the current forecast, or simply skip that day.

4. Calculate variance by 1-hour intervals?

Since our forecasts are based on hourly sales, this option determines if we run the algorithm based on 1-hour intervals or based on 15 minute intervals (if unchecked, we use 15 minute intervals).

5. Use Median Averages?

This option determines if we use median averages or raw data. If you check this box, the algorithm will use median averages with the percentage in step 6 to exclude any “random” sales data.

6. Enter the allowed range for the median average.

How far from the “middle” should we base the forecast on? In the example above, any data above or below 33.3% of the average will be excluded from the forecast calculations.

heartWhat some of our clients have to say ...

We are one year into it now, well past being enamored with the newness. We are married to TimeForge. It's as essential to us now as any of our management tools today, and we very happy about that.- Steve @ Hermosa Cyclery
We really like the program so far. I know that it is geared towards restaurants, but we are a real estate company and we love it because it is inexpensive and it is so easy to use.- Nicole @ Exit Premier Realty
The Timeforge scheduling system has not only increased our efficiency tremendously; decreased the errors in what is normally an error prone environment; it has also saved us ten times what it costs us each month.- Michael @ Tiara Cafe
I would highly recommend TimeForge to anyone making work schedules. ... What used to take 1-2 hours, now takes 15 minutes. The reports section is comprehensive and useful.- Lawrence Payne @ Mid Pacific Country Club
I've been really pleased with this latest version of TimeForge. I'm really getting familiar with this program and its become a great time saver! Keep up the good work!- Loren @ Fresh Produce
Before using TimeForge, creating a schedule took 2 hours. With TimeForge, it takes less than 10 minutes.- Gail @ Kerr Drug

Quick Contact

7412 University
Suite 9
Lubbock, TX 79424

Phone: 1 866 684 7191
Fax: 1 866 684 7191


About TimeForge

The best tools available for managing labor in the retail, restaurant, food-service, and hospitality industries. Includes applicant tracking, time management, employee scheduling, payroll, and other labor management tools.

© 2010 Labor Management – TimeForge Manual | All Rights Reserved