Looking for an expert in Excel to create a document that will be used to manage inventory for a restaurant. The first page will have a list of supplies that will vary in prices at every purchase. Each other page after that will be on a "per item" based on the menu.
On each menu page will be a list of the ingredients and the cost of each ingredient that you will need to gather and generate based on the food list prices giving us a total cost of the plate. We want the price for supplies on the first page to be hyperlinked to menu items on the other pages so that when we make a purchase of supplies the prices will be updated on all menu pages that use those supplies.
Example (supply page):
Supply Item List - Quantity - Cost
cheese - 5 lb bag - $10.00
tomato sauce - 16.0 oz can - $2.00
flour - 10 lb bag - $5.00
Example (menu page):
Ingredients - Quantity - Cost
cheese - 0.5 lbs (8 oz) - $1.00
tomato sauce - 1.0 oz - $0.13
flour - 1.0 lbs - $0.50
FOOD COST - $1.63
SALE PRICE - $5.00
In theory you will be making 2 pages, the supply page and the menu page. Please make it so that we can just duplicate the menu page so we can keep adding menu items. If you have other ideas on how to do this just let me know. Thank you.