{"id":26631,"date":"2018-07-18T01:28:03","date_gmt":"2018-07-18T01:28:03","guid":{"rendered":"http:\/\/e-ratepaorg.local\/?p=26631"},"modified":"2018-07-20T01:40:19","modified_gmt":"2018-07-20T01:40:19","slug":"calculating-remaining-category-2-budgets","status":"publish","type":"post","link":"https:\/\/e-ratepa.org\/?p=26631","title":{"rendered":"Calculating Remaining Category 2 Budgets"},"content":{"rendered":"

July 18, 2018<\/p>\n

Update:\u00a0C2 Used Amounts as of July 16 2018 – FY 2015-2018<\/a><\/p>\n

Calculating remaining Category 2 budgets for each school or library is not difficult if you have the updated underlying data and know the formula.\u00a0 What underlying data?\u00a0 What Category 2 budgets have been used since FY 2015, what the individual school enrollment figures are (or library square footage), and the current per student budget amount.\u00a0 This data is then plugged into one of these formulas:<\/p>\n

Schools: (Current Enrollment x $156.23) \u2013 Committed Pre-discount Amounts since FY 2015 = Remaining C2 Budget.<\/p>\n

Urban Libraries: (Square Footage x $5.21) \u2013 Committed Pre-discount Amounts since FY 2015 = Remaining C2 Budget. \u00a0(These are libraries with IMLS Locale Codes of 11, 12, or 21<\/strong>) <\/em><\/p>\n

Non-Urban Libraries: (Square Footage x $2.39) – Committed Pre-discount Amounts since FY 2015 = Remaining C2 Budget.<\/p>\n

There are two methods that can aid in these calculations.<\/p>\n

    \n
  1. Attached Pre-Discount Approved Amounts.<\/strong> \u00a0The attached spreadsheet shows the subtotaled, pre-discount amounts\/school or library since FY 2015, as well as the same data but broken down by FRN line item (which also shows the first FY the entity received C2 funding).\u00a0 The advantage of using the attached spreadsheet is that is shows all school\/library buildings in a single location which can easily be put into your own spreadsheet.\u00a0 \u00a0However, you\u2019ll have to do the offline calculations using your own enrollment figures.\u00a0 The spreadsheet shows an example at the top of the page.<\/li>\n<\/ol>\n
      \n
    1. USAC\u2019s C2 Budget Tool.\u00a0 <\/strong>The USAC C2 Budget Tool has recently been updated to show the pre-discount amounts that have been committed (to date), and the amount of the C2 budget remaining based on the enrollment (or library square footage data) that is currently in that school\u2019s EPC profile.\u00a0 Until recently, the tool didn\u2019t include FY 2018 data and used old enrollment data so it wasn\u2019t much help but they\u2019ve updated the data and the tool is much better.\u00a0 The tool is on the public-facing side of the USAC website (not in EPC) at: https:\/\/sltools.universalservice.org\/portal-external\/budgetLookup\/<\/a>. \u00a0The advantage of using the USAC C2 Budget Tool is that it actually performs the remaining C2 budget calculations based on enrollments currently in EPC.\u00a0 However, there\u2019s no way to download the data in spreadsheet format, and it requires multiple clicks (expansions) to see the relevant data.\u00a0 Also, if you use the tool this fall, it won\u2019t be accurate as you\u2019ll have updated enrollment data and the tool won\u2019t reflect this data until your FY 2019 application has been approved.\u00a0 Screenshots for each step of this process are below.<\/li>\n<\/ol>\n

      Step 1: \u00a0<\/strong>https:\/\/sltools.universalservice.org\/portal-external\/budgetLookup\/<\/a><\/strong><\/p>\n

      \"C2-step1\"<\/p>\n

      Step 2:<\/strong><\/p>\n

      \"C2-step2\"<\/p>\n

      Step 3:<\/strong><\/p>\n

      \"C2-step3\"<\/p>\n

      Obviously, if your enrollment increases or decreases this fall, the remaining C2 budget balance will need to be adjusted.\u00a0 Also, the amounts reflect pre-discount amounts, not E-rate discounted amounts.\u00a0 C2 budgets are based on pre-discount amounts, not reflecting your E-rate discount.\u00a0 Further, remaining C2 budgets are based on the pre-discount amounts that were approved — not disbursed.\u00a0 So if you were approved for $10,000, but only used $5,000, the data will still reflect that $10,000 of your C2 budget was used. \u00a0File a Form 500 (in EPC) to return the remaining $5,000 to USAC so you can use the C2 funding in future years.\u00a0 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 or in the USAC C2 Tool.<\/p>\n

      If you have any questions about the future of Category 2, please refer to https:\/\/e-ratepa.org\/?p=26601<\/a>.\u00a0 If you have questions about calculating your C2 budgets, please don\u2019t hesitate to contact me!<\/p>\n

      — Julie<\/p>\n

      Julie Tritt Schell
      \nPA E-rate Coordinator
      \n717-730-7133 – o
      \n717-730-9060 – f
      \n      jtschell@comcast.net<\/a>
      \n      www.e-ratepa.org<\/a><\/p>\n\n

      Tweet<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

      July 18, 2018<\/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-26631","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\/26631","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=26631"}],"version-history":[{"count":0,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts\/26631\/revisions"}],"wp:attachment":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=26631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=26631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=26631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}