Forecasting

Hello,

I need help with forecasting data in excel.
Basically I need find the perfect Sale Mix to maximum total units sold.
I would prefer to sell the units that have low days in inventory vs a high day in inventory because i believe i can sell more units
Any help would be great. I am total lost here

Thank you!

Days in Inventory Units sold Current Sale Mix
30 60 19%
60 50 16%
90 200 65%

If you prefer to sell the products with low days in inventory then you will guarantee that the others will have even higher days in inventory.


Sent from my iPad using Tapatalk