Spreadsheet: 793286d1661392467-sum-across-multiple-sheets-dsc-order-summary
Sheet: Ingredient Cost

Supplier | Ingredient | Units measured in | Quantity for price | Cost per measurement ($/measurement) | Category 1 | Category 2 | Conversions / Notes
ARZ | [NAME] | ml | 1000 | 11 | Pantry Staple
 | milk | ml | 1000 | 2.25 | Dairy
ARZ | ricotta cheese | gm | 1000 | 5
 | cream | ml | 1000 | 4.4 | Dairy
 | buttermilk | ml | 1000 | 5
 | lactose free cream | ml | 1000 | 10
 | lactose free milk | ml | 1000 | 2
ARZ | Hoi sin sauce | ml | 1000 | 12
ARZ | sweet chilli sauce | ml | 1000 | 5.5
ARZ | soy sauce | ml | 1000 | 3.8 | Condiment
ARZ | light soy sauce | ml | 1000 | 5.7
ARZ | worcestershire sauce | ml | 1000 | 8
 | chicken stock | ml | 1000 | 1.9
 | cider vinegar | ml | 1000 | 2.7
 | white vinegar | ml | 1000 | 0.6
 | rice wine vinegar | ml | 1000 | 10
 | sweet chilli | ml | 1000 | 4 | Condiment
 | tomato sauce | ml | 1000 | 2 | Condiment
associated | salsa | ml | 1000 | 6.2 | Condiment
 | BBQ sauce | ml | 1000 | 3 | Condiment
 | fish sauce | ml | 1000 | 5.3
 | oyster sauce | ml | 1000 | 9.5
 | lemon juice | ml | 1000 | 4 | Condiment
 | lime juice | ml | 1000 | 4
 | maple syrup | ml | 1000 | 6.7 | Condiment
 | golden syrup | ml | 1000 | 7.8 | Condiment
 | honey | ml | 1000 | 11.7 | Condiment
 | desicated coconut | gm | 1000 | 7.25
 | coconut cream | ml | 1000 | 3.8
 | coconut milk | ml | 1000 | 3.8
 | Chocolate  topping | ml | 1000 | 3 | Condiment
 | [NAME] topping | ml | 1000 | 3 | Condiment
 | caramel topping | ml | 1000 | 3 | Condiment
 | sweetened cond milk | ml | 1000 | 4 | Dairy
 | canola oil | ml | 1000 | 2.2
 | vegetable oil | ml | 1000 | 2.2
 | olive oil | ml | 1000 | 6
 | sesame oil | ml | 1000 | 27
 | peanut oil | ml | 1000 | 7
ARZ | deep frying oil | ml | 1000 | 4.4
 |  |  | 1000 | 5
ARZ | baking powder | gm | 1000 | 12.3 | Pantry Staple
ARZ | [NAME] | gm | 1000 | 12.6 | Pantry Staple
ARZ | icing Sugar | gm | 1000 | 3.8 | Sugar
ARZ | caster Sugar | gm | 1000 | 2 | Sugar
 | white Sugar | gm | 1000 | 1 | Sugar
 | brown Sugar | gm | 1000 | 2.8 | Sugar
 | cocoa powder | gm | 1000 | 10.7 | Pantry Staple
ARZ | milk Chocolate chips | gm | 1000 | 10 | Chocolate
ARZ | white chocolate chips | gm | 1000 | 7 | Chocolate
ARZ | dark Chocolate chips | gm | 1000 | 10 | Chocolate
ARZ | SR Flour | gm | 1000 | 0.75 | [NAME]
ARZ | corn [NAME] | gm | 1000 | 5 | [NAME]
ARZ | plain [NAME] | gm | 1000 | 0.75 | [NAME] |  | 1 cup = 0.150 kg, 1 tbsp = 0.015 kg
 | gluten free SR Flour | gm | 1000 | 7.5 | speciality item
 | gluten free plain flour | gm | 1000 | 7.5 | speciality item
 | gluten free pasta | gm | 1000 | 17 | speciality item
ARZ | sour cream | gm | 1000 | 3.9 | Dairy
 | yoghurt | gm | 1000 | 4.2 | Dairy
 | bocconcini | gm | 1000 | 25
ARZ | grated cheese | gm | 1000 | 6.8 | Dairy
ARZ | grated parmesan cheese | gm | 1000 | 6.8 | Dairy | Low lactose
ARZ | grated mozzarella cheese | gm | 1000 | 8.5
 | parmesan cheese block | gm | 1000 | 27.5
 | ice cream | gm | 1000 | 2
 | cream cheese | gm | 1000 | 17.6
