Appendix D8 Pricing Instructions.docx

State of Colorado Microwave Backhaul Network Appendix D8 Pricing Instructions

General Instructions

1. Although completion of the Proposal Pricing Forms is mandatory, the formulas within the spreadsheets are provided for convenience only and are not required to be used. RESPONDENT IS RESPONSIBLE FOR THE ACCURACY OF ALL DATA AND ALL TOTALS, INCLUDING ANY ERRORS OR OMISSIONS RESULTING FROM THE FORMULAS PROVIDED THEREIN.

2. The word "OPTIONAL" indicates that the product/service is optional for the State to purchase, but it IS NOT OPTIONAL FOR THE RESPONDENT TO PRICE IT. RESPONDENT MUST COMPLETE ALL TABS IN THIS ATTACHMENT.

3. This workbook contains ten pricing Tables (D8.1 – D8.10). Each spreadsheet contains a table that may consist of sub tables (i.e., D8.1.A, D8.1.B, etc.) for Respondent to complete.

Table D8.1 - Total Price Summary Instructions

1. This pricing worksheet is composed of the following three tables:

a. TABLE D8.1.A - Base Equipment and Services

b. TABLE D8.1.B - OPTIONAL Tower Structures and Analyses

c. TABLE D8.1.C - OPTIONAL Rectifier Systems and Batteries

2. The System Equipment prices (for all microwave rings) in Rows 4 – 7 of Table D8.1.A will populate automatically with completion of the following tables:

a. Table D8.2 - Ring 1 Site Prices

b. Table D8.3 - Ring 2 Site Prices

c. Table D8.4 - Ring 3 Site Prices

d. Table D8.5 - Ring 4 Site Prices

e. Table D8.6 - Ring 5 Site Prices

3. The Recommended Spare and Test Equipment price in Row 8 of Table D8.1.A will populate automatically with completion of Table D8.8 - Spare and Test Equipment

4. The EQUIPMENT SUBTOTAL will populate automatically.

5. The System Services prices (for all microwave rings) in Rows 11 – 18 of Table D8.1.A will populate automatically with completion of TABLE D8.7 - Base Proposal Services Prices.

6. The SERVICES SUBTOTAL will populate automatically.

7. The BASE PROPOSAL SUBTOTAL will populate automatically.

8. In Rows 21 – 23, the Respondent shall list the discounts or incentives, if any, for System Infrastructure, Equipment Trade In, and/or Contract Execution Date.

9. The Respondent shall provide an Estimated Tax on Equipment in Row 24.

10. The Respondent shall provide a Performance Bond price in Row 25.

11. The BASE PROPOSAL GRAND TOTAL will populate automatically.

12. The Tower Structures and Analyses prices (for all microwave rings) in Row 29 of Table D8.1.B will populate automatically with completion of the following tables:

a. Table D8.2 - Ring 1 Site Prices

b. Table D8.3 - Ring 2 Site Prices

c. Table D8.4 - Ring 3 Site Prices

d. Table D8.5 - Ring 4 Site Prices

e. Table D8.6 - Ring 5 Site Prices

13. In Row 30, the Respondent shall provide a total price for Engineering, Installation, and Removal services for all proposed tower work. This price includes, but is not limited to, site design and construction, foundation work, tower erection, hardware and equipment installation, removal of existing tower structure, and site documentation development.

14. In Rows 31 and 32, the Respondent shall provide total prices for Construction Management and Project Management, respectively, for all proposed tower work.

15. In Row 33, the Respondent shall provide a total price for Delivery/Shipping of all proposed tower equipment.

16. In Row 34, the Respondent shall list the discount(s) or incentive(s), if any, for Structural Analyses, Tower Equipment, and/or Contract Execution Date.

17. In Row 35, the Respondent shall provide an Estimated Tax of all proposed tower equipment.

18. In Row 36, the Respondent shall provide a Performance Bond for all proposed tower work.

19. The TOWER SUBTOTAL will populate automatically.

20. The Rectifier Systems and Batteries prices (for all microwave rings) in Row 40 of Table D8.1.C will populate automatically with completion of the following tables:

a. Table D8.2 - Ring 1 Site Prices

b. Table D8.3 - Ring 2 Site Prices

c. Table D8.4 - Ring 3 Site Prices

d. Table D8.5 - Ring 4 Site Prices

e. Table D8.6 - Ring 5 Site Prices

