An exciting new tool has just been released by EIM, Inc. that implements the principles of effective inventory management! The EIM Version 3 Spreadsheets feature our newly designed EIM Inventory Performance Simulator which combines the analysis performed by several of our individual spreadsheets into one! And, it will allow you to perform the analysis for up to 100 items at a time just by loading your data into a single worksheet.

The EIM Version 3 Spreadsheets contain:

• The EIM Inventory Performance Simulator
• Four additional Excel spreadsheet templates:
  • Price Break (Item)
  • Price Break (Vendor Line)
  • Price Break (Terms – Freight)
  • Value of Lost Inventory

These features are loaded onto a CD-ROM, which is packaged in an attractive binder along with a hard copy of each spreadsheet and detailed instructions. The spreadsheet templates, instructions, and visuals also can be sent electronically if you would like to avoid shipping charges. EIM Version 3 Spreadsheet templates provide valuable tools for any organization using any computer system.

Features

Perform forecasting analysis on up to 100 items at a time by just loading your data into one single worksheet. In one data entry action, automatically populates data and calculation fields on several worksheets which previously had to be done separately. Areas of analysis include:

• Differentiate types of usage.

• For items with recurring usage: Identify the best forecast formula from nine methods preloaded into the spreadsheet, and calculate the forecast and suggested replenishment parameters:

  

• For items with sporadic usage: Calculate normal quantity sold/used in one transaction as well as minimum and maximum quantities:

  

• Compare your current inventory value, turnover and return on investment to potential "ideal" values. You can then see how varying safety stock and other parameters will affect your service level and inventory investment:

  

• Employ user-maintained controls to smooth out unusually high or low usage:

  

• Graphically review the history and suggested replenishment parameters of a specific item, comparing the results of all 11 forecasting methods:

  

• Compare the current and potential values of these key metrics:
  • Inventory turnover
  • Turn/earn index
  • Gross margin return on Investment
  • Adjusted gross margin (i.e., gross margin considering your average inventory investment)
  • Percentage of excess Inventory
  • Planned excess (what vendors force you to buy in excess of what you need)

  

The new EIM Version 3 Spreadsheet release also includes the following spreadsheets to enhance your inventory decisions:

• Price Break by Item: If a vendor offers you a lower price per piece for a larger purchase quantity, is it a good deal? This spreadsheet will help you make an intelligent decision. It compares the lower cost per piece to the cost of carrying inventory for a longer period of time. It also takes into account the lower reordering cost per unit resulting from the purchase of larger quantities. The price break that provides the lowest Total Cost/Piece (last column) represents the best buy quantity.

• Price Break by Vendor Line: Compares the discount you will receive to the cost of carrying each purchase quantity for the length of time necessary to sell the entire amount (based on your current overall forecast for the vendor line). The result is a calculation of how much each dollar's worth of inventory will cost when you consider both the discount and the carrying cost. The lower the cost of a dollar's worth of material, the better the deal!

  

• Price Break with Freight Allowance and Terms: Allows you to consider freight, terms discounts, and extended terms in deciding which of three entered purchase quantities represents your "best buy" quantity.

  

• Value of Lost Material: 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.

  

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.

Currently using the EIM Spreadsheet Set?

Wondering how Version 3 is different? Below is a list of the key elements that make the Version 3 Spreadsheets different and improved over the EIM Spreadsheet Set.

NEW FEATURES!!

• Performs forecasting analysis on up to 100 items at a time (instead of one item at a time) by just loading your data into one single worksheet. In one data entry action, automatically populates data and calculation fields on several worksheets, which previously had to be done separately.

• Provides current forecasting and suggested replenishment parameters for all 100 items.

• Compares your current inventory value to an ideal inventory investment.

• Allows you to modify parameters to calculate how much inventory is needed to achieve a desired level of customer service.

• New Price Break with Freight Allowance and Terms spreadsheet: Allows you to consider freight, terms discounts, and extended terms in deciding which of three entered purchase quantities represents your "best buy" quantity.

Order today! You can order online at the EIM Store, or you can print out and fax the order 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: