it- recipe costing

48
Recipe Costing Guide Recipe Name: Costing Sheet Explanation 1 Batch Size Ba 2 Portion per Batch Pl $ 16.50 Menu Price (per portion) Foo Contributio Unit Ingredients Example 1 # skirt steak 4 ea lemons 4 ea oranges 6 ea apples Quantity (A) This is the amount that is produced by this recipe How many portions will this "batch" make? Decide on your menu price and put it here. Once your plate cost is calculated, your FC% will automatically be calculated. How many of each "unit" do you need? What size is the "unit" that you need? (ex: ounces, pounds, etc.) How much does the product cost per "unit" that you need? *Be sure that your cost per unit matches the unit *

Upload: mcgonagle7

Post on 30-Jul-2015

51 views

Category:

Documents


3 download

TRANSCRIPT

Page 1: IT- Recipe Costing

Recipe Costing Guide

Recipe Name: Costing Sheet Explanation

1 Batch Size Batch Cost 2 Portion per Batch Plate Cost

$ 16.50 Menu Price (per portion) Food Cost % Contribution Margin

Unit Ingredients

Example1 # skirt steak $ 6.650 4 ea lemons $ 0.190 4 ea oranges $ 0.240 6 ea apples $ 0.200

Quantity(A)

AP Unit cost (D)

This is the amount that is produced by this recipe

How many portions will this "batch" make?

Decide on your menu price and put it here. Once your plate cost is calculated, your FC% will automatically be calculated.

How many of each "unit" do you need?

What size is the "unit" that you need? (ex: ounces, pounds, etc.)

How much does the product cost per "unit"

that you need?

*Be sure that your cost per unit

matches the unit*

You only need to specify a yield percent on certain products. If you leave this blank, the sheet calculates it as 100% yield.

C5
This is the amount that is produced by this recipe
C6
How many portions will this "batch" make?
C7
Decide on your menu price and put it here. Once your plate cost is calculated, your FC% will automatically be calculated.
C11
How many of each "unit" do you need?
D11
What size is the "unit" that you need? (ex: ounces, pounds, etc.)
F11
How much does the product cost per "unit" that you need? *Be sure that your cost per unit matches the unit*
Page 2: IT- Recipe Costing

Recipe Costing Guide

$ 11.98 $ 5.99

36.3%$10.51

$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

75.0% $ 8.87 $ 8.87 90.0% $ 0.21 $ 0.84 90.0% $ 0.27 $ 1.07

100.0% $ 0.20 $ 1.20 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Yield %(E)

Subtotal (EP per

unit)

Extension (A×D/E)

This will be automatically calculated based on your ingredients and the prices below

This is determined based on your "batch" cost and the number of portions in the batch.

This is automatically calculated based on your cost per plate and the menu price that you decide on.

How much does the product cost per "unit"

that you need?

*Be sure that your cost per unit

matches the unit*

You only need to specify a yield percent on certain products. If you leave this blank, the sheet calculates it as 100% yield.

This is automatically calculated for you based on the # of units, the unit cost and the yield %.

This is EP (edible portion) per unit - the new cost after trim or waste

G5
This will be automatically calculated based on your ingredients and the prices below
G6
This is determined based on your "batch" cost and the number of portions in the batch.
G7
This is automatically calculated based on your cost per plate and the menu price that you decide on.
H10
This is EP (edible portion) per unit - the new cost after trim or waste
G11
You only need to specify a yield percent on certain products. If you leave this blank, the sheet calculates it as 100% yield.
I11
This is automatically calculated for you based on the # of units, the unit cost and the yield %.
Page 3: IT- Recipe Costing

Recipe Costing Guide

Recipe Name:

1 Batch Size Batch Cost 8 Portion per Batch Plate Cost

$ 5.00 Menu Price (per portion) Food Cost % Contribution Margin

Unit Ingredients

1 lb Unsalted Butter $ 2.420 15 lb Spanish Onions, sliced $ 0.400

2 oz salt $ 0.010 2 gallons white wine $ 8.840

