eprentiseTransformation Software Solutions
for Oracle E-Business Suite

Leveraging Purchasing in a Multi-Org Environment

By Helene Abrams

>> A Business Case for Consolidating Operating Units and Inventory Organizations

When companies originally set up multi-org in Oracle’s E-Business Suite, security and control were the primary drivers for separating data into different operating units. Plants wanted to run their own operations, negotiate their own contracts with suppliers, and set up their own invoicing, inventory and receiving practices. Moreover, there was a competitive environment among different divisions, product line operations, and general managers. One part of the company did not want another part to see the transaction detail. Little attention was paid to maximizing the purchasing power of the entire enterprise to negotiate better terms and discounts with common suppliers. As a result, companies often set up hundreds of operating units, each with its own freight carriers, matching tolerances, approval hierarchies, supplier terms, and contracts. It was difficult to determine how much business was conducted with a particular supplier, difficult to determine the enterprise cost of managing and maintaining different supplier relationships, and the burdened costs of different inventories.

Within a multi-org environment, much of the data must be set up by operating unit. While there are some advantages to having a multi-org environment, especially in regard to security, there are limitations that prevent obtaining an enterprise view of the data, especially the ability to leverage supplier relationships. There are three primary areas that can be negotiated with suppliers that contribute major amounts of money to the bottom line for an enterprise:

  • Obtaining larger discounts
  • Changing payment terms
  • Reducing the number of suppliers.

The following examples illustrate the benefits of executing each of these strategies. A spreadsheet is included with this document so that the key variables can be adjusted to reflect your own operating environment. In order to recognize the savings discussed, operating units need to be consolidated to provide an enterprise view of the data.

Obtaining Larger Discounts

If you are able to determine how much you spend with each of your suppliers, you may be able to renegotiate your discounts. Many suppliers will provide volume discounts if you commit to certain spending levels. By looking at your total spend across all operating units, you may be able to reach the thresholds required for greater discounts. The following chart examines potential savings for increasing the supplier discounts by 0.5%, 2%, and 5%. As you can see from this chart, even averaging a half percent additional discount results in millions of dollars in annual savings.

The data in the following table include an assumption that 25% of COGS is attributable to MRO.

A
B
C
   
1,000,000,000 1,000,000,000 1,000,000,000   Revenue
770,000,000 770,000,000 770,000,000 Cost of Goods Sold
75% 75% 75% Percent of COGS for material from suppliers
577,500,000 577,500,000 577,500,000 2007 Supplier Expense or "cost of inventory"
0.50% 2.00% 5.00% Leveraged Supplier Discount
574,612,500 565,950,000 548,625,000 Adjusted 2007 Supplier Expense or "cost of inventory"
2,887,500 11,550,000 28,875,000   Potential Annual Savings from Negotiating Additional Supplier Discounts
         
         

Changing Payment Terms

By increasing the number of days a company holds on to cash, additional interest will accrue, whether using a daily sweep checking account or another instrument for cash management. The chart below analyzes the benefits of extending the payment terms with suppliers and calculating the value of having the cash on hand for an additional “float” period. Again, negotiating an additional five days for payments results in hundreds of thousands of dollars in annual savings. This chart has the following assumptions:

1. MRO portion of COGS is 15%
2. The annual Cost of Capital is 5%

A B C    
1,000,000,000 1,000,000,000 1,000,000,000   Revenue
770,000,000 770,000,000 770,000,000 Cost of Goods Sold
85% 85% 85% Percent of COGS for material from suppliers
654,500,000 654,500,000 654,500,000 2007 Supplier Expense or "cost of inventory"
5 10 15 Extended Supplier Terms (Additional AP Float Days)
5.0% 5.0% 5.0% Annual Cost of Capital
0.0137% 0.0137% 0.0137%   Daily Cost of Capital
448,288 896,575 1,344,863   Potential Annual Savings from Utilizing Cost of Capital
         
         


