Navigator Purchasing Reports

Description

Use these fields to narrow the report to a specific company, warehouse, manufacturer, or item number.

Determines the order that the back orders appear on the Back Order ETA Report. However, the first sorting priority is the Customer Priority.

Purchase orders for these warehouses can be used to fill back orders for any other warehouse. For example, you can enter the code for a warehouse that acts as a distribution center.

*** is a valid entry. This is only valid in the 1st Global Warehouse setting. If the other 2 fields are used the entries display on the confirmation screen however the report will omit them and still only show All Selected.

Use this section to determine which customers get their back orders filled first. The Customer type and ABC code ratings work together to ensure your best customers automatically receive preference when filling back orders. Give your best customers a high priority by assigning a low priority sequence number. The lower the number, the higher the priority.

Customer Types are two-character codes that represent the type of business or service a customer is involve in. For example, CO could stand for contractor or HC for home center.

A customer type code is assigned to each customer in the Customer Type field of the Billto File.

ABC codes enable you to categorize and rate customers and items. For example, you might designate your most important customers with an ABC code of "A".

ABC codes are created using the ABC Code File and are assigned to customers via the Billto File.

This setting is for companies that have a manufacturing plant, or can receive production schedules from a supplier. Activating this setting directs the system to check these production schedules (via a file entitled PSCHEDULE), to see if a production date can be found for a back ordered item, and if no PO is found first, that production schedule date is used as the back order ETA date.

If you use manufacturer or supplier production schedules to update your back order ship dates, you can automatically assigned the status code entered here to the back order detail lines.

Since several of the available order status codes are user defined you can create a status code that means "back order date is based on production schedule".

Some of the user defined order status codes are @, $, %, G, M, N, W, Y, Z.

Unlike system-defined order status codes, user-defined status codes have no implicit meanings within any system programs. For example, whereas the system recognizes that status codes X, A, and S are used within the picking and shipping activities, the system does not attempt to assign meaning to the user-defined codes.

When this field is activated, the detail lines on the back order are changed to reflect any new dates procured from purchase orders or production schedules.

The status of the detail line is also updated to the entry made in the setting above.

Description/Instructions

Select a date span for computing the average usage and for displaying sales statistics. This can be whatever date span constitutes the most applicable trends for the products on the report. For most products, selecting the past one to six months can reveal applicable usage figures. The more subject to fashion and other trends an item is, the shorter and more recent the date span should be. For seasonal products, you can select a date span representing the same season last year. For example, if you are ordering for an upcoming summer season, you can select the date range for last summer. The reorder reports will then use last summer's sales and your current inventory position to determine suggested reorder quantities. If you are ordering for an upcoming promotion, you may want to use the time span of the last similar promotion. Leaving the date span blank causes the system to compute usage based on the past year. We recommend that you always enter the applicable date span. This is one of the most important parameters, since it affects the average usage figures.

Enter a single code to limit the report to that particular parameter. Optionally, you can leave these field blank to include all the applicable entities.

Enter a single warehouse code to limit the report to that particular warehouse. Optionally, you can leave this field blank to include all warehouses.

You can sort reports to be separate for each warehouse, to display multiple warehouses under each item, or to combine multiple warehouse statistics into a single total per item.

If the warehouse field if left blank, you can specify a company number to include all warehouses within that company.

The Item Reorder Report can be run for an established group of warehouses that are referred to as "warehouse groups". Warehouse groups can be specified allowing the inclusion or omission of warehouses from the report. The warehouse groups, which are used only for reordering, are created within the Reorder Reports parameter. The Warehouse Group option enables you to specify which of the warehouses included on the report should be considered the "distribution center". The distribution center warehouse is usually the warehouse where imports are received prior to shipment to other warehouses.

When you select the "Warehouse group option, you are effectively considering the available product in this warehouse to be part of the cumulative future availability that can service the other warehouses in the group. In effect, the distribution center is like a port - a temporary holding place for material that is moved to your other branches/warehouses.

Version 6 includes an option that works well with the warehouse groups concept.

If you try to enter a single warehouse and a warehouse group, you will receive an error message. You cannot specify both. You may specify a company number as well as a warehouse group. If there are warehouses in the group that are not in the specified company, they are omitted.

Including all inventory for items that need to be ordered

This functionality, added in March 2020 via spec 6043, created a new version of the reorder report that shows only items that need to be reordered, and activity and inventory in all warehouses for those items.

