Subscribe by Email

Your email:

Newsletter Subscription

Receive DataCraft News fresh off the presses - direct to your email.

Subscribe to DataCraft News 

 

Ask the Bean Counter

Have a question you would like to see answered here?

Submit your question to the Bean Counter

DataCraft Blog

Current Articles | RSS Feed RSS Feed

Effective Inventory Management

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

Earlier this week Monica Glenny spoke at the Belvidere Chamber of Commerce Manufacturer's Appreciation Breakfast.

The topic: inventory management. effective inventory management

Based on the discussion and amount of inquiries after the event, I think it's fair to say that inventory is something that is on everyone's mind.

During Business Clarity sessions, effective inventory management is often brought up by clients, and they're issues aren't isolated to just them.

Inventory is an issue that plagues businesses of all sizes and the same questions typically come up:

  • Do we have accurate accounts of all products, materials, or parts?
  • What is the physical location of each inventory item?
  • What is the cost of producing each unit of product or service?
  • Are we ordering appropriate quantities of inventory for future production and sales?
  • Do we have any inventory that has been sitting on the shelves for years?
  • Are we currently holding too much or too little inventory?

These are all questions that can be answered with the correct work flow process and by understanding inventory ratios

Because it is such a common pain point and has been a hot topic around here lately, we have pulled together some white papers that cover different aspects of inventory management.

Demand Planner
Inventory Turnover Ratio

Guide to Inventory Management

Business Entrepreneurs: Check out our 2010 Winter Book List

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

2010 Winter book liseWe've all been hit really hard by this winter weather, so what better way to relax than with a good book? We decided to take a break from our usual accounting basics and ERP software talk to compile a book list for you. Check out some of our favorites that made it to our 2010 Winter list

Make Today Count - John C. Maxwell (Center Street)  This is the second time Maxwell has made it onto our reading list. (Check out the other time here). Maxwell's book discusses the importance of making the right decision in twelve critical areas of your life, or what he refers to as the "Daily Dozen." Maxwell suggests the path to being successful starts small with making the right choices on a daily basis.

The Narrative of the Life of Frederick Douglass -Frederick Douglass(Fall River Press) Considered a milestone in American history, The Narrative of the Life of Frederick Douglas chronicles the life of the famous abolitionist. Originally published only seven years after his escape from slavery, it became an instant success.

Common Sense -Thomas Paine (Penguin Classics) This is the pamphlet that started it all. First published in 1776, Common Sense challenged the authority of the British government and the royal monarchy. What made his writing so popular? He didn't try to wow the masses with philosophy, instead he wrote for his audience, not above them, impassioning them to want to make a change. It's still as inspiring today as it was nearly 250 years ago.

Embrace the Struggle- Zig Ziglar and Julie Ziglar Norman (Howard Books) Written after a traumatic fall that lead to a head injury Embrace the Struggle discusses the importance of optimism to get us through the hard times we all eventually face. Through his own stories and the stories of friends, Ziglar highlights "living life on life's terms."

Exploiting Chaos: 150 Ways to Spark Innovation During Times of Change- Jeremy Gutsche (Gotham Books) Hailed by many as one the best business books of 2009, Exploit Chaos takes readers on a visual journey to help ignite ideas for a successful business. Gutsche's writing style and graphics fit in perfectly with today's busy reader. Looking for inspiration to put these challenging times to good use? Check out this book.

The Findability Formula: The Easy, Non-Technical Approach to Serach Engine Marketing- Heather Lutze (John Wiley & Sons) Ever wonder how customers are thinking when they search for a product or service? Lutze's book helps marketers at all levels of experience re-energize their website to make them more profitable. Her step-by-step guide to Pay-Per-Click campaigns helps to make your company visible throughout the customers' buying cycle.

Streamline Begins with the Right Work flow Software

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

workflow management 

In talking with growing businesses, we're finding a common theme of data reentry. If your employees enter and re-enter sales information in multiple software programs, it can slow the sales process and allows for data entry errors. But how can you streamline the work flow management?

Answer:

Procedures within the sales process may be fragmented in various ways, for example:

  • Sales inquiries are received by e-mail, telephone and fax
  • Inquiries are maintained on a spreadsheet
  • Price quotes are calculated on another spreadsheet
  • Follow-ups are maintained on yet another spreadsheet

Most accounting software can maintain and integrate several procedures within a single program. The software applications can generate lead follow-up letters, check inventory levels and automatically reorder, forecast potential product demand and allow customers to enter orders through your Web site.

