More Resources

Home > Tech Advisor > Ramon Ray - Question 1

My wife and I own a small direct-mail advertising company (10-14 employees and $2 million in sales). We do graphic design work, printing and the mail processing that goes along with direct-mail campaigns.

Currently, we use a combination of manual and electronic efforts to keep us on schedule and organized.Our job jackets are filled out manually, we have a large white board so we can see our work flow and we use a very basic database to keep track of our jobs. Our gut is telling us that we should migrate over to a computerized system for our scheduling and to help us keep track of all the balls that are in the air. Our question is two-fold. What product do you recommend? And do you have any pointers on how to do the ROI? We have timed our employees on how long it takes to fill out jackets and have done various other analysis, but we don't feel comfortable with those methods. We almost feel better going with our gut.



Using a manual process of white boards and job jackets is a good idea for those on the shop floor:

They can quickly see, at a glance, even with no hands available to type, what projects are being worked on, their deadlines and what needs to be done.

There are two options I see. No. 1, you could hire a programmer to custom develop and/or further develop your existing database. This database could include the client's complete work order and have models for printing the job jackets. Databases you could consider include Microsoft Access, File Maker Pro or Alpha Software. If you need a more robust database, then Oracle SQL (it's free for the license) might be a better fit.

A second option is off-the-shelf "print shop" software. I'm not sure of a particular name; however, I'm sure that at your industry conferences and in other material there are many vendors of "print shop" job software.

What you need in any program is one that can grow with your business and is modular. You don't want a system that provides the functionality you need today but to expand it, you have to create an entirely new program and waste your development efforts and time. A program that can interface with other programs, such as accounting and shipping, would also be important to further streamline your operations and boost productivity.

It appears that you know your business and have done your best to calculate ROI. This is a good and necessary step. If you do not find an off-the-shelf program that meets your needs, work with a programmer (a local one, or check out ehire.com) who can build you a database for your specific needs. Ensure you own the rights to the software and that you thoroughly test it out.

I hope this helps.

About Ramon Ray
Ramon Ray is an author, speaker and editor of Smallbiztechnology.com, a site that helps small to medium-sized businesses use technology to grow through news, articles, discussion boards, resources, analysis and events.

Ramon has been using computers since 1986. He's the author of Technology Solutions for Growing Businesses, and has written thousands of technology articles and news items for Smallbiztechnology.com and other media. Through his writing he's helped thousands of small businesses use technology as a tool to grow.

Despite his vast experience, Ramon isn't "just" a technology writer. As a former small-business technology consultant, he has years of hands-on experience in building networks, installing software, upgrading computers and supporting the technology small businesses use on a daily basis.

Marketplace

Learn how to distribute a press release

Try our new online printing. theupsstore.com/print