Spreadsheet: 733605d1621654772-food-truck-cost-spreadsheet-assistance-please-bergies-menu-05142021
Sheet: Ingredients

Menu Item | Burger |  | Cheese Burger |  | ? |  | ?
Ingredient | Portion | Total Cost | Portion | Total Cost | Portion | Total Cost | Portion | Total Cost |  | Pastable | Price per each | Qty | Price per 100 ml | Serving ml | Total | Pastable | Supplier | Brand | Product Name | [NAME] | Case Cost | Product Number
[NAME] | 1 |  |  |  |  |  |  |  |  | 0.027 |  |  | 0.18 | 0.15 |  | 0.027 | Wholesale Club | SunSpun | Hamburger Sliced Dill Pickles | 3.78 L | 10.97 | 20799952_EA
[NAME] |  |  | 1 |  | 1 |  | 1 |  |  | 0.0255 |  |  | 0.17 | 0.15 |  | 0.0255 | Wholesale Club | SunSpun | Ketchup Pump | 4 L | 6.97 | 21202857_EA
Mayo |  |  |  |  |  |  |  |  |  | 0.0705 |  |  | 0.47 | 0.15 |  | 0.0705 | Wholesale Club | HELLMANNS | Mayo | 4 L | 18.97 | 20021711_EA
Relish | 1 |  |  |  |  |  |  |  |  | 0.039 |  |  | 0.26 | 0.15 |  | 0.039 | Wholesale Club | SunSpun | [NAME] | 3.78 L | 9.97 | 20787162_EA
Onion |  |  |  |  |  |  |  |  |  | 0.0225 |  |  | 0.15 | 0.15 |  | 0.0225 | Wholesale Club | Farmer's Market | Yellow Onions | 10 lb | 6.97 | 20600991001_EA
Tomato |  |  |  |  |  |  |  |  |  | 0.0705 |  |  | 0.47 | 0.15 |  | 0.0705 | Wholesale Club | Vine Tomato Single | Vine Tomato Single | 1 kg | 4.34 | 20025417001_KG
Lettuce |  |  | 2 |  | 2 |  | 2 |  |  | 0.109 | 0.10876369 | 1 |  | 59 |  | 0.109 | Wholesale Club | Green Leaf Lettuce (Case) |  | 24 | 30.97 | 20133884001_C01
Mustard |  |  |  |  |  |  |  |  |  | 0.023685 |  |  | 0.1579 | 0.15 |  | 0.023685 | Wholesale Club | SunSpun | Prepared Mustard | 3.78 L | 5.97 | 6038374080
6oz STERLING Sirloin Beef Patty | 3 |  |  |  |  |  |  |  |  | 2.0972 | 2.0972 | 1 |  |  |  | 2.0972 | B&C Foods | Sterling | BURGER 6OZ STERLING SSP 25X6OZ | 25 | 52.43
[NAME] |  |  |  |  |  |  |  |  |  | 0.395833333333333 | 0.395833333333333 | 1 |  |  |  | 0.395833333333333 | [NAME]'s Bakery | [NAME]'s Bakery | Sweet Dough Burger Bun | 12 | 4.75
Thermo Foil Wrap (Burgers & Wraps) |  |  | 1 |  | 1 |  | 1 |  |  | 0.06 | 0.06 | 1 |  |  |  | 0.06 | Wholesale Club | Thermofoil | Thermo Foil Wrap | 1000 | 60.97 | 20551814_EA
Cheese Slice Cheddar |  |  |  |  |  |  |  |  |  | 0.3265 | 0.3265 | 1 |  |  |  | 0.3265 | B&C Foods | Castle | CHEESE CHEDDAR SLICES 4X500GR/100SL | 2 kg | 32.65
Cheese Slice Med Cheddar |  |  |  |  |  |  |  |  |  | 0.2376 | 0.23762 | 1 |  |  |  | 0.2376 | Wholesale Club | NoName | Medium Cheddar, Club | 2.27kg | 26.97 | 20178500_EA
Cheese Slice Swiss | 1 |  |  |  |  |  |  |  |  | 0.3033 | 0.3033 | 1 |  |  |  | 0.3033 | B&C Foods | Castle | CHEESE SWISS SLCD 4X500GR/100SLC | 3 kg | 30.33
Vinegar |  |  |  |  |  |  |  |  |  | 0.026 | 0.02594 | 1 |  | 9 |  | 0.026 | Wholesale Club | SunSpun | Vinegar 9g pack of 500 |  | 12.97 | 20180896_EA
[NAME], Hot, Rings |  |  | 1 |  | 1 |  | 1 |  |  | 0.026 | 0.02599 | 1 | 0.29 | 9 |  | 0.026 | Wholesale Club | President's Choice | [NAME], Hot, Rings | 2L | 5.77 | 20081534_EA
[NAME] |  |  |  |  |  |  |  |  |  | 0.0003 | 0.00299 | 1 |  |  |  | 0.0003 | Wholesale Club | Diamond | Diamond [NAME] | 1000 | 2.99 | 20114220_EA
[NAME] | 0.5 |  |  |  |  |  |  |  |  | 0.0209 | 0.01047 | 2 |  |  |  | 0.0209 | Wholesale Club | SunSpun | Pepper Portion | 1000 | 10.47 | 6038368448
Tortilla |  |  |  |  | 2 |  |  |  |  | 0.331 | 0.3308333 | 1 |  |  |  |  | Wholesale Club | Sonora | [NAME], 10 in | 12 | 3.97 | 20955770_EA
Portion Cup 1oz |  |  |  |  |  |  |  |  |  | 0.004 | 0.00397 | 1 |  |  |  | 0.004 | Wholesale Club | Godet | Godet Paper Portion Cup F100 | 1000 | 3.97 | 2064810022
[NAME] 14 lb |  |  |  |  |  |  | 1 |  |  | 0.05594 | 0.05594 | 1 |  |  |  | 0.05594 | Wholesale Club | Craft | Plain Paper Bags | 500 | 27.97 | 20182664_EA
Cup Soup/Chilli 12 oz | 1 |  |  |  |  |  |  |  |  | 0.1588 | 0.1588 | 1 |  |  |  | 0.1588 | Wholesale Club |  | 12 oz Compostable Paper Soup Cup | 25 | 3.97
[NAME] |  |  |  |  |  |  |  |  |  | 0.0694 | 0.0694 | 1 |  |  |  | 0.0694 | Wholesale Club |  | Vented Lid 115Mm | 50 | 3.47
Total Cost
Margin Required | 0.2 |  | 0.25 |  | 0.3 |  | 0.15
Selling Price