Draft GPN Budget March 16, 1998 ----------------------------------------------------------------------------------------------------------------------- Startup Expenses Income SubTotals Expenses Not Covered by Grant $430,000.00 Covered by Grant $37,700.00 Total Expenses $467,700.00 Income State North Dakota $71,666.67 South Dakota $71,666.67 Nebraska $71,666.67 Kansas $71,666.67 Oklahoma $71,666.67 Arkansas $71,666.67 Grant $37,700.00 Total Income $467,700.00 ----------------------------------------------------------------------------------------------------------------------- Grant Period Post Grant Period Monthly Recurring Expenses Expenses Income SubTotals Expenses Income SubTotals Infrastructure (I) Membership $22,041.67 $22,041.67 Network $18,250.00 $40,291.67 $18,250.00 $40,291.67 Circuits (C) $78,094.86 $78,094.86 Internet 1 (I1) $42,000.00 $42,000.00 Internet 2 (I2) $90,000.00 $90,000.00 $90,000.00 Agency Networks (A) $0.00 $0.00 $0.00 Subtotals (I+C) $118,386.53 $118,386.53 (I+C+I1) $160,386.53 $160,386.53 (I+C+I1+I2) $250,386.53 $250,386.53 (I+C+I1+I2+A) $250,386.53 $250,386.53 ----------------------------------------------------------------------------------------------------------------------- Grant Period Post Grant Period Monthly Recurring Income Expenses Income SubTotals Expenses Income SubTotals North Dakota Infrastructure $5,965.28 $6,715.28 Circuits $0.00 $5,965.28 $13,015.81 $19,731.09 Internet1 $8,400.00 $14,365.28 $8,400.00 $28,131.09 Internet2 $16,363.64 $30,728.91 $16,363.64 $44,494.72 Agency $0.00 $30,728.91 $0.00 $44,494.72 South Dakota Infrastructure $5,965.28 $6,715.28 Circuits $0.00 $5,965.28 $13,015.81 $19,731.09 Internet1 $4,200.00 $10,165.28 $4,200.00 $23,931.09 Internet2 $24,545.45 $34,710.73 $24,545.45 $48,476.54 Agency $0.00 $34,710.73 $0.00 $48,476.54 Nebraska Infrastructure $5,965.28 $6,715.28 Circuits $0.00 $5,965.28 $13,015.81 $19,731.09 Internet1 $8,400.00 $14,365.28 $8,400.00 $28,131.09 Internet2 $8,181.82 $22,547.10 $8,181.82 $36,312.91 Agency $0.00 $22,547.10 $0.00 $36,312.91 Kansas Infrastructure $5,965.28 $6,715.28 Circuits $0.00 $5,965.28 $13,015.81 $19,731.09 Internet1 $12,600.00 $18,565.28 $12,600.00 $32,331.09 Internet2 $16,363.64 $34,928.91 $16,363.64 $48,694.72 Agency $0.00 $34,928.91 $0.00 $48,694.72 Oklahoma $35,665.75 Infrastructure $5,965.28 $6,715.28 Circuits $0.00 $5,965.28 $13,015.81 $19,731.09 Internet1 $0.00 $5,965.28 $0.00 $19,731.09 Internet2 $16,363.64 $22,328.91 $16,363.64 $36,094.72 Agency $0.00 $22,328.91 $0.00 $36,094.72 Arkansas Infrastructure $5,965.28 $6,715.28 Circuits $0.00 $5,965.28 $13,015.81 $19,731.09 Internet1 $8,400.00 $14,365.28 $8,400.00 $28,131.09 Internet2 $8,181.82 $22,547.10 $8,181.82 $36,312.91 Agency $0.00 $22,547.10 $0.00 $36,312.91 Grant Money Infrastructure $4,500.00 $0.00 Circuits $78,094.86 $82,594.86 $0.00 $0.00 Subtotals (I+C) $118,386.53 $118,386.53 (I+C+I1) $160,386.53 $160,386.53 (I+C+I1+I2) $250,386.53 $250,386.53 (I+C+I1+I2+A) $250,386.53 $250,386.53 ----------------------------------------------------------------------------------------------------------------------- Grant Period Post Grant Period Expenses Income SubTotals Expenses Income SubTotals Infrastructure - Details Expenses Membership Salaries Director $6,250.00 $6,250.00 Engineer $5,416.67 $11,666.67 $5,416.67 $11,666.67 Fringe $3,500.00 $3,500.00 Travel $2,000.00 $2,000.00 Office $2,000.00 $19,166.67 $2,000.00 $19,166.67 Indirect Cos 0.15 $2,875.00 $2,875.00 Total $22,041.67 $22,041.67 Network Maintenance $10,750.00 $10,750.00 NOC Services $2,000.00 $2,000.00 Collocation Costs KC $4,500.00 $4,500.00 EROS $0.00 $4,500.00 $0.00 Miscellaneous Equip $1,000.00 $1,000.00 Total $18,250.00 $18,250.00 Total Expenses $40,291.67 $40,291.67 Income State Income North Dakota $5,965.28 $6,715.28 South Dakota $5,965.28 $6,715.28 Nebraska $5,965.28 $6,715.28 Kansas $5,965.28 $6,715.28 Oklahoma $5,965.28 $6,715.28 Arkansas $5,965.28 $6,715.28 Subtotal $35,791.67 $40,291.67 Grant Income Membership $0.00 $0.00 Network $4,500.00 $4,500.00 $0.00 $0.00 Total Income $40,291.67 $40,291.67 - - - - - - - - - - - - - - - - - - - - - - - - Notes: 1. Infrastructure costs are broken into membership and network categories for the purpose of calculating the administrative fee 2. The administrative fee is overhead for administration of salaries, benefits, and other miscellaneous costs. 3. The infrastructure costs are dependent on the EPSCoR grant. Collocation costs are paid by the grant for its duration. 4. Basic principle: Infrastructure costs are divided equally among the states. Per State Income 6 Membership $3,673.61 $3,673.61 Network $2,291.67 $3,041.67 Total $5,965.28 $6,715.28 ----------------------------------------------------------------------------------------------------------------------- Grant Period Post Grant Period Expenses Income SubTotals Expenses Income SubTotals Circuits - Details Expenses ND to EROS $19,893.00 $19,893.00 SD to EROS $4,174.86 $4,174.86 KC to EROS $15,870.00 $15,870.00 NE to KC $9,378.00 $9,378.00 KS to KC $5,701.00 $5,701.00 OK to KC $11,674.00 $11,674.00 AR to KC $11,404.00 $11,404.00 Total Expenses $78,094.86 $78,094.86 Income State Income North Dakota $0.00 $13,015.81 South Dakota $0.00 $13,015.81 Nebraska $0.00 $13,015.81 Kansas $0.00 $13,015.81 Oklahoma $0.00 $13,015.81 Arkansas $0.00 $13,015.81 Total $0.00 $78,094.86 Grant Income Circuits $78,094.86 $0.00 Total Income $78,094.86 $78,094.86 - - - - - - - - - - - - - - - - - - - - - - - - Notes: 1. Missouri circuit costs are included for information only. All totals exclude these costs. 2. The Total Base circuit cost is the cost of the circuit between KC and EROS, whether it be a DS-3 or an OC-3, plus the sum the costs of the other circuits at DS-3 speeds 3. The Average Base cost is the Total Base cost divided by the number of states. This cost is shared equally between the states. 4. The Upgrade cost of any circuit to OC-3, other than the KC to EROS circuit, is the difference between the OC-3 and DS-3 costs for that particular circuit. The upgrade cost for the KC to EROS circuit is part of the Base cost and is therefore zero. 5. Basic principle: The costs for circuits are shared for DS-3 speeds, with states paying the costs to upgrade to OC-3. The circuit between KC and EROS is part of the base cost and is shared between all states. Calculated State Costs Base Upgrade North Dakota $13,015.81 $48,170.00 South Dakota $13,015.81 $0.00 Nebraska $13,015.81 $22,277.00 Kansas $13,015.81 $14,401.00 Oklahoma $13,015.81 $24,450.00 Arkansas $13,015.81 $23,908.00 Missouri Total $78,094.86 $133,206.00 Upgrade Income Actual Circuit Costs DS-3 OC-3 DS-3/OC MRC NRC MRC NRC ND to EROS 0 $19,893.00 $4,200.00 $68,063.00 $14,000.00 SD to EROS 0 $4,174.86 $3,000.00 $12,000.00 $12,000.00 KC to EROS 0 $15,870.00 $3,100.00 $51,130.00 $10,000.00 NE to KC 0 $9,378.00 $3,100.00 $31,655.00 $10,000.00 KS to KC 0 $5,701.00 $3,100.00 $20,102.00 $10,000.00 OK to KC 0 $11,674.00 $3,100.00 $36,124.00 $10,000.00 AR to KC 0 $11,404.00 $3,100.00 $35,312.00 $10,000.00 MO to KC 0 $6,941.00 $3,100.00 $25,111.00 $10,000.00 Total $78,094.86 $22,700.00 $254,386.00 $76,000.00 Average/Stat 6 $13,015.81 $3,783.33 $42,397.67 $12,666.67 Base $78,094.86 Base Average $13,015.81 ----------------------------------------------------------------------------------------------------------------------- Grant Period Post Grant Period Expenses Income SubTotals Expenses Income SubTotals Internet 1 - Details Expenses KC Connection $42,000.00 $42,000.00 EROS Connection $0.00 $0.00 Total Expenses $42,000.00 $42,000.00 Average per T1 $1,400.00 $1,400.00 Income T1's North Dakota 6 $8,400.00 $8,400.00 South Dakota 3 $4,200.00 $4,200.00 Nebraska 6 $8,400.00 $8,400.00 Kansas 9 $12,600.00 $12,600.00 Oklahoma 0 $0.00 $0.00 Arkansas 6 $8,400.00 $8,400.00 Total Income 30 $42,000.00 $42,000.00 - - - - - - - - - - - - - - - - - - - - - - - - Notes: 1. Costs to states are allocated on a T1 basis. Each state contracts for the equivalent of a number of T1's worth of connectivity 2. Basic Principle: The costs for Internet1 service are paid by those contracting for this service and are based on bandwidth. ----------------------------------------------------------------------------------------------------------------------- Grant Period Post Grant Period Expenses Income SubTotals Expenses Income SubTotals Internet 2 - Details Expenses KC Connection $90,000.00 $90,000.00 EROS Connection $0.00 $0.00 Total Expenses $90,000.00 $90,000.00 Average per member $8,181.82 $8,181.82 Income Members North Dakota 2 $16,363.64 $16,363.64 South Dakota 3 $24,545.45 $24,545.45 Nebraska 1 $8,181.82 $8,181.82 Kansas 2 $16,363.64 $16,363.64 Oklahoma 2 $16,363.64 $16,363.64 Arkansas 1 $8,181.82 $8,181.82 Missouri Total Income 11 $90,000.00 $90,000.00 - - - - - - - - - - - - - - - - - - - - - - - - Notes: 1. Basic Principle: The costs for Internet2 service are paid by the participating Internet2 connected schools. ----------------------------------------------------------------------------------------------------------------------- Grant Period Post Grant Period Expenses Income SubTotals Expenses Income SubTotals Agency Networks - Details Expenses KC Connection $0.00 $0.00 EROS Connection $0.00 $0.00 Total Expenses $0.00 $0.00 Average per connection $0.00 $0.00 Income Agency North Dakota 0 $0.00 $0.00 South Dakota 0 $0.00 $0.00 Nebraska 0 $0.00 $0.00 Kansas 0 $0.00 $0.00 Oklahoma 0 $0.00 $0.00 Arkansas 0 $0.00 $0.00 Total Income 0 $0.00 $0.00 Notes: 1. Basic Principle: The costs for any agency network connection are paid by those having rights to such connections. ----------------------------------------------------------------------------------------------------------------------- Startup - Details Expenses Not Covered by Grant Miscellaneous $15,000.00 Routers 3 $225,000.00 Switches 7 $175,000.00 Computers 1 $15,000.00 Total $430,000.00 Average per State $71,666.67 Covered by Grant Circuit Installation ND to EROS $4,200.00 SD to EROS $3,000.00 KC to EROS $3,100.00 NE to KC $3,100.00 KS to KC $3,100.00 OK to KC $3,100.00 AR to KC $3,100.00 $22,700.00 Collocation KC $15,000.00 EROS $0.00 $15,000.00 Total $37,700.00 Total Expenses $467,700.00 Income State North Dakota $71,666.67 South Dakota $71,666.67 Nebraska $71,666.67 Kansas $71,666.67 Oklahoma $71,666.67 Arkansas $71,666.67 Total $430,000.00 Grant $37,700.00 Total Income $467,700.00 Notes: 1. Basic Principle: Startup costs are shared equally on a state by state basis. ----------------------------------------------------------------------------------------------------------------------- Miscellaneous Information Number States 6 EPSCoR/NSF Grant Inform Total Average/State Grant Total $1,361,160.00 $226,860.00 Startup costs - cir $22,700.00 $3,783.33 Startup costs - col $15,000.00 $2,500.00 Remainder $1,323,460.00 $220,576.67 Monthly Costs Circuits $78,094.86 $13,015.81 Collocation $4,500.00 $750.00 Grant Length in months 16.02 -----------------------------------------------------------------------------------------------------------------------