WEBVTT
1
00:00:00.930 --> 00:00:02.370
Okay.
2
00:00:02.370 --> 00:00:06.700
I didn't have the squash for
the last session,
3
00:00:06.700 --> 00:00:12.410
because I thought by now,
you guys are okay with this much numbers.
4
00:00:12.410 --> 00:00:14.530
But now, we gotta get through the rest,
5
00:00:14.530 --> 00:00:19.565
and I think we gotta remind ourselves
that we have to eat our vegetables here.
6
00:00:19.565 --> 00:00:22.520
Let's walk through this,
we're going to be good for that.
7
00:00:22.520 --> 00:00:27.610
So the next thing to do is
to see how much left can be
8
00:00:27.610 --> 00:00:33.540
expected in terms of units sold of
Very Spaghetti from this TV ads.
9
00:00:33.540 --> 00:00:39.470
The thing to remember that I have not
mentioned yet, is that while the ads ran
10
00:00:39.470 --> 00:00:45.450
in June and July, the national campaign
is going to happen in December.
11
00:00:45.450 --> 00:00:50.060
So the test,
the experiment was done in June and July.
12
00:00:50.060 --> 00:00:53.140
But the national campaign is
going to happen in December,
13
00:00:53.140 --> 00:00:55.780
which is the peak holiday season.
14
00:00:55.780 --> 00:00:59.210
Keep that in mind,
because that has important implications.
15
00:00:59.210 --> 00:01:03.080
But we need to also consider
that when we are projecting
16
00:01:03.080 --> 00:01:06.190
the lift in Arizona to the national level.
17
00:01:06.190 --> 00:01:09.740
So, what are the steps that
we need to do to project
18
00:01:09.740 --> 00:01:13.300
the sales left in Arizona
to the national level?
19
00:01:13.300 --> 00:01:19.369
So, the first things to consider is we
are at Arizona and that's the 267% left.
20
00:01:19.369 --> 00:01:25.580
The next thing to do,
is to take from Arizona test stores
21
00:01:25.580 --> 00:01:31.570
within the chain to the chain level
of all the stores in Arizona.
22
00:01:31.570 --> 00:01:34.450
From there, we gotta go to the national
23
00:01:34.450 --> 00:01:39.200
level number of stores in
the entire country in that chain.
24
00:01:40.380 --> 00:01:43.570
Then all retail across all chains.
25
00:01:43.570 --> 00:01:47.820
And then from there, we have to
project it to the selling season.
26
00:01:47.820 --> 00:01:53.460
So we have the step by step projections
that we need to do to take the sales in
27
00:01:53.460 --> 00:01:58.770
Arizona in a small number of stores,
then a particular chain,
28
00:01:58.770 --> 00:02:04.490
to the chain level within Arizona,
to the national chain level,
29
00:02:04.490 --> 00:02:10.050
to the entire retail across all the
chains, and then to the selling season,
30
00:02:10.050 --> 00:02:16.250
projecting the lift from June and
July to the holiday season.
31
00:02:16.250 --> 00:02:18.590
So these are the steps in the projection.
32
00:02:18.590 --> 00:02:21.820
I'm just showing you
the steps here conceptually.
33
00:02:21.820 --> 00:02:27.500
Now, we're going to take these and
apply the numbers that we have and
34
00:02:27.500 --> 00:02:31.862
see how much in unit sales
can Very Spaghetti expect
35
00:02:31.862 --> 00:02:35.731
from a TV advertising
campaign in December.