MAIN Wireless Project

 

 

 

 

 

 

 

 

 

 

 

5 Year Budget

Q 1

Q 2

Q 3

Q 4

Q 5

Q 6

Year 1

Year 2

Year 3

Year 4

Year 5

Income

User Fees (sch A)

1,500

10,522

19,667

24,752

48,126

48,126

56,441

192,504

250,104

307,704

365,304

Grants

350,000

80,000

75,000

75,000

27,500

27,500

580,000

55,000

-

-

-

CPE Installation Fees

2,500

3,500

6,500

6,000

4,500

4,500

18,500

18,000

12,000

12,000

12,000

Total Income

354,000

94,022

101,167

105,752

66,376

66,376

654,941

265,504

262,104

319,704

377,304

Expense

Salaries

20,000

20,000

27,500

27,500

28,500

28,500

95,000

114,000

119,700

125,685

131,969

Payroll Tax Expense

1,700

1,700

2,338

2,338

2,423

2,423

8,076

9,690

10,175

10,683

11,217

Health Insurance

1,490

1,490

2,049

2,049

2,123

2,123

7,078

8,493

8,918

9,364

9,832

Retirement Plan

1,800

1,800

2,700

2,700

2,835

2,835

9,000

11,340

11,907

12,502

13,127

Insurance

1,500

1,500

1,500

1,500

1,575

1,575

6,000

6,300

6,615

6,946

7,293

Marketing

1,000

1,000

1,000

1,000

1,000

1,000

4,000

4,000

4,000

4,000

4,000

Equipment Rental

-

100

100

100

25

25

300

100

100

100

100

Telephone-Cell/Pager

250

250

250

250

250

250

1,000

1,000

1,000

1,000

1,000

Travel

300

300

300

300

625

625

1,200

2,500

2,500

2,500

2,500

Training

5,000

3,000

 

3,000

1,250

1,250

11,000

5,000

5,000

5,000

5,000

Other Expenses

250

250

250

250

125

125

1,000

500

500

500

500

Total Non-network Expense

33,290

31,390

37,986

40,986

40,731

40,731

143,652

162,923

170,414

178,280

186,539

Network Expense

Connectivity (sch B)

-

3,800

5,700

9,500

15,750

15,750

19,000

63,000

52,000

66,000

80,000

Contract labor

60,000

15,000

2,000

2,000

500

500

79,000

2,000

2,000

2,000

2,000

Equipment (sch C)

254,015

32,850

50,000

50,000

5,000

5,000

386,865

20,000

30,000

60,000

60,000

Maintenance Contract

3,750

3,750

3,750

3,750

3,750

3,750

15,000

15,000

15,000

15,000

15,000

Total Network Expense

317,765

55,400

61,450

65,250

25,000

25,000

499,865

100,000

99,000

143,000

157,000

 

 

 

 

 

 

 

 

 

 

 

 

Total Expenses

351,055

86,790

99,436

106,236

65,731

65,731

643,517

262,923

269,414

321,280

343,539

Net Income

2,945

7,232

1,731

-484

645

645

11,424

2,581

-7,310

-1,576

33,765