WEBVTT

1
00:00:00.000 --> 00:00:09.590
In CCH Tagetik, we can plan for operating expenses by business unit, department, cost center or any other level of your organizational structure.

2
00:00:09.591 --> 00:00:19.181
Right from my CCH Tagetik home page, with a single click, I can access the operating expenses for my particular department in this example,

3
00:00:19.182 --> 00:00:28.773
and take a look at both my direct as well as indirect expenses all in one form. Now for my payroll expenses section, you can see that these cells are white,

4
00:00:28.774 --> 00:00:38.364
which means I can not edit them, this is because we choose to handle our HR expenses at a much more granular level, on first name, last name basis,

5
00:00:38.365 --> 00:00:47.955
and in this form we just want to view the output. Now, in the fixed expenses section you can see that my cells are yellow, which means that I'm able to edit them,

6
00:00:47.956 --> 00:00:57.542
and at the bottom I also have some visibility into IT costs which were allocated to my department through CCH Tagetik's built-in allocations engine.

7
00:00:58.757 --> 00:01:06.996
Now, before I start planning for my fixed expenses, I may be interested in taking a look at some of my prior years actuals 

8
00:01:06.997 --> 00:01:17.037
in fact, I want to do some further analysis and drill through to the GL subsystem to gain some useful transactional details such as suppliers 

9
00:01:17.038 --> 00:01:26.178
information and even invoice issue dates to help me plan for my next year's budget. Now, to start planning, I can do it the same way

10
00:01:26.179 --> 00:01:35.319
as I would in Excel, I can start typing in, add some different values, I can drag-and-drop, even use shortcuts like Ctrl+Z to undo my changes

11
00:01:35.320 --> 00:01:44.460
just like in Excel. I can also use any Excel formula such as equal, I can point to other cells, divide by 12 or use an even more advanced

12
00:01:44.461 --> 00:01:54.600
Excel syntax as well. Now, I could also start planning at a more aggregate level leveraging CCH Tagetik's spreading functionality where I could choose from a variety of methodoligies

13
00:01:54.601 --> 00:02:02.741
such as proportional or based on scenario to spread the changes according to the seasonality from my previous year's actuals for example.

14
00:02:02.742 --> 00:02:14.000
Now, if I choose the proportional method, CCH Tagetik will use the numbers that are already in there as weights so I could spread out my total or I can even spread out my variance to target, 

15
00:02:14.001 --> 00:02:22.023
if I want to achieve a certain variance. Not only that but, similarly, I could also spread fourth of all of my fixed expenses

16
00:02:22.024 --> 00:02:31.164
and have the changes spread right across. Now, once I'm done working on my numbers I can go ahead and save, and this is where CCH Tagetik will run 

17
00:02:31.165 --> 00:02:39.295
data validations that we can put in place to make sure our users respect certain business rules that we have preset.

18
00:02:40.720 --> 00:02:50.000
Now, if I want to detail further my monthly balances I could leverage the line item detail capabilities in CCH Tagetik and by clicking

19
00:02:50.001 --> 00:02:58.487
on my travel expenses I can start breaking it out in terms of individual trips, I can first provide the description and then enter 

20
00:02:58.488 --> 00:03:07.370
a value for my expenses, and of course we can also report on all of our line item details as well as their descriptions in CCH Tagetik.