FY 2018 Funding Formula Booklet 2_21_18

MCCB paying AT&T Costs.

MISSISSIPPI PUBLIC COMMUNITY AND JUNIOR COLLEGS FY 2018 Estimated EDUCATION TECHNOLOGY COSTS

ALL Colleges utilizing AT&T services, except MGCCC

Total $7,099,160 General Fund S.B. 2964

10 GB

C-Spire Ethernet Circuits

ITS

New AT&T Circuits for Redundancy ASE & 2-1GB Ethernet

LMS Canvas*

OTHER RECURRING

INDIVIDUAL

**Estimated**

TECHNOLOGY Wimba/Respondus

REMAINING

TOTAL CJC GF ED.TECHNOLOGY

DATA AND VIDEO DATA AND VIDEO

Internet/

POSITIONS

REMAINING 1/2 BASED ON

JULY

JANUARY

TOTAL

Full time

LINE CHARGES

LINE CHARGES

Related Technology & MSVCC Expenses

& CSpire Internet

DISTRICT COAHOMA

10 GB

10 GB

Backbone COSTS

1/2 EVENLY ENROLLMENT

COSTS FY 2018

DISBURSEMENT DISBURSEMENT DISBURSEMENTS Equivalent FTE

11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 11,988.00 323,757.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

58,908.00 58,908.00 58,908.00 58,908.00 58,920.00 58,920.00 58,920.00 58,908.00 58,908.00 58,908.00 58,920.00 58,908.00 58,920.00 58,908.00 58,908.00

100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000

41,450.00 41,450.00 41,450.00 41,450.00 41,449.00 41,450.00 41,449.00 41,450.00 41,450.00 41,450.00 41,449.00 41,450.00 41,449.00 41,450.00 41,450.00

16,889.00 26,349.00 22,078.00 36,117.00 97,207.00 51,408.00 47,764.00 45,466.00 28,886.00 21,872.00 79,354.00 29,708.00 63,387.00 38,349.00 16,912.00

217,247.00 226,707.00 222,436.00 236,475.00 297,576.00 251,778.00 248,133.00 245,824.00 229,244.00 222,230.00 291,711.00 230,066.00 263,756.00 238,707.00 217,270.00 3,460,000.00 7,099,160.00 7,099,160.00 0.00

108,293.00 113,374.00 111,504.00 118,403.00 149,351.00 125,454.00 124,375.00 123,009.00 114,492.00 111,107.00 146,010.00 114,957.00 131,611.00 118,980.00 108,660.00

108,954.00 113,333.00 110,932.00 118,072.00 148,225.00 126,324.00 123,758.00 122,815.00 114,752.00 111,123.00 145,701.00 115,109.00 132,145.00 119,727.00 108,610.00 1,730,000.00 3,549,580.00 3,549,580.00

217,247.00 226,707.00 222,436.00 236,475.00 297,576.00 251,778.00 248,133.00 245,824.00 229,244.00 222,230.00 291,711.00 230,066.00 263,756.00 238,707.00 217,270.00 3,460,000.00 7,099,160.00 7,099,160.00 0.0000000

1,557.5 2,429.9 2,036.0 3,330.7 8,964.3 4,740.9 4,404.7 4,192.8 2,663.8 2,017.0 7,317.9 2,739.7 5,845.4 3,536.5 1,559.6

COPIAH-LINCOLN EAST CENTRAL EAST MISSISSIPPI

HINDS

HOLMES ITAWAMBA MERIDIAN MISS. DELTA JONES

MISS. GULF COAST NORTHEAST MISS NORTHWEST MISS

11,988.00

PEARL RIVER

SOUTHWEST MISS

MCCB

491,589.00

540,000

-

0.00

MCCB - Learning Mgt System

0.00

0.00

0

0

2,428,411

0.00

0.00

3460000 1,730,000.00

0

TOTAL

503,577.00

503,577.00

540,000.00

0.00

883,680.00

1,500,000.00

2,428,411.00 621,746.00 2,428,411 7,099,160.00

621,746.00

0 3,549,580.00

57,336.6

179820

$10.84

3,549,580.00

57337

463916 -39661

540,000

883,680

5,855,668.00

621,746.00 621,746.00

