{"id":19871,"date":"2017-05-03T02:41:11","date_gmt":"2017-05-03T02:41:11","guid":{"rendered":"http:\/\/e-ratepaorg.local\/?p=19871"},"modified":"2017-05-08T02:59:25","modified_gmt":"2017-05-08T02:59:25","slug":"wisely-allocate-c2-budgets-for-shared-equipment","status":"publish","type":"post","link":"https:\/\/e-ratepa.org\/?p=19871","title":{"rendered":"Wisely Allocate C2 Budgets for Shared Equipment"},"content":{"rendered":"<p>May 3, 2017<\/p>\n<p>If a piece of Category 2 equipment is shared by two or more schools, the cost of the equipment must be allocated from the C2 budgets of the schools sharing the equipment (core switches and wireless controllers are good examples of shared equipment).\u00a0 After you enter the costs in the FRN Line Item and identify the schools sharing 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 $25,000 and there are 4 schools sharing the equipment, the system will take $6250 from each school&#8217;s C2 budget.\u00a0 This is not 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>I recommend that you 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>For equipment that\u2019s being shared among multiple schools, you likely want to select \u201cNo\u201d to the question <em>&#8220;Are the costs shared equally among all of the entities?&#8221;<\/em> and then do a weighted allocation.\u00a0 Unlike last year, the system will not do this math for you, unfortunately.\u00a0 Thus, applicants will have to do some quick, offline-math so you know what the weighted costs will be.\u00a0 Which method of weighting is up to you!<\/p>\n<p><strong>1)<\/strong>\u00a0 <strong>By % of Enrollment<br \/>\n<\/strong>This is the weighted allocation option most commonly used by schools.<\/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<table width=\"372\" bgcolor=\"e9edf4\">\n<tbody>\n<tr>\n<td width=\"111\"><\/td>\n<td width=\"&quot;\"><strong>Enrollment<\/strong><\/td>\n<td width=\"71\"><strong>% Enrollment<\/strong><\/td>\n<td width=\"117\"><strong>% Enrollment x Cost of Shared Component<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"111\"><strong>Plainfield Elem<\/strong><\/td>\n<td width=\"73\">225<\/td>\n<td width=\"71\">0.21<\/td>\n<td width=\"117\">$6,355.93<\/td>\n<\/tr>\n<tr>\n<td width=\"111\"><strong>Jacksonville HS<\/strong><\/td>\n<td width=\"73\">256<\/td>\n<td width=\"71\">0.24<\/td>\n<td width=\"117\">$7,231.64<\/td>\n<\/tr>\n<tr>\n<td width=\"111\"><strong>Franklin HS<\/strong><\/td>\n<td width=\"73\">581<\/td>\n<td width=\"71\">0.55<\/td>\n<td width=\"117\">$16,412.43<\/td>\n<\/tr>\n<tr>\n<td width=\"111\"><\/td>\n<td width=\"73\"><strong>1062<\/strong><\/td>\n<td width=\"71\"><strong>\u00a0<\/strong><\/td>\n<td width=\"117\"><strong>$30,000.00 <\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>2)<\/strong>\u00a0 <strong>By % of Devices Connected<\/strong><\/p>\n<p>This method calculates the cost based on the # of devices in each school that are connected to the shared equipment.\u00a0 For example, if the shared equipment is a wireless controller, you could count the number of WAPs at each school and do a weighted calculation by % of total WAPs.<\/p>\n<table width=\"372\" bgcolor=\"e9edf4\">\n<tbody>\n<tr>\n<td width=\"111\"><\/td>\n<td width=\"73\"><strong># of WAPs in School<\/strong><\/td>\n<td width=\"71\"><strong>% WAPs<\/strong><\/td>\n<td width=\"117\"><strong>% WAPs x Cost of Shared Component<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"111\"><strong>Plainfield Elem<\/strong><\/td>\n<td width=\"73\">55<\/td>\n<td width=\"71\">0.23<\/td>\n<td width=\"117\">$7,021.28<\/td>\n<\/tr>\n<tr>\n<td width=\"111\"><strong>Jacksonville HS<\/strong><\/td>\n<td width=\"73\">65<\/td>\n<td width=\"71\">0.28<\/td>\n<td width=\"117\">$8,297.87<\/td>\n<\/tr>\n<tr>\n<td width=\"111\"><strong>Franklin HS<\/strong><\/td>\n<td width=\"73\">115<\/td>\n<td width=\"71\">0.49<\/td>\n<td width=\"117\">$14,700.00<\/td>\n<\/tr>\n<tr>\n<td width=\"111\"><\/td>\n<td width=\"73\"><strong>235<\/strong><\/td>\n<td width=\"71\"><strong>\u00a0\u00a0\u00a0 \u00a0<\/strong><\/td>\n<td width=\"117\"><strong>$30,000.00 <\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>3)\u00a0 Other<\/strong><\/p>\n<p>You are free to develop your own cost allocation based on a method that is defendable.<\/p>\n<p>Remember, after you answer No, to this question, the system will allow you to enter the costs manually for each school:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19911 size-full\" src=\"https:\/\/e-ratepa.org\/wp-content\/uploads\/2017\/05\/C2-budgets.jpg\" alt=\"C2-budgets\" width=\"509\" height=\"348\" srcset=\"https:\/\/e-ratepa.org\/wp-content\/uploads\/2017\/05\/C2-budgets.jpg 509w, https:\/\/e-ratepa.org\/wp-content\/uploads\/2017\/05\/C2-budgets-300x205.jpg 300w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><\/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<br \/>\nPA 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<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>May 3, 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-19871","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\/19871","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=19871"}],"version-history":[{"count":0,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts\/19871\/revisions"}],"wp:attachment":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19871"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19871"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19871"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}