Required Data Science,Mathematics,Microsoft Excel freelancer for Inventory Management (Excel) - Mathematician to Calculate ideal order quantities based on sales data job

I require someone expert in mathematics and excel.

The rugs have variations in Colour / Density / Size and we have sales statistics on each combination (52 in total).

I have the attached excel sheet with the sales statistics, current inventory, 'to order' inventory, and total inventory (the amount we will have after we order).

I need the 'To Order' column to be completed based on the statistics of what sells. This is to be done using excel formulas.

This is so that next order, I can update the % values in the sales statistics section (based on what is selling) and the excel sheet will automatically update with the numbers I should be ordering.

Best Regards

Skills & Expertise Required

Data Science Mathematics Microsoft Excel