Scribd Logo
Upload

Welcome to Scribd!

  • 41 views

    Team Presentation

    Uploaded by

    api-298370103
    The document provides pricing and sales information for various food items sold by a food booth over a 9 week period. It includes a list of products with unit prices, an income statement showing sales and expenses projected over 9 weeks, and an initial balance sheet. Key items include total projected sales of $29,113.71 over 9 weeks, total projected expenses of $16,076.09, and projected net profit of $13,037.62. Initial assets include $1,676.95 in cash and inventory.

    Copyright:

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

    Team Presentation

    Uploaded by

    api-298370103
    41 views3 pages
    The document provides pricing and sales information for various food items sold by a food booth over a 9 week period. It includes a list of products with unit prices, an income statement showing sales and expenses projected over 9 weeks, and an initial balance sheet. Key items include total projected sales of $29,113.71 over 9 weeks, total projected expenses of $16,076.09, and projected net profit of $13,037.62. Initial assets include $1,676.95 in cash and inventory.

    Original Title

    team presentation

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides pricing and sales information for various food items sold by a food booth over a 9 week period. It includes a list of products with unit prices, an income statement showing sales and expenses projected over 9 weeks, and an initial balance sheet. Key items include total projected sales of $29,113.71 over 9 weeks, total projected expenses of $16,076.09, and projected net profit of $13,037.62. Initial assets include $1,676.95 in cash and inventory.

    Copyright:

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

    Team Presentation

    Uploaded by

    api-298370103
    The document provides pricing and sales information for various food items sold by a food booth over a 9 week period. It includes a list of products with unit prices, an income statement showing sales and expenses projected over 9 weeks, and an initial balance sheet. Key items include total projected sales of $29,113.71 over 9 weeks, total projected expenses of $16,076.09, and projected net profit of $13,037.62. Initial assets include $1,676.95 in cash and inventory.

    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 3

    Products

    Bread
    Slice
    Loaf
    Bowl
    Soda
    Small
    Medium
    Large
    Salads
    Tuna Salad
    Chicken Caesar Salad
    Strawberry Spinach Salad
    Sandwiches
    Brisket
    Pulled Pork

    Unit Cost
    Bread
    Slice
    $
    0.07
    Loaf
    $
    0.80
    Bowl
    $
    1.34
    Soda
    Small
    $
    0.50
    Medium
    $
    0.80
    Large
    $
    1.10
    Salads
    Tuna Salad
    $
    2.65
    Chicken Caesar Salad
    $
    3.80
    Strawberry Spinach Salad $
    3.50
    Sandwiches
    Brisket
    $
    3.88
    Pulled Pork
    $
    1.94

    25.0%
    15.0%
    15.0%
    15.0%
    15.0%
    15.0%
    10.0%
    10.0%
    10.0%
    8.0%
    5.0%

    Sale Price

    Net of Sales TCont. Margin

    $
    $
    $

    1.00
    4.50
    4.00

    $
    $
    $

    0.80
    3.60
    3.20

    $
    $
    $

    0.73
    2.80
    1.86

    $
    $
    $

    1.50
    1.75
    2.00

    $
    $
    $

    1.30
    1.52
    1.74

    $
    $
    $

    0.80
    0.72
    0.64

    $
    $
    $

    5.00
    6.00
    6.00

    $
    $
    $

    4.55
    5.45
    5.45

    $
    $
    $

    1.90
    1.65
    1.95

    $
    $

    6.00
    4.00

    $
    $

    5.56
    3.70

    $
    $

    1.68
    1.77

    Gross Margin
    Bread
    Slice
    Loaf
    Bowl
    Soda
    Small
    Medium
    Large
    Salads
    Tuna Salad
    Chicken Caesar Salad
    Strawberry Spinach Salad
    Sandwhiches
    Brisket
    Pulled Pork

    73.0%
    77.8%
    46.5%
    53.6%
    47.4%
    32.0%
    37.9%
    30.3%
    32.6%
    28.0%
    44.2%

    Taxes
    Intrest Rate
    Income Tax
    Sales Tax %

    2.0%
    30.0%
    6.0%

    Pro Forma Income Statement


    Units Sold

    Week
    Bread
    Slice
    Loaf
    Bowl
    Soda
    Small
    Medium

    60
    35
    50

    75.00
    40.25
    57.50

    93.75
    46.29
    66.13

    117.19
    53.23
    76.04

    146.48
    61.22
    87.45

    183.11
    70.40
    100.57

    228.88
    80.96
    115.65

    286.10
    93.10
    133.00

    357.63
    107.07
    152.95

    1548.14
    587.50
    839.29

    50
    55

    57.50
    63.25

    66.13
    72.74

    76.04
    83.65

    87.45
    96.20

    100.57
    110.62

    115.65
    127.22

    133.00
    146.30

    152.95
    168.25

    839.29
    923.22

    * Prices are Approximate, real prices may vary,


    *Assumes access to Ovens, and equipment already present in the booth

    9 Total
    12.00
    7.00
    10.00
    0.00
    10.00
    11.00

    Large
    Salads
    Tuna Salad
    Chicken Caesar Salad
    Strawberry Spinach Salad
    Sandwiches
    Brisket
    Pulled Pork
    Total

    60

    69.00

    79.35

    91.25

    104.94

    120.68

    138.78

    159.60

    183.54

    1007.15

    70
    50
    45

    77.00
    55.00
    49.50

    84.70
    60.50
    54.45

    93.17
    66.55
    59.90

    102.49
    73.21
    65.88

    112.74
    80.53
    72.47

    124.01
    88.58
    79.72

    136.41
    97.44
    87.69

    150.05
    107.18
    96.46

    950.56
    678.97
    611.08

    50
    75
    600

    54.00
    78.75
    676.75

    58.32
    82.69
    765.03

    62.99
    86.82
    866.83

    68.02
    91.16
    984.50

    73.47
    95.72
    1120.87

    79.34
    100.51
    1279.31

    85.69
    105.53
    1463.87

    92.55
    110.81
    1679.43

    624.38
    826.99
    9436.58

    Revenues
    Bread
    Slice
    Loaf
    Bowl
    Soda
    Small
    Medium
    Large
    Salads
    Tuna Salad
    Chicken Caesar Salad
    Strawberry Spinach Salad
    Sandwiches
    Brisket
    Pulled Pork
    Total

    Total
    $ 1,238.51
    $ 2,115.02
    $ 2,685.73

    $
    $
    $

    48.00 $
    126.00 $
    160.00 $

    60.00 $
    144.90 $
    184.00 $

    75.00
    166.64
    211.60

    $
    $
    $

    93.75
    191.63
    243.34

    $
    $
    $

    117.19
    220.37
    279.84

    $
    $
    $

    146.48
    253.43
    321.82

    $
    $
    $

    183.11
    291.45
    370.09

    $
    $
    $

    228.88
    335.16
    425.60

    $
    $
    $

    286.10
    385.44
    489.44

    $
    $
    $

    65.22 $
    83.70 $
    160.00 $

    75.00 $
    96.25 $
    184.00 $

    86.25
    110.69
    211.60

    $
    $
    $

    99.19
    127.29
    243.34

    $
    $
    $

    114.07
    146.38
    279.84

    $
    $
    $

    131.18
    168.34
    321.82

    $
    $
    $

    150.85
    193.59
    370.09

    $
    $
    $

    173.48
    222.63
    425.60

    $
    $
    $

    199.50
    256.03
    489.44

    $
    $
    $

    1,094.73
    1,404.90
    2,685.73

    $
    $
    $

    318.18 $
    272.73 $
    245.45 $

    350.00 $
    300.00 $
    270.00 $

    385.00
    330.00
    297.00

    $
    $
    $

    423.50
    363.00
    326.70

    $
    $
    $

    465.85
    399.30
    359.37

    $
    $
    $

    512.44
    439.23
    395.31

    $
    $
    $

    563.68
    483.15
    434.84

    $
    $
    $

    620.05
    531.47
    478.32

    $
    $
    $

    682.05
    584.62
    526.15

    $
    $
    $

    4,320.74
    3,703.49
    3,333.14

    $
    277.78 $
    300.00 $
    324.00
    $
    277.78 $
    291.67 $
    306.25
    $ 2,034.83 $ 2,255.82 $ 2,504.02

    $
    $
    $

    349.92
    321.56
    2,783.22

    $ 377.91
    $ 337.64
    $ 3,097.77

    $
    408.15
    $
    354.52
    $ 3,452.71

    $
    440.80
    $
    372.25
    $ 3,853.89

    $
    $
    $

    476.06
    390.86
    4,308.12

    $
    $
    $

    514.15
    410.40
    4,823.33

    $ 3,468.77
    $ 3,062.93
    $ 29,113.71

    Total
    $
    42.88
    $
    470.00
    $ 1,124.65

    COGS
    Bread
    Slice
    Loaf
    Bowl
    Soda
    Small
    Medium
    Large
    Salads
    Tuna Salad
    Chicken Caesar Salad
    Strawberry Spinach Salad
    Sandwiches
    Brisket
    Pulled Pork
    Total
    $

    Gross Profit

    Expense:
    Marketing
    R&D
    Food Permits

    $
    $
    $

    $4.20
    $28.00
    $67.00

    $2.82
    $32.20
    $77.05

    $3.24
    $37.03
    $88.61

    $3.73
    $42.58
    $101.90

    $4.29
    $48.97
    $117.18

    $4.93
    $56.32
    $134.76

    $5.67
    $64.77
    $154.98

    $6.52
    $74.48
    $178.22

    $7.49
    $85.65
    $204.95

    $32.61
    $44.00
    $66.00

    $37.50
    $50.60
    $75.90

    $43.13
    $58.19
    $87.29

    $49.59
    $66.92
    $100.38

    $57.03
    $76.96
    $115.43

    $65.59
    $88.50
    $132.75

    $75.43
    $101.77
    $152.66

    $86.74
    $117.04
    $175.56

    $99.75
    $134.60
    $201.90

    $
    $
    $

    547.36
    738.58
    1,107.87

    $185.50
    $190.00
    $157.50

    $204.05
    $209.00
    $173.25

    $224.46
    $229.90
    $190.58

    $246.90
    $252.89
    $209.63

    $271.59
    $278.18
    $230.60

    $298.75
    $306.00
    $253.66

    $328.62
    $336.60
    $279.02

    $361.49
    $370.26
    $306.92

    $397.64
    $407.28
    $337.62

    $
    $
    $

    2,518.99
    2,580.10
    2,138.77

    $290.63
    $305.16
    $320.41
    $145.31
    $152.58
    $160.21
    1,210.75 $ 1,320.10 $ 1,443.03

    $336.43
    $168.22
    1,579.17

    $353.26
    $176.63
    $ 1,730.11

    $370.92
    $185.46
    $ 1,897.62

    $389.47
    $194.73
    $ 2,083.71

    $408.94
    $204.47
    2,290.63

    $429.39
    $214.69
    2,520.96

    $ 3,204.60
    $ 1,602.30
    $ 16,076.09

    1,204.05 $1,367.65

    $1,555.08

    $1,770.18

    $ 2,017.49

    $ 2,302.37

    $13,037.62

    $
    $

    $
    $

    $
    $

    824.09

    150.00 $
    150.00 $
    125.00

    935.71

    $1,060.99

    150.00 $
    150.00 $

    150.00
    150.00

    $
    $

    150.00
    100.00

    ### $
    ### $

    75.00
    50.00

    75.00
    50.00

    * Prices are Approximate, real prices may vary,


    *Assumes access to Ovens, and equipment already present in the booth

    75.00
    50.00

    75.00
    50.00

    Total
    $ 1,050.00
    $
    850.00
    $
    125.00

    12.00
    0.00
    14.00
    10.00
    9.00
    0.00
    10.00
    15.00

    Deprciation
    Misc. Expense
    Total

    $
    $

    EBIT

    Income Tax Expense

    Net Profit

    41.20 $
    466.20 $

    357.88
    357.88

    $
    $
    $

    46.79 $
    346.79 $

    588.93
    588.93

    $
    $
    $

    53.05
    353.05

    $
    $

    707.94

    707.94

    $
    $

    60.20
    310.20

    $
    $

    68.38
    318.38

    893.84 $1,049.27
    -

    $
    $

    $1,352.33

    ### $

    893.84 $1,049.27

    77.75
    202.75

    $1,352.33

    $
    $

    88.51
    213.51

    Equipment*
    Meat Lamp
    Bun Toaster
    Total Equipment

    $
    $
    $

    651.88
    2,676.88

    $1,556.67

    $2,051.95

    $
    841.20
    $ 1,210.75

    $2,051.95

    Stockholders Equity
    Common Stock
    Retained Earnings
    Total Stockholders Equity
    Total Stockholders Equity
    and Liablities

    $
    $
    $

    $10,360.74

    Liabilities
    Notes Payable
    Accounts Payable
    Interest Payable
    Income Tax Payable
    Misc. Payable
    Total Liablities

    115.12
    240.12

    $ 2,062.25

    100.00
    275.00
    375.00

    Total Assets

    $
    $

    $ 1,791.61

    Assets
    $
    466.20
    $ 1,210.75
    $ 1,676.95

    100.87
    225.87

    $1,556.67

    Beginning Balance Sheet


    Current Assets
    Cash
    Inventory
    Total Current Assets

    $
    $

    $2,051.95

    * Prices are Approximate, real prices may vary,


    *Assumes access to Ovens, and equipment already present in the booth

    $ 1,791.61

    $ 2,062.25

    $10,360.74

    You might also like