{"id":21791,"date":"2017-10-16T02:13:24","date_gmt":"2017-10-16T02:13:24","guid":{"rendered":"http:\/\/e-ratepaorg.local\/?p=21791"},"modified":"2017-10-17T02:16:03","modified_gmt":"2017-10-17T02:16:03","slug":"category-2-budgets-remaining-amounts-committed-as-of-oct-16","status":"publish","type":"post","link":"https:\/\/e-ratepa.org\/?p=21791","title":{"rendered":"Category 2 Budgets Remaining &#8211; Amounts Committed as of Oct 16"},"content":{"rendered":"<p>October 16, 2017<\/p>\n<p>Attached:\u00a0<a href=\"https:\/\/e-ratepa.org\/wp-content\/uploads\/2017\/10\/C2-Budgets-Used-As-of-Oct-16.xlsx\" class=\"mtli_attachment mtli_xlsx\" target=\"_blank\">C2 Budgets Used As of Oct 16<\/a><\/p>\n<p>Funding Year 2018 marks the fourth year that schools and libraries can utilize the new E-rate Category 2 funding initiative.\u00a0 Calculating what has been spent and what remains to be used can be tricky as not all of the data rests in one single place.\u00a0 However, it is imperative for applicants to know this data so they can determine what Category 2 budgets remain by building.\u00a0 To help with this effort, I\u2019ve combined data from multiple sources and attached to this message is a spreadsheet that shows, by building, the pre-discount amounts of Category 2 funding that have been committed by USAC since FY 2015.\u00a0 Please read the following notes carefully so you understand what is and what is not included in this data.<\/p>\n<ul>\n<li>The data includes APPROVED PRE-DISCOUNT AMOUNTS through October 16, 2017 for Funding Years 2015, 2016 and 2017.<\/li>\n<li>If your FY 2017 Form 471 for Category 2 funding is still pending, the funding requested on that application is NOT included in this spreadsheet. However, I included a separate tab showing the pending FRNs for FY 2017.\u00a0\u00a0 These are not at the building level \u2013 just the district level.\u00a0 If you\u2019re on the \u201cpending\u201d list, you\u2019ll need to factor these buildings\u2019 C2 pending pre-discount requests into your calculations.<\/li>\n<li>The amounts reflect pre-discount amounts, not committed amounts.\u00a0 C2 budgets are based on pre-discount amounts, not reflecting your E-rate discount.\u00a0 This spreadsheet, likewise, does not including any data related to amounts with E-rate discounts applied.<\/li>\n<li>Remaining C2 budgets are based on commitments, not disbursements.\u00a0 So if you were committed $10,000, but only used $5,000, file a Form 500 to return the remaining $5,000 commitment to USAC so you can use the C2 funding in future years.\u00a0 The Form 500 is filed in EPC.<\/li>\n<li>If you have submitted a Form 500 to return an unused commitment and it has not yet been processed by USAC, it would not be reflected in this spreadsheet.<\/li>\n<\/ul>\n<p><strong>How to Use This Data to Calculate Your Remaining C2 Budgets<\/strong><br \/>\nWith this data, you can easily calculate the amount of pre-discount Category 2 funding remaining.\u00a0 I\u2019ve included three extra columns (green) in the spreadsheet to show how to perform the calculations, and included an example (yellow).<\/p>\n<ol>\n<li>List the School\u2019s Current Enrollment.\u00a0 This should be the enrollment provided to PDE with the October 2017 NSLP data (Column J).<\/li>\n<li>Multiply the School\u2019s Current Enrollment by $153.47 to obtain Current 5-Year C2 Pre-Discount Budget (Column K).<\/li>\n<li>Subtract the subtotal of each school\u2019s Committed, Pre-Discount Amounts from Column I.\u00a0 This will be the amount of C2 funding remaining to be used.<\/li>\n<li>If there are any pending FY 2017 C2 FRNs (shown in the pending tab), subtract those building pre-discount amounts from the C2 available budget.<\/li>\n<\/ol>\n<p>Libraries will use the same method to calculate remaining C2 budgets, but instead of $153.47 per student, they will use $2.35 per sq. ft. for non-urban libraries, and $5.12 per sq. ft. for large, urban libraries.<strong>\u00a0 <\/strong>See Library Sq. Ft. Tab in spreadsheet for details.<\/p>\n<p><strong>How Many Years Will Category 2 Funding Be Available?<\/strong><\/p>\n<p>The answer is \u2013 we\u2019re unsure.\u00a0 The rules say that the C2 budgets are 5-year rolling budgets, based on the first year that any school in the district was committed C2 funding.\u00a0 However, the rules also say that the C2 funding initiative is only available through FY 2019, after which it will sunset unless the FCC takes action.\u00a0 Therefore, I strongly encourage all schools and libraries to consider their internal connections needs, and utilize their Category E-rate budgets in either Funding Year 2018 or 2019.<\/p>\n<p>If you find that any data for any of your schools or libraries is inaccurate, please let me know.<\/p>\n<p><strong>Where Can You Find Category 2 Data?<\/strong><\/p>\n<ul>\n<li>USAC has a C2 budget tracking tool where you can search C2 commitments by building entity number, but it doesn\u2019t include any FY 2017 data.\u00a0 <a href=\"https:\/\/sltools.universalservice.org\/portal-external\/budgetLookup\/\">https:\/\/sltools.universalservice.org\/portal-external\/budgetLookup\/<\/a><\/li>\n<li>I obtained the data in the attached spreadsheet from two sources:<\/li>\n<\/ul>\n<p>&#8212; FY 2015:\u00a0 <a href=\"https:\/\/slweb.universalservice.org\/form471publicdatatool\/app\/#\/\">https:\/\/slweb.universalservice.org\/form471publicdatatool\/app\/#\/<\/a> (\u201ccurrent\u201d view)<\/p>\n<p>&#8212; FY 2016 and 2017:\u00a0 <a href=\"https:\/\/data.usac.org\/publicreports\/Forms\/Form471Detail\/Index\">https:\/\/data.usac.org\/publicreports\/Forms\/Form471Detail\/Index<\/a> (\u201ccurrent\u201d form version)<\/p>\n<p>Stay tuned for a Category 2-specific webinar in the next few weeks!<\/p>\n<p>&#8212; Julie<\/p>\n<p>Julie Tritt Schell<br \/>\nPA E-rate Coordinator<br \/>\n717-730-7133 &#8211; o<br \/>\n717-730-9060 &#8211; f<br \/>\n<a href=\"mailto:jtschell@comcast.net\">jtschell@comcast.net<\/a><br \/>\n<a href=\"http:\/\/www.e-ratepaorg.local\">www.e-ratepa.org<\/a><\/p>\n<p>Penn*link<\/p>\n\n<div class=\"twitter-share\"><a href=\"https:\/\/twitter.com\/intent\/tweet?via=eratepenn\" class=\"twitter-share-button\" data-size=\"large\">Tweet<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>October 16, 2017<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52],"tags":[],"class_list":["post-21791","post","type-post","status-publish","format-standard","hentry","category-listserve_archive"],"_links":{"self":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts\/21791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=21791"}],"version-history":[{"count":0,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts\/21791\/revisions"}],"wp:attachment":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=21791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=21791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=21791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}