EIM

Spreadsheets, Version 6.1

Eleven Excel-based tools built around the principles in Achieving Effective Inventory Management, 7th Edition. Forecast demand, evaluate vendor offers, calculate carrying costs, and run “what if” scenarios on your own data.

The complete toolkit for analyzing your inventory

The EIM Version 6.1 spreadsheet set is the perfect companion to Achieving Effective Inventory Management, 7th Edition. All 11 inventory-analysis spreadsheets have been updated with new features designed to help organizations put the principles of effective inventory management into practice. The enhanced Forecasting and Analysis Spreadsheet now lets you analyze up to 100 items at a time by loading your data into a single worksheet.

What you get in the set

Analyze up to 100 items at once. Determines the best of ten forecast formulas for each item.

Compare quantity breaks for a single item to identify the best deal across material, carrying, and ordering costs.

Identify the best buy across competing vendor offers, factoring in carrying costs.

Factor extended terms, terms discounts, and freight into purchase quantity decisions.

Evaluate whether a vendor rebate offer is actually a good deal by comparing extra carrying cost against the rebate.

Calculate the additional sales required to make up for lost, stolen, or damaged inventory.

Factor in freight, duties, inspection, and repackaging to find your true total cost of inventory.

Determine what it actually costs to fulfill a one-to-12-line outgoing order.

Calculate your K Cost and R Cost, the foundation for economic order quantity decisions.

Run "what if" scenarios on forecasts, costs, lead times, and order cycles. A great training tool for new buyers.

Find the right quantity to buy ahead of a vendor price increase to minimize total cost.

A comprehensive guide covering all 11 spreadsheets, included with the set.

Get the full set, delivered electronically

Eleven spreadsheets and complete documentation, sent directly to you after purchase.
Questions before you buy? Call 972-304-3325 or email info@effectiveinventory.

EIM