How to account for seasonal uplift with Shortcuts
Posted on 8th August 2013 by Angel Gonzales
If you are planning to have a killer increase in retail with lots of seasonal promotions, you have some serious statistical analysis at your fingertips using Shortcuts new Inventory feature. Not only will Shortcuts calculate the average daily sales for the same time period you plan to run your promotion, it will also allow you to increase or decrease your orders based on your plans.
So, for example, if you plan to run several promotions during the month, you can calculate your average daily sales during that time period last year and then increase it based on how much you plan to sell during your promotions.
- Go to the ‘Inventory’ screen and select ‘Statistics Calculation’.
- Set your date range for the same time period you plan to run the promotion last year.
- Add in a percentage of increase or decrease in the ‘Seasonal Uplift’ field. This can be an increase or decrease, for future reference!
- Select ‘Compute’ and then ‘Yes’ to proceed and then ‘Done’ once Shortcuts prompts you that the calculation was done.
You can now place your order with your supplier using this new calculation! Make sure to recalculate your maximum levels once your seasonal increase is over to set your levels back to your averages.