Excel VBA Script for MRP Automation
Budget: ₹750 – ₹1,250 INR
I need an experienced Excel VBA programmer to create a script that will automate the following tasks for Material Requirement Planning (MRP):
- Inventory Management: The script should monitor and manage the quantities of raw materials in the inventory.
- Order Scheduling: The script should help in scheduling orders based on the current inventory status and production schedules.
The script will need to process data concerning:
- Raw Material Quantities: This will involve tracking the quantities of raw materials available in the inventory.
- Production Schedules: The script should be able to use data from our production schedules to help in order scheduling.
Data Input: The data for the script will be coming from a database connection, so it should be capable of efficiently processing information in real-time.
Ideal skills for this project include advanced knowledge in Excel VBA, a strong understanding of inventory management and order scheduling, and experience with database connections. Please ensure you have a solid portfolio demonstrating your experience with similar projects.
- Inventory Management: The script should monitor and manage the quantities of raw materials in the inventory.
- Order Scheduling: The script should help in scheduling orders based on the current inventory status and production schedules.
The script will need to process data concerning:
- Raw Material Quantities: This will involve tracking the quantities of raw materials available in the inventory.
- Production Schedules: The script should be able to use data from our production schedules to help in order scheduling.
Data Input: The data for the script will be coming from a database connection, so it should be capable of efficiently processing information in real-time.
Ideal skills for this project include advanced knowledge in Excel VBA, a strong understanding of inventory management and order scheduling, and experience with database connections. Please ensure you have a solid portfolio demonstrating your experience with similar projects.