About Me

My photo
Andrew J. Jordan, CPA, MSF is a licensed Certified Public Accountant. He achieved a successful career as a CPA, Financial Manager and Consultant for a variety of large and small businesses. Andrew is experienced in creating value for companies in industries ranging from staffing and professional services, retail automotive dealerships, manufacturing and real estate. He also has over 25 years experience assisting individuals and businesses with income tax planning and compliance. Andrew holds a Bachelor of Science degree in Business Administration from Wayne State University in Detroit, MI and a Master of Science in Finance from Walsh College in Troy, MI. His graduate education included significant elective study in Taxation. His services include: Accounting, Tax and Advisory Services. Visit andrewjordancpa.com for more information.

Monday, November 15, 2010

Mining the Company Data

Data mining is the process of extracting patterns from data.  Data mining is seen as an increasingly important tool by modern business to transform data into business intelligence giving an informational advantage.  It is currently used in a wide range of profiling practices, such as marketing, surveillance, fraud detection, and scientific discovery.  (Source: Wikipedia definition of data mining)

Most business software allows one to extract data very easily by downloading it into Microsoft Excel or other types of files.   The data can be downloaded to included a number of data field combinations within each record. Once the information is in Excel it can be manipulated with

Wednesday, November 3, 2010

Break-Even Analysis Part 2

Break-even:  As one can see from my previous B/E analysis posting the additional sales needed to "breakeven" on a new hire decision can be challenging.  With new revenue hard to come by, why would a company add staff if sales have to be increased so much to make a profit on the decision?