Confused with calculating ingredient consumption

Hi guys, thanks for any help you can offer.

I'm in charge of reception for a restaurant and was looking to create a tool that would aid order planning by calculating ingredient consumption based on sales data.

I was messing around with the following test case to see how it would work. Basically what I want to do is find out how much of each ingredient I use on a weekly basis.

Here are my ingredients listed by dish and quantity:

1.PNG

My dishes and their weekly sales:

2.PNG

I establish a relationship between the two tables, linking them by name of dish.

I create a Pivot Table based on this data model.

5.PNG

But it does this weird summing thing with the sales data, so that it's unusable:

6.PNG

7.PNG

Any idea what's going on? I would ideally like to multiply sales per dish by ingredient quantity, but I can't do that if the Pivot Table sums all the sales data and doesn't let me see sales per dish.

All help is much appreciated.

Cheers!

Sorry, just read the thing about attaching a workbook and not photos. Here it is:Book1.xlsx

One way is to extend columns for the Ingredient in Sales table and use this formula:
I3=SUMIFS(Ingredients[Quantity],Ingredients[Name of dish],[@[Name of dish]],Ingredients[Ingredient],I$2)*[@[Weekly sales]], copy down and across.