Scribd Logo
Upload

Welcome to Scribd!

  • 47 views

    Hot Dog Express

    Uploaded by

    api-310626022
    This document provides information about the costs of food items and calculations for running a hot dog business. It lists the package size, number of servings, cost, and cost per serving of various hot dog condiments. It then calculates the total average cost of items, the pricing with a 100% markup, and the profit per hot dog. Finally, it asks how many customers would be needed to reach a daily $800 sales goal if each customer buys 2 hot dogs.

    Copyright:

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

    Hot Dog Express

    Uploaded by

    api-310626022
    47 views2 pages
    This document provides information about the costs of food items and calculations for running a hot dog business. It lists the package size, number of servings, cost, and cost per serving of various hot dog condiments. It then calculates the total average cost of items, the pricing with a 100% markup, and the profit per hot dog. Finally, it asks how many customers would be needed to reach a daily $800 sales goal if each customer buys 2 hot dogs.

    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?

    This document provides information about the costs of food items and calculations for running a hot dog business. It lists the package size, number of servings, cost, and cost per serving of various hot dog condiments. It then calculates the total average cost of items, the pricing with a 100% markup, and the profit per hot dog. Finally, it asks how many customers would be needed to reach a daily $800 sales goal if each customer buys 2 hot dogs.

    Copyright:

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

    Hot Dog Express

    Uploaded by

    api-310626022
    This document provides information about the costs of food items and calculations for running a hot dog business. It lists the package size, number of servings, cost, and cost per serving of various hot dog condiments. It then calculates the total average cost of items, the pricing with a 100% markup, and the profit per hot dog. Finally, it asks how many customers would be needed to reach a daily $800 sales goal if each customer buys 2 hot dogs.

    Copyright:

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

    Hot Dog Express

    1) Use formulas to calculate the following data (see class instruction sheet for details)

    Food Item
    Hotdogs
    Buns
    Cheese, Shredded
    Mustard
    Mayonnaise
    Pickle Relish
    Ketchup
    Onions
    Chili

    Package
    48 count
    24 count
    3 lb.
    2 lb.
    1 qt. Bottle
    2 qt. Bottle
    2 lb.
    3 lb.
    5 lb.

    Serving
    s per
    Package
    48
    24
    48
    32
    64
    32
    24
    60
    66

    $
    $
    $
    $
    $
    $
    $
    $
    $

    Cost
    5.95
    3.76
    9.95
    1.98
    3.29
    2.15
    4.98
    1.98
    8.95

    Serving
    Cost
    $ 0.12
    $ 0.16
    $ 0.21
    $ 0.06
    $ 0.05
    $ 0.07
    $ 0.21
    $ 0.03
    $ 0.14
    $

    100%
    Markup
    $ 0.25
    $ 0.31
    $ 0.41
    $ 0.12
    $ 0.10
    $ 0.13
    $ 0.42
    $ 0.07
    $ 0.27
    Pricing Totals
    1.04 $ 2.09

    1)What is the costliest item to you by package? $ 9.95


    2)What the least expensive items to you per serving? $ 0.13
    3)What is the average cost of your hot dog food items? $4.78
    4)With a 100% markup, what is your hot dog total to the customer? $8.48
    5)With a 100% markup,
    what
    the profit
    you above
    make per
    dog? the
    $ 1.71
    Use
    theisresults
    from
    to hot
    answer
    following
    questions:
    ***NOTE: EACH ANSWER IN COLUMN F MUST BE A FORMULA***
    6)To reach a daily goal of $800 in hot dog sales, how many customers
    are needed if each customer orders 2 hotdogs? 134

    uction sheet for details)


    Selling
    Price
    (per serving)
    $
    0.50
    $
    0.63
    $
    0.83
    $
    0.25
    $
    0.21
    $
    0.27
    $
    0.83
    $
    0.13
    $
    0.54
    Pricing Totals
    $
    4.18 Hot Dog Price
    6%
    Sales Tax
    $4.24
    Hot Dog Selling Price After Tax
    Cheese, Shredde use a formula for F19 and put the food description in G19
    Onions
    use a formula for F20 and put the food description in G20

    the following

    MUST BE A FORMULA***

    You might also like