Warehousing and Logistics

This spreadsheet package leave alone help you employ the principles inAchieving Effective Inventory Management. Completely updated and expanded, this third edition of the spreadsheets features the new designed Inventory Performance Simulator, which combines the analysis performed by several of the previous(prenominal) spreadsheets. The spreadsheet package includes a CD-ROM, sample print-outs and detailed instructions for use. Youll find the avocation easy-to-use spreadsheets Spreadsheet 1 The Inventory Performance SimulatorThis spreadsheet whollyows you to perform forecasting, replenishment, and enthronement analysis on up to100 items at a time by loading your selective information into a single worksheet. Areas of analysis include Differentiating types of usage. For items with recurring usage, identify the exceed forecast formula from among nine methods preloaded into the spreadsheet calculate the forecast and suggested replenishment parameters. For items with stray usag e, calculate normal quantity sold/used in oneness transaction as well as minimum and maximum quantities. canvas your on-line(prenominal) chronicle value, turnover and return on investment to emf ideal values. You can then see how varying safety acquit and other parameters will affect your service level and inventory investment. rent user maintained controls to smooth out unusually high or low usage. Graphically review the history and suggested replenishment parameters of a item item comparing the results of all 11 forecasting methods. Compare the sure and potential values of these key metrics Inventory turnover secrete/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). Spreadsheet 2 Price Break (Item) If a vendor offers you a lower price per piece for a larger obtain quantit y, is it a good deal? This spreadsheet will help you make an prehensile decision. It compares the lower make up per piece to the cost of carrying inventory for a bimestrial period of time. It also takes into account the lower reordering cost per unit of measurement resulting from the purchase of larger quantities.The price break that provides the lowest Total price/Piece represents the best buy quantity. Spreadsheet 3 Price Break (Vendor Line) This spreadsheet compares the snub you will receive to the cost of carrying each purchase quantity for the distance 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 ofttimes each vaulting horses worth of inventory will cost when you consider both the discount and carrying cost. The lower the cost of a dollars worth of material, the better the deal.Spreadsheet 4 Price Break (Terms/Freight) With this spreadsheet, you will be able to consider frei ght, terms discounts and extended terms to go down which of three entered purchase quantities represents your best buy quantity. Spreadsheet 5 Value of upset Inventory This spreadsheet determines the amount of additional sales your company must depict to make up for the value of material that is lost, stolen or otherwise unusable. from each one of the spreadsheets is provided on a single CD-ROM, along with hard copies of the spreadsheets, and detailed instructions, all packaged in a sturdy binder.