21. In Row 41, the Respondent shall provide a total price for Engineering, Installation, and Removal services for all proposed rectifier and battery work. This price shall include, but is not limited to, site design and construction (if any), hardware and equipment installation, removal of existing rectifiers and batteries, and site documentation development.

22. In Rows 42 and 43, the Respondent shall provide total prices for Construction Management and Project Management, respectively, for all proposed rectifier and battery work.

23. In Row 44, the Respondent shall provide a total price for Delivery/Shipping of all proposed rectifier and battery equipment.

24. In Row 45, the Respondent shall list the discount(s) or incentive(s), if any, for Equipment Volume, Equipment Trade In, and/or Contract Execution Date.

25. In Row 46, the Respondent shall provide an Estimated Tax of all proposed rectifier and battery equipment.

26. In Row 47, the Respondent shall provide a Performance Bond for all proposed rectifier and battery work.

27. The POWER SUBTOTAL will populate automatically.

28. The PROPOSAL WITH OPTIONS GRAND TOTAL will populate automatically.

Table D8.2 - Ring 1 Site Prices Instructions

1. This pricing worksheet is for Respondent to list and price equipment, services, and optional items on a site-by-site basis. ITEMIZE each proposed item for this ring in the subsystem categories listed in Column A.

2. Enter a Site Name on Row 2 for each of the proposed sites. The worksheet includes placeholders for up to 60 total sites; however, this does not indicate a required number of sites. Only include pricing data for the sites included in the proposed design. Enter a Site Description on Row 3 for each of the proposed sites. This Site Description shall clearly identify if the site is a ring site, spur site, relay site, etc.

3. For each proposed item, Respondent shall enter a unit price and quantity in their respective columns. The extended price column will populate automatically. Enter a discount percent in the Column labeled Discount %. The discounted price column will populate automatically. Repeat these steps for all subsystem categories and all sites included in the proposed design.

4. Respondent shall include pricing for Microwave Radio Equipment, Software, and Licensing needed for proposed sites. Microwave radio equipment includes, but is not limited to, non-standby radios, monitored hot standby radios, software, licensing, racks, and accessories, etc. Add additional rows as necessary.

5. Respondent shall include pricing for Networking Equipment, Software, and Licensing. Networking equipment includes, but is not limited to, routers, switches, gateways, firewalls, network time protocol (NTP) servers, virtual private network (VPN) servers, optical fiber interface units, etc. Add additional rows as necessary.

6. Respondent shall include pricing for Network Monitoring and Fault Management Equipment, Software, and Licensing. Network monitoring and fault management equipment includes, but is not limited to, Network management system (NMS) servers and software, licenses, network management terminals (NMT), fault management server, remote terminal units, etc. Add additional rows as necessary.

7. Respondent shall include pricing for Antenna, Waveguide and Dehydrator Systems. Antenna systems include, but are not limited to, single and dual polarization antennas, high performance and parabolic dishes, reflector antennas, radomes, elliptical waveguide, automatic dehydrators, mounting hardware, lightning protectors, ground kits, entry ports, etc. Add additional rows as necessary.

8. Respondent shall include pricing for System/Network Engineering Services, including, but not limited to:

a. Design and engineering

b. Graphical path profiles

c. Physical path surveys

d. Interference analyses

e. FCC license preparation

f. Frequency coordination

g. Quality of Service plan

h. Configuration and optimization

i. Acceptance testing

j. As-built documentation

9. Respondent shall include pricing for Installation, Testing and Removal Services, including, but not limited to:

a. Installation and testing of microwave radios, routers, switches, and NMS/NMT equipment

b. Installation and testing of antenna, waveguide, and dehydrator systems

c. Installation and testing of lightning protection and grounding systems

d. Removal of old microwave radios, networking equipment, and antenna systems

10. Pricing for Installation, Testing and Removal Services shall also include:

a. Inventory and storage of decommissioned equipment for 12 months after System Acceptance

b. Migration services, if any, for temporary lease space (during transition period) on tower, building, shelter, etc.

11. Respondent shall include pricing for OPTIONAL Tower Structures and Analyses, including, but not limited to:

a. Structural Analysis performed by a Colorado Registered Professional Engineer

b. Tower steel, climbing ladder, cable bridge, grounding system, obstruction lighting (where required), new waveguide entry panel, and all necessary bolts, washers and nuts

c. Material and necessary components for a fully functional tower foundation/anchor system

