Homework answers / question archive / New Perspectives Excel 2019 | Excel Module 10 SAM Textbook project    Cup and Platter          Author     Date     Purpose    To retrieve short-term and long-term financial data for select group of Cup and Platter products from a variety of data sources Cup and Platter         Data Sources                  Support_EX_10_History

New Perspectives Excel 2019 | Excel Module 10 SAM Textbook project    Cup and Platter          Author     Date     Purpose    To retrieve short-term and long-term financial data for select group of Cup and Platter products from a variety of data sources Cup and Platter         Data Sources                  Support_EX_10_History

MS Excel

Share With

New Perspectives Excel 2019 | Excel Module 10 SAM Textbook project 

Cup and Platter    
    
Author    
Date    
Purpose    To retrieve short-term and long-term financial data for select group of Cup and Platter products from a variety of data sources

Cup and Platter        
Data Sources        
        
Support_EX_10_History.csv        
Field    Data Type    Notes
Year    integer    Calendar year from 1999 to 2021
Business Year    integer    Year of Cup and Platter business operation, starting with Year 1
Revenue ($mil)    decimal    Annual revenue in millions of dollars
Units Sold    integer    Annual units sold of all items
Notes    text    Descriptive information about the year's events
        
Support_EX_10_TwoYear.csv        
Field    Data Type    Notes
Date    date    Date range from 1/1/2020 to 12/31/2021
Daily Revenue    integer    Sales revenue collected daily at Cup and Platter
        
Support_EX_10_Data.accdb        
Customers Table        
Field    Data Type    Notes
Cust ID    text    Customer ID number
City    text    Customer's city of residence
State    text    Customer's state of residence (all customers are from the United States)
Postal Code    text    Customer's postal code
        
Orders Table        
Field    Data Type    Notes
Order ID    text    Order ID number
Order Date    date    Date on which the order was placed
Store ID    text    Store ID number
Cust ID    text    Customer ID number
Items    integer    Quantity of items in the order
Cost    currency    Cost of the quantity of items ordered
Tax    currency    Sales tax on the items ordered
Shipping    currency    Shipping charge for items ordered, if necessary
Total Charge    currency    Total chart to the customer for the items ordered
        
Product Orders Table        
Field    Data Type    Notes
Order ID    text    Order ID number
Product ID    text    Product ID number
Quantity    integer    Quantity of the product ordered
Revenue    currency    Revenue generated from the ordered products
        
Products Table        
Field    Data Type    Notes
Product ID    text    Product ID number
Category    text    General product category
Subcategory    text    Subcategory of the product category
Description    text    Short summary description of the product
        
Stores Table        
Field    Data Type    Notes
Store ID    text    Store ID number
Type    list    Type of store (Website or Brick-and-Mortar)
Store Name    list    Name of store (Website, Brooklyn, Philadelphia, Washington DC, Chicago, Indianapolis)
Address    text    Web address or street address of store
City    text    City location of the brick store
State    text    State location of the brick store
Postal Code    text    Postal code of the brick store
Phone    text    Phone number of the brick store
Manager    text    Website manager or store manager
Established    integer    Year in which the store was established