Forecast Report

Action: RP_RESVFORE

This is a report to help determine future rental inventory requirements by counting your current bookings by any style & size for any future date period. The knowledge can help management make buy or sub-rent decisions.

Many operators would run this report on a style basis listing it's sizes for a future rental period. The report will show where inventory is running low or is overbooked. Report is selectable by the criteria of: ​ Assemble date thru Back Date...Only show items to be assembled and back within the date range specified. This date could be for any period into the future. The assembly date of the order must equal or be greater than the date entered AND the back date must be less than or equal to the date entered.

Assemble date range... The assembly date range, Perform calculations only on orders with an assembly date within the range. The report will count the style/sizes on orders to be assembled within the range and show how many are owned tat are marked available for rental. This option will include orders with no booked quantities and exclude CANCELLED orders or orders will missing sizes.

Limit to Vendor...Only items from the entered vendor will be shown. May choose one. Leave field blank for all.

Limit to Inventory category/sub-category...Items with the inventory category and/or sub-category entered will be included.

Item Type... Report may be limited by a single rental item type.

Styles...Multiple styles may be entered by separating each store style code with a comma. Use F2 for a list of styles to enter.

Show sizes? (checkbox)...If not checked, only the styles will be shown. Showing only styles is a good reference to see how each style inventory is performing. Checked sizes for each style will be included for a detail analysis of style/size performance

This report may be used to forecast there need for additional stock before it is actually needed for production.

Show only overbooked items? (checkbox)...Limit report to items/sizes that are overbooked within the date range specified. This is a powerful feature to zero in all hard stock needs.

Export to FORECAST.DBF? (checkbox)... The report data is placed into a database file called FORECAST.DBF and is then available for further analysis via other programs, like excel.