Calculate optimal Product Mix

hi - I am trying to calculate ‘Todays Production Order’ using power BI. Target is the inventory I want to have in the store. Transfer value includes the price attached to the items. Remaining is the current Inventory in the store. How do I calculate today’s Production order, keeping in mind that the total transfer value should not go beyond $500?Product Mix.xlsx (16.5 KB)

@shyaka, welcom to the Forum!

Please go over the post on how to use this forum.

If you follow this link here you’ll find some articles that might be of interest to you.

1 Like

Hi @shyaka, we’ve noticed that no response has been received from you since the 25th of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!