|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.|
|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.
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.
Please sign in to leave a comment.