1 1/2 cold water $ - 1/2 bunch fresh thyme $ 1.460 1/2 bunch fresh parsley $ 1.010 2 ea bay leaves $ 0.010 4 ea green leek leaves $ 0.020

Quantity(A)

AP Unit cost (D)

Page 4: IT- Recipe Costing

Recipe Costing Guide

$ 28.51 $ 3.56

71.3%$1.44

100.0% $ 2.42 $ 2.42 85.0% $ 0.47 $ 7.06

100.0% $ 0.01 $ 0.02 $ 17.68 $ - $ 0.73 $ 0.51

98.0% $ 0.01 $ 0.02 $ 0.08 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Yield %(E)

Subtotal (EP per

unit)

Extension (A×D/E)

Page 5: IT- Recipe Costing

Recipe Costing Guide

Recipe Name: champagne cookies

1 Batch Size Batch Cost $ 10.31 30 Portion per Batch Plate Cost $ 0.34

$1.50 Menu Price (per portion) Food Cost % 22.9% Contribution Margin $1.16

Unit Ingredients

4 ounces butter $ 0.106 8 ounces sugar $ 0.041 8 ounces champangne $ 1.150

16 ounces AP flour $ 0.020 2 tsp baking powder $ 0.021

Quantity(A)

AP Unit cost (D)

Yield %(E)

Subtotal (EP per

unit)

Page 6: IT- Recipe Costing

Recipe Costing Guide

$ 0.43 $ 0.33 $ 9.20 $ 0.32 $ 0.04 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Extension (A×D/E)

Page 7: IT- Recipe Costing

Recipe Costing Guide

Recipe Name: Apple cider cupcakes

1 Batch Size Batch Cost $ 13.33 30 Portion per Batch Plate Cost $ 0.44

Menu Price (per portion) Food Cost % #DIV/0! Contribution Margin -$0.44

Unit Ingredients

20 ounces cake flour- sifted $ 0.019 1/3 ounces baking powder $ 0.125 1/4 tsp baking soda $ 0.022 1/4 tsp salt $ 0.001 1/3 ounces cinnamon $ 0.970 1/4 tsp allspice $ 0.085 1/3 tsp cloves $ 0.158 1/6 ounces nutmeg $ 0.820 4 ounces butter $ 0.106

8 3/4 ounces brown sugar $ 1.000 10 ounces eggs $ 0.074 8 ounces buttermilk $ 0.101 1/6 ounces vanilla $ 0.512

10 3/4 ounces apple cider $ 0.064 7 3/4 ounces apple sauce $ 0.093 2 each egg whites $ 0.071

Quantity(A)

AP Unit cost (D)

Yield %(E)

Subtotal (EP per

unit)

Page 8: IT- Recipe Costing

Recipe Costing Guide

$ 0.38 $ 0.04 $ 0.01 $ 0.00 $ 0.33 $ 0.02 $ 0.05 $ 0.13 $ 0.43 $ 8.75 $ 0.75 $ 0.81 $ 0.09 $ 0.69 $ 0.72 $ 0.14 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Extension (A×D/E)

Page 9: IT- Recipe Costing

Recipe Costing Guide

Recipe Name:

Batch Size Batch Cost $ - Portion per Batch Plate Cost #DIV/0!Menu Price (per portion) Food Cost % #DIV/0!

Contribution Margin #DIV/0!

Unit Ingredients

Quantity(A)

AP Unit cost (D)

Yield %(E)

Subtotal (EP per

unit)

Page 10: IT- Recipe Costing

Recipe Costing Guide

$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Extension (A×D/E)

Page 11: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 1

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

DairyButter Unsalted 1#prints lb 159.00 $1.70 ###

Cheese Blue lb 6.00 $4.39 ###

Cheese Blue Crumbled lb 4.00 $3.20 ###

Cheese Boursin each 12.00 $3.30 ###

Cheese Cheddar lb 18.00 $2.10 ###

Cheese Chevre lb 19.80 $6.61 ###

Cheese Cream Loaf box 4.00 $6.62 ###

Cheese Gruyere lb 7.00 $7.68 ###

Cheese Mascarpone lb 12.00 $5.01 ###

