Spreadsheets to Achieve
Effective Inventory Management

Three-ring binder, 12 Excel spreadsheets on PC compatible disk, $69.00. Order Now

Spreadsheets to Achieve Effective Inventory Management includes 12 key spreadsheets developed to accompany the policies and procedures discussed in the Achieving Effective Inventory Management handbook.

Using the spreadsheets and your own data will provide the information you need to better manage your inventory.

The set contains 12 Excel spreadsheets on a PC compatible disk, a hard copy of each spreadsheet, and detailed instructions for their use, all packaged in an attractive binder.

These spreadsheets are valuable tools, which will provide vital information about your specific inventory situation. Spreadsheets in this package include:

• Comparative Forecast Calculations — Determines the most accurate of 15 forecast formulas based on the 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 the calculated forecast demand.
• Safety Stock Calculator — Calculates safety stock quantities based on the average difference between the forecast of demand and actual usage. This spreadsheet will also compute the investment necessary to maintain the safety stock quantity that is usually required to maintain various levels of customer service.
• Minimum/Maximum Analyzer — This spreadsheet will identify items with sporadic sales and suggest minimum and maximum stocking parameters based on the average sale quantity and optional safety stock quantity.
• Inventory Analysis — This spreadsheet calculates the adjusted margin (gross margin less the cost of carrying the average inventory investment) for each product rank as well as the savings that can be obtained (in both inventory investment and carrying cost) by achieving the target turnover.
• Value of Lost Material — This spreadsheet determines the amount of additional sales your company must generate to make up for the value of material that was lost, stolen, or is otherwise unusable.
• Excess Inventory — This spreadsheet determines what portion of the current available 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 — If you are using a system that is based on the philosophies of Gordon Graham, this simulator will help determine 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) — This spreadsheet 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. You will also receive a spreadsheet that will perform this analysis for an individual item.
• Ranking Analysis (Cost of Goods Sold) — This spreadsheet will classify items in “A,” “B,” “C,” “D,” and “X” categories based on their contribution to the total cost of goods sold.
• Ranking Analysis (Hits) — This spreadsheet will classify items into “A,” “B,” “C,” “D,” and “X” categories based on the number of times the product was sold, regardless of quantity. This is a valuable tool for identifying those products that are most important to your customers as well as organizing your warehouse for maximum picking efficiency.

About the Author

Jon Schreibfeder is president of Effective Inventory Management Inc. Over the past 18 years, Jon has helped over one thousand companies improve their productivity and profitability through better inventory management.

A featured speaker at international seminars and conventions, Jon has earned the title of “Inventory Subject Expert” from the American Productivity and Quality Center.

Your Guarantee of Satisfaction

If for any reason you are not totally satisfied with Achieving Effective Inventory Management, simply return it within 30 days for a complete refund.

Order Now