WEBVTT

1
00:00:07.490 --> 00:00:11.492
This video will take a look at budgeting and planning your retail stores in CCH Tagetik.

2
00:00:12.775 --> 00:00:22.500
So our sample revenue model begins with the management of our stores, users can manage existing stores and even change the status for temporary closings, they can also model new stores,

3
00:00:22.501 --> 00:00:31.558
giving them a quick description and assigning them in a specific store type, and comparable stores to have the system automatically precede that stores budget data 

4
00:00:31.559 --> 00:00:40.951
based off of the comparable stores data. Once we've created a new store, we're able to start budgeting. So now I'll open up our new store pro-forma for Stamford 

5
00:00:40.952 --> 00:00:50.500
Town Center store. Here, we're looking at a monthly view, but within each one of these months we can see our weekly planning details. The store traffic, 

6
00:00:50.501 --> 00:00:59.736
customer conversion rate and number of transactions were all pre-populated based off of the comparable store option that we set when creating it. In this example

7
00:00:59.737 --> 00:01:09.128
we've set a planning methodology to be based off of the average spend per person and given a driver value of $105 to drive our revenues. Of course, 

8
00:01:09.129 --> 00:01:18.521
any value in yellow means that we can update it and watch the system automatically update the numbers on the fly, we then have the ability to add any manual adjustment,

9
00:01:18.522 --> 00:01:27.913
a percent discount and watch the system automatically calculate our sales discount amount, our net revenue and our revenue by square foot. Now, hidden in the top of the form, 

10
00:01:27.914 --> 00:01:37.306
we have a graphical representation of the revenues by week and we also have the ability to add information like square footage and store manager. 

11
00:01:37.307 --> 00:01:46.698
So now that we're done with the in putting, let's take a look at some of our reports. A quick jump back into our workflow allows us to access some analytical reporting.

12
00:01:46.699 --> 00:01:56.091
So taking a look at the same store analysis, not only do we have visibility into some of the financial information, but I also have visibility into some statistical 

13
00:01:56.092 --> 00:02:05.483
information as well. Here we're comparing our new stores to our existing stores and we're displaying our budget, our prior year actuals

14
00:02:05.484 --> 00:02:15.000
and showing a percent variance. We're doing all of this on an annual level, on a quarterly level and hidden within the columns, we have a view into our monthly details.