Cheese Mozzarella Loaf lb 6.00 $1.90 ###

Cheese Parm Reggiano lb 21.30 $3.98 ###

Cheese Pepper Jack lb 8.00 $2.18 ###

Cheese Provolone lb 2.00 $3.21 ###

Cheese Ricotta lb 4.00 $2.30 ###

Cheese Swiss lb 11.00 $2.57 ###

Cream Half And Half qt 24.00 $1.52 ###

Cream Heavy Hgal hgal 26.00 $5.61 ###

Cream Sour cntr 4.00 $5.61 ###

Cream Whipped Can can 8.00 $2.15 ###

Creme Fraiche lb 2.00 $4.11 ###

Egg Whites each 4.00 $12.36 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 12: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 2

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

DairyEgg Yolks Pasteurized each 16.00 $2.00 ###

Milk Buttermilk qt 8.00 $3.24 ###

Milk Hvd Homo each 1.00 $18.51 ###

Milk Skim Half Gallon hgal 3.00 $1.66 ###

Milk Whole Gallon gal 17.00 $3.15 ###

Yogurt 2 Lb 2#TUB 5.00 $3.50 ###

Dairy Total: ###

GroceryAnchovies tin 8.00 $2.90 ###

Artichokes Hearts #10 #10 4.00 $9.04 ###

Baking Powder tub 1.50 $10.91 ###

Baking Soda box 16.00 $1.31 ###

Bar Mix Margarita bottle 4.00 $2.68 ###

Bar Mix Strawbrry Daquiry each 8.00 $4.25 ###

Bean Canellini #10 can can 2.00 $3.24 ###

Bean Garbanzo Dried case 0.40 $23.22 ###

Bean Garbanzos #10 Can #10 7.00 $3.87 ###

Bean Lentil French lb 10.00 $1.77 ###

Bean Pea Navy lb 20.00 $0.90 ###

Bitters Angostura bottle 0.00 $6.27 ###

Bonito Flakes lb 2.00 $10.24 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 13: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 3

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GroceryBread English Muffin sleeve 8.00 $3.05 ###

Bread Tortilla Corn sleeve 4.00 $5.38 ###

Bread Tortilla Flour 10" sleeve 12.00 $2.01 ###

Candy Mints case 0.13 $33.24 ###

Capers jar 4.00 $8.55 ###

Catsup Vol Pak bag 1.00 $19.78 ###

Cherries Maraschino gal 2.00 $14.23 ###

Chips Madhouse Individual Bag case 1.00 $19.88 ###

Chocolate Chip lb 20.00 $2.01 ###

Chocolate Hot Packets box 1.70 $9.43 ###

Chocolate Milk lb 6.00 $3.56 ###

Chocolate Semi-sweet lb 45.00 $5.31 ###

Chocolate White lb 4.00 $6.49 ###

Coconut Dessicated Unswt lb 3.00 $2.26 ###

Coconut Sweetened bag 2.50 $3.50 ###

Coffee Columbian Popayan bag 6.00 $12.03 ###

Coffee Espresso 2.2 Oz case 0.00 $50.45 ###

Coffee Espresso Decaf case 0.00 $22.36 ###

Coffee Espresso Pod - Decaf case 1.00 $33.80 ###

Coffee Espresso Pod - Reg case 2.00 $33.80 ###

Coffee Vt Cntry 2.2 case 0.00 $50.45 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 14: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 4

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GroceryCoffee Vt Cntry Dcaf 2.2 case 0.25 $50.45 ###

Coffee Vt Cntry Dcaf 4# bag 6.00 $9.62 ###

Corn Starch box 8.00 $0.66 ###

Crackers Assorted case 0.50 $40.73 ###

Crumbs Grahm Cracker lb 4.00 $1.84 ###

Dried Apricot lb 10.00 $2.45 ###

Dried Cherries Tart lb 20.00 $6.73 ###

Dried Cranberries lb 20.00 $4.01 ###

Dried Dates Whole lb 12.00 $7.70 ###

Dried Figs lb 5.00 $5.63 ###

Dried Raisins Dark lb 5.00 $1.59 ###

