|
>.
Using Spreadsheets - AGAIN!!! |
by Jose Acosta
August 2003 Finance executives in corporate America today are under so much additional pressure. Burdened by a struggling economy, high-profile accounting scandals, and a weak stock market with consecutive declines, finance executives find themselves pressed by government regulators, owners and investors to produce faster, more reliable, and more transparent financial outlooks upon which they can emphatically place their seal of approval. Of course, this further taxes the finance executive who is then challenged to create better and somehow more reliable budgets and forecasts with the same inadequate systems and processes used repeatedly since the inception of the company. The problem is compounded as it exposes the finance executive�s inability to track historical data and its relationship to actual performance, particularly when the only reliable method of gathering this data is via the standard spreadsheet solution. In fact there are still a stunning number of hospitality accounting divisions at many companies that continue to manage financial performance using the standard spreadsheet, making the process slow, rigid, and complex This widely used spreadsheet method requires the user to expend a tremendous amount of tedious work and time just to produce the desired numbers that are expected by upper management, investors and owners rather than providing the insight needed to guide the business and present management with a budget or forecasting plan than can help them to anticipate and manage their operation more profitably. One of the reasons it is so difficult to compare historical trends with actual data and consequently produce a budget and forecast is because this cumbersome number crunching process continues to be handled using spreadsheets. When one builds a complex budget with an intricate set of spreadsheets, it is very difficult to perform the inevitable changes to the data with any ease or speed at all. Traditionally in the hospitality industry the revenue segments are tracked fairly well in lengthy detail. However, the process falls apart when managers then try to associate expenses to the related revenues. The perfect example is when one budgets revenues by market segment by day but then calculates the associated labor costs needed to service these revenues by month. One of the reasons this occurs is that most accounting offices typically budget labor by the month while the actual expenses associated to that budgeted labor is calculated by dividing the monthly labor budget by the number of days in the month, creating an unreliable and ineffective plan for the company to implement. THE PROCESS Budgeting, forecasting and the consolidation of these budgets and forecasts in many organizations are extremely arduous tasks. Slowed down by manual processes and lack of integration among systems, this process inevitably involves constant re-keying of data, usually into existing budget spreadsheets. This entails long planning cycles and rigid, inflexible models that are eventually output to spreadsheets and are difficult to modify, particularly as a company grows. Even when finally completed, these enormous spreadsheets have to be checked and reported on manually as many incorrect formulas can be easily overlooked. Commonly the budgeting process begins by sending out spreadsheets to the heads of each of the departments. The department manager then has a limited amount of time to input his budget projections into the spreadsheets and return them to the accounting department which must type every department�s spreadsheet into a master worksheet. It is true that there are organizations which have very IT departments or a very strong user who has developed complicated macros and methods to consolidate departmental information without re-entering the data and have managed to address this issue in an automated fashion. Furthermore, it is usually accepted that during the annual budget the department managers must remove themselves from the daily operations of their departments while they are completely consumed by this exhausting, tedious and time consuming process. Once completed, there is another two weeks of typing and adjusting before the budgets can be sent for review by the executive committee. The executive committee finally reviews the budgets at least two or three times before finalizing them for their owners/investors to review and approve for the coming year. Moreover, by the time the budget is finally approved, it might be obsolete. Most companies which use rudimentary budgeting technology such as spreadsheets can take up to six months to complete a budget. By that time, the market may have changed, and new competition may have been introduced into certain areas. Finally, it is important to remember that the creation of a meaningful budgeting and forecasting model is an ongoing process. The ultimate goal is not just to do the plan once, have it sit there and gather dust; but, to continually refer to it as the roadmap that is used to run your business. Current Budgets concerns:
With the current economic conditions and the clear need for an accurate, detailed explanation of a company�s plan, it is more imperative than ever for the Hospitality industry to migrate from its traditional weak, archaic, and inflexible approach to budgeting and forecasting. Executives are required to produce various scenarios so that owners/investors can make financial decisions more quickly. The current utilization of the spreadsheet method will continue to handicap management and affect company operations. It is unfortunate that the technology in the Hospitality industry has had limited resources and options to facilitate and expedite this important budgeting and forecasting process. Numerous companies have internally developed programs outside of the spreadsheet environment. However, so often the employee who designed the program leaves the company and creates a gap in the process which begins with the logistical problems of simply supporting the model after changes are made. Further, the non-hospitality industry software packages in the market are over-priced, inflexible, and not easily adapted to the industry. It is clear that in order to simplify this grueling process and to make it more accurate and flexible; companies should adapt a budgeting and planning software that is database driven. This database solution combined with web-based capabilities would prove to be more convenient for multi-property access and would ultimately be the definitive solution for any hospitality corporation, regional office or property. The more functional, stable and flexible database application should allow for bottom-up and top-down forecasting, and provide real-time input from the individual properties as events occur and situations change. For example, a salesperson could use a database planning tool to update his pipeline, and if the probabilities on a deal change, that would be reflected in the forecasts. This budgeting application should allow users to easily revise budget targets and quickly determine how those revisions will affect overall corporate performance. Budgeting software should make it easy to consolidate numbers on the fly. If a change is made, the program should update the data so that the new scenario is immediately available, unlike the currently accepted process of waiting several hours while the change is slowly updated throughout the spreadsheet cells until suitable output is finally available for review. Such advanced budgeting tools should also provide
a large degree of flexibility for creating formulas and allowing users
to analyze numbers across multiple scenarios. Another important feature
should be the ability to integrate budget data with other operational software
by importing and exporting data from multiple applications across the property
or corporate offices. Only after implementing such an advanced performance
database budget application will there finally be less dread in the anticipation
of budget time, less time in creating and establishing the budget, and
finally more accessible data to allow for extracting reviewing, reporting
and analysis capabilities.
|
priZem international, inc. Phone: 212-327-2400 www.prizem.com Jose Acosta, COO
|
Also See: | Are You Laying-off the Right Employees? / April 2003 |
Inexpensive Software Provides Hoteliers with Decisive Method of Managing Labor Costs in a Challenging Economy / Dec 2002 |