Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    Excel Assignment 1

    Uploaded by

    Deepak
    The document contains sales details for various products from January 26th to January 31st. It includes information on the sales executive, product, customer, quantity sold, invoice number and incentives. There are also summaries of monthly sales by salesperson, revenue and costs for a period, and employee payroll details.

    Copyright:

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

    Excel Assignment 1

    Uploaded by

    Deepak
    33 views6 pages
    The document contains sales details for various products from January 26th to January 31st. It includes information on the sales executive, product, customer, quantity sold, invoice number and incentives. There are also summaries of monthly sales by salesperson, revenue and costs for a period, and employee payroll details.

    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 sales details for various products from January 26th to January 31st. It includes information on the sales executive, product, customer, quantity sold, invoice number and incentives. There are also summaries of monthly sales by salesperson, revenue and costs for a period, and employee payroll details.

    Copyright:

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

    Excel Assignment 1

    Uploaded by

    Deepak
    The document contains sales details for various products from January 26th to January 31st. It includes information on the sales executive, product, customer, quantity sold, invoice number and incentives. There are also summaries of monthly sales by salesperson, revenue and costs for a period, and employee payroll details.

    Copyright:

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

    Product Sales Details Column1 Column2 Column3 Column4

    Date Sales Executive Product Customer QTY(boxex)


    26/01/2020 Himanshu Lux IN & OUT 110.00
    27/01/2020 Sales Executive Pears IN&OUT 150.00
    28/01/2020 Manjit Amala plus V MART 380.00
    29/01/2020 Rashmi singh SunSilk Stop&Shop 290.00
    30/01/2020 Vivek Kumar Clinic Plus Big Mart 190.00
    31/01/2020 Jyoti bharadwaj Lux IN&OUT 450.00
    26/01/2020 Komal kumari Pears Big Mart 250.00
    29/01/2020 Himanshu Sunsilk Balaji Mart 200.00
    28/01/2020 Nitika kumari Dove Stop&Shop 150.00
    29/01/2020 Sneha kumari Shower Gel V Bazar 140.00
    30/01/2020 Ritika Clear Spring Bar Buy&Save 143.00
    31/01/2020 Neha Sunsilk Stop&Shop 290.00
    29/01/2020 Natasha SunSilk Stop&Shop 290.00
    30/01/2020 Nidhi Lux IN&OUT 450.00
    29/01/2020 Richa SunSilk Stop&Shop 290.00
    Column5 Column6
    INV No. Incentive
    IACT/INV/001 ₹ 550.00
    IACT/INV/002 ₹ 750.00
    IACT/INV/003 ₹ 1,900.00
    IACT/INV/004 ₹ 1,450.00
    IACT/INV/005 ₹ 950.00
    IACT/INV/006 ₹ 2,250.00
    IACT/INV/007 ₹ 1,250.00
    IACT/INV/008 ₹ 1,000.00
    IACT/INV/009 ₹ 750.00
    IACT/INV/010 ₹ 700.00
    IACT/INV/011 ₹ 715.00
    IACT/INV/012 ₹ 1,450.00
    IACT/INV/013 ₹ 1,450.00
    IACT/INV/014 ₹ 2,250.00
    IACT/INV/015 ₹ 1,450.00
    Total ₹ 18,865.00
    Monthly Sales details
    Salesman jan Feb March Total
    Amit kumar 5600 4500 6540 16640
    Ravi Kumar 8500 6550 7500 22550
    Sanjay verma 6900 9500 4500 20900
    Vikash sumam 7500 4500 6800 18800
    Rajesh Jha 5500 8400 6587 20487
    Neha singh 8500 5500 5600 19600
    Rita Dev 6520 4570 3600 14690
    aditya singh 5500 6500 4500 16500
    Raj Kamal 4500 4700 6900 16100

    18%
    Product OTY Rate GST@18%
    SamsungG7 12 12500 177000
    SamsungG5 10 10580 124844
    SamsungG8 8 15500 146320
    RealmeM17 5 9800 57820

    HRA CITY WISE


    25% 30% 35%
    BASIC KOLKATA DELHI MUMBAI
    10000 2500 3000 3500
    15000 3750 4500 5250
    20000 5000 6000 7000
    25000 6250 7500 8750

    Revenue 200000
    cost 115000
    bonus 4047.61905
    profit 80952.381
    EMP-ID DOJ NAME DEPT PAY RATE TOTAL PAY
    E0001 Monday, January 1, 2001 AKHIL KUMAR ACCT 200/Hr ₹ 50.00 ₹ 10,000.00
    E0002 Friday, February 2, 2001 NITISH KUMAR ADMIN 220/Hr ₹ 48.00 ₹ 10,560.00
    E0003 Saturday, March 3, 2001 PINKY SINGH MKT 185/Hr ₹ 42.00 ₹ 7,770.00
    E0002 Wednesday, April 4, 2001 VIVEK KUMAR SALES 230/Hr ₹ 55.00 ₹ 12,650.00
    E0005 Saturday, May 5, 2001 JYOTI KUMARI EDP 180/Hr ₹ 40.00 ₹ 7,200.00
    E0006 Wednesday, June 6, 2001 SUPRIYA KUMARI CRM 140/Hr ₹ 48.00 ₹ 6,720.00
    E0007 Saturday, July 7, 2001 KOMAL KUMARI CRM 145/Hr ₹ 55.00 ₹ 7,975.00
    E0008 Wednesday, August 8, 2001 SONU KUMAR CRM 255/Hr ₹ 50.00 ₹ 12,750.00

    TOTAL PAY HOURS 1555


    SALES BILL& COMMISSION
    CUST-ID CUST-NAME BILL DATE SALES-BILL
    CST001 M/S ANINDITA DAS 6/15/2020 ₹ 525,000.00
    CST002 M/S GANESH BHANDAR 7/11/2020 ₹ 430,000.00
    CST003 M/S PRIYO BROTHER 8/12/2020 ₹ 780,000.00
    CST004 M/S DHILLON CO 9/10/2020 ₹ 610,000.00
    CST005 M/S FANTASY CREATION 10/10/2020 ₹ 485,000.00
    CST006 M/S MICHEL CORNER 11/11/2020 ₹ 756,000.00
    CST007 M/S SURENDRA ENTERPRISES 12/12/2020 ₹ 290,000.00
    CST008 M/S SINHA BROTHERS 11/13/2020 ₹ 628,000.00
    CST009 M/S GAGAN TRADERS 9/2/2020 ₹ 318,000.00
    CST010 M/SULTAN CO 8/3/2020 ₹ 460,000.00
    CST011
    TOTAL SALES BILL MAXIMUM SALES BILL MINIMUM SALES BILL 2ND HIGHESTSALES
    BILL

    10 ₹ 780,000.00 ₹ 290,000.00 756000

    Number Integer Round Round up


    54.87 54 55 55
    123.887 123 124 124
    34.7 34 35 35
    25.8765 25 26 26
    CREDIT DAYS DUE-DATES
    15/DAY 6/30/2020
    30/DAY 8/10/2020
    07/DAY 8/19/2020
    15/DAY 9/25/2020
    15/DAY 10/25/2020
    30/DAY 12/11/2020
    15/DAY 12/27/2020
    15/DAY 11/28/2020
    30/DAY 10/2/2020
    30/DAY 9/2/2020
    12/30/1899
    3RD LOWEST SALES BILL AVERAGE SALES BILL

    430000 ₹ 528,200.00

    Round Down SQRT Rank


    54 7.40742870367309 2
    123 11.1304537194132 1
    34 5.89067059000926 3
    25 5.08689492716333 4

    You might also like