Dried Raisins Golden lb 25.00 $1.66 ###

Egg large doz 120.00 $0.89 ###

Extract Vanilla Pure gal 0.80 $65.55 ###

Fish Salmon Smoked lb 8.00 $11.50 ###

Flour All Purpose lb 200.00 $0.32 ###

Flour Almond lb 5.00 $7.20 ###

Flour Bread lb 50.00 $0.39 ###

Flour Cake lb 50.00 $0.30 ###

Flour Chick Pea lb 12.00 $1.90 ###

Flour Pastry lb 50.00 $0.36 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 15: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 5

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GroceryFlour Rice case 1.25 $71.76 ###

Flour Semolina lb 50.00 $0.52 ###

Flour Wondra bag 0.40 $19.02 ###

Gelatin Powdered lb 3.00 $16.83 ###

Gelatin Sheets box 2.50 $58.50 ###

Ginger Crystallized lb 4.00 $7.99 ###

Glucose pail 1.01 $20.10 ###

Grain Barley lb 12.00 $0.40 ###

Grain Bulgar lb 5.00 $2.09 ###

Grain Cornmeal lb 30.00 $0.40 ###

Grain Cous Cous box 8.80 $3.09 ###

Grain Couscous Israeli lb 10.00 $1.72 ###

Grain Grits lb 5.00 $2.99 ###

Grain Oats Rolled lb 40.00 $0.42 ###

Grain Polenta lb 22.00 $1.33 ###

Grain Quinoa lb 5.00 $4.75 ###

Grape Leaves jar 0.00 $5.95 ###

Grenadine Roses bottle 2.00 $3.58 ###

Honey lb 10.00 $3.26 ###

Honey Bears bottle 10.00 $2.58 ###

Horseradish qt 2.00 $5.62 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 16: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 6

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GroceryIqf Avocado Pulp Guacamole each 3.33 $12.74 ###

Iqf Blackberries lb 15.00 $2.00 ###

Iqf Blueberries lb 15.00 $1.40 ###

Iqf Corn lb 20.00 $1.60 ###

Iqf Peaches lb 5.00 $1.90 ###

Iqf Pearl Onions bag 8.00 $3.61 ###

Iqf Peas lb 40.00 $1.09 ###

Iqf Raspberries lb 10.00 $3.61 ###

Juice Apple 60 oz case 0.75 $28.11 ###

Juice Cranberry 60 Oz bottle 8.00 $3.47 ###

Juice Cranberry Bib each 1.00 $24.75 ###

Juice Grapefruit 60 oz each 8.00 $2.80 ###

Juice Lemonade 12 Oz can 288.00 $0.65 ###

Juice Lime 32 oz case 1.83 $51.93 ###

Juice Orange Fresh Gal gal 12.00 $4.23 ###

Juice Pineapple 46 Oz can 9.00 $1.87 ###

Juice Tomato 46 Oz can 10.00 $1.55 ###

Mayonnaise Gallon gal 3.00 $8.62 ###

Milk Coconut - 15 oz case 0.92 $35.18 ###

Milk Condensed each 14.00 $2.04 ###

Milk powder bulk bag 0.10 $65.85 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 17: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 7

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GroceryMolasses gal 0.60 $8.99 ###

Mustard Dijon can 2.00 $15.05 ###

Mustard Frenchs bottle 14.00 $1.40 ###

Mustard Grey Poupon each 8.00 $1.91 ###

Mustard Whole Grain can 1.00 $20.60 ###

Nuts Almonds Sliced lb 3.00 $4.63 ###

Nuts Almonds Whole Raw lb 20.00 $4.90 ###

Nuts Cashews lb 4.00 $4.55 ###

Nuts Hazelnuts Whole lb 10.00 $5.92 ###

Nuts Macadamia lb 6.00 $9.64 ###

Nuts Pecans Pieces lb 30.00 $4.50 ###

Nuts Pepitas/pumpkin lb 5.00 $4.49 ###

Nuts Pinenuts lb 6.00 $33.45 ###

Nuts Pistachio Meats lb 3.00 $10.48 ###

