Web-based Management Information System for Davidson Hotel Company

Davidson Hotel Company is a full-service company providing management, development, consulting and accounting expertise for the hospitality industry.

The Hotel information system used by Davidson (called DHARIA) is primarily intended for use by the management. The objective of Innasite's work was to improve the effectiveness and the actionability of the MIS by enhancing existing features and integrating it with other client server applications.

1. Forecast: The forecast section is used as a dynamic predictor of the income statements for each hotel. Innasite has added the freeze forecast module so that predictions related to sales of rooms/food, labor usage and revenue generation can be frozen. this is then used to monitor actual performance on a daily, quarterly and yearly basis.

2. Sales Ticker: This is designed to run like a stock market ticker on the DHARIA homepage. It informs managers on which properties have met their targets.

3.Time & Attendance Module: Time and Attendance is managed through third party software called A4W. The current process involved manual feeding of this information into the DHARIA system. The process has been automated by implementing Attendance Enterprise (AE), a centrally hosted SQL based application.

4. Purchase order module. This integrates the procurement function with the other related functions. It has been designed as a workflow - allowing the real life checks and balances (approval from relevant authorities based on volume and type of purchase) to be incorporated, without generating paperwork. The purchase module also integrates with the approved budgets and forecasted expenditures to provide effective MIS.

Technology:
This is a Microsoft based solution running on Windows NT with SQL Server 7.0 (currently being upgraded to Win 2K with SQL Server 2K). Scripting utilizes ASP.

THe DHARIA MIS is collated from hotels across the country, which have their own database servers. The database servers are connected through LINKED SERVERS. Extensive use of stored procedures in SQL Server has been made.