Streamline your software system. Your business will save money, and your sales force will become more productive.

Resolutions Aren't Enough

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

Key performance indicators

Now that 2010 is here, people are scrambling to figure out how they're going to keep their New Year's Resolutions. They picked out their personal resolutions - lose weight, quit smoking, start a hobby, save more, spend less... but what about New Year's resolutions for your business? How are you planning on taking what you learned in 2009 and putting it into practice for 2010 and beyond?   

Coming up with goals for the New Year is great, it gives your business something to work towards, but don't let it stop there. Planning out how you're going to achieve those resolutions is just as important as the resolutions themselves. They don't always have to be grandiose tactics, sometimes it's the simple steps that keep you on track.

Let's say your resolution is to pay more attention to the financial health of your business- take what we like to call "5 at 5"

Every day at 5:00 (or whenever your day at the office is winding down) take five minutes to review your key performance indicators. Here are some possibilities:

  • Day's cash receipts
  • Days' cash disbursement
  • Current ratio
  • Accounts Receivable (A/R) aging

Work your tactics into your daily routine, and your resolutions won't be as lofty as they seem.

What are some of your business resolutions this year? Better yet, how do you plan on keeping them?

Is Your Inventory Managment System Effective?

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

Unless your company is strictly service based, someone in the business is managing some kind of inventory. Or are they? Do you really know the answers to the following questions:

  • Do we have accurate accounts of all products, materials, or parts?
  • What is the physical location of each inventory item?
  • Are we ordering appropriate quantities of inventory to accommodate future production and sales?
  • Do we have any inventory that has been sitting on the shelves for years - "It was a really good buy!"
  • How are returned items handled within inventory?
  • What inventory items generate the most profit?

inventory systemsMany small to medium sized companies struggle with their inventory tracking software. Some businesses maintain procedures for tracking inventory that are labor intensive. Usually that "labor" is diverted from other revenue-producing activities such as manufacturing, retail sales, and service calls.

What inventory questions do you have? Knowing what information your business needs about its inventory is the first step in inventory management.

Take time to determine your needs; you will drive money to your bottom line with proper inventory management!

What the heck is Accounting ASP?

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

Last month, Microsoft discontinued their Office Accounting product and a lot of small businesses where left without accounting software to run their company.

A recent Business Week article by Gene Marks highlights Microsoft Office Accounting and the story of a business owner of who was one of the many that purchased the software and ultimately lost out. Marks highlights the importance of businesses knowing about  the technology that's available to them before they make the investment. Know the accounting technology that's available before you invest

Lately we've been getting a lot of questions about software add-ons and accounting application service providers (also known as ASP's), what they are and how they can help with their business accounting.

An accounting ASP is an Internet service that provides business accounting software on line. ASP accounting services range from specific functions, to fully integrated packages.

There are three types of accounting ASP's:

  • Completely Web-based packages
  • Desktop packages redesigned for Internet use.
  • Partial accounting applications - on line bill pay, for example.

Monthly fees typically are a flat Internet access rate plus a fee per accounting module - accounts receivable, accounts payable, payroll, etc. Charges typically run anywhere from $10 to $500 per month.

If you are considering an ASP for your business accounting, make sure you weigh these factors.

There are some distinct advantages of ASP's including:

  • Allows remote access to financial information.
  • Cost savings over in-house software.
  • Useful for businesses with multiple locations.

With that said, there are also significant disadvantages:

  • No personal interface with accountant.
  • Security issues - financial information must be protected.
  • Data conversions may require manual input.

Whenever you're looking at purchasing new accounting software, make sure you consider your business requirements first whether that is in-house or on line.
 

Know your software options- Download the Software Selection Guide

 

Bookkeeping and Accounting- Some things just don't change

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

20th Century Bookkeeping and AccountingMonica recently brought in a book that belonged to her grandmother Gladys, 20th Century Bookkeeping & Accounting by James W. Baker, published in 1919.

As we were thumbing through the pages, we couldn't help but notice not a whole lot has changed in the world of accounting. The preface of the books starts out like this:

"The successful business man should know what a profit will result from the transactions in connection with his business before they are completed."

He goes on to say there's a connection between success and accounting. In order to make money, you need to know how to manage it... not a whole lot has changed in 90 years.

It might not be the most fast paced and exciting aspect of business, but it's definitely one of the most important. We've preached before about knowing your numbers (here, here, and here just to name a few) but we just can't say it enough.

