Description

The economic challenges facing wholesaler-distributors today have resulted in the release of the fifth edition of Jon Schreibfeder’s Achieving Effective Inventory Management. This 2010 edition includes updated discussions regarding the impact and adjustments the current economic challenges have produced in all areas of inventory management. Just as easy to read as the earlier edition, this book will help you follow the path that leads to maximizing the productivity and profitability of your investment in stock inventory. Included with the workbook is a CD-ROM containing the “Carrying Cost Calculator,” which will determine the cost of storing inventory in your warehouse. A spreadsheet disk and workbook created exclusively for the NAW Institute for Distribution Excellence are also available.

What Readers Have to Say

"Jon Schreibfeder's Achieving Effective Inventory Management is a wonderful, easy-to-read, comprehensive guide to organizing your warehouse, establishing policies and procedures, forecasting future demand of products, and planning for the replenishment of stocked items. It is a great tool in helping us overcome our inventory challenges."

— Bill Holt, Operations Manager, A.M. Leonard Co.

Extended Description

As an essential companion piece to Achieving Effective Inventory Management, Fifth Edition, an exciting new tool is available. It is designed to help you work with the book and make the most of your inventory investment using information provided by your current business software system.

The set contains 12 different Excel spreadsheets on CD, and a hard copy of each spreadsheet and detailed instructions, all packaged in an attractive binder. These Achieving Effective Inventory Management spreadsheets are invaluable tools for wholesaler-distributors using any computer system. They provide vital information about your specific inventory situation:

• Comparative Forecast Calculations — Determines the most accurate of 15 forecast formulas based on past usage history of an item.
• Unusual Usage Identifier — Identifies products that may have experienced unusually high or low usage by comparing actual usage to forecast of demand.
• Safety Stock Calculator — Calculates safety stock quantities based on the average difference between the forecast of demand and actual usage. It also computes the investment necessary to maintain a sufficient safety stock quantity.
• Minimum/Maximum Analyzer — Identifies items with sporadic sales and suggest minimum/maximum stocking parameters based on average sales quantity and optional safety stock quantity.
• Inventory Analysis — Calculates the adjusted margin for each product rank, as well as savings that can be obtained by achieving the target turnover.
• Value of Lost Material — Determines the amount of additional sales that must be generated to make up for the value of material that is lost, stolen, or otherwise unusable.
• Excess Inventory — Determines what portion of the current quantity of each item is in excess of an “x” month supply. It also calculates an excess inventory value for each item as well as a grand total for all excess material listed on the report.
• Rolling Average Simulator — Determines the effect of changing the lead time, review cycle, carrying cost, and/or cost of ordering on your replenishment parameters and inventory investment.
• Price Break Analysis (Vendor Line) — Compares the additional discount you receive for placing a larger total vendor order with the cost of carrying more inventory for a longer period of time.
• Ranking Analysis (Cost of Goods Sold) — Classifies items into A, B, C, D, and X categories based on their contribution to the total cost of goods sold.
• Ranking Analysis (Hits) — Classifies items into A, B, C, D, and X categories based on the number of times the product was sold, regardless of quantity.

Each spreadsheet utilizes data (such as historical usage statistics and on-hand quantities) that you input or download from your computer system to provide guidance in maximizing the profitability and productivity of your inventory investment.