{"id":17211,"date":"2016-12-14T15:46:49","date_gmt":"2016-12-14T15:46:49","guid":{"rendered":"http:\/\/e-ratepaorg.local\/?p=17211"},"modified":"2016-12-15T15:49:21","modified_gmt":"2016-12-15T15:49:21","slug":"category-2-budget-calculator-worksheet","status":"publish","type":"post","link":"https:\/\/e-ratepa.org\/?p=17211","title":{"rendered":"Category 2 Budget Calculator Worksheet"},"content":{"rendered":"<p>December 14, 2016<\/p>\n<p>I know many of you are considering applying for Category 2 E-rate funding for FY 2017 and trying to calculate your C2 pre-discount budgets.\u00a0 C2 school budgets are generally easy to calculate if you have not applied for C2 funding for a school in FY 2015 or FY 2016 (simply multiply $150 x # of students enrolled in a school).\u00a0 Where it becomes challenging is when you have applied for funding in one or both of the previous two funding years.\u00a0 It becomes even more difficult when you have submitted or are intending to submit a Form 500 to return some of your commitment that was unspent.<\/p>\n<p>USAC has indicated that they intend to release an online C2 budget calculator in the coming weeks\/months; however, I know you need to these budgetary figures NOW.\u00a0 Therefore, <a href=\"https:\/\/e-ratepa.org\/wp-content\/uploads\/2016\/12\/C2-Budget-Calculator-FY-2017.xlsx\" class=\"mtli_attachment mtli_xlsx\" target=\"_blank\">attached is a spreadsheet<\/a> that will help you though these calculations.<\/p>\n<p>A few notes:<\/p>\n<ul>\n<li>If your FY 2016 C2 funding request is still pending, be sure to include it with your calculations as it WILL be funded and not available in your FY 2017 C2 budget for that school.<\/li>\n<li>If you were committed C2 funding and realize that you will not be using the entire commitment amount, be sure to file a Form 500 to \u201creturn\u201d the commitment (not actual money) to USAC so that those funds are available in your C2 budget for a future funding year.<\/li>\n<li>Don\u2019t forget, these are PRE-discount figures.\u00a0 Your E-rate discount will then apply on top of that and you will be responsible for paying the non-discounted share.\u00a0 (For example, if your pre-discount C2 budget is $10,000 and your discount is 60%, E-rate will pay $6,000 and you will be required to pay the vendor $4,000).<\/li>\n<li>Category 2 budgets are calculated by school and cannot be moved around.\u00a0 The only exception is if you\u2019re purchasing equipment that is being shared by multiple schools in which case you will use the C2 budgets of the schools connected to or utilizing the equipment.<\/li>\n<li>You may use the enrollment data from FY 2016 (currently in your EPC profile) or the FY 2017 enrollment, but it must be a complete dataset.\u00a0 Meaning, you can\u2019t pick and choose to update the enrollment for some schools and not others.\u00a0 The FY 2017 enrollment\/NSLP data (submitted by schools October 2016) will be coming out from PDE in mid-late January and I\u2019ll send to the PA E-rate listserve as soon as it\u2019s received.<\/li>\n<li>The spreadsheet shows an example where enrollment increased in FY 2017 and no additional C2 funds are available.<\/li>\n<li>The spreadsheet also shows an example where less than 62 students are enrolled and therefore they will receive the minimum $9200 C2 cap.<\/li>\n<\/ul>\n<p>As always, if you have any questions, please don\u2019t hesitate to contact me!<\/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>December 14, 2016<\/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-17211","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\/17211","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=17211"}],"version-history":[{"count":0,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts\/17211\/revisions"}],"wp:attachment":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}