|
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 |