• When a warehouse group is entered and ....
• ...the setting List ONLY Items that need to be reordered is set to Y, the setting Include all warehouses in Warehouse group XXX appears below it.

Enter a single item class to limit the report to that particular item class. Optionally, you can leave this field blank to include all item class. This parameter will actually test all three item class fields. Therefore if your item class 1, 2, and 3 codes are all unique, this parameter can access any item class. If you have used the same codes in multiple classes (1, 2, or 3) then the results are unpredictable.

Enter a single supplier code to limit the report to that particular supplier. Optionally, you can leave this field blank to include all supplier codes. This supplier number relates to the Usual Supplier# field in the Item File.

Enter a single reorder/buying category to limit the report to that particular buying category.

Use this code to define the buyer of the product line, or to group product lines for efficient use of the reorder reports. Selecting a reorder/buying category will list only the product lines in that category. Since this field is used exclusively for purchasing, it provides the most efficient way to request reorder reports.

Enter up to four characters of the color number to limit the report to that particular color number. Optionally, you can leave this field blank to include all color numbers. The color number is the four characters of the item number that immediately follow the manufacturer code.

This field enables you to apply a simple global growth factor to your usage figures. The growth factor% is controlled via the field Enter a Growth Factor% to be applied to the Usage/Activity Qtys.

For example, if you expect 10% growth over the historical usage averages, then enter 10.00 in this field. If you expect a 10% decline, enter 10.00- in this field. The average usage figure (and average activity figure) will be adjusted by this percentage, up or down.

It is recommended that this field be used to adjust for upcoming promotions, seasonality, and other instances where you expect a change the system cannot predict. You can also use this concept after a promotion. For example, if you are basing the forecast on the past three months usage, and there was a promotion during those months, you may want to apply a negative growth factor when the promotion ends.

Select Y to enter your own list of item numbers or product lines. If you enter Y, an additional screen appears which enables you to request a specific list of manufacturers, product lines, and item numbers.

The additional screen appears after you have completed this screen and click next.

Description/Instructions

• Option 1 shows all selected warehouses under each item. The default is option 1.

• Option 2 shows all items for one warehouse followed by all items for the next warehouse.

• Option 3 causes an additional Selection Screen to display with several more sort options. For example, an additional sorting option accessed via option 3 is option J which sorts inventory reports by Item description within each supplier, based on the Usual Supplier field in the Item Master File. We recommend this option for suppliers or cost centers that do not have meaningful or logically sequenced item numbers.

Enter Y to limit the report to only those items that require reordering. Only items that cause the system to suggest a reorder will be printed. Enter N to list all selected items. N is the default.

Use the first option to combine totals for the lots and warehouses within each item listed in the report. Each item will only show a single line of information which includes all lots and warehouses, according to the sort and selection criteria.

Use the second option to list each lot number and warehouse. Be careful not to confuse lot number with serial number or shade. This option shows each lot and warehouse on a detail line followed by a total for the item. The second option is the default.

The report can show average weekly usage or average monthly usage.

M is the default.

Enter Y to list each serial number under each detail line on the report. Along with the serial numbers are the quantities, receipt dates, shades, and status codes of each serial number. If any back orders exist for an item or warehouse, they are shown as a negative "blank" serial number.

Enter S to show a serial number summary. The summary shows the number of serial numbers available, the average quantity per serial number, the median quantity of all serial numbers, the largest serial number quantity, and the standard deviation for all serial numbers. These five statistics are shown instead of showing each individual serial number. The serial number summary combines multiple bin locations of the same serial number. The list of serial numbers shows each bin location separately.

Option 3 - to include items regardless of trim class is the default.

Items are designated as trim by entering a trim class code in the Item Master File. Your trim or support products often sell in very different and erratic cycles than your core products. They usually require different reorder parameters, and you may want to analyze them separately.

Enter Y to cause the Reorder Reports to compare the available quantity of each serial number to the remnant quantity as entered in the Item File. If the quantity available of a serial number is not greater than the remnant quantity, it is eliminated from the available total for the SKU. N is the default.

You can include or omit remnants from the availability calculations. Remnants are available quantities of a single serial number or lot number that are less than or equal to the remnant quantity/size as entered individually for each item in the Item Master File. This concept only applies to material that usually must be sold from the same or matching serial numbers, lots, or rolls. This parameter is ignored for items that are not stocked by serial or lot number. If you choose to omit remnants, the reorder report ignores the available quantity of any serial or lot number that is less than the remnant quantity in the item master record.

