Find Jobs
Hire Freelancers

Using Excel Macros, create an inventory management tool

₹12500-37500 INR

Cerrado
Publicado hace casi 4 años

₹12500-37500 INR

Pagado a la entrega
We wish to create an inventory management tool, using excel macros. For this purpose, we will be maintaining a collection of excel files which will serve as data files. Some of these will be master files and some will be transaction files. There will be another interface file which will contain the menu needed to run this tool. This menu will have several buttons to carry out the following actions: A) Masters 1) Create and edit consumable / non-consumable inventory masters 2) Create and edit vendor masters 3) Create and edit customer masters 4) Create and edit project masters 5) Create and edit finished goods inventory masters B) Transactions 1) Create and edit entry of raw materials inward 2) Create and edit rejection of some faulty inventory from above 3) Create and edit issue of inventory for production 4) Create and edit generation of new finished goods inventory 5) Create and edit issue of finished goods to customers As a part of this entire process, some documents get generated. They are store receipt voucher, material arrival intimation, store issue voucher, delivery challan and material gate pass. Also, some further reports may be needed which will be specified later. Userforms need to be created to enter the data (in the data files) through the interface file. So make sure you are well-versed with the designing of the userforms. Some sample files are attached herewith. Please issue your quote to execute this project and the expected timeline. Keep some margin in your quote for a little scope creep. Expect some iterations in the development process and a few rounds of back n forth communication till the product is finalised. Give your quote in terms of creating the project to put data into the system and generate the standard documents as indicated in the uploaded files. Give a separate quote for the reports in terms of per report development cost. Thanks!
ID del proyecto: 25839046

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 4 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
9 freelancers están ofertando un promedio de ₹26.827 INR por este trabajo
Avatar del usuario
Hi I have worked in Bosch ltd as Material Planner and currently as costing executive in FPI. I have good experience in Macros. My recent project was to create Hierachy chart in macros. Pls contact.
₹22.222 INR en 10 días
5,0 (6 comentarios)
2,7
2,7
Avatar del usuario
Good afternoon, I am Pedro Requena, Excel and .Net VBA Specialist, I was reading your request and I can do this work since I have an Application developed in Visual Studio 2019, which is called SYSPRIN, Production and Inventory System, its base of mail data in the Free Software Firebird ISQL Tools console. You can integrate the modules (Masters) of Projects, you already have a module of General Inventory, Suppliers, Clients and a module of user control, you have a Module for input of raw material and finished product manually, it is not suitable for your need, the issuance of vouchers is missing, in the case of being chosen I will work hard to have all the points up to date. I invite you to visit my portfolio so that you have an idea of the quality of my work: https://www.freelancer.com.ar/u/RequenaP For more detail of my work in the chat we can talk, the subject of budgets. Best regards.
₹37.000 INR en 14 días
5,0 (2 comentarios)
2,8
2,8
Avatar del usuario
Hi! I am an Information System Enginner with 14 years of experience. I have done many projects related to Excel Macros and automations, So I have plenty experience in this area. I am new in freelancer.com, so thats why I haven't done many projects,but I do this kind of tasks in my every day job. I would like to help you with this. Thanks.
₹25.000 INR en 7 días
5,0 (1 comentario)
1,8
1,8
Avatar del usuario
I assure you that task will delivered meeting deadlines and accuracy. I hope to hear more about what would make your project a success for you. Thank you for your time
₹25.000 INR en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dynamic, organized, action oriented, problem solver and highly motivated Senior project coordinator with 7+years of experience in Project support, Customer management, Order management, Vendor Management and Retail Banking. Focusing on fulfilling internal and external clients’ needs and resolving issues while delivering high quality performance. Detail oriented, customer centric professional capable of providing a high level of project support for the purpose of accomplishing projects.
₹25.000 INR en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Data Entry Clerk with 4+ years of experience verifying complex data, inputting figures into client databases at a quick pace, and maintaining the confidentiality of sensitive material.
₹25.556 INR en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear San Namestay Please review my profile , I have the capability to perform any task successfully and honestly. Regards
₹25.000 INR en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I have an experience of tool creation for Warehouse management and Raw material risk assessment using VBA and macros. I can leverage my experience to create a tool for inventory management. Relevant Skills and Experience Hands on experience in Advanced Excel and visual basic, Tools created for warehouse management and risk assessment.
₹23.333 INR en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Expect world class delivery for sure ! Hi, I am a qualified masters in supply chain and bachelors in engineering with more than 15 years of experience in supply chain & data analytics. I am starting new in the online freelancing world hence want to do my initial projects more to prove my worth and less for money. Till now I have been working as a freelancer for offline projects (coming though my contacts in industries/previous employers) I have accomplished numerous projects on inventory management and have also developed tools for same on excel and other DBMS & visualisation platforms (power bi, ms access etc). I have also been a supply chain trainer for the firms I have worked in. I have worked across functions such as procurement, demand planning, supply planning, inventory management, warehousing and logistics in both manufacturing and after market segment. I am a certified sigma black belt and have published several white papers on various supply chain topics. I will be highly obliged if you consider me for your project. Rest assured that the work I’ll deliver will be of highest grade & on time. Allow me a chance and I assure you of not letting you down. And Yes if required to stretch for longer hours it will never be an issue for me. Regards, Triptitva
₹33.333 INR en 15 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
Mumbai, India
0,0
0
Miembro desde ene 28, 2020

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.