Sure, the process and speed of how we can access the information has changes, but the fundamentals haven't. There are a lot of great accounting software packages out there that have made accounting easier and more accessible to everyone to understand but what's just as important as learning the software, is learning the process behind it.

In order to make money you need to know how it manage it... some things never change.

Basic Accounting Structure

Don't wait for stress tests

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

Stress tests When you read the phrase "stress test", what thoughts pop into your head? I'll go ahead and assume that they aren't very positive. Most people think that banks and businesses only undergo stress testing when they are on the brink of disaster, but stress test shouldn't be a last resort of your financial plan. Stress testing your business investment keeps you competitive by allowing you to be proactive.

The economy has changed the way we do business and the speed in which we need to adapt. Stress tests allow you to prepare for the worst-case scenarios that your business can come across. It helps to cover the "what ifs" of running a business:

  • "What if" our biggest customer goes out of business?
  • "What if" customers start demanding lower prices? Can you meet them?
  • "What if" customers start taking longer to pay you?
  • "What if" sales or production levels drop?

Stress testing your business has its benefits. It allows your business to be more adaptable to changes by providing the financial data you need to make quick and accurate changes to your business. Stress tests also help you formulate plans that address the "what ifs" giving you leverage when dealing with stakeholders and bankers, not to mention making you a stronger competitor.

Survive the New Normal by Knowing Your Key Performance Indicators

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

The market is down and unemployment is up. We all know this; we've been hearing it every day for the past year. Many people are becoming numb to the numbers thrown at us. It's not news anymore; it's becoming the new normal.

Some companies have decided to sit still and wait for the economy to turn around and others have started to recognize that things aren't going to change until someone makes a move.

These companies have stopped asking why and started asking how. They know that in July national unemployment was at 9.7%. They're aware that it's the highest it has been in decades. They know that the GDP is down. They know this stuff already and have turned from focusing on the problem to focusing on a solution. These companies haven't become numb to the numbers; they keep them in mind while driving business forward. They know that in order to fix the problem they can't lose focus on key performance indicators like liquidity, solvency and cash flow.

A solvent company is aware of its performance indicators and  are better equipped to not just survive, but also thrive in the economy. They're doing their research looking for new growth opportunities, forging new partnerships, and taking time to focus on what they do best. Don't sit in the corner waiting out the recession. Focusing in on mere survival will make you lose sight of your overall business plan. Keeping track of your financials will give you a leg up in competition and give you time to sharpen your focus.

But this workflow software was made for my business...

 | Submit to Digg digg it | Submit to Reddit reddit | Add to delicious delicious | Submit to StumbleUpon StumbleUpon | Share on Facebook Facebook | Share on Twitter Twitter | Share on LinkedIn LinkedIn 

Often times when we research software systems for our clients, we hear them say, "This software was made specifically for our industry." While this may or may not be true, there are some things you need to consider when looking for the right software:

  1. Does the production software or financial accounting software contain an Open Source Code or Closed Source Code? In relation to software, the owner of the software can exercise control over what users can do with the software. Can you purchase the software code so that the software can be customized (open source)? If so, once those customizations are made, can you own that code? If you change vendors and did not purchase the code and you want to implement an upgrade, you have to pay for that customization all over again. Bottom line, be careful with customizations - you may be stuck with a vendor you don't like or you may be stuck with software that has high maintenance costs for upgrades and support.
  2. What language is the business ERP software written in? Why is this important? If the software isn't in a language common to the software industry, then you will probably be paying a lot for the software, the customizations, maintenance and the training. If the labor pool for programmers in this expertise is small, it could be a very expensive software system to support and train to use.
  3. What is the relational database infrastructure like? Are the data tables relational? Relational databases use tables to store information. The model uses the relationship of similar data to increase the speed and versatility of the database. Relational databases are created using a special computer language, structured query language (SQL) that is the standard for database interoperability. SQL is the foundation for all of the popular database applications available today, from access databases to internet database structures. If the software you are thinking about purchasing does not have a relational database, it can become very difficult and time consuming to pull reports in the format you desire, or worse yet, the information may not be available at all.
  4. Research: Find out how long the product has been around and when it had its last update. Has it kept up with the industry trends, or was it purchased by some big company but has not received a face-lift in the last three years.

When someone states, "This software is made for your business" there's usually a big price tag associated with that. Today, many products out there can complete 85% or more of what your company does. You have to ask yourself what is the ROI (return on investment) associated with those customizations? Do the customizations solve a minor or major problem? What is the impact on the workflow management process if we don't have this customization? Think it through before you invest.

All Posts