1806 North Flamingo Road, Suite 200 Pembroke Pines, Florida 33028, USA
Worldwide +1 (954) 433-3633 info@datavisiontech.com
© 2016 Datavision Technologies, Inc. All Rights Reserved Legal Documents
Business Intelligence for Hospitality

Forecasting

Microsoft Excel is one of the most widely used financial tools for forecasting, budgeting and other numerical reporting. Many users have invested heavily in creating Excel-based forecasting sheets that link together to form large forecasting models. Unfortunately, maintaining these links have become extremely cumbersome - inserting or deleting a row in one spreadsheet has the unfortunate consequence of causing many of the linked sheets to lose their position, destroying the integrity of the entire process. With Datavision, you can continue using Excel as your forecasting engine, but without having to maintain linked sheets. Datavision will eliminate links between sheets by connecting each Model to a central data warehouse to send and receive data, which will allow each model to be used independently.  Data written into one model will automatically flow into any other models. Using a centrally connected database has the added advantage of delivering the exact same information to all sheets that require the same piece of information, without manual re-entry or links. This preserves data integrity while providing the ability to view instant P&L statements reflecting the latest forecasts during the forecasting process. The module will "wrap" around your existing forecasting sheets to connect each sheet to the central database. This allows the "drivers" (raw data that's necessary to generate the forecast) to flow from the database to the sheet, and the final forecasted data to flow to the database from the sheet. In general, the budgeting / forecasting process can be separated into three distinct portions: Drivers - The raw data from various sources that form the basis of your forecast. For example, you might want to use a 3 year average of historical occupancy average to drive your rooms forecast. Or you might use forecasted rooms in conjunction with capture ratios to drive cover counts in your Food and Beverage outlets. Models – A collection of Excel spreadsheets that use the information provided  by the drivers to calculate the forecast Forecast/Budget– These are the numbers generated by the forecasting spreadsheets. This data can then be written back to the data warehouse as your ‘forecast’ or your ‘budget’ Datavision’s Budgeting and Forecasting models will streamline your hotel’s entire budgeting and forecasting process. Department heads can budget/forecast their own department with the data automatically coming from and flowing back to Datavision’s database. Datavision has also developed a set of utilities that will make copies of your forecast - every day, if necessary. This will allow you to compare various sets of forecasts and to do back casting (compare what you forecasted for a certain month and what your actuals were for that month). In addition Datavision has also built an AutoForecaster utility that will calculate and upload selected sheets, allowing you to automatically propagate changes from one sheet to all dependent sheets in batch mode without user intervention
Forecasting using Datavision
Rooms and Revenues Forecast Model
Restaurant Forecast Model
1806 North Flamingo Road, Suite 200 Pembroke Pines, Florida 33028, USA
Analytics Multi-Property Forecasting Financial Reporting CRM Labor Metrics
Business
Intelligence

Forecasting

Analytics Multi-Property Forecasting Financial Reporting CRM Labor Metrics
In general, the budgeting / forecasting process can be separated into three distinct portions: Drivers - The raw data from various sources that form the basis of your forecast. For example, you might want to use a 3 year average of historical occupancy average to drive your rooms forecast. Or you might use forecasted rooms in conjunction with capture ratios to drive cover counts in your Food and Beverage outlets. Models – A collection of Excel spreadsheets that use the information provided  by the drivers to calculate the forecast Forecast/Budget– These are the numbers generated by the forecasting spreadsheets. This data can then be written back to the data warehouse as your ‘forecast’ or your ‘budget’ Datavision’s Budgeting and Forecasting models will streamline your hotel’s entire budgeting and forecasting process. Department heads can budget/forecast their own department with the data automatically coming from and flowing back to Datavision’s database. Datavision has also developed a set of utilities that will make copies of your forecast - every day, if necessary. This will allow you to compare various sets of forecasts and to do back casting (compare what you forecasted for a certain month and what your actuals were for that month). In addition Datavision has also built an AutoForecaster utility that will calculate and upload selected sheets, allowing you to automatically propagate changes from one sheet to all dependent sheets in batch mode without user intervention
Rooms and Revenues Forecast Model
Restaurant Forecast Model
Microsoft Excel is one of the most widely used financial tools for forecasting, budgeting and other numerical reporting. Many users have invested heavily in creating Excel-based forecasting sheets that link together to form large forecasting models. Unfortunately, maintaining these links have become extremely cumbersome - inserting or deleting a row in one spreadsheet has the unfortunate consequence of causing many of the linked sheets to lose their position, destroying the integrity of the entire process. With Datavision, you can continue using Excel as your forecasting engine, but without having to maintain linked sheets. Datavision will eliminate links between sheets by connecting each Model to a central data warehouse to send and receive data, which will allow each model to be used independently.  Data written into one model will automatically flow into any other models. Using a centrally connected database has the added advantage of delivering the exact same information to all sheets that require the same piece of information, without manual re-entry or links. This preserves data integrity while providing the ability to view instant P&L statements reflecting the latest forecasts during the forecasting process. The module will "wrap" around your existing forecasting sheets to connect each sheet to the central database. This allows the "drivers" (raw data that's necessary to generate the forecast) to flow from the database to the sheet, and the final forecasted data to flow to the database from the sheet.
© 2016 Datavision Technologies, Inc. All Rights Reserved