Richard Boutz is convinced of the merits of the approach. Boutz, CFO of Washington Trust Bank in Spokane, Washington, says the financial-services company substituted KCI Control for a company-built budgeting application two years ago. "KCI's Excel interface puts the user in a familiar environment," he says. "The advanced capabilities of Excel are, therefore, available to the Control user at all times."
The results have been startling. In the first year of using the software, the bank was able to complete its annual budgeting process 90 days earlier than in previous years. What's more, the software has dramatically cut the time required to perform budgeting analyses — from two weeks to a matter of minutes.
The Templates of Doom
Customer interest in less-daunting planning programs has not escaped the notice of more-established B&P vendors. John O'Rourke, senior director of product marketing for Santa Clara, California-based Hyperion Solutions Corp., believes that added functionality shouldn't complicate a program's structure or adversely affect its overall look and feel. He notes that despite numerous additions over the years, his company's Hyperion Strategic Finance has retained its familiar spreadsheet-style interface and hasn't forced users to adapt to any radical changes.
Still, it appears Hyperion is heeding customer calls for simpler software. The vendor is planning to improve Strategic Finance's ease of use by providing more wizards and improving integration with Microsoft Office. Hyperion developers are also working on a feature that will enable users to attach notes to models. Says O'Rourke: "The annotations will allow team members to see the assumptions behind each model."
Likewise, market leader Business Objects SA, based in San Jose, California, and in Paris, is tweaking its array of modeling applications. Peri Pierone, vice president of vertical markets, notes that the company's goal, with all of its software, is to help customers create plans they can trust. Says Pierone: "It's remarkable how much time companies spend on planning, but the plan that results really isn't very believable."
Universal Orlando's Neveras has some familiarity with the problem. The planning analyst, along with dozens of other company employees, uses Business Objects's software to track financial trends and goals at scores of functional units, including attractions, stores, restaurants, and souvenir carts. To improve usability — yet maintain reliability — Neveras says the company has pared the number of basic templates in the modeling program to 13. That's enough to handle the variability in the different business segments while minimizing the maintenance and training that result from additional templates. "If we tried to make a template specific to each individual business and vision," he says, "it would be a maintenance nightmare."
With the basic templates, Universal Orlando manages the interactions between the theme park's attractions, restaurants, and shops. The opening of a new ride, for instance, not only affects overall park attendance, but also the number of people drawn to food and merchandising sites. A fresh attraction typically adds visitors to nearby venues, yet may lure guests away from sites located close to older, less popular rides. "If we're still staffing based on the old history," says Neveras, "we're not going to capitalize on our penetration and maximize our profitability."
Easy For You
As they attempt to advance both capabilities and usability, modeling developers find themselves walking a thin and perilous line. Customers may be demanding easier-to-use products, but they're reluctant to trade away any modeling functionality. "They don't want the applications dumbed down," says Business Objects's Pierone.
Many modeling vendors have attempted to skirt the problem by giving customers the ability to integrate financial- and business-planning models. That sort of linking of systems appears to dovetail with the desires of customers. In a survey of users conducted by AMR Research, 70 percent of the respondents said their top B&P priority is connecting planning apps to underlying business programs and data.
The appeal of this melding of financial and business modeling, notes John Fontanella, a senior researcher with Aberdeen Group, a Boston-based technology research firm, is that it allows users to keep business goals in sync with financial projections. Forecasts of customer demand for a certain product or service, for example, can now be calculated alongside commodity pricing forecasts. "Virtually all of the major vendors have backwardly integrated their financial planning into business planning," says Fontanella.
Planned or not, this integration is a big step up in functionality. Not all customers, however, require such sophistication. Indeed, consultants say finance managers who yearn for usability need to be wary of purchasing modeling software that is light years beyond their needs or abilities. "You don't buy a cannon to shoot a rabbit," says Guillermo Kopp, vice president of the cross-industry practice at Tower Group Inc., a financial-services research and consulting firm in Needham, Massachusetts.





Reader CommentsDisplaying 2 of 2
Barry Phillips
Jun 12, 2007 10:37 AM ET
A World Beyond Spreadsheets
Anyone interested in modelling should look at www.atebit.co.uk This program gets over many limitations of spreadsheets … more
Nancy Ordway
Aug 23, 2006 6:00 PM ET
Content Free
Article was amazingly content free
Post a comment | View all comments