Reducing Number of Suppliers

There are a number of additional savings that might result from consolidating operating units or inventory organizations. Some of these are not as easily quantifiable, but result from obtaining an enterprise view of the supply chain operations when working with fewer suppliers in the enterprise. If you and your suppliers are closely aligned, operational savings occur because:

  • You are able to consolidate distribution logistics (freight, receiving, inspections).
  • There are fewer catalog items to maintain and reconcile among suppliers (Part # 100 from Supplier A is equivalent to Part # 357 from Supplier B).
  • You work closely with a supplier so that the supplier knows what you need and when you need it. The supplier is tied into your system so that goods arrive on your production schedule. Handling just-in-time ordering through blanket purchase orders also saves time and money. The supplier, in effect, bears the inventory cost (both the value of money and the costs of physical storage, insurance, etc.).
  • You can reduce inventory costs by eliminating duplicate or “dirty” data across operating units.
  • Operational costs of working with a supplier including approvals, sending out RFPs, reviewing quotes, completing background checks, and making payments can be streamlined and result in significant savings.
  • There are reduced legal fees since there are fewer contracts to negotiate.

In sum, there are many advantages to consolidating operating units. The financial benefits of having an enterprise view of the supply chain may outweigh the security factors that prompted the initial setup of E-Business Suites in a multi-org environment.

>> View our interactive reorganization calculator and see how much money you could save your company.


eprentise Resources

What is Metadata Analysis?

View Software Demo
Find out.

Data Sheets & White Papers

Reasons for eprentise and FlexField
Reasons for eprentise and FlexField
FlexField Data Sheet
FlexField Data Sheet
eprentise Consolidation Data Sheet
eprentise Consolidation Data Sheet
eprentise Divestiture Data Sheet
eprentise Divestiture Data Sheet
eprentise Reorganization Data Sheet
eprentise Reorganization Data Sheet
Calendar Change Data Sheet
Calendar Change Data Sheet
Adding Business Value to Database Consolidation
Adding Business Value to Database Consolidation

Software Demos

View Software Demo
FlexField®
View Software Demo
Merge Operating Units
View Software Demo
Move Legal Entity to a new Ledger or Set of Books
View Software Demo
Merge Ledgers or Sets of Books
View Software Demo
Divestiture - Filter by Legal Entity
View Software Demo
Divestiture - Filter by CCID
View Software Demo
Change Calendar Period Dates
Bookmark and Share

What People are Saying

This is the best thing since peanut butter & jelly.

-- Jack Logsdon, Barrick Gold Corporation
Not only do you have an excellent product, but you and your team provided top notch service to us (including some extra hand holding to get us in the right direction). I’m looking forward to our next project.

-- Tina Mitchell, BIAS Corporation (Client: Xiocom Wireless)
It is a pleasure to work with you and I think that the product is great for companies like Embry Riddle.

-- Karen Kerames, IT Convergence (Client: Embry-Riddle Aeronautical University)
The whole project has been a success. Saved the company lots of money by not re-implementing Oracle. The quality of service was unmatched.

-- Matt Adelman, Consultant (Client: Uponor)
I’d recommend this software to anyone that needs to change their CoA with minimal effort. The FF Express team is well experienced and showed that they were subject matter experts when it came to altering your chart and its impacts.

-- Marco Meirinho, GFI Group
[The FlexField Express team] was on top of our every move from demo to implementation, providing feedback, answering questions, and asking us if we were on track. Communication was better than I have ever had with any vendor.

-- Corvin Deus, Ultradent
[FlexField Express provided] very good service. It takes a lot of the burden off the staff that’s running the conversion and allows for more focus on designing the new COA.

-- Jason LaFontaine, Marion County (Oregon)
FlexField wins Best Exhibitor Marketing at Collaborate 09

>> visit the FlexField page
FlexField Noted as One of Twelve Hot Technologies for Government Customers at IT Channelvision

>> view the article