"We Make Better Retailers..."

CAM32 Inventory Control

The CAM32 Inventory Control system offers numerous features to help you manage your inventory in a way that is meaningful to you. The software has been specifically designed to enable you to maximize the performance of your inventory investment. Fundamental to the Inventory Control system is the simplicity and ease of use in maintaining accurate controls over your inventory. In the inventory maintenance file, the user may attach a picture image by simply clicking the picture window on the screen and then clicking the image file name or typing it in. Thus, using a digital camera a buyer could take pictures of certain products at a trade show. Then, when entering inventory items into the system, the images could be captured on the inventory record to allow all personnel to identify the items. Vendor catalogs with images may be imported and stored for better customer service.

When ICAM is utilized to create an internet store these images can be displayed on your web store if you purchase this option. An additional benefit of the picture image is that it can automatically display at point of sale when the item is rung up. This will help ensure the right item is being sold and can eliminate "sticker switching."

This is the main menu for the Inventory Control Module, showing you the basic functions you can accomplish here.

This is the Inventory Master screen. It shows the"fields" of information stored in the basic inventory record.

This Multi-Vendor Maintenance Screen. Easily accessed by a function key.

Inventory Reports Menu:

The CAM system offers a multitude of reports to choose from, or you can quickly and effortlessly create your own reports using the system's "Select Data to Print" custom reporting feature. In each case, the system allows you to choose just those items you wish to see on the report. In addition to the system's standard selections, such as Department, Vendor, Location, and Description, you can also make up your own inventory groupings any way you want. You can use your imagination to create sub-departments, classifications, seasonal categories, price categories, etc. All custom reports can be displayed on the screen or printed.

This is the menu of choices of basic Inventory Reports available on the CAM system. More sophisticated reports and custom reporting are also available.

Some of the reports CAM offers:

Sales Ranking Report:

One of the most useful reports in the system is the Sales Ranking Report. This report allows the user to rank any group of inventory by gross sales dollars, sales in units, or gross profit. The user defines what constitutes an A, B, C, or D mover. The system then assigns a rank and stores it in the inventory rank. You could now ask the system to create an automatic reorder for all of your "A" rank items. Or, you might ask the system to bump prices by 2% on all "D" items in a specific department.

Price Rounding Report:

The Price Rounding Report rounds all prices within a certain group based on a pre-designed rounding table that you set up. Shows the overall effect on your store's gross margin of rounding prices for the group of items chosen. Also allows you to print price labels for the quantity on hand for those items whose retail price has changed.

Monthly History Report:

The Monthly History Report will show your trailing 13 month sales history for any group of items, or by department. In addition to units sold, you have the option, for each item, to show gross sales dollars, cost of sales, and gross margin percentage.

Inventory Valuation Report:

The Inventory Valuation Report allows you to value any portion of your inventory at replacement cost, average cost, and retail.

Cost of Sales Report:

The Cost of Sales Report shows the true cost of sales, down to the item level, for any group of inventory you choose.

Sales Analysis Report:

The Sales Analysis Report shown below is by department, on a month to date basis. This is an excellent tool that allows you to quickly view the performance of each department for the month. This report can also be run at the item level, allowing you to evaluate the performance of any item.

Overstock-Understock Report:

The Overstock Understock Report is especially useful for identifying overstocked items, so that you can take appropriate action; such as marking them down, moving them within the store, or just having sales people focus on selling these products.

Vendor Profit Analysis Report:

The Vendor Profit Analysis Report allows you to analyze the profitability and performance of your inventory by vendor.

Balance On-Hand by Location Report:

This report shows the balance on hand (B.O.H) and suggested stock level (S.L), by store, for each item. It also shows you the total balance on hand and on order, by item for all stores listed.

Portable Data Terminal:

The Portable Data Terminal (PDT) is a handheld device that allows you walk around your store and count your inventory as well as giving you the ability to create purchase orders, receive goods, check the accuracy of retail prices, and more easily facilitate transfers between stores in a multi-store environment. The PDT also allows you to type in the SKU number or scan the item's bar code using the optional scanning device that attaches to the PDT. Once you have taken your physical inventory, entered the items to be purchased or received, or entered the items to transfer along with their quantities, you can connect the PDT to the computer using a special cable and send all of the data stored in the PDT to the computer. The system will then process the information and provide you with the appropriate reports and audit trails, allowing you to make changes or adjustments before allowing the system to update your files automatically.

The use of PDT's has been a key element in helping many CAM32 customers maintain extremely accurate inventories, along with significantly reducing the time it takes to receive inventory, take physical inventory, and to transfer inventory among different store locations. The PDT may also be used for creating and receiving purchase orders.

Unit Control Master Record:

For items that you want to track by serial number, the Unit Control/Serial Number Control program will automatically prompt you for serial numbers during receiving. This starts the process of tracking serialized items so that they can be accurately tracked until they are sold at POS. If you don't know the serial number, the system will assign a unit control number. The program will also handle serialized items that need to be tracked by make, model, year, date received, PO number, or as assembled or unassembled. The system will generate the proper tracking forms, and, if needed, track where each item is stored.

This screen shows how the Unit Control/Serial Number Control Record looks for an inventory item. It shows the information tracked for each serialized item.