Scribd Logo
Upload

Welcome to Scribd!

  • 123 views

    Hot Dog Express

    Uploaded by

    api-240476573

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Hot Dog Express

    Uploaded by

    api-240476573
    123 views2 pages

    Original Title

    hot dog express

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    123 views2 pages

    Hot Dog Express

    Uploaded by

    api-240476573

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 2

    Hot Dog Express

    1) Use formulas to calculate the following data (see class instruction sheet for details) Servings Selling per Serving 200% Price (per serving) Food Item Package Package Cost Cost Markup Hotdogs 48 count 48 $ 5.95 $ 0.12 $ 0.25 $ 0.25 Buns 24 count 24 $ 3.76 $ 0.16 $ 0.31 $ 0.31 Cheese, Shredded 3 lb. 48 $ 9.95 $ 0.21 $ 0.41 $ 0.41 Mustard 2 lb. 32 $ 1.98 $ 0.06 $ 0.12 $ 0.12 Mayonnaise 1 qt. Bottle 64 $ 3.29 $ 0.05 $ 0.10 $ 0.10 Pickle Relish 2 qt. Bottle 32 $ 2.15 $ 0.07 $ 0.13 $ 0.13 Ketchup 2 lb. 24 $ 4.98 $ 0.21 $ 0.42 $ 0.42 Onions 3 lb. 60 $ 1.98 $ 0.03 $ 0.07 $ 0.07 Chili 5 lb. 66 $ 8.95 $ 0.14 $ 0.27 $ 0.27 Pricing Totals $ 1.04 $ 2.09 $ 2.09 $0.13 $ 2.21 Use the results from above to answer the following questions: ***NOTE: EACH ANSWER IN COLUMN F MUST BE A FORMULA*** 1)What is the costliest item to you by package? $ 0.21 Cheese, Shredded 2)What the least expensive items to you per serving? $ 0.03 Onions 3)What is the average cost of your hot dog food items? $ 0.23 4)With a 200% markup, what is your hot dog total to the customer? $ 2.09 5)With a 200% markup, what is the profit you make per hot dog? $ 1.04 6)To reach a daily goal of $800 in hot dog sales, how many customers are needed if each customer orders 2 hotdogs? 181

    Hot Dog Price Sales Tax 6% Hot Dog Selling Price After Tax

    use a formula for F19 and put the food description in G19 use a formula for F20 and put the food description in G20

    You might also like