What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: CIA overview
Select a size
Overview of our Company.
Computer Ingenuity Associates
Financial Planning (Budgeting and Forecasting)
Daily Reporting, Dashboards, and BI
Sales and Catering
Asset Planning and Capital Replacement Calendar
Direct User Licenses
Custom Software Development
Operational Consulting Services
Properties: Largest 1,700+ Rooms, Smallest 77 Rooms
Corporate: Brands, Management Companies, REITs, and Individual Property Owners
Developed Systems for 5 Different Hotel Franchising Companies
Developed 8 separate and distinct applications
Applications are still in use in 2014
Developed DOS, Windows, and Web based apps
Developed standalone and centralized applications
Software License Sales to over 500 Hotels
Licenses to Casinos, Resorts, Convention Hotels, Full Service and Limited Service Properties
Licenses to Management Companies with 3 to 70+ properties
Budget and Forecast Development and Presentation
Labor Planning, Scheduling, and Management
1989 – Developed Sales and Catering System for Hilton Hotels
1990 – Began consulting with PROMUS Hotels on Budget preparations and ownership presentations
1992 – Developed Budgeting and Forecasting System for PROMUS Hotels
1995 – Began Selling Sales and Catering as well as Budget and Forecast System to Management Companies and Individual Properties
2005 – Developed Daily Accounting Software for Carlson World Wide – Radisson Hotels / Country Inn and Suites
2006 – Developed Preventative Maintenance application for FelCor Lodging Trust
2007 – Developed Asset Replacement Calendar for FelCor Lodging Trust
2008 – Developed CIA Online, web based Dashboard and BI tool
2014 – Formed beta user group for developing CIA Labor Optimization SAS
4 Facets of Software Development and Customization
4 Components of CIA Software
60% - 70% the same at all clients
30% - 40% items that are different from client to client
Setup and installation
Report design, system configuration, data normalization
What Separates Us
Experience and Expertise
Providing Hospitality Companies with Budget and Forecasting software for over 20 years
Functionality refined through collaboration with hospitality leaders.
Customization and Strong Core
Our core functionality reflects many years of studying how hotels make and miss projections, and reduce preparation time without sacrificing accuracy.
A proven core of functionality and customization not normally available in an off the shelf product.
Customizable to different types of properties in the same portfolio
The best of both worlds, response and processing time on a local server, and synchronization that allows for remote access, collaboration, and easy reviews
How does CIA Integrate
CIA integrates to many different Accounting, Property Management, Point of Sale, Payroll, Sales and Catering, and other systems. (We began integrating data in 1998)
We use a variety of methods: direct database connections, flat file data exchanges, report scraping, etc.
Instructions for the feeder system
We document the process when the interface is created
Instructions are posted on our website
Instructions are 90% generic across all clients (with same system)
Instructions for setting up our software
Instructions are 60% generic across all clients (with same system)
How do our integrations work
The majority of out interfaces utilize existing tools in the programs we are interacting with
This reduces your cost and gives you one point of contact
The majority of interfaces can be set to run on a schedule, based on an event, or be user activated
This limits impact on the source system as exports can be done when resources are most available.
While we have a number of existing methods, each client is unique, and our solutions always include a degree of customization.
A lot of companies offer a one size fits all approach, where either the other vendor needs to modify, or you need to modify the setup of you system use. We handle all customization on our side.
Overview of Interfaces
Users create export files from menu, which are read in to DSTAT
Custom export for client that auto generates a file and transfers it to CIA’s OnLine portal
Kronos programmers provided us with a file containing payroll information for the past 14 days. The file is sent to our FTP site by Kronos each day
Users run CIA provided queries to create export files in Market Vision, which are read in to Budget and Forecast
Newmarket developed automated export from Enterprise addition of Delphi. Files are sent daily to our Online Portal and then synched to property networks.
1993 / 2005
Springer – Miller
Read straight from database files
End of day file automatically generated as part of audit process.
9700 End of day file automatically generated as part of audit process is imported. Also have directly read in from data files
Symphony Micros programmers developed a custom export for CIA client, that auto generates end of day data file
In each instance existing Import and Export menu options are used to exchange data. Systems include Oracle, PeopleSoft, AccPac, Yardi, Timberline, Dataplus, and others.
Custom process automatically generates End of day file automatically as part of audit process is imported
End of day files automatically generated as part of audit process and stored in OnQ folder structure
Time clock system, utilizes internal report scheduler to automatically generate a daily payroll file.
Utilize internal report writer to generate files for group rooms and catering events exports.
Import of Monthly Smith Travel Research Excel file.
Selected reports are auto-emailed to a specific location and then scraped for data.
We have developed other interfaces over time and the list above contains the most common ones.
DSTAT Imports & Exports
Email Daily Report
In PDF or XLS
Daily Room Register
Analysis by Day
Analysis by Month
.xls file format used
To import into
For example, Banquet
Covers & Revenue
Transmit via FTP
Variety of Daily Reports
Interfaced to source systems
Income Audit Tool
Data Warehouse of Statistical and Financial Totals
Imports Day by Day history from PMS via DSTAT
Imports Group by Group values from Sales System
Imports partial or complete forecast from external Revenue Management Systems
Provides Trending info to assists with accurate Long Range Forecasting and Budgeting
Has 7 methods for handling on going forecasting and budgeting
Includes Impact Analysis to enter qualified budget assumptions.
Imports Day by Day history from POS via DSTAT
Provides trending information of Covers and Average Check by Day of Week, Year Over Year by Date, and Capture Percentage
Provides factor driven forecast and budgeting, allowing covers and revenue to self adjust with drivers such as groups booked and rooms sold.
Provides a variety of views and data entry options to allow for various types of outlets
Set up to reflect your P&L Format
Imports historical actual values from Accounting System
Provides trending information of miscellaneous revenues and expenses
Provides factor driven forecast and budgeting, allowing costs to self adjust as drivers change.
Provides explanation screens to document assumptions.
Provides Custom Report writer using Excel
Provides corporate offices with built in roll up capabilities.
Labor Cost Functionality
Imports history of hours and cost directly from payroll system
Provides trending information of Labor Cost and Performance Standards
Provides an unlimited number of Performance Standards for budgeting and forecasting hours per position based on business factors.
Allows for a percentage of hours budgeted/ forecasted to be costed at Contract or Overtime Rates
Provides for Seasonal and multiple driver standards
Provides for a standardized written Business Plan document to accompany budgets
Includes basic word processing functionality, spell check, cut and paste, etc.
Provides options for output as printed document or PowerPoint presentation
Automatically imports any needed financial values from budgets and history
Provides a fixed format that can not be altered accidently or intentionally.
Additional Forecasting Functions
Provides a formalized submission process that freezes forecast values for corporate reporting, while allowing properties to continue to dynamically forecast.
Provides ability to produce Forecast Accuracy reports
Automatically adjusts expense forecasts every time revenue and statistics are changed.
Utilize SQL Databases – 1 per client
Synchronized to local databases using XML
Transfer of XML files is on user defined schedule
Reports done using SQL Reporting Services
Currently hosted by Discountasp.net
Would be willing to provide server specification for self hosting (No one has opted for this yet)
May require hosting fee in future, currently no charge
First Application Online
Online Reporting, Automated email distribution, Warehouse Data, Ability to update property data remotely
DSTAT – Daily Reporting
First Financial Application Online
Online Reporting, Automated email distribution, Warehouse Data, Handles updating databases between Corporate, Region, and Property
First fully functioning Online Application
Released in test 3/2008
Provides an automated perpetual asset replacement calendar
Sharing and Updating
Automated Delivery of Updates
DSTAT can be set to automatically search our hosted site for updates, and auto-install them
Financial Planning software will be enabled to do same 9/08
Automated Back Up and Transfer of Data
Software will generate XML files that are transferred to the hosted site on a user defined schedule.
The XML files are then used to build the on line reports available on the hosted site, and can be used to synchronize another computer with any properties complete database file.o source systems
Provides trending information of Covers and