Inventory Scheduling With Excel Spreadsheets – J.I.T. Weekly Re-Ordering Scheduling

Inventory Scheduling With Excel – J.I.T. Weekly Re-Ordering Scheduling

(Any Version of Excel)
Download or CD Edition

alt


SCREENS

Quick Start introduction & overview

overview.jpg (78083 bytes)

Help with using Excel database functions within the program.

Excel database functions

help_database.jpg (56820 bytes)

Create your Inventory Lists Database with Minimum Stock levels and Supplier delivery schedules per item.

Inventory Lists Database with Minimum Stock levels and Supplier delivery schedules per item

inventory_database.jpg (30890 bytes)

Enter outstanding Purchase Orders by items, quantities and date of issue.

outstanding Purchase Orders by items, quantities and date of issue

delivery_forecasting.jpg (36728 bytes)

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 (Forecasting) Schedule spreadsheet

weekly_forecast.jpg (77195 bytes)

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

Closing weekly stock balances for each stock item for 10 weeks ahead

weekly_reorder_schedule.jpg (67390 bytes)

Scroll right for weekly re-purchase requirement scheduling – by volume to maintain minimum stock levels.

Re-purchase requirement scheduling – by volume to maintain minimum stock

weekly_reorder_schedule_2.jpg (66418 bytes)

Scroll right again for weekly re-purchase requirement scheduling – by week ending dates.

Weekly re-purchase requirement scheduling

weekly_reorder_schedule_3.jpg (65868 bytes)

This spreadsheet updates the current back order totals for each inventory item.

Current back order totals for each inventory item.

back_orders.jpg (54588 bytes)

To start setting up a new JIT system, this table helps you organise your Supplier delivery schedules data.

Full information and guidance how to organise and calculate supplier delivery reliability data to set JIT least cost minimum stock quantities is provided in the tutorial demo which accompanies the program.

How to organise and calculate supplier delivery reliability data

calculating_delivery_days.jpg (52958 bytes)

Order

Additional Information: Inventory Manager PRO For Excel

30 day money-back guarantee!

Platform : Windows or Mac  &  MS Excel 97 or later or MS Office 97 or later.

Buy Online

$139.95


Inventory Scheduling is a part of  All Programs Gold Edition Collection which contains also many other business support programs.

Additional Information: All Programs Gold Edition
OS : Windows 98 or later.

Excel 97 or later. Web data requires Excel 2000 or above and Windows XP/2000/2003 or later.

30 day money back guarantee!

Buy Online  $169.95

Regular Price : 299.95


Copyright © Millennium Software All Rights Reserved