Scribd Logo
Upload

Welcome to Scribd!

  • 43 views

    Employee ID Criteria: Quick Search Results: Last Day of Year Manager Salary Threshold

    Uploaded by

    riya lakhotia
    The document contains salary information for various employees of GetFit including their employee ID, name, location, title, hire date and salary. It also lists criteria for calculating year-end bonuses and raises based on date of hire. The table provides salary data for 20 GetFit employees across different locations and roles.

    Copyright:

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

    Employee ID Criteria: Quick Search Results: Last Day of Year Manager Salary Threshold

    Uploaded by

    riya lakhotia
    43 views7 pages
    The document contains salary information for various employees of GetFit including their employee ID, name, location, title, hire date and salary. It also lists criteria for calculating year-end bonuses and raises based on date of hire. The table provides salary data for 20 GetFit employees across different locations and roles.

    Original Title

    e07_script_data (1)

    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 contains salary information for various employees of GetFit including their employee ID, name, location, title, hire date and salary. It also lists criteria for calculating year-end bonuses and raises based on date of hire. The table provides salary data for 20 GetFit employees across different locations and roles.

    Copyright:

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

    Employee ID Criteria: Quick Search Results: Last Day of Year Manager Salary Threshold

    Uploaded by

    riya lakhotia
    The document contains salary information for various employees of GetFit including their employee ID, name, location, title, hire date and salary. It also lists criteria for calculating year-end bonuses and raises based on date of hire. The table provides salary data for 20 GetFit employees across different locations and roles.

    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 7

    Employee ID Criteria: Title Quick Search Results:

    Last Day of Year


    Manager Salary Threshold

    GetFit Sales Rep Salary Information

    Employee ID Name Location Title Hire Date


    1124 Angel Nashville Manager 9/4/2007
    9355 Armstrong Dallas Sales Rep 10/8/2018
    5521 Brooks Atlanta Sales Rep 7/20/2014
    2253 Chin Atlanta Manager 2/9/2009
    5967 Diaz Dallas Sales Rep 12/20/2014
    5245 Dominguez Nashville Sales Rep 5/6/2014
    6568 Ferguson Nashville Sales Rep 8/4/2015
    5058 Flowers Nashville Sales Rep 3/17/2014
    5370 Gaddis Nashville Sales Rep 7/16/2014
    7848 Goodyear Atlanta Sales Rep 11/16/2016
    6196 Hutcherson Atlanta Sales Rep 5/21/2015
    6370 Kemper Dallas Sales Rep 6/5/2015
    2899 Lin Dallas Manager 3/22/2011
    3698 Lynch Nashville Sales Rep 8/19/2012
    8211 Novak Dallas Sales Rep 9/21/2017
    6656 Proctor Nashville Sales Rep 10/5/2015
    7009 Sadler Nashville Sales Rep 3/6/2016
    7428 Skinner Atlanta Sales Rep 9/7/2016
    3445 Trujillo Dallas Sales Rep 3/14/2012
    4981 Urban Dallas Sales Rep 1/30/2014
    Bonus Amount Date Percent
    12/31/2018 Hired before 1/1/2011 10%
    $ 80,000 Hired on or before 1/1/2016 6%
    Hired after 1/1/2016 5%

    Years Raise
    Employed Salary Bonus Amount Status
    $ 72,750
    $ 48,575
    $ 44,000
    $ 85,800
    $ 42,695
    $ 41,750
    $ 47,350
    $ 49,240
    $ 48,735
    $ 47,225
    $ 49,000
    $ 46,025
    $ 68,500
    $ 48,250
    $ 43,000
    $ 48,300
    $ 36,350
    $ 46,445
    $ 48,250
    $ 45,750
    GetFit Sales Rep Salary Information
    Employee ID Name Location Title Hire Date Salary
    1124 Angel Nashville Manager 9/4/2007 $ 72,750
    9355 Armstrong Dallas Sales Rep 10/8/2018 $ 48,575
    5521 Brooks Atlanta Sales Rep 7/20/2014 $ 44,000
    2253 Chin Atlanta Manager 2/9/2009 $ 85,800
    5967 Diaz Dallas Sales Rep 12/20/2014 $ 42,695
    5245 Dominguez Nashville Sales Rep 5/6/2014 $ 41,750
    6568 Ferguson Nashville Sales Rep 8/4/2015 $ 47,350
    5058 Flowers Nashville Sales Rep 3/17/2014 $ 49,240
    5370 Gaddis Nashville Sales Rep 7/16/2014 $ 48,735
    7848 Goodyear Atlanta Sales Rep 11/16/2016 $ 47,225
    6196 Hutcherson Atlanta Sales Rep 5/21/2015 $ 49,000
    6370 Kemper Dallas Sales Rep 6/5/2015 $ 46,025
    2899 Lin Dallas Manager 3/22/2011 $ 68,500
    3698 Lynch Nashville Sales Rep 8/19/2012 $ 48,250
    8211 Novak Dallas Sales Rep 9/21/2017 $ 43,000
    6656 Proctor Nashville Sales Rep 10/5/2015 $ 48,300
    7009 Sadler Nashville Sales Rep 3/6/2016 $ 36,350
    7428 Skinner Atlanta Sales Rep 9/7/2016 $ 46,445
    3445 Trujillo Dallas Sales Rep 3/14/2012 $ 48,250
    4981 Urban Dallas Sales Rep 1/30/2014 $ 45,750

    Criteria Range:

    Output Range:
    Summary Statistics:
    Average
    Low
    High
    # of Employees
    Input Area: Basic Output Area:
    Payment $ 550.00 Loan
    APR 4.25% Periodic Rate
    Years 4 # of Payments
    Pmts per Year 12

    Payment Beginning Monthly Principal Ending


    Number Balance Payment Interest Paid Repayment Balance
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    Totals
    Cumulative Cumulative
    Interest Principal

    You might also like