Looking for an excel /Android app to be created for ordering food perishables in a fast food restaurant.
Process flow as follows:
1. Enter 'date': ddmmyy (max 7 dates)
2. Enter number of persons:
3. Enter number of staff:
4. Select 'time of day' for each date from droplist: breakfast, lunch, tea, dinner, snacks
5. Select any 4 'recipes' from droplist for each time of day:
Prepopulated list of recipes
Calculate and show report
Vlookup: 'ingredients' and 'quantities' for each recipe, for 1 person
Vlookup: max 3 'supplier names' for each ingredient
Sheet 1: aggregate Ingredient-wise total
(quantity) x (number of persons + staff) for all dates selected. Show all 3 supplier names for each ingredient.
Sheet 2: Recipes selected by date, time of day, for number of persons
22 freelancers are bidding on average £27 for this job
I work in the restaurant industry as well and think this would be easy to make for you. Go ahead and contact me and we can work out some of the details. Thanks and have a good day.
I am professional in MS excel, word, SAP, ERP, ORACLE, SPREED SHEET, PIVOT SHEET, ETC also experience in supply chain management, I have completed different project in excel, word etc. Regards Asif Mirza