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

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.

Skills: Excel

See more: html email design year end promotion, year end donation letters, year end donation letter, dow dupont merger tax consequences, dowdupont agriculture, dupont stock after merger, dowdupont annual report 2017, dow dupont merger timeline, dowdupont news today, dupont revenue 2016, dow dupont products, best year end donor letter, year end letter non profit, year end donor thank letter, year end non profit donations, non profit year end donor thank, tally accounting year end processing, year end donation non profit, year end contribution letter, year end donor letter

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #17572549

25 freelancers are bidding on average £144 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

£222 GBP in 3 days
(591 Reviews)

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 experien More

£210 GBP in 3 days
(248 Reviews)

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 in 2 days
(249 Reviews)

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 in 7 days
(123 Reviews)

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 in 7 days
(200 Reviews)

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 ca More

£250 GBP in 3 days
(54 Reviews)

"""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 m More

£100 GBP in 3 days
(135 Reviews)

- 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(r More

£150 GBP in 4 days
(44 Reviews)

I would like to discuss little bit more about the project for appropriate duration and cost as well. Please pm me. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 1 More

£20 GBP in 1 day
(57 Reviews)

Hi, I have extensive experience of working on similar data processing projects. I can help to develop a script to merge excel data files and do required comparison to generate a report according the requirements. Pleas More

£250 GBP in 7 days
(8 Reviews)

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, Invest More

£50 GBP in 1 day
(33 Reviews)

i am interested with your project so if you want me then please message me then i will give you quality work. i have previous experience in product entering field.

£38 GBP in 3 days
(37 Reviews)

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 in 1 day
(12 Reviews)

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 in 4 days
(6 Reviews)

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 in 5 days
(3 Reviews)

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 More

£88 GBP in 3 days
(1 Review)

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 in 3 days
(2 Reviews)

Hi there, This is Suresh from India I saw your project - work relating to combining multiple stock data, comparison with software report and outdated stock , etc. I can complete the task in a couple of days for the More

£20 GBP in 2 days
(2 Reviews)

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 in 3 days
(0 Reviews)


£20 GBP in 2 days
(0 Reviews)