Ditutup

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.

Kemahiran: Pengurusan Inventori, Excel, Pemprosesan Data, Pemasukan Data, Carta Aliran

Tentang Klien:
( 7 ulasan ) istanbul, Turkey

ID Projek: #33710079

37 pekerja bebas membida secara purata $181 untuk pekerjaan ini

(274 Ulasan)
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 Lagi

$150 USD dalam 7 hari
(120 Ulasan)
6.5
(63 Ulasan)
6.3
(40 Ulasan)
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 Lagi

$250 USD dalam 4 hari
(30 Ulasan)
4.9
(6 Ulasan)
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] Lagi

$140 USD dalam 2 hari
(8 Ulasan)
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 dalam 2 hari
(2 Ulasan)
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 Lagi

$165 USD dalam 2 hari
(1 Ulasan)
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 dalam 2 hari
(3 Ulasan)
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 Lagi

$100 USD dalam 4 hari
(2 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lagi

$100 USD dalam 3 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lagi

$250 USD dalam 15 hari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0