| General Description of The History File MYGATEFH.TXT |
|
|
|---|
| There is generally a history record for each location and item | |
| containing The following fields : | |
| Number | Content | Example |
| 1. Location | Plant , Warehouse , Distribution Center | DENVER |
| 2. Item Number | Item code | 134-789-0A |
| 3. Item Description | Item characteristic or name | Yellow 50 Watt Florescent Light Bulb |
| 4. Vendor code | Who is the ultimate source vendor , plant , warehouse number abbreviation | GE |
| 5. Product Class | Grouping of items by family or generic code | FLORESCENTS |
| 6. Management Code | Grouping of items by buyer or work center | HARDWARE |
| 7. Type | Type of item : Y = Make to stock NS = Make to order NB = discontinue | Y |
| 8. Safety Time | Minimum time supply in weeks (Adds to Vendor Safety Time) | 0 |
| 9. Safety Quantity | Minimum quantity to keep on hand | 0 |
| 10. Lead Time | Minimum resupply time in weeks (Adds to Vendor Lead Time) | Y |
| 11. Unit Cost | Value of 1 unit of sales history | 1.1516 |
| 12. Minimum | Minum Order Size(Usually the same as the Multiple) | 100 |
| 13. Multiple | Ship Pack | 100 |
| 14. Weight | Heaviness of 1 unit of sales history | .086 |
| 15. Other Unit of Measure | Unit Factor(s) of 1 unit of sales history | .07 cubes |
| 16. Unit of Measure Description | Cartons , Gallons , Packs of 100 , Pallets , etc. | Eaches |
| 17. On Hand | Physical count (or equivalent) of quantity in inventory | 1265 |
| 18. Month to date sales | Shipped so far this month in unit of measure | 25 |
| 19. Blank | Not Needed | H |
| 20. Most recent complete month of sales | For example how many we sold in August | 37 |
| 21. Month before that complete month of sales | For example how many we sold in July | 45 |
| 22. Month before that complete month of sales | Keep going back in time June etc. up to 48 months | 69 |