maximize output of product with alternative bom

[kema]

dear community,
my problem is the following: I have a product that has two recipes, which excel formula or method I can use to maximize output for each batch?
please see attached example. thanks a lot!

 

[DAMODAR]

Hi,
Do you got the solution for the query.
I do have a similar query.

Damu