MMS Data Files
MMS starts with a Batch Update.  This function takes the latest data from current Stock Status systems and brings that data into MMS.  This file is usually extracted as  NEWLOAD.XLS a Microsoft Excel file.  The following fields must be extracted from the user's Stock Status system - the order is important:

Field Field Name Field Description Field Range Notes
1 Item Item Number, SKU 20 Alpha-Numeric  
2 Location Warehouse, Branch 20 Alpha-Numeric  
3 Description Long Description of Item 30 Alpha-Numeric  
4 On Hand Available Stock on Shelf 8 Numeric 0 – 99,999,999
5 On Order Stock already ordered & scheduled 8 Numeric 0 – 99,999,999
6 Incremental EOQ Package Size (i.e. pack of 10) 8 Numeric 0 – 99,999,999
7 Number in Service # of Items in the field (in service) 6 Numeric Ignored if blank - substitute usage levels
8 Part Cost Item Cost 10.2 Numeric 0.01 – 99,999,999.99
9 Service Level Criticality of Item 2 Numeric 88 - 99
10 Carrying Cost Storage as a % of total cost 2 Numeric 0 - 50
11 Lead Time Time to procure Item (weeks) 2 Numeric 1 – 99 weeks
12 Ordering Cost Administrative cost to place orders 7.2 Numeric 0.00 – 99,999.00
13 Cut-off Threshold for “slow moving”
 
(48 = usage < 48 is slow moving)
4 Numeric  0 – 9,999
14 Year 1 Total usage from 3 years ago 8 Numeric 0 – 99,999,999
15 Year 2 Total Usage from 2 years ago 8 Numeric 0 – 99,999,999
16 Year 3 Total Usage from last year 8 Numeric 0 – 99,999,999
17 MIN Quantity to trigger an order 8 Numeric 0 – 99,999,999
18 MAX Maximum # of units to stock 8 Numeric 0 – 99,999,999



 

This NEWLOAD.XLS file can be re-created to update MMS on a regular basis.  It is extremely crucial to have up-to-date information when determining New MIN and New EOQ values.  Extractions and MMS processing should be done regularly.

Once the NEWLOAD.XLS file has been reviewed and approved, the Batch Update function should be used.  When run, this update will synchronize data in the MMS database to the user's Stock Status system.  MMS will, however, retain critical values that the user may have previously saved.  Other specific fields will be updated by new data.  Saved items will retain some key fields - otherwise all fields will be refreshed at each download process.  New calculations willl be completed for all items in both cases since a New MIN and/or New EOQ could be changed at any time.  Such changes are much more stable when variables are saved.