Some Thoughts on What Can be Done With a Properly Designed Database

Many small to mid-size businesses don’t know the true costs of their product Virtually all business suffer from theft and product loss Most businesses don’t use databases to bolster their marketing campaigns  Many businesses’ payroll merely prints checks In summary, many companies don’t fully utilize the benefits of a database to create accountability

The following was written by one of my customers after telling him I was going to put up a website. I was totally surprised that he went to the effort to write the document with no encouragement from myself. When I questioned him on why he wrote it, he stated that we were able to show him ways to track his company that he was sure were not possible and wanted others to know what we can do. By the way, if you live or work in the metro Kansas City area, and need lunch for 5 or 500 Call Grandma's Office Catering at (816) 472-6362  or see their menu at  http://www.grandmascatering.com/ Presented with permission from Grandma's Deli & Catering

Forms from different applications written by Business & Computers, Inc. were added to further illustrate the solution.

 

Fact: 

Fact: 

While product loss can never be eliminated, stringent controls utilizing a database management system will let you know almost immediately when and where a loss occurs.  You will see even greater savings as your staff participates in inventory control and see first-hand the accountability for each product, each void, each discount.  Database management goes far beyond theft and cost control.  Once you know what is sold and what is used, an accurate ordering system is an easy extension. 

Once you have tracked your products to find what sells and what doesn’t, that data can by utilized to make marketing decisions based on profits!  An inexpensive marketing campaign can easily be supported by a well built database.  Send personalized letters with ease from that same database.  Even custom labels for your products or reminder postcards verifying a client’s appointment or product availability can be just a keystroke away.  Some of the most cost effective marketing campaigns have been centered around a focused group of profitable clients and/or profitable featured products, both of which are easily targeted with a customized database.

Above - Sales Information for each Company from Jobs Done
in a Program We Wrote for a Construction Company.

With setup of a proper database, payroll can not only calculate regular and overtime hours, multiple bonuses based on units, percentages and more, but can assign those costs to customers or products.  This system creates the paycheck, but more importantly creates a system to track costs and profit centers.

Above - Payroll Screen from the Payroll part of Grandma's Deli & Cateringa program.

In summary, you will see greater sales, lower waste, theft and product cost with a noticeable rise in bottom-line profits!

Above - Job Sceduling Card (the employee takes to the job)
from a Program We Wrote for a Construction Company.