Excel Guru for Manufacturing Automation
Budget: ₹1,500 – ₹12,500 INR
I need an expert who can create an Excel system that can help me improve the efficiency of my manufacturing business. My primary focus is on automating our inventory management. As of now, we are tracking things manually, using pen and paper. This old-school method is tedious and prone to errors. I believe that by automating this, we can significantly reduce the time spent and improve accuracy.
Your role will be to create a sophisticated Excel spreadsheet that allows:
- Automatic calculation of inventory turnover to understand how efficiently we're moving stock.
- Alerts for when the stock falls below a certain level to prevent running out of stock.
- Data analysis on the highest selling products to better understand what's driving our business.
Ideally, you will have a strong background in business operations, specifically in manufacturing. This will allow you to comprehend our needs better and produce a more beneficial tool. Advanced excel skills, especially in creating automated functions and comprehensive data analysis, are a must. Familiarity with inventory tracking and management would be a significant plus. Understanding of business metrics related to inventory management, such as inventory turnover and sales forecasting, will be beneficial.
Your role will be to create a sophisticated Excel spreadsheet that allows:
- Automatic calculation of inventory turnover to understand how efficiently we're moving stock.
- Alerts for when the stock falls below a certain level to prevent running out of stock.
- Data analysis on the highest selling products to better understand what's driving our business.
Ideally, you will have a strong background in business operations, specifically in manufacturing. This will allow you to comprehend our needs better and produce a more beneficial tool. Advanced excel skills, especially in creating automated functions and comprehensive data analysis, are a must. Familiarity with inventory tracking and management would be a significant plus. Understanding of business metrics related to inventory management, such as inventory turnover and sales forecasting, will be beneficial.