Inventory Management (Excel) - Mathematician to Calculate ideal order quantities based on sales data

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
About the recuiter
Member since Jul 20, 2017
Ron P.
from Queensland, Australia

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions