An allocation is the process of shifting overhead costs throughout an organization. One company might want to distribute costs across business units or departments. Another might want to assign costs to individual products or projects. Fundamentally, the smartest approach to allocations is about properly assigning costs to the areas that benefit from those costs.

When organizations allocate costs, they benefit from more accurate financial reports that show a greater level of detail. By properly allocating the costs, we can see true profitability results and make strategic decisions based on those results.

These detailed results give organizations the ability to answer questions such as:

  • Are we making money on this project?
  • Should we stop selling this product?
  • What personnel changes should we make?

Four key phrases in the allocation process

There are four key phrases associated with allocations. These are:

  1. Source – The source is simply the original value. This is the value that will be allocated or moved somewhere.
  2. Driver – This is the basis for allocation calculations. Drivers can be dollars, units sold, headcount, etc. These are tangible items that are used to determine how to spread the source costs.
  3. Target – The target is where you want to move the cost to. The source is where you start from, the target is where you move it.
  4. Offset – An offset is typically a negative value associated with that target. This is used to create a balanced accounting entry and ensure that your end result is the same as your starting value.

Performing allocations

How do you perform an allocation? First, you calculate the allocation amount. We use the driver to help determine a percentage to spread the cost. For example, a company has an office with two different departments. A very simple allocation takes the overall office costs, splits them in two, and allocates a piece to each department. In this example, the allocation percentage is half. Once the amount is defined, we post a journal entry to both move the allocated amount into the target and remove the amount from the source.

This is a very simple explanation of allocations. In the real world, some companies take a complex approach to allocations.

A complex approach to allocating product costs

One Revelwood client in the healthcare industry asked us to create an allocation model for their IBM Planning Analytics environment. They wanted to allocate a series of product costs by territory and customer combinations. The organization has multiple product categories such as commercial products, Medicare products and Medicaid products.

We tackled this challenge by designing an allocation model that could be added into their existing planning and reporting model. The new model allows the company to calculate allocation percentages by utilizing a series of methods. These methods included:

  • Using a standard allocation approach to calculate percentages via drivers that could be easily redefined
  • Defining a fixed percentage for a single product, then allocating the remaining percentage to all other products
  • Defining fixed percentages to existing subsets of products and then allocating those percentages into the specific products within each subset
  • Defining a percentage to an ad-hoc subset of products and allocating only to those products
  • Incorporating various combinations of these methods

This Planning Analytics allocation model uses a two-step process. First, it calculates the allocation percentages. Next, it uses the calculated percentages to allocate costs by entity, customer, product, territory and more. The model offers the financial team the flexibility to use an allocated series of independent expenses using a variety of drivers and approaches. This unique approach allows the team to separate the allocations into pieces and analyze the details throughout the process.

This approach saved the business a significant amount of time. Before Planning Analytics, the company spent days creating allocation calculations in Excel. With Planning Analytics, the company can now complete this process in approximately four minutes.

Are you interested in learning more about allocations and allocation models? Watch Revelwood’s webinar on Allocations in IBM Planning Analytics, read our blog post, IBM Planning Analytics Tips & Tricks: Allocations in IBM Planning Analytics or reach out to me to chat.

Want to see how IBM Planning Analytics can help your business? Visit the website for more information and to access a free trial.

More from Analytics

How IBM® and Esri are working together to map a more sustainable future

Businesses today have greater responsibility than simply making profits; they have a role to play in ensuring our planet remains livable for generations to come. Each year, we collectively release over 50 billion tons of carbon dioxide into the atmosphere, up 40% from 1990. Of these emissions, roughly 80% come from real estate, industry and transportation. If we’re going to succeed in sustainable development, actions must involve business owners. And businesses are responding. According to a 2022 survey of 3,000…

IBM named a Leader in The Forrester Wave™: Data Management for Analytics, Q1 2023

Accelerate your analytics transformation journey with IBM data management solutions The opportunity to work with many clients on their analytics journey inspires us to achieve even greater heights with our solutions. The findings of the recent Forrester Wave: Data Management for Analytics, Q1 2023 is a clear indication that IBM continues to be a leader in analytics, providing our customers with innovative and fully integrated solutions. [button link="" ]Read the report[/button]  IBM’s approach to data management for analytics Our purpose-built…

How technology can help save our water supply

A 2021 United Nations report finds that 2.3 billion people live in water-stressed countries which, according to the World Health Organization, is expected to be exacerbated in some regions due to climate change and population growth. To sustain lives on Earth, we must protect the health of its water resources and be efficient in our consumption, including minimizing waste in water distribution. These tasks involve a variety of equipment, assets, and people, and at IBM, we have deep experience in…

Web3 oracle nodes: The capabilities and challenges of an industry disruptor

In Greek mythology, oracles took once unattainable information from the gods and shared it with the world. Today, blockchain oracles pass information from one source to another. By design, a blockchain does not communicate with outside data sources; they only store historical on-chain user data. A blockchain oracle is the middleware that allows a blockchain to communicate with off-chain data. The addition of off-chain data provided by blockchain oracles was a huge step forward for the Web3 industry, enabling new use…