Established in 1960, McKinstry is a full-service design, build, operate and maintain (DBOM) firm with over 900 full-time employees and 900 union employees. Headquartered in Seattle, with 18 regional offices and $500 million in annual revenue, McKinstry’s professional staff and trades people deliver consulting, construction, energy, and facility services.
McKinstry was operating in a spreadsheet environment with 40 to 50 spreadsheets circulating in the organization at any given time. It was difficult to perform basic rollups, users would make changes and break formulas, and there was no centralized location for the budget. In addition, there was a lack of privacy controls and sensitive data could be accessed outside the finance group.
"Our main objective was to improve our budgeting process across the organization," recalls Mike Shannon, Sr. Finance Analyst, McKinstry. "We needed an application that could easily map to our existing general ledger. In addition, we wanted the ability to forecast based on actual detail more cleanly than in our existing spreadsheet-based process."
McKinstry’s IT director discovered Adaptive Planning, part of the Adaptive Suite, by attending a seminar. The solution met McKinstry’s objectives for an improved process. The application was webbased and users across the regional offices could access it from anywhere. Finance could also manage and control the formulas and assumptions within the tool. Finally, Adaptive Planning could easily map to their existing general ledger, normalize historical data and enable forecasting.
"Users love the application because the model was built in such a manner that application calculated and rolled everything up. In addition, managers can log-in from anywhere and even work on the budget while on vacation."
Mike Shannon, Sr. Finance Analyst, "After selecting Adaptive, the implementation process went very smoothly," said Shannon. "The professional services team was responsive and was always able to find a solution to specific McKinstry nuances due to the flexible nature of the application. We rolled out to 58 users across the organization on schedule."
By rolling out Adaptive Planning, the finance team reduced the budgeting time by 65%. In addition, it eliminated hours of manual spreadsheet work previously spent developing dashboard reports for the executive team. Now all twelve executives have access to the Adaptive dashboard on their homepage and they can look each day at where they stand, see the snapshot, and review which departments are hitting or missing their revenue targets.
"The user feedback was great," confirms Shannon. "Users love the application because the model was built in such a manner that everything was pre-defined and all they had to do was enter the data and the application calculated and rolled everything up. In addition, managers can log-in from anywhere and even work on the budget while on vacation." Now the finance team spends less time consolidating the budget and fixing formulas and more time analyzing the data. In addition, they have saved 10 hours per month developing monthly reports now that the report process has been automated.