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