The Stand Sheet Forecast Report is located on the Forecasting tab of the Reports menu and considers the par levels set on the Inventory tab of the Item Editor for each Inventory Location. The report calculates the cost to replenish inventory levels to the set par levels.
The wizards allow you to select an existing Stand Sheet upon which to base the report. You also can choose to include items with zero requirements (i.e. no set par levels) on the report.
Next, the wizard allows the creation of a Requisition or Shopping List upon generation of the report.
If a Requisition is to be created, you must select the source (Inventory Location) of that Requisition.
You have the choice of creating a single Requisition for all locations on the form, of creating a separate Requisition for each Profit Center, or of creating one for each Location.
You must also indicate on this wizard window whether to use Minimum or Maximum Par Levels as criteria for determining the reorder quantities.
Finally, you can choose to generate a detailed report, a summary, or both.
The detailed report lists the Current On Hand Amounts and their Cost (Value) in their respective Purchase Units. It lists the Minimum and Maximum Par Levels and the amount needed to reach par. Based on the unit cost of each item, the report lists what the Cost would be to replenish the items to either Minimum or Maximum par.
The summary version of the report lists the Current On Hand Cost (Value) of items in each Inventory Location and the cost to each Location at both the Minimum and Maximum Order levels. Finally, it displays the Ending Inventory value at the Maximum order range.