New Energy Articles Blog

Most probably, you purchase your wholesale jewelry from the wholesaler online.  If this is so, you also probably copy and save the jewelry supplier’s photo of each piece you buy, but if you don’t, start doing it today, because this is the basis to create the best and easiest jewelry business inventory spreadsheet.  Curious?  You should be!  And here is how it works:

1.    First, get an image from the wholesale jewelry supplier
In most cases, the supplier will be able to provide a picture of each jewelry piece, but if this is not the case, just take a photo of each one as soon as you receive them.  Resize the image using a program like Paint, for PC’s, or a Preview program, for Mac’s, or, make instant thumbnail images.

2.    Second, name the image
By selecting a significant name for each jewelry piece, you take care of the indexing and inventory at the same time.  Let’s say you purchase three silver necklaces, this is the information you will write down in the file name:

-    The date, ‘1209’ means December 2009
-    The price, ‘3050’ means $30.50
-    The number of necklaces, in this case, 3.  You can add other important information, like the cost per piece, shipping cost, etc.

Once you’re done, the file name will look like this: 12093050310 (Dec. 09, $30,50, count 3, $10 each), to make it clearer, you can separate the numbers: 1209_3050_3_10.  You can also add a small description of the pieces:  1209_3050_3_10silver_neck.

3.    Third, add the pieces to a spreadsheet
This list of images can be viewed either as file names or as pictures, but if you want to be able to view a total column easily, use the file names.  Copy the file names of the pictures, without the extension (.jpg, for example). And just in case you don’t know exactly how to copy and paste an image, follow these quick instructions:

-    With the mouse, highlight the image file name
-    Right-click and select ‘copy’
-    Go to the spreadsheet
-    Right-click again and select paste to place the file name in a row on the spreadsheet 

See?  In a quick and easy way, you will have all your wholesale jewelry pieces stored in your jewelry business inventory.  If you want to make it more sophisticated, just create a column for the actual thumbnail picture and include it in your inventory.

An inventory is a great tool if you want to stay on top of things and sort pieces easily.  If you’re looking for silver necklaces you have bought at different times, just sort the ‘type’ column and you will get all the data in an instant; however, remember to highlight the whole document before sorting it, or else, you will get all your inventory mixed up.  Just in case, save another copy as backup and never mess with it.

As you sell your pieces, simply enter a minus number and include a new total.  Your results will be a total cost of inventory on a daily basis.

You can find free spreadsheet programs online; no need to pay a fortune to get your wholesale jewelry professionally organized.

If you liked this article, tell all your friends about it. They’ll thank you for it. If you have a blog or website, you can link to it or even post it to your own site (don’t forget to mention www.paradisojewelry.com as the original source).

Tags: easy inventory, inventory, inventory control, inventory control system, inventory database, inventory management system, jewelry inventory, simple inventory, stock inventory, wholesale jewelry
Posted in Uncategorized | | No Comments »

Many experts believe that a successful supply chain management is based on the efficient logistics inventory management of inventories and inventory control. Different industries manage their inventories in a different way. These various inventory management also have different inventory costs. Understanding factors that affect this costs will help you decide whether to keep a large or small inventories.

In a way, food companies are quick to embrace a logistics inventory management strategies to reduce costs compared with the agribusiness industry. The Efficient Consumer response was introduced by several food manufacturers and grocers almost 20 years ago to move away from controlling logistical costs to examining supply chains.

The industry also realized then the importance of customer service as a crucial competitive differentiation point for firms which are focused on value creation for end consumers. Learning to characterize inventories into two distinct categories, such as cost reduction and improving customer service for the system to be effective.

The idea is to have a balance of inventories and solve the problem of maintaining a large inventory (which can lead to huge expenses) as against having too little inventory (which can also result to lost sales).

Most companies believe that reductions in inventory could result to reduction in costs in supply chain management. Since 1982, many companies have reported reduction in inventory costs by at least 60%, while hauling expenses also dropped by 20%. Most companies now are pushing for inventory reduction strategy in their supply line because of the marked reduction in inventory costs. But first, these companies must understand the principles of an effective logistical strategy, such as product demand, inventory costs, and supply chain capabilities.

For an effective logistics inventory management strategy, a company must use one of the three general approaches to management inventory. Step one is to monitor inventory levels by items, such as used by most retailers who use the inventory control approach. Second, manufacturers are typically more concerned with production scheduling and use flow management to manage inventories. Third, a number of firms (for the most part those processing raw materials or in extractive industries) do not actively manage inventory.

Tags: inventory, logistics, management
Posted in Uncategorized | | No Comments »