Use this article to understand how to format your weekly location budgets into the right format to be loaded into your tRS service.
About
tRS supports multiple budgets such as Board Budgets, Forecasts and Targets across multiple measures such as Sales and GP $. This article explains how to set up your budgets using the correct template to get them loaded into you tRS Service.
When setting your budgets at location and week level, we additionally need to fill in a second template called Daily Splits or also known as a trading profile that split the week budget into days 1 through to 7 where day 1 = your first day of your retail week.
See below for more details.
Weekly Location Budget Template
Your weekly location budgets must be formatted and maintained in a specific structure to be uploaded into your tRS service and this is best done in MS Excel.
When preparing your budget template, the final template with look like this
And will have the following column headings.
In summary, location code by year and budget type are in the rows with the weeks 1 to 53 as columns.
Daily Splits Template
As mentioned above, the weekly budgets will need to split to the day level using a trading profile or % contribution to the total week.
Tip: If you are budgeting at fulfilled sales and you are setting your ecom budget, your online budget might be '0' for Saturday and Sunday but a higher percentage for Monday and Tuesday as these orders are processed. Conversely, if you are budgeting based on demand sales (when the order was received) then you would need to split your weekly budget for online across all 7 days.
When preparing your budget template, the final template with look like this
And will have the following column headings.
In summary, location code by year AND week number are in the rows with the days 1 to 7 as columns.
PLEASE NOTE:
1. The format of the cell should be decimal numbers and rounded to three decimals
2. The 7th Day column should be a formula of 1 - sum(days 1 to 6) which will ensure each location / week combination adds exactly to "1"