Case Study Summary:
Company:
Fortune 500 Manufacturing Client
 
Challenge:
Combine various sales order and supporting data to allocate revenue and cost to the appropriate divisions within the company
 
Solution:
ADC Business Consulting, Application Development and Integration
 
Results:
Management decisions and financial reporting within the company are based on information that more accurately reflects the performance of each corporate division.


Fortune 500 Manufacturing Client
Accurate Information

   Challenge
As a Fortune 500 manufacturing client moved toward providing a "single face" to their customers, consolidated order management and billing typically produced a single order containing products and services from various divisions within the company. This consolidation of information made the provision of data needed to effectively manage and provide accurate financial reporting for each individual division quite challenging. With items from various divisions included in a single transaction, an accurate and equitable method was needed to allocate common revenue, discounts, and charges (e.g., freight and handling) back to each individual division. Without this process in place, management decisions would be based on information not reflecting the true performance of each division.

   Solution
In less than three months, Alliance Data used its rapid development methodology and system architecture to design, develop and deploy a solution to interface with the company's sales order system and appropriately allocate revenue, cost and charges to each division for every customer invoice. Standard sets of periodic reports, as well as a secure web-based ad hoc reporting interface were provided to support the resulting financial information.

   Results
It was crucial that Alliance Data deliver a solution where the output not only accurately reflected the allocation method, but also provided timely and accurate reporting to support the credibility of the resulting financial information. The solution was delivered on schedule in less than 90 days, with the resulting output reflected in the corporate financials shortly thereafter. Today, Alliance Data provides ongoing management and support of the system that, because of its user-friendly access to sales order data, has grown its user-base far beyond its original scope.

   Technology
Microsoft Visual Studio
Oracle 9i
ADC's Rapid Implementation Methodology
ASP
Microsoft Internet Explorer
HP Proliant Servers