Nuts Walnuts 1/2 & Pcs lb 15.00 $4.98 ###

Oil Canola 35# Tub tub 4.00 $23.74 ###

Oil Fry 35# Tub tub 3.00 $24.34 ###

Oil Olive Extra Virgin can 10.00 $22.82 ###

Oil Pan Vegaline Spray each 6.00 $5.14 ###

Oil Sesame can 1.50 $15.52 ###

Olives Calamata Pitted lb 10.00 $6.50 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 18: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 8

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GroceryOlives Queen Blue cheese stuffed case 0.50 $143.92 ###

Olives Queen Garlic Stuffed bag 1.00 $60.10 ###

Olives Queen Stuffed Gallon gal 2.00 $15.79 ###

Onions Cocktail jar 6.00 $1.31 ###

Pasta Elbow Macaroni lb 30.00 $0.85 ###

Pasta Linguini lb 20.00 $0.86 ###

Pasta Orzo lb 15.00 $0.89 ###

Pasta Penne lb 10.00 $0.87 ###

Paste Tahini lb 6.00 $4.60 ###

Paste Tomato 12 oz each 16.00 $1.36 ###

Peanut Butter Creamy tub 5.00 $7.24 ###

Pectin Apple lb 2.00 $24.25 ###

Phyllo Dough pkg 2.20 $1.63 ###

Potato Fries French 5/16 case 2.00 $23.87 ###

Pumpkin Solid #10 2.00 $6.10 ###

Puree Passionfruit each 2.00 $12.10 ###

Puree Strawberry ·each 1.00 $10.90 ###

Rice Arborio lb 32.00 $1.27 ###

Rice Basmati lb 25.00 $1.19 ###

Rice Brown Long Grain lb 20.00 $1.21 ###

Rice Jasmine lb 30.00 $0.96 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 19: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 9

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GroceryRice Sushi Sticky lb 60.00 $1.66 ###

Rice White Parbolied lb 40.00 $0.55 ###

Rice Wild lb 20.00 $6.90 ###

Sauce A-1 Steak bottle 7.00 $1.82 ###

Sauce Chili Garlic Galln gal 1.00 $14.80 ###

Sauce Chili Sriracha case 0.70 $20.40 ###

Sauce Chipotles Adobo Sc can 3.67 $1.19 ###

Sauce Hot Gallon gal 1.00 $12.79 ###

Sauce Soy 5 gallon 5GAL 0.30 $28.97 ###

Sauce Tabasco 12 Oz Btle bottle 15.00 $4.90 ###

Sauce Worchestershire5oz each 9.00 $1.40 ###

Sauce Worchestershre Gal gal 1.00 $7.16 ###

Seaweed Nori pkg 3.00 $12.95 ###

Shortening Vegetable 50#CNT 0.20 $27.56 ###

Soda Bib box 1.00 $51.65 ###

Soda Co2 Cylinder each 1.00 $70.00 ###

Soda Pre Mix cntr 1.00 $11.50 ###

Soda Sourmix cntr 1.00 $23.79 ###

Spice Allspice Whole oz 32.00 $0.49 ###

Spice Anise Star/whole oz 8.00 $0.99 ###

Spice Basil Leaf oz 4.00 $0.81 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 20: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 10

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GrocerySpice Bay Leaves oz 16.00 $2.50 ###

Spice Caraway Seed oz 4.00 $0.37 ###

Spice Cardamon Pod Green oz 8.00 $1.70 ###

Spice Cayenne Pepper oz 48.00 $0.56 ###

Spice Celery Seed oz 4.00 $0.32 ###

Spice Chili Powder oz 64.00 $0.47 ###

Spice Cinnamon Ground oz 32.00 $0.31 ###

Spice Cinnamon Stick oz 64.00 $1.24 ###

Spice Cloves Whole oz 16.00 $0.91 ###

Spice Coriander Whole oz 48.00 $0.72 ###

Spice Cumin Whole oz 64.00 $0.45 ###

Spice Curry Powder oz 64.00 $0.52 ###

Spice Fenugreek Seed oz 33.33 $0.32 ###

