headermask image

Business Tools Blog

Are people becoming less considerate?

Photobucket

Are you Considerate of Others?

The conference room picture shown on the right, may not seem especially messy, but that isn’t the point.  A group of people met, drank 4 bottles of water and 2 Diet Cokes.   2 of the people in the meeting cleaned up after themselves.  4 left a mess for someone else to clean up. There is a trash can in the room, right before the exit door, so tossing an empty bottle would take very little effort.

This seems to be a theme for me this week.

Incident #1: The doctor’s office

On Saturday, I took my daughter for her annual physical.  We were about 10 steps from the double entry glass door, when we spotted an elderly woman carrying an oxygen tank exiting the building - she had just entered the foyer when we caught sight of her.  She wasn’t moving very quickly, and I hurried forward to open the door.  Just then, a young man - in his twenties - shot past her.  He opened the door and then dropped it so that it swung back and hit her.  I was horrified.  She looked like she was about to cry.  The man didn’t even look back.

Incident #2: Dogs on the lawn

Last night, my husband and I were sitting on the porch talking.  A man, woman and their dog walked by.  The dog pooped on our lawn.  The couple walked on without cleaning up after the dog.  (We live on a park, and there are free bags and a trash can less than 20 feet from where the incident took place.  There is sign on the trash can that says $250 fine for not cleaning up after your dog.)  My husband followed them (he’s from Chicago) and asked them to please come back and clean up their dog’s mess.  The man said, “No” and walked on without a care in the world.

Incident #3: Merging in traffic

Every morning I merge onto I-36.  A few days ago, there were no cars in the right lane, so I turned on my turn signal and started to merge.  As I started to move over, the car behind me moved to the right lane and cut me off.  I had to swerve to avoid being hit.

The theme through the above stories is people being inconsiderate (lacking in care or thought for others; thoughtless).

I remember a lesson that I learned in 8th grade on an algebra final.  The last question was:

What is the name of the woman who cleans the school?

When asked, Mr. Hoffman assured us that the question counted.  He further explained that it is important to be considerate, especially with those who take care of you. I am sad to report that I missed that question, but the lesson stuck with me.   Being considerate and showing appreciation are extremely important, both in business and in your personal life.

I may add this to the interview process.  I could take the interviewee to a conference room.  If he/she leaves a mess, I will know that they shouldn’t be hired for any job that requires basic human consideration.

Change the default address list, Microsoft Outlook

Photobucket

Tips and tricks
By Jason Tibbs

Your system administrator probably set up the default address list in Microsoft Outlook.  But what if you want to change the default address list?

Step 1: On the main Outlook menu: select Tools>Address Book

Photobucket

Step 2: “Address Book” menu: select Tools>Options

Photobucket

Step 3: On the “Addressing” menu:

  1. Select the address list that you want to use as your default
  2. Select the order that Outlook should check addresses (Use the up and down arrow keys to reorder the address lists)
  3. Click Apply

Photobucket

That’s all there is to it.

Great Article on Zayo in Telephony Online today

Dan Caruso of BearonBusiness spoke on the Maximizing Transport Assets panel at the 2008 COBANK Communications Industry Executive Forum in Beaver Creek, CO, yesterday.

The 4 person panel discussion included:

Dan Caruso, President & CEO Zayo Group
Andy Newton, President & CEO Southern Light
Bachchi Oumar, CFO Syringa Networks
John Summersett, VP Bus Development Great Lakes Comnect

I wasn’t at the conference, so I couldn’t take notes.  Fortunately, Ed Gubbins of Telephony Online captured the spirit of the discussion in this article: Zayo: CLEC woes mean buyer’s market for fiber

Google Account, link multiple non Gmail email addresses

With the proliferation of Google Aps, you might find yourself wishing that there was a way to have one log-in to Google that recognizes all of your email addresses.

For example, if your work email is linked to several Google Groups and you also have personal groups linked to your gmail or yahoo emails, you can associate them all to your Google account.

1.  Click My Account

Photobucket

2.  Click Edit

Photobucket

3.  Add an email address

Photobucket

A Google Calendar invite sent to any email address will show up in your Google accounts calendar.  Also, if you are invited to a Google Group with a non-Google email, that address can be used without having to maintain multiple accounts.

Forecast Recurring Revenue with Weighted Average Install Interval

