4/13/11

How To Calculate The Weekday For Any Date On The Julian Or Gregorian Calendar

The following formula is used to calculate the weekday for any date on the calendar:

Century + Year + Month + Day = Weekday

Each of the words century, year, month, and day represents a number that is used to offset all of the other numbers in the formula. The sum of the offsets yields a number that represents the weekday.

In order to develop the proper offsets, let us begin with the simplest scenario, the first day of the first month of the first year of this century. January 1, 1900 fell on a Monday.

Since this century is the 1900's, let us make the century offset 0 when Century = 19. In this way, we can ignore the century offset for all dates in this century, and so only need deal with Year + Month + Day.

To continue making January 1, 1900 as simple as possible, let us make the offset 0 when Year is 00 and make the offset 0 when Month is January. Thus:


Century (19)+ Year (00) + Month (1)+ Day (1)= Weekday
Offsets: 0+ 0+ 0+ 1= Monday

Since the offset for the century, the year, and the month all equal 0 for January 1900, we can forget about them for the present. We therefore only need to deal with the conversion of the day of the month to the weekday.

Day Offset

As the 1st day of this month falls on a Monday, let us assign Monday a value of 1. The 2nd day of the month has a value of 2, and as the day after Monday is Tuesday, we assign Tuesday the value of 2. In like manner, the first seven days of the month have the following values:

Day Offsets

Weekday

Numeric Value

Monday

1

Tuesday

2

Wednesday

3

Thursday

4

Friday

5

Saturday

6

Sunday

7

January 7 falls on day 7, and 7 corresponds to Sunday. On what day does January 8 fall? On any calendar you will notice that the 8th of any month falls on the same day as the 1st of the month, which falls on the same day as the 15th, the 22nd, and the 29th of the month. Therefore, if we subtract one week (7 days) from the January 8, we have January 1, which we know is a Monday. January 8 is therefore a Monday.

This process of subtracting weeks from the 8th, 15th, 22nd, 29th etc. to achieve a number equal to or less than 7 is called modulo ("mod," for short). The word modulo is usually represented in computer languages as %. To find a number such as 20 % 7, divide 20 by 7, and keep only the remainder. 20 / 7 = 2 remainder 6. 20 % 7 = 6. The 20th falls on the same weekday as the 6th.

(Please note that multiplication, which is usually indicated by an x in mathematics, as in 3 x 2 = 6, is usually indicated by an * in computer languages, as in 3 * 2 = 6. Multiplication will be indicated by an * here.)

January 28 falls on 28 % 7 = 0. Which day of the week corresponds to 0? Sunday. We assigned Sunday a value of 7, but 7 % 7 = 0, and so we will modify the weekday values as follows:

Day Offsets

Weekday

Numeric Value

Sunday

0

Monday

1

Tuesday

2

Wednesday

3

Thursday

4

Friday

5

Saturday

6

We can now calculate the weekday for any date in January. Let us now calculate the month offsets.

Month Offset

January is the first month, and so we assigned January an offset of 0. January has 31 days. January 31 falls on 31 % 7 = 3 = Wednesday. Whenever January 1 falls on a Monday, February 1 falls on a Thursday, 3 days later. The February offset equals 0 (January offset) plus 31%7 = 3 (number of days in January). 0 + 3 = 3. Thus, for example, February 2 would fall on 3 (February offset) + 2 (Day offset) = 5 (Friday).

February has 28 days (in a non leap year). 28 % 7 = 0. February 28 falls on 3 (February offset) + 0 (28 % 7) = 3 = Wednesday. Whenever February 1 falls on a Thursday, March 1 also falls on a Thursday, in a non leap year. The March offset equals 3 (February offset) plus 28%7 = 0 (number of days in February). 3 + 0 = 3. Thus, for example, March 12 would fall on 3 (March offset) + 12 (Day offset) = 15 % 7 = 1 (Monday).

Month Offsets

Month

Offset

Days

Days % 7

Add to next month's offset

January

0

31

3

+3

February

3 (0+3)

28

0

+0

March

3 (3+0)

31

3

+3

April

6 (3+3)

30

2

+2

May

1 (6+2=8,%7)

31

3

+3

June

4 (1+3)

30

2

+2

July

6 (4+2)

31

3

+3

August

2 (6+3=9, %7)

31

3

+3

September

5 (2+3)

30

2

+2

October

0 (5+2=7, %7)

31

3

+3

November

3 (0+3)

30

2

+2

December

5 (3+2)

31

3

+3

The month offsets, which can easily be remembered to enable quick calculation of the weekday, are as follows:

Month Offsets

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Offset

0

3

3

6

1

4

6

2

5

0

3

5

Year Offset

The month offset for December is 5. December has 31 days. 31%7=3. 5 (December offset) + 3 (number of days in December) = 8. 8%7=1. January, the month after December, has an offset of 1. Thus, if January 1 of one year falls on a Monday, and if it is not a leap year, then January 1 of the following year will fall on 365 % 7 = 1 (new year offset) + 0 (January offset) + 1 (Day offset) = 2 (Tuesday).

Each year begins 1 day later in the week than the previous year, if the previous year is a non-leap year. The year 00, as in 1900, was previously assigned a year offset of 0. The year 1 would therefore have a year offset of 1. The year 2 would have a year offset of 2. The year 3 would have a year offset of 3. The year 4 begins with a year offset of 4. However, in a leap year February has 29 days. We accommodate this by adding 1 to the year offset in leap years. When calculating the weekday for a date in January or February of a leap year, we must subtract 1 from the year offset, as the leap day has not arrived yet. As every 4th year is a leap year, the year offset can be quickly calculated as Year + Year/4. (Remember that a year that ends in 00 is not a leap year in the Gregorian calendar unless it is also a multiple of 400.)

Year Offsets

Years

Offset

6, 17, 23, 28, 34, 45, 51, 56, 62, 73, 79, 84, 90

0

1, 7, 12, 18, 29, 35, 40, 46, 57, 63, 68, 74, 85, 91, 96

1

2, 13, 19, 24, 30, 41, 47, 52, 58, 69, 75, 80, 86, 97

2

3, 8, 14, 25, 31, 36, 42, 53, 59, 64, 70, 81, 87, 92, 98

3

9, 15, 20, 26, 37, 43, 48, 54, 65, 71, 76, 82, 93, 99

4

4, 10, 21, 27, 32, 38, 49, 55, 60, 66, 77, 83, 88, 94

5

5, 11, 16, 22, 33, 39, 44, 50, 61, 67, 72, 78, 89, 95

6

Now, for some examples:

January 1, 1999:

Century offset: 0 for 1900's
Year offset: 99 + 99/4 = 99 + 24 = 123. 123%7 = 4
Month offset: 0 for January
Day offset: 1
Weekday: 0 + 4 + 0 + 1 = 5 = Friday

January 1, 1999 fell on a Friday.

February 14, 1920

Century offset: 0
Year offset: 20 + 20/4 -1 (this is a leap year, and leap day has not arrived yet)

20 + 5 - 1 = 24. 24%7 = 3.
Month offset: 3
Day offset: 14. 14%7 = 0
Weekday: 0 + 3 + 3 + 0 = 6 = Saturday

February 14, 1920 fell on a Saturday.

Century Offset (for the Gregorian Calendar)

Each century has 100 years. 100 years has a total year offset of 100 + 100/4 = 125. 125%7 = 6. This calculation assumes 25 leap years in a century which, on the Gregorian calendar, is only true for centuries that are multiples of 400; i.e., 400, 800, 1200, 1600, 2000, etc.

Thus, since 1900 has a century offset of 0, 2000 has a century offset of 6, and so begins one day earlier.

Because the other 3 centuries out of every 4 do not have 25 leap years (the year 00 is not a leap year), they each have a total relative year offset of 124%7 = 5.

1900 has a century offset of 0 (by our definition).
2000 has a century offset of 0 + 6 = 6 (0 + 125%7).
2100 has a century offset of 0 + 6 + 5 = 11 % 7 = 4 (0 + 6 + 124%7).
2200 has a century offset of 0 + 6 + 5 + 5 = 16 % 7 = 2 (0 + 6 + 5 + 124%7).

The cycle is thus 0, 6, 4, 2, and it repeats every 400 years.

Gregorian Century Offsets

Century

Offset

300, 700, 1100, 1500,1900, etc.

0

400, 800, 1200, 1600, 2000, etc.

6

100, 500, 900, 1300, 1700, etc.

4

