An exciting new tool has just been released by EIM, Inc. that demonstrates the principles of effective inventory management! The set contains 12 different Excel spreadsheet templates loaded onto a CD-ROM, a hard copy of each spreadsheet, and detailed instructions, all packaged in an attractive binder. (If you would like to save shipping charges. the spreadsheet templates can be delivered electronically.) Achieving Effective Inventory Management spreadsheet templates provide valuable tools for any organization using any computer system. Spreadsheet templates in this package include:

• Comparative Forecast Calculations – For an individual product, this spreadsheet determines the most accurate of 15 forecast formulas based on the past usage history. This formula can be utilized to calculate accurate forecasts of future demand!

• 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.

• Planned Excess Spreadsheet – This spreadsheet is designed to set minimum and maximum parameters for stocked products that have sporadic usage. In addition it will determine the quantity and value of planned excess – that is, the quantity of the product that you might have on-hand in excess of the maximum quantity due to vendor package quantity requirements.

• 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.

Each spreadsheet template uses usage and other data you input or download from your computer system to provide you with the guidance you need to maximize the profitability and productivity of your inventory investment! You can also adapt our formulas into your own spreadsheets! Or if you prefer, EIM can develop customized spreadsheets to adopt the concepts and principles of effective inventory management to your entire inventory addressing your organization's specific needs. Please contact us if you would like to discuss this service.

Order today! You can order online at the EIM Store, or you can print out and fax the following form to our secure fax machine at (972) 393-1310 (it's in the United States). If you have any questions (or would like to place a phone order) please give us a call at (972) 304-3325 or email us at TinaSna@EffectiveInventory.com. You can also mail a completed form to: