Find Jobs
Hire Freelancers

Create an Excel Tool for managing warehouse stock

£20-250 GBP

Terminado
Publicado hace casi 10 años

£20-250 GBP

Pagado a la entrega
Hi there I'd like to have created an excel file which will allow me to record in coming and out going stock. I would like to record stock under different category types with stock code and description I would like to record incoming stock, it's trade price cost and date received I would then like to record outgoing stock (ideally just enter stock code and quantity sold) I would then like to be able to print a report at that point in time which will list stock levels by category (and values/ total values) I understand there are better platforms than excel but this would be easier for us accessing from multiple computers via dropbox
ID del proyecto: 5922499

Información sobre el proyecto

47 propuestas
Proyecto remoto
Activo hace 10 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
Adjudicado a:
Avatar del usuario
Hi Thank you for allowing me the chance to bid on your project. As a new freelancer I understand the importance of building a reputation on this site and therefore I have priced this bid accordingly. However do not mistake this for a lack of expertise in this area. I have completed numerous projects relating to the development of Excel based tools. I would leverage off these previous tools in order to complete the task. As per your request, I propose that the Stock Management tool be an Excel based tool with built-in macros to facilitate the data entry process. I would envisage a 'Stock Movement' sheet that would be the point of entry for recording stock movements. The user would only be required to enter the code, date and quantity to record a movement (in or out), the remaining information (e.g. item description) would be pre-populated from a "Stock list" sheet. The user would be able to update this 'Stock list' sheet with new items, update prices etc. This ensures that data entered in the 'Stock Movement' sheet is consistent and free from errors. The movements would then be transferred/removed from a 'Stocktake' sheet (by a macro) which would contain current stock levels. Another sheet could contain reporting functionality that could be printed. It would also be possible to have an audit trail that would stamp the windows user name of the employee who entered the data. The tool could also be locked down (protected) and include data entry validations. Thanks
£50 GBP en 3 días
5,0 (1 comentario)
1,6
1,6
47 freelancers están ofertando un promedio de £112 GBP por este trabajo
Avatar del usuario
Hi, I'll be more than happy to help you with this project. Have done that several times before using Excel Please feel free to message me if you need to discuss any questions you might have prior to award
£100 GBP en 1 día
4,9 (249 comentarios)
7,6
7,6
Avatar del usuario
Hi, I am an Excel VBA expert and have been involved in projects of similar nature earlier. Please confirm and provide sample data. Regards, Arul
£140 GBP en 3 días
5,0 (162 comentarios)
7,1
7,1
Avatar del usuario
Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel/vba tasks, all achieved with 5/5 rating...I read your project descriptions carefully, I exactly got what you need and ready to go ahead if you wish to proceed with a top-rated and reliable partner here...I bid a very competitive amount for you..kindly note that I only deliver best quality at a reasonable price...awaiting your (+) reply to start....regards,
£100 GBP en 5 días
4,9 (221 comentarios)
7,3
7,3
Avatar del usuario
Hi, your project can be done with formula, VBA macro and pivot tables for the report. But we have to make a short discussion in order to clarify all the points. Thanks
£84 GBP en 5 días
4,9 (148 comentarios)
7,0
7,0
Avatar del usuario
Hi: Here's my proposal: I will design a menu driven Excel sheet where you will option of entering Stock, recording outgoing stock and a dashboard menu to view the current status of stock and stock sold. We can also add the option of sorting or filtering any particular type if you want. All the content in the dashboard will be printable. When entering data, it will present a form. The form will have drop down list for stock categories, a text box field for stock code, description, price and day received. Please connect with me to discus more
£77 GBP en 3 días
4,9 (138 comentarios)
6,8
6,8
Avatar del usuario
Hi Kerr. I have done a similar project in Excel, which required tracking of Stocks and I would be glad to extend a helping hand to you. If you are seeking a high quality application, kindly discuss. Regards. Usman
£120 GBP en 2 días
5,0 (67 comentarios)
6,7
6,7
Avatar del usuario
Dear Sir/Madam I'm happy to help you on this task. I am an expert in advanced excel features and have a strong financial background which is essential in this project. Please visit my profile to see my qualifications, experience and ratings, and if you are comfortable, please send me the information. I assure you that I will go beyond your expectations I look forward to hearing from you soon. Best regards, Priyal
£250 GBP en 4 días
5,0 (158 comentarios)
6,5
6,5
Avatar del usuario
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
£78 GBP en 0 día
4,9 (123 comentarios)
6,2
6,2
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
£100 GBP en 3 días
4,9 (112 comentarios)
6,2
6,2
Avatar del usuario
Hi , I can help you with excel model for warehouse / inventory management. I have worked in big accounting firms for more than 10 years and have extensive experience in business advisory. Please specify you requirement in details will help you out. Regards Sawan Gupta
£105 GBP en 3 días
5,0 (21 comentarios)
5,2
5,2
Avatar del usuario
Following are the features you would get. 1. An interface to make data entry a) A drop down showing asking for 'incoming' or 'outgoing' b)Entry facility for category, stock code, quantity, trade price and date Once done click a button to push the data in back-end. If entered values are same with one of the already made entries (same category, same stock code, same date, same status (incoming or outgoing) then it will pop up a message whether operator still want to make the entry replacing the already existing one. 2. A section for report generation. Where you need to select again which status (incoming or outgoing), from which date to which date, and press generate button to see all values with total at the bottom between two dates. If the above description is something similar to what you are looking for kindly let us know. And of course this can be made a shared document. So everyone in your office can access at the same time. Regards, Pal (d2imatrix)
£100 GBP en 2 días
5,0 (24 comentarios)
4,9
4,9
Avatar del usuario
Hi, I am working as a Software Engineer from last 3 years. Currently I working on projects solely based on Windows platform and MS office applications specially Excel and VBScripting So,I am good option to go with. Looking forward to hear from you. We can start as soon as you award this project to me. Thanks Abhinov
£150 GBP en 3 días
4,9 (29 comentarios)
4,9
4,9
Avatar del usuario
Hi there, I have more than 3 years experience with writing/debugging excel vba code. This is what I do on daily basis at my workplace. Creating an excel-based application for you it will be also my pleasure as I am a passionate programmer and eager to start our collaboration. I only need to know the Office/Excel version you are using, to make the appropriate coding (because, for instance - there are significant changes in VBA platform between excel in Office 2003 and Excel in Office 2010) Kind Regards, Jon P.S. I can offer support as well - after we close the deal. And if you feel like more customization is required - to better satisfy your need I can do it with no additional charge.
£100 GBP en 2 días
5,0 (34 comentarios)
4,9
4,9
Avatar del usuario
Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I have understood your requirement and I have develop amazing ideas to make this warehouse control tool work really interestingly. My bid amount right now is for updating sheets as per your job description whereby I would implement some drop-downs to make the input easier for you. If you supply me the Stock Codes, Price list, it will be nice to do this drop-downs. However, my idea if implemented would need me to code some macros so if you would like my idea than I would quote a price of 50. So here is my idea. You have a Master sheet where you can enter all stocks (Outgoing & Incoming both). With an automation, this stocks moves to either Outgoing or Incoming sheets based on your command of just a mouse click. Additionally, a table alongwith a graphical representation of your stock levels by category. This will be automated as well to update as per your current stock entries in the Master Sheet. Please let me know how do you like my idea. Thanks ! Regards Dan
£30 GBP en 2 días
4,9 (10 comentarios)
4,3
4,3
Avatar del usuario
Hi, I am well versed with MS Excel and create this tool for you. I can also introduce some automation in the tool using VBA macros as I well versed with VBA as well. Please let me know if we can discuss further on the warehouse stock management tool. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
£100 GBP en 3 días
4,8 (13 comentarios)
4,1
4,1
Avatar del usuario
Hello Kerr79, Thank you for the project post. I am working in an FMCG goods Warehouse in Pakistan, my contract is just getting over. Right now I am looking for a Job as Warehouse Operative/Associate or Assistant in any foreign country. Regarding warehouse inventory report. I will need more information. Please send me list of products/items including their details and quantity. It is possible for me to create a complete excel inventory management report which will contain following attributes. --Incoming Goods-- TOP - Product Descriptions Column [Title] - GIN/GRN Column (Shared with Outgoing Goods) [Title] - Opening Balance Row (with goods inventory quantity will be maintained in cells) . . BOTTOM: - Today's Receipts - Total Available Units - Total Dispatches .............................................................................................. Outgoing Goods - Description of Goods dispatched with Dealers or customer respect. - Closing Balance. . . . - MTD Dispatches (mean total dispatches for the day) - MTD Receipts (mean total dispatches for the day) - Damage Stocks - Actual count - Weight of goods All attributes will be visible at left and maintained on daily basis for data/record posting, entry while all total counts of inventory can be viewed on Right of each attribute. It is better to create a sample sheet based on your requirement and products then i can send you a demo. Regards Nauman .
£211 GBP en 15 días
4,7 (8 comentarios)
3,6
3,6
Avatar del usuario
hello employer, I can do this Consider me and get it done perfectly as well as quickly. Please come for the discussion. Thank you.
£230 GBP en 5 días
4,8 (4 comentarios)
3,2
3,2
Avatar del usuario
i have something better. and u can install it between multiple computers. EXCEL is no doubt easiest but u have to do double entry and if 1 entry missed it will give a lot of trouble rooting it. i have done this for OSIM Pakistan in excel to manage 3 warehoused and 6 shops.
£23 GBP en 0 día
5,0 (6 comentarios)
3,2
3,2
Avatar del usuario
Hi, I am a Chartered Accountant (CPA Equivalent) and an Excel Expert. I have over 8 years of professional experience and have done many projects. I have clearly understood your requirement and am confident of delivering a output exceeding your expectations. I would be able to provide valuable suggestions too. Message me if you want to discuss the project. Thanks
£190 GBP en 2 días
4,7 (7 comentarios)
3,0
3,0
Avatar del usuario
I am an experienced coder. I have also written excel macros to perform similar tasks. I have also written tools in other languages that can modify excel sheets according to requirements and employers were completely satisfied by my solutions. Thank you
£166 GBP en 7 días
5,0 (5 comentarios)
2,8
2,8

Sobre este cliente

Bandera de UNITED KINGDOM
Edinburgh, United Kingdom
5,0
12
Forma de pago verificada
Miembro desde jul 6, 2011

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.