Inventory Allocation Report

I would like to have an excel report:

This will be used to make decision about moving inventory from one company between it's plants, based on historically usages (weekly basis),and on hands inventory, which plant will be the best to pull the inventory from based on lower and higher user and based on inventory on hands, also region on the plant.

Information will be pulled from ERP system, usage will be input in weekly or monthly basis, inventory will be pulled from sap and injected to the spreadsheet.

I would like to have a cover page where you can make the input of the material number, and with a click of a button will display the best option based on:

inventory on hands (based on historical usage) and region where it's being pulled

Taidot: Excel, Varastonhallinta, Microsoft Access, Visual Basic

Näytä lisää: inventory allocation excel, ERP SAP, sap erp, Excel report, excel inventory, usage spreadsheet, sap usage, report sap, excel monthly inventory, excel spreadsheet inventory system, sap weekly report, option report, excel based decision, excel inventory input, excel monthly report, allocation spreadsheet, excel inventory spreadsheet, moving excel, report cover page, basic page report

Tietoa työnantajasta:
( 0 arvostelua ) Irving, United States

Projektin tunnus: #6091644

Myönnetty käyttäjälle:


Hi, I placed in my portfolio a screen from a similar report I created from data coming from MAS200. The portfolio is called Purchasing Dashboards. I have been an Access programmer for the last 18 years in New Jersey Lisää

$71 USD 1 päivässä
(6 Arvostelua)

17 freelanceria on tarjonnut keskimäärin 69$ tähän työhön


Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Lisää

$98 USD 2 päivässä
(194 arvostelua)

hey there, are you using WINDOWS or MAC ? Please share the excel sheet that you have. Please reply and we can discuss further, thank you !

$35 USD 1 päivässä
(201 arvostelua)

Hi, I've got extensive experience in development of MS Access databases and attached VBA modules, for the UK sites of one of top logistics enterprises worldwide. The modules parsed reports downloaded on a schedul Lisää

$100 USD 5 päivässä
(39 arvostelua)

Hi, I can help you with your requirement. I have closed more than 150 excel related projects. Can assure you quality in given time. Regards Sawan

$24 USD 1 päivässä
(30 arvostelua)

Hi, This is Amit from India. Expert in excel [login to view URL] have executed multiple projects in Excel before. Looking forward to talk to you soon, Thanks, Amit

$60 USD 1 päivässä
(8 arvostelua)

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft Excel datab Lisää

$34 USD 3 päivässä
(15 arvostelua)

Hi, I have gone through your descriptions,I am 5+ years experienced VB.NET,ASP.NET,MS Access,SQL,SQL Server developer at CMMI-5 level company.I can do your job easily before your deadline . Please confirm me with who Lisää

$100 USD 3 päivässä
(12 arvostelua)

Update, I reviewed the spreadsheet you posted. I have completed projects like this in the past. I can send you a current working sample if you want to review. I do freelance work on the side, but in my full time jo Lisää

$100 USD 7 päivässä
(4 arvostelua)

Sir/Madam, Greetings. This is an IT person and an experienced Access database developer .I have good expertise in MS access VBA as well as Access macros , queries and expressions.I have had read the given descri Lisää

$100 USD 3 päivässä
(10 arvostelua)

I can make this excel report. Regards, *************************************************************************************************************************************************************************** Lisää

$30 USD 2 päivässä
(2 arvostelua)

I had done such projects at beginning of my career (inclucing some complicated projects where we did sub classing/superclassing and used windows API's to read/write serial port etc).

$166 USD 1 päivässä
(1 arvostelu)

hi, I am submitting herewith my proposal for your perusal and favorable consideration for the said project I would appreciate the chance to discuss with you as to how I could be a vital part of your posted project Lisää

$25 USD 1 päivässä
(1 arvostelu)

I am a well trained business facilitator, I have written so many business plans and different kind of articles, and I possess technical classified trading experience. I will perfectly handle your required articles with Lisää

$25 USD 1 päivässä
(0 arvostelua)

Technical writing, PhD Thesis, Dissertations, proof reading, project management, supply chain management, operations management, occupational health and safety management, strategic management, purchasing, inventory m Lisää

$100 USD 5 päivässä
(1 arvostelu)


$25 USD 3 päivässä
(0 arvostelua)

I am currently working as inventory controller job. i have good experience in that, so that i will do this better then other and this is my first online task. you have to trust on me.

$88 USD 1 päivässä
(0 arvostelua)