BI and EPM Keep Projects on Track and ProfitablePosted 2013-07-02 Email Print
General Dynamics' Business Intelligence Collaborative acts as a hub to help the entire company uncover and implement best practices in BI and data warehousing.
By John Monczewski, Edward J. Cody and Ajay Yelne
General Dynamics is an aerospace and defense company with deep expertise in business aviation; land and expeditionary combat vehicles and systems, armaments, and munitions; shipbuilding and marine systems; and mission-critical information systems and technology. With high-profile public and private sector customers, including the U.S. federal government, the Department of Defense and Blue Cross Blue Shield, General Dynamics is the fourth largest defense contractor in the world.
The company was founded in 1952 and since the mid-1990s has acquired and integrated more than 60 businesses, including manufacturing facilities and companies. During this time, revenue has grown from $4 billion to approximately $33 billion, and the company has nearly tripled its workforce to more than 95,000 employees.
To support the rapid growth and business change, General Dynamics’ leadership invested in developing a culture of analytics. This led to the creation of the Business Intelligence Collaborative, a business intelligence and EPM (enterprise performance management) Center of Excellence inside General Dynamics Information Technology.
Our unit acts as a hub to help the entire company uncover and implement best practices in BI and data warehousing. As General Dynamics greatly prizes innovation and agility, we are often tapped to find new ways to use technology and data to create efficiencies, enhance visibility and run the business better.
For example, the leadership team tasked the Business Intelligence Collaborative to leverage BI and analytics to find new efficiencies across the company’s financial operations. In addition to integrating acquired businesses, the company reorganized into four different business units.
Also, sequestration (forced budget cuts throughout the government) is having an impact on General Dynamics’ public sector customers. With spending tight, the consulting environment is more competitive than ever, and it’s up to the Business Intelligence Collaborative team to uncover ways to stretch every dollar further.
This led to the expansion of BI and EPM software to increase analytic capabilities. The enterprise shift toward industry-leading analytics started with the implementation of planning and forecasting systems to replace legacy Excel models, reducing cost and cycle time while improving quality and detail. The solutions, developed using the Oracle Hyperion EPM software suite, provide a significantly improved platform tailored to the business processes and data of each business unit.
This initiative has had far-reaching effects across our entire defense and aerospace business, helping the company increase profitability, manage costs, improve executive visibility and drive efficiencies. With cutting-edge technology to streamline financial reporting and increase insights into our resources, we’ve achieved powerful business results.
Increasing Profitability, Managing Costs
With large-scale projects across R&D, manufacturing and production under tight deadlines and project constraints, aligning resources with production cycles is critical. General Dynamics places a high value on rate analysis, a complex process that shows how we manage our costs and human capital.
For instance, when we’re running a big land systems project to build armored vehicles, we need to make sure we’ve built out our engineering team enough to get the technical components mapped out during one phase of the project, and then adjust accordingly—and profitably—to ensure we have the right manufacturing resources on board. To do this, we need to have a high-level view of the project performance, while also being able to dig into the resources, profitability and people involved.
Previously, all the project resources were locked in our siloed spreadsheets, making it difficult to view the status of projects, foresee any issues and reallocate resources in a timely fashion. Teams could not realistically make informed decisions on rates until the end of a month or quarter, when everyone had logged their time and updated their project components.
This is no longer the case. With our new financial management system, we have a simple way of viewing resources, with color-coded “traffic lighting.” If one part of the project turns up “red,” shifts can be made to change the cost structure, allowing us to make profitable changes swiftly.
We can also see different stages of the project by month, so if one cycle of our armored vehicle manufacturing is held up, we have insight into which people and facilities have capacity, and can move resources accordingly. By intelligently managing our overhead costs, we can be more competitive and invest more in our growth.
In addition, we now have the visibility to look back three months into a project, and we can leverage predictive analytics to forecast how the project will track so we can plan for the future. This level of insight and analysis helps us keep projects on track and profitable.