Inventory Order Tracking Managment Excel Workbook
$10-30 CAD
S-au achitat serviciile după ce au fost prestate
I am in need of an Inventory Order Tracking Management Excel Workbook Template which i can develope. Currently, I have a manual system in place that I am looking to Redesign. Specifically, I need better organization and accessibility for my inventory and order tracking.
The ideal candidate will have experience creating Excel sheets using pi ot tables and advanced excel formulas (Mix of: Vlookup, Index, Mach, etc..) that automate processes and improve my data analysis. The workbook should include order details (location, quantities, status). Some additional features that would be helpful include the ability to track track the order live if possible.
Here is a brief of the how the process curently is;
Starts- Orders are listed in priority orders from most important first and we work accordingly
Bending & Folding Stage
1- Order is started when a Reskin is created for an order from top of list downwards (Identified by number of boxes - this info can be extracted)
Picking and Kanban Stage
2- Then Picking process starts:
a) I will need to order the reskin (usualy from other warehouse locations to main warehouse)
b) I will start picking from two warehouses which are then shipped to main warehouse when completed
c) all orders should be identified as (No Missing peices, and how many total boxes - Reskin + picking)
Note: all orders will end up in main warehouse and they will either be completed orders or missing items to be completed
Paint Stage
3- Once order is completed and have no missing peices they are moved to paint racks
4- Paint checks if all parts have been picked (quality check)
5- Once paint is completed the order is “Ready to Ship”
Transportation
Ready to ship completed orders wait for dispatch
Other
- My main aim of the sheet is to know exactly where my multiple boxes for any order are placed (they are not placed together and are distributed in the warehouse)
- know how many total boxes i have once order is completed
- know when i receive my reskin (and how many boxes) and how when i receive my picking from other warehouses (and how many boxes) with their exact locations
NEEDED SHEETS:
1- SHEET1: Daily order location Scans (Here i will scan daily where every box physicaly is in my
Main warehouse
2- SHEET2: Dashboard to Display all my orders and tell me how many total boxes and their locations and their status (extractable)
3- SHEET3: Identify boxes i need to order weekly to align with my initial list! (I have to get the boxes all to main warehouse to give to paint all together)
4- SHEET4: intigrate existing data into my template (missing parts declared sheet, order list by priority, order status sheet)
ID Proiect: #36699349
Detalii despre proiect
40 freelanceri licitează în medie 40$ pentru acest proiect
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Mai multe
Hello there! My name is Akriti and I am an Excel VBA programmer with more than 5 years of experience. I understand that you are looking for an Inventory Order Tracking Management Excel Workbook Template that can be dev Mai multe
Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from Mai multe
Hi, I have gone through the Job details and am interested in taking it up. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and mac Mai multe
I am a planning and cost control department section head in one of the leading companies in the middle east. Professional of creating reports and data analysis regarding projects such as Sales &Cost & Management & Plan Mai multe
I Have 4+ Years Of Experience In Microsoft Excel And I will Create an Advanced Level Stock Inventory Management System That Will Do Automate Your Business Work And Calculation. My Services. Stock Inventory Management Mai multe
Hello! I am the right person to help you complete this project. I am a professional|expert in Software Architecture, Visual Basic, Supply Chain and Excel. My years of experience dealing with related projects to yours Mai multe
I understand exactly what you're looking for in an Inventory Order Tracking Management Excel Workbook Template - better organization and accessibility for your inventory and order tracking. With my experience in softwa Mai multe
(((I'm available to start right now))) ----Efficient and specialized Excel expert at your service---- I understand that you currently have a manual system in place that you're looking to redesign. My goal is to prov Mai multe
I understand from your description that you are looking for an Inventory Order Tracking Management Excel Workbook Template which you would like me to develop. Specifically, you need better organization and accessibilit Mai multe
Dear Sir/Madam - I am the best freelancer for your job. Choose me and I will deliver immediately. I am a hard-working and driven individual who isn't afraid to face a challenge. I'm passionate about my work and I know Mai multe
Hi there! I am Md. Akibul, a freelancer with extensive experience in Excel and Visual Basic. I understand your need for an Inventory Order Tracking Management Excel Workbook Template and am ready to help you redesign y Mai multe
Greetings, I am an ACCA member and have more than 10 years of experience in professional consultancy regarding Microsoft Excel/ Spreadsheets. I am an expert in formulating scenarios, logic, and criteria outputs based Mai multe
Hi, I am certified in advanced Excel, data analytics, and Dashboards from Macquarie University, Australia. I have a lot of experience in databases, data analysis, Excel Charts & Graphs. I am an Accountant and I have o Mai multe
✍️✍️I can do it perfectly ✍️✍️ I have all of these skills Excel, Data Processing, Data Entry, and I did like it many times just please have a look on my profile and check please ping me back ......... Thanks ! Best Reg Mai multe
Hi there! My name is Pomarides, and I am an IT Consultant with 14 years of experience in Web and Windows software development, strong knowledge in database with special emphasis on the .Net, PLSQL, T-SQL, PHP and Java Mai multe
Hi hiring Manager! I've checked your requirements and it fits perfectly to my skills. I have work experience in a distribution center warehouse, I know the process from the reception of the merchandise, its location sy Mai multe
I will find the online work ....i am hard working person and my accuracy 90%... So please give me this work ...???
Hello! I am NUR SYAZWANI, a highly experienced Excel expert who can help you with your project. I understand your need for an Inventory Order Tracking Management Excel Workbook Template that can be developed. Specifica Mai multe
I am an experienced IT professional with 8 years of expertise and the necessary skills to develop an Inventory Order Tracking Management Excel Workbook Template. I understand your requirements for better organization, Mai multe