For example, let's say the total quantity available = 1000, consisting of three serial numbers of 900, 25, and 75. If the remnant size is 80, then the Reorder Report only considers that you have 900 available.

Report Versions 

To select more than one report version simultaneously, string together the versions in any sequence. For example, entering version number 153 simultaneously runs versions 1, 5, and 3. Versions 7 and 8 can only be run simultaneously with version 1 and each other.

Worksheet - lists supporting information to be used in conjunction with other versions. Once you are familiar with all the reports, this version may not be necessary.

Report with Suggested Reorder Quantities - determines suggested reorder quantities based upon the usage and the reorder parameters you have entered. This version can be lined up exactly side by side with Version 1 for easy cross reference between the two reports.

This version shows subtotals of the net available inventory after lead time figure by product line. This subtotal is useful for product lines whose items all share the same native unit of measure.

This version also includes two recaps at the bottom of each report. The first recap is by supplier and the second recap is by manufacturer. The recaps summarize the suggested reorder quantities by weight, pallets, number of items, and value ordered.

Create Purchase Orders For Suggested Qtys - is not a reorder report. It is a purchase order edit automatically created for the items with a suggested quantity to order. It can be used in conjunction with one or more of the other versions. The goal of setting up purchasing parameters is to be able to use this option to generate automatic purchase orders.

When you select Version 3, the system goes through the process of creating a reorder report, and then automatically creates a purchase order for items that would appear on the reorder report with suggested order quantities. You can then use the Purchase Order Entry program to modify the edit and issue as an actual purchase order.

Inventory Forecasts - tests your reorder parameters. The report shows either a 12-week or 12-month forecast (depending upon your choice of weekly or monthly usage) using current inventory status and assuming that average usage remains constant. The purpose of this report is to see what would happen to your stock levels if the system was to run on "auto pilot" based upon the reorder parameters in the Product Line, SKU, and ABC Files. The report deducts the average usage each week or month, and then illustrates when new purchase orders would be generated and received, and what the quantity available would be each week or month. You should then compare the stock levels achieved with the quantity to stock parameters you have entered. If the available quantity is consistently and significantly lower or higher than your desired quantity to stock, then your reorder parameters may need adjusting. Important: If your reorder frequency or lead time is less than one month, then only run this report with weekly usage in order to list meaningful data.

Gordon Graham Format - contains certain attributes that are consistent with those recommended by Gordon Graham, who writes and lectures on inventory control for distributors. It expresses each statistic in actual quantity and in weeks or months. It also shows a six month trend regardless of the date span selected for usage. The six month trend shows the sales each month. Underneath the sales is an "S" whenever the month ended with an "Out of Stock" condition. An "S" will often explain low sales levels in that or the following month.

Importing Format - is intended primarily for companies who allocate purchase orders and customer back orders to specific vessels or shipments. Version 6 displays availability statistics separately for current stock and for each incoming vessel or shipment.

This version can be run in the following formats:

• Regular

• Cumulative Months available by vessel - shows the future cumulative quantity available (expressed in months) by vessel by day.

• Distribution Center - shows the future cumulative quantity available. Additionally this format designates one warehouse as a distribution center, and calculates availability using a special formula.

Activity Format - has similarities to versions 2 and 5, but uses a very different inventory concept referred to as activity. Activity replaces usage in all formulas used for reordering on this version. Activity is defined as sales plus the change in open order quantities for the selected date span.

Version 7 of the report contains the following columns:

• Activity - Quantity sold plus the change in open order position in the selected date span.

• Average Activity - Activity divided into the number of weeks or months as shown.

• Back Orders - Quantity of open customer back orders.

• Stock Allocated - Quantity of open customer orders that are allocated against stock. Total allocated equals the sum of the back orders and the stock allocated.

• Pre-Receipts - The quantity in transit from supplier. Located in Pre-Receipts File, but not in inventory yet.

• Scheduled - The quantity of open purchase orders less those also in pre-receipts.

An additional parameter screen is displayed when Reorder Report version 7 is selected. The following options are:

• display a single line on the report for every SKU record shown. The single line displays figures primarily in total quantities.

• print two lines for every SKU record. The first line is primarily figures expressed as total quantities. The second line shows averages per month or week. The six monthly columns show activity per month, with sales per month underneath.

