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