Scribd Logo
Upload

Welcome to Scribd!

  • 55 views

    Azibrofinal

    Uploaded by

    api-333416041
    The document shows Zibro Marine's expense estimates and actual expenses by month for 2022, including employee costs like wages and benefits, facilities costs like mortgage and utilities, and marketing costs. Total estimated expenses for the year are over $1.8 million while actual expenses came in lower at $1.58 million. Wages make up the largest portion of expenses at over 71% of the total actual costs.

    Copyright:

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

    Azibrofinal

    Uploaded by

    api-333416041
    55 views12 pages
    The document shows Zibro Marine's expense estimates and actual expenses by month for 2022, including employee costs like wages and benefits, facilities costs like mortgage and utilities, and marketing costs. Total estimated expenses for the year are over $1.8 million while actual expenses came in lower at $1.58 million. Wages make up the largest portion of expenses at over 71% of the total actual costs.

    Original Title

    azibrofinal

    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 shows Zibro Marine's expense estimates and actual expenses by month for 2022, including employee costs like wages and benefits, facilities costs like mortgage and utilities, and marketing costs. Total estimated expenses for the year are over $1.8 million while actual expenses came in lower at $1.58 million. Wages make up the largest portion of expenses at over 71% of the total actual costs.

    Copyright:

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

    Azibrofinal

    Uploaded by

    api-333416041
    The document shows Zibro Marine's expense estimates and actual expenses by month for 2022, including employee costs like wages and benefits, facilities costs like mortgage and utilities, and marketing costs. Total estimated expenses for the year are over $1.8 million while actual expenses came in lower at $1.58 million. Wages make up the largest portion of expenses at over 71% of the total actual costs.

    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 12

    Z

    Exp

    Jan Feb Mar Apr


    Employee Costs
    Wages $ 105,000 $ 105,000 $ 105,000 $ 130,000
    Benefits 29,400 29,400 29,400 36,400

    Facilities Costs
    Mortgage 8,500 8,500 8,500 8,500
    Utilities 1,400 1,400 1,350 1,350
    Supplies 175 175 175 200

    Marketing Costs
    Website Management 1,850 1,850 1,850 1,850
    Flyer 350 350 350 500
    Product Sheets 200 200 200 350
    Zibro Marine
    Expense Estimates

    May Jun Jul Aug Sep Oct

    $ 130,000 $ 130,000 $ 130,000 $ 130,000 $ 120,000 $ 120,000


    36,400 36,400 36,400 36,400 33,600 33,600

    8,500 8,500 8,500 8,500 8,500 8,500


    1,300 1,300 1,250 1,250 1,350 1,350
    200 300 300 300 200 200

    1,850 1,850 1,850 1,850 1,850 1,850


    500 500 500 350 350 350
    350 350 350 200 200 200
    Nov Dec YEAR

    $ 120,000 $ 120,000 $ 1,445,000


    33,600 33,600 404,600

    8,500 8,500 102,000


    1,400 1,400 16,100
    175 175 2,575

    1,850 1,850 22,200


    350 350 4,800
    200 200 3,000
    Z
    Ac

    Jan Feb Mar Apr


    Employee Costs
    Wages $ 105,000 $ 105,000 $ 105,000 $ 145,000
    Benefits 29,400 29,400 29,400 40,600

    Facilities Costs
    Mortgage 8,500 8,500 8,500 8,500
    Utilities 1,525 1,590 1,425 1,300
    Supplies 124 230 85 178

    Marketing Costs
    Website Management 1,850 1,850 1,850 1,850
    Flyer 180 245 325 620
    Product Sheets 185 225 210 405

    Employee Costs

    Jan Feb Mar Apr May Jun Jul


    Aug Sep Oct Nov Dec YEAR
    Zibro Marine
    Actual Expenses

    May Jun Jul Aug Sep Oct

    $ 145,000 $ 145,000 $ 145,000 $ 145,000 $ 135,000 $ 135,000


    40,600 40,600 40,600 40,600 37,800 37,800

    8,500 8,500 8,500 8,500 8,500 8,500


    1,475 1,620 1,570 1,520 1,610 1,630
    345 295 420 285 265 120

    1,850 1,850 1,945 1,945 1,945 1,945


    585 485 525 410 295 250
    375 415 290 255 195 245

    yee Costs Actua

    20%

    Apr May Jun Jul Jan 105000


    Nov Dec YEAR 124
    Nov Dec YEAR

    $ 135,000 $ 135,000 $ 1,580,000


    37,800 37,800 442,400

    8,500 8,500 102,000


    1,640 1,675 18,580
    186 105 2,638

    1,945 1,945 22,770


    190 230 4,340
    105 310 3,215

    Actual Expenses
    0%
    1%
    0%
    6%1%

    20%

    71%

    Jan 105000 29400 8500 1525


    124 1850 180 185
    Zibro Mar
    Wage Expen

    Employee NGross SalaryW/H Tax SS Tax Net pay


    Your name $ 750,000 $210,000.00 $ 57,375.00 $ 482,625.00
    Ben Waddle 125,000 $ 35,000.00 $ 9,562.50 $ 80,437.50
    Alicia Seaside 150,000 $ 42,000.00 $ 11,475.00 $ 96,525.00
    Angus Sundst 175,000 $ 49,000.00 $ 13,387.50 $ 112,612.50
    Jennifer Sail 100,000 $ 28,000.00 $ 7,650.00 $ 64,350.00
    Robert Shaw 104,000 $ 29,120.00 $ 7,956.00 $ 66,924.00
    Augustine Gr 176,000 $ 49,280.00 $ 13,464.00 $ 113,256.00
    Total $1,580,000 $442,400.00 $ 120,870.00 ###

    W/H Tax rate 28%


    SS Rate 7.65%
    Zibro Marine
    Wage Expense
    Zibro Marine
    Yearly Expenses

    Actual
    Employee Costs
    Wages $ 1,580,000
    Benefits 442,400

    Facilities Costs
    Mortgage 102,000
    Utilities 18,580
    Supplies 2,638

    Marketing Costs
    Website Managemen 22,770
    Flyer 4,340
    Product Sheets 3,215
    ro Marine
    ly Expenses

    Actual Expenses

    Employee Costs Wages Benefits


    Facilities Costs Mortgage
    Utilities Supplies
    Marketing Costs Website Management Flyer
    Product Sheets
    efits
    gage

    You might also like