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%