Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

INFO10514 | Using Business Information Systems | W2021 Project. Part2 1 Group Project Part 2 Data Analysis & Visualization (Jan XXXXXXXXXX) Overview There are no doubts that ITs are the...

1 answer below »
INFO10514 | Using Business Information Systems | W2021
Project. Part2 1
Group Project Part 2
Data Analysis &
Visualization (Jan XXXXXXXXXX)
Overview
There are no doubts that ITs are the key factors in business and industry development. Companies are
always looking for more intelligent solutions for their businesses in order to improve their processes and
achieve superior results. When companies adopt Business Analytics tools, they are taking advantage of
solutions to their business problems, by transforming data into knowledge for decision making.
Usually Business Analytics includes “decision management, content analytics, planning and forecasting,
discovery and exploration, business intelligence, predictive analytics, data and content management,
stream computing, data warehousing, information integration and governance”.
Data Analytics and Data Visualization are two very powerful tools widely used to provide decision-makers
with measurable, relevant, easy to understand input. It’s well known that Analytics Methods are used at
all stages of information processing, but their real application efficiency depends upon an architecture of
company’s Information System (IS), since it establishes the foundation for flexibility and interoperability
of all available methods provided by IS to analysts and management.
Objective
Teamwork in Excel Data Analysis of provided information to demonstrate your professional
skills in finding some insights from the data sets, visualize these results in a clear and effective
manner and make professional practical recommendations.
Format of Deliverables
Deliverable Format File Name Comments
Deliverables MS WORD XXX_Analytics_Text Explanations, conclusion & recommendations
MS Excel XXX_Analytics_Data Data spreadsheets, charts, etc
Important: XXX – this is a code for your group number, assigned by professor. For example, XXX=001.
Value & Due Date
The Project Part2 is evaluated out of 20 marks. See the Ru
ic section of this document for an outline of
how this part of the Project will be graded.
Your results should be submitted into the SLATE Assignment Dropbox according to a deadline. Please be
advised that your report will be automatically reviewed by TURNITIN, the anti-plagiarism software
application. Be sure that your work is your own!
Forming Groups
This is a group project (4-5 students). As working in groups is one of the course learning outcomes, no
projects submitted by individuals will be graded.
You may use the same group as in Project Part 1 or find new people to work with.
Groups (teams) must be registered with your instructors before the end of Week 8. Each group must
designate a group leader to send the full names and students’ ID of its members to professor. This includes
groups that have not changed from Project Part 1. Your instructor will send you the data set you will be
working on by return message. No project will be marked from a group that is not registered with its
instructor.
INFO10514 | Using Business Information Systems | W2021
Project. Part2 2
The Assignment
Data Analytics
You will be provided the data source with many attributes and variables.
1. You should provide THREE (3) insights based on your data sets. You will be looking fo
elationships between attributes in the data set that can help you understand the company’s
products, customers, sales and or any other aspects.
2. You are expected to demonstrate your ability to use the following functions appropriately: Sorting,
Filtering, Subtotals, IF, CountIF, AverageIF, Pivot Tables and others.
3. Your analysis may not support using all the listed functions. However, your team will be marked
on the sophistication of the analysis and the appropriateness of the tools being used.
4. You and your team are expected to create some professional chart(s) for each insight to
communicate the results of your analysis. The charts should help to interpret our results and
conclusions.
5. For each insight, the report of your data analysis will include:
a. A statement about what you are trying to discover.
. Tables summarizing the results from your analysis.
c. Charts/diagrams/plots you are using to visualise the data with appropriate headings and
formatting.
d. Screen shots from the Excel will be acceptable if it is clearly labelled and concise.
e. A
ief description of what you have discovered and how the decision making people can use
this information to add value to their business.
6. The report first page must have an information that includes the students’ full names and thei
IDs, team number XXX and the submission date.
INFO10514 | Using Business Information Systems | W2021
Project. Part2 3
Evaluation Criteria, Ru
ics
This is a guide to help you achieve the expectations for the Project Part2.
Marks Sections Comments
Data Analysis and Visualization
Max 10 o At least THREE analyses are undertaken.
o For at least two of the insights, two (or more) variables are used
o The techniques and functions are used co
ectly
o Demonstrated the professional usage of Excel basic functions such as IF,
CountIF, SumIF or AverageIF, Grouping with Subtotals and Pivot Tables
o The interpretation of the results is co
ect
Excel Charts
Max 5 o Appropriate to the data being visualized
o Labelled so that the visualization is understandable
o Formatting reflects the course lessons on creating professional charts that
tell a clear story about the data
Conclusion & Recommendations
Max 5 o The Findings are relevant to the business
o The Findings show your insights
o Report shows how findings can be implemented to add value to the
Business
Elements of Style & General Professionalism
• All elements of spelling, grammar and punctuation are co
ectly applied.
• Headings are used appropriately to organize the flow of ideas.
• Length of submission is within the acceptable range
• Marks are subtracted for failure to achieve these outcomes
Max 20 Total: _____ /20
    Group Project Part 2 (13%)
    Data Analysis & Visualization
    (Jan XXXXXXXXXX)
    Overview
    Format of Deliverables
    Value & Due Date
    Forming Groups
    The Assignment
    Evaluation Criteria, Ru
