Availability Calculation is Incorrect (Doc ID 2777193.1)

Last updated on AUGUST 16, 2022

Applies to:

Goal

Available Quantity calculation is not 

Initial formula:

• Numerical Availability = No. of SKUs Below MDQ / Total Number of SKUs in scope
• Qty Weighted Availability = Adj SOH Qty / MDQ Qty
• Value Weighted Availability = Adj SOH V / MDQ V

Inputs:
• SKUs Below MDQ = Case when (SOH – MDQ < 0 and shelf capacity is not null) then 1 else 0
• Adj SOH = if SOH< MDQ then SOH, if SOH>MDQ then MDQ
• Gap Qty = MDQ – Adj SOH
• MDQ V = MDQ * Retail Price
• Adj SOH V = Adj SOH * Retail Price
• Gap V = Gap Qty * Retail Price

The formula for "SKUs Below MDQ" should be:
• SKUs Below MDQ = Case when (SOH – MDQ < 0) then 1 else 0

Please validate.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.