Find Jobs
Hire Freelancers

Inventory/Stock Management in Excel

£20-250 GBP

Imefungwa
Imechapishwa 6 months ago

£20-250 GBP

Kulipwa wakati wa kufikishwa
I need an inventory/stock management system in Excel to manage our stock balance, the stock coming in, the stock coming out. On day 1, I will have the opening stock of each item, the colour, and sizes. I want a tracker that will see the stock that we have coming in and out (however, the stock coming in will usually be the same as stock coming out as we will only order the stock if someone needs it, so 1 stock in should be 1 stock out the next day, if that makes sense?) I want the 'stock in' and 'stock out' sections to be with the quantity, size, colour, and the date too. Then the stock balance will see the difference between the stock in and out on each day, which will require some formulae. I then need a column that will have the minimum number of stock to be kept, which will equal to 2 for each item. I then need another column that will make the admin suggestion, where if the stock balance falls to 2 or below, then the cell should say 'order stock', which should be highlighted in yellow too. Please see the Excel attachment in sheet 3, as I want something similar to this. There will be a lot of excel formulae involved.
Kitambulisho cha mradi: 37440404

Kuhusu mradi

39 mapendekezo
Mradi wa mbali
Inatumika 5 mos ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
39 wafanyakazi huru wana zabuni kwa wastani £117 GBP kwa kazi hii
Picha ya Mtumiaji
Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.
£40 GBP ndani ya siku 1
4.8 (237 hakiki)
7.3
7.3
Picha ya Mtumiaji
Hello there, I'm eager to develop an Excel-based Inventory/Stock Management System for your business. With a Master's in Finance since 1998, I'll create a dynamic tracker to manage stock in/out, sizes, colors, and dates, ensuring accurate daily balances. My solution will include automated alerts for items nearing or falling below the minimum stock level of 2 units, streamlining restocking decisions and enhancing efficiency. I've reviewed the provided Excel sheet and am confident in delivering a tailored, efficient solution aligned with your needs. I'm excited about the opportunity to contribute to your business's success through this project. I'm available from 8am till 11pm Lebanon Time(UTC+2) Best Regards, Saliba.
£199 GBP ndani ya siku 4
4.8 (98 hakiki)
6.1
6.1
Picha ya Mtumiaji
Pleasure to help you. Excel automation is my masterpiece in my accounting field. I can design that fits your needs. Feel free to message me to help you.
£100 GBP ndani ya siku 3
4.9 (75 hakiki)
5.7
5.7
Picha ya Mtumiaji
Hello, I can help with this job. Can start right now I can do for you great inventory system with full monitoring reports. I can do it using Excel VBA I'm working in big distribution company and working on reports from our base. So I have very good experience. Regarding my experience you can check in my reviews with 100% feedback I have 16+ year experience of Excel, Excel VBA and Have 100% feedback So, you can trust me. Result will be as you need Best Regard
£150 GBP ndani ya siku 7
5.0 (73 hakiki)
5.5
5.5
Picha ya Mtumiaji
I understand that you are looking for an inventory/stock management system in Excel to manage your stock balance and the stock coming in and out. I would be delighted to assist you with this project. As an experienced professional with a track record of success, I am well-placed to lead the team responsible for developing an inventory/stock management system in Excel that meets your needs. My expertise in project management has allowed me to successfully lead cross-functional teams and deliver complex projects on time and within budget. My strong organizational skills, attention to detail, and ability to communicate effectively with stakeholders have helped me navigate complex projects and ensure successful outcomes. Additionally, I have a deep understanding of strategic planning and marketing campaigns across a variety of channels. My experience in both B2B and B2C markets gives me a broad perspective on how to approach these areas of planning. This combination of skills makes me uniquely suited to lead the team responsible for developing the inventory/stock management system in Excel that you require.
£135 GBP ndani ya siku 7
4.9 (4 hakiki)
4.4
4.4
Picha ya Mtumiaji
Dear Client. When it comes to your project, i am expert. I will provide you 100% satisfaction work and full service. It would be great if you hire me. Based on your feedback, I can draft my proposal accurately and from there I can get started. Hence, I look forward to hear back from you in order to proceed ahead accordingly. Let's Go Thanks a lot. Regards
£100 GBP ndani ya siku 4
5.0 (17 hakiki)
4.1
4.1
Picha ya Mtumiaji
Hello. I read your requirement and also check attachment i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
£95 GBP ndani ya siku 1
5.0 (16 hakiki)
4.0
4.0
Picha ya Mtumiaji
Hello sir, I understand your need for an efficient inventory/stock management system in Excel. Leveraging my expertise in advanced Excel functions and formulas, I will create a comprehensive tracker for your stock, including stock in, stock out, and stock balance. The system will automatically highlight cells suggesting to order stock when the balance falls to 2 or below. Let's discuss any specific requirements or adjustments you'd like and ensure the system meets your expectations.
£150 GBP ndani ya siku 2
5.0 (6 hakiki)
3.3
3.3
Picha ya Mtumiaji
Hello, I have experience with this works so you can hire me to get a fast and efficient work done exacly as what you spect. If you want to explain me more about your needs, just open chat
£120 GBP ndani ya siku 7
5.0 (5 hakiki)
3.4
3.4
Picha ya Mtumiaji
Hello I understand your request that you’re demanding Inventory/Stock Management in Excel As a Professional Geeks I can avail creative, proactive and high-tech solutions to your development needs. I have excellent experience in Metatrader (4 And 5),Ninjatrader (7 And 8),Indicators & Trading Robots Development,Tradingview (Pinescript & Strategy),Python Trading Api,Machine Learning,,Python,HTML, Javascript, PHP,CSS, Laravel,Java,Joomla,Angular.js,MySQL, Node.js, React.js,Wordpress,linux Ruby on Rails, Database, Objective-C and Swift,C, C#, C++, Qt, Linux and raspberry. My Engineering skill are unimaginable with lot of success in engineering task My page is clear about my professionalism with awarded task Don't hesitate to contact me to create awesome products! Thanks
£20 GBP ndani ya siku 1
5.0 (2 hakiki)
2.8
2.8
Picha ya Mtumiaji
Hi there, I'm excited to express my interest in your Inventory/Stock Management in Excel project. With 4-5 years of experience in Visual Basic, Data Processing and Excel, I'm well-prepared to add significant value to your initiative. Please note that the initial bid is provisional. A final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please provide any available detailed documentation? I'm also open to further discussions to delve deeper into specific aspects of the project. Feel free to review my profile, which showcases my portfolio, past jobs, and client reviews, reflecting the quality and professionalism I bring to every project. I always aim to offer a competitive budget without compromising on quality. Thank you for considering my proposal. I'm eager to collaborate and contribute to your project's success. Let me know if you need any additional information. Best regards, Rashid Amjad.
£150 GBP ndani ya siku 11
5.0 (2 hakiki)
3.0
3.0
Picha ya Mtumiaji
Happy Diwali ! Edi S. I've worked with other clients in similar project, so I have rich experiences with skills including Data Processing, Excel and Visual Basic. Specially I can work on your time zone for the good communication. I'd like you to discuss the requirements in more detail through chat and start right now. Regards, Samantha
£150 GBP ndani ya siku 3
5.0 (1 hakiki)
2.3
2.3
Picha ya Mtumiaji
I am a seasoned research professional with a robust background in creating efficient inventory/stock management systems using Excel. I am excited about the opportunity to assist you in developing a comprehensive and user-friendly system tailored to your specific needs. Scope of Work: I understand your requirements for an Excel-based inventory/stock management system that encompasses the following features: Stock Balance Management: Track stock balances on day 1 and implement dynamic formulas to calculate daily stock movements. Stock In/Out Tracker: Establish a tracker to monitor stock inflow and outflow, ensuring seamless management of inventory transactions. Minimum Stock Requirement: Set up columns to display the minimum stock required for each item, initializing at 2 on day 1. Admin Suggestion Column: Integrate a column providing admin suggestions; if stock falls to 2 or below, trigger a 'order stock' recommendation highlighted in yellow for easy identification. Benefits of the Proposed System: Automated calculations for precise stock management. Clear visualization of stock levels and order recommendations. Enhanced efficiency in inventory tracking and decision-making. Next Steps: I am eager to discuss your specific requirements further and customize the system to align seamlessly with your workflow. Please feel free to reach out to me to initiate the conversation and explore how this Excel solution can streamline your inventory management processes.
£135 GBP ndani ya siku 7
5.0 (4 hakiki)
2.5
2.5
Picha ya Mtumiaji
I understand you are looking for an inventory/stock management system in Excel to manage your stock balance and the stock coming in and out. I am confident that my experience and skills make me the best fit for this project. With over 15 years of experience in C#, VB.NET, Winforms, and WPF development, I am highly skilled in creating user-friendly applications that meet client needs. Additionally, I have a proven track record of delivering high-quality software solutions that are adhered to performance and maintainability standards. I would be delighted to discuss this project further with you so that we can work together to create the perfect solution for you. Please feel free to contact me if you have any questions or would like to discuss further how I can help you achieve your goals for this project!
£185 GBP ndani ya siku 7
5.0 (2 hakiki)
2.1
2.1
Picha ya Mtumiaji
Hello, I am Saim, a skilled Excel expert with over 10 years of experience in the industry. As you mentioned in your project description, you are looking for an inventory/stock management system in Excel to manage your stock balance, the stock coming in, and the stock coming out. On day 1, I would expect the opening stock of each item to be tracked along with the color and sizes. The tracker should see the stock that we have coming in being equal to the stock coming out on subsequent days as we do not order any stock unless someone needs it. I understand that you require a tracker that will see the stock that we have coming in and out (however, the stock coming in should usually be the same as stock coming out as we will only order the stock if someone needs it). Additionally, we should make sure that there is at least a minimum number of stock needed to be kept on each item so that it will always equal to 2 before being ordered. I am confident that my skillset combined with those of my team would be perfect for this project. We have extensive knowledge in Excel which will be vital for building your inventory/stock management system in Excel and we are committed to providing
£80 GBP ndani ya siku 1
4.8 (2 hakiki)
1.8
1.8
Picha ya Mtumiaji
You've got the right candidate for you here. Best in data entry for 5yrs now as well as advanced excel. I can assure you that I have understood your work description and I can do to almost perfection. I look forward to working with you. Thank you
£20 GBP ndani ya siku 1
5.0 (2 hakiki)
0.5
0.5
Picha ya Mtumiaji
Hi, Edi S. how are you? I am Larrisa. I am a senior full stack developer with Visual Basic, Data Processing and Excel I have 7 years of experience in web development until now so I have deep knowledge about creating web site, how to make a responsive website, how to create a modern design, how to optimize the code and so on. I can speaking English fluently so you can communicate effectively to save your time. Please send me a message and discuss more. I can start your work immediately. Thank you!
£150 GBP ndani ya siku 6
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hi, Please Give me one chance to work for you, I have expertise in Data Processing, Excel and Visual Basic, I have read your details posted in project. I Will sure give you 101% High quality, creative and fast work. I have done number of similar projects in past.I will show you my latest work on Chat. I am very interested in your project and also ready to start immediately. Looking forward for long term business relationship. Thanks and Regards,
£150 GBP ndani ya siku 6
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hi, there I want to work with you because I found the idea very interesting and I think my company is able to deliver exactly what you need. I am confident that I am able to complete this project within as asap due to our expertise in various technologies such as Excel, Data Processing and Visual Basic and more. We have a team of highly skilled professionals who are equipped to handle any task that comes their way. We understand the importance of timely delivery for this project and will do our utmost to make sure that everything is completed on time.
£150 GBP ndani ya siku 4
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
?Hi , Edi S. This is Cindy, I've rich experience in Data Processing, Excel and Visual Basic After reading your job description, I understand you're looking for freelancer with good experience in Data Processing, Excel and Visual Basic. I've checked your requirements and worked with another client in this space. I am fully available to start your project immediately and you might find it's very interesting to have a chat with me about the project details. Thanks and Best regards. Cindy
£150 GBP ndani ya siku 4
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED KINGDOM
RAINHAM, United Kingdom
5.0
6
Njia ya malipo imethibitishwa
Mwanachama tangu Feb 7, 2022

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.