ESH Sample Item 21 State Report 9.17.13

1

• Internet Pricing Portal
• Sample Item 21 State Report
• Prepared for the State of XXXX
• 10.1.2013

2
IMPORTANT NOTES

• This is how we anticipate using the Item 21
  attachment data in a reporting format
• There may be additional slides that we include as
  applicable trends and conclusions are uncovered
  as we codify and analyze the data
• In all cases, we will present only aggregate data
  and not identify specific school districts
• State reports are very malleable and based on
  your states wishes they can include or exclude
  any data that can be obtained through Form 471s,
  Item 21 attachments and our follow-up contacts
• Comments in orange boxes are provided to help
  guide the reader and will not be included in the
  report

Note text
3
Topics

• Reporting Overview
• Allotment of Funds
• Cost Variability
• Key Takeaways

4
Reporting Overview
Item 21 data collection in your state has been
successful, with 95 of school districts
reporting complete or partial 2013-14 Item 21
information
Statewide Reporting Numbers

• 95 of state school districts have self-reported
  their Item 21 information
• 190 of 200 school districts
• 80 of reporting school districts have given
  complete Item 21 information
• This analysis represents over 300M in annual
  purchasing in your state

Note Analysis is taken from 2013-14 Form 471,
Item 21 attachments submitted to USAC and sent to
ESH some submissions change prior to funding
commitment or disbursement
5
Reporting OverviewProcess
Below are the steps that we have taken with the
Item 21 attachment data from your states school
districts
Item 21 Analysis Process

1. Collect and organize the Item 21s as they are
   sent to us
2. Input every line item into a protected database
3. Categorize each line item into ESH specific
   subcategories and service/product types and
   highlight those that are unclear/ambiguous
4. Check that all Item 21 attachments have been
   received, based on submitted Form 471 Application
   numbers
5. Clarify unclear/ambiguous line items by emailing
   and/or calling school district contacts so that
   we can code the information as accurately as
   possible
6. Analyze and report on the cleanest possible
   version of the data

Note text
6
Reporting OverviewDistrict Size and Locale
Distribution
We obtained complete Item 21 information from 80
of school districts in your state reporting
districts are distributed as below
District Size
99 Tiny Small Medium Large Mega Total
Urban 13 6 9 15 3 46
Suburban 10 8 12 3 1 34
Town 4 15 19 - - 38
Rural 25 10 7 - - 42
Total 52 39 47 18 4 160
Locale
Note text
7
Topics

• Reporting Overview
• Allotment of Funds
• Cost Variability
• Key Takeaways

8
Preliminary AnalysisAllotment of Funds USAC
Categories
According to USAC-delineated categories reported
by applicants, Telecom costs are almost half of
your states spending
May include Priority 2 in addition to P1
Note This and all subsequent data from Form 471,
Item 21 data collected and analyzed as of xxx
9
Preliminary AnalysisAllotment of Funds ESH
Categories
ESH has categorized spending data to more
accurately align reporting with how services and
products are actually used
May include Priority 2 in addition to P1
Note Totals may not equal 100 due to rounding
10
Preliminary AnalysisAllotment of Funds
Categories Sub-Categories
ESH has categorized spending data to more
accurately align reporting with how services and
products are actually used
Telephony
Data Network
Mobile
Other Services

• POTS
• Trunk
• Voice usage
• Trunk Voice
• Exchange system
• VoIP
• Other tbd

• ISP services
• Upstream connectivity
• Upstream ISP
• District WAN
• Upstream WAN
• Other tbd

• Mobile voice
• Mobile data
• Other tbd

• Web hosting
• Email services
• Other tbd

11
Preliminary AnalysisAllotment of Funds Data
Network Sub-Category Visual
ISP Service only
Internet
ISP
Upstream Connectivity
Upstream ISP
S
DO
S
S
District WAN
12
Preliminary AnalysisAllotment of Funds Data
Network
May also be presented as a bar graph or as a
100 sub-category pie chart
The sub-category breakdown of Data Network costs
in your state
Categories
Sub-Categories
Note Totals may not equal 100 due to rounding
some smaller sub-category percentages are omitted
due to space
13
Preliminary AnalysisAllotment of Funds Data
Network
WAN costs are almost 80 of total data network
spending in your states school districts
14
Preliminary AnalysisAllotment of Funds
Telephony
May also be presented as a bar graph or as a
100 sub-category pie chart
The sub-category breakdown of Telephony costs in
your state
Categories
Sub-Categories
Note Totals may not equal 100 due to rounding
some smaller sub-category percentages are omitted
due to space
15
Topics

• Reporting Overview
• Allotment of Funds
• Cost Variability
• Key Takeaways

16
Preliminary AnalysisCost Variability Upstream
/ ISP Service
Your states school districts upstream ISP
Mbps per month costs vary dramatically, as do
their bandwidths
Note Includes total upstream connectivity and/or
ISP costs reported on Item 21s graph on the left
does not correlate to graph on the right
17
Preliminary AnalysisCost Variability Upstream
Cost vs Bandwidth
Best practice pricing in your state tends to be
under 2 per Mbps per month
May also be presented as a non-log graph
Best Practice
Note Log-log, graph includes total upstream
connectivity and/or ISP costs reported on Item 21s
18
Preliminary AnalysisCost Variability District
WAN
Cost per Mbps and WAN speed vary dramatically
within your state, as do the WAN bandwidths
Note Includes total WAN costs, including those
bundled with upstream (non-ISP) costs graph on
the left does not correlate to graph on the right
19
Preliminary AnalysisCost Variability WAN Cost
vs Bandwidth
Best practice school districts in your state that
have 1 Gbps WAN connections are paying less than
1 per Mbps
May also be presented as a non-log graph
Best Practice
Note Log-log graph includes total WAN costs,
including those bundled with upstream and ISP
costs Cost per Mbps is divided by the number of
sites within each WAN
20
Preliminary AnalysisCost Variability WAN Cost
vs Bandwidth
1 Gbps Internet connections via Managed Ethernet
are 3-6x times more expensive per month than
owned or leased dark fiber in your state
21
Topics

• Reporting Overview
• Allotment of Funds
• Cost Variability
• Key Takeaways

22
Key Takeaways

• Text
• Text
• text

Overview Trends

• Text
• Text
• text

Allotment of Funds

• Text
• Text
• text

Cost Variability

• Text
• Text
• text

Best Practice Pricing
23
Appendix
24
Glossary

• Can include, if desired
• Text
• Text