Spice Garlic Granulated oz 32.00 $0.39 ###

Spice Ginger Powder oz 32.00 $0.75 ###

Spice Juniper Berries oz 3.20 $0.93 ###

Spice Marjoram Leaf oz 4.00 $1.12 ###

Spice Mustard Seed Yellow lb 2.00 $4.96 ###

Spice Nutmeg Whole oz 16.00 $0.80 ###

Spice Old Bay lb 2.00 $5.38 ###

Spice Onion Powder oz 24.00 $0.25 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 21: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 11

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GrocerySpice Oregano Leaf oz 32.00 $0.57 ###

Spice Paprika Smoked tin 10.91 $3.73 ###

Spice Peppercorn Black oz 80.00 $0.43 ###

Spice Peppercorn Blk Grd oz 32.00 $0.40 ###

Spice Peppercorn White oz 32.00 $0.55 ###

Spice Poppy Seed oz 16.00 $0.46 ###

Spice Saffron oz 0.50 $103.82 ###

Spice Salt Bulk/evaporat lb 4.00 $0.11 ###

Spice Salt Kosher box 16.00 $1.83 ###

Spice Salt Popcorn cntr 8.00 $1.14 ###

Spice Sesame Seed White oz 16.00 $0.34 ###

Spice Tarragon Leaf oz 8.00 $1.60 ###

Spice Tumeric Ground oz 32.00 $0.47 ###

Spice Wasabi Powder oz 8.00 $4.68 ###

bag 6.00 $2.03 ###

Sugar Confection Bag bag 16.00 $2.03 ###

Sugar Equal Packets case 1.00 $28.04 ###

Sugar Granulated lb 150.00 $0.65 ###

Sugar In Raw Packets case 0.90 $24.98 ###

Sugar Packs Vermont case 0.90 $9.77 ###

Sugar Splenda case 1.00 $31.14 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 22: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 12

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GrocerySugar Sweet N Low Packs case 1.00 $24.47 ###

Syrup Chocolate #10 Can #10 1.00 $7.93 ###

Syrup Corn Light gal 1.50 $14.41 ###

Syrup Maple Grade B gal 10.00 $44.42 ###

Syrup Monin Almond bottle 1.00 $9.50 ###

Syrup Monin Caramel bottle 1.00 $9.50 ###

Syrup Monin Hazelnut bottle 1.00 $9.50 ###

Syrup Monin Irish Cream bottle 1.00 $9.50 ###

Syrup Monin Raspberry each 1.00 $9.50 ###

Syrup Monin Vanilla bottle 1.00 $9.50 ###

Tea Reflections box 1.50 $4.55 ###

Tea VT Artisan 175 - Chai Masala bag 1.14 $34.25 ###

Tea VT Artisan 175 - Chamomile bag 1.14 $34.25 ###

Tea VT Artisan 175 - Earl Grey bag 0.86 $34.25 ###

Tea VT Artisan 175 - English Breakfasbag 1.14 $34.25 ###

Tea VT Artisan 175 - Peppermint bag 1.14 $34.25 ###

Tea VT Artisan 175 - Yunwu bag 1.00 $34.25 ###

Tempeh lb 5.00 $4.87 ###

Tofu Extra Firm PACKAG 9.00 $2.63 ###

Tomato Fillet #10 6.00 $4.20 ###

Tuna Chunk Light can 5.00 $9.04 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 23: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 13

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

GroceryVinegar Balsamic jug 1.00 $12.54 ###

Vinegar Cider gal 4.00 $2.79 ###

Vinegar Malt bottle 6.00 $1.89 ###

Vinegar Red Wine gal 3.00 $12.33 ###

Vinegar Rice Wine gal 4.00 $7.13 ###

Vinegar Sherry 5 Ltr jug 2.00 $12.30 ###

Vinegar White gal 3.00 $2.34 ###

Vinegar White Wine 5 Ltr jug 2.00 $10.37 ###

Wine Red Cooking 5L each 20.00 $8.26 ###

Wine White Cooking 5L each 5.00 $8.26 ###

