using stockout indicator in weekly_prod_dmnd table

DCM
Demand Chain Management
Teradata Employee

using stockout indicator in weekly_prod_dmnd table

What are the rules to interface stockoutInd column in the DCM WPD table?


Accepted Solutions
Teradata Employee

Re: using stockout indicator in weekly_prod_dmnd table

  • Set the stockoutind column to 1 in wpd table (wekly_prod_dmnd) when a pdl (product/location) runs out at any point during the week
  • That will allow the ETL to calculate lost sales and revised demand as the difference between the forecast sales (expected sales) and the actual sales reported in wpd
  • This will tell the application the pdl ran out during the week reported in wpd with the stockoutind field set to 1
  • The lost sales calculation is typically in the wpd ETL and developed by the PS team or the client
  • The stockout logic is independent of whether you use replenishment
  • The standard logic is when stockoutind is 1 OR inventory 0, the ETL will apply the revised demand calculation and store it in wpd_rev table (wekly_prod_dmnd_rev) as revised demand
  • This depends on how the ETL was written

 

For additional details you can also consult the following documentation:

  • KCS-ONE Knowledge Centered Support article: KCS001281
  • TDCM Table Interface Guide

 

1 ACCEPTED SOLUTION
1 REPLY
Teradata Employee

Re: using stockout indicator in weekly_prod_dmnd table

  • Set the stockoutind column to 1 in wpd table (wekly_prod_dmnd) when a pdl (product/location) runs out at any point during the week
  • That will allow the ETL to calculate lost sales and revised demand as the difference between the forecast sales (expected sales) and the actual sales reported in wpd
  • This will tell the application the pdl ran out during the week reported in wpd with the stockoutind field set to 1
  • The lost sales calculation is typically in the wpd ETL and developed by the PS team or the client
  • The stockout logic is independent of whether you use replenishment
  • The standard logic is when stockoutind is 1 OR inventory 0, the ETL will apply the revised demand calculation and store it in wpd_rev table (wekly_prod_dmnd_rev) as revised demand
  • This depends on how the ETL was written

 

For additional details you can also consult the following documentation:

  • KCS-ONE Knowledge Centered Support article: KCS001281
  • TDCM Table Interface Guide