Home > Excel Business Solutions > Operations and Management > Supply Chain and Inventory > Inventory Scheduling Share

Inventory Scheduling

Excel inventory scheduling for supply chain and inventory

Excel Inventory Scheduling

Rate this solution:
(2.6/5 from 7 votes)
Inventory Scheduling screenshot
Inventory Scheduling for Excel is an application which allows you to know exactly when to re-order so that materials arrive Just In Time (JIT) before an out of stock situation occurs. This Excel inventory scheduling application:
  • Translates purchase order/delivery histories into minimum stock management scheduling, and
  • Schedules re-ordering quantities and dates.

Key Features include:
  • Excel spreadsheets organize delivery timetables and stock level forecasting into JIT purchasing schedules.
  • Spreadsheet calculations tell you when to issue purchase order to sustain JIT minimum stock balances.
  • Provides closing weekly inventory balance forecast spreadsheets - for each stock item.
  • Provides weekly purchasing requirement planning spreadsheets for individual stock items.
  • Provides When to re-order dates to maintain minimum stock levels.
  • Provides statistical analysis spreadsheets with embedded Excel statistical functions for JIT inventory management.
  • Excel Inventory Database plus built-in Look Up functions.
  • Excel Supplier Database linked to Purchase Order template plus LookUp functions.
  • Capacity for 1,250 inventory items database and 2,500 purchase orders at any one time.
  • Tutorial version containing complete JIT method explanation.

Get It

(Pricing is available on the next page)
(Updated on 2018-04-01)

Related Excel Solutions for Inventory Scheduling

Construction Schedule TemplatesProject Management  Inventory ManagementSupply Chain and Inventory  Inventory TrackingSupply Chain and Inventory  Supply Chain Balanced ScorecardSupply Chain and Inventory  Resource ManagementManufacturing and Engineering

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.