Yeast Instant Saf bag 4.00 $2.78 ###

Grocery Total: ###

MeatBeef Brisket Choice Fres lb 22.30 $2.04 ###

Beef Ground 80/20 lb 90.00 $3.50 ###

Beef Hanger Steak lb 21.60 $2.40 ###

Chicken Breast B/s lb 32.00 $1.25 ###

Chicken Leg Quarters lb 20.00 $1.51 ###

Chicken Whole All Natural lb 26.00 $2.32 ###

Cornish Hens lb 72.00 $1.81 ###

Duck Breast Boneless lb 9.50 $9.11 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 24: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 14

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

MeatDuck Legs lb 12.30 $3.67 ###

Lamb Ground lb 25.00 $3.80 ###

Mf Beef Ribeye lb 14.80 $13.82 ###

Mf Pork Chops lb 12.70 $2.00 ###

Mf Sausage Andouille lb 4.00 $2.25 ###

Mf Sausage Chorizo lb 4.00 $2.25 ###

Pork Bacon Layout/slice lb 30.00 $2.56 ###

Pork Bacon Slab lb 25.00 $4.72 ###

Pork Bellies Fresh lb 6.00 $0.00 ###

Pork Ham Boneless lb 9.00 $4.97 ###

Pork Loin Boneless lb 8.50 $3.96 ###

Pork Pepperoni Sliced lb 10.00 $3.81 ###

Pork Proscuitto lb 7.50 $14.40 ###

Pork Tenderloin Bnls lb 24.00 $2.83 ###

Veal Bones lb 100.00 $1.70 ###

Veal Sweetbreads lb 4.00 $4.99 ###

Venison Boneless Leg lb 8.00 $14.21 ###

Meat Total: ###

ProduceApple Fuji - case case 0.80 $41.00 ###

Apple Granny Smith each 6.00 $0.47 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 25: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 15

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

ProduceArtichokes each 24.00 $1.33 ###

Asparagus lb 15.00 $2.41 ###

Bean Haricort Verts lb 5.00 $4.39 ###

Beets lb 10.00 $1.09 ###

Cabbage Red lb 15.00 $1.10 ###

Carrots lb 40.00 $0.40 ###

Celery bunch 20.00 $0.96 ###

Chard Swiss bunch 6.00 $1.83 ###

Cucumbers English each 12.00 $1.17 ###

Eggplant lb 16.63 $1.20 ###

Fennel/anise each 12.00 $2.08 ###

Garlic lb 5.00 $2.63 ###

Garlic Peeled gal 1.60 $12.19 ###

Ginger Root lb 3.00 $1.89 ###

Grapes Green lb 10.00 $2.25 ###

Grapes Red lb 10.00 $1.89 ###

Herb Basil bunch 6.00 $3.20 ###

Herb Chives bunch 8.00 $3.95 ###

Herb Cilantro bunch 8.00 $0.99 ###

Herb Dill bunch 2.00 $2.00 ###

Herb Mint bunch 10.00 $2.09 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 26: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 16

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

ProduceHerb Oregano bunch 3.00 $3.25 ###

Herb Parsley Flat/italia bunch 16.00 $1.19 ###

Herb Rosemary bunch 8.00 $3.25 ###

Herb Sage bunch 4.00 $3.25 ###

Herb Tarragon bunch 6.00 $3.95 ###

Herb Thyme bunch 8.00 $3.25 ###

Lemons each 88.00 $0.25 ###

Lettuce Arugula bunch 6.40 $0.88 ###

Lettuce Mesclun LOCAL lb 12.00 $6.50 ###

Lettuce Raddichio lb 2.00 $6.64 ###

Lettuce Red Leaf head 20.00 $1.04 ###

Lettuce Romaine Hearts bag 6.00 $2.04 ###

Limes each 70.00 $0.24 ###

Melon Canteloupe each 8.00 $4.50 ###

Melon Honeydew each 3.00 $2.75 ###

Mushroom Domestic lb 30.00 $1.59 ###

Mushroom Oyster lb 2.00 $4.98 ###

Mushroom Portabella lb 5.00 $2.50 ###