This version includes two recaps at the bottom of each report. The first recap is by supplier and the second recap is by manufacturer. The recaps summa­rize the suggested reorder quantities by weight, pallets, number of items, and value ordered.

Create Purchase Orders using Activity instead of Usage - Version 8 (create Purchase Order Edit) is the same as Version 3 except it is based on activity instead of sales. Version 8 uses the same formulas and logic as Version 7.

Fill Rate and Ranking Report - is not actually a reorder report. It is an item ranking by sales activity which shows the fill rate of your top items. This report shows how good (or poor) a job you do at keeping top sellers in stock.

The Fill Rate version of the Reorder reports is a logical place to show lost orders because fill rates and lost orders go hand in hand.

This report version includes an additional parameter screen.

If you enter Y, the Reorder Report programs checks both the Product Line and SKU File reorder points, and uses the greater of the two reorder point values. Use this option if your SKU File reorder point is set as a "minimum" quantity, yet you want to reorder earlier when sales or demand is rising. During rising sales, the product line parameters might dynamically figure a higher reorder report than the minimum quantity set in the SKU File Reorder Point field.

• Reorder point = greater of SKU file reorder point or product line/Supplier Reorder point
• Reorder amount = SKU File Reorder Amount

If you enter X, the program checks both the Product Line and SKU Files for reorder points and quantities to stock. The program uses the greater of the two values for each of the fields. For example, if the SKU File reorder point is used, then so is the SKU file quantity to stock.

• Reorder point = greater of SKU file reorder point or product line/Supplier Reorder point
• Reorder amount = greater of SKU file reorder amount or product line/Supplier Reorder Parameters file

When available plus scheduled equals less than quantity to stock the report calculates suggested reorder amount equal to difference between net available after lead time and quantity to stock value from SKU file or PRODUCT LINE/SUPPLIER REORDER - whichever is greater, when report parameter is submitted as X.

N is the default.

• Reorder point = SKU file reorder point
• Reorder Amount = SKU File reorder amount

If you enter Y, each open purchase order will print under the corresponding items and warehouses. The purchase order number prints along with the ETA, the quantity ordered, and the status. If you use this option, we recommend that you also use the following pre-receipts option. N is the default option.

If you enter Y in this field, each open customer back order prints under the corresponding items and warehouses. The customer's name, order number, status, and quantity of each back order is shown. N is the default.

If you enter Y, the Reorder Reports will list all unposted pre-receipts under the corresponding items and warehouses. The pre-receipts list with the quantity, serial number, shade, and receipt date. Pre-receipts are receipts that have been entered into the Receiving System, but not yet posted into the actual inventory files.

Lost order information can be included in Reorder Reports. This functionality pertains to versions 1, 2, 5, 7 and 9.

An order may be considered "lost" due to several reasons such as the following:

• You do not carry the product the customer is requesting

• The price was too high

• The item was not available and back order time was too long

• The specific dye lot could not be matched

The following entries are available:

• Y - generates a detail list of lost orders for the entered date range shows. Essentially each lost order is displayed on the report. This is similar to the detailed lists of purchase orders, back orders, and pre-receipts that are also available.

• S - a summary line is added for each item showing the monthly lost order averages and also the corresponding monthly sales and activity figures. This adds a line to each item on the reorder report(s).

This parameter is used only if you have selected Version 3 or 8, which creates automatic purchase orders.

Enter a specific warehouse to direct all automatically created purchase orders to that warehouse. Enter ALL to automatically create purchase orders for all warehouses that show suggested reorders. This method is a perfect compliment to the stocking matrix option. Purchase orders are automatically created for the items and warehouses that need to reorder material. In most cases, ALL is the recommended option.

The warehouse ALL causes purchase orders to be created at the SKU level instead of the item level. This means that POs for multiple warehouses can be created in a single run of the reorder programs. The ALL warehouses parameter also activates the use of SKU level reorder parameters, such as fixed quantity stocking levels. Note: This is even true when you have selected only a single warehouse to include.

Adhere to the following guidelines:

• Entering a specific warehouse in the Auto PO Warehouse parameter causes the reorder system to create POs at the item subtotal level, diverted to the specified warehouse.

• Entering ALL as the Auto PO Warehouse parameter cause the reorder system to create POs at the default warehouse (SKU) level.

• Leave blank to direct automatically created purchase orders to the last warehouse needing a reorder that is shown on the report for each item. This option may have unpredictable results in a multiwarehouse environment.

