|
SCREENS
Quick Start introduction & overview.
Help with using Excel database functions within the program.
Create your Inventory Lists Database with Safety Stock and Supplier
delivery day per product. |
|
Enter outstanding Purchase Orders by items, quantities and date of
issue. |
|
||
|
|
The Weekly (Forecasting) Schedule spreadsheet calculates your forward weekly demand by item, and number of days until delivery. You can overwrite the demand forecasts if you wish to create current weekly demand forecasts.
The Weekly Re-Order table forecasting spreadsheet calculates closing weekly stock balances for each stock item for 10 weeks ahead.
The same spreadsheet forecasts your weekly re-purchase requirements – by volume, to maintain your safety stock levels.
The same spreadsheet calculates re-order requirements by weekly date scheduling.
Back Order reporting for each inventory item.
To Start your journey into the statistical methods needed to manage JIT systems, this table helps create your database of Supplier performance statistics. Use this data in the Analyzing Delivery Stats spreadsheet.
More information about statistical analysis of supplier reliability which allows you to set lower minimum stock levels is provided in the tutorial demo accompanying the program.
Inventory Manager PRO For Excel
$169.95 $139.95 Secure Payment Options
Buy as part of All Excel Templates Gold Edition - HUGE Value - 80% Discount!
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $69.00. ALL purchases totaling over $138.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft