Creating Food Inventory Master for an ERP project

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I have a list of all items purchased from a major supplier to our 10 Food Outlets for past 12 months. At present, we have a basic inventory system that does not have accurate / proper inventory items in it's master data.

I would like help from some one who would be familiar on Restaurant Operations to;

1) Review the items in the attachment

2) Come up with a "Generic Food Inventory Item List", that could be used for ordering and recipe costing and link such generic inventory items to attached supplier inventory items (I do not want to create all the supplier items as Inventory Codes in my ERP system).

Eg. Supplier will have 3 different Bread types, say white / wholemeal / white soft, where as in ERP I would like to have one inventory item called "Bread" and all 3 types of Supplier Items above can be linked. This will reduced the number of inventory items in ERP as the price variance would be minimal

3) The Unit of Measurements also need to be rationalized. In ERP, it should be ideally Kgs, Ltrs, each and each supplier items shall be then logically linked using the packaging. I am open to any better ideas or suggestions based on your experience

4) Once the Item Master created for ERP per above 2, I need to have an identifier against each item which Restaurant would be using them, based on the Customer Name in the attachment

Knowledge of the food and restaurant industry is beneficial, if you have such knowledge please indicate so.

Excel Excel VBA

Project ID: #16870999

About the project

19 proposals Remote project Active 6 years ago

Awarded to:

zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this as I have experience in restaurant industry ! I can start More

$705 AUD in 5 days
(151 Reviews)
7.7

19 freelancers are bidding on average $614 for this job

schoudhary1553

Hello, I can help with you in your project Creating Food Inventory Master for an ERP project . I have more than 5 years of experience in ERP, Software Architecture. . We have worked on several similar projects befor More

$800 AUD in 10 days
(421 Reviews)
8.3
editchamp

Hey There !! I am proud to say , I have vast knowledge on restaurant menu and meal as I have worked before. I have worked several restaurant system to set up menu and inventory . So I would be best for this scope More

$588 AUD in 10 days
(173 Reviews)
7.1
satishtl

- Have experience in Peoplesoft ERP and have worked have managed on AP, PO & AM systems. - Also from Excel view point have good expertise in macros and VBA and have done complex solutions using Excel. - Went throug More

$500 AUD in 5 days
(49 Reviews)
6.1
TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W More

$588 AUD in 10 days
(2 Reviews)
4.9
dionisiotumbaga

Hi, I am interested in this project. I can design and create MS Access Database that will serve as an ERP. Database will generate forms and reports in accordance with the functionalities indicated in the project spec More

$300 AUD in 5 days
(6 Reviews)
4.7
cr8tivewebexpert

Greetings, We have reviewed your requirement for creating Food Inventory Master for the ERP. We have got highly experienced Database Analyst/Administrator so we will review it and rationalized it at highest level More

$823 AUD in 8 days
(3 Reviews)
4.8
techcristaglobal

Hello i have strong experience in application development and design. i have gone through your requirement. i have would like to discuss more in details regarding the same. Please let me know further.

$1588 AUD in 10 days
(1 Review)
4.8
hjabeen972

After reviewing your attached excel sheet i am quite sure i can build that inventory software for you very easily within your budget and deadline .. you can have a look my profile feedbacks i am expert in development. More

$405 AUD in 7 days
(1 Review)
3.9
arzooshaikh

Hi client, see my portfolio for for more PHP project information. I am PHP developer having 6 years of experience in software development. please start your discussion with me. thanks.

$555 AUD in 20 days
(1 Review)
2.1
smrutimodi

Hiiiiiiiiiiii i have gone through your proposal.i do ms word and excel .Thanks

$251 AUD in 5 days
(0 Reviews)
0.0
qs1516

Discuss me on whatsapp 00923348008045

$555 AUD in 10 days
(0 Reviews)
0.0
karthik05star

I’m interested with your project. I’m already expected on this field. Please send me a message so that we can discuss more.

$250 AUD in 3 days
(0 Reviews)
0.0
Altafbabu34

I have to interest in working with you. and i really need for work & job. I want to build my career. I can work hard and always finish the job before deadline. And I am a fast, responsible and honest worker. I alwa More

$500 AUD in 12 days
(0 Reviews)
0.0