1- Stock Only - suggest quantities to order based upon all of your reorder parameters - lead time, order frequency, desired days to stock, etc. The programs order to cover all customer orders and reach the desired days to stock.

2 - Non-Stock Only - suggest quantities that fill the back orders for non-stock items. These do not include special orders, which are already managed by the special orders system. All of the logic for determining optimum reorder quantities for stock items is bypassed for non-stock items. It is replaced by the following formula; suggested reorder amount for non-stock items equals zero minus net available if net available is negative. In other words, back orders are covered by ordering the exact amount back ordered. No stock quantities are ever suggested for non-stock items. This allows a thorough and seamless ability to generate automatic purchase orders for all items.

3 - Both Stock & Non-Stock - This is the recommended reorder method, for each supplier it will order both stock and non-stock items on the same purchase order. Stock items are brought up to your desired days to stock, and non-stock items are ordered only to fill back orders.

4 - Back Orders Only - This method should be used when:

• Due to cash restraints, you can only afford to purchase what you need to fill orders in house, rather than buying for stock.

• You can not wait to fill a truck, and you need order on an LTL basis to cover your back orders.

This option has no affect on how non-stock items are purchased, because only back orders are ever covered for non-stock. However, for stock items it will only order enough to cover the back orders, instead of enough to achieve the desired stock quantities. An example of how this option can be helpful, is if you need to order on an emergency basis, and don't have time to fill your next truck. You are filling on an LTL (less than truckload) basis, and just want what is absolutely needed to fill the back orders in house.

Notes about option 4:

• Supplier purchasing rules apply

• If the ISO setting "cannot mix serial numbers" is off, the system orders what is back ordered less what is still available in stock. If the ISO setting "cannot mix serial numbers" is on, then the program ignores available quantities and covers the full back order qty.

• Existing open P.O.s are considered. If enough is already scheduled, the system will not create another P.O.

• In the Qty-To-Stk column, non stock items usually show NON-STK. When back order only is selected, the message BOs ONLY is printed, so users are aware that only back orders are being covered, and not the qty to stock (this applies to versions 2,5,7).

• If the program finds there are back orders - and there is available stock > or = to the back orders, then a warning is printed "note: available stock is > = back orders". The program assumes that you back ordered the items because of shade/dye lot considerations, but will warn you "just in case". (versions 2,5,7).

All of this logic is only applied when the default option of "2" to List Each Lot# & Warehouse Sub-Total Within Each Item on the second screen of settings is selected.

This field enables you to buy only enough products to cover back orders through a specified date.

The reorder reports also include a note at the bottom, indicating if this option is used. Furthermore, if you use the reorder report option that lists all back orders, back orders that are omitted from the availability calculations on the report are noted with **.

This option does NOT affect the "Inventory Activity" calculation. Activity still includes all back orders. However, report versions based upon Activity are affected, because the future back orders are removed from the allocations used to calculate availability. Therefore reports based upon either usage or activity omit the future back orders, and do NOT purchase those quantities. The activity calculation, which is a measure of trends in open orders, is still influenced by all back orders.

Note:You may also set the Enter "Y" to list individual back orders under total allocated qty field to Y to list back orders, and all individual back orders will be listed on the report.

The back order date works as follows:

Any back orders that have a "date required" greater than the date specified are omitted from the availability calculation. In other words, the program will NOT attempt to purchase material to fill those future back orders. The quantity available is not reduced by those future back orders.

For example, if you have none onhand and four back orders for an item:

• 500 required on 10/15/03

• 300 required on 10/31/03

• 400 required on 11/15/03

• 800 required on 11/25/03

If you exclude back orders after 11/01/03, the quantity available is considered to be <800>, (0-500-300), and the program orders at least enough to cover that 800. If you do not enter a date, then all back orders are considered, and the quantity available is <2000> (0-500-300-400-800). In that case, the program orders enough to at least cover 2000.

The affected back orders appear on the report but are denoted with astericks (**).

Description

• 1 to Print Quantities in Native (Usual) U/M - This option is the default. It causes the report to print in the normal unit of measure. The normal (native) unit of measure is the unit measure in which an item is priced.

• 2 to Print Quantities in Sales U/M - This option converts the report to the sales unit of measure for each item as defined in the Item File. For rolled goods, this options causes the report to print in RL (whole rolls).