200, 600, 1000, 1400, 1800, etc.

2

A shortcut to calculate the century offset for the Gregorian calendar is ((39 - Century) % 4) * 2. For example, the century offset for the 1200's would be ((39 - 12) % 4) * 2 = (27 % 4) * 2 = 3 * 2 = 6. The reason that 39 was selected here is that this calendar is valid only until the 3900s, and therefore 39 was selected as the next highest multiple of 4 (40) minus 1.

The quickest way to determine the century offset for any given century is to find the next highest multiple of 4, subtract 1, subtract the desired century, and multiply the result by 2. For example, to find the century offset for the 1900s, the next highest multiple of 4 beyond 19 is 20. ((20 - 1) - 19) * 2 = 0, and 0 is the century offset for the 1900s. To find the century offset for the 2000s, the next highest multiple of 4 beyond 20 is 24. ((24 - 1) - 20) * 2 = 6. To find the century offset for the 7400s, the next highest multiple of 4 beyond 74 is 76. ((76 - 1) - 74) * 2 = 2.

We now have all of the information required to calculate any date on the Gregorian calendar. We can do it quickly in our head or on a piece of paper if we can remember the 12 month offsets.

Examples of dates on the Gregorian calendar

July 4, 1776:

Century offset: ((20-1)-17)*2 = 4
Year offset: 76 + 76/4 = 76 + 19 = 95. 95%7 = 4
Month offset: 6 for July
Day offset: 4
Weekday: 4 + 4 + 6 + 4 = 18. 18 % 7 = 4 = Thursday

July 4, 1776 fell on a Thursday (on the Gregorian calendar).

February 14, 2020:

Century offset: (((24-1)-20)*2 = 6
Year offset: 20 + 20/4 = 20 + 5 = 25. 25%7 = 4

(Subtract 1 because Jan/Feb of a leap year) 4 - 1 = 3
Month offset: 3 for February
Day offset: 14. 14 % 7 = 0
Weekday: 6 + 3 + 3 + 0 = 12. 12 % 7 = 5 = Friday

February 14, 2020 will fall on a Friday (on the Gregorian calendar).

Century Offset (for the Julian Calendar)

To calculate dates on the Julian calendar is very similar to calculating dates for the Gregorian calendar. There are two differences. One is that the year 00 is always a leap year. Therefore, the years 1700, 1800, and 1900 are leap years.

The other difference is that each century has a total of 100 years and 100/4 = 25 leap years. The relative century offset for the Julian calendar is always +6, as 125%7 = 6.

For the Julian calendar, each century begins 1 day earlier then the previous century, with no exception every 4th century as for the Gregorian calendar.

For the Julian calendar, the 1900s have a century offset of 6. The 1800s had an offset of 0. The 1700s had an offset of 1. And so on.

From this trend two facts can be noted. One is that as the century increases, the century offset decreases. The other is that as the 1800s have an offset of 0, and as 18%7 = 4, 3 must be added to the century to make 4+3 = 7 and 7%7 = 0.

Therefore, a quick method of calculating the century offset for the Julian calendar is to add 3 to the century and take the mod 7 (these two steps align the number with 0), and then subtract the result from 7 (to make the offset decrease as the century increases); i.e., 7 - (Century + 3) % 7.

Thus, the 1900s have a century offset of 7- (19+3) % 7 = 7 - 1 = 6. The 1800s have a century offset of 7 - (18+3) % 7 = 7 - 0 = 7, and 7%7 = 0. The 1000s have a century of 7 - (10+3) % 7 = 7 - 6 = 1.

The cycle is thus 6, 5, 4, 3, 2, 1, 0, and it repeats every 700 years.

Julian Century Offsets

Century

Offset

500, 1200, 1900, etc.

6

600, 1300, 2000, etc.

5

00, 700, 1400, etc.

4

100, 800, 1500, etc.

3

200, 900, 1600, etc.

2

300, 1000, 1700, etc.

1

400, 1100, 1800, etc.

0

We now have all of the information required to calculate any date on the Julian calendar. We can do it quickly in our head or on a piece of paper if we can remember the 12 month offsets.

Examples of dates on the Julian calendar

July 4, 1776:

Century offset: 7 - (17 + 3) % 7 = 1
Year offset: 76 + 76/4 = 76 + 19 = 95. 95%7 = 4
Month offset: 6 for July
Day offset: 4
Weekday: 1 + 4 + 6 + 4 = 15. 15 % 7 = 1 = Monday

July 4, 1776 fell on a Monday (on the Julian calendar).

February 14, 2020:

Century offset: 7 - (20 + 3) % 7 = 5
Year offset: 20 + 20/4 = 20 + 5 = 25. 25%7 = 4

(Subtract 1 because Jan/Feb of a leap year) 4 - 1 = 3
Month offset: 3 for February
Day offset: 14. 14 % 7 = 0
Weekday: 5 + 3 + 3 + 0 = 11. 11 % 7 = 4 = Thursday

February 14, 2020 will fall on a Thursday (on the Julian calendar.)

Conclusion

The algorithm for calculating the dates on the calendar is surprisingly simple. It is so simple that with minimum practice, and memorizing the 12 month offsets, it can be done in the head or on paper.

The algorithm is also very simple for a computer to calculate, as is demonstrated by this calendar program.



http://5dspace-time.org/Calendar/Algorithm.html

4/6/11

What Should Your Net Worth Be? Why “The Millionaire Next Door” Equation Falls Short – And What A Better Thumbnail Calculation Might Look Like

Recently, I was reminded of the first book I ever reviewed on The Simple Dollar, The Millionaire Next Door. I really liked the book, even though there was one big flaw in it: a rather large age bias. The book was written for people over forty, from top to bottom.

This was most obvious when the book offered up a formula for calculating what your net worth should be:

Target Net Worth = Age X Annual Pre-Tax Income / 10

So, let’s say I’m a 23 year old, fresh out of college. I am carrying $25,000 in student loan debt and my only asset is my car, but I get a job paying $30,000 a year. According to this formula, this is my net worth:

Target Net Worth = 23 X $30,000 / 10 = $69,000

I don’t know very many fresh college graduates with a net worth that high – most are saddled with a lot of student loan debt and simply haven’t been in the workplace long enough to build any assets.

What can we do to change that? The big question is really how old should a person be when their net worth switches over to positive? For the average college graduate, that’s going to be at least a few years after graduation, no matter what. So let’s try this instead:

Target Net Worth = (Age – 27) X Annual Pre-Tax Income / 10

That gets a more realistic number for young people – our straw man above would have a target net worth of -$12,000, which is pretty realistic – and even if a person chooses graduate school, the number isn’t too far off.

The problem pops up later on in life. At age 40, with an annual salary of $40,000, a person would have the following target net worth:

Target Net Worth = (40 – 27) X $40,000 / 10 = $52,000

A person who has been earning $30K to $40K over fifteen years or so should definitely have a higher net worth than that. The culprit, I think, is that number on the bottom – 10. It assumes that a person’s net worth should only grow 10% in a given year. What will actually happen is once the net worth starts going positive and growing well, it will grow by more than 10% each year. My net worth, for example, will probably grow somewhere around 30% this year.

So let’s say we think a financially healthy person, once they’ve paid down some of their debts, should see their net worth grow by significantly more than 10%. Let’s try making that number on the bottom 5 instead of 10.

Target Net Worth = (Age – 27) X Annual Pre-Tax Income / 5

For our straw man, at age 23 with an income of $30,000, his target net worth would be

Target Net Worth = (23 – 27) X $30,000 / 5 = -$24,000

This is probably a pretty good estimate, considering he graduates with $25,000 in student loan debt and owning only his beat-up car. The new equation is far more realistic for people in their twenties and thirties than the old one. What about the 40 year old with an income of $40,000?

Old Target Net Worth = 40 X $40,000 / 10 = $160,000
New Target Net Worth = (40 – 27) X $40,000 / 5 = $104,000

Even at age 40, the new equation points at a lower target net worth. But what about a 60 year old with an income of $60,000?

Old Target Net Worth = 60 X $60,000 / 10 = $360,000
New Target Net Worth = (60 – 27) X $60,000 / 5 = $396,000

Late in life, the modified equation actually points at a higher net worth than before. I think this is a much more realistic model because of the power of compounding – compounding is going to be much more powerful for you later in life as you’ve been building up your retirement and such.

So, instead of using the equation found in The Millionaire Next Door to figure your net worth, try this one instead:

Target Net Worth = (Age – 27) X Annual Pre-Tax Income / 5

It creates a much more realistic view of a person’s financial state throughout their life than the original, particularly for younger people. No single thumbnail formula like this is perfect – I’m just seeking one that matches better than the one in the book.

I recommend using this number as a target throughout your life, much as The Millionaire Next Door suggests: make it a goal to try to double the target or better, but know that if you’re matching the number, you’re doing all right.

http://www.thesimpledollar.com/2007/09/16/what-should-your-net-worth-be-why-the-millionaire-next-door-equation-falls-short-and-what-a-better-thumbnail-calculation-might-look-like/

4/4/11

SQL - Function - Month Name

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Fn_MonthName]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[Fn_MonthName]
go
Create function Fn_MonthName (@MonthCode varchar(2))
Returns Varchar (15)
As
/*------------------------------------------------------------------------------------------------------------------------------------------
** SQLVersion : SQL 2000
** Function    : Fn_FinMonth
** Author     : Kartik M Kumar
** DateTime    : 29 January 2011 21:27
** Version    : 1.1
** Purpose    : To get the Month Name from the respective calander month
** ToCheck    :
** Changes    :
------------------------------------------------------------------------------------------------------------------------------------------*/
/*
-- Start of Debugging Stuff
    Declare @MonthCode varchar(2)
    Set @MonthCode = '03' -- Pass the Month Number as Input
-- End of Debugging Stuff
*/
Begin
    Declare @MonthName varchar(15)
    DECLARE @IMonthCd as int
    set @IMonthCd = cast(@MonthCode as Int)
    Select @MonthName = case @IMonthCd
        when 1 then 'January'
        when 2 then 'Feburary'
        when 3 then 'March'
        when 4 then 'April'
        when 5 then 'May'
        when 6 then 'June'
        when 7 then 'July'
        when 8 then 'August'
        when 9 then 'September'
        when 10 then 'October'
        when 11 then 'November'
        when 12 then 'December'
                end
