Scribd Logo
Upload

Welcome to Scribd!

  • 22 views

    Assigniment 2 - Jean Paul

    Uploaded by

    gatete sam
    The document shows sales data for different software products (word processing, spreadsheets, databases) across four cities (New York, Boston, Miami, Denver) with Boston bringing in the highest total sales of $276,000 and New York the lowest at $27,000. A bar graph compares the total sales for each software type across the cities.

    Copyright:

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

    Assigniment 2 - Jean Paul

    Uploaded by

    gatete sam
    22 views9 pages
    The document shows sales data for different software products (word processing, spreadsheets, databases) across four cities (New York, Boston, Miami, Denver) with Boston bringing in the highest total sales of $276,000 and New York the lowest at $27,000. A bar graph compares the total sales for each software type across the cities.

    Original Title

    ASSIGNIMENT 2 - JEAN PAUL (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 shows sales data for different software products (word processing, spreadsheets, databases) across four cities (New York, Boston, Miami, Denver) with Boston bringing in the highest total sales of $276,000 and New York the lowest at $27,000. A bar graph compares the total sales for each software type across the cities.

    Copyright:

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

    Assigniment 2 - Jean Paul

    Uploaded by

    gatete sam
    The document shows sales data for different software products (word processing, spreadsheets, databases) across four cities (New York, Boston, Miami, Denver) with Boston bringing in the highest total sales of $276,000 and New York the lowest at $27,000. A bar graph compares the total sales for each software type across the cities.

    Copyright:

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

    NAMES IT ECONOMICS STATISTICS

    CAT/50 EXAM/50 CAT/50 EXAM/50 CAT/50 EXAM/50


    BETTY 43 43 23 43 34 23
    BONE 23 12 50 12 36 45
    JAN 42 23 45 23 27 34
    JANNET 36 11 34 11 25 54
    MARCEL 37 17 23 17 20 34
    DANATH 47 13 34 13 29 23
    MARIROSE 45 42 12 42 28 12
    ANGE 50 45 23 45 17 34
    IGIHOZO 24 34 34 34 15 23
    BELSE 26 43 45 43 14 45
    ALICE 39 32 43 32 11 45

    PASS AN FAIL FOR THIS STUIDENT

    8
    7
    6
    5
    4
    3
    2
    1
    0
    PASS FAIL

    Given a=2/3,b=3/4,c=25.find out the value of x

    0. 4
    44𝑐∗ξ 𝑏 +4𝑎𝑐
    X= 2𝑎
    X= 2𝑎

    Description Symbols Values

    a 2÷3
    b 3÷4
    c 25
    Denominator 2a 1.33333333333
    4ac 66.6666666667
    44c 1100
    b^0.4 0.89130122898
    Light hand side(LHS) X= 6780.97647091
    assignment
    ENGLISH BASIC MATHEMATICS SOCIAL&ECON ENV ENTREPRENEURSHIP REASERCH
    CAT/50 EXAM CAT/50 EXAM/50 CAT/50 EXAM/50 CAT/50 EXAM/50 CAT/50 EXAM/50
    11 43 23 23 23 43 23 43 23 43
    15 23 50 45 45 12 50 12 50 23
    46 42 45 34 34 23 45 23 45 42
    18 36 34 54 54 11 34 11 34 36
    39 37 23 34 34 17 23 17 23 37
    25 47 34 23 23 13 34 13 34 47
    43 45 12 12 12 42 12 42 12 45
    45 50 23 34 34 45 23 45 23 50
    20 24 34 23 23 34 34 34 34 24
    25 26 45 45 45 43 45 43 45 26
    23 39 43 45 45 32 43 32 43 39

    FAIL
    SUM AVERAGE TOTAL
    CAT EXAM PASS FAIL
    507 22.5556 30.4 52.95556 PASS 7 4
    503 35.4444 18.4 53.84444 PASS
    573 36.5556 24.4 60.95556 PASS
    493 29.8889 22.4 52.28889 PASS
    432 24.6667 21 45.66667 FAIL
    452 28.8889 19.2 48.08889 FAIL
    458 19.5556 28.2 47.75556 FAIL
    586 26.4444 34.8 61.24444 PASS
    448 24.2222 23 47.22222 FAIL
    604 32.2222 31.4 63.62222 PASS
    586 32.2222 29.6 61.82222 PASS
    EXPERT SOFT WARE COMPANY

    SALES PERSON TOTAL SALES BASE SALARIES COMMITION TOTAL SALARY


    Adams, John $98,000 $35,000 3920 $38,920
    Barber, Maryann $24,000 $35,000 720 $35,720
    Boone, Dan $39,000 $50,000 1170 $51,170
    Borow, Jeff $56,000 $35,000 2240 $37,240
    Brown, James $81,000 $50,000 3240 $53,240
    Carson, Kit $17,000 $50,000 510 $50,510
    Coulter, Sara $22,000 $35,000 660 $35,660
    Fegin, Richard $72,000 $35,000 2880 $37,880
    Ford, Judd $64,000 $35,000 2560 $37,560
    Glassman, Kris $25,000 $35,000 750 $35,750
    Goodman, Neil $70,000 $50,000 2800 $52,800
    Milgrom, Marion $11,000 $50,000 330 $50,330
    Moldof, Adam $68,000 $50,000 2720 $52,720
    Smith, Adam $100,000 $50,000 4000 $54,000

    Average Total Salary


    Highest Total Salary
    Lowest Total Salary
    Commission Percentages
    Total Sales < $50,000 3%
    Total Sales ≥ $50,000 4%
    Commisson Threshold $50,000
    Evaluation Criteria
    $0
    $25,000
    $50,000
    $75,000
    SALES PERSON EVALUATION
    GOOD
    GOOD
    EXCELLENT
    GOOD
    EXCELLENT
    EXCELLENT
    GOOD 77
    GOOD
    GOOD 7
    GOOD
    EXCELLENT
    EXCELLENT
    EXCELLENT
    EXCELENT

    $44,536
    $54,000
    $35,660

    Evaluation Criteria
    Poor
    Fair
    Good
    Excellent
    Superior Software Sales

    New York Boston Miami Denver


    Word Processing 9500 1410 50000 67500
    Spreadsheets 11500 105000 44000 18000
    Database 6000 30000 12000 7500
    Total 27000 276000 106000 93000

    300000

    250000

    200000
    Word Processing
    150000 Spreadsheets
    Database
    100000 Total

    50000

    0
    New York Boston Miami Denver

    Price of Car $13,999


    Manufacturer's rebate $1,000
    Down payment $3,000
    Amount to finance $9,999
    Interest rate (yearly) 8%
    Term (years) 4
    Monthly payment $8,959.36
    Word Processing
    Spreadsheets
    Database
    Total

    You might also like