HomeMy WebLinkAboutLEG 01-21 Report to
Executive Committee
Report Number: LEG 01-21
Date: January 4, 2021
From: Paul Bigioni
Director, Corporate Services & City Solicitor
Subject: Broadband Service for Whitevale and Green River - ICON Grant Funding Stage 2
-File: A-3700
Recommendation:
1.That Council approve payment by the City of $150,000.00 towards the project to deliver
broadband services to the residents and businesses of Green River and Whitevale, which
payment will be made by the City upon receipt of the written commitment of Vianet Inc. to
proceed with and complete construction of the project;
2.That staff be directed to continue working with Vianet Inc. to complete its submission of an
application for grant funding from the Province’s Improving Connectivity for Ontario (ICON)
Program by January 27, 2021; and
3.That appropriate City of Pickering officials be authorized to take the actions necessary to
implement the recommendations in this report.
Executive Summary: Pursuant to Report LEG 08-20, City staff continue to work with Vianet
Inc. (“Vianet”) to develop a proposal to extend broadband service to the residents and businesses
of Whitevale and Green River. The Stage 1 application for ICON funding was submitted in August
and has been approved by the Province. City staff continue to work with Vianet to complete the
design of the project and submit the Stage 2 ICON application, which is due by January 27, 2021.
While the bulk of the project costs would be borne by Vianet, and Provincial grant funding is being
sought, a contribution of $150,000.00 by the City is needed for the project to proceed. The project
would replace the poor and costly internet service that has been tolerated for years by the
residents of Whitevale and Green River. If funded, this project would make it faster and less
expensive to extend service directly into the Seaton Employment Lands.
Vianet has completed its design and project budget and is ready to make the Stage 2 application
for ICON funding. The City’s commitment of $150,000.00 toward the project is needed in order to
proceed with the Stage 2 application.
Financial Implications: The total project cost is $1,107,395.00. Provincial funding covers up to
25 per cent of project costs ($252,098.75), and the City’s proposed contribution is $150,000.00.
The extent of provincial funding of this project will remain unknown until the Stage 2 ICON
application is submitted and processed by the Province. Vianet will absorb the balance of the
project costs. Funding of the City’s $150,000.00 contribution will be from the IT Capital Account:
5206.1813.6250 (Municipal Broadband Projects) in 2021.
LEG 01-21 January 4, 2021
Subject: ICON Grant Funding Stage 2 Page 2
Vianet has stated that it will apply for additional funding through the recently announced Federal
Universal Broadband Fund program which identifies both Green River and Whitevale as eligible
communities. This additional funding could reduce the financial contributions of both Vianet and
the City.
Discussion: Today, high-speed Internet access is essential for all Canadians, no matter
where they live. It is necessary to telework, to access online medical advice, for distance learning
and more. It helps businesses thrive, no matter where they are located, and it ensures that rural
Pickering residents can transition smoothly to the digital economy. But there is a connectivity
gap – residents living in rural and remote areas have less access to high-speed Internet than
those living in urban areas.
That is why, now more than ever, broadband connectivity for Pickering residents is an essential
requirement and the support of Council as we work to bridge the connectivity gaps in Pickering is
greatly appreciated.
The Improving Connectivity for Ontario (ICON) Broadband program aims to support local
collaborative projects to connect more unserved and underserved homes and businesses, often in
rural, remote and northern communities. The evaluation criteria require that at least one project
partner must have a minimum of three years’ experience in building, owning, servicing and/or
operating broadband and/or cellular infrastructure in Canada. Vianet brings more than the
required experience to the table and will enable Pickering to bring services to the Hamlets of
Green River and Whitevale.
Vianet is a full-service telecommunications company that has been offering internet, telephone
and television services since 1995. It is based in Sudbury, Ontario with satellite offices in
Northern, Eastern, and Southern Ontario. Vianet offers ultra-high-speed Internet with speeds
ranging from 100Mbps to 1Gbps.
At the special Council meeting of August 10, 2020 (Report LEG 08-20), Council authorized staff to
work with Vianet Inc. to apply for provincial funding through the ICON program in order to bring
high speed fibre broadband services to the Hamlets of Green River and Whitevale. The stage 1
submission for this project was jointly written by Vianet and City staff, and was submitted to the
ICON program by Vianet on August 20th, in advance of the August 21st deadline.
On September 25th, Vianet received confirmation that its application had been accepted and had
been moved to the second stage of the ICON program.
The second stage of the application process will further evaluate the project based on:
•The ability to provide cost-effective access to households and/or businesses relative to the
total amount of ICON funding requested;
•Effectively leveraging other sources of public sector funding, if required;
•The overall project cost in relation to technologies and operational planning;
•How the project design meets community needs and accounts for unique community
characteristics; and
LEG 01-21 January 4, 2021
Subject: ICON Grant Funding Stage 2 Page 3
•Affordability to end-users in relation to nearest large urban centre.
Vianet submitted the application for the second stage of the ICON program for preliminary review
and comment on December 11, 2020. The second stage of the application includes a detailed
budget, financial forecast, logical network diagram and a technological solution overview. Detailed
information about the project design and budget is included in Attachment Nos. 1 to 5.
Vianet and City staff have until January 27, 2021 to answer questions from the Province regarding
the evaluation of the project and viability of the business case. The final stage 2 application must
be submitted by January 27, 2021. The City’s contribution must be committed to the project in
advance of the finalization of the stage 2 application.
Attachments:
1.Project Overview – Fibre Up Rural Pickering
2. Logical Network Diagram and Project Coverage Map
3.ICON Stage 2 Detailed Project Budget
4.ICON Stage 2 Financial Forecast
5.VIANET Service Offering for High Speed Internet
Prepared By: Prepared/Approved/Endorsed By:
Dale Quaife Paul Bigioni
Division Head, Information Technology Director, Corporate Services & City Solicitor
PB:ks
Recommended for the consideration
of Pickering City Council
Marisa Carpino, M.A.
Interim Chief Administrative Officer
Original Signed By:Original Signed By:
Original Signed By:
Fibre Up Rural Pickering – Technological Solution
(Excerpt from ICON Application Document)
This project will consist of approximately 12.5 km of new fibre optic network
constructed in the communities of Green River and Whitevale at the western
edge of the Town of Pickering. It will leverage Vianet’s existing dark fibre IRU
assets to connect a new outdoor telecom shelter, which will act as the project
POP site, connecting back to Vianet’s existing King City POP site at an initial
backhaul capacity of 10 Gbps.
This project will run on 100% Vianet controlled fibre optic network with no 3rd
party transport services or leased capacity up to the Internet at transit/peering
handoff points in Toronto and Barrie. This ensures simple, cost effective
capacity upgrades with the ability to cost effectively over provision backbone
bandwidth. By using of our own facilities throughout the entire project area, we
are able to set service objectives of 99.99% uptime, latency and jitter below 10
ms and packet loss below 0.01% when measured to exchange points in Toronto
or Barrie.
This project will utilize a new Zhone MXK GPON aggregation shelf located at the
newly created POP Site to provide speeds up to 1Gbps to residential and small
business users. The Zhone MXK will require 1 16 port OLT line card, with each
OLT port capable of servicing up to 64 end users by utilizing passive GPON
splitters in the field and ONUs in the home. The ONUs will provide the end user
with a minimum of four 1Gbps ethernet ports, one will be utilized to provision
internet service and the remaining ports may optionally be used to deliver
television service to IPTV set-top boxes. The ONUs also contains a minimum of
2 POTS ports to optionally provide telephone service.
At the POP Site, the Zhone MXK will uplink via two 10Gbps ports to a Cisco
ASR9000 series router. Connectivity over Vianet owned fibre from the new POP
site to both Vianet’s Barrie and Toronto POP sites, via the King City POP site,
will provide access to diverse 100 Gbps Internet transit feeds and TorIX peering,
as well as to 3rd party carrier NNIs capable of terminating both ethernet transport
services and serving as aggregation points for wholesale open access.
Enterprise, carrier and WISP customers will connect directly to the ASR9000
router on dedicated fibres for ethernet transport or dedicated Internet transit
services up to 10Gbps. Where services above 10Gbps are required, existing
dark fibre and DWDM and optical repeaters will be utilized to connect customers
directly to the Barrie or Toronto routers.
The remainder of this project involves the installation of passive fibre
infrastructure along roadways within municipal right of ways. Horizontal
Directional Drilling will be used to install parallel duct structures for both transport
and distribution networks. The transport network will consist of high count fibre
Attachment #1 to
Report LEG 01-21
optic cable (216, 144 or 72 strands) in 1.5” duct and the distribution network will
consist of lower count micro-fibre cable (24, 48, 72 or 144 strands) in 7-way
micro-duct.
Cable vaults and pedestals will be installed throughout the network to enable
customer drop connections and distribution fibre aggregation as well as splicing
of trunk and distribution fibres. Where customers are not serviced directly from a
pedestal or vault, the 7-way micro-duct bundle will be “branched” by splicing the
customer drop conduit, mid-span in the micro-duct bundle, to the allocated micro-
duct. Roadside cabinets containing GPON splitters will be installed at vaults 1, 5
and 9, which will enable passive aggregation of 32 individual customers onto a
single feeder fibre for transport to an OLT port at the new POP site.
Barrie
POP
(Existing)
Cisco
ASR9k
Toronto
151 Front
(Existing)
Internet
100G 100G
Zhone
MXK
2x 10G
Carrier
NNIs
New POP Site
100G Vianet Fiber
King City
POP
(Existing)
10 G Vianet Fibre10G Vianet Fibre
Logical Network Diagram
Fibre Up Rural Pickering
10 G Dark Fibre IRU
Sample FTTH Distribution
Cable
Vault
Cable
Vault
Home
1. Direct to vault
PedPedPed
Home
2. Direct to Ped
Home
3. Tie into 7-way
micro-duct mid-
span + back to
ped or vault
144 count trunk in 1.5" conduit
Dist micro fiber 24,48,72 in 7-way micro duct
3 options for drops to home (indicated in diagram)
1. Direct to vault
2. Direct to Ped
3. Tie into 7-way micro-duct mid-span + back to ped or vault
2020 -12-17
Carrier
NNIs
Attachment #2 to
Report LEG 01-21
Coverage Map
Fibre Up Rural Pickering
Amount requested under ICON 252,098.75$
Lead Applicant Contribution 705,296.25$
Funding from all other sources 150,000.00$
Total Eligible Costs 1,008,395.00$ Other Provincial -$
Total Ineligible Costs 99,000.00$ Federal -$
Total Project Cost 1,107,395.00$ Municipal 150,000.00$
Territorial -$
Community Organization -$
Band Council -$
Private -$
ELIGIBLE COSTS Item Description Comments (If Applicable)Total Number of Units WIRED - Last-Mile ($)WIRED - Backbone ($)WIRELESS - Last-Mile ($)WIRELESS - Backbone ($)Total Amount ($)
Direct Labour (enter hours or days)
Project Management Overall PM of design and construction of Estimated 300 hours @$50/hr 300 8,750.00$ 6,250.00$ -$ -$ 15,000.00$
Engineering Design External design firm Charged on a /m rate, estimated at $4/m - 12500 50,000.00$ -$ -$ -$ 50,000.00$
Directional Drilling Conduit/vault/ped installation plus fibre j $44/m for drilling and $3/m for fibre jettin 12500 587,500.00$ -$ -$ -$ 587,500.00$
Fibre Splicing Internal staff 180 hours @$40/ - 80 last mile, 100 backb 180 3,200.00$ 4,000.00$ -$ -$ 7,200.00$
Others (Please Specify)-$ -$ -$ -$ -$
Others (Please Specify)-$ -$ -$ -$ -$
Others (Please Specify)-$ -$ -$ -$ -$
Direct Materials
Conduits Backbone conduit $4.00/m 144 count fibre, $2.00/m1.5" SDR 11200 -$ 68,320.00$ -$ -$ 68,320.00$
Vaults Vault, lid, ground plate, marker stick and Includes all materials located at each vault 25 -$ 26,875.00$ -$ -$ 26,875.00$
Pedestals Pedestal and small splice closure Includes all materials at each ped location 55 16,500.00$ -$ -$ -$ 16,500.00$
PON Cabinets + Splitters GPON field cabinets with 1x32 passive splitters 3 27,000.00$ -$ -$ -$ 27,000.00$
Conduit - Last Mile Last Mile conduit $1.50/m avg cost of mix of 24/48/72 coun 14000 94,500.00$ -$ -$ -$ 94,500.00$
Equipment
Radio -$ -$ -$ -$ -$
Routers Cisco ASR 920 Series - 12 x1/10GE SFP, D Core router for POP site 1 -$ 16,500.00$ -$ -$ 16,500.00$
Dishes -$ -$ -$ -$ -$
Antennas -$ -$ -$ -$ -$
Switches -$ -$ -$ -$ -$
Servers -$ -$ -$ -$ -$
Splices -$ -$ -$ -$ -$
Power Systems(Generators, batteries, solar cells, etc)-$ -$ -$ -$ -$
Fibre/Cable Fibre included in costing of Backbone and Last Mile conduit costing above -$ -$ -$ -$ -$
Monitoring Systems -$ -$ -$ -$ -$
Miscellaneous -$ -$ -$ -$ -$
GPON Shelf Zhone MXK GPON Shelf with 2x16 Port OLT cards and optics 1 41,500.00$ -$ -$ -$ 41,500.00$
Others (Please Specify)-$ -$ -$ -$ -$
Others (Please Specify)-$ -$ -$ -$ -$
Direct Satellite Capacity
Contract -$ -$ -$ -$ -$
Other Consulting Services (please specify)-$ -$ -$ -$ -$
Other Consulting Services (please specify)-$ -$ -$ -$ -$
Other Consulting Services (please specify)-$ -$ -$ -$ -$
Other Consulting Services (please specify)-$ -$ -$ -$ -$
Other Consulting Services (please specify)-$ -$ -$ -$ -$
Direct Travel
Flights -$ -$ -$ -$ -$
Vehicle Rental -$ -$ -$ -$ -$
Accommodations -$ -$ -$ -$ -$
Others (please specify)-$ -$ -$ -$ -$
Others (please specify)-$ -$ -$ -$ -$
Others (please specify)-$ -$ -$ -$ -$
Others (please specify)-$ -$ -$ -$ -$
Others (please specify)-$ -$ -$ -$ -$
Other
Site Preparation Concrete pad for Telecom Shelter includes materials labour 1 -$ 4,000.00$ -$ -$ 4,000.00$
Hydro Connection Utility hookup for Telecom Shelter 1 -$ 3,500.00$ -$ -$ 3,500.00$
Make-ready -$ -$ -$ -$ -$
Testing-Network Elements -$ -$ -$ -$ -$
Testing-Power Systems -$ -$ -$ -$ -$
Testing-Monitoring Systems -$ -$ -$ -$ -$
Software( Please Specify)-$ -$ -$ -$ -$
Telecom Shelter Outdoor telecom cabinet with built in DC Outdoor Telecom Shelter POP Site 1 -$ 15,000.00$ -$ -$ 15,000.00$
Special Crossing - Highway 407 Sepcial permit, blocker trucks, paid duty police and after hours works 1 -$ 30,000.00$ -$ -$ 30,000.00$
Sepcial Crossing - Railroad Special permit, rail flagmen 1 -$ 5,000.00$ -$ -$ 5,000.00$
Other(Please Specify)-$ -$ -$ -$ -$
Other(Please Specify)-$ -$ -$ -$ -$
828,950.00$ 179,445.00$ -$ -$ 1,008,395.00$
25%25%
207,237.50$ 44,861.25$ -$ -$ -$
INELIGIBLE COSTS Comments (If Applicable)Total Number of Units (If Applicable)Total Amount ($)
Billing Support Systems Internally developed system already in place -$
Customer Care Systems Internally developed system already in place -$
Licenses N/A -$
General Liability Insurance Already in place -$
Testing – User Devices -$
Testing – Support Systems -$
Customer activations End customer activaton includes $150 fo 90 99,000.00$
Other (please specify)-$
Other (please specify)-$
Other (please specify)-$
Other (please specify)-$
99,000.00$
Project Costing
Project Costs 2020-21 2021-22 2022-2023 2023-2024 TOTAL
Eligible -$ 750,000.00$ 258,395.00$ -$ 1,008,395.00$
Ineligible -$ 60,500.00$ 38,500.00$ -$ 99,000.00$
Total Project Cost -$ 810,500.00$ 296,895.00$ -$ 1,107,395.00$
Project Funding
Project Funding Status of Funding Source of Funding Contact Information
(Name, Phone, Email Address)2020-21 2021-22 2022-2023 2023-2024 TOTAL
Amount Requested under ICON
(Up to 25% of total eligible costs)To Be Requested -$ 187,494.00$ 64,604.75$ -$ 252,098.75$
Lead Applicant Contribution Confirmed/Received -$ 511,443.00$ 193,853.25$ -$ 705,296.25$
Funding from other Sources -$ 111,563.00$ 38,437.00$ -$ 150,000.00$
Other Provincial -$ -$ -$ -$ -$
Federal -$ -$ -$ -$ -$
Municipal Confirmed/Pending Transaction -$ 111,563.00$ 38,437.00$ -$ 150,000.00$
Territorial -$ -$ -$ -$ -$
Community Organization -$ -$ -$ -$ -$
Band Council -$ -$ -$ -$ -$
Private -$ -$ -$ -$ -$
Total Financial Contributions -$ 810,500.00$ 296,895.00$ -$ 1,107,395.00$
1. a) Indicate whether the project contains the following components.
Does the project have a mobile
component?
SUMMARY TABLE
Please fiil out this section Do Not Fill-This section is auto-populated
Insert the following values into the Application Form under Section G (Budget Forecast & Confirmed Sources of Funding). The boxes below will be populated once the form is
complete.
Are you targeting a very remote
community or an Indigenous
community or a satellite dependent
community?
NO
Improving Connectivity for Ontario (ICON) - DETAILED BUDGET TEMPLATE
This template is part of Stage 2 of the ICON Program application.
IMPORTANT: Do not copy or paste values into this template, it includes formulas designed to calculate totals.
1: Detailed Budget: The detailed budget table should be completed by the Applicant as part of ICON Stage 2 application process.
a) Under the Summary Table, indicate if the project will be targeting a remote community, an Indigenous community, a satellite dependent community, and/or have a mobile component.
Applicants MUST input information into all the grey cells, except if there is no information for that specific cell.
Failure to provide the requested information may result in the application being deemed incomplete.
ICON team may share application information with provincial and federal governments or other federal funding partners to improve coordination and bilateral decision-making related to broadband and mobile funding.
g) Once completed, proceed to the Summary Project Budget table.
2: Summary Project Budget
a) These tables are organized according to government fiscal year which runs from April 1st to March 31st. Applicants must ensure that costs are allocated accordingly.
b) Verify that all budget line items correlate between Part 1 and Part 2 on the Detailed Budget Template.
3: Once Part 1 and 2 are completed, proceed to filling out Section G on the Application Form (Budget Forecast & Confirmed Sources of Funding) using the auto-populated values in the Summary Table, as specified. Once the Applicant has completed the template, the Applicant is required to resolve any error messages displayed. The template can
b) Complete the eligible and ineligible cost categories ensuring that you are placing the items in the appropriate cost category. Costs must be rounded to the nearest whole dollar.
c) Each budget category (i.e. equipment, materials, direct labour, etc.) have an extensive number of sub-categories (i.e. radios, routers, dishes, etc.). If your sub-category is not listed please use the “Other” subcategory row and specify, with as much detail as possible, explaining information on the nature of the item in the item description
d) For categories that are not applicable, leave the cell empty.
e) The following rows are automatically calculated based upon the allocations provided: total eligible, total ineligible and total project costs.
f) Please indicate the funding ratio(s) requested from the ICON program.
INDICATE SHARING RATIO (%)
AMOUNT REQUESTED FROM ICON (Auto-Populated)
TOTAL INELIGIBLE
PART 2 - SUMMARY PROJECT BUDGET
NO
PART 1 - DETAILED BUDGET
TOTAL ELIGIBLE
Attachment #3 to Report LEG 01-21
DATE:Applicant Name
Project Name
?
?
Annual expenses for that operational component should be entered under each of the five (5) years accordingly. Add any notes or comments as appropriate.
5) There is a section where the total civic addresses (serviceable addresses) captured by the proponents network solution are input. Estimate the customer acquisition or growth curve over the five (5) years.
This input will be used in the SUMMARY TAB and also in the Customer Premise Equipment and Installation section of the NETWORK BUILD TAB. Add any notes or comments as appropriate.
The spreadsheet automatically calculates the Capital $ required annually based on the percentage chosen by the proponent. A 40 year lifecycle suggests a 2.5% annual refresh rate.
7) There is an "OTHER" category where the proponent may include any other components which has not been covered in the category section. Add any notes or comments as appropriate.
6) A network technology lifecycle refresh component has been included which is typically based on a 40 year lifecycle for the Outside Plant, towers etc. The proponent can choose whatever lifecycle term they feel is appropriate for
their solution.
Your Project Name
INSTRUCTIONS TAB:
SUMMARY TAB:
NETWORK BUILD (WIRED and WIRELESS Solution TABS):
6) There is an "OTHER" category where the applicant may include any other components which have not been covered in the category section. Add any notes or comments as appropriate.
1) This TAB provides Applicants Instructions for filling out this Financial Forecast template.
2) Applicants need only to fill the boxes in grey above in this TAB (Date / Applicant Name / Project Name).
1) The "Summary" TAB summarizes the inputs from both the "Network Build" (WIRED and WIRELESS) TABS and the "Operations" TAB.
2) The "Summary" TAB reflects total $ costs for both WIRED and WIRELESS solution proposals as well as normalized unit $ costs per customer.
This also provides a "checking" mechanism for the applicant as the template is being filled in.
Improving Connectivity for Ontario (ICON) - Financial Forecast Template Instructions
1) There are two separate TABS, a WIRED solution TAB and a WIRELESS solution TAB which are both protected so that only the "input fields" can be altered by the applicant. All formulas can be seen but not altered in any way. All
white cells are calculated and NOT alterable.
2) There may be cases where a project has wired and wireless components, and certain infrastructure is required for both types of service to be operational. In those instances, please include the common infrastructure in only
one of the "Network Build" TABS so the infrastructure is not double-counted. These TABS have been protected so that only the "input fields" can be altered by the applicant. All formulas can be seen but not altered in any way. All
4) On each relevant line, the proponent should simply provide the "Capital $" component required to support the start-up of the operations. If already captured under the "Network Build" TAB, DO NOT report it again.
Your Company Name
4) Applicants should only fill in the "cell inputs" which are relevant to their network solution. For example, in a WIRED Solution, if no towers are used, DO NOT fill in any of the input cells which pertain to towers.
If multiple technologies are used, then fill in the appropriate input cells in the appropriate TAB. Add any comments or notes to help support your numbers.
5) On each relevant line, the proponent should simply provide the "Quantity" and "Unit Cost" whether they are Materials or Labour as the input. Add any notes or comments as appropriate.
3) There is also an opportunity for the applicant to add any final Comments or Notes to the "Summary" TAB.
3) The "Network Build" TABS provide the "inputs" for the "Backbone" portion and "Last-Mile" portions of the proposed network solutions. All input cells are grey in colour.
1) This TAB has been protected so that only the "input fields" can be altered by the proponent. All formulas can be seen but not altered in any way. All white cells are calculated and NOT alterable.
2) This TAB provides the "inputs" for the "Operations" portion of the proposed network solution. All input cells are grey in colour.
3) Proponents should only fill in the "cell inputs" which are relevant to their network solution.
OPERATIONS TAB:
Attachment #4 to Report LEG 01-21
Date:0-Jan-00 Project Name:
QTY Material $Labour $TOTAL CAPITAL $AVG $/Unit AVG $/Pot
Customer QTY Material $Labour $TOTAL CAPITAL
$AVG $/Unit AVG $/Pot
Customer
0 $0 $0 $0 $0 $0 Land Acquisition 0 $0 $0 $0 $0 $0
11,201 $103,320 $0 $103,320 $9 $708 Wireless Towers Deployed (Qty)0 $0 $0 $0 $0 $0
0 $0 $0 $0 $0 $0 Fibre Deployment (m)0 $0 $0 $0 $0 $0
0 $0 $0 $0 $0 $0 Coax Plant Deployment (m)0 $0 $0 $0 $0 $0
25 $26,875 $4,000 $30,875 $1,235 $211 Outside Plant Materials (QTY)0 $0 $0 $0 $0 $0
0 $0 $0 $0 $0 $0 Transport Equipment (QTY)0 $0 $0 $0 $0 $0
1 $15,000 $7,500 $22,500 $22,500 $154 Back Office Facilities (QTY)0 $0 $0 $0 $0 $0
1 $16,500 $6,250 $22,750 $22,750 $156 Back Office Equipment (QTY)0 $0 $0 $0 $0 $0
0 $0 $0 $0 $0 $0 Other Backbone Materials and
Labour:0 $0 $0 $0 $0 $0
TOTAL Backbone
Network Capital $:$179,445 TOTAL Backbone
Network Capital $:$0
AVG $/Customer:$1,229 AVG $/Customer:$0
Total ELIGIBLE $:$179,445 Total ELIGIBLE $:$0
Total INELIGIBLE $:$0 Total INELIGIBLE $:$0
QTY Material $Labour $TOTAL CAPITAL $AVG $/Unit AVG $/Customer QTY Material $Labour $TOTAL CAPITAL
$AVG $/Unit AVG
$/Customer
0 $0 $0 $0 $0 $0 Land Acquisition 0 $0 $0 $0 $0 $0
14,000 $94,500 $637,500 $732,000 $52 $5,014 Wireless Towers Deployed (Qty)0 $0 $0 $0 $0 $0
0 $0 $0 $0 $0 $0 Fibre Deployment (m)0 $0 $0 $0 $0 $0
0 $0 $0 $0 $0 $0 Outside Plant Materials (QTY)0 $0 $0 $0 $0 $0
55 $16,500 $3,200 $19,700 $358 $135 Distribution Equipment (QTY)0 $0 $0 $0 $0 $0
1 $68,500 $8,750 $77,250 $77,250 $529 End Customer Termination @100%
PEN (QTY)3 $0 $0 $0 $0 $0
0 $0 $99,000 $99,000 $0 $678 Other "Last Mile" Materials and
Labour:0 $0 $0 $0 $0 $0
0 $0 $0 $0 $0 $0 TOTAL "LAST MILE"
Network Capital $:$0
TOTAL "LAST MILE"
Network Capital $:
$927,950 AVG $/Customer:$0
AVG $/Customer:$6,356 Total ELIGIBLE $:$0
Total ELIGIBLE $:$828,950 Total INELIGIBLE $:$0
Total INELIGIBLE $:$99,000 $0
$1,107,395
YEAR #1 YEAR #2 YEAR #3 YEAR #4 YEAR #5 YEAR #1 YEAR #2 YEAR #3 YEAR #4 YEAR #5
55 25 15 5 5 55 25 15 5 5
55 80 95 100 105 55 80 95 100 105
37.7%54.8%65.1%68.5%71.9%1833.3%2666.7%3166.7%3333.3%3500.0%
PROJECT COMPONENTS ELIGIBLE COSTS
(Backbone)
INELIGIBLE COSTS
(Backbone)
ELIGIBLE COSTS
(Last MIle)
INELIGIBLE COSTS
(Last MIle)TOTALS TOTAL $Year #1 Year #2 Year #3 Year #4 Year #5
Core Backbone $7,500 $0 N/A N/A $7,500 $32,250 $9,000 $6,075 $5,650 $5,725 $5,800
Last Mile Distribution N/A N/A $50,000 $0 $50,000 $0 $0 $0 $0 $0 $0
Towers $0 $0 $0 $0 $0 $8,750 $1,750 $1,750 $1,750 $1,750 $1,750
A/E Plant, Poles $35,000 $0 $0 $0 $35,000 $0 $0 $0 $0 $0 $0
U/G Plant, Fibre/Coax $99,195 $0 $778,950 $0 $878,145 $41,000 $10,750 $7,825 $7,400 $7,475 $7,550
Optical Transport and
Back Office $37,750 N/A N/A N/A $37,750 AVG $/Customer:$195 $98 $78 #REF!#DIV/0!
Misc – Travel Costs $0 $0 $0 $0 $0
Pre-engineering N/A $0 N/A $0 $0 TOTAL $Year #1 Year #2 Year #3 Year #4 Year #5
Land Acquisition $0 $0 $0 $0 $0 $32,250 $9,000 $6,075 $5,650 $5,725 $5,800
Customer Premise
Equipment (CPE)N/A N/A $0 $99,000 $99,000 $0 $0 $0 $0 $0 $0
$179,445 $0 $828,950 $99,000 $1,107,395 $8,750 $1,750 $1,750 $1,750 $1,750 $1,750
Contingency Amount $17,945 $0 $82,895 $9,900 $110,740 $0 $0 $0 $0 $0 $0
$197,390 $0 $911,845 $108,900 $1,218,135 $758 $152 $152 $152 $152 $152
N/A N/A N/A N/A N/A N/A
$41,758 $10,902 $7,977 $7,552 $7,627 $7,702
AVG $/Customer:$198 $100 $79 #REF!#DIV/0!
ERROR!$21,652 $15,802 $14,952 $15,102 $15,252
OVERALL AVG
$/Customer:$271 $198 $157 #REF!#DIV/0!
OPERATING EXPENSES SUMMARY
GENERAL Office Expenses
Network Back Office Expenses (Call Centre, Service Desk
Network - Outside Plant Maintenance Expenses
Network - Equipment Maintenance Expenses
Network - Equipment Maintenance Expenses
Technology Lifecycle Refresh
Other Operating Capital (Included under each Category)
Total Operating Expenses:
OPERATING CAPITAL SUMMARY
GENERAL Office Expenses
Network Back Office Expenses (NOC and Service Desk)
Network - Outside Plant Maintenance Expenses
Land Acquisition
Other "Last Mile" Materials and Labour:
Coax Plant Deployment (m)
DSLAM and FDH Deployments (QTY)
Outside Plant Materials (QTY)
Distribution Equipment (QTY)
End Customer Termination @100% PEN (QTY)
Transport equipment, transport cards, racking, cabling.
Equipment installation.
Supply and Install - Towers, Site Equipment, hydro transfers,
hydro make-ready.
Fibre Deployment (m)
Supply and Install - Poles, achors, grounding and
transportation. Pole placement, hydro transfers, hydro make-
ready.
Planning, design and engineering. Equipment installation.
Planning, design and engineering. Equipment installation.
TOTAL OSP INFRASTRUCTURE BUILD ESTIMATE
Total Operating Cash Flow Estimate:
Applicants Notes and Comments:Total Operating Capital Expenses:
WIRELESS SOLUTION - "BACKBONE" INFRASTRUCTURE ESTIMATE
WIRELESS SOLUTION - "LAST MILE" OSP INFRASTRUCTURE ESTIMATE
DESCRIPTION OF ACTIVITIES
OPERATING CASH FLOW ESTIMATE - 3 YEAR OPERATIONS
Pre-engineering Design and Bid Preparation.
Leasing of land, buildings and other facilities; leasing
equipment other than equipment directly related to the
construction of the Project; real estate fees and related costs,
purchase of Land for Towers and/or Backbone connections.
10% has been calculated into each individual component
Total Estimated Project Costs
Customer Premise Equipment (ie. Towers, Antennas, RF
Amplifiers, Termination Hardware, Modems, Drops, Optical
Network Terminals)
Subtotals
Fibre and/or Coaxial cable, associated hardware, terminals,
cabinets, passive splitters, planning and design.
ICON - Cost Estimate Summary
WIRED SOLUTION - "BACKBONE" INFRASTRUCTURE ESTIMATE
WIRED SOLUTION - "LAST MILE" OSP INFRASTRUCTURE ESTIMATE
Land Acquisition / Leasing
Fibre Deployment (m)
Coax Plant Deployment (m)
DSLAM and FDH Deployments (QTY)
Your Project NameYour Company NameApplicant Name:
Outside Plant Materials (QTY)
Transport Equipment (QTY)
Back Office Facilities (QTY)
Back Office Equipment (QTY)
Other Backbone Materials and Labour:
Customer Growth Curve
(Customers to be connected by Proposed Network
Solution):
Cumulative Connections:
TOTAL Network Solution Reach:
WIRELESS SOLUTION
Customer Growth Curve
(Customers to be connected by
Proposed Network Solution):
Cumulative Connections:
TOTAL Network Solution Reach:
WIRED SOLUTION
CAPITAL BUDGET $ ESTIMATE WORKSHEET
DATE:0-Jan-00 ?= CELL INPUTS
# of WIRED Connections Serviced 146 Households 138
Businesses 4
Anchor Institutions 4
BACKBONE INFRASTRUCTURE - Materials
Item Eligible/ Ineligible
Cost Units Unit $$ Estimate
1 Eligible 1 $35,000 $35,000
2 Ineligible 0 $0 $0
3 Eligible 11200 $6 $68,320
4 Eligible 0 $0 $0
5 Eligible 0 $0 $0
6 Eligible 0 $0 $0
7 Eligible 25 $1,075 $26,875
8 Eligible 0 $0 $0
9 Eligible 1 $15,000 $15,000
10 Eligible 1 $16,500 $16,500
Other Backbone Materials NOT Covered Above:
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
$161,695
$161,695
$0
Item Eligible/ Ineligible
Cost Units Unit $Cost $ Estimate
1 Ineligible 0 $0 $0
2 Eligible 1 $0 $0
3 Ineligible 0 $0 $0
4 Eligible 0 $0 $0
5 Eligible 0 $0 $0
6 Eligible 0 $0 $0
7 Eligible 0 $0 $0
8 Eligible 0 $0 $0
9 Eligible 0 $0 $0
10 Eligible 0 $0 $0
11 Eligible 0 $0 $0
12 Eligible 0 $0 $0
13 Eligible 100 $40 $4,000
14 Eligible 0 $0 $0
15 Eligible 1 $7,500 $7,500
16 Eligible 125 $50 $6,250
Other Backbone Labour NOT Covered Above:
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
$17,750
$17,750
$0
Item Eligible/ Ineligible
Cost Units Unit $Cost $ Estimate
1 Eligible 0 $0 $0
2 Ineligible 0 $0 $0
3 Eligible 14000 $7 $94,500
4 Eligible 0 $0 $0
5 Eligible 0 $0 $0
6 Eligible 0 $0 $0
7 Eligible 55 $300 $16,500
8 Eligible 1 $68,500 $68,500
9 Ineligible 0 $0 $0
Other "Last Mile" Materials NOT Covered Above:
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
$179,500
$179,500
$0
Item Eligible/ Ineligible
Cost Units Unit $Cost $ Estimate
1 Ineligible 0 $0 $0
2 Ineligible 0 $0 $0
3 Eligible 0 $0 $0
4 Eligible 0 $0 $0
5 Eligible 12500 $4 $50,000
6 Eligible 12500 $47 $587,500
7 Eligible 0 $0 $0
8 Eligible 0 $0 $0
9 Eligible 0 $0 $0
10 Eligible 0 $0 $0
11 Eligible 0 $0 $0
12 Eligible 0 $0 $0
13 Eligible 80 $40 $3,200
14 Eligible 175 $50 $8,750
15 Ineligible 90 $1,100 $99,000
Other "Last Mile" Labour NOT Covered Above:
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
$748,450
$649,450
$99,000
$1,107,395
Assumptions (Notes and Comments)
Fibre splicing of last mile fibre.
NOTE TO BRIAN: This is actually for Project Management however there is
no set spot for that and the "Other Last Mile Labour" section below
End customer activaton includes $150 for ONT, $450 to run drop conduit
and blow drop fibre in, $200 for drop materials including drop conduit,
Includes design and permitting for parallel backbone network.
$44/m directional drilling includes installation of conduit systems, vaults
and peds both last mile and bakcbone. $3/m for cable jetting of both last
$1.50/m avg cost of mix of 24/48/72 count micro fibre, $4.75/m 7-way
microduct, $0.25/m microduct couplers, $0.25/m trace wire. Includes 12%
Pedestals and small splice closures.
$41,500 for 1 Zhone MXK Shelf with 2x16 Port OLT cards plus optics. 3 x
$8,000 for PON cabinets. 12 x $250 for 1x32 splitters for PON Cabinets.
Outside Plant Materials (Installation, Commissiong and Turn-up) ($/QTY)
Assumptions (Notes and Comments)
U/G design of backbone section piggybacked on parallel last mile build
U/G installation of backbone section piggybacked on parallel last mile
build
$4000 to install concrete pad for shelter (includes material and labour)
and $3,500 for hydro hookup.NOTE TO BRIAN: This is actually for Project Management however there is
no set spot for that and the "Other Last Mile Labour" section below
Fibre splciing of backbone fibre.
TOTAL INELIGIBLE $:
ICON - WIRED SOLUTION COST ESTIMATE
Assumptions (Notes and Comments)
BACKBONE INFRASTRUCTURE - Labour
"LAST MILE" INFRASTRUCTURE - Materials
"LAST MILE" INFRASTRUCTURE - Labour
NOTE TO BRIAN: This is actually for 2 special permits and needs to be in
Item 11 below but requires the spreadsheet to be fixed to allow it as an
TOTALS:
TOTAL ELIGIBLE $:
Distribution Equipment (Installation, Commissiong and Turn-up) ($/QTY)
End Customer Equipment (Customer Drop, Outside Home Termination, Internal Wiring, Cable/Data Modem, Home Terminal, etc) (QTY)
16
DSLAM/Node and FDH/FSA Design, Permits and Engineering ($/QTY)
DSLAM/Node and FDH/FSA Install, Commissioning and Turn-up (Cabinet, Fibre/Copper Termination, Splitter Modules, Actives, etc)
($/QTY)
$4.00/m 144 count fibre, $2.00/m1.5" SDR13.5 conduit, $0.10/m
couplers Includes 12% account for wastage of fibre backloops and
$475/cable vault, $550/large splice closure, $50/ground plate and marker
stick at each vault location
Outdoor telecom cabinet with built in DC power system and battery
backupCisco ASR 920 Series - 12 x1/10GE SFP, Dual DC Model & Cisco ASR920
Series - Advanced Metro IP Access
Assumptions (Notes and Comments)
TOTALS:
TOTAL ELIGIBLE $:
End Customer Equipment (Customer Drop, Outside Home Termination, Internal Wiring, Cable/Data Modem, Home Terminal, etc) (QTY)
A/E Coax Plant Install, Commissioning and Turn-up ($/m)
U/G Coax Plant Extension Design, Permits and Engineering ($/m)
U/G Coax Plant Install, Commissioning and Turn-up ($/m)
U/G Fibre Design, Permits and Engineering ($/m)
U/G Fibre Install, Commissioning and Turn-up ($/m)
A/E Coax Plant Extension Design, Permits and Engineering ($/m)
Fibre Network Pre-Engineering ($)
Leasing of land, buildings and other facilities; leasing equipment other than equipment directly related to the construction of the Project;
real estate fees and related costs, purchase of Land for Towers and/or Backbone connections
Aerial Fibre Design, Permits and Engineering ($/m)
Aerial Fibre Install, Commissioning and Turn-up ($/m)
TOTAL ELIGIBLE $:
TOTAL INELIGIBLE $:
Description
TOTALS:
10
DSLAM/Node and FDH/FSA Last Mile Deployments (Cabinet, Fibre/Copper Termination, Splitter Modules, Actives, etc) (QTY)
Outside Plant Materials (FOSC, Peds, Handholds, Connectors, Power Supplies, etc) (QTY)
Distribution Equipment (Optical Equipment and Splitters, RF Equipment, Routers, Switches, Spares, etc. ) (QTY)
Leasing of land, buildings and other facilities; leasing equipment other than equipment directly related to the construction of the Project;
real estate fees and related costs, purchase of Land for Towers and/or Backbone connections
U/G Fibre Distribution Build (Cable, Conduit, Couplers) (U/G m)
A/E Coax Distribution Plant Extensions (Aerial m)
U/G Coax Distribution Plant Extensions (U/G m)
TOTAL INELIGIBLE $:
Description
A/E Fibre Distribution Build (Poles, Cable, Strand, Lashing Wire, Anchors ) (Aerial m)
Back Office Facilities (Building, Racks, Power, HVAC, Gensets, Fuel Tanks, Security) (QTY)
Back Office Equipment (Transit Routers, Switches, Redundancy Equipment, Sparing, etc) (QTY)
11
Back Office Facilities (Design, Permitting and Engineering) ($/QTY)
Back Office Equipment Install, Commissioning and Turn-up ( Transit Routers, Switches, Redundancy Equipment, etc) (QTY)
17
DSLAM/Node and FDH/FSA Install, Commissioning and Turn-up ($/QTY)
Outside Plant Materials (Installation, Commissiong and Turn-up) ($/QTY)
Transport Equipment (Installation, Commissiong and Turn-up) ($/QTY)
U/G Coax Plant Extension Design, Permits and Engineering ($/m)
U/G Coax Plant Install, Commissioning and Turn-up ($/m)
DSLAM/Node and FDH/FSA Design, Permits and Engineering ($/QTY)
U/G Fibre Install, Commissioning and Turn-up ($/m)
Aerial Coax Plant Extension Design, Permits and Engineering ($/m)
Aerial Coax Plant Install, Commissioning and Turn-up ($/m)
A/E Fibre Design, Permits and Engineering ($/m)
Leasing of land, buildings and other facilities; leasing equipment other than equipment directly related to the construction of the Project;
real estate fees and related costs, purchase of Land for Towers and/or Backbone connections
A/E Fibre Install, Commissioning and Turn-up ($/m)
U/G Fibre Design, Permits and Engineering ($/m)
TOTAL INELIGIBLE $:
Description
Fibre Network Pre-Engineering ($)
TOTALS:
TOTAL ELIGIBLE $:
DSLAM/Node and FDH/FSA Deployments (QTY)
Outside Plant Materials (FOSC, Peds, Handholds, Connectors, Power Supplies,etc) (QTY)
Transport Equipment (Optical Transport, RF Transport, Redundancy Equipment, Sparing, etc) (QTY)
Leasing of land, buildings and other facilities; leasing equipment other than equipment directly related to the construction of the Project;
real estate fees and related costs, purchase of Land for Towers and/or Backbone connections
U/G Fibre Build (Cable, Conduit, Couplers) (U/G m)
A/E Coax Plant Extensions (Aerial m)
U/G Coax Plant Extensions (U/G m)
Description
A/E Fibre Build (Poles, Cable, Strand, Lashing Wire, Anchors ) (Aerial m)
CAPITAL BUDGET $ ESTIMATE WORKSHEET
DATE:0-Jan-00 ?= CELL INPUTS
# of WIRELESS Connections Serviced 3 Households 1
Businesses 1
Anchor Institutions 1
BACKBONE INFRASTRUCTURE - Materials
Item Eligible/ Ineligible
Cost Units Unit $$ Estimate
1 Eligible 0 $0 $0
2 Ineligible 0 $0 $0
3 Eligible 0 $0 $0
4 Eligible 0 $0 $0
5 Eligible 0 $0 $0
6 Eligible 0 $0 $0
7 Eligible 0 $0 $0
8 Eligible 0 $0 $0
9 Eligible 0 $0 $0
10 Eligible 0 $0 $0
Other Backbone Materials NOT Covered Above:
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
$0
$0
$0
Item Eligible/ Ineligible
Cost Units Unit $Cost $ Estimate
1 Eligible 0 $0 $0
2 Ineligible 0 $0 $0
3 Ineligible 0 $0 $0
4 Eligible 0 $0 $0
5 Ineligible 0 $0 $0
6 Eligible 0 $0 $0
7 Eligible 0 $0 $0
8 Eligible 0 $0 $0
9 Eligible 0 $0 $0
10 Eligible 0 $0 $0
11 Eligible 0 $0 $0
12 Eligible 0 $0 $0
13 Eligible 0 $0 $0
14 Eligible 0 $0 $0
15 Eligible 0 $0 $0
16 Eligible 0 $0 $0
17 Eligible 0 $0 $0
Other Backbone Labour NOT Covered Above:
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
$0
$0
$0
Item Eligible/ Ineligible
Cost Units Unit $Cost $ Estimate
1 Eligible 0 $0 $0
2 Ineligible 0 $0 $0
3 Eligible 0 $0 $0
4 Eligible 0 $0 $0
5 Eligible 0 $0 $0
6 Eligible 0 $0 $0
7 Ineligible 3 $0 $0
Other "Last Mile" Materials NOT Covered Above:
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
$0
$0
$0
Item Eligible/ Ineligible
Cost Units Unit $Cost $ Estimate
1 Ineligible 0 $0 $0
2 Eligible 0 $0 $0
3 Eligible 0 $0 $0
4 Ineligible 0 $0 $0
5 Ineligible 0 $0 $0
6 Eligible 0 $0 $0
7 Eligible 0 $0 $0
8 Eligible 0 $0 $0
9 Eligible 0 $0 $0
10 Eligible 0 $0 $0
11 Eligible 0 $0 $0
12 Ineligible 3 $0 $0
Other "Last Mile" Labour NOT Covered Above:
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
$0
$0
$0
$0
Tower Site Pre-Engineering, Design, Permits and Bid Preparation ($/Site)
Tower Site Design, Permits and Engineering ($/Site)
Assumptions (Notes and Comments)Description
"LAST MILE" INFRASTRUCTURE - Labour
A/E Fibre Distribution Build (Poles, Cable, Strand, Lashing Wire, Anchors ) (Aerial m)
U/G Fibre Distribution Build (Cable, Conduit, Couplers) (U/G m)
TOTAL ELIGIBLE $:
TOTAL INELIGIBLE $:
"LAST MILE" INFRASTRUCTURE - Materials
Assumptions (Notes and Comments)
8
Distribution Equipment (Optical Equipment and Splitters, RF Equipment, Routers, Switches, Spares, etc. ) (QTY)
End Customer Equipment (Customer Drop, Outside Home Termination, External Mini-Tower and Antenna, Internal Wiring,
Cable/Data Modem, Home Terminal, etc) (QTY)
Outside Plant Materials (FOSC, Peds, Handholds, Connectors, Power Supplies, etc) (QTY)
Description
Towers, Equipment Shelter, Powering, HVAC, Antennas, Cabling (QTY)
Leasing of land, buildings and other facilities; leasing equipment other than equipment directly related to the construction of the
Project; real estate fees and related costs, purchase of Land for Towers and/or Backbone connections
TOTAL INELIGIBLE $:
13
TOTAL ELIGIBLE $:
TOTAL INELIGIBLE $:
TOTALS:
TOTAL ELIGIBLE $:
Distribution Equipment (Installation, Commissiong and Turn-up) ($/QTY)
End Customer Equipment (Customer Drop, Outside Home Termination, External Mini-Tower and Antenna, Internal Wiring,
Cable/Data Modem, Home Terminal, etc) (QTY)
U/G Fibre Design, Permits and Engineering ($/m)
U/G Fibre Install, Commissioning and Turn-up ($/m)
Outside Plant Materials (Installation, Commissiong and Turn-up) ($/QTY)
Leasing of land, buildings and other facilities; leasing equipment other than equipment directly related to the construction of the
Project; real estate fees and related costs, purchase of Land for Towers and/or Backbone connections
Fibre Network Pre-Engineering ($)
Aerial Fibre Design, Permits and Engineering ($/m)
Aerial Fibre Install, Commissioning and Turn-up ($/m)
Tower Site Installation, Commissioning and Turn up ($/site)
TOTALS:
ICON - WIRELESS SOLUTION COST ESTIMATE
Assumptions (Notes and Comments)
Transport Equipment (Installation, Commissiong and Turn-up) ($/QTY)
Outside Plant Materials (Installation, Commissiong and Turn-up) ($/QTY)
11
U/G Coax Plant Install, Commissioning and Turn-up ($/m)
U/G Coax Plant Extension Design, Permits and Engineering ($/m)
Leasing of land, buildings and other facilities; leasing equipment other than equipment directly related to the construction of the
Project; real estate fees and related costs, purchase of Land for Towers and/or Backbone connections
A/E Fibre Build (Poles, Cable, Strand, Lashing Wire, Anchors ) (Aerial m)
U/G Fibre Build (Cable, Conduit, Couplers) (U/G m)
A/E Coax Plant Extensions (Aerial m)
BACKBONE INFRASTRUCTURE - Labour
Assumptions (Notes and Comments)
Back Office Facilities (Design, Permitting and Engineering) ($/QTY)
Back Office Equipment Install, Commissioning and Turn-up ( Transit Routers, Switches, Redundancy Equipment, etc) (QTY)
18
Aerial Coax Plant Install, Commissioning and Turn-up ($/m)
A/E Fibre Install, Commissioning and Turn-up ($/m)
U/G Fibre Design, Permits and Engineering ($/m)
U/G Fibre Install, Commissioning and Turn-up ($/m)
Leasing of land, buildings and other facilities; leasing equipment other than equipment directly related to the construction of the
Project; real estate fees and related costs, purchase of Land for Towers and/or Backbone connections.
Tower Site Installation, Commissioning and Turn up ($/site)
Fibre Network Pre-Engineering ($)
A/E Fibre Design, Permits and Engineering ($/m)
Description
Tower Site Design, Permits and Engineering ($/Site)
Tower Site Pre-Engineering ($/Site)
Description
Backhaul Towers, Land, Equipment Shelter, Powering, HVAC, Antennas, Cabling (QTY)
Back Office Facilities ( Building, Racks, Power, HVAC, Gensets, Fuel Tanks, Security) (QTY)
Back Office Equipment ( Transit Routers, Switches, Redundancy Equipment, Sparing, etc) (QTY)
TOTALS:
U/G Coax Plant Extensions (U/G m)
Outside Plant Materials (FOSC, Peds, Handholds, Connectors, Power Supplies,etc) (QTY)
Transport Equipment (Optical Transport, RF Transport, Redundancy Equipment, Sparing, etc) (QTY)
TOTALS:
TOTAL ELIGIBLE $:
TOTAL INELIGIBLE $:
Aerial Coax Plant Extension Design, Permits and Engineering ($/m)
OPERATIONS $ ESTIMATE WORKSHEET
DATE:0-Jan-00 ?= CELL INPUTS
General Office Expenses
Item Description Capital $Expense $Assumptions (Notes and Comments)YEAR #1 YEAR #2 YEAR #3 YEAR #4 YEAR #5
55 25 15 5 5
1 Direct Management Support - Oversight, Performance Management etc $0 $0 Serviced by existing staff, small enough project footprint to be negligible.$0 $0 $0 $0 $0
2 HR - Staff Recruiting and Training Support $0 $0 Serviced by existing staff, small enough project footprint to be negligible.$0 $0 $0 $0 $0
3 Sales and Marketing Support, Customer Acquisition Costs $0 $4,000 Assume a town hall meeting to kickoff project and direct mailers first 2 years with word of mouth ongoing.$3,500 $500 $0 $0 $0
4 General Admin Support, office space and equipment i.e. photocopiers, furniture, telephones,
computers, printers and office software $0 $0 No physical office in project area.$0 $0 $0 $0 $0
5 Pole Rental - Recurring Pole Attachment Costs $0 $12,500 Not pole rental - ongoing locate costs as plant will be underground.$2,500 $2,500 $2,500 $2,500 $2,500
6 Tower Site Rental - Recurring Costs $0 $0 $0 $0 $0 $0 $0
7 Back-Office Building/Space Rental - Recurring Costs $0 $0 $0 $0 $0 $0 $0
8 Field Maintenance & Repair Support, Vehicles, Office desk space, laptops, Tools, S/W licensing,
Annual S/W maintenance $0 $0 $0 $0 $0 $0 $0
9 Co-Location and Utility (Power) @ ALL Network Centres, Co-location sites $0 $0 $0 $0 $0 $0 $0
10 Fuel Costs for all Tower sites, Head Ends, Network Centre back-up Gensets $0 $0 $0 $0 $0 $0 $0
11 Utility Costs for all Tower sites, Head Ends, Central offices or Network Centres $0 $15,750 Minimal power requirments at a single head end.$3,000 $3,075 $3,150 $3,225 $3,300
12 Property Insurance - all Towers sites, Head Ends, Central Office, Network Centres or Back Office
Facilities.$0 $0 $0 $0 $0 $0 $0
13 Land Lease Costs , Property Taxes, ROW annual fees, Legal Fees, Environmental or Archeological
studies, Radio and Spectrum licensing fees, etc.$0 $0 $0 $0 $0 $0 $0
Other General Office Expenses NOT Covered Above:
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $32,250 $9,000 $6,075 $5,650 $5,725 $5,800
Network - Back Office Expenses (Call Centre, Service/Help Desk and NOC Operations)
Item Description Capital $Expense $Assumptions (Notes and Comments)YEAR #1 YEAR #2 YEAR #3 YEAR #4 YEAR #5
55 25 15 5 5
1 Establish or expand existing Call Centre Capacity, Resources, workstations, Specialized Training,
etc $0 $0 Serviced by existing staff, small enough project footprint to be negligible.$0 $0 $0 $0 $0
2 Establish or expand existing Service /Help Desk component, Resources, workstations, Specialized
Training, etc $0 $0 Serviced by existing staff, small enough project footprint to be negligible.$0 $0 $0 $0 $0
3 Establish or expand existing Network Operation Centre component, Resources, workstations,
Specialized Training, etc $0 $0 Serviced by existing staff, small enough project footprint to be negligible.$0 $0 $0 $0 $0
4 Estimated Transit Bandwidth Expenses (Based on Customer Growth Curve)$0 $0 $0 $0 $0 $0 $0
Other Network Back Office Expenses NOT Covered Above:
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
Network - Outside Plant Maintenance Expenses
Item Description Capital $Expense $Assumptions (Notes and Comments)YEAR #1 YEAR #2 YEAR #3 YEAR #4 YEAR #5
1 Field Maintenance & Repair Support, including Technician hand tools, safety equipment, Training
etc $0 $0 Serviced by existing staff, small enough project footprint to be negligible.$0 $0 $0 $0 $0
2 Corrective Maintenance - Outage Response $0 $5,000 $1,000 $1,000 $1,000 $1,000 $1,000
3
Peventative Maintenance - Tower site maintenance, Genset Oil changes, Regular excercising,
Battery levels, HVAC filters, antenna alignments, Construction Route Monitoring, Ped repairs,
anchor repairs, lashing wire repairs, pole changes etc…
$0 $3,750 $750 $750 $750 $750 $750
4 Network Construction & Physical Plant Repair Support $0 $0 $0 $0 $0 $0 $0
5 Network Maintenance Standby Pay - On Call $0 $0 $0 $0 $0 $0 $0
6 Vehicles, Insurance, Licensing, Operation and Maintenance $0 $0 $0 $0 $0 $0 $0
7 Network Test Instruments - OTDR, Power meter, Laptop, Fusion Splicer, Network Analyzers,
Annual S/W licenses, Annual S/W Maintenance $0 $0 $0 $0 $0 $0 $0
8 Fibre Reel Trailers, Conduit Reel, A/E Construction hardware, lashing wire, small lasher, brackets,
standoffs, strand,anchors, etc $0 $0 $0 $0 $0 $0 $0
9 Tower maintenance, Inspections, Anchor-Guy maintenance, $0 $0 $0 $0 $0 $0 $0
Other Network Maintenance Expenses NOT Covered Above:
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $8,750 $1,750 $1,750 $1,750 $1,750 $1,750
Network - Site and Equipment Maintenance Expenses
Item Description Capital $Expense $Assumptions (Notes and Comments)YEAR #1 YEAR #2 YEAR #3 YEAR #4 YEAR #5
1 Outside Plant Equipment - General Construction repairs, replacements, plant related degradation $0 $0 $0 $0 $0 $0 $0
2 Tower Site, Network Centres Site Maintenance, HVAC System, Standby Power System, Propane
tanks and system, Batteries, Grounds weed control, Gate/Fence, Security, Access roads etc.$0 $0 $0 $0 $0 $0 $0
3 Tower Site, Network Centre/POP Points - Monthly Equipment Checks - Fibre Transport $0 $0 $0 $0 $0 $0 $0
4 Tower Site, Network Centres/POP Points - Weekly Equipment Checks - Battery/Power System
Tests, HVAC Systems, Security systems, etc $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
Network - Technology Lifecycle Refresh
Item Description Percent (%)Capital $Assumptions (Notes and Comments)YEAR #1 YEAR #2 YEAR #3 YEAR #4 YEAR #5
1
BACKBONE NETWORK: Tower and Wireless Infrustructure, Outside Plant Lifecycle Refresh
(Example: Based on 40 year operating life of network gives 2.5% of total construction cost/year)2.0%$123 $25 $25 $25 $25 $25
2
LAST MILE NETWORK: Tower and Wireless Infrustructure, Outside Plant Lifecycle Refresh
(Example: Based on 40 year operating life of network gives 2.5% of total construction cost/year)2.0%$636 $127 $127 $127 $127 $127
$758 $152 $152 $152 $152 $152
Other Network Site and Equipment Maintenance Expenses NOT Covered Above:
5
TOTALS:
TOTALS:
TOTALS:
ICON - OPERATIONS COST ESTIMATE
TOTALS:
10
TOTALS:
Estimated Customer Growth Curve:OR - Check Network Build TA
5
Estimated Customer Growth Curve:ERROR - Check Network
Build TAB (C5)
14
Attachment #5 to Report LEG 01-21