How to Calculate Allocations Based on Headcount

As part of Wise Up Wednesday, a new Host Analytics webinar series for quick tips and tricks from industry experts, UHY Advisors walks us through a model that calculates allocations based on headcount.

Regardless of how you want to allocate expenses or revenue you can get a lot of value from using modeling. Why allocate using Host Analytics Modeling? Many of our clients at UHY Advisors allocate expenses in order to build a product or project P&L. An additional benefit of using Modeling for allocations means you don’t have to touch the model if the number of products, projects, departments, accounts, etc. grows.

Some of our clients have allocated expenses in their ERP systems, and unfortunately, they’ve lost visibility to the details when the data comes into Host Analytics. In this situation, ‘deallocating expenses’ is essential to regain that visibility.  We have seen and built an extensive number of automated allocation models, whether it be for Actual or Plan (i.e., budget or forecast) data.

Here are 5 key areas to consider when setting up allocation models based on headcount:

  1. Setup the model to perform pre- and post-allocation numbers to see what the P&L looked like before and after the allocation
  2. Make sure to post offsetting entries so you don’t double count
  3. Set up your allocations, so you don’t need to change the model if you add new departments/products/projects
  4. Ensure that verification/checks are set up and visible to anyone using the model
  5. Lastly, make sure to implement leading practices like recursive or circular formulas to make allocations work in Modeling

Our  Wise Up Wednesday session “How to Calculate Allocations Based on Headcount” highlights a project we completed for a customer that wanted ‘lights out’ automation of the allocation of expenses, and they wanted to base the allocation percentage headcount by department. We show you the keys to how this allocation model works, but also touch on how you could build a model that allows for developing a manual allocation driver percentage.

So, to see it live in action, watch the on-demand webinar.

On-Demand Webinar

Related Posts

Modeling
Forecasting Life Sciences Gross to Net Revenues

Blue Line Planning walks us through the Life Science Gross to Net Revenue Solution, allowing life science companies to forecast sales and net revenues...

Read More
Modeling
Business on a Page – In Depth Visibility in One Source

‘Business on a Page’ is a reporting application built leveraging the Host Analytics Modeling technology. The one-page dynamic report gives each manager visibility to their organization, and all units reporting to them, in a consistent format...

Read More
Modeling
How to Manage Patient Trial Enrollment and Inventory

Managing and forecasting patient volumes, product utilization, inventory levels and costs by product, lot, dosage and expiry date to ensure sufficient inventory, access to that inventory and access to the limited, high cost manufacturing resources and facilities is a critical, complicated process...

Read More