YTD (Jan-June 2016 vs. Jan-June 2015)
129
125
YTD Days
Global Breakout
Revenue
$13,644,073
2016
Revenue/Day
$105,768
PY2015
Revenue/Day
$96,976
% Total
100%
Domestic
INTL
$12,085,137
$1,558,936
$93,683
$12,085
$85,181
$11,795
89%
11%
Customer Rank
Acquire
Expand
Retain
Serve
Non-Coded
2016
PY2015
Revenue
Revenue/Day Revenue/Day % Total
$1,312,868
$10,177
$6,427
10%
$7,634,424
$59,182
$57,566
56%
$3,026,592
$23,462
$21,759
22%
$1,666,355
$12,917
$11,225
12%
$3,834
$30
$(0)
0%
Customer Class
Commercial
INTL
Municipal
Reseller - Other
Industrial Labs
Government
Resell - Industrial Hygiene
Education
Other
2016
PY2015
Revenue/Day Revenue/Day
Revenue
$7,195,592
$55,780
$50,772
$1,535,905
$11,906
$11,700
$1,634,643
$12,672
$12,034
$1,386,876
$10,751
$9,785
$900,409
$6,980
$6,373
$425,018
$3,295
$2,669
$336,569
$2,609
$2,419
$154,662
$1,199
$1,031
$74,399
$577
$194
% Total
53%
11%
12%
10%
7%
3%
2%
1%
1%
Top Customers
ABC Corp
Fish Limited
Delta Appliance
ALPS Company
Here4U
XYZ Inc
Expert Engineers
Check Gmbh
Francios and Sons
Euro Ltd
Marketing Accounts
2016
PY2015
Revenue
Revenue/Day Revenue/Day
$601,368
$4,662
$4,208
$480,717
$3,726
$2,889
$424,678
$3,292
$3,478
$398,347
$3,088
$2,877
$269,038
$2,086
$1,568
$208,819
$1,619
$1,362
$207,066
$1,605
$1,561
$201,704
$1,564
$1,023
$186,532
$1,446
$960
$177,660
$1,377
$1,215
$2,759,521
$21,392
$20,029
% Total
4%
4%
3%
3%
2%
2%
2%
1%
1%
1%
20%
n-June 2015)
QTD (Apr, May, Jun 2016 vs Apr, M
GPSales - Avg/Day Avg/Day
9.1%
8.3%
PM
59%
V$
V%
60%
50%
$8,501.78
$290.10
10.0%
2.5%
PM
58%
58%
58%
61%
V$
$3,750.74
$1,615.50
$1,703.45
$1,692.46
$29.73
PM
61%
50%
62%
62%
59%
60%
32%
59%
V$
$5,008.13
$206.30
$638.02
$965.93
$607.13
$625.70
$190.52
$167.51
$382.63
V%
9.9%
1.8%
5.3%
9.9%
9.5%
23.4%
7.9%
16.2%
197.1%
GPSales - Avg/Day Avg/Day
9.9%
9.2%
1.8%
2.3%
5.3%
3.9%
9.9%
5.8%
9.5%
9.2%
23.4%
23.1%
7.9%
6.9%
16.2%
5.1%
197.1%
Customer Class
Commercial
INTL
Municipal
Reseller
Industrial Labs
Government
Resell - Industrial Hygiene
Education
Other
PM
64%
66%
53%
61%
59%
29%
52%
49%
49%
54%
63%
V$
$453.49
$837.05
$(185.91)
$210.65
$517.81
$256.85
$44.19
$540.96
$485.84
$162.40
$1,362.33
V%
10.8%
29.0%
-5.3%
7.3%
33.0%
18.9%
2.8%
52.9%
50.6%
13.4%
6.8%
GPSales - Avg/Day Avg/Day
10.8%
11.1%
29.0%
25.2%
-5.3%
1.8%
7.3%
12.4%
33.0%
37.6%
18.9%
5.6%
2.8%
-3.6%
52.9%
32.8%
50.6%
72.1%
13.4%
3.0%
6.8%
6.0%
Top Customers
ABC Corp
Fish Limited
Delta Appliance
ALPS Company
Here4U
XYZ Inc
Expert Engineers
Check Gmbh
Francios and Sons
Euro Ltd
Marketing Accounts
10.0%
2.5%
8.9%
3.1%
GPV%
Sales - Avg/Day Avg/Day
58.4%
58.4%
50.1%
2.8%
2.8%
2.0%
7.8%
7.8%
7.5%
15.1%
15.1%
16.3%
-371611.6%
Global Breakout
Domestic
INTL
Customer Rank
Acquire
Expand
Retain
Serve
Non-Coded
QTD (Apr, May, Jun 2016 vs Apr, May, Jun 2015)
MTD (June 2016 vs. Ju
Revenue
$7,024,096
% Total
100%
PM
58%
Sales
8.3%
GP
6.5%
Global Breakout
$6,145,978
$878,119
87%
13%
60%
48%
8.0%
11.1%
6.6%
5.7%
Domestic
INTL
Revenue
% Total
$654,170
9%
$4,017,070 57%
$1,505,103 21%
$843,966 12%
$3,787
0%
PM
58%
58%
59%
60%
Sales
50.8%
3.0%
10.4%
7.4%
GP
42.7%
0.6%
10.3%
8.0%
Customer Rank
Acquire
Expand
Retain
Serve
Non-Coded
Revenue
% Total
$3,719,525 53%
$868,634
12%
$814,624 12%
$721,253 10%
$464,827
7%
$183,030
3%
$140,804
2%
$84,981
1%
$26,418
0%
PM
61%
48%
63%
61%
58%
58%
32%
61%
Sales
8.5%
10.9%
1.7%
10.9%
14.2%
14.2%
-8.4%
2.1%
GP
6.8%
5.2%
1.7%
6.8%
12.8%
12.8%
-14.2%
-3.8%
Customer Class
Commercial
INTL
Municipal
Reseller - Other
Industrial Labs
Government
Resell - Industrial Hygiene
Education
Other
Revenue
% Total
$332,350
5%
$239,460
3%
$230,032
3%
$226,766
3%
$119,433
2%
$117,490
2%
$104,936
1%
$100,171
1%
$96,755
1%
$75,156
1%
$1,381,927 20%
PM
63%
67%
53%
61%
59%
11%
52%
48%
50%
55%
63%
Sales
7.2%
18.1%
-21.0%
8.8%
31.9%
213.1%
22.1%
2835.2%
-7.0%
19.1%
8.9%
GP
4.2%
16.3%
14.7%
12.3%
28.0%
16.8%
8.6%
3186.6%
-16.9%
19.1%
6.3%
Top Customers
ABC Corp
Fish Limited
Delta Appliance
ALPS Company
Here4U
XYZ Inc
Expert Engineers
Check Gmbh
Francios and Sons
Euro Ltd
Marketing Accounts
MTD (June 2016 vs. June 2015)
Revenue
$2,257,102
% Total
100%
PM
56%
Sales
11.2%
GP
6.1%
$1,930,466
$326,636
86%
14%
58%
42%
4.2%
83.4%
2.3%
52.4%
Net Sales
% Total
$219,791 10%
$1,282,340 57%
$477,879 21%
$273,533 12%
$3,559
0%
PM
56%
55%
57%
57%
Sales
54.3%
8.1%
18.0%
18.0%
GP
40.2%
0.5%
17.3%
17.3%
Net Sales
% Total
$1,130,973 50%
$323,990
14%
$263,030 12%
$266,066 12%
$135,694
6%
$50,261
2%
$43,642
2%
$35,846
2%
$7,600
0%
PM
60%
51%
60%
57%
59%
61%
29%
60%
Sales
1.0%
83.2%
12.3%
26.4%
-7.4%
30.9%
-39.7%
25.6%
GP
-1.0%
50.8%
3.4%
14.9%
2.6%
33.8%
-50.1%
14.4%
Net Sales
% Total
$87,955
4%
$76,813
3%
$75,000
3%
$60,179
3%
$56,444
3%
$51,610
2%
$35,156
2%
$31,740
1%
$29,154
1%
$28,452
1%
$447,025 20%
PM
62%
66%
-1%
59%
52%
56%
57%
45%
54%
58%
56%
Sales
-2.6%
6.4%
5258.2%
-10.7%
100.0%
-23.0%
-8.2%
-7.1%
3.7%
126.6%
6.4%
GP
-10.9%
1.3%
-164.1%
-10.4%
-0.5%
-11.3%
-27.9%
5.0%
119.5%
6.8%
YTD
QTD
MTD
Year to Date
Quarter to Date
Month to Date
YTD Days
number of selling days in the current year (or comparable year, depending on location in header)
Days Adj
Domestic
INTL
PM
V$
V%
GP
Days Adjusted---in finance, each month may have a different number of reporting/selling days based on how
measured. Some companies use a 5 week, 4 week, 4 week quarter to standardize the reporting/selling days
means that when comparing different years you are comparing the same number of days.
United States
International or ROW (Rest of World)
Prior Month
Growth in dollars
Growth percent
Gross Profit
Customer
Rank
Customer
Class
Classification schema for determining selling activities. Acquire-gain new customers, Expand-grow within cus
Classification
schemaservice
by industry
or area.
Commercial-US/domestic.
Used when not
classifed by industry ty
customer, Serve-get
business
in addition
to product sales, non-coded--not
coded
international customers. Municipal-self-explanatory. Reseller-other--resellers of your products to other end
classifed ( i.e. Reseller-Industrial hygiene). Industrial labs, Governement, Education--specific classifications.
when not a company cannot be classified in one of the previous categories.
on location in header)
porting/selling days based on how a quarter is
dardize the reporting/selling days. Days adjusted
umber of days.
ustomers, Expand-grow within customer, Retain-keep
when
classifed by industry type. INTLd--notnot
coded
lers of your products to other end users except where
ducation--specific classifications. Other--catch all
Researching Marketing Questions
Grading Guide
MKT/571 Version 9
Marketing
Copyright
Copyright © 2016 by University of Phoenix. All rights reserved.
University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries.
Researching Marketing Questions
Grading Guide
MKT/571 Version 9
Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All
other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended
to imply endorsement, sponsorship, or affiliation.
Edited in accordance with University of Phoenix® editorial standards and practices.
2
Researching Marketing Questions
Grading Guide
MKT/571 Version 9
Individual Assignment: Researching Marketing Questions
Purpose of Assignment
This assignment is designed to help students analyze and interpret primary and/or secondary data and
research. First, students will be provided with a marketing report that allows for preparing basic executive level
data insights. Second, they will be allowed to pick a company and product or service. This assignment will help
prepare students for the development of their marketing plan. Students will be creating a marketing plan (refer
to Marketing Plan and Outline document) so they may want to choose a company and product or service that
has data readily available or where they can use demographic/psychographic data to provide insights.
Resources Required
Week 1 Business Growth Overview
Grading Guide
Content
Student analyzes the dataset and provides insight
and commentary in the form of a memorandum.
Student’s analysis includes major areas of increase
and decrease in revenue or type and/or category of
business.
Student’s analysis includes trends that are evident in
terms of revenue or type and/or category of
business.
Student’s analysis includes insights that would help
formulate marketing strategies to either continue
growth or reverse decline.
Student’s analysis includes additional analysis you
(as SVP) would like (and why) to build a marketing
goal and strategy or strategies.
The memorandum is a minimum of 525 words in
length.
Student selects a global or multi-regional (does
business in more than one country) company and
one of its products or services that will serve as the
basis for your marketing plan.
Students prepares a summary document and sends
it to the instructor that includes but is not limited to:
• Name of Company
Met
Partially
Met
Not Met
Comments:
3
Researching Marketing Questions
Grading Guide
MKT/571 Version 9
Content
•
•
•
•
Met
Partially
Met
Not Met
Total
Available
Total
Earned
4
#/4
Comments:
Location of Company Headquarters
Name of Product or Service selected
General description of company (number of
employees, revenue, type of ownership, web
page, etc.)
General description of product or service.
The summary document is a minimum 175 words in
length.
Writing Guidelines
Met
Partially
Met
Not Met
Total
Available
Total
Earned
2
#/2
6
#/6
The paper—including tables and graphs,
headings, title page, and reference page—is
consistent with APA formatting guidelines and
meets course-level requirements.
Intellectual property is recognized with in-text
citations and a reference page.
Paragraph and sentence transitions are
present, logical, and maintain the flow
throughout the paper.
Sentences are complete, clear, and concise.
Rules of grammar and usage are followed
including spelling and punctuation.
Assignment Total
Additional comments:
#
Comments:
4
Purchase answer to see full
attachment