Return Isnull(@MonthName, 'InvalidMonth')
end
go

http://www.sqlservercentral.com/scripts/Month+Name/72408/

3/31/11

How to Poach an Employee from a Competitor

It’s natural to look at a rival’s staff and wonder who could help your business. Here’s how to lure a star employee to work for you.

Hiring an employee from a rival firm can mean bringing on someone who already knows your industry, your business, and can bring valuable new knowledge and even clients to you.

Little wonder that recruiters are often asked to bring home that particular prize.

“Companies are so focused on getting someone from the competition,” says Mike Sweeney, Principal of MAS Recruiting in Cherry Hill, NJ. “As soon as they see the resume, their eyes light up.”

Still, as enticing as it is, hiring from the competition requires caution and a certain degree of finesse, especially for a small-business owner. The process is loaded with pitfalls: you don’t want to get a reputation as a poacher, start a tit-for-tat talent war with a competitor or, worst of all, get sued for breaching a non-compete agreement.

So, before wading in to dangerous waters, here are some things to consider when you’re tempted to look to the competition for your next employee of the month.

Take the subtle approach
If you can afford it, hiring a search firm to find candidates can help keep you at an arm’s length from the potentially distasteful business of poaching.

A good search firm uses a polished, subtle approach. They’ll talk with potential candidates about “an opportunity” in vague terms, until they can gauge interest.

If your budget bars hiring a search firm, it’s best to copy the approach, says Brenda Snyder, chief operations officer at The Human Resource Group, a boutique search firm in Denver. She suggests using your professional network to spread the word that you’re hiring, and approaching the candidate you’re interested in on neutral ground, like a Chamber of Commerce meeting or conference. If you’re too aggressive, Snyder warns, you risk scaring away potential partners and/or suppliers.

“In the small business world, you don’t want to blow out your personal relationships,” Snyder says. “If you know that there’s a person you want at another firm, and if you don’t have a relationship with that firm, you can go for it. But if it’s a small industry, a small market, with small niche players, be very conscious of the consequences of that action. Think it through, like any good business leader would.”

Look before you leap
Perhaps the most important thing to think through is whether the candidate you’re eyeing is really worth the trouble. You don’t want to get stuck with someone else’s headache, says Martin Kartin, principal of boutique search firm Martin Kartin and Company in New York.

“You want to make sure you’re recruiting talent, as opposed to recruiting a resume,” Kartin says. “The biggest mistake small companies make is to look at the resume in terms of what the person says he has done, and what company the person has been with, and they automatically say ‘Oh, that’s great.’

“Even if they have the right job with the company, it doesn’t mean that they are a qualified candidate,” he warns.

To avoid the problem, do thorough reference checks, and really study the candidate’s background, to get a sense of what’s driving them, suggests Chris Von Der Ahe, a senior client partner at Korn/Ferry International in Los Angeles. You also need to assess whether the person will be a good fit at your firm, Von Der Ahe added. “Just because they work for a competitor, doesn’t mean they’ll fit into the culture.”

Culture differences can include large firm vs. small firm differences, and can also be as simple as geography. If the candidate you want is across the country, for example, and he or she has no ties to your area, it may be difficult for them to get acclimated.

For this reason, it’s often a smart move to take seriously the local people who come to you with their resumes, eager to join your firm, even if they don’t have the exact experience you’re looking for, says Mike Sweeney of MAS Recruiting.

“I tell companies you’re a lot better off getting someone who has a burning desire to come work at your company, for whatever reason, especially if they’re local,” Sweeney says. “They might not have all the bells and whistles that you want, but if they live local, and they have a real desire to work at your company, some months down the road, you’ll have struck gold.”

Watch for legal troubles
If it turns out that the candidate you’ve been eyeing at a competitor is as good as you hoped, and you want to begin talking with them more seriously about joining your firm, a critical step is to find out whether they have a non-compete agreement with their current employer. If they do, and they jump ship to join your firm, depending on the state in which you’re based, you may be in for a great deal of trouble, including a lawsuit in some cases. Some states take non-compete agreements very seriously. An employment lawyer can advise you on how best to proceed.

Keep in mind that talking with a candidate who is bound by a non-compete agreement is definitely a matter of weighing the risks and rewards, according to Mike Travis, principal of Travis & Company, in Newton Center, Massachusetts. “It’s very easy to run afoul of a non-compete, and it’s very expensive to fix your mistake,” he says.

Sell your story
If, after all the reference-checking, soul-searching, and risk-reward analysis, the candidate from a rival firm still looks as good as you imagined, don’t forget that you need to sell them on what you and your company have to offer. After all, why should they leave their job and join you? You need to make your opportunity sound more attractive than what they've already got. And remember, it’s not just about money. Most people are motivated by things they weren’t offered at their previous job: recognition, opportunity, and more innovation and excitement.

So, inspire that person to leave their job not just with a generous offer, but with everything they will be able to do and achieve at your company.

Recruiters know the drill. “We can’t lure people from point A to point B without a compelling story,” says Snyder of Human Resource Group. “Typically it’s not money. It’s always about the opportunity, the industry, or about the leadership.”

Watch your back
Finally, recognize that your competitors might be playing the same game you are. When spending the requisite time analyzing your staff and looking for gaps, don’t forget that you need to treat your best employees very well, so that when they receive a call from a recruiter, or are approached by a rival CEO, the only answer they’ll feel obliged to give is a firm “Thanks, but no thanks.”

“Know who your stars are, and make sure they’re well taken care of, and well paid,” said Sweeney at MAS Recruiting.

http://www.inc.com/guides/201101/how-to-poach-an-employee-from-a-competitor.html

3/30/11

How to Boost Confidence and Success

Recently I enjoyed a conversation with friend and peer, Doris Helge, Ph.D. In a discussion about our group coaching programs, Doris stated that some coaches struggle in their own business due to a lack of confidence. Like the shoemakers’ kids who are the last to receive new shoes, some coaches struggle with what they best inspire others to achieve: the confidence to bring their dreams to fruition.

Reflecting upon that conversation this morning reminds me that the lack of confidence issue is true for solopreneurs and solo practitioners everywhere, and isn’t exclusive to coaches. The ironic part is that many of them believe they are the only ones struggling with the fears associated with a lack of confidence. Oftentimes, it isn’t until they enter into a coaching relationship that they discover that confidence is lacking in large numbers across ranks of entrepreneurs and high achieving executives everywhere.

Those who struggle with confidence often build barriers that keep them from taking the emotional risks associated with business growth. The business owner will do only what is necessary to reach the border of their tolerance level, known as the comfort zone. They will manufacture many “excuses” to stay within those safe confines - yet, so much more is possible.

