Alternate BOM prioritization based on component's Expiration date or standard Cost or Purchase price

Summary:

We are evaluating constraint based supply planning. For certain assemblies we have more than 3 alternate BOMs. Each has a production priority set up in its routings (work definition). Our manufacturing is in EBS, so we are extracting data out of EBS into Supply planning cloud.

One of the requirements business has is to be able to recommend alternate BOMs based on the expiration date (FEFO) of the components used in alternates. If components for all alternates are on hand and If the priority 3 alternate's components are expiring before the components used in alternate 1 (priority1), then system should recommend alternate BOM 3.