Return Product Ratios

Internal Table Name: ReturnProductCoefficients

Use the Return Product Ratios table to define the relationship between received and returned products by customer.

Period

Technology: NO S

Table: ReturnProductCoefficients

Internal Name: PeriodName

Type: Short Text (50)

Enter the period name to which the return product ratio applies.

Customer

Technology: NO S

Table: ReturnProductCoefficients

Internal Name: SourceName

Type: Short Text (100)

Select the customer or customer group for which the return product ratio applies.

Product

Technology: NO S

Table: ReturnProductCoefficients

Internal Name: ProductName

Type: Short Text (100)

Select the product or product group that is demanded by the customer. For example, the Product could be Finished Good1, as demanded by the customer. This is the Product as defined in Return Policies.

Return Product

Technology: NO S

Table: ReturnProductCoefficients

Internal Name: ReturnProductName

Type: Short Text (100)

Select the return product or product group that is being returned by the customer. For example:

• On average, a percentage of demanded products are returned. In this case, the Return Product may be the same as the Product.
• To track damages, the Return Product could be Damaged Good1.
• Special packaging may need to be returned after delivery.

Return Rate

Technology: NO S

Table: ReturnProductCoefficients

Internal Name: ReturnRate

Type: Short Text (255)

Enter the effective exchange rate between the Product and the Return Product. For example, one unit of product called Finished Good1 may be shipped with 4 frames called Shipping Frame that need to be returned to the manufacturer. In this case, the Return Rate is 1 and the Return Quantity is 4.

Rate Basis

Technology: NO S

Table: ReturnProductCoefficients

Internal Name: ReturnRateBasis

Type: Short Text (255)

One of Per Unit, Per Shipment, Per Order.

Enter the basis by which the Return Rate is applied.

Return Quantity

Technology: NO S

Table: ReturnProductCoefficients

Internal Name: ReturnQuantity

Type: Short Text (255)

Enter the amount of Return Product that is to be returned. Enter a value, then optionally select a quantity, weight or volume unit of measure. If you do not select a unit of measure, the default Quantity unit of measure from Model Settings is used.

Status

Technology: NO S

Table: ReturnProductCoefficients

Internal Name: ReturnProductCoefficientStatus

Type: Short Text (25)

One of Include, Exclude.

Choose the return product ratio status:

• Include - This return product ratio is to be included in an optimization run.
• Exclude - This return product ratio is to be excluded from an optimization run.

Default: Include

Notes

Technology: NO S

Table: ReturnProductCoefficients

Internal Name: ReturnProductCoefficientNotes

Type: Short Text (255)

Enter optional descriptive notes about the return product ratio.