Comfort zones come in all shapes and sizes, so for some, living within their comfort zone still allows for measured success and a steady income – even strong profits in many cases. But lack of confidence lurks outside the comfort zone, keeping them from their greatest potential. For others, the dream remains a dream and, tragically, may never see the light of day.

Here are some sure ways to boost confidence and break through the barriers of your - not so comfortable - comfort zone…

Recognize your strengths and successes. It’s common to diminish the significance of past “wins” when you are lacking in self-confidence. Make a list of your success stories, even if they date back to your high school days! Then note the qualities and skills that you tapped into to achieve your success. No “ya but anyone could have done this” statements allowed here! Concentrate only on the positive and unique aspects of YOU!

Do it your way! Determine if you need to stop reading the newsletters, social media updates and websites of your competitors and peers. Do they bring about feelings of inadequacy or jealousy? When I began building my practice I subscribed to the newsletters of successful coaches – just to see how they did it. I followed them on FaceBook and monitored their Tweets carefully. Well, this strategy turned from an education to a flurry of envy, fear and doubt. So I took myself off of those lists and did it my way – this was the best decision ever! So take notice of how you feel as you read materials from people whose success you aspire to emulate. If it’s empowering, that’s great. But if your body and brain feel stressed, hit that “unsubscribe” button!

Tell your story
. Join a leads group or another type of organized event that will give you the opportunity to tell people what you do. As you hone your pitch and begin to see a positive response you will gain confidence. It’s easy to get into a rut, sitting behind the computer where your social interaction is limited to social media. Nothing beats eye contact and heads nodding to give you a shot of confidence.

Forgive yourself.
We all carry memories of past failures and disappointment. These little treasures are the classroom of life.

"Failure is success if we learn from it." Malcom S. Forbes.

Review any “failures” in your life and list the things that you learned from them. How do you do things differently now? How have you grown? Release any related negative emotion by acknowledging the positive results you have garnered from these experiences. If this task seems insurmountable to you explore coaching and modalities like the Emotional Freedom Techniques to break the hold of these past experiences.

Get feedback. When people praise your success, attitude or personal qualities, how do you feel? Embarrassed? Humbled? Anxious? Do thoughts like, “it’s really not a big deal” or “it’s just common sense” go through your mind? If so, then push yourself way out of your comfort zone by doing this little exercise. Why? Because shutting out praise means that you don’t acknowledge yourself for your achievements and positive characteristics. Boost your confidence by asking friends and family to create a list of all of the things they admire about you. If possible meet with them in person as they read their lists to you. Don’t say a word, simply look them in the eye during this process and internalize what they have to say. You might just learn a few things about yourself.

http://www.inc.com/marla-tabaka/how-to-boost-confidence-and-success.html

How to Execute Great Ideas

Entrepreneurs typically have no shortage of ideas, but this creative strength can quickly become a weakness if the ideas aren’t managed well. The constant messages running through a solopreneur’s mind might include thoughts like, “I should get moving on that.” “What if I miss out on something big?” “Too many ideas, too little time.” “I wish I had the money to make this happen, it’s such a great idea.” This brain-clutter will bring a truckload of great ideas to a screeching halt before they even get on the road, so let's take a look at how to unload the excess cargo!

Taking a systematic approach isn’t always easy for the right-brained, creative solopreneur. But to get these ideas off the ground, that’s what we have to do. So whether your idea is about a new product, marketing or other growth or organizational opportunities, here are a few of these tips to move it forward – or take it off the list once and for all.

Get them out of your head and onto paper. Having all of this brilliance trapped in your brain is exhausting – it wants out! Begin by sorting out your ideas; big and small. Categorize and prioritize them based on your needs: Do you need immediate revenue? Do you need to improve your branding? Do you need to get systems into place? Do you need to satisfy client demands? Or do you simply need to have more fun by utilizing your creativity in a new way? Now choose ONE idea (yes, just one) and apply some or all of the following strategies.

Examine and Expand. When your idea is in its initial stages take a curious, no pressure approach. Rather than putting pressure on yourself to find a way to make the idea work, simply ask “what if” questions.

“What if this idea was in place right now, what would be different because of it?”
“What if I could see this idea as something bigger than it is right now, how would it look?”


Just have fun, exploring the concept like a child might explore a playground. Introducing playfulness can reduce your stress and allow room for further creativity.

Compare your idea or strategy to your vision and mission statements. Is there synergy? Does it really fit in with your long term goals? Does it change anything in a way that you must explore or does it just confuse the picture? Is it too far off the mark or does it fit in seamlessly with the big picture?

Sometimes we get a “great idea” and being wrapped up in the energy of it all can cause us to lose track of our true vision. Getting sidetracked like this can take you off your path and on a long, bumpy detour. You may or may not end up in the right place!

Apply the S.W.O.T. analysis steps to your idea. Draw a quadrant on a piece of paper or write down the four categories on your mindmap or whiteboard. Strengths, Weaknesses, Opportunities, Threats.

After examining your concept and listing everything you can think of in each of the four areas, explore your thoughts on the following:

  • Is there danger of a strength becoming a weakness?
  • Can you convert a weakness to an opportunity?
  • Can weaknesses be minimized or eliminated?

Bringing this information together, to assess the most promising opportunities and the most crucial issues is where you will find the greatest value in a SWOT analysis. Then you can take your idea further or take it off your plate altogether.

Look at latest trends. If you are bringing a new product or service to the market, does it meet your clients’ needs in a way that is new, refreshing and creative? Will it stand out or get lost in the chaos? Again, introduce non-threatening, stress-free exploration of your idea to see how you can make it different and/or better from the rest.

Brainstorm with friends and peers. I know I’ve said this more times than I can count, but solo doesn’t mean alone! Don’t take it on all by yourself. Ask creative and strategic people to work with you and have fun with it. Remember that you chose to be your own boss because you love the freedom. Being glued to your ideas in a stressful, lonely way doesn’t make it a very enjoyable experience!

Here's a fun idea - Go somewhere different to work through your ideas. I love to work in a decadent hotel lobby or a coffee shop or bookstore I've never been to. Somehow, this creates a new level of excitement for my planning and brainstorming and really helps me tap into that playful side. What works for you?

http://www.inc.com/marla-tabaka/how-to-execute-great-ideas.html

Why You Should Be a Slacker

If you want to get ahead, you need a Type A personality. Go, go, go. Right? The more stress you’re under, the better you perform. You can handle everything.

Sue Shellenbarger at the Wall Street Journal reported on a new study in the Journal of Applied Psychology. Researchers found that slackers actually handled life better than their go getter counterparts.

But in a finding that may baffle busy-bee readers, people who avoid problems – those we might call slackers in a different context — who withdraw and, say, lie down and take a nap instead of tackling dilemmas right away, actually do better with life conflict, and seem to have more energy, says the study.

The part about the “slackers” having more energy isn’t surprising. After all, they just took naps.

But, overall this makes sense. By taking some down time, they have time to evaluate whether this new problem is actually worth solving. How many of times have you had “urgent requests” become “oh never mind, we’re going another direction” an hour later? Look over your email after you’ve been stuck in an off site training all day without access to email? You weren’t there and magically some problems solved themselves.

In addition, you can often think of solutions when you’re not staring at a problem directly. Go for a walk, talk to a friend, do something other than dwelling on the problem you are currently facing.

More fascinating is the finding that people who seek out other people for emotional support reported more stress. These people probably take the stress into their relationships instead of using the relationships for an escape from problems.

So, stop complaining, and go take a nap. By the time you wake up, perhaps you’ll be less stressed and one of your type A coworkers will have taken care of three items on your to-do list.

http://www.bnet.com/blog/evil-hr-lady/why-you-should-be-a-slacker/2007

The 6 Principles of Success

PepsiCo's Salman Amin shares the six guiding principles that have led him to success in his career.

Predicting the future is a seemingly futile exercise. This doesn't mean we should not try to stay ahead of the game. However, I have found throughout my career at PepsiCo that rapid adaption to changes as they occur is more beneficial in business than clairvoyance.

While we all have opinions about what may happen next, one thing is clear: we are operating in a web of global interconnectivity that affects everything we do.

As business people, it affects how we expand into a new market, what products we sell and who our consumers will be. The rules of engagement of our entire civilization are being reconfigured by a digitally-charged communications revolution. So, what can we do to operate more effectively in a time of profound, tumultuous, and continuous change—or as I call it, the "Era of Ambiguity?"

