Traffic Light Report

	A	B	C	D	E	F	G	H	I	J
1
2
3	Traffic Light Report
4	If you're a Spektrix user, we can build this report within your system - contact our Client Success team for this and any other custom reporting, all included in our role as your technology partner.
5
6	How to use this report:
7	Add your events, price bands and sales into the white boxes to quickly calculate how changes to pricing or zone capacity will impact on the overall potential of your event.
8	If the % capacity column is marked in red, sales are below 10%. If this is below target for this point in time, consider reducing the capacity of this price zone.
9	If the % capacity column is marked in green, sales are above 50%. Consider raising prices or increasing the capacity of this price zone.
10	Add unlimited rows to track potential across complex price points or whole seasons. Adjust the conditional formatting in Column J if you prefer to flag different capacities sold.
11
12	Event Name	Price Band	Price	Capacity	Sold	Reserved	Available	Value sold	Value available	% capacity
13	Beauty and the Beast	A	£22.50	250	63	6	181	£1,552.50	£4,072.50	27.60%
14							0	0	0
15							0	0	0
16							0	0	0
17							0	0	0
18							0	0	0
19							0	0	0
20							0	0	0
21	Total value sold	£1,552.50
22	Total value available	£4,072.50
23	Total potential	£5,625.00
24
25
26
27
28
29
30
31
32
33
34
35
36
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