You are here: Inventory > Parts > Prepare Annual Budget > Calculation Method

Calculation Method

Here you enter which calculation method or forecasting method that should be used when calculating the annual budget.

Manual Method

A new annual budget must be entered manually for each part in the list.

Exponential Smoothing

A new annual budget is calculated using formula 1 taken from the Planning Formulas procedure in the Global Settings module. If you have the Supplement required to edit Planning Formulas, you can enter multiple formulas used to prepare and calculate the annual budget.

Formula used to prepare annual budget with exponential smoothing.

In the drop-down list under Calculation method you select which formula (from the Planning Formulas procedure) you want to use in the annual budget calculation.

help0032.gif

Formulas from the Planning Formulas procedure.

Comment: This drop-down list is only visible if you have both selected Exponential smoothing under the heading Calculation method and you have more than one formula for calculating annual budget in the Planning Formulas procedure.

Sales

This calculates a new annual budget using a sliding average for prior sales during a certain number of months. You must enter the number of months you want to use for this option. The default option here is 12 months. For example, if you select 3 months, it will be multiplied by 4 to get the annual value.

Part's Calculation Method

This will calculate a new annual budget using the calculation method (one of the three options listed above) that was saved for that part. You can choose from which year you want to apply the part’s calculation method from.

Save Calculation Method

Check this box if you want the selected calculation method to be saved for the part. This will allow you to choose whether to calculate the next annual budget using the “Part’s calculation method”, and also select from which year you want to select the calculation method.