Following are the six guiding principles that have benefited me throughout my career:

1. Cultivate learning agility. I am an engineer who became a marketer who became a business leader. I have learned from each one of my assignments, and I have tried to learn at least one thing from every manger I had. To be an effective, life-long learner, I look at my career as a marathon. You must have the stamina, the technique, and the resiliency to stick with it, regardless of whether you are running uphill into a headwind.

2. Listen carefully. Too often we just talk to those who are close to us in our management hierarchies. We must make an effort to listen to everyone. Even our most ardent and intractable opponents will invariably teach us something important. When I was president of PepsiCo UK, some health interest groups ran some unpleasant commercials criticizing our products. It would have been easy to dismiss their concerns. Yet, by spending time with these committed activists and developing an insight into what they had to say, we were able to rethink our position in a number of beneficial ways.

3. Be comfortable with embracing significant and ongoing change. I knew we had to do more than just listen to what health activists had to say, we had to take action. Ultimately, we reduced the saturated fat content in Walker's crisps, and sponsored a Change4Life anti-obesity campaign.

Along the way, we won over some very opinionated activists. We showed the activists that we respected their opinions; we were willing to make changes, and we were willing to contribute to their efforts. This had a profound effect on our relationship with our health-oriented consumers in the UK.

4. Learn to deal with failure. To paraphrase Tennyson: it is better to have tried and failed, than never to have tried at all. For if you aspire to great achievements and high rank, you must venture forth—and you will fail from time to time. But, do not make the mistake of equating business failure with personal failure. Failure in pursuit of a worthy goal must never be personal. If we allow it to become so, we will create a society of timid souls. Failure is simply a learning experience. Every great person's career has at least one significant failure, usually many, but those people were able to learn from it and move forward.

5. Have a strong philosophical foundation. Too often, companies look at mission statements as corporate window dressing, just something to put on a Web site and on the walls of offices. Your mission should be a powerful tool: a road map for future action. At PepsiCo, "Performance with Purpose" means delivering sustainable growth by investing in a healthier future for people and our planet. This is a lofty goal, but ultimately, it provides guidelines for discussion and debate within our company and a list of what to do—and what not to do. This is vital when navigating the oceans of ambiguity. While PepsiCo will inevitably move in a variety of directions, we know that you will not go too far off course if we adhere to our core principles.

6. Offer a far greater insight into what you and your organizations can offer. Customers and clients are looking for a different value proposition. The days of the impersonal manager, the impersonal company, and the impersonal product are over. It is no longer about just selling products or services. It is about creating and sustaining relationships where values and emotions are taken far more seriously.

We need to demonstrate to consumers that we understand the community in which they operate, that we understand what they care about, whether it is enacting broad-based policies to reduce PepsiCo's environmental footprint in the broader sense or partnering with local farmers and community groups to use our manufacturing facilities to improve water's sanitation and availability. If we can show that we are sensitive to these challenges, our brands will be in a much better place. Then, whether they invite us into their lives is entirely dependent upon how strongly they feel that we are relevant to them. They have to feel good about us.

This exercise of authenticity forces us to look within ourselves and become more aligned personally and institutionally with what we want to achieve. But if you make this commitment—and it is a very serious commitment—you and your business will be able to meet the needs and demands of the millions of consumers who are looking for products that they can believe in and trust. In an era of ambiguity, when there are fewer guarantees every day, this becomes increasingly valuable over time.

Salman Amin is the executive vice president of global marketing and chief marketing officer for PepsiCo.

3/28/11

21 Rules to Live Your Life – Dokkodo

I came across ‘Dokkodo’ recently which is a small book written by Miyamoto Musashi a week before he died in 1645. Based on the date, I was quite amazed at how many of the following rules or principles if you like have stayed with us and are still very relevant today.

The 21 precepts below were written just as Miyamoto was giving away all his possessions in preparation for death and I think many of them still apply to our modern society and lifestyles.

I’m not one to simply copy the work of others and put it here, but in this case I believe that the precepts by Miyamoto deserve to be shared. Many of them fall into the same line of thinking that I have and the same line of teaching that I’m trying to share here.

This post is long so I recommend you scan the points and if there are any you don’t understand or want to have my views on then read the comments by me below them.

21 Rules to Live Your Life
Below I’ve included the 21 ‘rules’ from 1645 and also added my own commentary; I would love to hear yours in the comments at the end.

1. Accept everything just the way it is
I’ve already stated that I think acceptance is the way to instant happiness so I always try to implement acceptance into my life. If you aren’t accepting things then you are simply resisting what is, resistance causes internal conflict and then tends to lead to negative emotions or downward spirals.

Often things we resist are in the past i.e. not accepting that someone has died or still being angry about a previous relationship. These are things we simply can not change and that is why it makes no sense to resist what has happened. Total acceptance also allows you to live in the now and much more consciously.

2. Do not seek pleasure for its own sake
This is one I really had to think about to start to understand. What I believe Miyamoto was suggesting here is that you should not look for pleasure simply in order to have pleasurable feelings. Another interpretation of this by the University of Minnesota suggests that it means you shouldn’t seek pleasure solely for yourself.

In my opinion, you should focus on the things that you enjoy then pleasure will exist as a byproduct, rather than pleasure something you’ve had to work on specifically in order to receive the benefits.

3. Do not, under any circumstances, depend on a partial feeling
This is quite self explanatory, but, simply put; don’t act in high importance or high risk situations based on a partial feeling. It’s great to go with your instinct now and then and just ‘go with the flow‘ but when something is crucial, make sure you know what you are getting into.

4. Think lightly of yourself and deeply of the world
You are who you are, nothing more and nothing less. You are not the car that you drive and you are not the size of your bank balance. It’s fine for others to think of you as funny, cool, rich or any of those things, but if you place a large importance on them and start to identify with what these words represent then you’ll start to live a much more reactive life.

Accept who you are, know your strengths and weaknesses, don’t over qualify yourself to the world but definitely don’t under estimate your potential. The world and everything in it is truly amazing, see it, explore, make the most of everything; take nothing for granted.

5. Be detached from desire your whole life long
Detachment is to be disinterested in the outcome of an event or situation. Therefore, being detached from desire your whole life long means that you shouldn’t care about the outcome of the things you want in life. Worry about the outcome projects negative emotions such as fear. As with a point earlier, attachment to something means you are identifying with it, you see it as part of yourself in one way or another.

Whatever your desires are in life, don’t make the outcome necessary. If something doesn’t happen then be OK with that, realize everything in life is abundant.

6. Do not regret what you have done
I have a favorite saying for when I look back after having taken action on something that says “I’d rather regret the things I DID do rather than the things I DIDN’T do”. However, if you look at this on a presence and acceptance level, you should never regret the things you have done, simply because you can’t change what has happened.

7. Never be jealous
What reasons do you have to be jealous of anybody? If you are jealous of somebody with lots of money then you should re-frame your thinking. Be glad there are people out there that show you there is potential for you to make lots of money as well.

If you are jealous of somebody’s looks then you identify with superficiality much more than is even necessary. You never know what ‘problems’ people can have under the surface, fitting in with society standards doesn’t make you a happier person, it just makes you more socially conditioned.

8. Never let yourself be saddened by a separation
According to the Buddha, attachment is the source of all suffering and as far as separation goes this certainly applies. Separation can apply to losing a partner, a pet, money, possessions or anything of the sort. I think what Miyamoto is referring to here is once again live in total acceptance of what happens and don’t hold on to things that have occurred previously.

You have the choice to be angry or happy at all times, there’s no point wasting time in the frame of the former. When I was mugged at knife point recently I lost my drivers license, lots of money, my credit card, mobile phone (worth over $300) and more. I was disappointed for a short while, but I was more pleased about the fact the knife wasn’t used on me or my brother during the incident.

9. Resentment and complaint are appropriate neither for oneself or others
Once again this is pretty self explanatory. Resentment and complaint aren’t going to get you anywhere in life, except to be troubled with negative emotions. Accept everything for what it is and always appreciate the moment, nothing else applies.

10. Do not let yourself be guided by the feeling of lust or love
I don’t think that this means anything to do with celibacy like others have interpreted this as, but more about controlling your own destiny. If you have a good grasp on reality a.k.a. an abundance mindset then you will know there are literally billions of potential partners out there for you. I don’t believe that there is always just ‘the one’ but I believe there are many people you can connect with and love.

