Popularity Based Pricing Calculator

	A	B	C	D	E	F	G	H
1
2
3	Popularity-Based Pricing Calculator
4	If you're a Spektrix user, contact our Client Success team for custom reporting, and data benchmarks, all included in our role as your technology partner.
5
6
7	How to use this calculator:
8	First populate the Programme Strand, Month and Day tables below - you only need to do this once.
9	Then use the dropdowns in the Popularity Calculator below to quickly explore average prices for similar events.
10	Use this to define base prices, update your pricing model or take your first steps into pricing flexibly.
11
12	Your knowledge of planned campaigns, partnerships or audience behaviour will influence the exact price you set for individual events. Using data to guide your price setting can help to test your assumptions about what people will pay.
13
14	To calculate overall event pricing:
15	PROGRAMME STRAND		MONTH		DAY		Calculated mean
16	Musical Theatre	£21.00	January	£21.00	Monday	£21.00	£21.00
17
18	Data Tables
19	List your event genres in Table 1.
20	For each genre, month of the year and day of the week, run a report to calculate average ticket price, and enter these into the green boxes.
21	If you regularly hold matinees, add rows to Table 3 to separate daytime and evening events.
22
23	TABLE 1: PROGRAMME STRAND			TABLE 2: MONTH			TABLE 3: DAY
24	Programme/genre	Average price		Month of year	Average price		Day of week	Average price
25	Musical Theatre	£21.00		January	£21.00		Monday	£21.00
26				February			Tuesday
27				March			Wednesday
28				April			Thursday
29				May			Friday
30				June			Saturday
31				July			Sunday
32				August
33				September
34				October
35				November
36				December
37
38
39
40
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100