ics

SalesOrderDataSet
    SalesOrderID    OnlineOrder    SalesOrderDetailID    ProductName    ProductNumber    DaysToManufacture    OrderQuantity    UnitPrice    UnitPriceDiscount    $UnitPriceDiscount    LineTotal    OrderDate    DueDate    ShipDate    PurchaseOrderNumber    AccountNumber    CustomerID    Te
itoryID    ShipMethod    City    StateProvinceA
eviation    StateProvinceName    PostalCode    Country    Ca
ierTrackingNumber    CreditCardID    CreditCardType    CreditCardNumber    OrderSubTotal    OrderTax    OrderFreight    OrderTotalPaymentDue
    53606    0    50100    LL Mountain Seat/Saddle    SE-M236    1    2    16.272    0    0    32.544    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50101    Long-Sleeve Logo Jersey, XL    LJ-0192-X    0    3    29.994    0    0    89.982    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50102    Long-Sleeve Logo Jersey, L    LJ-0192-L    0    11    28.9942    0.02     XXXXXXXXXX     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50103    Mountain-400-W Silver,40    BK-M38S-40    4    4    461.694    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50104    Hydration Pack - 70 oz.    HY XXXXXXXXXX    0    4    32.994    0    0    131.976    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50105    ML Mountain Frame-W - Silver,42    FR-M63S-42    1    3    218.454    0    0    655.362    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50106    Hitch Rack - 4-Bike    RA-H123    0    6    72    0    0    432    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50107    Mountain-200 Black,38    BK-M68B-38    4    2     XXXXXXXXXX    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50108    Sport-100 Helmet, Black    HL-U509    0    8    20.994    0    0    167.952    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50109    HL Mountain Seat/Saddle    SE-M940    1    3    31.584    0    0    94.752    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50110    Women's Mountain Shorts, M    SH-W890-M    0    2    41.994    0    0    83.988    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50111    AWC Logo Cap    CA-1098    0    4    5.394    0    0    21.576    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50112    Sport-100 Helmet, Red    HL-U509-R    0    6    20.994    0    0    125.964    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50113    Mountain-200 Silver,42    BK-M68S-42    4    4     XXXXXXXXXX    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50114    Short-Sleeve Classic Jersey, L    SJ-0194-L    0    6    32.394    0    0    194.364    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50115    Mountain-200 Black,46    BK-M68B-46    4    2     XXXXXXXXXX    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50116    Half-Finger Gloves, M    GL-H102-M    0    6    14.694    0    0    88.164    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50117    LL Mountain Frame - Black,42    FR-M21B-42    1    1    149.874    0    0    149.874    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50118    Mountain-400-W Silver,42    BK-M38S-42    4    4    461.694    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50119    Mountain-500 Black,48    BK-M18B-48    4    2    323.994    0    0    647.988    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50120    HL Mountain Handlebars    HB-M918    1    3    72.162    0    0    216.486    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50121    Mountain-500 Silver,40    BK-M18S-40    4    1    338.994    0    0    338.994    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50122    Classic Vest, S    VE-C304-S    0    8    38.1    0    0    304.8    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50123    ML Mountain Frame-W - Silver,40    FR-M63S-40    1    6    218.454    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50124    Long-Sleeve Logo Jersey, M    LJ-0192-M    0    1    29.994    0    0    29.994    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50125    HL Mountain Pedal    PD-M562    1    3    48.594    0    0    145.782    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50126    Women's Mountain Shorts, S    SH-W890-S    0    16    38.4945    0.05     XXXXXXXXXX     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50127    Mountain-400-W Silver,38    BK-M38S-38    4    4    461.694    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50128    Mountain-500 Silver,44    BK-M18S-44    4    6    338.994    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50129    Short-Sleeve Classic Jersey, S    SJ-0194-S    0    6    32.394    0    0    194.364    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50130    Mountain-400-W Silver,46    BK-M38S-46    4    4    461.694    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50131    Mountain-500 Silver,48    BK-M18S-48    4    5    338.994    0    0    1694.97    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50132    LL Mountain Frame - Black,48    FR-M21B-48    1    1    149.874    0    0    149.874    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50133    HL Mountain Frame - Silver,38    FR-M94S-38    2    4    818.7    0    0    3274.8    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50134    Mountain-500 Black,44    BK-M18B-44    4    2    323.994    0    0    647.988    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50135    Mountain-200 Silver,38    BK-M68S-38    4    4     XXXXXXXXXX    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50136    Mountain-200 Black,42    BK-M68B-42    4    2     XXXXXXXXXX    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50137    LL Mountain Frame - Silver,40    FR-M21S-40    2    2    158.43    0    0    316.86    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50138    Women's Mountain Shorts, L    SH-W890-L    0    14    40.5942    0.02     XXXXXXXXXX     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50139    LL Mountain Frame - Black,44    FR-M21B-44    1    4    149.874    0    0    599.496    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50140    Classic Vest, M    VE-C304-M    0    9    38.1    0    0    342.9    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50141    Mountain-500 Silver,52    BK-M18S-52    4    4    338.994    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50142    LL Mountain Frame - Silver,44    FR-M21S-44    1    2    158.43    0    0    316.86    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50143    Short-Sleeve Classic Jersey, XL    SJ-0194-X    0    7    32.394    0    0    226.758    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50144    Mountain-500 Silver,42    BK-M18S-42    4    4    338.994    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50145    Bike Wash - Dissolver    CL-9009    0    4    4.77    0    0    19.08    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50146    LL Mountain Frame - Silver,42    FR-M21S-42    1    2    158.43    0    0    316.86    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50147    Water Bottle - 30 oz.    WB-H098    0    7    2.994    0    0    20.958    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50148    Half-Finger Gloves, S    GL-H102-S    0    3    14.694    0    0    44.082    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50149    Sport-100 Helmet, Blue    HL-U509-B    0    4    20.994    0    0    83.976    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50150    ML Mountain Handlebars    HB-M763    1    1    37.152    0    0    37.152    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53606    0    50151    LL Mountain Frame - Silver,52    FR-M21S-52    1    1    158.43    0    0    158.43    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    61    4    CARGO TRANSPORT 5    Fullerton    CA     California    92831    US    6A19-463C-B7    10623    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50152    Bike Wash - Dissolver    CL-9009    0    1    4.77    0    0    4.77    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50153    LL Road Frame - Black,52    FR-R38B-52    1    2    202.332    0    0    404.664    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50154    Road-750 Black,48    BK-R19B-48    4    5    323.994    0    0    1619.97    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50155    Racing Socks, L    SO-R809-L    0    14    5.2142    0.02     XXXXXXXXXX     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50156    LL Road Pedal    PD-R347    1    3    24.294    0    0    72.882    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50157    ML Road Frame-W - Yellow,44    FR-R72Y-44    1    3    356.898    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50158    Road-350-W Yellow,48    BK-R79Y-48    4    6     XXXXXXXXXX    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50159    ML Road Pedal    PD-R563    1    1    37.254    0    0    37.254    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50160    Short-Sleeve Classic Jersey, S    SJ-0194-S    0    2    32.394    0    0    64.788    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50161    Road-350-W Yellow,40    BK-R79Y-40    4    5     XXXXXXXXXX    0    0    5102.97    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50162    Half-Finger Gloves, M    GL-H102-M    0    3    14.694    0    0    44.082    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50163    Racing Socks, M    SO-R809-M    0    8    5.394    0    0    43.152    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50164    Road-750 Black,52    BK-R19B-52    4    2    323.994    0    0    647.988    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53607    0    50165    Long-Sleeve Logo Jersey, M    LJ-0192-M    0    2    29.994    0    0    59.988    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    5    4    CARGO TRANSPORT 5    Fremont    CA     California    94536    US    329F-491C-8E    17324    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    53608    0    50166    HL Mountain Seat/Saddle    SE-M940    1    2    31.584    0    0    63.168    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50167    ML Mountain Handlebars    HB-M763    1    2    37.152    0    0    74.304    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50168    Classic Vest, S    VE-C304-S    0    4    38.1    0    0    152.4    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50169    Hydration Pack - 70 oz.    HY XXXXXXXXXX    0    1    32.994    0    0    32.994    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50170    Short-Sleeve Classic Jersey, L    SJ-0194-L    0    2    32.394    0    0    64.788    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50171    Women's Mountain Shorts, L    SH-W890-L    0    12    40.5942    0.02     XXXXXXXXXX     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50172    Classic Vest, M    VE-C304-M    0    5    38.1    0    0    190.5    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50173    Hitch Rack - 4-Bike    RA-H123    0    3    72    0    0    216    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50174    AWC Logo Cap    CA-1098    0    4    5.394    0    0    21.576    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50175    Sport-100 Helmet, Red    HL-U509-R    0    4    20.994    0    0    83.976    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50176    Short-Sleeve Classic Jersey, XL    SJ-0194-X    0    8    32.394    0    0    259.152    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50177    Long-Sleeve Logo Jersey, L    LJ-0192-L    0    2    29.994    0    0    59.988    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50178    HL Mountain Pedal    PD-M562    1    1    48.594    0    0    48.594    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50179    Bike Wash - Dissolver    CL-9009    0    5    4.77    0    0    23.85    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50180    Sport-100 Helmet, Blue    HL-U509-B    0    2    20.994    0    0    41.988    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50181    Water Bottle - 30 oz.    WB-H098    0    4    2.994    0    0    11.976    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53608    0    50182    Sport-100 Helmet, Black    HL-U509    0    5    20.994    0    0    104.97    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    E075-4B48-BE    6291    ColonialVoice     XXXXXXXXXX    2091.01     XXXXXXXXXX    52.2753     XXXXXXXXXX
    53609    0    50183    Men's Bib-Shorts, M    SB-M891-M    0    2    58.4935    0    0    116.987    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50184    AWC Logo Cap    CA-1098    0    3    5.394    0    0    16.182    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50185    Women's Tights, L    TG-W091-L    0    2    48.7435    0    0    97.487    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50186    Long-Sleeve Logo Jersey, L    LJ-0192-L    0    1    29.994    0    0    29.994    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50187    ML Mountain Handlebars    HB-M763    1    1    37.152    0    0    37.152    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50188    ML Mountain Rear Wheel    RW-M762    1    4     XXXXXXXXXX    0    0    698.634    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50189    Full-Finger Gloves, S    GL-F110-S    0    2    24.6935    0    0    49.387    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50190    Sport-100 Helmet, Black    HL-U509    0    2    20.994    0    0    41.988    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50191    Sport-100 Helmet, Blue    HL-U509-B    0    1    20.994    0    0    20.994    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50192    Women's Tights, S    TG-W091-S    0    5    48.7435    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50193    Mountain-200 Black,38    BK-M68B-38    4    1     XXXXXXXXXX    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50194    Full-Finger Gloves, M    GL-F110-M    0    4    24.6935    0    0    98.774    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53609    0    50195    ML Mountain Frame - Black,48    FR-M63B-48    1    1     XXXXXXXXXX    0    0     XXXXXXXXXX    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    14    8    CARGO TRANSPORT 5    Frankfurt am Main    SL     Saarland    60075    DE    72A5-411A-9C    6291    ColonialVoice     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    79.7184     XXXXXXXXXX
    53610    0    50196    HL Touring Frame - Blue,60    FR-T98U-60    1    1    602.346    0    0    602.346    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    113    4    CARGO TRANSPORT 5    Fontana    CA     California    92335    US    A496-4DE7-A2    5666    Distinguish     XXXXXXXXXX     XXXXXXXXXX    79.1699    24.7406     XXXXXXXXXX
    53610    0    50197    LL Touring Frame - Yellow,50    FR-T67Y-50    1    1    200.052    0    0    200.052    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    113    4    CARGO TRANSPORT 5    Fontana    CA     California    92335    US    A496-4DE7-A2    5666    Distinguish     XXXXXXXXXX     XXXXXXXXXX    79.1699    24.7406     XXXXXXXXXX
    53611    0    50198    ML Mountain Frame-W - Silver,40    FR-M63S-40    1    2    218.454    0    0    436.908    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    695    3    CARGO TRANSPORT 5    Kansas City    MO     Missouri    64106    US    700F-4823-BC    2270    Vista     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    52.3042     XXXXXXXXXX
    53611    0    50199    Women's Mountain Shorts, S    SH-W890-S    0    4    41.994    0    0    167.976    1-Sep-03    13-Sep-03    8-Sep-03    PO XXXXXXXXXX     XXXXXXXXXX    695    3    CARGO TRANSPORT 5    Kansas City    MO     Missouri    64106    US    700F-4823-BC    2270    Vista     XXXXXXXXXX     XXXXXXXXXX    167
Answered Same Day Apr 01, 2023

Solution

Amar Kumar answered on Apr 02 2023
34 Votes
Insight 1: Sales by Country and Product Line
Statement: We are trying to discover which product lines are the most popular in each country based on sales.
Table: The PivotTable we created shows the total sales by country and product line. Here is a sample of the data:
Chart: Based on the PivotTable data, we created a clustered column chart to visualize the sales by country and product line.
Description: From the PivotTable and chart, we can see that:
· In Australia, the top-selling product lines are Distinguish and SuperiorCard.
· In Canada, the top-selling product lines are ColonialVoice and Distinguish.
· In Germany, the top-selling product lines are Vista and ColonialVoice.
· In France, the top-selling product line is ColonialVoice.
· In the UK, the top-selling product line is ColonialVoice.
· In the USA, the...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here