If you feel you want to marry someone then go down that route, but don’t let your strong attachment and emotions guide the direction of your life. Take control and enjoy lust / love on the way, don’t completely immerse yourself in their powers and detach from other areas of your life.

11. In all things have no preferences
Before you are so quick to dismiss this, think about what it is saying. Obviously we all have a preference over things such as Coke vs Pepsi or Cars vs Motorbikes but that isn’t the main message. I think the message here is not about having no preferences but rather about not letting certain preferences control your emotions.

For example, if there is a noisy party next door and you are trying to sleep then wishing there was silence (preferred) isn’t going to help. Instead, you should just accept the noise, don’t create any internal conflicts and you’ll be asleep before you know it. [Example Source]

12. Be indifferent to where you live
The word indifferent is best described as “that which does not matter, one way or the other” and in reality where you live shouldn’t make any difference to you internally. Whether Miyamoto was referring to the idea that you should travel more or the underlying fact that it was much harder to move around in 1645 I’m unsure.

13. Do not pursue the taste of good food
I have a feeling that this doesn’t refer to food literally but haven’t found anyone that has yet to explain this in more detail. Maybe a copy of the book is needed or if anyone can leave a comment I’ll update this one.

14. Do not hold on to possessions you no longer need
Letting go of the things that you don’t need can give you multiple benefits. First of all you get a lot more clarity in your life (and environment) due to lack of clutter. Secondly, someone else can benefit from your possessions and put them to good use.

This may seem quite negative to the likes of collectors and those who are very materialistic but it makes a lot of sense. Also, we tend to attach ourselves to our possessions and feel strong negative emotions if anything happens to them, even if we don’t need / use them.

15. Do not act following customary beliefs
We live in a society where a large majority of people spend their time living in spectator mode, just like everybody else. We follow celebrities in the media, we play computer games and we watch a lot of TV. These are all influences on how we should live our lives and are actually a place where a lot of this ‘life’ is wasted.

Make your own life rules based on reference points, experience and with proper, truthful mindsets such as those of abundance and potential.

16. Do not collect weapons or practice with weapons beyond what is useful
In 17th-century Japan this was a lot more relevant due swords being a commonality and the many forms of Martial Arts were in full swing. I take this message as saying ‘Don’t waste time with things (weapons) that aren’t going to benefit you‘.

Sure, there are hobbies such as fencing that involve weapons which aren’t necessarily used in this way because they are useful. People take part in fencing because they enjoy what they do. However, in terms of learning to perform skills with weapons which serves no purpose, this could be seen as protecting you from acts which simply inflate the ego.

17. Do not fear death
I’m a big preacher of living in the moment and doing things for the now, I started learning more about ‘The Now’ through the teachings of Eckhart Tolle. In his first book Eckhart states that there is ‘no such problem in the now’. In my lack of understanding, I hesitantly asked on an Eckhart Discussion Forum how the likes of having a knife in your chest could not be seen as a problem in the now.

One of the responses I received that I liked went along the lines of “Death is no different to birth, they are both natural. They are one and the same. If you fear death then that is like fearing birth.”

18. Do not seek to possess either goods or fiefs for your old age
Stated very strongly in the book ‘The Four-Hour Workweek’, we tend to try to save up our money so that we can start to enjoy life once we retire from our jobs. However, as you will discover, if you can live in the moment you will see how stupid and incorrect our societal views on this actually are.

Think about it, most of us actually do plan to save money so that we can enjoy life when we retire and do the things we love. However, this is silly because we are planning for something that:

•a) We may never reach
•b) Involves our form being in it’s worst ever condition (aging)
•c) We could be doing right now

19. Respect Buddha and the gods without counting on their help
I’m not Christian or involved in any other religions so I don’t believe in the common view behind the word ‘God’. However, that isn’t to say I would judge or look down upon anyone that chooses to have belief that such Gods exist.

Respect the teachings and messages of others, but don’t use them as a crutch to keep you balanced.

20. You may abandon your own body but you must preserve your honour
The one thing we all have in common when we born, albeit deemed as negative, is that we are going to die. We can’t stop the aging process (although we can limit its affects through the likes of plastic surgery) and we can’t cheat death.

Despite that, this precept is saying that along the way you should always stand to live by your own moral values. Don’t change them due to pressure from others or the usual conforms of society.

21. Never stray from the Way

‘The Way’ may be viewed as something monumental like finding and acting our your life’s purpose and it may also be viewed as something small like keeping on top of your goal progress. Either way, you should always try to remain focused on the things you want to achieve and stay on that path.

There are many distractions these days with drug or alcohol abuse, financial worries and much more. However, you should simply see these distractions as hurdles that filter out those that really want to achieve something and those that don’t. Never stray from the way.

3/25/11

Flash Reports Definition

Flash Reports Definition
The Flash Report or financial dashboard report is defined as a periodic snapshot of key financial and operational data. It's a one-page report that helps management assess the key performance indicators of the company. The flash report should cover the shortest time period that is feasible, usually a weekly basis. The whole process should be based on the KISS principle (Keep It Simple Stupid) and should not take any longer than 30 minutes to prepare and get ready. If it takes any longer than that, then the flash report is too detailed and will be too difficult to maintain!

There are 3 sections to the flash report: Liquidity, Productivity and Profitability.

Flash Reports are a rough measure of change. They are not meant to be 100% accurate. If the data is 80-90% accurate, it will be enough to manage the business. For complete accuracy, the firm can defer to its monthly financial statements, which come out 2-4 weeks after the month closes. For management purposes, it is timeliness and "mostly accurate" is good enough. If one were to wait for complete accuracy, the competitive landscape may have change so completely that the "accurate" financial statements may not be of any use.

Flash reports should be done on a weekly basis. However, some companies elect to do it every two weeks in order to more naturally capture the payroll cycle in terms of monitoring cash flow.

The CFO/Controller should get together with the Owner(s)/Management to arrive at a set of metrics for the Productivity Section. This is the hardest part to arrive at and will require the input of both operations as well as finance/accounting.

After the initial metrics have been determined, the CFO/Controller can have someone in the client's accounting staff to gather the data for the Liquidity, Productivity and Profitability sections.

Each section tells a different story about the firm.

The Liquidity Section tells management about the cash situation of the firm. Is the company generating cash? Does it have enough money to pay the bills?

The Productivity Section gives an indication of the key performance metrics of the business. These metrics are tied to operations and are a way to combine the operations of a company to its financial performance.

The Profitability Section gives a rough indication of how much money the company has made during the period of measure. It is important to emphasize again that complete accuracy is not necessary. Timeliness, however, is. Management can work off of 80-90% accuracy. What they need to focus on is the change in trends over a period of time.



Flash Reports:Liquidity Section
The purpose of the Liquidity Section is to measure the change in working capital of the company. In so doing, the company will have a rough estimate of whether or not they can pay the bills and how much money they will have left over.

Monitoring the company's working capital over time will allow the firm to see: how cash increases/decreases, any effects of seasonality and effects of management decisions. If a company is making a profit then the Working Capital should increase over time!

As part of the overall Flash Report, the Liquidity Section ought to be monitored and reported on a periodic basis. What is that period? It is recommended that the entire Flash Report at a minimum be reviewed on a weekly basis. The more management reviews the information, the faster they can respond to crises.

The frequency of monitoring depends on several factors: Availability and commitment of the management team to review the information, Frequency of certain cash inflows/outflows (i.e. payroll), Ease of access and/or generation of information and Timeliness of data entry of information pertaining to this section (i.e. are all A/R and Inventory entered into the system on a timely basis?).

Someone in accounting, preferably a person who is in charge of bookkeeping.

Information for the Liquidity Section can be found in the Balance Sheet section of the company's financial statements (so long as it is updated). If the firm uses a software program (i.e. PeachTree, QuickBooks, Great Plains, etc) to manage its books, then the information can be easily retrieved.

NOTE: Make sure that the ending period on the Balance Sheet matches that of the Flash Report. Both are snapshots of the company in time. Make sure we are talking about the same time period!!!

Cash: Look in the check register to see how much cash is there. Do not use the bank balance because there may still be outstanding checks. Be leery of using the cash position off of the balance sheet. The information is good only if it is updated. This may not always be the case. This is why the check register is bes

Accounts Receivable: Look at the Accounts Receivable detail report for total accounts receivable. Deduct any bad debts reserved.

Inventory: Look at the inventory detail report for total inventory on hand.

