Find Jobs
Hire Freelancers

An excel spreadsheet

£20-250 GBP

Closed
Posted about 10 years ago

£20-250 GBP

Paid on delivery
I want to create an inventory system in excel to keep track of 100 food products in vending machines there will be a mobile application feeding data on a daily basis (that part is sorted) there will be about 4-6 fields receiving data daily (just numbers),this data is ISSUE (to be deleted from inventory). I need the work sheet to absorb this data and keep track of quantities of products used and still available . I estimate the core work sheet should not exceed 20 columns. There will be a need to MOVE quantities of product between colums (locations) eg: from warehouse to van and also to receive new product in (Receive) from suppliers.
Project ID: 5707532

About the project

43 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
43 freelancers are bidding on average £115 GBP for this job
User Avatar
Hi! Please send me message so that I can send you a sample that was prepared for inventory management. Thanks, Khurram .
£160 GBP in 3 days
5.0 (401 reviews)
7.8
7.8
User Avatar
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 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,
£105 GBP in 3 days
4.9 (297 reviews)
8.0
8.0
User Avatar
Hi, I will be happy to help you with this project. Please feel free to message me for prelim discussion prior to award
£111 GBP in 1 day
4.9 (251 reviews)
7.7
7.7
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
£147 GBP in 2 days
4.9 (330 reviews)
7.7
7.7
User Avatar
Hi, I am an Excel macro specialist and would be happy to take on your project. Kindly provide specific details regarding the project with sample Excel data. Regards, Arul
£150 GBP in 3 days
5.0 (173 reviews)
7.4
7.4
User Avatar
Hi, I have a degree in Business and I work with excel every day. I can create a spreadsheet that meets all your requirements. Chat with me. Greetings.
£83 GBP in 5 days
5.0 (322 reviews)
7.4
7.4
User Avatar
Dear Sir/Madam I'm happy to help you on this task. Because I have experience in both advanced excel works and financial works. And also, I have developed such kind of inventory work books for various clients. Please visit my profile to see my reliability and qualifications. If you are comfortable,I am happy to discuss the project details. I look forward to hearing from you Best regards Priyal
£90 GBP in 3 days
5.0 (192 reviews)
6.7
6.7
User Avatar
HI Fellside. I have developed several Inventory systems in Excel before and I can design one for you as desired. Kindly discuss in detail. Regards. Usman.
£200 GBP in 4 days
5.0 (72 reviews)
6.9
6.9
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
£77 GBP in 3 days
4.9 (115 reviews)
6.2
6.2
User Avatar
Hi, I've 3 years of experience in Excel VBA / Macros. I've worked in complicated projects and with MNC's. I'm able to write this program for you in Excel. Awaiting for your most precious reply. I can get this done in 24 hours from awarding the project. Thank you Karthik :)
£77 GBP in 1 day
4.9 (109 reviews)
5.8
5.8
User Avatar
Hello, I have made such project but for tools (factory on Alaska). I can make this in few days time, and I think you would like final product. Please check my reviews and award me with trust. With regards, Tom
£111 GBP in 3 days
4.9 (34 reviews)
5.3
5.3
User Avatar
Hi Fellside64, I have read your short requirement. Normally when we use Excel to manage stock, we use excel spreadsheet in the database style. This means we will keep all the feeding data will be archive to the bottom of the spreadsheet everytime, but have some flag to indicate the activity (reveive, sales). Then the Ending stock = BF + Rcv - Sell (BF - bring forward qty / Rcv = Receiving qty / Sell = sold qty), then not only the transaction type, we still keep the time log so that we have evident of time for trace & track reference. That is the database part, the in another sheet will be Inventory monitor, here we will put some code to list the product item at the same time calculate the ending inventory. So now about the van (delivery)...this concern to the customer purchase order, we will log this activity at the Po no. (purchase order number not at Item level), but of course we will have the record of all items in each PO. Then we keep tracking from this worksheet. So now we can trace & track and do analysis...(see sales trend, Rcv trend, Inventory Days on hand..etc) on our company actitity. Feel free for further discussion, if you are interested. let me introduce myself a little, I am an excel developer, expert in Excel both excel standard and Vba coding, more than 10 years. You can see more of my profile and expertise in my project feedback in http://www.freelancer.com/users/feedback_2698784.html Kind regards, Pichart Y.
£222 GBP in 3 days
5.0 (40 reviews)
5.5
5.5
User Avatar
Hello ready to start asap to deliver you but I think I need to submit something to you and then you review it, I can also do a free sample to you, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, mathematics, accounting, cost calculating and finance that helps in this project.
£63 GBP in 4 days
4.9 (60 reviews)
5.3
5.3
User Avatar
A proposal has not yet been provided
£84 GBP in 3 days
3.9 (29 reviews)
6.2
6.2
User Avatar
Hi I have 6+ years exp in data processing, formatting and entering in word, excel and powerpoint. Please provide me sample input and output, also please contact me on messenger so that I can start it asap. thank you
£150 GBP in 3 days
4.5 (19 reviews)
4.4
4.4
User Avatar
Having created inventory management systems for other clients, I would be happy to produce a stock management for you. I work from home in the Midlands, so communications will be straightforward. I can do this under a Confidentiality and Non-Disclosure Agreement if required, and start as soon as you pay the fee into the site. I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational. Now work across five freelance sites with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. Would normally provide samples to let you judge my Excel skill for yourself, but you made this a "restricted" project. I can't send you an attachment unless you send me a Private Message first. I have allowed three days to complete the Project, which will enable you to view the work in progress and make any changes you want in that period. Hope you find this of interest and look forward to hearing from you. Bob Allen-Turl
£123 GBP in 3 days
4.6 (11 reviews)
4.5
4.5
User Avatar
Hello I have a great experience in Excel, VBA as well as in accountancy, invernotry management software. I've implemented the HRM software in Excel/VBA for company with 150 employees. Hope to work with you. Cheers Valery
£98 GBP in 3 days
5.0 (9 reviews)
4.0
4.0
User Avatar
Dear Sir, I would like to support the project with the core excel sheet. Maybe we can include also some overview charts that will show the stock per vending machine location. I am a former IBM ops manager and Ingram Quality and Performance manager, so I led a data analysis team. In case you want to award me the project, I am able to start right away and deliver results that you will find very useful. Please let me know if you have any questions. Kind regards Viktor Mihalkov
£99 GBP in 2 days
5.0 (5 reviews)
3.7
3.7
User Avatar
We will be able to complete your task as described. We are a team of 5 people. We are proficient in advance Excel and have completed numerous projects. We use few automated process to complete the project in order to minimize human error. One member of our team does audit of the work done to ensure that the work is as per the requirement and specifications. Based on experience, we have committed a reasonable time, but are confident that we would be able to complete the assignment before reasonable time. As a policy, we keep the client data confidential. We would be able to start the assignment immediately upon confirmation. We are very excited and geared up for the assignment. For clarification on any matter, feel free to contact us.
£55 GBP in 2 days
4.7 (7 reviews)
3.1
3.1
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
5.0 (1 review)
1.6
1.6

About the client

Flag of UNITED KINGDOM
southport, United Kingdom
5.0
2
Member since Mar 23, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.