Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    APAT06 Day 3

    Uploaded by

    bavanthinil
    The document contains data from various surveys and reports including favorite cheeses in the UK, roller coaster details from amusement parks, hair salon client information, weekly chocolate consumption, printer cartridge sales commissions, catalog order inquiries from December. It contains various data points, tables and summaries.

    Copyright:

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

    APAT06 Day 3

    Uploaded by

    bavanthinil
    6 views20 pages
    The document contains data from various surveys and reports including favorite cheeses in the UK, roller coaster details from amusement parks, hair salon client information, weekly chocolate consumption, printer cartridge sales commissions, catalog order inquiries from December. It contains various data points, tables and summaries.

    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 data from various surveys and reports including favorite cheeses in the UK, roller coaster details from amusement parks, hair salon client information, weekly chocolate consumption, printer cartridge sales commissions, catalog order inquiries from December. It contains various data points, tables and summaries.

    Copyright:

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

    APAT06 Day 3

    Uploaded by

    bavanthinil
    The document contains data from various surveys and reports including favorite cheeses in the UK, roller coaster details from amusement parks, hair salon client information, weekly chocolate consumption, printer cartridge sales commissions, catalog order inquiries from December. It contains various data points, tables and summaries.

    Copyright:

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

    Favourite Cheeses Data

    Cheese Type Number of People


    Brie 9
    Cheddar 23
    Cheshire 7
    Dairylea 9
    Lancashire 8
    Other 7
    Red Leicester 14
    Stilton 11
    Wensleydale 12
    UK CHEESE SURVEY

    12; 12% 9; 9%
    11; 11%
    23; 23%

    14; 14%
    7; 7%
    7; 7% 9; 9%
    8; 8%
    Roller Coaster Amusement Park Type Design Status
    Rage Adventure Island Steel Sit Down Operating
    Air Alton Towers Steel Flying Operating
    Nemesis Alton Towers Steel Inverted Operating
    Oblivion Alton Towers Steel Sit Down Operating
    Rita - Queen of Speed Alton Towers Steel Sit Down Operating
    Corkscrew Alton Towers Steel Sit Down Operating
    Magic Mouse Brean Leisure Park Steel Sit Down Operating
    Opened Speed ( mph )
    2007 43.5
    2002 46.6
    1994 50
    1998 68
    2005 61.1
    1980 40
    2007 29.1
    Fifty Shades Hair Design Clients

    Customer ID Surname Initial Age Category Natural Hair Colour

    FS-783A172 Smith V 45-60 Blonde


    Eye Colour Usual Treatment First Visit Date

    Blue Balayage 11/16/2017


    Weekly Chocolate Consumption

    Quantity Price Each Total Vat Total Final


    Flake 1 0.36 0.36 0.063 0.423
    Crunchine 3 0.2 0.6 0.105 0.705
    Mars Bar 2 0.42 0.84 0.147 0.987
    Aero 6 0.39 2.34 0.4095 2.7495
    Total Consumed 12 4.14 0.7245 4.8645
    Printer Cartridge Reps Commission for This Month

    Commission Commission
    Sales Rep Sales This month Rate 15.00%
    Emily £ 25,000.00 £ 3,750.00
    Rob £ 19,000.00 £ 2,850.00
    Michael £ 27,500.00 £ 4,125.00
    Francine £ 14,000.00 £ 2,100.00
    Mircea £ 33,300.00 £ 4,995.00
    Helene £ 41,800.00 £ 6,270.00
    Bridget £ 17,300.00 £ 2,595.00
    Paolo £ 23,800.00 £ 3,570.00
    Total £ 201,700.00 £ 30,255.00
    Catalog Order Enquires- December

    Call ID Date Type of Call Description

    z12866 1/3/2020 Product enquiry Is item waterproof


    z16620 1/5/2020 Stores enquiry Opening hours enquiry
    z44569 12/2/2020 Delivery enquiry Not arrived
    z11234 12/2/2020 Delivery enquiry Not arrived
    Order disappeared from basket after
    adding extra 4th item and then
    z11235 12/2/2020 Website problem deleting it
    z11580 12/2/2020 Customer Complaint Item missing
    z11970 12/3/2020 Customer Complaint Wrong size sent
    z12865 12/3/2020 Delivery enquiry Not arrived
    z12901 12/4/2020 Customer Complaint Wrong colour sent
    z14110 12/4/2020 Payment enquiry Double payment taken
    z14233 12/5/2020 Stores enquiry Opening hours enquiry
    z14356 12/5/2020 Website problem Website down
    z16770 12/5/2020 Website problem Website down
    z44867 12/6/2020 Customer Complaint Sent wrong size
    z77483 12/6/2020 Delivery enquiry Query re expected delivery date
    Can't choose any sizes apart from 8
    z44281 12/7/2020 Website problem on the website
    z89135 12/7/2020 Payment enquiry Payment blocked
    z22190 12/8/2020 Payment enquiry Money not taken from account
    z44282 12/8/2020 Customer Complaint Goods damaged
    Sent wrong colour - has already
    z89134 12/11/2020 Customer Complaint ordered the replacement item
    z56435 12/11/2020 Product enquiry Does item have pockets
    z22191 12/11/2020 Stores enquiry London store details
    Action Taken

    None needed
    None needed
    Phone customer services
    Phone customer services

    Details sent to website team


    Phone customer services
    Returns label emailed
    Details sent to accounts team
    Returns label emailed
    Details sent to accounts team
    None needed
    Details sent to website team
    Details sent to website team
    Returns label emailed
    None needed

    Details sent to website team


    Details sent to accounts team
    Details sent to accounts team
    Returns label emailed

    Returns label emailed


    None needed
    None needed

    You might also like