Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Weekly Re-Ordering Scheduling Screen Shots

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Inventory Scheduling Excel Templates Start

SCREENS

Quick Start introduction & overview.

Overview

Help with using Excel database functions within the program.

Help Database

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.

Inventory Database
Delivery Forecasting

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.

Weekly Forecast

The Weekly Re-Order table forecasting spreadsheet calculates closing weekly stock balances for each stock item for 10 weeks ahead.

Weekly Re-order Schedule

The same spreadsheet forecasts your weekly re-purchase requirements by volume, to maintain your safety stock levels.

Weekly Re-order Schedule

The same spreadsheet calculates re-order requirements by weekly date scheduling.

Weekly Re-order Schedule

Back Order reporting for each inventory item.

Back Orders

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.

Calculating Delivery Days

Inventory Scheduling Excel Templates Start

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