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:
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.
37 freelancers are bidding on average $181 for this job
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.
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
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.
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