• 3 to Print Quantities in Pick U/M - This option converts the report to the pick unit of measure for each item as defined in the Item File. For rolled goods, this option causes the report to print in LF (lineal feet). For items with a pick unit of measure of PC, EA, CT, or blank, the report attempts to convert to cartons (CT).

• 4 to Print Quantities in Order Entry U/M - This option converts the report to the Order Entry unit of measure for each item as defined in the Item File. This unit of measure will always be the pricing unit of measure.

• 5 to Print Quantities in Supplier U/M - This option converts the report to the supplier unit of measure for each item as defined in the Item File. If the supplier's unit of measure is properly set in each item, this is the most logical choice. This creates the Reorder Report in the unit of measures in which the supplier expects you to order.

A stocking matrix is a set of rules which govern where stock is carried to meet the demands of each geographic grouping of customers. If you do not use the Stocking Matrix File, the system assumes that stock should be replenished to the warehouse where it was stocked. Enter Y to use the stocking matrix in order to calculate usage.

Description

Enter S to cause the report to be sorted, highest to lowest, based on sales. Enter A to cause the report to be sorted, highest to lowest, based on order activity.

Enter a number between 1 and 100 to control through what percentage of cumulative sales or order activity to print. 80% is the default. For example, if you enter 80, only the items representing 80% of cumulative sales or item activity are printed. This leaves off the items comprising the bottom 20%. Usually you are interested in the fill percentage of your top items.

Enter 1 to run a single cumulative ranking report. All selected items are ranked by sales or order activity. Enter 2-7 to run separate ranking reports, with a page break after each one, based on the categories shown.

• Enter 2 to sort by sales or order activity within each Manufacturer.

• Enter 3 to sort by sales or order activity within each Product Line.

• Enter 4 to sort by sales or order activity within each Item Class 1.

• Enter 5 to sort by sales or order activity within each Cost Center.

• Enter 6 to sort by sales or order activity within each ABC Code.

• Enter 7 to sort by sales or order activity within each Buying Category - If each of your buyers are represented by a buying category code, use this option to check each buyer's fill percentage.

This option determines how the report should consider an item to be in stock or not. Select one of the three options:

Items are considered "in stock" if the quantity available is at least equal to the average sales quantity per invoice.

Items are considered "in stock" if a certain fixed quantity is available. To select this option, enter the fixed quantity representing an "in stock" quantity.

Enter Y to include back orders in the total allocations.

Enter N to omit back orders from total allocations. Only include orders allocated against stock. This option causes your fill percentage to be higher. However, this may give a more fair analysis, as items that have stock that can be sold can be counted as in stock, even though back orders can exist. Sometimes back orders are created in order to have special shade or dyelots, and not because you are actually out of stock.

Orders may be considered "lost" due to several reasons such as the following:

• You do not carry the product the customer is requesting

• The price was too high

• The item was not available and back order time was too long

• The item could not match a specific dye lot

Description

The amount physically in stock.

The amount of stock committed to customer orders.

The amount onhand less the amount allocated.

The amount currently on open purchase orders (on order) from suppliers.

The amount available plus the amount scheduled, It is the total available including what is on purchase orders.

Net available after lead time is the amount you will have net available after a time frame equal to your lead time. If this figure is negative, you will probably be out of stock even if immediate action is taken. Net Available After Lead Time equals Net Available less lead time in weeks multiplied by average weekly usage.

Amount in credit memos that was automatically received to stock by the invoicing program.

The total quantity sold in selected date range unless it is expressed in weeks or months, in which case it is the average per week or month.

The total usage (quantity sold in date range selected on report) divided by the number of weeks or months in the selected date range.

The quantity to reorder based on the average usage and the reorder parameters in the Product Line, ABC, Purchasing Rules, and SKU Files.

The quantity to reorder which will cause net available to equal the amount to stock within the lead time (amount needed in order to achieve the amount to stock based upon usage and the reorder parameters).

The total quantity sold within the date range selected for the report.

The largest individual sales quantity in the date range selected for the report.

The quantity available divided by the average monthly usage.

The quantity available divided by the average weekly usage.

The quantity scheduled divided by the average monthly usage.

The quantity scheduled divided by the average weekly usage.

