---
title: "Enhanced Forecasting Worksheet: Customize the Predicted Value and Change Item Planning Expressions"
app: "Enhanced Planning Pack"
section: "How-to guides"
last_updated: "2024-02-13"
url: "https://insight-works.com/kb/enhanced-planning-pack/enhanced-forecasting-worksheet-customize-the-predicted-value-and-change-item-planning-expressions/"
---

# Enhanced Forecasting Worksheet: Customize the Predicted Value and Change Item Planning Expressions

The Enhanced Forecast Worksheet allows you to preview forecasted values and see a detailed breakdown of the calculated forecast (from Microsoft’s Sales and Forecast extension) before applying it.

You can also calculate Safety Stock, Reorder Point, Reorder Quantity, Maximum Inventory and apply those item planning parameters in a similar way to the Item Planning Worksheet by using forecast values as the basis instead.

You can also adjust the calculated value itself with the _Forecast Expression_ field on the _Enhanced Forecast Setup_ page.

For assistance on general expression support, available variables, and functions help with expressions, see the _[Expression Evaluator](/kb/product-configurator/expression-evaluator/)_ page.

To change the expressions for the Enhanced Forecasting Worksheet:

1. Navigate to _Enhanced Forecast Setup_ in Business Central.
2. Locate the _Calculation Expressions_ section and modify the available expressions.

#### Default values

| **Field** | **Default** |
| --- | --- |
| Safety Stock Expression | avg\_daily\_usage |
| Reorder Point Expression | avg\_daily\_forecast \* lead\_time\_days |
| Maximum Inventory Expression | avg\_daily\_forecast \* lead\_time\_days \* 2 |
| Reorder Quantity Expression | forecast\_qty |
| Forecast Expression | Forecast\_qty (or blank). When blank it is effectively equivalent to Forecast\_qty   If you wanted to simulate a “what if” scenario that hypothesizes 20% growth in addition to the predicted value, use a formula such as forecast\_qty\*1.2 |