ARZ | Butter | gm | 1000 | 7.2 | Dairy | Low lactose
ARZ | unsalted butter | gm | 1000 | 7.2
 | lactose free cheese | gm | 1000 | 23.12
 | lactose free yoghurt | gm | 1000 | 10.5
 | tofu | gm | 1000 | 13
 | polenta | gm | 1000 | 5.6
 | breadcrumbs | gm | 1000 | 3.1 | Breads
 | [NAME] | gm | 1000 | 2.9
 | [NAME] | gm | 1000 | 9.2
 | rolled oats | gm | 1000 | 1.4 | Cereal
 | coconut | gm | 1000 | 6.4
 | corn flakes | gm | 1000 | 3.6 | Cereal
 | rice bubbles | gm | 1000 | 3.6 | Cereal
 | apricot halves tinned | gm | 1000 | 2.4
 | macadamia nuts | gm | 1000 | 33.98
 | yeast | gm | 1000 | 5.7
 | instant chocolate mousse | gm | 1000 | 19
 | cocoa pops | gm | 1000 | 7.7 | Cereal
ARZ | salt | gm | 1000 | 3.2 | Spices
ARZ | pepper | gm | 1000 | 25.1 | Spices
ARZ | ginger | gm | 1000 | 3.8 | Spices
ARZ | cumin | gm | 1000 | 13.8 | Spices
ARZ | ground coriander | gm | 1000 | 14.4 | Spices
ARZ | beef stock powder | gm | 1000 | 15
ARZ | cinnamon | gm | 1000 | 10 | Spices
ARZ | paprika | gm | 1000 | 11 | Spices
ARZ | tumeric | gm | 1000 | 14.2 | Spices
ARZ | mixed herbs | gm | 1000 | 17.6 | Spices
ARZ | [NAME] | gm | 1000 | 10
ARZ | onion powder | gm | 1000 | 20
ARZ | sesame seeds | gm | 1000 | 16
ARZ | cayenne | gm | 1000 | 18.2
ARZ | [NAME] | gm | 1000 | 18
ARZ | chilli flakes | gm | 1000 | 18
ARZ | thyme | gm | 1000 | 15
ARZ | oregano | gm | 1000 | 20
ARZ | green curry paste | gm | 1000 | 15.2
ARZ | minced garlic | gm | 1000 | 5
ARZ | minced ginger | gm | 1000 | 5
 | tomato paste | gm | 1000 | 2.6 | Condiment
 | crushed tomato | gm | 1000 | 3
 | tzatziki | gm | 1000 | 9.5
associated | [NAME] | gm | 1000 | 7.8
associated | mayo | gm | 1000 | 9 | Condiment
 | wholegrain mustard | gm | 1000 | 13
 | [NAME] | gm | 1000 | 13 | Condiment
 | tamarind paste | gm | 1000 | 23.6
ARZ | [NAME] | gm | 1000 | 4
ARZ | [NAME] | gm | 1000 | 4
 | creamed corn | gm | 1000 | 2.3 | Vegetables
ARZ | passionfruit pulp | gm | 800 | 3.71
 | pineapple | gm | 1000 | 2.7 | Fruit
 | chickpeas | gm | 1000 | 1.9
 | kidney beans | gm | 1000 | 1.88 | Legumes
 | crushed pineapple | gm | 1000 | 5.09
 | dried apricots | gm | 1000 | 10 | Fruit
 | sprinkles | gm | 1000 | 23
 | 100 & 1000's | gm | 1000 | 13
associated | mini marshmallows | gm | 1000 | 10
 | dried cranberries | gm | 1000 | 14
 | sultanas | gm | 1000 | 5.6 | Fruit
 | macaroni | gm | 1000 | 2
 | sushi rice | gm | 1000 | 4.7
 | rice stick noodles | gm | 1000 | 7.5
 | fried noodles | gm | 1000 | 10.3
 | stir fry noodles | gm | 1000 | 7.6
 | cooked rice | gm | 1000 | 3
 | arborio rice | gm | 1000 | 3
 | long grain rice | gm | 1000 | 3
 | corn chips | gm | 1000 | 10
 | dates | gm | 1000 | 3.6
 | frozen corn | gm | 1000 | 2.7 | Vegetables
 | frozen peas | gm | 1000 | 2.2 | Vegetables
