A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
Revenue Functions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5 |
|
|
|
|
|
|
|
Synopsis |
|
|
|
|
|
|
|
|
|
|
|
|
6 |
|
|
|
|
|
|
|
Revenue Functions do the same job as a Price
and a Production function. |
|
|
|
|
|
|
7 |
|
Base |
|
6 months |
<-- Try changing this to 6 months |
Case 1 shows a basic
example wher Revenue is Price x Production. |
|
|
|
|
|
|
8 |
|
|
|
|
|
|
|
If you change the Base to 6 months in this
example, the total over |
|
|
|
|
|
|
|
9 |
|
Market Price |
|
20 |
|
|
|
the period rather amazingly stays the same,
showing that the calculation |
|
|
|
|
|
|
10 |
|
GrowthDates |
|
1 Jan 04 |
1 Jan 05 |
1 Jan 06 |
|
is robust. |
|
|
|
|
|
|
|
|
|
|
|
|
11 |
|
GrowthRates |
|
|
5% |
10% |
|
However, this is because the inputs are nice
round figures and, most |
|
|
|
|
|
|
12 |
|
|
|
|
|
|
|
crucially,
the ReviewMonths variable is et to only grow the price to |
|
|
|
|
|
|
13 |
|
|
|
|
|
|
|
a new level every 12 months. |
|
|
|
|
|
|
|
|
|
|
14 |
|
From Dates |
|
1 Apr 03 |
1 Jul 04 |
1 Oct 05 |
|
Case 2 shows where
this introduces innaccuracies and it's just not |
|
|
|
|
|
|
15 |
|
Annual Rates |
|
100 |
200 |
500 |
|
possible using two lines to accurately project
revenue where the |
|
|
|
|
|
|
|
16 |
|
Finish |
|
1 Oct 06 |
|
|
|
price is chaning frequently. |
|
|
|
|
|
|
|
|
|
|
17 |
|
|
|
|
|
|
|
Case 3 shows how the
Revenue Function approach is moer robust |
|
|
|
|
|
|
18 |
|
|
|
|
|
|
|
to changes in the timebase when the price
changes monthly. |
|
|
|
|
|
|
|
19 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
21 |
|
Case 1: Basic Example |
|
1
Jan 03 |
1 Jul 03 |
1 Jan 04 |
1 Jul 04 |
##### |
1 Jul 05 |
1 Jan 06 |
##### |
Total |
|
|
|
|
|
|
|
22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
23 |
|
|
|
ReviewMonths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
24 |
|
Price |
using Grow |
12 months |
20.00 |
20.00 |
20.00 |
20.00 |
20.00 |
20.00 |
21.00 |
21.00 |
|
|
|
|
|
|
|
|
25 |
|
Production |
using FStep |
|
25 |
50 |
50 |
100 |
100 |
175 |
250 |
125 |
875 |
|
|
|
|
|
|
|
26 |
|
Revenue |
|
|
500 |
1,000 |
1,000 |
2,000 |
2,000 |
3,500 |
5,250 |
2,625 |
17,875 |
|
|
|
|
|
|
|
27 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
28 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
29 |
|
Case 2: Where ReviewMonths<Timeperiod
length, inaccuracies creep in |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
31 |
|
|
|
ReviewMonths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
32 |
|
Price |
using Grow |
1 months |
20.00 |
20.00 |
20.00 |
20.00 |
20.00 |
20.49 |
21.00 |
22.02 |
|
|
|
|
|
|
|
|
33 |
|
Production |
using FStep |
|
25 |
50 |
50 |
100 |
100 |
175 |
250 |
125 |
875 |
|
|
|
|
|
|
|
34 |
|
Revenue |
|
|
500 |
1,000 |
1,000 |
2,000 |
2,000 |
3,586 |
5,250 |
2,753 |
18,090 |
|
|
|
|
|
|
|
35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
36 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
37 |
|
Case 3: A Revenue Function solves the
inaccuracy problem |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
38 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
39 |
|
|
|
ReviewMonths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
40 |
|
Revenue |
using FStepGrow |
1 months |
500 |
1,000 |
1,000 |
2,000 |
2,020 |
3,633 |
5,356 |
2,775 |
18,284 |
|
|
|
|
|
|
|
41 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
42 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
43 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
44 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
45 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
46 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
47 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
59 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
60 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
61 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
63 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
64 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
65 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
66 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
67 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
68 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
71 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
75 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
77 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
78 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
79 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|