Inventory Management Excel Automation
Budget: $30 – $250 USD
I need an experienced Excel expert to create a spreadsheet that will automatically calculate important inventory-related information, based on the data I provide.
Key Requirements:
- The inventory spreadsheet should be able to calculate how many months my current inventory will last.
- It should also estimate when a new purchase order needs to be made, factoring in lead times.
- Lastly, the spreadsheet should take into account open purchase orders with incoming inventory.
Your deliverable will be an Excel sheet that automates these calculations based on the data I'll provide you.
Ideal Skills and Experience:
- A strong background in Excel and spreadsheet automation.
- Previous experience in inventory management or supply chain would be advantageous.
- Ability to work with formulas and functions to create accurate and efficient calculations.
Please provide examples of similar projects you've worked on, and let me know if you have any suggestions for additional features that could improve the functionality of the spreadsheet.
Key Requirements:
- The inventory spreadsheet should be able to calculate how many months my current inventory will last.
- It should also estimate when a new purchase order needs to be made, factoring in lead times.
- Lastly, the spreadsheet should take into account open purchase orders with incoming inventory.
Your deliverable will be an Excel sheet that automates these calculations based on the data I'll provide you.
Ideal Skills and Experience:
- A strong background in Excel and spreadsheet automation.
- Previous experience in inventory management or supply chain would be advantageous.
- Ability to work with formulas and functions to create accurate and efficient calculations.
Please provide examples of similar projects you've worked on, and let me know if you have any suggestions for additional features that could improve the functionality of the spreadsheet.