Inventory Status & Projection Report (ISRP)

How to print: Use the Print Inventory Status and Projection Reports (ISRP) menu option.

CWDirect Rel 10.0 Inventory Status and Projection Report KBOTTGER FCR0054 5/05/06 10:07:36 Page 1 KAB Co Sort : By Item, Single Offer Version Offer: ISR ISRP OFFER All Suggested qtys Item class: All Override not entered DFO . . . . . . : 5/04/06 DFO Week Begin . : 5/04/06 % Complete . . . : 50.00 Current week . . : 2 / 7 Offer Curve/Type : 206 Override % . . . : .00 Codes: A = Current Qty Equals Projected Demand B = Current Qty Exceeds Projected Demand C = Current Qty Is Less Than Projected Demand Item COLO STYL SIZE S/O Qty % Qty Qty Qty Qty Ovr Proj Net Prj Net Net Prj On PO Sugg On PO Exp Act Pers C Avail C Lead C S Pg# Code Avail Ordered Rtn/Exc Cancel Soldout %Comp Crv Units Life Units Remain For Ofr Qty Oth Ofr Rtn % Rtn % Rem D Rem D Pers R ISRP1 ISRP1 ITEM DESCRIPTION 1 5 100.00 4 0 0 0 50.00 206 10 10 4 6 0 1 5 .00 .00 5.00 B 5.00 C 0 Totals for COLO : 5 4 0 0 0 10 10 4 6 0 1 5 .00 Totals for item: 5 4 0 0 0 10 10 4 6 0 1 5 .00 ISRP2 ISRP2 ITEM DESCRIPTION 1 0 100.00 9 1 0 0 50.00 206 5 5 8 3- 0 3- 5 .00 .00 .00 B .00 B 0 Totals for COLO : 9 1 0 0 5 5 8 3- 0 0 5 .00 3- Totals for item: 9 1 0 0 5 5 8 3- 0 0 5 .00 3-

Contents:

Note: Some of the field names and contents vary, depending on whether you generated the single-offer or 10-offer version of the report.

Report Summary Information appears at the top of report, including (depending on report options):

• Sort: Available sorts are:

• Class/Item

• Vendor/Item

• Item

• Class/Descending Units

• Descending Units

• Descending $ Ordered

• Buyer

• Offer: The code and description of the offer(s) selected during report generation. Up to 10 offers can be reported.

• Selected items to include: Defines the item option you selected during report generation:

• All Suggested qtys displays if you selected the All Items option.

• Suggested Qty > 0 displays if you selected the Suggested Quantity Greater Than Zero option.

• Suggested Qty < 0 displays if you selected the Suggested Quantity Less Than Zero option.

• Critical Items Only displays if you selected the Critical Items Only option.

• Item class: Defines the item class, if any, you selected during report generation.

• Override: Defines whether you defined an override curve completion % during report generation.

• Override not entered displays if you did not define an override curve completion %.

• % Overrides entered displays if you did define an override curve completion %.

• Proj $ use: Indicates whether the price from the Item file or the SKU file was used for projecting totals for multi-offer reports. The IS Report Projected Dollar Calculation Price Basis (D59) system control value indicates which price to use.

• DFO: The date the first order was taken for this offer, in MMDDYY format.

• WFO: The week in which the first order was taken for this offer, in MMDDYY format.

• % Complete (Percent complete): The number of total percentage of units ordered, as of the current period, for the entire projected sales cycle.

• Current week: The week you are in of the ordering cycle and the number of weeks in the full cycle. If ordering continues beyond the total cycle, it will be captured in the last week of the cycle.

• Offer curve/Type: The curve assigned to this offer, which is a mechanism by which you predict the number of sales expected for the ordering cycle in terms of a percentage complete for each week. Curves are defined in the Projection Curves file.

• Override %: The percent complete for the curve override you specified during report generation.

Report details:

• Override item curve: The percent complete for this SKU/Offer combination. This is the percentage to adjust the percent complete for a curve. For example, if you enter an override curve of 5% and the percentage complete is 75%, the percentage complete will be adjusted to 78.75% for this curve. The IS report searches the following files in the sequence listed for the curve:

• SKU/Offer file (INSKOF)

• Item/Offer file (INIOFR)

• Item Class file (INICLS) or

• Offer file (MSOFFR)

• Item: The code for an item in the selected offer(s).

• SKU: The SKU code for the item.

• S/O code (soldout code): The soldout code, if any, defined for the item or SKU. Soldout codes are validated against the Soldout Control file, and can be created with the following values:

• sellout immediately, regardless of on-hand quantity

• sellout when on-hand quantity equals zero

• sellout when on-hand and on-order quantity equals zero

Note: The S/O code field appears on the multi-offer report only if the Print Item Status or Sold Out Control on 10 Offer IS Report (D78) system control value is set to SOLDOUT.

• Qty avail (quantity available): The quantity of the item/SKU that is not reserved or printed. This is the quantity available in the IS Item file (FCISIT). The system uses the following calculation to determine the quantity available: On hand - Protected - Reserved - Reserve Transfer - Backordered = Qty available

• Actual units: The number of units ordered for the SKU/Offer combination, maintained in the Item/SKU/Offer file (FCISOF).

• Gross units: The number of actual units ordered across all offers for this SKU.

• % (percentage by size): The percent of orders for this SKU compared to all of the SKUs for this style. This is the total quantity ordered for the SKU divided by the total for the first SKU element, such as the total for the size or color of the item. This is the percentage of contribution to sales for the first SKU element. The calculation is: Gross Units [SKU] / Gross Units [STYLE] * 100

• Qty ordered: The total number of all orders (against offers on this report) for this SKU, as captured in the Item/SKU/Offer file. The calculation is: Quantity Ordered in the Item/SKU/Offer file (FCISOF)

• Qty return (quantity returned): The total of all the returns (against offers on this report) for this SKU, captured in the Item/SKU/Offer file. The calculation is: Quantity Returned + Quantity Exchanged in the Item/SKU/Offer file (FCISOF)

• Qty cancel (quantity cancelled): The total number of all the cancels (against offers on this report) for this SKU, as captured in the Item/SKU/Offer file. The calculation is: Quantity Canceled in the Item/SKU/Offer file (FCISOF)

• Qty soldout: The total of all the sold outs (against offers on this report) for this SKU (using option 13 during Order Entry or sold out through the Auto Soldouts program). Sold outs are captured in the Item/SKU/Offer file. The calculation is: Quantity Soldout in the Item/SKU/Offer file (FCISOF). This value may include the number of units identified as a lost sale (using option #9 on the Item Availability screen prior to Order Entry), if you entered a Y in the Include lost sales in sold out field at the Select Class/Sold Out/Curve Overrides Screen. Lost sales are captured in the SKU/Offer/Page file, and post to the default Current Offer (A33) defined in the System Control file.

• % comp (percent complete): The number of total percentage of units ordered, as of the current period, for the entire projected sales cycle.

• Proj units (projected units): The quantity of the SKU that will be ordered during the life of all the SKUs offers on the report. The system uses the Projected units from the item/offer or SKU/offer on the report if the current period of the curve is less than or equal to the Periods to Use Projected Units (H91) system control value, and the Use projected units field is set to Y at the Select Class/Sold Out/Curve Overrides screen. Otherwise, the system uses the following calculation to determine the projected units: (Actual units ordered * 100) / % complete = projected units.

• Tot proj life (total projected life): The total quantity of the SKU that will be ordered during the life of all the SKUs offers on the report. This is the sum of the Projected units for all offers on this report. The calculation is: Gross Units [SKU] / Gross Units [STYLE] * 100

• Net prj life (net projected life): The projected number of units you expect to sell, taking into account what you can resell from returned items. Total projected life * (1 - (Expected return % / 100)). The value in the Periods to Use Expected Return % (D27) system control value determines the point at which you use the actual percentage of returns received to calculate the Net projected life.

• Net units: The net number of units ordered for all offers on this report, calculated by: Gross units - (Cancellations + Returns + Soldouts).

• Net prj remain (net projected remaining): The number of units needed to fill current open orders plus projected future orders (minus expected returns). This value represents the quantity of the SKU that will be ordered during the remainder of the lives of the SKU/offers. This identifies the number of units already ordered. If the IS Report Net Projected Remaining Calculation Method (D34) system control value is set to NET, this amount is calculated by subtracting Net units from Net projected life. If this system control value is set to GROSS, this amount is calculated as follows: Net projected life - Quantity ordered + Quantity returned/exchanged = Net projected remaining Note: If this system control value is blank, the net projected remaining quantity will not be calculated.

• On PO for ofr (On purchase orders for offer): The total units for this SKU on open purchase orders that are attributed to one of the offers on the report, if the Offer Required Entry on Purchase Orders (A36) system control value is set to Y. This includes any units located on a pending putaway detail record that is associated with a pending putaway warehouse, and whose "final destination" warehouse is allocatable, and is associated with one of the offers on the report. See Pending Putaway Overview. The calculation is: On PO for Offers in the IS Item file (FCISIT).

• Sugg qty (suggested quantity): The number of units of the item required to complete the demand for open orders (with quantity on-hand and expected returns taken into account). This is the quantity of this item that you will need to add to or remove from inventory to fulfill the remainder of the lives of the SKU/offers. If this value is negative, it means that you overbought; you might want to cancel a PO, place the item in a sale catalog, or return the item to the vendor.

• If the Offer Required Entry on Purchase Orders (A36) system control value is set to N, the calculation is: Net Projected remaining - (Available + On PO for offers) = Suggested qty

• If the Offer Required Entry on Purchase Orders (A36) system control value is set to Y, the calculation is: Projected remaining - (Quantity available + On order for offers on this report) = Suggested qty

• If the IS Report Net Projected Remaining Calculation Method (D34) system control value is blank, the net projected remaining quantity will not be calculated and the suggested units in this calculation will be inaccurate.

• On PO oth ofr (on purchase order for other offer): The total number of units on open purchase orders that are attributed to offers not on this report or any open purchase orders that do not specify an offer. This total includes any units located on a pending putaway detail record that is associated with a pending putaway warehouse, and whose "final destination" warehouse is allocatable, and is associated with offers not on this report; see Pending Putaway Overview. The calculation is: On PO for Other Offers in the IS Item file (FCISIT).

• Exp rtn % (expected return percent): The average of the expected returns percentage for the item from each offer listed on the report, from the Expected Return Pct field in the SKU/Offer file (INSKOF). Note: If an item/SKU has an expected return percent set up for more than one offer for which the report is run, the expected return percent on the report is an average of all the values.

• Act rtn % (actual return percent): The average of the actual returns for the item from each offer, from the SKU/Offer file (INSKOF). The # of Periods to Offset Returns (C06) controls whether the Units shipped in the calculation is based on the current period, or some previous period: (Returns and exchanged / Units shipped [FCISOF]) * 100. Note: If demand for an item/SKU exists in more than one offer for which the report is run, the total quantity returned/ exchanged and the total quantity shipped for all of the offers on the report are used for this calculation.

• Pers/Wks rem (periods/weeks remaining): The number of forecasting periods remaining before the quantity available runs out. This is based on the projected curve, before the current available quantity (including what is ordered on purchase orders) is exhausted. The calculation below is performed for each offer. The program performs this calculation for each period, subtracting each period's result from the Quantity available and Quantity on PO until it reaches zero. The calculation is: ((Actual units / % Complete) * (% Complete for the next period)). Note: This field appears only on the single-offer version of the report.

• CD (code): A code that identifies the status of the item, in terms of projected sales. This code identifies the remaining projected quantity as equal to, exceeding, or less than the quantity available. The system highlights the items for which the current quantity available equals or exceeds projected demand. One of the following codes prints in this column:

• A = current quantity available equals projected demand

• B = current quantity available exceeds projected demand (you overbought; you might need to cancel a PO, put the item in a sale catalog, or return a quantity to the vendor)

• C = current quantity is less than projected demand (you need to obtain more units of the item quickly)

• Avail rem (available remaining): The number of forecasting periods remaining before the quantity available runs out. This is based on the projected curve, before the current available quantity (including what is ordered on purchase orders) is exhausted. The calculation below is performed for each offer. The program performs this calculation for each period, subtracting each period's result from the Quantity available and Quantity on PO until it reaches zero. The calculation is: ((Actual units / % Complete) * (% Complete for the next period)). Note: This field appears only on the single-offer version of the report.

• CD (code): A code that identifies the status of the item, in terms of projected sales. This code identifies the remaining projected quantity as equal to, exceeding, or less than the quantity available. The system highlights the items for which the current quantity available equals or exceeds projected demand. One of the following codes prints in this column:

• A = current quantity available equals projected demand

• B = current quantity available exceeds projected demand (you overbought; you might need to cancel a PO, put the item in a sale catalog, or return a quantity to the vendor)

• C = current quantity is less than projected demand (you need to obtain more units of the item quickly)

• Lead pers (lead periods): The number of forecasting periods it will take to receive inventory for this SKU. This lead time is defined in the Vendor/Item file for the primary vendor (defined in the Item file for the item) to get the item to you. The calculation is: Cushion Periods [from forecasting SCV C00] + (Lead Days from Vendor/Item [POVNIT] / # of Days in Forecasting Period [from forecasting SCV C00]

• CR (Critical): This field identifies whether it is critical to reorder this SKU. A Y prints here if the weeks remaining are less than the lead periods in the previous field. This means that, if the item is not ordered shortly, you cannot receive stock in time to fill the expected orders. A Y appears in this column if "Weeks remaining" is less than "Lead periods + Cushion Periods." Note: This field is blank if no lead time is defined in the Vendor/Item file.

• Totals for style: Totals for all fields for SKU element 1, which may be the size, color, etc. for the base item

• Actual $: Actual units ordered * Price from Item/Offer file

• Projected $: Actual $ / (% Complete [from the Override Item Curve] / 100). Note: If an item/SKU has a price and page number or a price and return percent set up for more than one offer included on the report, dollars are projected for each offer separately and are printed separately on this report.

• Totals for item: A grand total of all fields for the base item, which is the summary of all subtotals for SKU element

• Total Item Return Percentage: The weighted return percentage for the item. This figure appears on the Totals for item line, under the Actual Return Percentage column. The Total Item Return Percentage is calculated as follows: Total units exchanged or returned / (Total units sold - Total units sold in the Number of periods to offset returns). In making this calculation, the system uses the values in the # of Periods to Offset Returns (C06) and # of Days in Forecasting Period (B96) fields in the System Control file. For example, if the number of days in a forecasting period is 7, and the number of periods to offset returns is 2, the system offsets returns two weeks. In this example, if the total units exchanged or returned is 15, total units sold is 100, and the total units sold in the last two weeks is 10, the system calculates the percentage as follows: 15/(100-10). The resulting percentage would be 16.67. Note: This field appears only on the 10-offer version of the report.