{"id":30061,"date":"2019-03-13T00:07:48","date_gmt":"2019-03-13T00:07:48","guid":{"rendered":"http:\/\/e-ratepaorg.local\/?p=30061"},"modified":"2019-03-14T00:14:33","modified_gmt":"2019-03-14T00:14:33","slug":"how-to-allocate-c2-budgets-for-shared-equipment","status":"publish","type":"post","link":"https:\/\/e-ratepa.org\/?p=30061","title":{"rendered":"How to Allocate C2 Budgets for Shared Equipment"},"content":{"rendered":"<p>March 13, 2019<\/p>\n<p>~ And what to do if one\/several of the schools don\u2019t have enough C2 funding remaining ~<\/p>\n<p>If a piece of Category 2 equipment is utilized by two or more schools, the cost of the equipment must be allocated from the C2 budgets of the schools sharing the equipment \u2013 regardless of where the equipment is physically located.\u00a0 Core switches, firewalls, and wireless controllers are good examples of shared equipment.\u00a0 After you enter the costs in the FRN Line Item and identify the schools utilizing the equipment, the 471 will ask <em>&#8220;Are the costs shared equally among all of the entities?&#8221;.<\/em>\u00a0 \u00a0How you answer this question is important!<\/p>\n<ul>\n<li>If you answer \u201cYes,\u201d the system will split the costs of this line item equally among the recipients identified.\u00a0 For example, if the equipment costs $30,000 and there are 3 schools sharing the equipment, the system will take $10,000 from each school&#8217;s C2 budget.\u00a0 This is <strong>not<\/strong> the method that most applicants will want to choose, even though it&#8217;s very tempting to click &#8220;Yes&#8221; and let the system do the math for you.<\/li>\n<\/ul>\n<ul>\n<li>You may want to answer \u201cNo,\u201d and use a weighted allocation, performing the math offline.\u00a0 Note:\u00a0 This can only be done for a piece of equipment that is shared by two or more entities.\u00a0 You can\u2019t do a weighted allocation if equipment is just being used by a single school.<\/li>\n<\/ul>\n<p><strong>Weighted Allocation Options <\/strong><\/p>\n<p>You are free to develop your own cost allocation based on a method that is defendable.\u00a0\u00a0This could be % of enrollment, % of usage, # of total users (not just students), etc.\u00a0 Whichever method you choose, keep your calculations so you can easily show your math to USAC or an auditor.<\/p>\n<p>&nbsp;<\/p>\n<p>The most common method of weighted allocate ion is by % of enrollment.\u00a0 Here are the steps and an example:<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Take total enrollment for all schools being served by the shared equipment.<\/li>\n<li>Divide school enrollment by total enrollment to obtain % enrollment for that school.<\/li>\n<li>Multiple school % enrollment by total cost of equipment.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<table border=\"1\" width=\"517\" bgcolor=\"e5ecf5\">\n<tbody>\n<tr>\n<td width=\"115\"><\/td>\n<td width=\"108\"><strong>Enrollment<\/strong><\/td>\n<td width=\"105\"><strong>% Enrollment<\/strong><\/td>\n<td width=\"189\"><strong>% Enrollment x Cost of Shared Component<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"115\"><strong>Plainfield Elem<\/strong><\/td>\n<td width=\"108\">225<\/td>\n<td width=\"105\">0.21<\/td>\n<td width=\"189\">$6,355.93<\/td>\n<\/tr>\n<tr>\n<td width=\"115\"><strong>Jacksonville MS<\/strong><\/td>\n<td width=\"108\">256<\/td>\n<td width=\"105\">0.24<\/td>\n<td width=\"189\">$7,231.64<\/td>\n<\/tr>\n<tr>\n<td width=\"115\"><strong>Franklin HS<\/strong><\/td>\n<td width=\"108\">581<\/td>\n<td width=\"105\">0.55<\/td>\n<td width=\"189\">$16,412.43<\/td>\n<\/tr>\n<tr>\n<td width=\"115\"><\/td>\n<td width=\"108\"><strong>1062<\/strong><\/td>\n<td width=\"105\"><strong>\u00a0<\/strong><\/td>\n<td width=\"189\"><strong>$30,000.00 <\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>How to Handle Schools with Too Little (or no) Remaining Category 2 Budgets<\/strong><\/p>\n<p>As I\u2019ve said previously, never ever request more funding than is available in a school\u2019s C2 budget.\u00a0 If you find that a school with no remaining C2 budget will be sharing a piece of equipment, the best thing to do is list the total amount of the equipment, then list the amount that is over the C2 budget as ineligible.\u00a0 Then allocate the remaining eligible amount to the schools sharing the equipment, according to your cost allocation calculations (or an equal allocation). \u00a0Do <strong>not<\/strong> include the impacted \u201cno C2 budget\u201d schools as Recipients of Service.<\/p>\n<table border=\"1\" width=\"846\" bgcolor=\"e5ecf5\">\n<tbody>\n<tr>\n<td width=\"133\"><\/td>\n<td width=\"95\"><strong>Enrollment<\/strong><\/td>\n<td width=\"96\"><strong>% Enrollment<\/strong><\/td>\n<td width=\"144\"><strong>% Enrollment x Cost of Shared Component<\/strong><\/td>\n<td width=\"114\"><strong>Remaining C2<\/strong><strong>Budget<\/strong><\/td>\n<td width=\"126\"><strong>Eligible Amount<\/strong><\/td>\n<td width=\"138\"><strong>Ineligible Amount<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"133\"><strong>Plainfield Elem<\/strong><\/td>\n<td width=\"95\">225<\/td>\n<td width=\"96\">0.21<\/td>\n<td width=\"144\">$6,355.93<\/td>\n<td width=\"114\">$6,000<\/td>\n<td width=\"126\">$6,000<\/td>\n<td width=\"138\">$355.93<\/td>\n<\/tr>\n<tr>\n<td width=\"133\"><strong>Jacksonville MS<\/strong><\/td>\n<td width=\"95\">256<\/td>\n<td width=\"96\">0.24<\/td>\n<td width=\"144\">$7,231.64<\/td>\n<td width=\"114\">$8,789<\/td>\n<td width=\"126\">$7,231.64<\/td>\n<td width=\"138\"><\/td>\n<\/tr>\n<tr>\n<td width=\"133\"><strong>Franklin HS<\/strong><\/td>\n<td width=\"95\">581<\/td>\n<td width=\"96\">0.55<\/td>\n<td width=\"144\">$16,412.43<\/td>\n<td width=\"114\">$18,250<\/td>\n<td width=\"126\">$16,412.43<\/td>\n<td width=\"138\"><\/td>\n<\/tr>\n<tr>\n<td width=\"133\"><\/td>\n<td width=\"95\"><strong>1062<\/strong><\/td>\n<td width=\"96\"><strong>\u00a0<\/strong><\/td>\n<td width=\"144\"><strong>$30,000.00 <\/strong><\/td>\n<td width=\"114\"><strong>\u00a0<\/strong><\/td>\n<td width=\"126\"><strong>$29,644.07<\/strong><\/td>\n<td width=\"138\"><strong>$355.93<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>In this example, if a district\u2019s discount is 50%, E-rate will pay $14,822.04 (50% of $29,644.07) and the District will be responsible for the other 50%, plus 100% of the ineligible amount ($14,822.04 + $355.93 = $15,177.97).\u00a0 Plainfield Elem would be included as a Recipient of Service because they have some C2 funding remaining.<\/p>\n<p>If you have any questions about cost allocations for shared equipment, please let me know!<\/p>\n<p>&#8212; Julie<\/p>\n<p>Julie Tritt Schell<\/p>\n<p>PA E-rate Coordinator<\/p>\n<p>717-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\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>March 13, 2019<\/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-30061","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\/30061","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=30061"}],"version-history":[{"count":0,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts\/30061\/revisions"}],"wp:attachment":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=30061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=30061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=30061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}