0.00

0.00

0.00

0.00

0

-

41,450 1,243,492.00

41,450.00

The estimates for line charges/circuits are based upon costs provided AT&T in December of 2015 for 15 colleges and the MCCB. The former AT&T prices included the enhanced features of Priority Plus Q-Forwarding and Metro Ethernet Reporting for 100 MB Fixed ME pricing per site. The cost for 100 MB metro ethernet AT&T connections to the college campuses varied from $970 per month to $1,631 per month for a total of $352,469. The new pricing estimates from AT&T are at the speed of 1 GB at the cost of $899.00 per month or $10,788 per college. The $323,752 calculation for the MCCB consists of $167,832 for the cost of 14 colleges' circuits at $899 + $100 per month or $11,998 per college per year. MGCCC will pay for their circuit directly. Two MCCB circuits (($16,439 +3005) X 12 = $269,328 and ($5,288 X 12 = $63,456), and 15% of community and junior college line charges ($179,820 x 15% = $26,973) for any additional charges.

ITS Backbone Costs - Speed 10,000,000,000 GB x $5.40 per MB = $540,000

621746

ITS/AT&T

Current 2 Gbps

Proposed 10 Gbps

5376 32463 37839 12 454062

41,449.73

Internet Access

$ $ $

8,000.00 3,000.00 11,000.00

$ $ $

40,000.00 5,000.00 45,000.00

35207

WAN Port

Total Backbone

12

$

540,000.00

Cspire Ethernet Connection = 1 GB Ethernet:

Each Monthly Monthly x 15 colleges

Increase

Annual Amount

5 Year MRC

$ $ $ $ $ $ $ $ $ $ $

2,350.00 157.00 267.00 2,774.00

$ $ $ $ $ $ $

35,250.00 2,350.00 4,000.00 41,600.00 5,818.05 4,000.05 9,818.10

Venture Data Center (2) 10 GB Ports MCCB 2 -1GB (<5ms) Cspire

$

499,200.00

2 Gig DIA

387.87 266.67 654.54

Rate Increase 1GB Ethernet (2) Total Monthly Rate Increase Proposed Upgrade to CSPIRE: 5 Year MRC

$

117,817.20

$

617,017.20

3,428.54

3,428.54 1,481.73 4,910.27

$ $ $

51,428.10 22,225.95 73,654.05

Proposed 10 Gig DIA

Total Proposed

$

266,662.80 22,221.90

$

883,680.00

$ The colleges will need hardware (switches and Firewall) in the total amount of $506,706.08.

At the September meeting of the Mississippi Community Connectivity Consortium (MC4), there was a proposal made to upgrade the MC4 Network, which provides Internet for the community colleges. This proposal was made because of the increase in Internet bandwidth utilization at all of the colleges. On October 27, 2015, the proposed network upgrade was approved by the MACJC. The proposal included: Cspire Side - (1) Upgrade the 2 GBps Cspire Dedicated Internet Access (DIA) to a 10 Gig DIA and (2) Upgrade the two 1 Gig Cspire circuits between the Venture Data Center and MCCB to 4 GBps. The total cost per year is $883,680.00 for the cost of 15 colleges at $4,910.27 per month or $73,654.05 per college per year. AT&T Side - (1) Upgrade the shared MetroE circuits to a full 1 Gig ASE circuit for each college and (2) Upgrade the 2 Gig DIA to a 10 Gig DIA.

FY 2018

* MCCB Education Technology Budgeted Expenses:

Major Objects

Technology

MSVCC

TOTAL

354,314

100,000 1,565,115 200,000

454,314 1,565,115 200,000 540,000 503,577 196,994

TechnologyPositions

0 0

Contractual Services - Learning Management System

- Wimba & Respondus 3.5

540,000 503,577 196,994

- Internet Access (3GB to 4GB)

-Data &VideoLine Charges (double capacity from 50 MB to 100 MB)

Other MCCBEd. Tech Expenses

0 0

0 0

RedundancyProject

Circuit/Switches Upgrades/Other Total Education Technology Needs

3460000 ADMIN BILL

1,594,885

1,865,115

3,460,000

18ftefundingformula_final_8_11_174:14 PM2/20/2018

37