Inventory Tracking - Excel or Access

OtterBoxing

New Member
Joined
Jun 23, 2012
Messages
2
Hi,


I'm just currently trying to figure out whether I should be looking onto having my inventory managed/tracked using excel or access.


Background info:


We currently use google docs, simply because we do not have the know how to use excel to its full potential yet, and google docs has made it easy for multiple users. But as our business is becoming more complex, we feel the need to employ someone to either build a data base in access or excel.. so I just need to try and figure who to target.


What we do:


We are a small family runned, laptop refurbishing business. Our products go throgh the following proccess...


We receive skids of offlease laptops, and do an initial audit. At this point all laptops are entered into a sheet identified by serial number, other info includes (make/model/specs). We also have the original price.


We then run hardware tests and do a physical inspection.. and assign each laptop a grade (A,B,C,D) etc.


The laptops are then refurbished from grade B,C,D to Grade A Any parts used to refurbish is added to the original price on the sheet


We then move the laptops to a 'ready to sell' sheet


The laptops are then stored on a shelve. Until a customer order comes in. We then upgrade the product to the customers spec (if needed) Parts cost added, and anything salvaged is deducted in the sheet


Laptops are shipped out to the customer. We then move it to a sold workbook. Where each individual customer has their own sheet. So we can see how much product a customer purchases


.. all along the main identifier is the serial. We also keep an inventory of parts on a separate workbook, so everytime a part is used to refurbish a laptop we have to reduce quantity on hand, and add the cost of the part to the laptop.


so for a small business 'me and my brother run it'... this is a pretty complex system, and we want to reduce some of the redundancies, and mistakes that take place, because of moving hundreds of items physically from sheet to sheet.


But what I need to know, is will excel be able to handle this or should I start looking for someone to build us an access database?


If excel could to do it, where can I start learning.. I would love to learn and do it myself.


Thanks.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,123,385
Messages
5,601,329
Members
414,445
Latest member
walramgo02

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top