Weighted Average adds a volume dimension to a plain average calc.  Each quantity being averaged is assigned a weight.

Example: What if we were trying to determine the average install interval (the time between when a product is sold and when it is installed)?

We could use the average (sum up all of the days shown below in column B and divide by 20). This calculation would = 43 day average install interval.

Photobucket

But what if we were going to use the install interval to forecast recurring revenue?  We would need to know the weighted average install interval.  (i.e. the larger the revenue, the higher the weight.)

We could do this manually:  [(180*1,000,000)+(75*900,000)+(80*810,000)+ … +(6*135,085)]/8,784,233 = 63 days.

Or, use Excel’s sumproduct function.  Sumproduct multiplies 2 columns of data by each other, in the same way that the manual formula above multiplies columns B and C.  How to:

  1. SUMPRODUCT(B2:B21,C2:C21) multiplies B2*C2+B3*C3+B4*C4 +…+B21*C21
  2. Divide SUMPRODUCT(B2:B21,C2:C21) by the sum of the Revenue 8,784,233
  3. The total is a 63 day weighted average

Photobucket

Why use Weighted Average instead of the Average Days to Install?

The average days to install metric to use in a revenue forecast would be the weighted average of 63 days to install service.  20 days might not seem like a big deal, but if you use the rule of 78’s the compounding effect is huge.

The example below shows how $10K/mo. in sales on the first day of each month converts to revenue if the install interval is 43 days.  e.g. a sale on Jan 1st would be installed on Feb 12th.  The revenue for Feb would be for 17 days or 59% of the month.   The annual revenue in this example is $614,701.

Photobucket

The chart below shows that a 63 days install interval would result in $543,140 in annual revenue.

Photobucket

With just $10K per month in sales, the annual difference in revenue is $71,516.  If you were selling $100K per month the annual difference in the forecast would be $710,516.

Understanding the weighted average install interval is extremely important if you want to forecast recurring revenue accurately.

The above examples also show why getting installs done just a few days faster can yield a lot more revenue.  With Zayo’s bonus and commission plans, more revenue = more bonus and more commission!

Link Excel Chart Titles, How to

Most folks create static chart titles using the “Chart Options” menu in Excel.

Photobucket

Excel has an easy trick to link the chart title to any cell, without using the “Chart Options” menu.  How to:

  1. After the chart is created, use the cursor to click the title that you want to link
  2. In the formula bar type “=”
  3. Click on the cell that you want the title to link to (I linked to cell D1)  the name of the worksheet is “pareto”

Photobucket

The title is linked. Anytime cell D1 changes, the title in the chart will update automatically.  You can use the same methodology to link the x axis title and the y axis title to cells.

A Puzzle, Can you figure it out without cheating?

“You’re trapped in a car like a bad mafia movie. It’s either figure out a way to escape or die trying. Can you click your way to freedom?”   Escape the Car Game

Explore the vehicle, gather and combine items by clicking on them with your mouse.  Just for fun, see how quickly you can get out!

Photobucket

Caution: Men at Work

Photobucket

Women work all the time.  Men have to put up signs when they work.

Friday afternoon fun

This has nothing to do with business, but when I saw this yesterday I laughed so hard that I cried.

This has to be the worst wedding cake in history.  Can you imagine being served a piece of the head?  or worse … Yikes!

Photobucket

The blog Cake Wrecks features more horrifying cakes. But this one is clearly the worst.

For grins, Cake Wrecks points out that the baker took a little artistic license with the red rick-rack, and it looks like the bride just notices and is giving it the evil eye.

Google Desktop, timesaver

Have you ever spent hours looking for a file on your PC?  or tried to locate that elusive email?

Google Desktop is a great solution to quickly sort through the zillions of files and emails on your PC.  The search is as fast as any Google web search.

For example -I did a search on my computer, that resulted in 5,396 emails (it even searched deleted emails); 1,821 files and 3,768 web visits.

Photobucket

If I choose to only look at the 1,821 files, Google lets me refine the search to the type of file:

Photobucket

Google Desktop Searches:

  • Word
  • PowerPoint
  • Excel
  • Text
  • Web History - view web pages you´ve seen, even when you´re not online
  • pfd
  • Images
  • Video
  • Music
  • Zip

Click here to download Google desktop.