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:
There are four key phrases associated with allocations. These are:
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.
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:
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.
The post Smart approaches to allocations in enterprise financial and operational planning appeared first on Journey to AI Blog.
The large language model (LLM) has become a cornerstone of many AI applications.
Computer use is a breakthrough capability from Anthropic that allows foundation models (FMs) to visually…
OpenAI's new API and Agents SDK consolidate a previously fragmented complex ecosystem into a unified,…
A directive from the National Institute of Standards and Technology eliminates mention of “AI safety”…
Speech foundation models, such as HuBERT and its variants, are pre-trained on large amounts of…
This post was co-written with Vishal Singh, Data Engineering Leader at Data & Analytics team…