• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

P&L planning models

IBM Planning Analytics Tips & Tricks: Allocations

August 31, 2021 by Lee Lazarow Leave a Comment

Tips & Tricks

P&L planning models consist of a variety of inputs, including revenue planning and various forms of expense planning. In addition to these standard models, we are often asked to develop other planning components. One of these components entails an allocation process, which leads to the question: what is an allocation?

An allocation is defined as “the action or process of distributing something.” In business terms, this typically entails the movement of costs. This could include moving overhead costs to revenue centers or moving IT costs to other departments. The result of this process ensures that costs become associated with the areas where they “should be” recorded. This allows you to create P&L reports and profit analyses of sub-sections of your business. 

There are typically three components to the allocation process:

  • Source – the original value
  • Target – where the value is moved/spread to
  • Offset – a negative value associated with the target; this is usually the same intersection as the source

The calculation is relatively simple: take a number and divide it by a total to define a proration percent. This value is called a driver and is defined as a metric that can be used to determine how the costs are spread. Examples of drivers can include headcount (for HR expenses) or number of computers (for IT costs) or revenue dollars (for a sales manager’s expenses).

Once the allocation percentages are defined, the process is performed by simply spreading the source value to the targets using the percentages. The process also creates a negative entry as an offset. The offset ensures the ending value is not doubled while also providing an easy audit check by determining that the net result of the allocation is zero.

Within IBM Planning Analytics, we often use separate elements to separate the source value from the allocation details. This gives us the ability to view the pre-allocated values, the allocation amounts, and the post-allocated values.

IBM Planning Analytics Tips & Tricks: Allocations

Want to learn more about allocation details or recommended best practices? Contact us.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Depreciation

IBM Planning Analytics Tips & Tricks: 445

IBM Planning Analytics Tips & Tricks: PAW Lines vs Area for Multiple Elements

Home » P&L planning models

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: allocation model, allocations, IBM Cognos TM1, P&L planning models

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.