Town Data and Pricing Worksheet

Viewing online will have limited functionality. Notice the tabs at the bottom to view the different sheets. Under is a link to download and you can view in Excel or a compatible spreadsheet program with full functionality.

IMPORTANT: This worksheet was updated on June 12, 2017. If you downloaded the earlier version, please download this corrected version.

Here’s a walkthrough of the spreadsheet requested by Plainfield, but can be used by others with appropriate substitution of the numbers.

WiredWest will charge each customer a retail rate for services.  WG+E will collect the retail payments from the customers and deduct their fixed wholesale cost per customer.  The wholesale cost that WG+E collects covers the following services:

Program Management will include

  • oversight of program implementation and
  • direct access to senior executive 24X7X365

Customer Service will include

  • Separate 800 number to Network Operator Call Center,
  • Customer Service personnel shall recognize customers based on phone number caller id where possible and then verify customer.
  • Customer Service personnel shall be trained to handle most issues using a knowledge base approach before escalation to Technical Support.
  • Physical Payment Center 8:30am to 5 pm, Monday – Friday, and
  • Call Center Account Agents available 8:30am to 5pm, Monday – Friday, answering as WW brand
  • Off hours answering service capable of escalating technical service problems to Network Support
  • Automated Customer satisfaction callback survey
  • Customer Service personnel will be capable of provision service to customer.

Sales and Marketing will include

  • custom branded correspondence,
  • Print materials will be developed and available for distribution by the towns
  • Direct Marketing
    • Constant Contact
    • Direct mail
    • Door to door
    • Events
    • Multilevel
    • Other
  • Local newspaper ads and articles
  • bi-monthly email literature Item, and
  • quarterly sales literature
  • Customer relationship management tools
  • Inbound sales calls through the customer service call center
  • Ongoing periodic educational events

Web Site will include

  • Custom branded web site to capture customer applications and interest
  • Built on Network Operator framework
  • Capable of provisioning customer network services
  • Capable of allowing the customer to turn their service on or off
  • Custom URL owned by WW
  • Reporting, Customer Relationship Management Item

Billing will include

  • Billing Template setup
  • Customer surcharges by WW Member Town
  • Custom branding as WW
  • Rates management
  • Physical bill presentment
  • Online bill presentment (optional at a cost)
  • Collections
  • Reporting
  • Tax payments, as required

Tech Support will include

  • Tier 1 Help Desk 24 X 7 -Phone Support
  • Tier 2 Help Desk 7 am -6 PM, Monday -Saturday
  • Tier 3 Network Support 24 X 7
  • Tier 1 Field Support -7am -6pm, Monday -Saturday
  • CPE Trouble Call Support 7am -10 pm, Monday -Saturday.
  • Field Trouble Call Support 7am -10 pm, Monday -Saturday.

Email will include

  • 5 email address per subscriber
  • Custom domain owned by WW
  • IMAP

Data Security

  • Compliance with M.G.L Chapter 93H and CMR 201 Standards of Personal Information of Residents of the Commonwealth
  • Backup of all customer data
    • Dailies for two weeks
    • Weeklies for two months
    • Monthlies for two years
    • Yearlies for duration of this agreement

Network Security will include

  • 1 license of TrendMicro
  • Backup of all network data
    • Dailies for two weeks
    • Weeklies for two months
    • Monthlies for two years
    • Yearlies for duration of this agreement
  • Protection from Denial of Service attacks

Network Monitoring

  • Load monitoring and reporting
  • Load balancing
  • High use customer monitoring for compliance of acceptable use policies

Legal and Regulatory will include

  • FCC Form 477 filing
  • FCC Form 499A filing
  • Digital Content Millennium Act (DCMA) administration
  • Communications Assistance for Law Enforcement Act (CALEA) management

VolP services will include

  • Customer Service as described in above
  • Legal and regulatory: Universal Service Fund fees, taxes, and fee calculation.

VolP Features will include:

  • Free U.S. calling
  • Caller-ID and call-waiting
  • One-touch voicemail access
  • Online call log
  • Fax Mode
  • Optional Bluetooth Adapter
  • The utmost voice clarity
  • Caller-ID blocking
  • Remote Voicemail Retrieval
  • Online Preferences
  • Live Customer Support
  • 911 Service Call Hold
  • Enhance 911
  • Online Voicemail Playback
  • Area Code Selection
  • Encrypted calls
  • 911 Email and Text Alerts
  • Call Return
  • Online phonebook
  • 7/l0-Digit Dialing
  • Optional WiFi Adapter
  • Free calling to Canada
  • Caller Name
  • Anonymous call blocking
  • Voicemail alerts
  • Private Device
  • Instant Second Line™
  • Voicemail monitoring
  • Call forwarding
  • Voicemail-to-email forwarding (audio)
  • Private Voicemail
  • Three-way conferencing
  • Do not disturb
  • Online Voicemail Playback
  • Multi-Ring
  • Personal Number
  • Backup Number
  • Community blacklist
  • Free Mobile Minutes
  • Voicemail-to ­text ($4.99/month)
  • Google Voice Extensions

Construction and repair personnel as required

  • Construction equipment, materials
  • Traffic control
  • Testing
  • Splicing
  • Repair stock
  • Supervision

On the Income Expense tab of the spreadsheet you will see the operating costs that are not covered by WG+E and will be paid by WW out of the balance of the retail fees that WG+E will remit to WW on a monthly basis. These include insurance, pole bonding and licensing, maintenance, backhaul, and miscellaneous expenses such as electricity for the huts, legal and accounting services, etc. which for Plainfield acting on its own and not part of the WW network would cost $83,154 per year.  If all of the customers in Plainfield were taking the $59 25mbps service and no phone, then 235 customer would be required or 75% take rate to generate enough excess revenue to pay the operating costs.  However, because WW negotiated rates based on 5,000, 10,000, 15,000 and 20,000 customer the wholesale rates for WW customers are less than what an individual town could get.  Which means that Plainfield customers would have to pay a higher retail rate in order to generate sufficient revenue to cover operating expenses.  The last column on the Income Expense tab is Plainfield’s estimated portion of the excess revenue that is generated from the subscriber fees.  This varies obviously by the overall and individual town take rates and product mix.  So if all customers in all towns took only the $59 25mbps service and not phone at a 50% take rate then the excess revenue that Plainfield could be eligible for would be $12,667.  If you change the parameters to a 70% take rate with a product mix of half the customers taking phone service and half of taking the $59 service and half taking the $75 service then the excess revenue that could be distributed to Plainfield would be $62,187.  

On the Depr Debt tab you see the excess revenue in the first light blue columns, the next light brown column shows the depreciation reserves necessary to replace the electronics every 10 years.  For Plainfield that is $9,175 per year or $3 per customer per month at a 70% take rate.  The purple columns deal with the debt service.  For Plainfield, if the cost of construction equal the estimated cost, then the debt service is $78,933 per year for principal and interest or if the debt service is added to the customers bills it would be $25 per month at a 70% take rate.  However if the debt service is paid for by taxes then the average household in Plainfield would pay $16 per month.  

Given the potential for Plainfield to receive $60,000 per year in profit sharing it is recommended that the depreciation reserves and debt service not be added to the customers’ bills.  Keeping the customers’ bills low will increase the take rate which will increase the revenue which will increase Plainfield’s share of the profit sharing which may cover most if not all of the debt service and depreciation reserves.