lincoln.ne.gov

City of Lincoln Systems Development Case Study - continued

PERSONNEL

Project Manager: The Project Manager will oversee all administrative aspects of the grant. Responsibilities include creating project work plans, establishing schedules, budgets, coordinating staff in three sections, training advisor, consultant selection and administration, status reporting, and post implementation monitoring. The Project Manager will be the public liaison with the community centers, rural elected officials, and corporate project partners. The Project Manger will work 100% for the first 6 months and 50% for the remaining 12 months. Based on an annual salary of $ 55,000, the cost to the project will be $ 55,000.

Systems Analyst: The systems analyst will identify, document, and administer all activity on the Web file server. Coordinate all content modification and insure quality assurance standards are enforced. Establish seamless data exchange from the file server and the IBM mainframe. Assist the Project Manager in the collection, documentation and dissemination of statistics and project reporting requirements. The Systems Analyst will work 100% for the first 12 months and 50% for the remaining 6 months. Based on an annual salary of $30,000, the cost to the project will be $ 45,000.

Network Specialist: The network specialist will coordinate and work closely with the project manager in the acquisition, design, testing, and implementation of the network and related hardware. First line contact with Internet Service Provider. Coordinate site preparation in all 38 public access locations. Full network management responsibilities and administration activities including assisting the project manager with the collection and analysis of statistical measurements for project status reporting. The Network Specialist will work 100% for the first 3 months and 20% for the remaining 15 months. Based on the annual salary of $ 40,000, the cost to the project will be $ 20,000.

Customer Training Specialist: The customer training specialist will assist the project manager in the selection and development of appropriate curriculum and material for the navigator certification course. Conduct training sessions for InterLinc navigators, and provide on site training and assistance in both local and rural settings. The Customer Training Specialist will work 25% for the first 3 months and 5% for the remaining 15 months. Based on the annual salary of $ 35,000, the cost to the project will be $ 4,375.

Info Center Support Specialist: Info center support specialist is responsible for all non network related hardware and software. First line contact for public access sites for both local and rural settings. Ongoing support for upgrade of software releases, hardware expansion and inventory management for Project InterLinc. Will coordinate the installation of public access sites with the Network Specialist and Project Manager. Will supply the project manager with current statistics on network configuration, hardware and software support activity. The Info Center Support Specialist will work 100% for the first 3 months and 20% for the remaining 15 months. Based on the annual salary of $ 35,000, the cost to the project will be $ 17,500.

Customer Services Specialist: The customer service specialist will field all incidents via the telephone hot line, log, track, contact response staff, and monitor until problem resolution. Coordinate and inform customer on status of reported problem. Provide detail and aggregate statistics to Project Manager for support status reporting. The Customer Services Specialist will work 6.67% for 18 months. Based on the annual salary of $ 29,000, the cost to the project will be $2,900.

Total Project Personnel Cost: $ 144,775

FRINGE BENEFITS

Fringe benefits were calculated by specific job title and actual percentages. Benefits include FICA, life, health, dental, pension, and longevity.

Project Manager                  31%  of  $ 55,000       $ 17,050
Systems Analyst                  27%  of  $ 45,000       $ 12,150
Network Specialist               19%  of  $ 20,000       $  3,800
Customer Training Specialist     37%  of  $  4,375       $  1,620
Info Center Support Specialist   36%  of  $ 17,500       $  6,300
Customer Services Specialist     39%  of  $  2,900       $  1,130

Total Project Fringe Benefits $ 42,050

TRAVEL

Project Manager. The project manager will have scheduled site visits to the 12 rural access points 1 time every 3 months for a total of 72 trips. Based on the average of 30 miles round-trip driving at the standard rate of $0.32 per mile the cost is $690. Scheduled site visits to 18 urban locations 1 time every 3 months for a total of 108 trips. Based on average of 15 miles round-trip driving at $0.32 per mile the cost is $518. Total cost for Project Manager $ 1,210.

Network Specialist. The Network Specialist will have implementation site visits to the 12 rural access points approximately 4 times initially and 1 time every 3 months for a total of 75 trips. Based on the average of 30 miles round-trip driving at $0.32 per mile the cost is $ 720. Site visits to 18 urban locations approximately 4 times initially and 1 time every 3 months for a total of 111 trips. Based on average of 15 miles round-trip driving at $0.32 per mile the cost is $532. Total cost for Network Specialist $ 1,252.

Customer Training Specialist. The Customer Training Specialist will have 2 training visits to the 12 rural access points for a total of 24 trips. 30 miles @ $0.32 cost is $ 230. Two site visits to 18 urban access points for a total of 36 trips. 10 miles @ $0.32 cost is $ 115. Total cost for Customer Training Specialist $ 345.

Info Center Support Specialist: The Info Center Support Specialist will install all the non network software and hardware at each location. Site visits to the 12 rural access points 1 time every 2 months for a total of 108 trips. 30 miles @ $0.32 cost is $ 1,037. Two site visits every 2 months to 18 urban access points for a total 162 trips. 10 miles @ $0.32 cost is $518. Total cost for Info Center Support Specialist $ 1,555