Accounts Payable: Look at the Accounts Payable detail report for total accounts payable.

Working Capital: Sum up the values for Cash, Accounts Receivable, and Inventory. Subtract the value of Accounts Payable. This will give you the value for working capital.

Review and monitor your results. Graphing the results may also be a very effective method to see what is going on in your company's process.

In the spirit of flexibility, the Flash Report can and ought to be customized to fit each company's needs. The basic format is just that….a basic platform to help get you started. For the Liquidity Section, some companies have also added the following items:

Cash Receipts - This gives a feel for the cash that has come in during the period of concern.

Cash Disbursements - This gives a feel for the cash that has gone out during the period of concern.

Taken together, The Cash Receipts and Cash Disbursements give an indication of whether the cash flow for the firm is positive or negative.

Days Sales Outstanding (DSO)

DSO= 365 x Average A/R / Total Credit Sales

This tells you how many days it takes on average to collect on A/P.

Days Payable Outstanding (DPO)

DPO= 365 x Average A/P / Total Annual Purchases

This tells you how many days it takes on average to pay your liabilities

Days Inventory Outstanding (DIO)

DIO= 365 x Average Inventory / Cost of Goods Sold

This tells you how many days it takes on average it takes to turnover your inventory Cash Conversion Cycle (CCC)

CCC= DSO + DIO - DPO

This tells you how many days it takes to convert raw material to cash



Flash Reports:Productivity Section
A major issue that businesses of all sizes face is the inability for the Operations people to connect with the Finance/Accounting people and vice versa. The Productivity Section seeks to address this disconnect by measuring and tracking certain metrics that both Finance/Accounting and Operations can agree upon. By identifying and monitoring these non-accounting metrics, management can now manage the productivity of the company in a more meaningful way.

How do you get these metrics? An important by-product of this process is the communication process that both Finance/Accounting and Operations must have with one another. In essence, coming up with these metrics forces each party to “stand in the other person’s shoes.” In so many ways, this section is the most difficult to create, but it is by far the most powerful section.

For companies that have multiple profit centers, it may be worthwhile to have the key performance metrics grouped by profit centers.

The CFO/Controller sets it up. Then someone in the accounting department inputs the information into the template. The majority of the metrics should be formulas.

Since the goal is to tie operations to financial numbers, it is important to come up with operational metrics that will have significant impact on the financial performance of the company.

Step 1 - It is important for both the operations and financial departments to both grasp the general economics of the firm. Some key questions to ask are: What are the key drivers of the business? What/Where is the process bottleneck? How can we measure the bottleneck? What are the unit economics of the business? What is the breakeven point for the business? Note: Breakeven may be done on a dollar basis or unit volume basis.

Step 2 - Map out the business process. Ask yourself how does each part of your business contribute to the key performance indicators identified in step one?

Step 3 - Come up with business metrics that tie in the unit economics of the firm (Step 1) to the business process (Step 2).