associated | frozen blueberries | gm | 1000 | 9.3 | Fruit
 | sausage mince | gm | 1000 | 8 | Meat
 | pork mince | gm | 1000 | 11
 | lamb mince | gm | 1000 | 12 | Meat
 | beef rump | gm | 1000 | 20.5
 | diced lamb | gm | 1000 | 28.9
 | chicken mince | gm | 1000 | 12 | Meat
 | tinned salmon | gm | 1000 | 8.43
 | bacon | gm | 1000 | 18
 | beef mince | gm | 1000 | 8 | Meat
 | white fish fillets | gm | 1000 | 10
 | [NAME] | gm | 1000 | 0.05 | Equipment
 | beenshoots | gm | 1000 | 8.6 | Vegetables
 | [NAME] | each | 1 | 0.69
 | mixed leaf salad | gm | 1000 | 15
 | pumpkin | gm | 1000 | 3
 | snow peas | gm | 1000 | 15.9 | Vegetables
 | spinach | gm | 1000 | 2.9 | Vegetables
 | mushrooms | gm | 1000 | 10
 | gluten free bread | each | 1 | 0.45 | speciality item
 | eggs | each | 1 | 0.4
 | gluten free wrap bread | each | 1 | 0.31 | speciality item
 | puff pastry sheets | each | 1 | 0.69
 | shortcrust pastry sheets | each | 1 | 0.69
 | cheese slices | each | 1 | 0.4
 | choco ripple biscutis | each | 1000 | 0.12
 | taco shells | each | 1 | 0.24
 | nori sheets | each | 1 | 0.35
 | sliced white bread | each | 1 | 0.2
 | burger buns | each | 1 | 0.42
 | sliced white bread | each | 1 | 0.2 | Breads
 | wrap | each | 1 | 0.3 | Breads
associated | pizza bases | each | 1 | 0.66 | Breads |  | each base feeds 1 person
 | rice paper sheets | each | 1 | 0.2
 | sliced ham | each | 1 | 0.12 | Meat
 | sliced chicken | each | 1 | 0.15 | Meat
 | chicken breast | each | 1 | 2.5 | Meat
 | chicken wings | each | 1 | 0.75
 | foil containers | each | 1 | 0.16 | Equipment
 | plastic cups | each | 1 | 0.06 | Equipment
 | avocadoes | each | 1 | 3.9
 | lettuce | each | 1 | 1.5 | Vegetables
 | red apple | each | 1 | 0.65 | Fruit
 | lemon | each | 1 | 1.5
 | red capsicum | each | 1 | 1.58
 | mixed leaf salad | gm | 1000 | 15
 | lemon grass | each | 1 | 0.75
 | [NAME] | each | 1 | 0.69
 | green apple | each | 1 | 0.45 | Fruit
 | banana | each | 1 | 0.54 | Fruit
 | onion | each | 1 | 0.52 | Vegetables
 | lettuce leaves | each | 1 | 0.13
 | cabbage | each | 1 | 2.9 | Vegetables
 | chinese cabbage | each | 1 | 3
 | coriander fresh | each | 1 | 3
 | lettuce leaves | each | 1 | 0.13
 | mint fresh | each | 1 | 3
 | flat leaf parsley | bunch | 1 | 3
 | capsicum | each | 1 | 2.53 | Vegetables
 | carrot | each | 1 | 0.34 | Vegetables
 | pear | each | 1 | 0.88
 | leek | each | 1 | 1.5
 | celery | each | 1 | 1.5 | Vegetables
 | cucumber | each | 1 | 2.5 | Vegetables
 | sweet potatoes | each | 1 | 0.65
 | potatoes | each | 1 | 0.65 | Vegetables
 | orange | each | 1 | 0.7
 | spring onion | each | 1 | 0.2
 | kiwi fruit | each | 1 | 0.9
 | spring onion | each | 1 | 0.2 | Vegetables
 | oregano fresh | each | 1 | 3
 | chives fresh | each | 1 | 3
 | pear | each | 1 | 0.97
 | basil fresh | each | 1 | 3
 | thyme fresh | each | 1 | 3
 | strawberries | each | 1 | 0.2 | Fruit
 | tomatoes | each | 1 | 0.72 | Vegetables
 | [NAME] | each | 1 | 0.2
 | long red chilli | each | 1 | 0.5
 | mixed leaf salad | gm | 1000 | 15
 | zucchini | each | 1 | 1.5 | Vegetables
 | bok choy | bunch | 1 | 2