#7024 - Inventory Scheduling With Excel - Weekly Stock Scheduling.
" The problem is our inventory values keep increasing and our stock turnover goes from bad to worse! I want a program that lets me
know exactly when to re-order so that materials arrive JIT before an out of stock situation occurs. "
This customer purchased our inventory scheduling system for Excel:
1. Excel spreadsheets organize delivery timetables and stock level forecasting into JIT purchasing schedules.
2. Spreadsheet calculations tell you when to issue purchase order to sustain JIT minimum stock balances.
3. Provides closing weekly inventory balance forecast spreadsheets - for each stock item.
4. Provides weekly purchasing requirement planning spreadsheets for individual stock items.
5. Provides When to re-order dates to maintain minimum stock levels.
6. Provides statistical analysis spreadsheets with embedded Excel stat functions for JIT inventory management.
7. Excel Inventory Database plus built-in LookUp functions.
8. Excel Supplier Database linked to Purchase Order template plus LookUp functions.
9. Capacity for 1,250 inventory items database and 2,500 purchase orders at any one time.
10. Tutorial version containing complete JIT method explanation.
The download file contains the tutorial version. If you need a completely empty program version please ask and we will add this to your download site (at no additional charge).
The download file is zipped. After downloading, locate the zipped file and double click to expand into a standard Excel file.
Plus:
Now installed are permanent web query links that grab data from financial web sites where we believe that the data is directly relevant to the tasks performed by the spreadsheets. This will enable you to apply current and latest inventory benchmarks within your company.
