Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
food cost
i'm opening a restaurant soon , i made the food recipe items and also the
sales projections and product mix, i need an excel sheet that i can input the food recipe i have in able to have the order quantities i need as per the PMIX |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
food cost
Sam,
Lots of variables here and not quite enough information to give you hard answers. The basic answers would seem to involve the use of VLOOKUP() formulas to bring in the ingredients for a product/menu item and simply do some multiplication based on the number of servings the basic recipe makes and how many you want to order for. I may be able to help more if I see the actual workbook you have right now (no, I'm not a competitor and won't sell your recipes, promise!). If you'd like to give it a go, send me an email at (remove spaces) Help From @ JLatham Site.com with the workbook attached to it, and if you can show me what you'd like to see as an end result on a sample sheet, that would be a big help. "Sam" wrote: i'm opening a restaurant soon , i made the food recipe items and also the sales projections and product mix, i need an excel sheet that i can input the food recipe i have in able to have the order quantities i need as per the PMIX |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Food Pyramid | Charts and Charting in Excel | |||
how do i set up inventory for food? | Excel Worksheet Functions | |||
Food Details. | New Users to Excel | |||
Current Cost versus Original Cost | New Users to Excel | |||
Confusion on adding percentage of cost to that cost. | Excel Worksheet Functions |