WEBVTT

1
00:00:07.204 --> 00:00:16.666
CCH Tagetik's built-in configurable allocations engine makes managing your painful allocations and profitability analysis pain-free, dynamic and scalable.

2
00:00:16.667 --> 00:00:26.129
So here we have three expenses to be allocated, each with their own individual driver and we show the amount to be allocated. Drivers can be percentages, financial information such as revenue,

3
00:00:26.130 --> 00:00:35.592
or statistical data, for example square footage or headcount. The tables at the bottom of the form outline a walk through of each expense as it relates to the cost center

4
00:00:35.593 --> 00:00:45.055
showing us the expenses amount before, the amount to be allocated and the total amount after the allocation. So for rent, we can see that our shared services department 

5
00:00:45.056 --> 00:00:54.518
has an amount of just over $30.000, this amount will be allocated based off of the cost center's square footage and CCH Tagetik's allocation engine will allocate

6
00:00:54.519 --> 00:01:03.000
these percentages and amounts of that $30.000 to each cost center to bring us to our total allocation amount. The important thing here about the allocated amount is 

7
00:01:03.001 --> 00:01:13.444
that CCH Tagetik will never alter the original data and it categorizes or labels that allocated amount with specific tags. The system does this automatically and it makes it 

8
00:01:13.445 --> 00:01:22.907
very easy to report results including or excluding these allocated entries. Now, on to the second step of our allocation: allocating these expenses to customers and products. 

9
00:01:22.908 --> 00:01:32.370
Again, we displayed the amount to be allocated in a driver that will be using, in this case revenue. So for products the allocation percentage is based on the 

10
00:01:32.371 --> 00:01:41.833
revenue that each product brings in, we can see how much of our allocated amount is going to each product and the total expense amount on that product post allocation. So now that we've

11
00:01:41.834 --> 00:01:51.296
taken a look at the results that CCH Tagetik's built in allocation engine provided, let's take this one step further by analyzing our customer and product profitability. On this form 

12
00:01:51.297 --> 00:02:00.759
you have a condensed P&L view displayed by customers, industries and product groupings. So now we can easily see Walmart sales revenue and COGs, giving us our gross margin,  

13
00:02:00.760 --> 00:02:10.222
the allocated expenses, our operating margin and subsequently our customer and product profitability. All of this is managed through our built-in engine ,

14
00:02:10.223 --> 00:02:20.000
so as usual in CCH Tagetik, no development, no scripting and no coding required. The setup is dynamic and scalable, so as your organization changes and grows, the rules adapt without maintenance.