Scribd Logo
Upload

Welcome to Scribd!

  • 397 views

    Computer Assignment of Excel

    Uploaded by

    Adeel Kiayni
    The document contains 6 exercises that provide data in table format related to payroll, call statistics, sales reports, purchase reports, and other financial information. The tables include data such as employee payroll details, call volumes and bonuses for agents, monthly sales and commissions by employee, item sales and taxes, quarterly city sales and profits, and customer purchase histories. The data comes from a variety of companies and organizations and is presented to practice working with tables of financial and statistical information.

    Copyright:

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

    Computer Assignment of Excel

    Uploaded by

    Adeel Kiayni
    397 views9 pages
    The document contains 6 exercises that provide data in table format related to payroll, call statistics, sales reports, purchase reports, and other financial information. The tables include data such as employee payroll details, call volumes and bonuses for agents, monthly sales and commissions by employee, item sales and taxes, quarterly city sales and profits, and customer purchase histories. The data comes from a variety of companies and organizations and is presented to practice working with tables of financial and statistical information.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains 6 exercises that provide data in table format related to payroll, call statistics, sales reports, purchase reports, and other financial information. The tables include data such as employee payroll details, call volumes and bonuses for agents, monthly sales and commissions by employee, item sales and taxes, quarterly city sales and profits, and customer purchase histories. The data comes from a variety of companies and organizations and is presented to practice working with tables of financial and statistical information.

    Copyright:

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

    Computer Assignment of Excel

    Uploaded by

    Adeel Kiayni
    The document contains 6 exercises that provide data in table format related to payroll, call statistics, sales reports, purchase reports, and other financial information. The tables include data such as employee payroll details, call volumes and bonuses for agents, monthly sales and commissions by employee, item sales and taxes, quarterly city sales and profits, and customer purchase histories. The data comes from a variety of companies and organizations and is presented to practice working with tables of financial and statistical information.

    Copyright:

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

    Areesha Adeel Kiyani

    DPT 1ST YEAR


    Roll no: 01
    Computer assignment
    Islamabad Medical and Dental College.
    EXERCISE 1:

    Payroll
    date 9/9/2021

    Hourly Hours
    EMPL Number EMPL Number Gross pay S.S Tax Net pay
    Rate Text

    E00001 Ford 7.5 35 $262.50 $15.75 $246.75


    E00002 Mino 8 30 $240.00 $14.40 $225.60
    E00003 Bell 6.5 25 $162.50 $9.75 $152.75
    E00004 Davis 9 40 $360.00 $21.60 $338.40
    E00005 Turo 10 39 $390.00 $23.40 $366.60

    EXERCISE 2:
    LONDON CALL STATISTICS

    No. Hours Calls per


    Name Bonus
    calls worked hour
    Adam 42 5 8.4 € 2.10
    Jhon 6 4 1.5 € 0.38
    Jamse 39 6 6.5 € 0.63
    Alex 15 6 2.5 € 0.63
    Emma 2 7 0.28571429 € 0.07

    Total 104 28 19.1871429 4.795

    Bonus
    25%
    rate
    EXERCISE 3:

    Pnada EST
    Monthly Sales Report-July

    Emp.No. Name Salary Sales amount Commission Total salary


    $101 Ahmed 1600 2500 50 1,650.00
    $105 Hassan 1800 3000 60 1,860.00
    $112 Ali 1500 2200 44 1,544.00
    $107 Waleed 2000 4500 90 2,090.00
    $110 Muhammad 1700 3500 70 1,770.00
    $103 Samir 1600 2500 50 1,650.00

    Total 10,200.00 18,200.00 364.00 10,564.00


    Average 1,700.00 3,033.33 60.67 1,760.67
    Highest 2,000.00 4,500.00 90.00 2,090.00
    Lowest 1,500.00 2,200.00 44.00 1,544.00
    Count 6 6.00 6 6
    EXERCISE 4:

    Total
    Total
    Item No. of Item price
    Tax price Rate
    No. items Price before
    after tax
    Tax
    100 115 30 50 3450 3500 Reasonable
    101 256 12 50 3072 3122 Reasonable
    102 49 56 50 2744 2794 Reasonable
    103 23 150 100 3450 3550 High
    104 840 5 50 4200 4250 High
    105 200 56 50 11200 11250 High
    106 294 300 100 88200 88300 High
    107 4 90 50 360 410 Reasonable

    Count of items 8 8 8 8
    Average of Tax 87.375 62.5 14584.5 14647
    Minimum Item
    5 50 360 410
    price
    Maximum Item
    300 100 88200 88300
    price
    EXERCISE 5:

    Sales an profit report-First Quarter 2012


    No. City Jan Feb Mar Average Maximum
    C001 New york $22,000.00 $29,000.00 $19,000.00 $23,333.33 $29,000.00
    C002 Los Angeles $42,000.00 $39,000.00 $43,000.00 $41,333.33 $43,000.00
    C003 London $18,000.00 $20,000.00 $22,000.00 $20,000.00 $22,000.00
    C004 Paris $35,000.00 $26,000.00 $31,000.00 $30,666.67 $35,000.00
    C005 Munich $12,000.00 $15,000.00 $13,000.00 $13,333.33 $15,000.00
    Total sales $129,000.00 $129,000.00 $128,000.00
    Cost $83,000.00 $84,000.00 $43,000.00
    Profit $46,000.00 $45,000.00 $85,000.00
    10% Bonus $4,600.00 $4,500.00 $8,500.00

    Total sales greater than


    $77,000.00 $39,000.00 $74,000.00
    30000
    No. of sales greater than
    2 1 2
    30000
    Sales and Profit
    $50,000.00

    $40,000.00

    $30,000.00 Jan

    $20,000.00 Feb
    Mar
    $10,000.00

    $0.00
    New york Los London Paris Munich
    Angeles

    Maximum sales in each city

    11%
    20%

    24%

    30%
    15%
    EXERCISE 6:

    USA Annual purchase Report-2011

    Gender
    Customer ID City Education Annual Annual
    purchases Salary
    C11 M New york University $6,233.00 7500
    C12 M New york High School $4,233.00 4999
    C13 F Seatle University $6,560.00 6750
    C14 M Chicago University $5,001.00 12000
    C15 F New York University $7,034.00 17500
    C16 F Chicago University $5,345.00 13150
    C17 F Seatle High School $790.00 3799
    C18 F Seatle None $240.00 2150
    C19 M Seatle University $4,300.00 22450
    C20 F New york None $232.00 2500

    Total annual
    City
    purchase
    New york $17,732.00
    Chicago $10,346.00
    Seattle $11,890.00

    Average annual
    Education
    Purchase
    University $34,473.00
    High school $5,023.00
    Annual Salary Gender
    None $472.00
    City Male Female
    Gender Population New York $12,499.00 $20,000.00
    Male 4 Chicago $12,000.00 $13,150.00
    Female 6 Seattle $22,450.00 $12,699.00
    Annual Purchase VS. Annual Salary
    $30,000.00

    $25,000.00

    $20,000.00

    $15,000.00 Annual Salary


    Annual purchases
    $10,000.00

    $5,000.00

    $0.00
    C11 C12 C13 C14 C15 C16 C17 C18 C19 C20

    Total annual purchase

    Seattle

    Chicago
    Total annual purchase

    New york

    $0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00

    Population

    40% Male

    Female
    60%
    New york Chicago Seattle
    Male $10,466.00 $5,001.00 $4,300.00
    Female $7,266.00 $5,345.00 $7,590.00

    Annual Purchases

    $15,000.00

    $10,000.00
    Male
    $5,000.00
    Female
    Female
    $0.00
    Male
    New york
    Chicago
    Seattle

    You might also like