The percentage of quantity that was ready for invoicing (not including back orders) that was actually invoiced. This statistic is calculated from invoices only, not from open orders. For example, if an order for 100 each is invoiced as 100 each, that is a 100 percent Fill%. If an order for 100 each is back ordered it does not affect Fill% until it is invoiced. If an order for 100 each is invoiced as 95 each, that is a 95 percent Fill%. The fill% shown on reorder reports is accumulative Fill% for each product, including total quantity invoiced for date range.

Actual usage divided by Fill%. If Fill% is less than 100%, then demand was higher than actual use.

The quantity transferred on stock-to-stock transfers. Stock-to-stock transfers are processed via the stock transfer account, or by using the Inventory Transfer program. Stock-to-stock transfers are not included in usage. However, Version 5 of the reorder reports lists transfers next to usage and demand.

The serial number with the largest available quantity. For non-rolled goods all bin locations with the same serial number, for an item at the specified warehouse, are combined and then sorted to determine the largest serial number.

The average quantity available of all available serial numbers for the specified item and warehouse. For non-rolled goods all bin locations with the same serial number and warehouse are combined before being averaged.

If there is an odd number of available serial numbers, the median is the quantity available of the middle serial number, when sorted smallest to largest. If there is an even number of available serial numbers, the two middle serial numbers are averaged to compute the median. For non-rolled goods, all bin locations for the same serial number and warehouse are combined before calculating the median.

The average deviation, in quantity, between all serial numbers and the average serial number. For non-rolled goods, all bin locations for the same serial number and warehouse are combined before calculating the standard deviation.

When reorder reports versions 7 and 8 are requested, quantity sold is replaced by activity, and average usage is replaced by average activity. Activity equals the quantity sold plus the change in open order quantity within the specified date span.

The portion of the allocated figure that has been assigned to stock. (Allocated - Back Orders = Stock Allocated)

The portion of the allocated figure that has not been assigned to stock. (Qty Back Ordered = Allocated - Stock Allocated)

Description

Enter a date span for computing the average usage and activity. This can be whatever date span constitutes the most applicable trends for the products on the report. For most products, selecting the past one to six months can reveal applicable usage figures. The more subject to fashion and other trends an item is, the shorter and more recent the date span should be. For seasonal products, you can select a date span representing the same season last year. For example, if you are forecasting for an upcoming summer season, you can select the date range for last summer. The forecast report will then use last summer's sales and your current inventory position to determine suggested reorder quantities. If you are ordering for an upcoming promotion, you may want to use the time span of the last similar promotion. Leaving the date span blank causes the system to compute usage based on the past year. We recommend that you always enter the applicable date span. This is one of the most important parameters, since it affects the average usage figures.

The recommended version is 12 weeks.

This field enables you to apply a simple global growth factor to your usage figures.

For example, if you expect 10% growth over the historical usage averages, then enter 10.00. If you expect a 10% decline, enter 10.00-. The average usage figure (and average activity figure) will be adjusted by this percentage, up or down.

It is recommended that this field be used to adjust for upcoming promotions, seasonality, and other instances where you expect a change the system cannot predict. You can also use this concept after a promotion. For example, if you are basing the forecast on the past three months usage, and there was a promotion during those months, you may want to apply a negative growth factor when the promotion ends.

The Stocking Matrix is a set of rules that govern where stock is carried to meet the demands of each geographic grouping of customers. If you do not use the Stocking Matrix File, the system assumes that stock should be replenished to the warehouse where it was stocked. For example, if the stock was picked from warehouse NYC, then without a stocking matrix, the system assumes that stock in NYC should be replenished. If this replenishment method is satisfactory for your operation, or if you have a single stocking warehouse, you do not need to use this file. With a single central stocking warehouse, you should run the reorder reports for all warehouses combined.

You can include or omit remnants from the forecast calculations. Remnants are available quantities of a single serial number or lot number that are less than or equal to the remnant quantity/size as entered individually for each item in the Item Master File. This concept only applies to material that usually must be sold from the same or matching serial numbers, lots, or rolls. This parameter is ignored for items that are not stocked by serial or lot number. If you choose to omit remnants, the report ignores the available quantity of any serial or lot number that is less than the remnant quantity in the item master record.

For example, let's say the total quantity available = 1000, consisting of three serial numbers of 900, 25, and 75. If the remnant size is 80, then the Stock Out Predictor Report only considers that you have 900 available.

Activity is defined as sales plus the change in open order quantities for the selected date span.

Activate this setting to only display those items with a forecasted stock out.

For an item to be considered inactive it must:

• Have no sales within the last year

• Have inventory on hand