SAMPLE Programming Scorecard and Financials v1.xls

	A	C	D	E	F	G	H	I	J
1	Legend	Event Date	2/15/2020	3/20/2020	4/15/2020	5/21/2020	6/17/2020	7/18/2020	CONTINUE ADDING NEW EVENTS TO THE RIGHT
2	Manually input	Event Title	Event name / location	Event name / location	AWARD CEREMONY	Event name / location	WORKSHOP	Event name / location
3	Computer calculates	Company	Speaker's company	Speaker's company	Just an Example…	Speaker's company	Just an Example...	Speaker's company
4	Obtain from Membership	Speaker	Name of speaker	Name of speaker	…of a LARGE Event	Name of speaker	…of a SMALL Event	Name of speaker
5	Obtain from Surveys	Attendance Data
6		Members Registered	35	40	65	33	15	57
7		Guests Registered	30	45	90	48	2	40
8		Students Registered	5	5	20	6	1	3
9		Total Registered Attendees	70	90	175	87	18	100
10		Walkup Data
11		Members Walk up	3	2	7	2	1	2
12		Guests Walk up	3	4	12	2	1	5
13		Students Walk up	0	2	6	2	1	2
14		Total Registered Walkups	6	8	25	6	3	9
15		Comps Data
16		Comps - Sponsors	6	6	12	6	0	6
17		Comps - Speakers	1	1	4	1	0	1
18		Comps - Board	2	2	6	2	0	2
19		Total Registered Comps	3	3	10	3	0	3
20		Total Attendance	79	101	210	96	21	112
21		Attendance Goal	100	100	175	100	20	100
22		% Goal Achieved	79%	101%	120%	96%	105%	112%
23		Current Members	290	285	295	300	305	280
24		% of Members Attended	12.1%	14.0%	22.0%	11.0%	4.9%	20.4%
25
26		Financial Results (Income)
27		EventBrite Income	$2,330.00	$2,600.00	$12,200.00	$2,820.00	$400.00	$2,705.79
28		Walkup Income	$260.00	$145.00	$250.00	$120.00	$20.00	$215.00
29		Sponsor Income (CASH - not In Kind)	$750.00	$750.00	$1,500.00	$750.00	$0.00	$1,250.00
30		Total Income	$3,340.00	$3,495.00	$13,950.00	$3,690.00	$420.00	$4,170.79
31		Financial Results (Expenses)
32		Catering & Venue	$1,405.44	$1,515.24	$8,900.00	$2,620.00	$300.00	$650.00
33		Merchant Fees (e.g. EventBrite)	$100.00	$100.00	$350.00	$100.00	$20.00	$100.00
34		A/V Rental (if a sponsor, NO cost)	$775.00	$775.00	$775.00	$775.00	$0.00	$775.00
35		Travel			$550.00
36		Thank You Gifts	$25.00	$25.00	$75.00	$25.00	$0.00	$25.00
37		Additional Expenses			$1,500.00	$350.00
38		Total Expense	$2,305.44	$2,415.24	$12,150.00	$3,870.00	$320.00	$1,550.00
39		Net Profit (Income-Expense)	$1,034.56	$1,079.76	$1,800.00	($180.00)	$100.00	$2,620.79
40
41		Calculated Financial Metrics
42		% Comp Attendees	3.8%	3.0%	4.8%	3.1%	0.0%	2.7%
43		Income / Attendee	$42.28	$34.60	$66.43	$38.44	$20.00	$37.24
44		Profit / Attendee	$13.10	$10.69	$8.57	($1.88)	$4.76	$23.40
45
46		Satisfaction Scores
47		Presenter	4.67	4.25	3.96	3.38	4.25	3.96
48		Relevancy of Topic	4.44	4.50	4.61	4.15	4.50	4.61
49		Date & Time	4.78	4.57	4.61	4.08	4.57	4.61
50		Location	4.67	4.64	4.26	4.46	4.64	4.26
51		Value	4.33	4.19	4.17	4.00	4.19	4.17
52		Overall event	4.44	4.33	4.26	3.77	4.33	4.26
53		Expectations
54		Exceeded	33%	22%	22%	15.4%	22%	22%
55		Met	67%	63%	78%	61.5%	63%	78%
56		Failed	0%	15%	0%	23.1%	15%	0%
57		Recommendation
58		Very likely	67%	43%	52%	38%	43%	52%
59		Likely	33%	39%	35%	38.5%	39%	35%
60		Neutral	0%	14%	13%	7.7%	14%	13%
61		Unlikely	0%	4%	0%	15.4%	4%	0%
62		Very unlikely	0%	0%	0%	0.0%	0%	0%
63		Total Responses	9	28	23	14	6	23
64		Response Rate	11%	28%	11%	15%	29%	21%
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