Scribd Logo
Upload

Welcome to Scribd!

  • 60 views

    Laiba Tahir 2025-11-0172 Izzah Atif Dar 2025-11-0184 Ahmad Jawaid 2025-11-0024

    Uploaded by

    laiba
    Group #10 consists of 3 students: Laiba Tahir, Izzah Atif Dar, and Ahmad Jawaid. Various mathematical operations are performed on the numbers 1 through 5, resulting in sums, differences, products, and quotients. Customers are listed with their ID and amount spent. The total number of customers is 26 and total spend is $43,811. Various operations are performed to add 10 to each amount spent. Items are listed with their ID, price, cost, and calculated margin. The highest margin item is 2738 at 89.41% and the lowest is 6215 at -8.24%. Employee data is provided including name, rank, location, salary details, deductions and totals

    Copyright:

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

    Laiba Tahir 2025-11-0172 Izzah Atif Dar 2025-11-0184 Ahmad Jawaid 2025-11-0024

    Uploaded by

    laiba
    60 views8 pages
    Group #10 consists of 3 students: Laiba Tahir, Izzah Atif Dar, and Ahmad Jawaid. Various mathematical operations are performed on the numbers 1 through 5, resulting in sums, differences, products, and quotients. Customers are listed with their ID and amount spent. The total number of customers is 26 and total spend is $43,811. Various operations are performed to add 10 to each amount spent. Items are listed with their ID, price, cost, and calculated margin. The highest margin item is 2738 at 89.41% and the lowest is 6215 at -8.24%. Employee data is provided including name, rank, location, salary details, deductions and totals

    Original Title

    A2-2025-11-0172

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Group #10 consists of 3 students: Laiba Tahir, Izzah Atif Dar, and Ahmad Jawaid. Various mathematical operations are performed on the numbers 1 through 5, resulting in sums, differences, products, and quotients. Customers are listed with their ID and amount spent. The total number of customers is 26 and total spend is $43,811. Various operations are performed to add 10 to each amount spent. Items are listed with their ID, price, cost, and calculated margin. The highest margin item is 2738 at 89.41% and the lowest is 6215 at -8.24%. Employee data is provided including name, rank, location, salary details, deductions and totals

    Copyright:

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

    Laiba Tahir 2025-11-0172 Izzah Atif Dar 2025-11-0184 Ahmad Jawaid 2025-11-0024

    Uploaded by

    laiba
    Group #10 consists of 3 students: Laiba Tahir, Izzah Atif Dar, and Ahmad Jawaid. Various mathematical operations are performed on the numbers 1 through 5, resulting in sums, differences, products, and quotients. Customers are listed with their ID and amount spent. The total number of customers is 26 and total spend is $43,811. Various operations are performed to add 10 to each amount spent. Items are listed with their ID, price, cost, and calculated margin. The highest margin item is 2738 at 89.41% and the lowest is 6215 at -8.24%. Employee data is provided including name, rank, location, salary details, deductions and totals

    Copyright:

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

    Group # 10

    Name Roll Number


    Laiba Tahir 2025-11-0172
    Izzah Atif Dar 2025-11-0184
    Ahmad Jawaid 2025-11-0024
    Number 1 Number 2
    5 4 Sum using numbers and + sign 9
    Sum using cell references and + sign 9
    Sum using cell references and sum function 9
    5
    Subtract using cell references 1
    Multiply using cell references 20
    Divide using cell references 1.25
    Customer ID Amount Spent Add 10
    1 42 52
    2 423 433
    3 4324 4334
    4 2132 2142
    5 54 64
    6 243 253
    7 43 53
    8 5435 5445
    9 563 573
    10 2324 2334
    11 43 53
    12 90 100
    13 90 100
    14 864 874
    15 44 54
    16 467 477
    17 75 85
    18 9656 9666
    19 7865 7875
    20 765 775
    21 4676 4686
    22 976 986
    23 83 93
    24 23 33
    25 1647 1657
    26 864 874

    Total customers 26
    Total spend by customers 43811
    Minimum amount spent by customer 23
    Maximum amount spent by customer 9656
    # Item ID Price Cost Margin
    1 2212 2150 2000 6.976744
    2 2347 1700 1500 11.76471
    3 7920 1950 1800 7.692308
    4 9777 1150 900 21.73913
    5 8352 2000 300 85
    6 4322 750 780 -4
    7 9019 160 20 87.5
    8 6215 850 920 -8.235294
    9 2720 1150 1000 13.04348
    10 7346 900 890 1.111111
    11 8803 850 790 7.058824
    12 2576 2250 2100 6.666667
    13 9289 2700 2380 11.85185
    14 2738 850 90 89.41176
    15 7413 1050 900 14.28571
    16 5003 1200 1100 8.333333
    17 3253 1700 1200 29.41176
    18 2296 1300 1300 0
    19 5230 2850 2700 5.263158
    20 5674 90 30 66.66667
    Highest Margin Value 89.41176
    Highest Margin Item 2738

    Lowest Margin Value -8.235294


    Lowest Margin Item 6215
    Sr no. Name Rank Location Gross Salary Per Hour Salary Present Days
    1 Shais Aadil Manager Head Office 70000 21
    2 Maryam Jahanzeb Manager Head Office 65000 21
    3 Tooba Ashraf Manager Head Office 75000 21
    4 Ali Tarar Manager Head Office 80000 20
    5 Owais Khan Manager Head Office 68000 20
    6 Sarfaraz Gil Manager Head Office 60000 19
    7 Maimoona Khan Assistant Manager Head Office 50000 21
    8 Laila Khattak Assistant Manager Head Office 52000 21
    9 Tanveer Bhatti Assistant Manager Head Office 54000 20
    10 Asad Khan Assistant Manager Head Office 38000 19
    11 Kalsoom Nasir Manager Branch 35000 19
    12 Sarah Amjad Waiter Branch 16800 70 30
    13 Waiter Branch 15600 65 30
    14 Farooq Butt Cleaner Branch 11600 50 29
    15 Moiz Nasir Waiter Branch 16320 68 30
    16 Ali Gohar Waiter Branch 12096 72 21
    17 Maira Rashid Chef Branch 35000 34
    18 Chef Branch 20000 33
    19 Fajr Rehmat Intern Head Office 12000 21
    20 Turab Amjad Intern Head Office 12000 20
    21 Dua Rehmat Intern Head Office 12000 20
    22 Bilal Khan Intern Head Office 12000 19
    23 Shifa Noor Intern Head Office 12000 15
    24 Taufiq Akhtar Intern Head Office 12000 14
    Absent Advance Decduction Fine Total Gross Tax Payable
    0 0 70000 3500
    0 0 65000 3250
    0 5000 0 70000 3750
    1 300 79700 4000
    1 200 67800 3400
    2 700 59300 3000
    0 200 49800 2500
    0 100 51900 2600
    1 100 53900 2700
    2 0 38000 1900
    11 0 35000 1750
    0 200 16600 840
    0 300 15300 780
    1 2000 400 9200 580
    0 0 16320 816
    9 300 11796 604.8
    -4 0 35000 1750
    -3 800 19200 1000
    0 0 12000 600
    1 0 12000 600
    1 3000 0 9000 600
    2 0 12000 600
    6 0 12000 600
    7 0 12000 600
    Number of Missing Names 2

    Total Salary Expense for Month 846416

    Average Gross Salary 35267.33

    You might also like