12. Respondent shall include pricing for OPTIONAL Rectifier Systems and Batteries, including, but not limited to:

a. Power shelf with rectifier(s), controller, distribution panel, and other hardware

b. Valve regulated lead acid (VRLA) batteries, seismic racks, and safety solutions

13. After entering pricing data for all base and OPTIONAL equipment at proposed sites, the Totals will populate automatically in column B. These Totals will automatically populate the discounted prices in Table D8.1.A, Table D8.1.B, and Table D8.1.C.

Table D8.3 - Ring 2 Site Prices Instructions

1. This pricing worksheet is for Respondent to list and price equipment, services, and optional items for Ring 2 on a site-by-site basis. ITEMIZE each proposed item in the subsystem categories listed in Column A.

2. The worksheet includes placeholders for up to 60 total sites; however, this does not indicate a required number of sites. Only include pricing data for the sites included in the proposed design.

3. Use pricing instructions provided for Table D8.2 - Ring 1 Site Prices to complete this worksheet.

4. After entering pricing data for all proposed equipment and sites, the Totals will populate automatically in column B. These Totals will automatically populate the discounted prices in Table D8.1.A, Table D8.1.B, and Table D8.1.C.

Table D8.4 - Ring 3 Site Prices Instructions

1. This pricing worksheet is for Respondent to list and price equipment, services, and optional items for Ring 3 on a site-by-site basis. ITEMIZE each proposed item in the subsystem categories listed in Column A.

2. The worksheet includes placeholders for up to 60 total sites; however, this does not indicate a required number of sites. Only include pricing data for the sites included in the proposed design.

3. Use pricing instructions provided for Table D8.2 - Ring 1 Site Prices to complete this worksheet.

4. After entering pricing data for all proposed equipment and sites, the Totals will populate automatically in column B. These Totals will automatically populate the discounted prices in Table D8.1.A, Table D8.1.B, and Table D8.1.C.

Table D8.5 - Ring 4 Site Prices Instructions

1. This pricing worksheet is for Respondent to list and price equipment, services, and optional items for Ring 4 on a site-by-site basis. ITEMIZE each proposed item in the subsystem categories listed in Column A.

2. The worksheet includes placeholders for up to 60 total sites; however, this does not indicate a required number of sites. Only include pricing data for the sites included in the proposed design.

3. Use pricing instructions provided for Table D8.2 - Ring 1 Site Prices to complete this worksheet.

4. After entering pricing data for all proposed equipment and sites, the Totals will populate automatically in column B. These Totals will automatically populate the discounted prices in Table D8.1.A, Table D8.1.B, and Table D8.1.C.

Table D8.6 - Ring 5 Site Prices Instructions

1. This pricing worksheet is for Respondent to list and price equipment, services, and optional items for Ring 2 on a site-by-site basis. ITEMIZE each proposed item in the subsystem categories listed in Column A.

2. The worksheet includes placeholders for up to 60 total sites; however, this does not indicate a required number of sites. Only include pricing data for the sites included in the proposed design.

3. Use pricing instructions provided for Table D8.2 - Ring 1 Site Prices to complete this worksheet.

4. After entering pricing data for all proposed equipment and sites, the Totals will populate automatically in column B. These Totals will automatically populate the discounted prices in Table D8.1.A, Table D8.1.B, and Table D8.1.C.

Table D8.7 - Base Proposal Services Prices Instructions

1. This pricing worksheet is for Respondent to provide prices for system services and training.

2. On Row 3, Respondent shall provide pricing for Staging Acceptance Testing of a complete system.

3. On Row 4, Respondent shall provide pricing for Delivery/Shipping of a complete system.

4. On Row 5, the System/Network Engineering Services price will automatically populate with completion of Tables B.2 through Table D8.6.

5. On Row 6, the Installation, Testing and Removal Services price will automatically populate with completion of Tables B.2 through Table D8.6.

6. On Row 7, Respondent shall provide pricing for Project Management and any other services needed for a complete system implementation (all microwave rings).

7. In Rows 8 and 9, Respondent shall specify and provide pricing for any other service(s) not listed.

8. The SUBTOTAL for System Services will populate automatically.

9. In Row 12 – 19, Respondent shall provide pricing for technical and system management training for staff responsible for maintaining and managing the system. Example courses are listed, but Respondent can modify with their recommended training for the proposed system.

10. In Rows 20 and 21, Respondent shall specify and provide pricing for any other training not listed.