Mushroom Shiitake lb 1.50 $5.98 ###

Mushroom Shiitake Dried lb 0.50 $15.95 ###

Mushroom Woodear Dried lb 0.50 $11.95 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 27: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 17

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

ProduceOnions Chipolini lb 5.00 $3.19 ###

Onions Leeks bunch 12.00 $1.92 ###

Onions Red lb 20.00 $1.60 ###

Onions Scallions bunch 20.00 $0.69 ###

Onions Shallots lb 12.00 $1.45 ###

Onions Spanish lb 150.00 $0.64 ###

Oranges each 50.00 $0.27 ###

Peppers Ancho Dried lb 0.50 $9.68 ###

Peppers Green lb 15.00 $1.00 ###

Peppers Jalapeno Green lb 2.00 $3.69 ###

Peppers Red lb 20.00 $1.72 ###

Potato Baker/russet each 250.00 $0.16 ###

Potato Sweet/yams lb 25.00 $0.45 ###

Potato Yukon Gold lb 125.00 $0.40 ###

Rhubarb lb 10.00 $1.78 ###

Spinach Baby case 1.50 $14.95 ###

Squash Summer lb 5.00 $0.85 ###

Squash Zucchini lb 5.00 $0.80 ###

Strawberries pint 9.00 $2.08 ###

Tomato Hot House lb 20.00 $1.27 ###

Tomato Plum lb 10.00 $1.00 ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 28: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 18

Main St. Grill

Inventory ExtensionSorted by Report Group

Item Name Unit On Hand Cost Extension

Inventory Form:6/30/2011 3:00 PMFood

ProduceTomato Sundried lb 5.00 $3.80 ###

Watercress bunch 6.00 $1.16 ###

Produce Total: ###

SeafoodFish Clams Minced/choppd gal 0.50 $26.00 ###

Fish Cod Salt lb 3.00 $7.75 ###

Fish Mussels Pei lb 5.00 $1.80 ###

Fish Octopus Whole lb 5.00 $2.08 ###

Fish Oysters each each 5.00 $0.72 ###

Fish Salmon Filet lb 7.00 $7.50 ###

Fish Salmon King lb 22.00 $13.30 ###

Fish Scallops U-10 lb 30.00 $13.95 ###

Fish Shrimp 21/25 lb 20.00 $7.95 ###

Fish Sole Dover lb 5.00 $3.95 ###

Fish Squid/calamari lb 20.00 $0.98 ###

Fish Trout 10 Oz Clearct lb 20.00 $7.95 ###

Seafood Total: ###

Food Department Total: ###

Inventory Form Total: ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 29: IT- Recipe Costing

7/21/2011 3:16:20 PM Page 19

Main St. Grill

Inventory ExtensionSorted by Report Group

Report Group Extension

Report Group SummaryInventory Form:6/30/2011 3:00 PMFood

Dairy ###

Grocery ###

Meat ###

Produce ###

Seafood ###

Food Department Total: ###

Inventory Form Total: ###

FOOD-TRAK® System for Windows * Copyright 1997,2011, System Concepts, Inc. All Rights Reserved * FOOD-TRAK is a Registered Trademark

Page 30: IT- Recipe Costing

of 19

Page 31: IT- Recipe Costing

of 19

Page 32: IT- Recipe Costing

of 19

Page 33: IT- Recipe Costing

of 19

Page 34: IT- Recipe Costing

of 19

Page 35: IT- Recipe Costing

of 19

Page 36: IT- Recipe Costing

of 19

Page 37: IT- Recipe Costing

of 19

Page 38: IT- Recipe Costing

of 19

Page 39: IT- Recipe Costing

of 19

Page 40: IT- Recipe Costing

of 19

Page 41: IT- Recipe Costing

of 19

Page 42: IT- Recipe Costing

of 19

Page 43: IT- Recipe Costing

of 19

Page 44: IT- Recipe Costing

of 19

Page 45: IT- Recipe Costing

of 19

Page 46: IT- Recipe Costing

of 19

Page 47: IT- Recipe Costing

of 19

Page 48: IT- Recipe Costing

of 19