I received these questions from Trevor yesterday … and thought that others might benefit from the answers:
Trevor writes:
I’m doing a project for Accounting and I’m having some problems with excel, so I thought I’d say hi and ask for help since I haven’t heard from you in a while =)
Question 1:
I have a spreadsheet and […]
April 30, 2008 – 12:13 am
Let’s start with who measures churn? Answer: The stakeholders:
CRM, Sales and Marketing
Service Delivery
Billing/Revenue Assurance
Zayo uses a methodology that I describe as Balancing the Checkbook to measure net installs (net installs = gross installs less churn).
Step 1 –
The CRM, Sales and Marketing organizations gather information from customers about potential churn before orders come in. They share […]
April 27, 2008 – 12:14 am
Before toolbars, we used shortcut keys to navigate thru Microsoft applications. While the toolbars are nice to have, they take more time than using a shortcut key.
Rather than list all the shortcut keys, I will list the shortcuts that I use. Add a few of these to your repertoire and you’ll increase your speed in excel.
[…]
April 26, 2008 – 12:00 am
Where to start?
I thought I’d start with first page ever posted on Zayo’s Intranet. We have Lexicon built around financial definitions. We want everyone to have a reference to key business terms.
· Adjusted EBITDA: EBITDA revised to exclude non-cash/stock based compensation, transaction costs, loss/gain on sale of assets, other (non-operating) income
· Amortized Install Charges: […]
I am hoping that this blog serves as a conduit for organizational dialogue. The aspiration is that this blog will share tribal knowledge … not just at Zayo, but across the Telecom industry.
Abraham Maslow said, “If the only tool you have is a hammer, you tend to see every problem as a nail.” […]