Aim For Improvement

Public outrage over the attempted assassination of President Ronald Reagan could have spelled the end for Tippmann Pneumatics. The company, which made half-scale, collectible machine guns, could have been regulated out of business. Instead of giving up, founder Dennis Tippmann Sr. redirected his focus toward paintball, a sport in which players barrage each other with paint-filled pellets launched from “markers,” guns powered by carbon dioxide or compressed air.

Tippmann Sports (the company name changed in 2004 when it was sold to a private investment group) is now the leader in what IT Director Doug Spieth estimates is a $350 to $400 million market.

The company occupies a 30,000-square foot manufacturing space supported by a 40,000-square foot warehouse with four order pickers, a supervisor, a receiving clerk and an inventory manager. Initially, the company distributed its products through dealers, but today, it deals directly with a network of 3,000 individual stores as well as with mass merchandisers like Wal-Mart and Sports Authority.

The company's warehouse operations are basic, using lift trucks to collect and deliver raw materials to the manufacturing floor, pallets of finished products from manufacturing to storage and customer orders to the staging area for shipment. Since 1999, the company has used Microsoft Dynamics GP (initially Great Plains Software) as its enterprise resource planning (ERP) solution, executing the flow of components and finished goods through the system's inventory management module.

Tippmann normally manufactures 1,500 to 2,000 markers per day, each having about 150 raw components ranging from bolts and screws to injection-molded plastic parts. Only about 5% of components are manufactured internally. On arrival at the dock, the hundreds of parts were staged, counted and compared with the packing slip. The invoice would go to accounts payable, and the shipment would be keyed in to the ERP software.

Microsoft Dynamics offers an inventory management module, but it is entirely reliant on paper- and screen-based processes for receiving, inventory tracking and transfer and picking/shipping. As a result, inventory was tracked only to the warehouse level because the volume of transactions made manual bin-level control unrealistic.

Warehouse operations were not well organized, Spieth recalls, with raw materials and product normally placed on a space-available basis. When draw-down was required, either for raw materials and components for manufacturing or shipment of finished goods, warehouse personnel — most of them longtime employees with knowledge of warehouse geography — would visually search for the materials, pick the required product and deliver it.

When finished goods were returned to the warehouse from manufacturing, raw materials were relieved from the warehouse. The number of markers and part numbers they represented were recorded on paper, and this data was keyed into the system to adjust inventory records.

Then, in 2007, Tippmann implemented Accellos One Collect. This allowed the company to turn on Microsoft Dynamics' bin allocation capability, automate the end-to-end inventory management process and eliminate virtually all paper-based receiving, inventory management and picking processes.

“There was no easy way for us to do those transactions within the Dynamics GP product prior to the implementation of Accellos One Collect,” Spieth says.