ppt课件-thebestinventoryspreadsheetever-apics254.pptVIP

The Best Inventory Spreadsheet Ever Chuck Benfield, CFPIM How to Match the System to Your Business Data What factors need to be considered? Service level desired Lead time Safety stock levels Demand data Lot size Cycle stock Spreadsheet can be developed for raw materials, WIP, and finished goods Service Level Management should define this Statistically based calculation The higher the desired level, the higher the inventory Manually enter the value by category Lead time In this spreadsheet it is defined in months Examples: one week lead time = 0.25, six week lead time is 1.50 Enter manu