Bid Evaluation Worksheet FY2023-24 Firewall.xlsx

	A	B	C	E	F	H	I	K	L	N	O	P	Q	R
1	E-Rate Bid Assessment Worksheet									Page	1	of	1
2	Funding Year 2023	7/1/2023-6/30/2024		Name of School		Carroll Community Schools
3
4	Project or Service		Firewall - SonicWall NSA 4700 or equivalent
5	Description from 470
6
7
8
9	Score each bid using a Raw Score: 1= worst, 5=best for each of the criteria. The weighted score should automatically calculate.
10
11				Vendor Scoring (use additional worksheets if necessary)
12
13				Western Iowa Networks		NetDiverse		Questivity		Vendor # 4 name			Vendor # 5 name
14				$8,164.72		$5,319.44		$10,613.39		insert price			insert price
15				Raw	Weighted	Raw	Weighted	Raw	Weighted	Raw	Weighted		Raw	Weighted
16	Selection Criteria		Weight*	Score**	Score***	Score	Score	Score	Score	Score	Score		Score	Score
17	Cost of Eligible Goods/Services		35%	4	1.4	5	1.75	3	1.05		0			0
18	Understanding of Needs		30%	5	1.5	3	0.9	5	1.5		0			0
19	Prior Experience		20%	5	1	1	0.2	1	0.2		0			0
20	Local Presence		10%	5	0.5	1	0.1	1	0.1		0			0
21	Timeley Bid		5%	5	0.25	5	0.25	5	0.25		0			0
22	Other (describe)
23	Other (describe)
24
25	Overall Ranking		100%		4.65		3.2		3.1		0			0
26
27
28	Vendor Selected:	Western Iowa Networks						NOTES: The winning bid is the most cost-effective solution to meet district needs.
29	Approved By:	Craig Rowedder
30	Title:	Director of Technology
31	Date:	3/17/2023
32
33	Notes:
34	* Percentage weights must add up to 100%. Price must be weighted the heaviest.
35	** Evaluated on a scale of 1 to 5: 1=worst, 5=best.
36	*** Weight x Raw Score
37	**** If no bids were received, indicate as such and sign/date this form.
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