The Ledger

Curated content for
analytical business leaders

Tag Archives: cost allocation

CFO Magazine: 80% of CFOs Expect Cost Pressures to Persist Into Next Year: Weekly Stat

“As inflation rises and the quality of labor pools falls, financial executives must develop strategies, not only to juggle the external economic elements bearing down on their companies, but to remain proactive in efforts to sustain growth.”

Read More at CFO Magazine >

CFO Journal: Check it Twice: A Checklist for Rethinking Capital Allocation

CFO Journal came up with a checklist for re-evaluating your allocations strategy – and here are some of the items on that list:

Data. Do you have the data and insights you need to make informed decisions? Work with your stakeholders to determine what those are, where they need to come from, and how you can get them.

Tools. Where could data analytics, scenario planning, and risk-sensing tools improve your decision-making? Which tools do you already have, and which do you need? Engage your stakeholders on what data they need to generate from their business units.”

Read More at The Wall Street Journal >

CFO Magazine: Five Lessons for CFOs As We Approach 2021

“Cutting expenses in a defensive and reactive posture can have unintended consequences. Instead, create “what if” scenarios now and plan allocations for each. If the time comes, you can respond with a thoroughly vetted plan.”

Read More at CFO Magazine >

Cost Allocations: Gaining Actionable Insights With Detailed Calculations

Organizations face growing pressure to control costs and enable effective financial management of their resources to deliver value. Business leaders need visibility into the cost of the products and services they provide to know if their business is profitable at a granular level.  To get these insights, many implement a cost allocation methodology to make business units more accountable for the activities they perform and assigns the costs associated with these activities to the business units or cost centers based on their appropriate share of the cost.

A recent EY whitepaper, The Allocation Game, defines the practice of cost allocations as “managing costs before any money is spent.” An effective cost allocation methodology enables an organization to reduce costs by identifying what services are being provided and what they cost, allocating costs to business units, and managing cost recovery.

Cost allocations are key to determining how much it costs to manufacture products and serve customers while answering strategic questions that drive corporate decisions like, “Which customers or products are profitable?” or “What activities are driving costs?”. The goal is allocating or assigning costs based on root causes or drivers, instead of simply spreading the costs evenly. However, finding the right allocation methodology that provides fully loaded cost information that leads to actionable business insights can be a challenge. The Dinner Check Method is a simple, yet effective way to explain the different cost allocation methods, and why some of them lack cost transparency.

Three friends have dinner.  The generic split method divides the check evenly among three friends, even though they all individually ordered something different. Each person pays the exact same amount regardless of what they ordered, which isn’t entirely fair to any of the friends.

 

The second method is a bit more accurate since it assigns some items properly, but it’s not entirely right.  In our example, Friend 2 pays the correct amount while Friend 1 gets stuck with the entire appetizer, even though he shared it with Friend 3.  Better? Yes.  Precise?  Not really.

 

In our final example, each of the items is assigned to each friend based on what they consumed individually, making sure that each person is financial responsible for the items they ordered and how much they ate.   This approach is the most equitable, but also the hardest to track and calculate.

It’s All About the Drivers

Just like the Dinner Check Method, companies must decide the best way to “split the check” when it comes to allocating the direct and indirect spending associated with manufacturing, selling, and supporting products.  Our widget manufacturer makes three different widgets, each with different attributes that drive costs – one is expensive to setup, one uses lower-skilled workers that are less expensive, and one uses cheaper commodity materials.

The widget company generates $1,000,000 in revenue selling the three widgets, but spends about 45% of it for all of the production costs, overhead expenses and post-production activities.   How can they figure out which of the three widgets is profitable?  You can pick an arbitrary allocation rule – say revenue share – and assign the costs to each product using simple math.  Using this method, it appears that Widget 2 is the most profitable.

 

But is it really the most profitable?  Remember the cost drivers we discussed earlier – expensive setup times, low labor rates, and cheap commodity products?  By having a way to track those costs and allocate spending for each activity based on the specific ways each widget consumes them, it’s possible to unlock accurate COGS and activity costs which provides a more accurate margin calculation.  And while we already thought Widget 2 was profitable, it’s even better than we imagined.

Imprecise allocation methods lack the detailed cost and expense data necessary for cost transparency, which leads to poor costing decisions and behaviors. Implementing a programmatic and defined allocation process enables actionable cost management.  It redefines the cost allocation methodology to balance simplicity with the need for fully loaded costs, strengthen the link between drivers and business fundamentals, and improving data quality, all while driving down costs.

Establishing an Equitable and Accurate Allocations Process

Cost allocation methodologies are utilized to determine the true costs associated with customers, products and vendors. Outdated legacy systems coupled with the existence of multiple systems that house critical costing data contributes to the loss of transparency in cost allocation processes.

ImpactECS gives companies the ability to drive costs to unique products and SKUs.  The first step to launching any allocations process is by bringing together – or pooling – relevant production and finance data from systems across the organization.  Depending on the IT architecture, data from dozens of systems may be required to establish a central and harmonized data set.  With this solid data foundation, the next step requires identifying the most appropriate and measurable drivers, and using this information to dynamically calculate allocation rates.  These rates are used to assign expenses directly to products, giving meaningful and accurate insights into each product’s cost profile.

 

EY states, “A company’s ability to sustain cost management routines is rooted in its ability to embed cost control into business rhythm and cadence as well as integrate cost allocation within existing key processes such as financial planning, transfer pricing and pricing of critical services to generate a consistent view and understanding of costs within the organization.”  Organizations looking to sustain their ability to manage costs and expand their competitive advantage through meaningful insights must dig into the details and get access to the granular cost detail critical to see true profits – one SKU at a time.

Companies of all sizes leverage ImpactECS for allocations and rate building processes designed to inform decisions and ultimately increase profitability. Visit us at www.3csoftware.com to learn more.