After selecting the structure of interest and the condition of the analysis ‘Prevision’, let’s see how to fill in the seven tables proposed by the system for the analysis of future data.
- Period
Select the year you want to analyze. The date below indicate the last date of statistic elaboration. (last closure made)
|
- From… to…
set the future period to be monitored, ask for the daily detail and below set what are the work-day that you intend to monitory.
|
- Data
select the desired data for the examined period.
|
- Segmentation
Not fill in!
|
- Reservation status
Select the type of reservation that you intend to include in the calculation (all, or only the confirmed, or all with the status of distinct)
|
- Output
Set the currency and the display of decimals. Is suggested the one indicated in the picture, with statistical data reported at two decimal places and rounding according to standard rules.
|
- Others
Select the preferences about:
- inclusion/exclusion of guests
- inclusion/exclusion of day-use
- specify only the room income or the detail of other income voices and the distinction of these.
|
Generate report
Explaining the print with a concrete example, we can analyze the excel file here below: the stamp here shows that during the questioned period (13-31 October 2013) we had movement only in the last week, in the days between 23/10 and 31/10. While the 10 of October we had a growth of 5463,90 € (by adding 74 rooms in the month), the 11 of October we had a new decrease of 3131,67 € by deleting 51 rooms from the ‘On the book’ of the current month. |
Post your comment on this topic.