Inventory using Demand and Purchase

Crosstab Name	Inventory using Demand and Purchase
Description	Calculates projected inventory levels using the formula: Inventory = Previous month inventory - Forecast Demand + Projected Purchases
Number of Files	3 files required (File 1: Inventory, File 2: Demand Forecast, File 3: Planned Purchases (receipts))
Database Validity	Can be applied to Sales databases that include the above files.
Variants	None
Extra Notes	Does not use any classification variables, so is applicable to all databases. Files 1, 2 and 3 must be apportioned correctly, hence the sequence of files is significant. Variance option must be Period Totals only.

Example

You want to see the current levels of inventory you have and how these will be affected by the current forecast.

For information on how to import this Crosstab Definition please see How to Import a Crosstab Library File.