The Last Year SPIT calculation is used in a number of places in Right Revenue. In particular in the Room/Revenue Status Overview graphs on the dashboard of the system. This is a brief description of how those figures are arrived at, and what they mean in practice, especially when they are compared to the Last Year Final figure.
Below is an example of a Room Status Overview graph for the month of February.
As you can see from the legend of the graph, the blue line represents Last Year SPIT and the pink line represents Last Year Final.
The first thing to know is that when we refer to the same point in time last year, we mean the day of the week rather than the date. I am looking at this graph on Thursday 9th February 2023. So the Last Year SPIT that the graph refers to, is the Thursday exactly 52 weeks ago, which was Thursday 10th February 2022.
The second thing to know is that the dates that we are providing data for in the graph are also the equivalent day last year, not the equivalent date. So when we provide a Last Year SPIT value above Friday 17th February in the graph above, we are referring to the value on the same Friday, 52 weeks before, which was Friday 18th February 2022. This is essential, as we want to directly compare Friday with Friday, Saturday with Saturday and so on.
As you are probably aware, if you hover your mouse over the graph it will show the exact figures for the day that you are settled on. A table of figures appears showing each of the different figures on that date. Below shows me hovering over the 17th February on the graph shown above.
In this table of figures, the Guaranteed, Unguaranteed and Forecast values all refer to the 17th Feb 2023. These are the values for the 17th as they are sitting on the date that you are looking at the graph (in my case Thursday 9th February 2023, which was 8 days before the 17th).
The Last Year SPIT value is how many rooms you had on the books for Friday 18th February 2022, on Thursday 10th February 2022, which was the same 8 days before that I mentioned above.
The Last Year Final value is how many rooms did you sell in total for that day, Friday 18th February 2022.
To summarise, using the example above. It’s the second Thursday in February. You are looking ahead to Friday, 8 days from now. At the moment you have 15 Guaranteed rooms on the books for that Friday, and no Unguaranteed rooms. Right Revenue is forecasting that you will sell 18 rooms in total for that day. Last year the same Friday, when viewed from the same Thursday, 8 days before, had 14 rooms on the books, and it finished with 17 rooms sold. So you are trending 1 room ahead of Last Year SPIT and we forecast that you will finish 1 room ahead of your Last Year Final figure.
If you have any questions about this, or any other system-related topic. Please contact:
Comments
0 comments
Please sign in to leave a comment.