I've been cooking for many years, but recently took on my first executive chef position. I'm fairly proficient with computers, but not on the level where I can create my own Excel Spreadsheets and actually have them be helpful. I was wondering if anyone out there has spreadsheets they would like to share. I'm looking for the basic stuff: Ordering, scheduling, inventory, food cost, etc. Versatile templates would be very helpful to me, as my menu will change frequently therefore creating the need to edit the forms often. Over the years, I used great spreadsheets at other jobs, and am wishing right now I had kept copies to use in the future. Oh well...
Hi David, I may be able to help. I've been in restaurants for 20 years now - the last half in training & development and I've done a fair share of building Excel documents for what you've listed. My only challenge is that I'm in the middle of relocating right now and don't have access to all my archived files. Maybe we can touch base at the beginning of the week and go from there - I may be able to remake some quickly for your use. - Jeff Portwood, jeffportwood@raisingcanes.com, (225) 246-7285.
There are menu costing programs with recipe development integrated into the software -- and some of them are fairly inexpensive. They can also provide nutritional information. CALCMENU is one that comes to mind -- it costs around 300 bucks.
Hi,
Excel has many limitations. Try and buy a software. I would recommend www.resortsoftware.com . They have series of software and they are not expensive. You can do menu engineering, prepare makrket lists etc. You get a 30 day trial. I have one.
Finally, I would recommened a restaurant must have its own ineventory / material management system which is linked to its POS.