consultants to the trade

Marina Dock Age, November/December 1995

Create Your Own Comparable Data
by Dennis P. Kissman

Anyone who has tried to obtain statistical operating information on the marina industry realizes it is almost an impossible task. Our industry is very fragmented and those working in it are suspicious of sharing any information. Through the years, marina organizations and other groups have attempted to compile and publish such information with very limited success or accuracy.

Today more and more marina owners realize the importance of using comparative information as a means of measuring their business performance. Since there are no "industry standards" to compare your results to, establish your own historical data or goals to compare current results. First, comparing raw numbers does not always provide accurate comparisons because there may be extraordinary factors that increase or decrease the amount recorded in a given period from year to year. Second, marina activity is heavily weighted to weekend boating activity. For example, July 1995 had five weekends to record income and expenses. Third, weather has a big impact on marina activity.

You may be saying to yourself that the gathering of information is one reason we have computers. We expect our computers to provide us with all the answers and we are quick to blame the computer when there is a problem with the results. Unfortunately a computer is no smarter than the person who operates it. You must first understand what you are doing and why you are doing it.

For some of us who are not as computer literate as others or maybe have a little difficulty with number relationships, let’s see what the rationale is and how we can do it by hand before we attempt to set up the information on our computers.

First, get yourself a 13-column pad. List your account descriptions in the first column. Place the prior years numbers as reported in the second column. Review those numbers for any extraordinary items. For example, no utilities were recorded because the bill got buried in the stack of papers on your desk and by the time you realized there were no utilities charged to expenses for the month, your reports were already published. Insert this amount in column three and add or subtract this information from column two (in this example it needs to be added) and insert the results in column four.

In columns five, six and seven repeat the same steps as you did in columns two through four for the current year. Subtract column two from column seven and place the difference in column eight. This gives you the amount of change from the previous year. In column nine divide column eight by column four to give you the percent change from last year and place the answer in column 10. Now your numbers are comparable and have meaning, providing you have already addressed the second key item-timing.

The best way to eliminate differences due to timing is to establish your accounting on a 4-4-5 fiscal calendar. Identify each quarter of the year with the first two months having four weeks and the third month five weeks each, regardless of the day of the week the month actually begins. For example, August 1995 actually began on a Tuesday but in this system your accounting period begins on Monday, July 31. Its best to start your workweek on Monday and end on Sunday.

Keep an accurate daily weather log. It is not acceptable to say, “Oh, we had six days of heavy rain in July last year, that is why the numbers are different.” It could make a big difference if those six days were a Monday, Tuesday or Wednesday vs. Over the Fourth of July holiday. After you determine the impact of weather on your business, you may want to incorporate this factor into your spreadsheet to include current and prior years weather as an additional adjustment column.

These are but three items that need to be taken into account when establishing meaningful numbers to be used for statistical analysis. Do not be afraid to start out simple and get more complex later.