Progressive Distributor
Keeping tabs on costs

Deco Tool Supply helps customers reduce costs by keeping closer tabs on inventory.

by

Production facilities that want to reduce costs typically look at the price they pay and the number of tools they buy. Thanks to prodding from distributors like Deco Tool Supply Company headquartered in Davenport, Iowa, a growing number of companies are beginning to understand that they need to pay attention to more than just price.

Deco uses sophisticated inventory management tools that provide flexibility in how they track and report information to customers, making it easier to watch over their tooling and other MRO supply costs more closely.

“More and more customers are discovering that they don’t have control of their MRO supplies,” says Brad Burch, manager of Deco’s integrated supply division, PRISM, which stands for Process and Inventory Systems Management. “They spend a tremendous amount of time, energy and money sourcing those items. Plus, they don’t have any way of gathering that information.”

When you consider the thousands of cutting tools, carbide inserts, abrasives, tool and die supplies, precision measuring equipment and other consumable maintenance, repair and operations supplies that plants typically consume, managing those items creates huge headaches.

Enter Deco Tool Supply.

Utilizing bar code scanning technology, a tool crib management software package, automated tool dispensers, laptop computers and portable printers, this Midwest-based distributor specializes in helping production facilities manage what many considered unmanageable.

Deco uses WinWare’s CribMaster Windows-based software package designed specifically to manage tool cribs in industrial facilities. It tracks a variety of data that customers previously either didn’t bother to gather, or gave up because it proved too difficult.

For example, Deco manages all of the perishable tooling used by a hydrostatic transmission manufacturer with five separate plant locations. Since taking over inventory management responsibilities for the customer, tooling costs per part shipped dropped by nearly 40 percent and Deco documented more than $1 million in cost savings in one year.

It didn’t generate the savings by simply selling tools at lower prices. Instead, Deco analyzed where and how end-users use tooling, which enabled them to make suggestions for cost-saving process and applications improvements.

Numbers don’t lie
Here’s an example of how better data leads to cost-cutting opportunities: Suppose a customer issues carbide inserts from several tool cabinets located throughout a shop. Each month, the shop foreman receives a series of printouts from Deco showing the number of inserts issued from each cabinet, the piece cost, the average inventory on hand, total number of transactions and more (see sidebar, “Measuring Performance”). Analyzing the data, the shop foreman can quickly recognize unexpected spikes in usage, see where most of his inventory dollars are being tied up and have a better idea of where to focus his resources to get costs in line.

The CribMaster system has more than 150 standard reports, but Deco also customizes reports using report writing software from Crystal Reports.

“We can generate a number of special reports to give the customer information about inventory turns, price savings, usage reports, slow moving inventory and other information they may need,” says Burch.

At some locations, Deco trained customers to manage the inventory themselves, with Deco’s information technology (IT) people providing technical support. In other cases, Deco’s onsite representatives handle all ordering, stocking and inventory management responsibilities. In either case, when inventory leaves the tool crib or point-of-use cabinet, it’s scanned into the system.

“We document what’s been taken by machine number or by part number or however the customer wants to gather information,” Burch says. “We’re able to give him information about exactly what is being used and where.”

Getting an accurate picture
One of the most important pieces of information that Deco keeps tabs on is inventory turns. But it draws a distinction between how it reports turns compared to other companies.

“A lot of software programs use turn reports that are snapshots,” Burch says. They simply report what inventory was in stock on a given day. Deco uses a more classic definition of turns when it reports tool crib inventory to customers. Its reports measure the average daily turns for an item over a defined period of time.

Why is that important? Companies that use the snapshot approach run the risk of viewing a skewed picture. If they happened to receive a big shipment on the day the snapshot was taken, inventory levels will appear high. If inventory was low when they took the snapshot, it makes turns look high. By looking at an average daily balance over a 30-day, 60-day or even a 12-month period of time, it eliminates spikes caused by seasonality in product usage and paints a much more accurate picture.

Customers also benefit from information on demand. Because Deco route people are equipped with a scanner, a portable printer and a laptop computer with a customer’s database installed, they can scan inventory, print out a purchase order or even print out a usage report for a customer on the spot.

“We can generate an order out of CribMaster, e-mail it directly into our Prophet 21 system, and have the order shipped while we’re still on site,” Burch says.

In the past, they’d take out an Excel-generated spreadsheet, do a manual inventory count and enter the data onto the spreadsheet by hand, then bring it back to the office for someone to load into the system. Information that used to take days or even weeks to gather now takes hours.

Better quality information leads to better decision making. Better decisions lead to cost savings. And, as smart customers are finding out, that’s much more important than getting the lowest price.

This article appeared in the May/June '02 issue of Progressive Distributor magazine. Copyright, 2002.


Measuring performance
Deco Tool Supply Company of Davenport, Iowa, utilizes a variety of reports including turn reports, inventory value reports, ranking reports and pricing analyses – to show customers how to manage their tooling. PRISM division manager Brad Burch or an onsite manager typically present the reports to customers in Microsoft PowerPoint. Here are samples of three Deco reports.

Turn report
This turn report allows Deco to analyze the turn rate for individual items and individual stock locations. It helps set order point/order quantity and min./max. levels. It's helpful in determining the optimum stocking point as well as in identifying inventory items with slow movement.

Item Avg.
 Invt'y.
Piece Cost $ Avg. Invt'y $ Sales (Issues) Turns Crib Bin
AS-1 1.6 $1.45 $2.32 $0 0.000 01-AS-
B10-1A10
AS-2 2.7 $450 $1,215 $900 0.741 02-A2-
B10-A11
AS-3 3 $3 $9 $18 2.000 01-A2-
B10-A12
AS-4 5 $56.66 $280 $168 0.600 01-A2-
B10-A13

Ranking report
The ranking report allows a customer to view items issued over a self-designated time frame. It is helpful when considering order point/order quantity or min./max. levels, and determining order frequency. Deco utilizes this report to help manage satellite cribs and other stocking locations. It is also helpful in projecting usage, negotiating pricing and identifying the top and bottom items for establishing inventory classification.

Transaction Count Item Number Descrip. Item Total Total Cost  Crib
78 A Insert 1 3090 $30,190.30 10
137 B Insert 2 1351 $12,618.34 02
89 C Insert 3 503 $8,241.83 06

Inventory value report
This report allows a customer to view not only his entire inventory value for a self-designated time frame, but also the value of the individual items making up the total figure. Deco uses this report to monitor the effectiveness of inventory reduction efforts.

ID Date Value Sppl'r Item Class Spc'l Status Code Item No. Crib
256  2/26 $56,604.16 ABC Face 110 A A1 1
269 2/26 $332 ABC Filter 111 B DE1 1
270 2/26 $22 V-ABC Sponge 215 B C112 2
271 2/26 $440 CDE Widget 327 B GFR-1 11
272 2/26 $648 CDE Widget 327 A GFR-1 11

Return to story

This article originally appeared in the May/June 2002 issue of Progressive Distributor. Copyright 2002.

back to top                                      back to e-business archives

 

Check out these stories:

United we stand

Clicks & mortar