Закрыт

Need an automated inventory management system in Excel or Google Sheets

We need an online inventory management system in Excel or in Google sheet to see the general picture in the movement of food ingredients between our warehouses, bakeries and to generate reports on the balance of available food items at each point. We are running more than 20 bakeries that are located separately in multiple locations. Our bakeries supply baked breads to about 300 customers daily. We have about 5 warehouses that we store bakery ingredients i.e. flour, walnuts, raisons, sugar and oil.

We bulk purchase food ingredients and store them in our warehouses. Based on the requirement, we deliver food ingredients form our warehouses to our bakery storages. Food ingredients from our bakery storages are then used to bake fresh bread and deliver them to our list of customers that reach about 300 clients. each bread is baked with specific amount of ingredients. The amount of food ingredient in each bread is fixed. We need an automated excel workbook to record everything and to generate reports of general types.

Based on the number of breads supplied daily from our bakeries, the excel sheet should show how much of food ingredients are consumed at the bakery level based on on the bread quantity baked and distributed at each day. We should be able to see the available balance of remained food items at the bakery storage. System should also record the movement of quantity of food items between our warehouses and bakery storages. Excel workbook should also show the related data in terms of charts and graphics.

Food ingredient per bread:

Flour 160gr

Walnuts 7gr

Raisins 8gr

Sugar 10gr

We need the inventory management system to be live (online). You may create it as Excel online or in Google Sheets. But it should cover all features above. Company staff from different locations shall input data into it. i.e. warehouse managers, bakery manager and others.

Period to complete this project is 2 days after award date.

Besides creating such system, freelancer shall agree to provide 1 month of free maintenance. This period will be used to maintain and further improve template deficiencies & flaws that will arise during using of the system. 30% of freelancers fees will be held for a period of 1 month for this purpose and will be released after one month after completion of the project.

Навыки: Складской учет, Excel, Обработка данных, Ввод данных, Блок-схемы

О клиенте:
( 7 отзыв(-а, -ов) ) istanbul, Turkey

ID проекта: #33710079

37 фрилансеров(-а) готовы выполнить эту работу в среднем за $181

(274 отзывов(-а))
7.0
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including automation of warehou Больше

$150 USD за 7 дней(-я)
(120 отзывов(-а))
6.5
(63 отзывов(-а))
6.3
(40 отзывов(-а))
5.5
rameshraja86

Hi There, I have understood the requirement to develop Inventory Management System. I have done similar Project for Warehouse management, Inventory Management with following features 1. Inward Entry, 2. Consumption or Больше

$250 USD за 4 дней(-я)
(30 отзывов(-а))
4.9
(6 отзывов(-а))
4.5
sharmapritam311

Hi there , I am expert in building web apps that integrates with Google Sheet. I am attaching you demo. Please check it out. It's just for seeing the way how thing works: [login to view URL] Больше

$140 USD за 2 дней(-я)
(8 отзывов(-а))
2.8
xixdia

Hi, I can help you and start today. I have more than 10 years experience as Supply Chain Analyst and Excel expert. I am used to work with forecast, inventory, multi warehouse.

$200 USD за 2 дней(-я)
(2 отзывов(-а))
2.5
farizaneeq12

Hello I am a mechanical engineer having over 3 years of experience in inventory management, excel sheet automation, VBA and with my experience, I assure you that I can do your inventory management of Bakery in Excel. I Больше

$165 USD за 2 дней(-я)
(1 отзыв)
2.1
Nosratabouhamzeh

Hi dear sir/madam, I'm very active and interested to work with you. My time is up to you. I have many experiences in this case and you could award your project to me and enjoy it. With best regards

$200 USD за 2 дней(-я)
(3 отзывов(-а))
1.7
MostafaMansour1

I'm ready to start immediately, i am so good with excel formulas and graphs, so i'm sure that you will get best value for money, just contact me and let's build this excel sheet step by step, and of course you will ge Больше

$100 USD за 4 дней(-я)
(2 отзывов(-а))
0.8
rajsingh483050

Hi John, I will summarize all the lectures and provide you with clear, concise notes. I am a Ph.D. writer with 5 years of experience. I’ve worked on several similar projects compiling presentation slides and lecture no Больше

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
bradleykurt

I am very familiar with inventory systems, I made systems like this already. Kindly check my profile to see if im suited for the job. Just drop me a message if you think so.

$100 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
veronikairawati

I am fast in doing things, thorough and hardworking. I am also used to working using excel, ms word for 3 years working as an insurance administration

$250 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
sobansoban49

HI I AM SADAQAT ALI I CA PROVIDE SERVICE TO YOU AS A DATA ENTRY ASSISTAINT .I CAN CREATE DATA FROM PICTURE OF FOOD ITEM .I AM EXPORTIN THIS WORK .I CAN PROVIDE FROFECT SERVICE TO YOU IN INVENTRY INCLUDE WITH ITEM GRA Больше

$100 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
Shankarrajput663

I am honest and certified Data entry operator . I have experience of this work. I work hard that makes different.

$50 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
kathiresan11

Hi, Hope all well, I'll be able to complete your work in time without making any error, I have more experience of this working.

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
qqsd

Sir I understand your work very well I will do your work 100% I have very good knowledge of Excel

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
Matiyas29

We are a team ERPNext Developer, Implementer Web Designing ,Web Development Logo, Web Services ,Content Writing, Responsive Design React, Web Development, Android Apps Development, iOS Apps Development, UX/UI Developme Больше

$250 USD за 15 дней(-я)
(0 отзывов(-а))
0.0
ansaralijutt7022

Yes sir I will do this job for you in a very good way. I will show you how to do this job in a very short time. Please give me a chance.

$140 USD за 2 дней(-я)
(0 отзывов(-а))
0.0