Out of this process you will come up with several key performance metrics that will indicate how the business is doing. These metrics may not relate directly to dollars, but indirectly they will. Two great ways to approach this is to look at process bottlenecks and sales in terms of volume (i.e. # of feet, # of barrels, # of units).

Focus only on the most important metrics. Four to five will do. If you focus on too many, it will be hard to measure and difficult act upon. Here are some examples for various businesses:

Business - Metric Manufacturing - % Utilization of Machine (Bottleneck Machine) Consulting Firm - Average Bill Rate Jet Refueller - Gallons Per Aircraft Fueled

Step 4 - Also find some metrics that tie your business process down to the employee level. Relating this to the employee gives management a way to see how each employee contributes to business performance. Here are some examples for various businesses:

Business - Metric Construction Firm - # of Active Projects per Employee Construction Firm - Construction Cost per Employee Consulting Firm - Hours Billed per Employee

Step 5 - Review and monitor your results. Graphing the results may also be a very effective method to see what is going on in the business process. Flash reporting is an ongoing process until you have identified the key performance drivers for the business.

In the spirit of flexibility, the Flash Report can and ought to be customized to fit each company's needs. The basic format is just that….a basic platform to help get you started.

For the Productivity Section, some companies have also added the following items: Metrics for each Product Line or Business Unit, Separated out FTE employees versus Sales Employees (Example: Sales per Sales Person) and Sales per Full Time Employee.



Flash Reports:Profitability Section¶
This section gives you an estimate of how much money the company has made during the period. It is important to emphasize the word "estimate" for several reasons. First, the Flash Report itself was not meant for complete accuracy. This cannot be overstated. The Flash Report is used best when it is timely and mostly accurate- (80-90%) is good enough. Second, you will notice that profitability was derived from the estimate of the volume throughput for that period. This makes sense as sales and productivity are often a function of volume throughput (i.e. # of barrels, # of gallons, etc.). Another option is to obtain the values for Revenue, Cost of Goods Sold (COGS), Gross Profit, Overhead, and Net Income directly from your accounting system.

The second method is the simplest, but there is a hidden risk that you must account for. Not all the items associated with sales and cost/expenses may have been entered into your accounting system during that time period. Thus, there is a risk that the numbers you use may not even be "mostly accurate". It may or may not be. Thus, backing into your profitability estimate can help remove that risk. Now, you just need to make sure that you have a good grasp of how many units were sold as well as the associated costs.

Note, the metrics in the Productivity Section can be an excellent guide in helping you to start estimating the profitability of the firm.

The CFO/Controller sets it up. Then someone in the accounting department inputs the information into the template. Regular monitoring should be done by the Owner(s)/Management of the firm. Here are some ideas on how to get things started:

Option 1: Obtaining information directly from your accounting system. If you are obtaining revenue and cost information directly from your accounting system, then anyone with the proper authorization can obtain the numbers.

Option 2: Backing into the Profitability Numbers. The CFO/Controller, as well as, the key person(s) in charge of operations. Initially, it may be wise to have both parties involved. Operations will have the feel for units sold. Finance/Accounting may have a better grasp for costs.

Later on, you may decide to create a system where such numbers are automatically reported by someone as part of that person's responsibilities.

For those choosing to obtain numbers directly from the company's accounting system, it will be relatively simple to obtain. Just go to the Income Statement section to retrieve information regarding Revenue, Cost and Expense. However, please understand the risks as described above in the Goals section. You may be taking on some hidden risks by going directly to the Income Statement for the profitability information. Not all the information pertaining to sales and costs/expenses for that period may have been entered.

For those of you electing to indirectly arrive at profitability using sales volume and unit costs and unit price, please refer to the following steps:

Step 1 - Obtain data on the # of units sold, cost per unit, and estimate of monthly expenses. Having a good understanding of the unit economics of the firm will be key to making this step easier. Initially, this may be somewhat challenging to be able to collect. However, over time it will become easier. Here are some helpful tips:

Number of Units Sold: The operations department will need to keep records to in order to record how many units have been sold. There is no short cut here. However, if you can know 80-90% of the # of units sold, then that is enough.

Unit Sales Price: Sales and Accounting will need to keep good records on prices. Please note that sometimes, prices may have changed in the middle of the period.

Unit Sales Cost: Sometimes you can easily determine the cost using vendor invoices. If it becomes difficult, a helpful way is to look at historical P&L Statements. You can estimate the COGS amount for this period by seeing what historically they were as a percentage of revenue. For instance, if COGS was 60% of sales last year, then you can estimate COGS for this year as 60% of current revenue.

Step 2 - Plug in the data for Revenue, COGS, and Overhead Expense. Sum up as per the example in the Basic Format section.

Step 3 - Review and monitor your results. Graphing the results may also be a very effective method to see what is going on in the business process.

In the spirit of flexibility, the Flash Report can and ought to be customized to fit each company's needs. The basic format is just that….a basic platform to help get you started.

For the Profitability Section, some companies have also done the following: Report just the Gross Margin and/or Net Income. You can do this, but this does not excuse you from understanding the underlying unit economics. You still have to do your homework. Include profitability on a per employee basis.



Flash Reports:Monitor & Review
Now that you have assembled all the parts of the Flash Report, it is time to review your results. Again, it deserves mention that the purpose of the Flash Report is to provide management with a timely, "mostly accurate" tool to assess the current state of affairs. Thus, any changes that need to be made can be made quickly. Emergencies can be proactively addressed at the problem stage, rather than reactively in the crisis stage. If you want complete accuracy, wait until the financial statements for the period are complete 2-4 weeks after the month has ended. In the meanwhile, 80-90% accurate is fine for managing a business.

The Owner(s)/Management of the firm should review the results of the Flash Report after it has been completed. If possible, review on a weekly basis in order to expedite the decision making process. This way, the company can react to trends faster.

Any person or parties involved in the active management of the firm should certainly be included in the performance review of the firm. It is especially important that representatives from Operations, Finance, and Accounting be there as well.

In and of themselves, the numbers do not tell you a whole lot. They serve as a point of reference for discussion. It is recommended that you start off with the review of the firm's cash position. The cash position may provide questions as to why cash is short, which in turn will generate questions regarding A/R or sales.

Step 1 - Review the Liquidity Section This section will provide management an idea of whether or not they can pay the bills. Deficiencies will usually spring from a collections issue, sales issue or cost/expense issue. It will be up to management to explore each of these areas to see where potential problems lie.

Step 2 - Review the Productivity Metrics Section Ultimately, if done right, this section gets to the heart of the business process. It is important that the Finance/Accounting people are in accord with Operations people that these metrics are meaningful. If they are not, keep working at them until they are. This may be several iterations later.

Review of this area can tell management in a very simple way, how the business process is doing. These metrics should provide a simple read as to the how the heart of the business is beating. Should there be problems, these metrics should capture them in some way. In turn, revenue should be affected as well. For instance, revenue may be down, because a certain machine was down for repairs. Thus, % utilization could tell you indirectly why revenue was down for the period.

Step 3 - Review the Profitability Section Because the firm's productivity affects its profitability, so too will the results from the Productivity Section be seen in the Profitability Section. It is important for management to confirm this.

Continue to monitor results from period to period. If changes to Productivity Metrics need to be made, please feel free to do so. The key to successful implementation and use of the Flash Report is the commitment to its use and the commitment to communication and discussion.

Some companies may choose to graph the results in addition to having the flash report in a tabular format. A graph may at times be easier to understand than numbers, especially for analyzing trends.

For the purposes of the flash report, it may be useful to include 3 historical periods in addition to the current period. This will aid in the analysis of trends.


http://www.wikicfo.com/Wiki/Default.aspx?Page=How%20to%20Prepare%20a%20Flash%20Report&NS=&AspxAutoDetectCookieSupport=1

10 efficient ways to produce useful metrics

Takeaway: Accurate metrics are essential for assessing performance and making informed decisions, but companies often rely on flawed information that paints a misleading picture. Alan Norton explains the most efficient strategies for obtaining valid, useful metrics.

The one constant in my career has been the collection and distribution of company information. I didn’t know the cost of the metrics I was producing. Those costs were never measured. But I did know my labor costs and the costs of the supplies I was purchasing. Multiply that by each department in the company where I worked and I knew that the numbers had to be getting real big, real fast. I also knew that there were opportunities there for big cost savings.

It is not difficult to make a case for more efficient metrics. Significant cost savings can be realized by reviewing and improving how and what metrics your company produces. Metrics are expensive. Add up the true total costs and they can be quite considerable:

•Printers
•Paper
•Printing supplies
•Labor
•Development
•Production
•Distribution
•Maintenance
And the costs don’t end at document creation. Metrics are shared multiple times, either electronically or physically. The security of company sensitive metrics is an additional responsibility and cost. The metrics must be managed, stored, and retrieved –all activities more costly than you might guess.

I won’t try to argue that metrics are in any way fun to discuss. However, their importance to the health of a company is undeniable. Get the metrics wrong and a company’s full potential will not be realized. I have seen enough to know that the metrics used by companies both large and small can be improved. Here are 10 ways to do just that.

Note: This article is also available as a PDF download.


1: Measure performance at aggregate levels and exceptions at lower levels
I have produced a lot of charts in my time. In retrospect, I realize that I produced too many charts. Many of those charts provided no value at all — they showed performance on schedule or close to on schedule for a number of subassemblies. Printing these charts might have given managers a reassuring sign that all was well, but little else. The better approach is to use exception reporting and set upper and lower limits. Sure, go ahead and measure performance at higher levels. But report only exceptional performance, good or bad, at the more granular levels.

2: Eliminate metrics with little or no value
Know the cost of each metric. Are all your metrics worth reporting? A cost benefit analysis can help identify reports that are costing more than they are worth. A best guess estimate of potential savings must be included in the analysis, so it is not as simple a process as it might first appear.

It can be difficult to discard those old, comfortable shoes when you’re rummaging through your closet. But if they’re no longer useful, they should go. The same applies to those charts and reports that managers have become comfortable seeing. Nevertheless, if they are of little or no value, they should go.


3: Avoid tying incentives to lower level metrics
Meeting goals at the department level can be detrimental to the company’s overall performance. For example, a help desk manager might be paid a bonus for increasing completed tickets at tier one. But this is counterproductive if the overall costs rise due to the increased workload at tier two and lower. Bonuses and other incentives should be tied to the corporate bottom line and not departmental performance.


4: Avoid metrics that are inaccurate, misleading, or ambiguous
Producing metrics that are inaccurate or ambiguous can be costly to correct if they lead to bad decision making. There are a number of reasons why metrics can be inaccurate, misleading, or ambiguous:

•Invalid assumptions
•Errors in data collection
•Incomplete data
•Outdated data
•Questionable/unverified data
•Difficult to measure data
•Subjective (not objective) data
•Complex and multifaceted data
Some metrics are difficult if not impossible to measure. Managers are nevertheless tasked with boiling down metrics like software development into one or two charts. Similarly, other metrics, like employee happiness, just don’t translate well into numbers and should be avoided. I’m not suggesting that measuring this type of information should be avoided altogether, just not presented as numbers in chart format.


5: Avoid skewing the data
One simple example of data skewing is reporting costs over a long period of time. 2010 dollars are not the same as 2005 dollars. If you are not compensating for inflation, you are delivering misleading information. Obtaining too small a sample or a non-random sample are other common ways that data can be skewed.


6: Standardize and consolidate
Reduce the amount of information generated by eliminating redundancies and standardizing where possible. Financial reports, like manpower metrics, can usually be centralized and standardized for all departments. There are those unique metrics that can’t be standardized for all departments, but many of these can be standardized across divisions.


7: Use unbiased personnel or outsource connect
Being a reporting guy my entire career, it isn’t surprising that I ran across a manager or two who wanted to game the system. There are countless ways to lie with numbers or, at a minimum, hide poor performance by the appropriate (or should I say inappropriate) manipulation of the data. One example I saw was to use fiscal YTD values instead of a 12-month moving window. The obvious problem with this is that when a new fiscal YTD starts you have no previous data points to show a trend. And that is exactly the goal. It’s a great way to hide bad numbers. I reported directly to the manager asking for the fiscal YTD format, so I was in no position to question his motives. The inherent problem created with this type of working relationship is another reason why metrics production should be centralized and reported directly to upper management or outsourced.


8: Automate whenever possible
Gathering data by hand and entering numbers into a charting program is a labor intensive and costly endeavor. Since charts are often generated weekly or even daily, one or more people can spend most of their time preparing the charts. If the data is available online, the charts should be automated. If the data is not available online and must be collected by hand, consider developing systems that can collect the data at a reasonable cost.


9: Consider going paperless
If your company hasn’t already done so, going paperless can save a lot of money. However, paper should still be an option and care should be taken before converting a report to online only. If it takes more time to look up a metric online, the additional labor costs can far outweigh the savings.


10: Be careful what you measure
All too often, overly simplistic metrics focus on only part of the whole picture. A metric like “IT spending as a percentage of revenue” treats IT services as a cost. But such incomplete information can lead to poor decision making. The challenge for IT managers is to develop metrics that show the value added by IT and get them under the CEO’s nose.

The very act of measurement determines where managers will place time and resources — often at the expense of other unmeasured metrics or other departments’ metrics. Measure too little and important performance metrics can be missed. Measure too much and the focus can be lost from the mission-critical metrics. The costs of measuring the metrics can then quickly exceed the benefits. The metrics package should be carefully selected to balance these tradeoffs.


The bottom line
Metrics are like laws. They are born but never seem to die. An annual review of the company’s metrics package provides a good opportunity to add new metrics, update out-of-date metrics, and discontinue those metrics that are no longer needed. Select your metrics package carefully. What you measure is what you get.

For further information, check out the whitepaper Efficient Metrics: Be Careful What You Measure.

http://www.techrepublic.com/blog/10things/10-efficient-ways-to-produce-useful-metrics