11. The SUBTOTAL for System Training will populate automatically.

12. The TOTAL SERVICES will populate automatically.

13. Completion of Table D8.7 will automatically populate the System Services prices (Rows 11 - 18) in Table D8.1.A.

Table D8.8 - Recommended Spare and Test Equipment Instructions

1. Respondent shall itemize the recommended initial outfitting for spare equipment, test equipment, and spare parts to be purchased by the State with the Base Proposal system.

2. Examples of items include, but are not limited to, complete base radios, antennas, dehydrators, field replaceable units, circuit boards, power supplies, routers, switches, test equipment, calibration equipment, diagnostic equipment, and repair kits.

3. Respondent shall determine the types and quantities of spare and test equipment based on their proposed design. The spare and test equipment shall be distributed evenly between the State’s 13 radio shops.

4. For each item, enter a part number, item description, unit price and quantity in their respective columns. The extended price column will populate automatically. Enter a discount percent in the Column labeled Discount %. The discounted price column will populate automatically. Repeat these steps for all recommended items. Add additional rows as necessary.

5. The TOTAL SPARE AND TEST EQUIPMENT price at the bottom of the list will automatically populate the discounted price in Row 8 of Table D8.1.A.

Table D8.9 - System Lifecycle Support Instructions

1. This pricing worksheet is for items and services that the State will consider for purchase in the future (not delivered as part of initial system replacement project). It is NOT optional for the Respondent to provide System Lifecycle Support prices. Respondent shall provide a detailed list (with discount structures) for equipment, spares, and services needed to support the system during the life of the contract. As an alternate method to providing this pricing, Respondent may choose to use and modify this Table as needed. The Respondent must provide a category list of parts, components, subassemblies and services broken down by discount offered in each category. As an example: radio subassemblies such as power supplies, exciter, and power amplifiers are discounted at X% and server subassemblies are discounted at Y%, etc.

2. The State plans on purchasing items and services at a fixed discount rate off of the List Price published at the time of purchase. The Discount % entered on this Table (or Respondent provided price list) would stay the same during the life of the contract.

3. In Table D8.9.A, enter the List Price (in column B) and the Fixed Discount off of List Price (in column C) for each equipment and component item. The discounted price will populate automatically. Add additional rows as needed.

4. EXAMPLES OF EQUIPMENT AND COMPONENT ITEMS ARE: complete base radios, antenna systems (antenna, waveguide, dehydrator, etc.), field replaceable units, circuit boards, power supplies, routers, switches, parts, test equipment, calibration equipment, diagnostic equipment, repair kits, software, software licensing, etc.

5. In Table D8.9.B, enter the daily or hourly rate (in column B) and any applicable discount (in column C) for each service that can be provided. Add additional rows as needed. A predefined annual increase in the base rates may be proposed but the discount percentage offered from that base rate will remain for the duration of the contract.

6. EXAMPLES OF FUTURE SERVICES ARE: design and engineering, structural analyses, physical path surveys, field support services, construction and project management, etc.

Table D8.10 - OPTIONAL System Post-Warranty Support Instructions

1. This pricing worksheet is for the OPTIONAL Post-Warranty Support. IT IS NOT OPTIONAL FOR THE RESPONDENT -- ALL PRICES MUST BE INCLUDED.

2. In Table D8.10.A, Respondent shall list the prices for TECHNICAL SUPPORT for Years 4 - 15. The State may or may not choose to purchase any of these line items in conjunction with the Base Proposal components. Respondent can also provide a bundled price for 5-year increments, Years 4 – 15 or any combination thereof.

3. In Table D8.10.B, Respondent shall list the prices for SOFTWARE SUPPORT AND UPGRADES for Years 4 - 15. The State may or may not choose to purchase any of these line items in conjunction with the Base Proposal components. Respondent can also provide a bundled price for 5-year increments, Years 4 – 15 or any combination thereof.

4. In Table D8.10.C, Respondent shall list the prices for all EXTENDED WARRANTY available beyond the 3-year system warranty for all supplied equipment. The State may or may not choose to purchase any of these line items in conjunction with the Base Proposal components. Respondent can also provide a bundled price for Years 4 – 8 or any combination thereof.

Appendix D8 1 Cost Proposal Summary

1. Please complete and sign the Cost Proposal Summary Appendix D8 1 as well as the detailed Appendix D8 cost proposal form.