Need an automated inventory management system in Excel or Google Sheets
Budget: $30 – $250 USD
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.
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.
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.
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.