Software

Ask something
Question Locked

Inventory Management Spreadsheet for MAC?

0 helpful
3 replies

by donnadimick

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
I'm the owner of a company that manufactures and wholesales bath soap products. I've been in the industry for 11 years now. And have never found a inventory system that I'm happy with.

So, I have been on an exhaustive search for days trying to find a simple Mac compatible spreadsheet that will allow me to track raw ingredients coming in, going out, and then the finished goods coming in and then going out when sold. All I want is a spreadsheet. I don't want a complex program that does a bunch of other office applications.

I fear that I will need to make my own. However, I'm totally clueless about Excel formulas. When I tried to do a simple invoice it was a disaster. I don't know what formulas to plug in and where to plug them.

If anyone knows of an inexpensive (I've spent tons on useless programs already) spreadsheet that will do this, or can help me to design one, I'd be eternally grateful.

Regards,
Donna

3 replies

by robo_dev

Don't use the butt-end of a gun as a hammer.
Cars make terrible boats. In other words, use the right tool for the job.

Spreadsheets are great for doing analysis, but are the wrong tool to do inventory tracking. You can spend hundreds of hours creating complex spreadsheets to do simple database tasks, or buy or create a simple database app to do simple database tasks.

Get a database program and have a programmer whip up a simple inventory program.

Or buy an off-the-shelf app (found via google search) like:

Inventory Tracker Plus
http://productivity-software.com/

Manufacturing Synergy
http://www.b2bdbsys.com/

by donnadimick

While it is easy for you say simply buy a $100-$200 off the shelf program, it is not an easy task for a small business owner like myself to do so in an economy such as ours. As I said before, I've already spent lots of money on such programs that don't serve the needs of the type of manufacturing company such as my own.
Plus these programs are filled with "fluff" that I do not need nor do I want. All I need is something that I can input and subtract inventory of raw materials, and then do the same for the finished goods after they are manufactured and sold. And is MAC compatible.

It should not be this difficult to find such a simple, bare bones application. You would think that I was asking for the countries deficit to be paid!

Thanks anyway for your time.

This discussion is closed to new replies.