Find Jobs
Hire Freelancers

Combined stock to merged production schedules report, and year end stock value report

£20-250 GBP

Закрито
Опублікований over 5 years ago

£20-250 GBP

Оплачується при отриманні
We manufacture and supply lots of decals to JCB and other OEM's. We need to take 12 or so hse production schedule files and merge them in to one excel file showing common part numbers data merged and then arranging the parts in numerical order in a pivot table of up to 2000 part number lines . Subsequently to this we need to do a comparison of the data on the schedule with our stock database file from Sage to create a file that shows us when stocks will run out, and a separate stock year end reconciliation value report, taking in to account rules like zero or negative stocks, and where stock exceeds the 6 month customer forecast on the production schedules so needs capping at this figure. We have existing reports in the formats we are looking to create for the freelancer who does this work.
ID проекту: 17572549

Про проект

22 пропозицій(-ї)
Дистанційний проект
Активність 5 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
22 freelancers are bidding on average £149 GBP for this job
Аватарка користувача
Hello, Hope you are doing well. I can help with you in your project Combined stock to merged production schedules report, and year end stock value report. I can assure you the quality job. I have good experience in Excel. We have worked on several similar projects before! We have worked on 385+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
£210 GBP за 3 дні(-в)
4,9 (507 відгуки(-ів))
8,4
8,4
Аватарка користувача
Hi, I develop inventory modules in Microsoft Excel by VBA. I built modules which enable you to manage inventory transactions and Bill Of Materials in a spreadsheet and to get immediate reports and info. The modules can upload external databases. The modules show the transactions on user-form with a possibility to review and update them. There is a search engine with high search capability to find a specific record (or group of records). During the process, Excel validates the information and prepares reports and documents based on the needed parameters and criteria. There is a report generator which enables you to develop templates independently. And more, the files are secured by username login and password. About Me: I am a financial expert and a guru in Excel and VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I develop financial modules including business valuation methodology & ratios.
£250 GBP за 3 дні(-в)
4,9 (93 відгуки(-ів))
7,5
7,5
Аватарка користувача
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
£250 GBP за 7 дні(-в)
5,0 (323 відгуки(-ів))
7,4
7,4
Аватарка користувача
Hi, I'd be happy to help you with this project. Let me know if you have any question. Looking forward to hearing from you.
£225 GBP за 2 дні(-в)
4,9 (251 відгуки(-ів))
7,7
7,7
Аватарка користувача
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
£100 GBP за 3 дні(-в)
4,9 (266 відгуки(-ів))
7,1
7,1
Аватарка користувача
I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel to prepare Budgeting, Costing Analysis, Financial Analysis, Financial Modeling, Data Analysis, Investment Calculator, Break-even Analysis, Production Schedules and Plans. I will be happy to discuss in detail regarding my qualification and experience and how I am highly suitable for this project.
£50 GBP за 1 день
4,8 (209 відгуки(-ів))
7,2
7,2
Аватарка користувача
Hello, I will merge 12 production schedule files into one excel file, create year end stock value report. Let's discuss more details in chat if you're interested. Best regards, Hoang
£150 GBP за 7 дні(-в)
5,0 (162 відгуки(-ів))
7,1
7,1
Аватарка користувача
Hello, I am an experienced Data Analyst with advanced excel skills. I can do your job really fast and i assure you that you will be pleased with the outcome. Please check my portfolio to see my work. Thanks!
£150 GBP за 4 дні(-в)
4,9 (61 відгуки(-ів))
6,7
6,7
Аватарка користувача
- Can get the 12 Production schedule files and have them merged then identify the common part numbers and showing up the 2000Part lines. - Based on the Parts and the Existing Stock File (from Sage) do the comparison(reconcilation) report. - Set a reorder or stock level and identify those that will be outof stock or nearing the Reorder level. - Can generate reports using button clicks. - Have done similar inventory, stock reordering, capping, reporting. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
£150 GBP за 4 дні(-в)
4,7 (49 відгуки(-ів))
6,1
6,1
Аватарка користувача
Hello! I'm highly interested. I read carefully this Project Description. I can do this. Trust me! I will do for you an accurate service. send me message please...!!
£150 GBP за 1 день
4,7 (26 відгуки(-ів))
5,3
5,3
Аватарка користувача
Dear Sir, I would like to involve with your project and i have sound knowledge with excel and its functions. I will guarantee to deliver your intended result. Please contact me. Thank You
£80 GBP за 5 дні(-в)
5,0 (4 відгуки(-ів))
2,9
2,9
Аватарка користувача
greetings,,your project caught my attention we can cooperate together that i know EXCEL from A to Z ALSO have very good experience as a data entry i will provide you with accurate work within short duration u can trust me and will be satisfied..............regards
£88 GBP за 3 дні(-в)
5,0 (1 відгук)
0,8
0,8
Аватарка користувача
i am Proficient in MS-Excel, MS-Word, Web Research, Data Entry, PDF to Word/Excel Conversions etc Expert in making business presentations, web research, business research.
£150 GBP за 3 дні(-в)
5,0 (2 відгуки(-ів))
0,5
0,5
Аватарка користувача
Excellent experience in the Computer field in the following Applications: - Windows Operating systems. - Office package (Excel – Word – Access) - PC accumulation & Maintenance - Internet Good knowledge of the network system and dealing with hardware Good knowledge of dealing with search and data gathering using the tools of internet
£55 GBP за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
.....................................................................................................
£20 GBP за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hello Sir, I Just gone threw your project description, I am a IT professional I could help you in completing this project, Also I can meet your expectations.
£250 GBP за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I am an experienced Excel trainer from basic to advanced. I also have 45 years experience in the accounting field. I have worked in both the manufacturing environment as well as 23 years in a company with high stock volumes. I am sure I can assist with this project.
£194 GBP за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hands on experience in Advance Excel since last 10 years. Know actual business processes. Handled practical critical job situations at work. Timely reporting to the employer. Job completed as per the requirements on the Employer.
£110 GBP за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I have over 20 years experience in administration using Office products and corporate software packages. Responsibilities have included data validation, report writing, database definition, spreadsheet modelling. I would appreciate being considered for this project.
£150 GBP за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED KINGDOM
United Kingdom
0,0
0
На сайті з серп. 14, 2018

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.