Total Project Travel Costs: $ 4,362

EQUIPMENT

Personal Computers. IBM 486DX2 66MHz 420 hard drive, 8MB memory, 14" super VGA color monitor, 1MB Video memory, Double-speed CD-ROM, 16-bit stereo sound card and speakers, internal fax, Lexmark color inkjet printer. (or equivalent conf.) Unit cost $ 2,200.

Network Server. IBM RS/6000 POWERserver utilizing the IBM Power RISC processor. 64 Meg RAM, 2 Gigabyte Hard Disk, UNIX: AIX 3.2.5. Unit cost $19,500.

Network Routers. Network routers will be located at Data Processing and at each of the public access sites. Cisco 2500 series router with 12 port Cableltron ethernet hub. (or equivalent conf.) Unit cost $2,500.

DSU. Each site will be equipped via a 56k DDS frame relay circuit. UDS DDS/MR1 standalone DSU unit. Unit cost $ 500.

Item                Quantity      Unit Price        Total 

Personal Computers        38           2,200       83,600 (Exhibit 2a,2b,2c)
Network Server             1          19,500       19,500
Network Routers           30           2,500       75,000
DSU                       30             500       15,000

Total Project Equipment Cost:                    $193,100

SUPPLIES

Printer Paper. Each access site will need approximately 4 reams of paper per month. 38 sites for 18 months or 2736 reams. @ $2.50 per ream the total cost is $ 6,840.

Printer Cartridges. Each access site will need approximately one pair of color and black/white printer cartridges every two months. 38 sites for 18 months or 342 pairs. @ $ 15.00 per pair the total cost is $ 5,130.

Total Project Supplies Cost: $ 11,970

CONTRACTUAL

Quality Assurance Audit. An outside expert in Internet Web, community access projects will be chosen to review Project InterLinc. They will administer a community survey, analyze the data, and publish a findings report. In addition, all standards and procedures will be reviewed, analyzed, and documented for any improvements or modifications. It is estimated that the audit will take 15 days @ $400 per day. Total cost will be $ 6,000. ($50 per hour)

Web Training and Content Consultant. Information Analytics Inc. will be contracted for consulting work in content development strategies, graphics advise, and training for the Data Processing Staff. It is estimated that a 300 hour one year contract would be reasonable. Total contract cost to the project is $ 15,000. ($50 per hour)

Total Contractual Cost to the project: $ 21,000

OTHER

Software for the Network Server. NetScape Communications Corporation. NetSite Communications Serve 1.0 Unit price $ 1,495. Support $ 995/yr. for a total cost to the project of $ 2,988.

Web Browser for the Access Points. Each of the 38 access sites will need a Web browser. NetScape Navigator 1.1 has been chosen by InterLinc. Unit price $ 21.00 for a total cost to the project of $ 798.

Leased 10MBS Circuit. The Lincoln Telephone Company will provide our Internet access via a Transparent Lan Interconnection Service. (TLIS) One 10Mbs TLIS Interface and Internet Access @ $ 2138 per month for 18 months for a total cost to the project of $ 38,484.

Frame Relay Access. Each of the 30 access locations will have 56k frame relay service. Detail site breakdowns will be provide. Deeply discounted rates and an in-kind contribution from the Lincoln Telephone Company for the first 18 months of Project InterLinc will reduce the total cost to the project from $ 89,124 to $ 44,562.

Total Other Costs: $ 131,394

STATEMENT OF MATCHING AND OPERATING FUNDS

The City of Lincoln and Lancaster County seeks a 40% match from the TIIAP. The City and County contributions will be considered cash. The Lincoln Telephone Company, as an in-kind contribution has reduced all frame relay circuit charges by 50% for the first 18 months of a 3 year lease with the City of Lincoln and Lancaster County. Information Analytics Inc. as an in-kind contribution has discount all billable rates by 20% for services rendered with Project InterLinc.

Cash Contributions from the City of Lincoln and Lancaster County.

$   86,865   Personnel
$   25,230   Fringe Benefits
$    2,617   Travel
$  131,295   Equipment
$    7,182   Supplies
$   10,800   Contractual
$   52,100   Other

In-Kind Contribution from The Lincoln Telephone Company

Reduced 56k frame relay circuit charges by 50% for 18 months on a 3 year lease agreement. This service is valued at $ 44,562.

In-Kind Contribution from Information Analytics Inc.

Reduced billable rates by 20% for the duration of Project InterLinc. This discounted service is valued at $ 3,000.

NTIA Request

The City of Lincoln and Lancaster County request that NTIA provide grant funds to cover the following costs:

$   57,910    Personnel
$   16,820    Fringe Benefits
$    1,745    Travel
$   61,805    Equipment
$    4,788    Supplies
$    7,200    Contractual
$   34,732    Other

Total NTIA Request:     $ 185,000

Systems Development