Weekly Forecast Projections & Adjustments

Weekly forecasting is an automated process in Ameego that runs when you begin your weekly schedules. In order to schedule a new week, you must click the ‘Calculate Forecast’ button on your schedule page. By doing this, Ameego will automatically run a 3 week average forecast from your actual sales. Once this has been calculated, you can opt to change the forecast to ‘Annual Trend’. This can only be done if you have a full year of sales in Ameego. This option will average the past 4 weeks of actual sales along with the same 4 week period from the year before. Whichever method of forecasting you use, you can also make some adjustments as required.

This document focuses on weekly forecasting and adjustments. We have added a link at the bottom of this page that will take you to our ‘Daily Forecast Adjustments’ document for a more detailed look at daily forecast adjustments. 

Calculating a 3 week average forecast

When you click on a new schedule week, Ameego will automatically run a 3 week average forecast. Simply click on the ‘Calculate Forecast’ button to begin.

3_Week_Average.gif

To see the dates we used to calculate this forecast, you can click on any day of the week and then click on '3 week average' to see how we calculated this forecast. Further adjustments to the day can be made. We will show you how to make adjustments to a day in our next guide ‘Daily Forecast Adjustments’. You will find a link for this guide at the bottom of the page.

3_wk_average_SS.png

 

Calculating an annual trend forecast

After your 3 week average forecast has been created, you can easily change this to an annual trend forecast. Follow the steps below to calculate an annual trend forecast for the week.

  1. If you are not already at the forecast screen, you can click the ‘Manage Forecast’ button to get back to the screen shown above.
  2. Be sure that you are set on the ‘Totals’ tab at the top of the graph to make this calculation for the entire week.
  3. Click ‘Annual Trend’ in the lower left edit forecast menu.
  4. Set the ‘Apply to’ drop down menu to ‘All Sales Metrics’ 
  5. Click the ‘Apply’ button.

Annual_Trend.gif

You can click on any day of the week and then click on ‘3 Week Average’ to see the dates we used to calculate this forecast. Further adjustments to the day can be made. We will show you how to make adjustments to a day in our next guide ‘Daily Forecast Adjustments’. 

Adjusting the weekly forecast by percentage

You can also adjust the whole week's forecast by percentage. You can also do this for a single day, but we cover that in our next guide called ‘Daily Forecast Adjustments’. To adjust the week by percentage, follow the steps below. 

  1. If you are not already at the forecast screen, you can click the ‘Manage Forecast’ button to get back to the screen shown above.
  2. Be sure that you are set on the ‘Totals’ tab at the top of the graph to make this calculation for the entire week.
  3. Click on ‘Adjust By Percentage’ on the lower left edit forecast menu.
  4. Enter a percent value in the box provided to increase your forecast. Use negative numbers here if you need to reduce your forecast.
  5. Set the ‘Apply to’ drop down menu to ‘All Sales Metrics’ 
  6. Click the ‘Apply’ button

Recalculating a forecast

We know that sometimes you need to create your schedules weeks in advance. If this is the case, we recommend that you recalculate your forecast about a week before the actual week in order to get a more accurate forecast. Follow the steps below to recalculate a forecast. 

  1. Click the ‘Manage Forecast’ button 
  2. Click ‘Annual Trend’ or ‘3 Week Average’ in the lower left edit forecast menu.
  3. Set the ‘Apply to’ drop down menu to ‘All Sales Metrics’ 
  4. Click the ‘Apply’ button

Want to make forecast adjustments to a single day? Click HERE to review our ‘Daily Forecast Adjustments’ guide.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.